Joining parcel objects and parcel addresses - Latest

Parcel Boundaries Product Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > Property Features
Product
Parcel Boundaries
Version
Latest
Language
English
Product name
Parcel Boundaries
Title
Parcel Boundaries Product Guide
Copyright
2024
First publish date
1996
Last updated
2024-07-31
Published on
2024-07-31T12:04:11.146121

A parcel boundary representing a plot of land can be associated with zero or more addresses. To accurately reflect this real-world scenario, Parcel Boundaries includes both an objects table, which holds parcel boundary geometry and basic attribution such as FIPS codes and TAX_APN, and an address table containing key address information like the PreciselyID and formatted first line address. A JOIN or RELATE operation must be performed to link these tables together in order to assign address information to parcel objects.

The PRCLID field, found in both tables, should be used similar to the following example:

join [PARCEL_OBJECTS.prclid] to [PARCEL_ADDRESSES.prclid]

Refer to your application's help and user guides for specific information about table joins and table relate operations.

Records in the Parcel Addresses table are included only if there is linkage to a property record.