Index of Posts

BigQuery Geospatial 101

• Migrating Geospatial Data to BigQuery

Functions

How to build new or enhance existing geospatial functions

• ST_Subdivide
• ST_Simplify extras
• ST_Intersection_Agg
• ST_Multi
• Any Postgres function
• ST_Transform

Performance

• Performance tips
• Spatial join performance check
• Spatial join rewrite
• Spatial predicate choice
• Split query to reduce its cost
• How to GROUP BY <Geography>

Tutorials and query examples

• Hurricanes
• Load and analyze Fitbit data
• Load, clean and visualize pets data
• Spatial statistics remapping
• Recreating spatial hierarchy
• Zip code neighbors

Technical details

• Empty and full geos
• Planar vs geodesic edges —conversion, long lines, bounding boxes