DataEngBytes 2023 - MEL-T1-06 - Lizzie Macneill
summary
A live map server built on Postgres + PostGIS loads NSW open-data EV chargers, converts coordinates with ST_Transform, and serves them as GeoJSON to a Leaflet front end; a bounding-polygon query and ST_Within -> 13 stations within 60 km identify reachable chargers, ST_Distance ranks nearest ones, and pgRouting (osm2pgrouting + indexes) computes driving paths with pgRouting (Dijkstra) -> GeoJSON route that is rendered on-screen (demo has a brief connection hiccup but the route displays).
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:26Building map server open source
- 3:33PostGIS and open mapping data
- 5:39Tile server stack setup
- 7:25Displaying spatial data
- 9:53Converting coordinates to spatial
- 11:57Finding nearby charging stations
- 13:21Calculating distances to stations
- 14:46Introducing PG Routing
- 16:56Optimal routes with Dijkstra
- 19:05Customizing routing layers
- 20:30PostGIS integration support
- 22:37Advantages of open source spatial
- 23:45Live demo routing map server
related talks
27mDataEngBytes 2023 - PER-T1-03 - 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
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
23mLocation Insights for Your Graphs with Neo4j, PostGIS, and Brickgraph
26mMaps with Django with Paolo Melchiorre
51mTime to graph up with Spring Data Neo4j