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

[Tom van Tilburg]

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