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

Tom van Tilburg tom.van.tilburg at gmail.com
Wed May 24 00:43:09 PDT 2017

Yes, this should be done with the ST_Equals function:
>From the docs: "Returns true if the given geometries represent the same
geometry. Directionality is ignored."


On Fri, May 19, 2017 at 7:55 PM, Basques, Bob (CI-StPaul) <
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
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170524/fb19853a/attachment.html>

More information about the postgis-users mailing list