Index of Posts
Jul 18, 2023
BigQuery Geospatial 101
Functions
How to build new or enhance existing geospatial functions
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