2009/10/14 Randall, Eric <[email protected]>: > Hi all, > > I'm currently finding nearest crossing-streets by procedurally walking > upstream and downstream > of any given centerline segment, looking at endpoints/startpoints and vice > versa until a different street name occurs. > Is there a better way to do this? Thanks!
you could build a table contaiing all the linkages, by first looking for co-incident endpoints for all lines in the database. then use this table to more quickly find the street crossings for specific streets. > > Eric > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
