Skip to content

Instantly share code, notes, and snippets.

@mbforr

mbforr/union_spatial.sql

Created July 29, 2021 17:12
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save mbforr/18e060b4bb8f75b073ba451b9a8de9c8 to your computer and use it in GitHub Desktop.
Save mbforr/18e060b4bb8f75b073ba451b9a8de9c8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
union_spatial.sql
SELECT
st_union_agg(county_geom) AS geom,
state_fips_code
FROM
`bigquery-public-data.geo_us_boundaries.counties`
GROUP BY
state_fips_code
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment