Getting Down To Earth: Geospatial Analysis With Rails
summary
Sets up Rails with PostGIS + Postgres and Ruby gems RGeo and rgeo-shapefile, loads 50,000 points from Perk logs, stores coordinates as SRID 3785 (Google Mercator), and shows why projecting to Mercator keeps map-rectangle queries simple. Implements heat maps with thermo.js heatmap and explains when to pre-render raster tiles. Builds a timezone service using polygon shape files, uses ST_Contains then a ST_Buffer/ST_Intersects rewrite to avoid full table scans, and speeds queries by 4:1 polygon subdivision and proper spatial indexes.
AI-written summary · about
chapters (6)
- 0:00Geospatial analysis with Rails
- 4:39Rails geospatial setup
- 7:53Visualizing location data
- 19:07Time zones from location
- 31:46Optimizing spatial queries
- 38:23Recap and resources
related talks
53mSpatial Programming for the Rubyist
19mThe Power of GeoDjango
30mGeospatial analysis made easy with PostGIS and Geoalchemy
02h 18mTutorial
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS
24mAdding Geo into your Django
45mBreakout Session
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home