sql - Select duplicates based on Geometry Column -


i have encountered bit of tough problem. need select duplicates in sql spatial table based on geometry (some has been copy , pasting out realising pasting same geometry on , over).

i need select duplicates except lowest id geometry same.

you can join table , check stequals function.

select tbl1.objectid, tbl2.objectid your_table tbl1 join yout_table tbl2 on tbl1.your_geometry_field.stequals(tbl2.your_geometry_field) = 1 order tbl1.objectid 

one downside duplicate pairs following:

101 110 101 210 110 101 110 210 210 101 210 110 

Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -