How to use Geospatial Data in SQL Server
summary
Shows how to store and query spatial types in SQL Server 2016/2017, demonstrating geometry vs geography with SRID choices and why SRID 4326 matters for correct distances. Builds geoJSON from spatial columns inside the database, uses ST_Distance and buffers to run radius and polygon searches (demo finds 5 parks within 5 miles, 18 within 15), and constructs hurricane buffers and a 50-mile line buffer that matches 152 ZIP code polygons. Uses SSMS spatial results and in-database parsing of WKT/GeoJSON; examples run and return expected, usable maps.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:06Agenda and expectations
- 3:53Geospatial data and uses
- 6:19Geometry vs geography types
- 11:39SRID importance
- 14:27Geospatial objects in SQL Server
- 17:18Demo of geospatial data in SQL Server Management Studio
- 20:33Geospatial formats
- 23:24Spatial functions
- 28:41Calculating distances
- 31:27Locations within radius
- 38:30Demo: hurricane impact tracking
- 43:09Summary
related talks
45mBreakout Session
53mSpatial Programming for the Rubyist
19mThe Power of GeoDjango
26mBuilding Geospatial GraphQL APIs By Leveraging GraphQL Database Integrations
46mGetting Down To Earth: Geospatial Analysis With Rails
53mThis Is PostGIS
35mMySQL 5.7, 8.0 and MongoDB: Geospatial Introduction
45mUnderstanding geospatial data with duckdb