Dissolve features

[Anonymous]

Hi,

We've got ZIP code areas in a feature class in an Oracle database. In ArcGIS Desktop it is possible to create new, larger areas through 'dissolving' features that are adjacent and that have the same value for a specific attribute. We'd like to put al areas with the same first four digits for the ZIP code together to create new, larger areas. Is this possible in AutoCAD Map?

Regards,

Willy

[gluckett]

There is only a Dissolve for classic Topology with DWG Features, not FDO.

But since you are using Oracle Spatial, you are really in luck.  You can do that with a SQL Query.

For example, if you want all the parcels with the same street name (or Zoning for that matter), you can do the following query:

select STNAME as ST,SDO_AGGR_UNION(SDOAGGRTYPE(GEOMETRY, 0.5)) as GEOMETRY from  MAP3D.PARCELS  group by STNAME

You could create a view with this SQL and point Map 3D to that view.  You might have to add this view to the SDO_METADATA:

Note:  If you are using Autodesk's Metadata (i.e. you have all the F_ tables such as F_CLASSDEFINITION) you may want to put this view in a different USER/SCHEMA so that those features appear -  otherwise you will have to manually populate the F_ tables so that AutoCAD Map can see the view.

gordon

[Anonymous]

Thank you very much for your answer. I'll give your solution a try!