I am trying to manipulate a large dataset containing a lot of sliver polygons resulting from an overlay operations. (The eliminate tool is very time consuming to generalize them.)
I identified the sliver polygons using:
SELECT * FROM data1 WHERE
[CODE] IN ( SELECT CODE
FROM data1
GROUP BY CODE
HAVING Count ( CODE ) >1)
Now I want to select the slivers with maximum area from the ones isolated through above query.
I need to select each CODE value (from the multiple instances) where the associated shape area is the largest. This will help me eliminate the sliver polygons without having to merge them separately.
Any help is extremely appreciated.
