DataEngBytes 2023 - BRI-T1-11 - Lizzie MacNeill
summary
Builds a self‑hosted EV charging map by importing OpenStreetMap with osm2pgsql into PostGIS, converting lat/long to geometry, and serving GeoJSON to a Leaflet layer via renderd/Apache. Uses PostGIS spatial predicates like ST_Within and ST_Distance to list stations within a given range (example: 60 km) and returns metadata about connector types. Constructs a pgRouting topology and runs Dijkstra to produce a route (183 segments in the demo) computed in under a second; mentions ETL and geocoding with PL/Python and warns pgRouting can struggle at global scale.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:47Build own map server
- 3:34PostGIS and open source mapping
- 5:22Open source stack setup
- 7:09Live demo: self-sufficient map server
- 8:32Loading spatial charging station data
- 12:26Nearest charging stations with PostGIS
- 14:16Routing with PG Routing and Dijkstra
- 20:37PostGIS advantages and features
- 22:43Q&A
related talks
25mDataEngBytes 2023 - MEL-T1-06 - Lizzie Macneill
27mDataEngBytes 2023 - PER-T1-03 - Lizzie Macneill
26mBUILD YOUR OWN ELECTRIC VEHICLE CHARGING MAP WITH PostGIS
46mGetting Down To Earth: Geospatial Analysis With Rails
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
23mLocation Insights for Your Graphs with Neo4j, PostGIS, and Brickgraph
01h 41mOpenStreetWhat? Mapping The World With Open Data