[GIS] Calculating millions of distances with Road Graph

distancepgroutingqgis

I'm new to GIS but thanks to the answers I got in another question here on GIS stack exchange I was able to increase my knowledge significantly. This question is related to an earlier question I asked and got answer, but since this is a new question, I thought better to ask a new question instead of continuing on the older one.

I have about 160,000 addresses (points) and a (vector format) map of roads and 10 city limits (polygon). I want to:

  • Calculate the distance from each of these addresses to the city borders (or possible the city centers – a point – if that is easier).
  • That is, for each city I want 10 distances. I don't just want the possibility to do it one by one – I want the total 1,600,000 distances once and for all!

I was earlier advised to use either Road Graph for QGIS og pgRouting for PostGIS.
I have stated using Road Graph. I was able to import all the data into QGIS, install the Road Graph plugin, and calculate the distance between to points. My question now is:

  • How do I get Road Graph to calculate all the 1,600,000 distances? And can it at all be done with 'Road Graph'?

Thanks

Best Answer

As far as I have understood Road Graph, it is very limited in its functionality. Only A-B routing on screen. No automation of processing.