eet
2")
Since the inner join part is trivial, I figured I'd just ask about creating
the sets of records that would be fed to it
Thanks,
Andrew
From: Milo van der Linden
To: PostGIS Users Discussion
Sent: Monday, December 15, 2008 10:24:50 AM
Subject: Re: [p
streets that I specify, I'll use python to capture a pair of street names and
generate the query dynamically.
Thanks again,
Andrew
From: "Obe, Regina"
To: PostGIS Users Discussion
Sent: Monday, December 15, 2008 8:58:30 AM
Subject: RE:
Hello Andrew,
Can you give some more detail on the why part of this question? Why
would you want to find all the elements that connect to elements that
connect to an intersection? This sounds like you are either:
- Trying to do routing and prepare the network for that (in that case;
check to s
Andrew,
Not sure I understand your question. Are you saying your street segments are
cut such that they only connect at junctions. Kind of like tiger tlids.
And given each intersection, you are trying to find continguous segments from
the intersection?
e.g.
---
Stop thinking lines and start thinking endpoints. If you convert your
lines into a set of start/end points then group on x/y you'll end up
an aggregation which defines your sets of road intersections.
If you want until Monday, I bet Kevin or Regina will drop full SQL
into your lap. I'm too lazy (
