Joining building objects with building addresses - Latest

Buildings Product Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > Property Features
Product
Buildings
Version
Latest
ft:locale
en-US
Product name
Buildings
ft:title
Buildings Product Guide
Copyright
2025
First publish date
2018
ft:lastEdition
2025-03-21
ft:lastPublication
2025-03-21T10:32:30.871000

A building can be associated with more than one address, creating a parent-child relationship between the building and addresses. To accurately reflect these relationships, Buildings includes both an objects table, which holds boundary geometry and basic attribution, such as county FIPS and elevation information, as well as 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 a building object.

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

join [buildings.bldgid] to [buildings_addresses.bldgid]

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