I have three shapefiles:
- roads(lines),
- logistic center(one point feature) and
- places(a lot of point features).
I have tried to calculate route from logistic center to places by ArcMap network analyst, but it was pain and I do not successfully made it.
So I installed PostGIS/Postgresql with pgRouting extension. Now I have those shapefiles imported to dabatabase with SPIT tool from QGIS. In database they are shown as 3 tables. Also I successfully created topology for roads by tutorial found in pgRouting workshop documentation.
For now, I can't find tutorial for my situation, as I want to calculate shortest routes from logistic center to places using roads layer. I can do it by hand, one by one, on QGIS or ArcMap, using their tools, but I have 1500 places, so it would be pain to do it.
My questions:
Is it possible to calculate routes from one point to many with pgRouting (I need only distances for shortest route) using logistic center as source and places as targets?
Is it possible to create a table with information containing target ID and route distance and create a shapefile with geometry?
How to do that?