670 likes | 802 Views
Indiana University Migrating from AutoCAD to a Geodatabase Theresa Thompson ththomp@indiana.edu. 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.
E N D
Indiana UniversityMigrating from AutoCAD to a GeodatabaseTheresa Thompsonththomp@indiana.edu
Total enrollment 2004-05 (7 campuses): 92,070students 15,831faculty and staff 714buildings (7 campuses) 26,525,251gross sq. feetof building space 2,963acres
For the Bloomington campus13 Utility SystemsChilled Water,Condensate, Communications,Electric, Exterior Lighting, Irrigation, Natural Gas, Sewer, Steam, Storm Water, Tunnel, Telephone, WaterBasemap
IUB Physical Plant Utilities Utility Information Group Watchdogs of the Utility Department Documentation, GIS/GPS, Locating, and Metering for the IUB Campus
Utility Information Group Covering Utility Information for the IUB Campus Indiana University
Why move from AutoCAD Mapto a SDE Geodatabase environment? • Ease-of-Use for Editors • Centralized Database/Graphics Environment • Enterprise level data sharing • Easier to bring CAD into ArcGIS than GIS into CAD without conversion
IU GIS system • Windows based ArcGIS 9.1 – editorsWindows ArcReader 9.1 - viewersUnix ArcSDE/Oracle for geodatabaseUnix ArcIMS for web mappingTesting ArcGIS ServerGeodatabase – IU BloomingtonData Layers = over 58 basemapover 100 utilities
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”
Read this! http://downloads.esri.com/support/whitepapers/ao_/CAD_Translation_in_Geoprocessing_1004_J9324.pdf
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
Simple CAD with no data linking but with block attributes 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
Filter out certain CAD blocks Rename field names
“Text_” field = blockname 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
your geodatabase 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.
CAD annotation – use ArcToolbox \ 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.
Once you explode the mtext, save the dwg and preview again in ArcCatalog
Be sure to select the dwg file annotation class for conversion
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