<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>