CODEWITHSUNDEEP
google-bigquerygis
ronencozen
ronencozen

Reputation: 2201

BigQuery SQL Geo function that return the coordinates of full address

I wonder if BigQuery has an SQL Geo function that returns the location coordinates based on the full address.

Upvotes: 2

Views: 3995

Answers (1)

ronencozen
ronencozen

Reputation: 2201

Here is the response from BigQuery.

Thanks for feature request!

Geocoding is currently not supported by BigQuery directly, but thanks for request, we'll consider it for future planning.

The typical solution is to do it outside of BigQuery, e.g. in Dataflow job using Google Maps Geocoding API: https://developers.google.com/maps/documentation/geocoding/start or similar third-party APIs.

For some addresses the Open Street Map can be used for geocoding, we host it at bigquery-public-data.geo_openstreetmap.planet_nodes.

Upvotes: 4

Related Questions