Re: query question really cant give a summary here so read the body ;-)
| От | Rhys Stewart |
|---|---|
| Тема | Re: query question really cant give a summary here so read the body ;-) |
| Дата | |
| Msg-id | 189966030804251025w3959d1dbhb09c1933b08266ce@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: query question really cant give a summary here so read the body ;-) (Colin Wetherbee <cww@denterprises.org>) |
| Список | pgsql-general |
Yes, PostGIS LINESTRINGS, no not ST_AsEWKT(). By similar configuration I mean shape. So I can identify two lines if they have a similar shape. No not ST_Distance()....and don't call me Shirley.
I also neglected to include the query in my previous post.
SELECT a.id,b.id FROM subsumed_secondary a
INNER JOIN subsumed_secondary b ON a.geom && b.geom AND a.id <> b.id
WHERE dev.line_descriptor_2(simplify(a.geom,1.5)) = dev.line_descriptor_2(simplify(b.geom,1.5))
I also neglected to include the query in my previous post.
SELECT a.id,b.id FROM subsumed_secondary a
INNER JOIN subsumed_secondary b ON a.geom && b.geom AND a.id <> b.id
WHERE dev.line_descriptor_2(simplify(a.geom,1.5)) = dev.line_descriptor_2(simplify(b.geom,1.5))
On Fri, Apr 25, 2008 at 12:07 PM, Colin Wetherbee <cww@denterprises.org> wrote:
Rhys Stewart wrote:PostGIS LINESTRINGs?The example I provided earlier was a very simplified model of the table I'm working with after a self join. The table in question contains geographic data (linestrings)
Like ST_AsEWKT()?
> and I have written a function to return atextual representationSurely, you don't mean ST_Distance()?
> so that I can easily identify lines with similarconfiguration. I want to now select lines that are in close proximity to each other and have the same configuration. So this requires a self join (afaik). So, short of a function like the one that was posited earlier, is there a method using just plain old sql to get the results I desire?
What do you mean by "similar configuration"?
Colin
В списке pgsql-general по дате отправления: