Working with geospatial data  |  BigQuery  |  Google Cloud

PHOTO EMBED

Tue Feb 08 2022 21:37:12 GMT+0000 (Coordinated Universal Time)

Saved by @qbui #sql

SELECT
  *,
  ST_GeogPoint(pLongitude, pLatitude) AS p
FROM
  mytable
content_copyCOPY

For example, the following query retrieves longitude, latitude pairs and converts them to geographic points. When you run this query, you specify a new destination table to store the query results:

https://cloud.google.com/bigquery/docs/geospatial-data