BUILD YOUR OWN ELECTRIC VEHICLE CHARGING MAP WITH PostGIS
summary
A live map server is built with PostGIS and pgRouting running on PostgreSQL, importing OpenStreetMap via osm2pgsql and renderd and charging points from the TfNSW CSV transformed into geometry. Spatial queries use ST_DWithin to find stations within 60,000 meters (60 km), GeoJSON outputs feed a Leaflet front end, and pgr_dijkstra returns a route made of 183 edges in under one second. The demo runs on Apache and successfully displays markers and routes.
AI-written summary · about
chapters (11)
- 0:00Building EV charging map
- 1:44Speaker and EDB role
- 3:29Why PostGIS for spatial data
- 5:37Map server setup with PostGIS
- 7:01Live demo of map server
- 8:25Importing EV charging data
- 10:54Displaying charging stations
- 13:22Find stations within range
- 15:07Routing with pgRouting
- 22:51Advanced PostGIS features
- 24:59Summary and open-source
related talks
27mDataEngBytes 2023 - PER-T1-03 - Lizzie Macneill
23mDataEngBytes 2023 - BRI-T1-11 - Lizzie MacNeill
25mDataEngBytes 2023 - MEL-T1-06 - Lizzie Macneill
47mPostGIS and pgRouting: Extensions for spatial data in PostgreSQL
22mMaps with Django (and PostGIS)
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
19mThe Power of GeoDjango