Exercise 5: Create a calculated property

AutoCAD Map 3D 2009

 
Exercise 5: Create a calculated property
 
 
 

Now that you have joined owner data to the Parcels layer and saved the result to a new data store, you can use the combined information to create a calculated property. The calculated property is the result of an expression: in this case, the last sales price divided by the area.

NoteYou must be connected to the data store that contains the data for the calculation in order to create or manage calculations.
NoteThis exercise uses the map you created and modified in the previous exercises.

To create a calculated property using joined data

  1. At the bottom of the Data Table, click Options, and click Create A Calculation.
  2. In the Create A Calculation dialog box, name the calculated property “ValueByArea.”
  3. Click Properties. Select Assessor| LAST SALES PRICE.

  4. Click the operator for “divided by” (the slash character).
  5. Click Geometric Area2D.

    This option calculates the area of a polygon.

  6. Hold your cursor inside the parentheses, where you see the text “geometry property.” On the tooltip that displays, click Enter A Property.
  7. From the Properties list, select Geom.

    Every spatial feature has a geometry property that you can use to calculate area or length.

  8. Click Validate to make sure the expression is a valid calculation.
  9. When you see “The expression is valid,” click OK to create the calculated property and return to the Data Table.

    Scroll to the right in the Data Table to see the new field. It is gray, to indicate that it is a calculated property and cannot be edited.

  10. Close the Data Table.

Where you are now

You joined information from a Microsoft Access database to a layer containing parcels. You saved the layer out to a new SDF file, making all its data available in the future. You used the new data source to create a calculated property.

To continue this tutorial, go to Lesson 4: Theming Polygon Features.