[postgis-users] identifing duplicate line features (with different draw directions0

[Basques, Bob (CI-StPaul)]

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 at gmail.com<mailto:tom.van.tilburg at 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 at ci.stpaul.mn.us<mailto:bob.basques at 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 at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at 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




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170524/23387a85/attachment.html>