I imagine there would be a solution to plotting home address point data in Looker Google maps by using user input text data as the data source. It would likely require some customization, and possibly an intermediary step of geocoding the text input, and perhaps adding some quality of life features such as address suggestions that Google is known for. Overall, the goal would be to identify if whether the point exists within a map layer shape. However, simply plotting the point data would be a milestone achievement that does 90% of that work. I haven't seen any documentation that points me in that direction, so is there anyone willing to share a solution or a least a hint towards the general direction?
I think it would be best to do this in the database, rather than in Looker. There is a Google API for this, but I'm quite sure others exist too. Once the work is done on the database end, you can expose it in Looker or any other tool.
I agree with this approach. I'm thinking of collecting publicly available parcel data as the lookup table, spatially relate these points to their respective geometries as a feature extraction, and then display shapes and points in Looker maps with an address filter to identify the area in which it belongs.