Trying to dissolve polygons based on a series of attributes.
758248Feb 22 2011 — edited Feb 24 2011I am trying to dissolve a large table with over 3 million polygons using five attributes. This is proving to be too slow and unreliable in ArcGIS which is very slow and crashes very often performing this operation. As an alternative I am trying to do the same thing the dissolve tool does but using Oracle. Not being very experienced with Oracle Spatial the SDO_AGGR_UNION seemed to do what I wanted, so far what I have come with is the query below:
select TRANSTECH,MAXADDOWN,MAXADUP,HOCONUM,HOCONAME,SDO_AGGR_UNION(
MDSYS.SDOAGGRTYPE(c.shape, 0.005))SHAPE
FROM ADDRESS_EXTRACT_FC_BUFFER_RI c
group by TRANSTECH,MAXADDOWN,MAXADUP,HOCONUM,HOCONAME;
The query produces the expected number of records but takes actually longer than the DISSOLVE tool. Dissolve took 1.04 seconds for 3300 polygons. The query above took 60 minutes.
Can someone suggest a better way to accomplish this. My end goal is to be able to do it on millions of records. In ArcGIS I only seem to be able to dissolve about 500000 features.
Thanks and regards,
Ovidio