PostGIS: Calculate multiple distances between set of points and vector grid

[المشرف العام]

My set contains the following input data: A set of points and a hexagonal (vector) grid.

For each cell in the grid, I want to calculate the driving-distance to each point. I thought this would be a nice approach for calculation in a pgRouting enabled PostGIS database. At the end, I'd like to have the information stored in the attribute table of the Grid!

Unfortunately I'm not that much into PostGIS so I'm not sure about how to implement the algorithm correctly. What I did so far:

1. I have a street network that I loaded into PostGIS. I used pgr to create a topology. It seems to work!
   
2. I loaded the grid and the points into PostGIS DB.
   

I kind of understand that I have to merge all this information into one table and then apply the routing algorithm (maybe with a loop?). However I'm heavily unsure about HOW to merge and then implement the algorithm correctly. I already checked out a couple of threads here but they did not seem to help a lot.

Maybe you guys have some suggestions?



أكثر...