[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] identifing duplicate line features (with different draw directions0
From: "Basques, Bob (CI-StPaul)" <bob.basques () ci ! stpaul ! mn ! us>
Date: 2017-05-24 13:49:44
Message-ID: ACF53A96-9CAB-4295-AD1A-22DC63E8CE5A () ci ! stpaul ! mn ! us
[Download RAW message or body]
[Attachment #2 (text/plain)]
Tom,
Ok, that's one I've never used before. Sounds like it's the right thing too.
Thanks
bobb
On May 24, 2017, at 2:43 AM, Tom van Tilburg \
<tom.van.tilburg@gmail.com<mailto:tom.van.tilburg@gmail.com>> wrote:
Yes, this should be done with the ST_Equals function: \
http://postgis.net/docs/ST_Equals.html From the docs: "Returns true if the given \
geometries represent the same geometry. Directionality is ignored."
Best,
Tom
On Fri, May 19, 2017 at 7:55 PM, Basques, Bob (CI-StPaul) \
<bob.basques@ci.stpaul.mn.us<mailto:bob.basques@ci.stpaul.mn.us>> wrote: I'm trying \
to remove all duplicated parcel edges from an exploded parcel dataset. I have a set \
of 2 point line segments and I've been able to find the geom duplicates ok witha \
window partition, but the number was really low. Upon examining the data more \
closely, I figured out that the majoirty of the duplicates are indeed the same line, \
but the end points are swapped around, so they appear in the window as different \
feature.
Anyone have a SQL chunk/function that I should look at to get to this matching of \
spatial location?
Thanks
bobb
"Be nice to people on your way up because you meet them on your way down."
- Jimmy Durante
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
"A doctor can bury his mistakes but an architect can only advise his clients to plant \
vines."
- Frank Lloyd Wright
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space;" class=""> Tom,
<div class=""><br class="">
</div>
<div class="">Ok, that's one I've never used before. Sounds like it's the right \
thing too.</div> <div class=""><br class="">
</div>
<div class="">Thanks</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On May 24, 2017, at 2:43 AM, Tom van Tilburg <<a \
href="mailto:tom.van.tilburg@gmail.com" class="">tom.van.tilburg@gmail.com</a>> \
wrote:</div> <br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Yes, this should be done with the ST_Equals function: <a \
href="http://postgis.net/docs/ST_Equals.html" \
class="">http://postgis.net/docs/ST_Equals.html</a> <div class="">From the docs: \
"<span style="color:rgb(46,46,46);font-family:"Lucida \
Grande",Verdana,Geneva,Arial,Helvetica,sans-serif;font-size:13.3333px" \
class="">Returns true if the given geometries represent the same geometry. \
Directionality is ignored."</span></div> <div class=""><span \
style="color:rgb(46,46,46);font-family:"Lucida \
Grande",Verdana,Geneva,Arial,Helvetica,sans-serif;font-size:13.3333px" \
class=""><br class=""> </span></div>
<div class=""><span style="color:rgb(46,46,46);font-family:"Lucida \
Grande",Verdana,Geneva,Arial,Helvetica,sans-serif;font-size:13.3333px" \
class="">Best, </span></div> <div class=""><span \
style="color:rgb(46,46,46);font-family:"Lucida \
Grande",Verdana,Geneva,Arial,Helvetica,sans-serif;font-size:13.3333px" \
class=""> Tom</span></div> </div>
<div class="gmail_extra"><br class="">
<div class="gmail_quote">On Fri, May 19, 2017 at 7:55 PM, Basques, Bob (CI-StPaul)
<span dir="ltr" class=""><<a href="mailto:bob.basques@ci.stpaul.mn.us" \
target="_blank" class="">bob.basques@ci.stpaul.mn.us</a>></span> wrote:<br \
class=""> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"> <div style="word-wrap:break-word" class="">I'm trying \
to remove all duplicated parcel edges from an exploded parcel dataset. I have a \
set of 2 point line segments and I've been able to find the geom duplicates ok witha \
window partition, but the number was really low. Upon examining the data more \
closely, I figured out that the majoirty of the duplicates are indeed the same line, \
but the end points are swapped around, so they appear in the window as different \
feature. <div class=""><br class="">
</div>
<div class="">Anyone have a SQL chunk/function that I should look at to get to this \
matching of spatial location? </div> <div class=""><br class="">
</div>
<div class="">Thanks</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">
<div style="font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; \
font-variant-ligatures: normal; font-variant-caps: normal; font-variant-east-asian: \
normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; \
text-align: start; text-indent: 0px; text-transform: none; white-space: normal; \
word-spacing: 0px;" class=""> <br \
class="m_-5359812668341210610Apple-interchange-newline"> <br class="">
</div>
<div style="font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; \
font-variant-ligatures: normal; font-variant-caps: normal; font-variant-east-asian: \
normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; \
text-align: start; text-indent: 0px; text-transform: none; white-space: normal; \
word-spacing: 0px;" class=""> <dt class="">"Be nice to people on your way up \
because you meet them on your way down."<span \
class="m_-5359812668341210610Apple-converted-space"> </span></dt><dd class="">- \
Jimmy Durante <div class=""><br class="">
</div>
</dd></div>
<br class="m_-5359812668341210610Apple-interchange-newline">
</div>
<br class="">
</div>
</div>
<br class="">
______________________________<wbr class="">_________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" \
class="">postgis-users@lists.osgeo.org</a><br class=""> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank" class="">https://lists.osgeo.org/<wbr \
class="">mailman/listinfo/postgis-users</a><br class=""> </blockquote>
</div>
<br class="">
</div>
_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" \
class="">postgis-users@lists.osgeo.org</a><br class=""> \
https://lists.osgeo.org/mailman/listinfo/postgis-users</div> </blockquote>
</div>
<br class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; \
font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: \
normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; \
white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: \
0px;" class=""> <br class="Apple-interchange-newline">
<br class="">
</div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; \
font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: \
normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; \
white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: \
0px;" class=""> <dt class="">"A doctor can bury his mistakes but an architect \
can only advise his clients to plant vines."<span \
class="Apple-converted-space"> </span></dt><dd class="">- Frank Lloyd \
Wright<span class="Apple-converted-space"> </span> <div class=""><br class="">
</div>
</dd></div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; \
font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: \
normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; \
white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: \
0px;" class=""> <br class="">
</div>
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
</body>
</html>
[Attachment #4 (unknown)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic