[postgis-users] Finding nearest crossing streets

[Brian Modra]

2009/10/14 Randall, Eric <ERandall at eriecountygov.org>:
> 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
> postgis-users at postgis.refractions.net
> 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/