Skip to content

Instantly share code, notes, and snippets.

@mshodge

mshodge/BigQuery_GEOGRAPHY_to_STRING_GeoJSON

Last active June 4, 2022 22:13
Show Gist options
  • Save mshodge/0c71ab8eb55b99cee8b580cf89e7d69f to your computer and use it in GitHub Desktop.
Save mshodge/0c71ab8eb55b99cee8b580cf89e7d69f to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery GEOGRAPHY to STRING GeoJSON
Raw
BigQuery_GEOGRAPHY_to_STRING_GeoJSON
SELECT *, REPLACE(CAST(ST_ASGEOJSON(county_geom) AS STRING),' ', '') as g FROM `bigquery-public-data.geo_us_boundaries.counties` counties
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment