So I am working with some pgrouting road network data in postgis2.0/postgresql 9.1. I am interested in routing around certain types of disasters like tornados or such. If a disaster event happens at some spatial coordinate
x1,y1. Then I would generate an isochrone from that point to every other point that is reachable at some cost
c. So basically I am creating a travel buffer around the event. Then I would like to loop through all of the road edges that fall within this isochrone and increase the costs of travel along that road segment. I am trying to figure out how to reconcile the pgrouting part with the postgis part--I have less familiarity with pgrouting.
Would I create a polygon out of the isochrone and then do some sort of
within query to get the included edges, and then run an sql update to increase their costs. An additional consideration is the efficiency of this operation since this type of spatial operation might present a problem for a large number of network edges.