Exercise 2: Connect to the Access database
Lesson 2: Analyzing Data With External Information Using Joins
Exercise 4: Use the joined data for calculated fields and styles
AutoCAD Map 3D Tutorials > Tutorial: Analyzing Data Using Styles, Joins, and
Buffers > Lesson 2: Analyzing Data With External Information
Using Joins >
Exercise 3: Join the data from the ODBC source to the layer containing the parcels
After you connect to an external data source, you can join it to a layer in your map using the Data Table (as long as the two data sources share a common property). You can see the results of the join immediately.
NoteThis exercise uses the AnalyzeMap1.dwg map you created
and modified in the previous exercises.
To join the ODBC parcel data to the geospatial parcel layer
- In Display Manager, select the Parcels layer and click Table.
- At
the bottom of the Data Table, click Options,
and click Create a Join.
In the Create A Join dialog box, the Primary Table Initiating The Join entry is automatically displayed.
- For Table (Or Feature Class) To Join To, select the ODBC_1:Fdo:Assessor layer.
- For This
Column From The Left Table, select APN.
The entry for the corresponding Matches This Column From The Right Table is automatically displayed.
- Click OK to display all the data in the Data Table.
- Scroll to the right to see the owner information.
To continue this tutorial, go to Exercise 4: Use the joined data for calculated fields and styles.