2011

Table Of Contents

Using Joins for Calculated Fields

You can create a calculated field that uses native data and joined data. For

example, if you join assessor data to parcel data, you can create a field that

represents the cost per acre for each parcel. You create a calculated field using

an expression.

Non-matching Data

When you create a join, you can specify how to deal with features in the

primary table that do not find a match in the secondary table. For example,

if you are joining assessor data to a parcel layer, you can decide what to do

with parcels that have no assessment data. The choices are as follows:

■ Keep All Records On The Left – Keeps all features, even if there is no match

in the secondary table (a left outer join).

■ Keep Only Left-Side Records With A Match – Hides features if there is no

matching record in the secondary table (an inner join).

Tell me more

Video

■ Show me how to join attribute data to

features.

Procedure

■ Create a join. (page 512)

Tutorial

■ Lesson 2: Analyze Data With External

Information Using Joins

Workflow

■ Join Attribute Data to a Geospatial

Feature

GIS Skill

■ Join attribute data to features