It's a large ZIP file that includes all the streets within the Seattle area. The shapefile we'll be using is the City of Seattle street network. We'll use it again, so if you don't already have PostGIS installed and you're using macOS with homebrew, you can install it using the terminal with: brew install postgisĭirections on how to install PostGIS on other platforms are found here. That article gave a general overview on how to import shapefiles into PostgreSQL using the command line tool shp2pgsql, which comes with PostGIS. We talked about importing shapefiles into PostgreSQL in Converting and importing shapefiles for Compose PostgreSQL and MongoDB. In the previous article, getting started with pgRouting, we covered everything from adding the extension to Compose PostgreSQL, creating a data set of nodes, connecting them together, then finding the shortest path using the pgRouting routing functions pgr_dijkstra and pgr_ksp. Today, we are going to look at how to upload an Esri shapefile of Seattle streets, layer on a set of locations throughout Seattle, and then find the shortest paths to those points using the street network. We’re going to show you how to plan your travel around Seattle’s museums and sights, building on our introduction to pgRouting. Geofile: Getting Started with pgRouting using Esri Shapefiles pgrouting postgresql geofile Free 30 Day Trial
0 Comments
Leave a Reply. |