Introduction to geospatial analysis for uninitiated SQL Data Engineer

on YouTube ↗32m

" summary

Claim: SQL data engineers can use geospatial types and functions with existing workflows because BigQuery geospatial adds geometry/geography columns, ST_ prefixed spatial ops and visualization in the UI. Implementation detail: it maps coordinates with S2/Hilbert indexing into 64-bit integers for fast spatial range queries. Coverage: about 80% of common analyst functions are implemented. Example: query Census tracts within one mile of Oakland using ST_DWithin/ ST_Distance and render results; performance relies on the spatial index.

AI-written summary · about

" chapters (17)

1. 0:00Introduction
2. 3:21Raster data
3. 5:18Vector data
4. 6:47Road network
5. 8:53Data
6. 9:33Data Description
7. 10:46Polygons
8. 12:41spherical earth
9. 13:15geography type
10. 13:59problems with 2D
11. 15:43geometry
12. 19:00find relationship
13. 20:08census tracks
14. 22:24indices
15. 23:28joints
16. 24:47demo
17. 30:01Hilbert curve

" related talks

• 22mTake your Business to a New GeographyJavier de la Torre · Spatial Data Science Conference 2022 London
• 20mCloud Native Patterns for Geospatial Analytics and AILinda Sheard · Spatial Data Science Conference 2022 London
• 46mGeoSpatially enabling your Big Data Apache clusters with LocationTechRobert Emanuele · Devoxx US 2017
• 18mA Toolbox for Scalable Spatial Data Science in the CloudJuan Luis Ruiz-Tagle Oriol · Spatial Data Science Conference 2022 London
• 14mMosaic: A Framework for Geospatial Analytics at ScaleMilos Colic · Spatial Data Science Conference 2022 London
• 07mSmarter Cities through GeotabChad W. Jennings · Strata Data Conference 2018 - New York, NY
• 06mGoogle BigQuery for enterpriseChad W. Jennings · Strata + Hadoop World 2016 - New York, New York
• 39mWhat Data Engineering Can Learn from Front-end EngineeringPete Hunt · OSA Con 2022