Lesson 3: Using Joined Data to Create Calculated Properties

AutoCAD Map 3D 2009

 
Lesson 3: Using Joined Data to Create Calculated Properties
 
 
 

You will join the parcel data to an assessor database to add information about the owners and values of the parcels.It does not contain information about the owners. You will join the Parcels layer to a Microsoft Access database that contains owner information.

To connect to an Access database from AutoCAD Map 3D, you must first set up an ODBC connection for that database using a control panel in Windows. Then, connect to this source using Data Connect, just as you connected to the physical data sources in your map. The database source contains a field that you can match to a property in the Parcels layer, so you can join the data to the parcels. Using the combined data, you will create a calculated property that is stored in the map but is not saved back to the original data stores. This property is not available in either original data source alone. It requires a join and a calculation to create it.