orivero

Alternative to dissolve.

Discussion created by orivero on Feb 22, 2011
Latest reply on Feb 25, 2011 by orivero
I have been trying to dissolve a very large polygon feature class.  This dataset is composed of about 3 million polygons that were generated by buffering points.   All attempts in arcmap have been unsuccesful.

I am trying to see if I can accomplish the same operation in Oracle.  Has anyone in this forum been able to do that?

My basic query I am trying to use now is very slow but it seems to produce the right number of records when I run it on a small dataset but it is slower than actually running the dissolve tool.  It would seem that dissolving directly on the database should be faster but it is not. This is my currect query.

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;


Any help will be greatly appreciated,

Outcomes