Loading in 2 Seconds...
Loading in 2 Seconds...
Indiana University Migrating from AutoCAD to a Geodatabase Theresa Thompson firstname.lastname@example.org. Total enrollment 2004-05 (7 campuses): 92,070 students 15,831 faculty and staff 714 buildings (7 campuses ) 26,525,251 gross sq. feet of building space 2,963 acres.
15,831faculty and staff
714buildings (7 campuses)
26,525,251gross sq. feetof building space
For the Bloomington campus13 Utility SystemsChilled Water,Condensate, Communications,Electric, Exterior Lighting, Irrigation, Natural Gas, Sewer, Steam, Storm Water, Tunnel, Telephone, WaterBasemap
Utility Information Group
Watchdogs of the Utility Department
Documentation, GIS/GPS, Locating, and Metering
for the IUB Campus
Data Preparation for moving from AutoCAD Map to a GeodatabaseDatabase model in placecreate a geodatabase and set up boundary polygon for spatial referencedatanaming/object/relationship standards for featuresdomain tables (lookup tables)Clean your CAD and Attribute data before you convertobjects on correct layers / CAD Standardscorrect blocks / object linkingExpect data problems: there is no “perfect conversion”
Approaches to converting CADCAD with no data linking but with block attributes– use Direct Read CAD file export into geodatabase (via ArcCatalog / ArcToolbox)CAD linked to database/object data – use AutoCAD Map export to shapefiles or coverage, then load into SDE/OracleCAD annotation – use ArcToolbox \ Conversion Tools \To Geodatabase \ Import CAD AnnotationCAD text or blocks linked to polygons – use ArcToolbox\ CAD Translation \ PolygonsfromCADLinesandPoints
Use Direct Read CAD file export into geodatabase (via ArcCatalog)
“The direct read functionality treats the CAD file
as a database of spatial features”
CAD files are rich in attribute data – don’t lose this during conversion
Rename field names
Attribute fields in feature class have new field names
CAD linked to database/object data – use AutoCAD Map export to shapefiles
or coverage, then load into SDE/Oracle
There are currently no ESRI tools out there
to bring in database linked attributes via object
data or link templates in AutoCAD Map
AutoCAD Map 2006 has direct read capability to SDE/Oracle
Make sure your data source is connected and the link templates you need are active
For complex closed polylines you might need to convert to a coverage first, then geodatabase or shapefile
Select both drawing property attributes and link template attributes to migrate over.
AutoCAD dwg property attributes and linked database attributes are now part of the converted feature class.
Create a new personal geodatabase or new feature layers in SDE to import your shapefile data into
Here is another chance to change the field names or decide not to bring in some attribute fields
You can do similar functions several ways...this time you use the Export to Geodatabase command.
Conversion Tools \ to Geodatabase \
Import CAD Annotation
Finally! A great tool for converting AutoCAD
Text into geodatabase annotation.
You need to explode all mtext for conversion. Set up a selection filter for only mtext, then explode this.
You need to determine a reference scale. We use 1:5000 for our campus maps based on units of feet.
This is how the converted CAD annotation looks in the geodatabase annotation feature class
You will be able to edit geodatabase annotation easily in a ArcGIS edit session with Annotation edit tools
– use ArcToolbox\ CAD Translation \
There are several powerful geoprocessing
tools/scripts in the CAD Translation toolbox.
We have filtered out just the parcel number layer to pull as an attribute for the parcel polygons
Parcel polygons now have the enclosed text from the CAD dwg as a parcel attribute
Approaches to exporting from GIS to CADSet up a CAD template .dwg(with preinserted blocks, layers, linetypes)Create geodatabase fields for CAD mapping like LAYER, ROTATION, LINETYPE, CADTYPE, REFNAMEFor conversion to CAD – use ArcToolbox \ Conversion Tools \ Export to Geodatabase \ Export to CAD
Exported from SDE – this CAD file now has mapped blocks and attributes, layers and linetypes automatically from the CAD template file (seed file)
For mapping geodatabase attributes back to CAD you need to make sure you have fields for CADtype = insert
REFNAME = blockname
In an ArcGIS edit session – use the Field Calculator to populate the REFNAME with the correct CAD blockname
Point feature class in SDE is exported to new CAD file and block attributes automatically populated to block inserts.
Note: open up newly created dwg in AutoCAD first, zoom extents and save before viewing in ArcCatalog.