DataEngBytes 2023 - PER-T1-03 - Lizzie Macneill
summary
Live demo builds an electric-vehicle charging map using PostGIS as the single data store, ingests CSV charging points from Transport for NSW, converts coordinates to geometry, exports GeoJSON and serves tiles to Leaflet. Routing uses pgRouting with osm2pgrouting-generated topology and Dijkstra to produce node/edge sequences for turn-by-turn lines, with results GeoJSONified and map-ready. Map answers “how many stations within 60 km” and nearest-by-distance queries, is fully indexed and performant, and the live demo falls back to screenshots when the VPN fails.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:04Building EV charging map
- 3:54OpenStreetMap basics
- 5:19Tile server with PostGIS
- 7:05Importing EV charging data
- 9:34Spatial data to GeoJSON
- 12:00Charging stations within range
- 13:47Nearest charging stations
- 14:07PG Routing introduction
- 17:42Optimal routes with Dijkstra
- 21:35PostGIS features and integrations
- 24:22Summary and Q&A
related talks
25mDataEngBytes 2023 - MEL-T1-06 - Lizzie Macneill
23mDataEngBytes 2023 - BRI-T1-11 - Lizzie MacNeill
26mBUILD YOUR OWN ELECTRIC VEHICLE CHARGING MAP WITH PostGIS
46mGetting Down To Earth: Geospatial Analysis With Rails
15mThe turf wars on data - can be a matter of life and death
23mLocation Insights for Your Graphs with Neo4j, PostGIS, and Brickgraph
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
19mThe Power of GeoDjango