<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="">
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="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="">"Be nice to people on your way up because you meet them on your way down."<span class="Apple-converted-space"> </span></dt><dd class="">- Jimmy Durante
<div class=""><br class="">
</div>
</dd></div>
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
</body>
</html>