[pgrouting-users] Create network with nodes at least every 50m
alaw005 at gmail.com
Sat Aug 23 17:16:00 PDT 2014
I have spent over a week trying to work this out. I have an existing road
network and have used pgr_alphashape to try and get a 400m walking
catchment from bus stops.
But pgr_alphashape snapes to the nearest network node which means
catchments returned are significantly smaller than 400m. I have therefore
tried to create a new network with nodes every 50m using ST_Segmentize but
I can't seem to get it to work.
The function below is my attempt to loop through the existing network and
run ST_Segmentize on each entry to return updated network with additional
nodes but it only returns one record each time rather than a number of
Any advice on how to make this work or alternative approach would be
greately appreciated (especially given that following over a week and
research it seems no one else has had this problem).
DROP FUNCTION hutt_pax.my_test_function();
CREATE OR REPLACE FUNCTION hutt_pax.my_test_function()
RETURNS TABLE (
xgeog geometry) AS
FOR r IN
xid := r.id;
xgeog := ST_Segmentize(
RETURN NEXT; -- return final result
$BODY$ LANGUAGE plpgsql STABLE;
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pgrouting-users