ADA377146
ADA377146
CJ)
c)
c* Integrating CAD Data with Geographic
LIi
Information Systems Using AutoCAD
and ARC/INFO Software
Paul T. Cedfeldt and Mark A. Scott March 2000
a: ii
^ui
N\
~u
o c • Borehole
o 05
X:8.97581 Y:10.6975B dx:8.97581 dy:10.69758 Dist 13.96436
Prepared for
OFFICE OF THE CHIEF OF ENGINEERS
This report was written by Paul T. Cedfeldt, Physical Scientist, Geochemical Science
Division, U.S. Army Cold Regions Research and Engineering Laboratory, Engineer Re-
search and Development Center, and Mark A. Scott of the Environmental Systems Re-
search Institute, Redlands, California.
Funding for this project was provided by the U.S. Army Corps of Engineers Alaska
District.
The contents of this report are not to be used for advertising or promotional purposes.
Citation of brand names does not constitute an official endorsement or approval of the use
of such commercial products.
CONTENTS
Preface ii
Introduction 1
Software overview 1
AutoCAD 1
ARC/INFO 2
Datastorage 2
AutoCAD R14 drawings 2
ARC/INFO 7.2 coverages 2
ARC/INFO coverage features 3
Modeling ARC/INFO features with AutoCAD entities 4
Point features 4
Arc features 5
Polygon features 6
Annotation features 6
AutoCAD symbology data and data organization 6
Layers 7
Colors 7
Line types 7
Line width 7
Problems to avoid 7
Using 3-D data 7
Model space and paper space 7
Details and title blocks 7
Groups 7
Multilines and other entities 8
Hatching 8
External references 8
Dimensions and leaders 8
Blocks as grouped graphics 8
Layer 0 8
Georeferencing and coordinate systems 8
Methodology 8
Layering standards and conventions 8
Color and line type schemes 8
Using text or block inserts as data tags 9
Converting the data: DXFOUT and DXFARC 9
III
Summary and process step example 10
Appendix A: ArcView GIS 3.1 15
Appendix B: ARC/INFO 8.0 17
Abstract 19
ILLUSTRATIONS
Figure
1. CAD and GIS software data storage 3
2. ARC/INFO point feature 3
3. ARC/INFO arc/node features 4
4. ARC/INFO polygon features 5
5. Representing ARC/INFO arc features with AutoCAD entities 6
6. AutoCAD drawing containing water data 11
7. Using the ARC/INFO DXFARC command 12
8. Using the ARC/INFO NEAR command 13
9. ARCPLOT canvas showing converted data 13
10. Flowchart showing conversion from AutoCAD to ARC/INFO 14
TABLES
Table
1. AutoCAD data types and ARC/INFO coverage equivalents 11
IV
Integrating CAD Data with Geographic Information Systems
Using AutoCAD and ARC/INFO Software
INTRODUCTION
This document offers the reader a methodology for objects to AutoCAD objects, and the concepts should
effectively integrating data created using AutoDesk's carry over accurately. For example, layers in AutoCAD
computer-aided design (CAD) software AutoCAD correspond to levels in MicroStation, AutoCAD
(R14) with ESRI's (Environmental Systems Research polylines correspond to linestrings in MicroStation, and
Institute's) ARC/INFO (version 7.2) geographic infor- blocks map to cells.
mation system (GIS) software. Although we intend to
educate CAD and GIS users to ways of facilitating the
SOFTWARE OVERVIEW
creation of data in CAD for use in GIS, it is not within
the scope of this document to consider compatibility CAD and GIS software, while different, are often
issues between every object type in each system. We used in conjunction with one another. The two pack-
do, however, discuss a set of issues that are representa- ages are concerned with three types of data: coordinate
tive of the data integration hurdles faced by many CAD data, descriptive attributes, and graphic symbology.
and GIS users. Traditionally, CAD software stores graphic symbology
At the writing of this paper, AutoCAD 2000 had been and geometric coordinates in the object information in
released but had not yet been tested for this document. the drawing database. The final product is often a
ESRI plans to fully support AutoCAD 2000 in upcom- paper map, so symbology and appearance take prece-
ing versions of its software. ArcView 3.2 is in produc- dence during the data creation process. GIS software,
tion to support AutoCAD 2000 data, and ARC/INFO however, is primarily concerned with the geographic
8.0 is in beta testing. ARC/INFO 8.0, with its coordinates (not to be confused with geometric coordi-
GeoDatabase model, is a new development in ESRI's nates) and descriptive attributes stored in a relational
GIS model. The appendixes and a future revision to database. The GIS database is targeted at providing a
this document will include discussion of Arc View 3.1 continuous digital model, connected to a database of
and ARC/INFO 8.0 in varying levels of detail. attributes, and it is intended for complex query and
CAD and GIS professionals such as engineers, sur- analysis. Symbology is applied map by map, based on
veyors, planners, and cartographers commonly integrate the values in the database.
AutoCAD drawing (.DWG) or drawing interchange
format (.DXF) files, developed internally or by outside AutoCAD
contractors, with ESRI formats such as ArcView AutoCAD is the most widely used PC-based CAD
shapefiles (.SHP) or ARC/INFO coverages. This docu- package on the market. It is primarily used in the
ment assumes that the reader has a professional level design and drafting of models in engineering, architec-
of knowledge of AutoCAD or ARC/INFO or both, but ture, and other disciplines, but it also serves as an
we provide base-level information for the sake of com- excellent generic geometric design tool. An engineer
pleteness. might use AutoCAD to design a site for a new mall,
Although this document is intended for an audience and an architect may use it to design a new building.
of AutoCAD users, MicroStation users can map their Whatever the discipline, the strength of AutoCAD lies
in its ability to allow the user to manipulate graphic tional mode desired. As we will see, this is both a
objects quickly and easily to create a finished hardcopy strength and a weakness when it comes to integrating
product. Traditionally, AutoCAD is concerned with two data. The user can organize data into logical layers and
types of data: each object in an AutoCAD model stores impose a methodology for the symbolization if desired,
its location (geometry) and the characteristics of its but this is not required. Although there is a great deal
appearance (graphics). A line may be drawn in a spe- of control over the geometry of the graphics, there are
cific color or using a specific line style (dashed, dotted, few built-in methods to attach descriptive information
etc.) that conveys information about its use. Further- via a database. This makes AutoCAD an attractive tool
more, AutoCAD uses an organizational approach in its to use for the capture of data because of its powerful
drawing (.DWG) files via a system of layers. These are editing engine. The task now becomes translating that
places where objects can be stored, with the user then work into a format that can be converted easily into
being able to manipulate their display as a group. Lay- ARC/INFO to facilitate advanced GIS data manipula-
ers can be assigned colors, although individual objects tion. The coordinate space upon which an AutoCAD
can have their own color. AutoCAD, being primarily a drawing exists is a double-precision, 3-D system, origi-
graphic system, uses the graphic characteristics of an nating at 0,0, and extending out in all directions.
object to carry information about itself. Primitive meth-
ods exist in AutoCAD to associate data with drawing ARC/INFO 7.2 coverages
entities, such as blocks and object data. One method is As mentioned, ARC/INFO stores data into logical
to simply create text in the drawing that visually units called coverages. A coverage stores a set of vec-
describes an entity but is not rigidly associated with tor-based geographic features, such as roads, soil bound-
the drawing object. Thus, the CAD package uses a aries, zip codes, buildings, city locations, sample wells,
graphic database for symbology and a geometric data- rivers, etc. Coverages are stored in a georelational for-
base for the coordinates of the dimensions of the mat, which means the vector features are associated with
objects. AutoCAD stores true geometry for circles, arcs, a database containing descriptive attributes of the fea-
ellipses, and other types of mathematical curves. tures such as zip code number, soil type, or stream name.
A coverage, taken as a whole, is a directory of files, all
ARC/INFO related together into a model that supports such topo-
ARC/INFO is the most widely used professional GIS logical relationships that may need to be created to sup-
software package. Professionals in many disciplines use port network tracing, polygon overlay, and other spa-
ARC/INFO to analyze relationships among the geo- tial operations. This topology is created by ARC/INFO's
graphic locations of features and the information BUILD and CLEAN commands and generates tables
describing these features. A GIS is a database in the to describe the relationships between coordinates that
fullest sense, relating tables of information that describe define linear features (arc-node topology) and tables
features to point locations, such as monitoring wells; to describe the relationships between linear features that
linear features, such as rivers or roads; and area fea- define closed polygonal areas (polygon-arc topology).
tures, such as county boundaries, parcels of land, or zip These relationships create a seamless, nonredundant
codes. The databases, spatial and attribute, are inter- database that describes the geometry of the geographic
related and can be used to create ad hoc symbology to data. Another key component of a coverage is that it
represent the state of the data, trends in the values, or has a specific coordinate system associated with it,
specific values searched on or queried for. ARC/INFO which can be described by its projection and datum.
stores these data in a series of georelational units called The datum is the ellipsoid upon which the surface of
coverages. The coverages store the coordinates that the earth is approximated, and the projection is the
make up the geometry of the features as well as the mathematical method via which the surface is "flat-
database that describes them. Coverages store this infor- tened" into a Cartesian coordinate mapping space. Fig-
mation as points (single coordinate locations), arcs (lin- ure 1 illustrates data storage concepts for both AutoCAD
ear connected segments), and polygons (closed areas), and ARC/INFO.
and more complex features such as regions.
ARC/INFO coverage features
ARC/INFO is capable of storing data in many simple
DATASTORAGE and complex features. Some examples of complex fea-
AutoCAD R14 drawings ture classes are routes (paths through multiple arcs),
AutoCAD R14 stores its data into files called draw- regions (collections of polygons in potentially overlap-
ings. A drawing can contain any design of graphic ping areas), and raster data sets such as images and grids.
objects that the user wishes to create, in any organiza- We will concern ourselves here with the simple 0-D,
CAD Software GIS Software
Graphic Attribute
Database Database
ARC/INFO Coverage
1-D, and 2-D features of points, arcs, and polygons. in a LAB file that is linked internally to the point
These will then map through the conversion from attribute table (PAT).
AutoCAD points, block inserts, lines, polylines, light-
weight polylines, circles, arcs, and other drawing enti- Arc features
ties. Each ARC/INFO feature is connected to its fea- Arcs represent both linear features and the borders
ture attribute table via an internal ID system. This is of polygon features. Linear features represented by arcs
not a major concern to the AutoCAD user. However, can have length but no area, such as a contour line, or
creating a way to uniquely identify each entity by a can be long narrow features whose width is not appar-
system-dependent identifier might be a concern. For ent at a given map scale, such as a river. Each linear
example, each fire hydrant in a drawing may have some feature may be made up of many arcs. Since arcs also
unique number assigned by the Public Works Depart- form the basic linear infrastructure from which com-
ment. This ID might be placed in the drawing to iden- plex GIS processes are derived, such as tracing and
tify the hydrant. A CAD user might be satisfied to place surface computation, it is very important that an entity
this on the drawing to be plotted out. The GIS would be continuous. An arc is a continuous string of X,Y
need to store this value with the hydrant in the feature coordinate pairs (vertices), beginning at one location
attribute table, so it can join it to other databases in the and ending at another, stored in an ARC file. Geometri-
future. As we will see, there are various methods to cally, an arc is similar to an AutoCAD Polyline entity,
capture this type of information into ARC/INFO. which is often used to create ARC/INFO arc features.
The topological structure is created so that the starting
Point features and ending points are special locations known as nodes.
Points represent geographic features that have no The in-between points are the vertices that define the
area or length, such as sewer manholes, bank locations, arc's shape. This structure is used to trace linear sys-
accident locations, or features that are too small at a tems and to form the boundary of polygon features. This
given scale to be represented by their dimensions. Points means that there should be no break in the continuity
are stored as single X,Y coordinate pairs. In a GIS, of entities drawn in AutoCAD to represent features in
descriptive data are stored in a database, then related to ARC/INFO. If a text entity is used to indicate the
the spatial database that holds the coordinates. As shown diameter of a water line, it should not break the conti-
in Figure 2, the spatial database stores the coordinates nuity of the water line and should be placed above or
□ LAB (Internal
WELL* X-COORD
File)
Y-COORD
1 150.75 209.45
2 254.12 400.2:-
PAT
AREA PERIMETER WELLU WELL-ID
0.00 0.00 1 1
0.00 0.00 2 2
1 2
AAT ▼
FNODEit TNODEU LPOLY» RPOLYit LENGTH PIPE« PIPE-ID
1 2 0 0 10.25 ll^lll^^pjjl
J { 1 L
A
Ml
1 NAT
RECORD ARCH PIPE» PIPE-ID
1 1 1 0
r 2 1 2 0
4 1 2
3
i 1
2
j
ing that can have several shapes. The AutoCAD shape Arc features
entity has its definition stored in a shape font definition AutoCAD line objects are simple two-point objects
file. Either of these can be converted into point fea- that delineate an edge of a 2-D or 3-D entity. These
tures. The AutoCAD block entity can be used to cap- objects translate directly into ARC/INFO arc features.
ture a multitude of data types. A block is a compound The problem from a GIS perspective is that any break
object, defined from a set of other AutoCAD entities. in the line results in a break in the connectivity of the
For example, a fire hydrant symbol could be created feature. Lines that are broken in two, for example, to
from a set of lines, arcs, and polylines, drawn in vari- place a piece of text, can result in difficulty in GIS model
ous colors and on various layers, to look like a fire creation. Several line entities can be strung together to
hydrant. The block is then defined and saved as a tem- form linear boundaries, but they should be snapped so
plate. This block can be placed multiple times in the the end points coincide. A more appropriate AutoCAD
drawing. Each individual instance of the block is called object to use would be the polyline or LWpolyline (light-
an insert. Each block insert can be captured as a point, weight polyline) object. These are multivertex linear
based on the location where it was inserted into the objects that can be used to symbolize a road centerline,
drawing. There are options to create ARC/INFO arc river edge, or any other 2-D object. LWpolylines are
features from the individual geometric parts of the often used when there is no need for 3-D elevations on
block, but these must be valid object types. In addition the vertices, since they take up much less storage in the
to the symbol, a block can contain a set of attributes, AutoCAD database. Each segment of a polyline can
which are items of descriptive text that can accompany contain a bulge factor, making its segment a geometric
the symbol. The block definition contains a set of arc. Again, these entities should be continuous if they
attribute definitions called tags, and each instance of are being prepared as layers to be converted into ARC/
the block (insert) contains the tag attributes. Our hypo- INFO coverage arc features.
thetical hydrant block could have two attributes asso- AutoCAD geometric arcs and circles can be con-
ciated with it: the hydrant ID number and the date of verted to ARC/INFO arc features and will be tessel-
installation. These can be captured as text annotation, lated into segments approximating the curved segment,
but they can also be stored as a point feature. with one segment per degree of arc. The primary entity
used in AutoCAD to digitize linear features is the cates an edge is not necessary, because of the nature of
polyline. An AutoCAD polyline is a multivertex, the coverage model and the CLEAN process.
multisegment, and two-dimensional entity. Three-
dimensional polylines can be created in AutoCAD, but Annotation features
those with vertices at varying Z coordinates should be Text objects are used to indicate additional attributes,
avoided, as the conversion process will ignore them. If such as pipe conditions or installation dates, or simple
the polyline is at a consistent elevation, it can be cap- labels on objects, such as a river name. This text, how-
tured for future use, as we will see. As noted, the light- ever, has no connection to the object, rather it simply
weight polyline, which is a simple, noncurved, 2-D provides a visual aid on the drawing canvas. The text
version of a polyline, may be used. While AutoCAD object represents data that can be captured from the
users often prefer these entities because of their low drawing as ARC/INFO annotation. Each piece of text
overhead, it does not matter for the conversion process, can be captured, along with its size, value, and rotation
and they are treated as a regular polyline. Any further angle, as annotation or as a point feature located at the
reference to an AutoCAD polyline will imply a polyline insertion point of the text. No information concerning
or lightweight polyline object. Note that ARC/INFO the font or AutoCAD text style is needed. While it is
will create nodes at the end points of the line, polyline, useful for the data provider to deliver necessary text
or arc entities when they are converted to ARC/INFO fonts to the ARC/INFO user, it is not crucial to the con-
arc features. Figure 5 illustrates ARC/INFO arc fea- version process because ARC/INFO uses its own set of
tures and corresponding AutoCAD entities. text symbols.
Attributes, as noted in the section on point features
Polygon features above, are textual objects that are part of a compound
As noted previously, an ARC/INFO polygon feature block insert. This text, in addition to being captured as
is created from arc features via the CLEAN command. point data and linked back to the symbol, can be cap-
This being said, information that is intended for con- tured as annotation and treated as such in the GIS data-
version into ARC/INFO arc features, then CLEANed base. These data will follow the same rules and proce-
into polygon features, should be carefully digitized to dures as text.
avoid error. Polylines could be digitized either as closed
(an option when creating the polyline), or open, with
AUTOCAD SYMBOLOGY AND DATA
the start and end points identical. If these methods are
ORGANIZATION
used, closed and snapped polylines will be easily con-
verted into ARC/INFO polygon features. Digitizing AutoCAD organizes its data, stored in file-based
polygons that overlap will result in the creation of mul- drawings, into a series of overlays called layers. In
tiple polygons, as this is not allowed in the polygon addition to layers, the user can utilize methods of sym-
model. This may also lead to undesirable results. If the bolization such as block symbols, color, line type, and
line work is digitized and snapped correctly, CLEAN line width to visually describe the drawing entities.
will create polygons and drop any redundant geometry. Attribute information can be carried along in the form
This means that a closed or open polyline that dupli- of AutoCAD block attributes as well.
Line
Polyline
Arc
10
Table 1. AutoCAD data types and ARC/INFO coverage
equivalents.
Point
Insert (block) Point feature
Attribute
Shape
Line
Polyline Arc feature
Arc Polygon feature (after CLEAN)
Circle
11
Arc: dxfarc
Usage: DXFARC <in_dxf_file> <out_cover> { text_width}
{attrib_width}
Arc: DXFARC WATER.DXF WATER 32 32
Enter layer names and options (type END or $REST when done)
Enter layer names and options (type END or $REST when done)
0 Arcs written.
688 Labels written.
516 Annotations written.
1 Annotation levels.
Arc: BUILD WATERJTAGS POINT
Building points...
Arc: BUILD WATERJTAGS ANNO.DXF
Building annotation...
Arc:
Figure 7. Using the ARC/INFO DXFARC command.
12
Arc: near
Usage: NEAR <in_cover> <near_cover> {LINE POINT I NODE}
{ search_radius}
{ out_cover) { NOLOCATION | LOCATION}
Arc: NEAR WATERJTAGS WATER LINE 1.0 WATERJTAGS2
Identifying features in WATER near those in WATERJTAGS.
/^ARCPLOT HU
Pan/Zoom
13
Digitize data in AutoCAD
on appropriate layers
I
DXFOUT entire drawing
or specific layers
I
DXFARC desired layers
into appropriate features
I
BUILD arc, point,
annotation coverage,
CLEAN polygons
14
APPENDIX A: ARCVIEW GIS 3.1
ArcView stores data in a format called a shapefile (.SHP). The shapefiles are defined, for
our purposes, as point, line, or polygon shapes. There is no text or annotation data type in a
shapefile. Geometry is stored in a .SHP file, a spatial index is built in a .SHX file, and
database attributes associated with the shapes are stored in a dBase file (.DBF). AutoCAD
data can be read directly using the ArcView CAD Reader extension. Conversion is facili-
tated via the Convert To Shapefile option in Arc View. Custom conversion tools can be
written in ArcView with the Avenue programming language. See the ArcView help docu-
ment for object mapping.
ArcView has two additional features that make it useful for the conversion process. First,
any AutoCAD polyline that is closed, or any open polyline whose beginning and ending
points are identical, is interpreted as a polygon shape. Second, attributes of blocks are auto-
matically associated with the block insertion point, which defines a point shape, by
denormalizing the data in the associated table.
A future version of this document will provide more information on using Arc View GIS
and CAD data.
15
APPENDIX B: ARC/INFO 8.0
Arclnfo 8.0 stores data in a GeoDatabase. This GeoDatabase can exist in a standalone
format using a Microsoft Access file (.MDB), or it may be stored in a relational database
management system (RDBMS) such as Oracle or SQL Server to be used in a multiuser
environment. The GeoDatabase stores information in a similar fashion to an ARC/INFO
coverage, but all in one unit. Since the object models of AutoCAD and ARC/INFO are
visible via Visual Basic or any other Microsoft Windows COM-compliant development
environment, creation of custom translators would be very feasible in this powerful envi-
ronment. See the Arclnfo 8.0 help document for object mapping.
A future version of this document will provide additional information on using ARC/
INFO 8.0 and CAD data.
16
Form Approved
REPORT DOCUMENTATION PAGE OMB No. 0704-0188
Public reporting burden for this collection of information is estimated to average 1 hour per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the
data needed, and completing and reviewing this collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing
this burden to Department of Defense, Washington Headquarters Services, Directorate for Information Operations and Reports (0704-0188), 1215 Jefferson Davis Highway, Suite 1204, Arlington, VA 22202-4302.
Respondents should be aware that notwithstanding any other provision of law, no person shall be subject to any penalty for failing to comply with a collection of information if it does not display a currently valid
OMB control number. PLEASE DO NOT RETURN YOUR FORM TO THE ABOVE ADDRESS.
1. REPORT DATE (DD-MM-YY) 2. REPORT TYPE 3. DATES COVERED (From - To)
March 2000 Technical Report
4. TITLE AND SUBTITLE 5a. CONTRACT NUMBER
Anchorage, AK 99506-0898
12. DISTRIBUTION / AVAILABILITY STATEMENT
14. ABSTRACT
Software for computer-aided design (CAD) and geographic information systems (GIS) are often used in conjunction with one another. This
document proposes a methodology for effectively integrating data created using Autodesk's AutoCAD R14, the most widely used CAD
software package, with Environmental System Research Institute's (ESRI's) ARC/INFO 7.2, the most widely used professional GIS soft-
ware package. Abrief discussion of software data models is provided, followed by an enumeration of certain entities that should never be
used to represent AutoCAD data that is going to be converted using ARC/INFO. The document concludes with an example implementation
of the proposed integration methodology.
a. REPORT b. ABSTRACT c. THIS PAGE 19b. TELEPHONE NUMBER (include area code)
u u U u 24