Census Geography

FIPS hierarchy: counties, tracts, block groups, blocks. Linked to properties via census_block_fips.

The census tree is a separate hierarchy from the city/state tree.

It connects to the existing state tree via ref_census_counties.state_fips → ref_states.state_fips.

Properties link to census blocks via properties.census_block_fips → ref_census_blocks.block_fips.

Tables populate on-demand as properties are geocoded — not pre-loaded.

Hierarchy: County (5-digit FIPS) → Tract (11) → Block Group (12) → Block (15).

FIPS codes are nested: each level's code contains its parent's code as a prefix.

Tables: ref_census_counties, ref_census_tracts, ref_census_block_groups, ref_census_blocks.

Key Terms

Glossary of terms used across the platform, linked to properties and each other.

Key terms are client-scoped definitions stored in the key_terms table.

Each term can be linked to one or more properties via key_term_properties.

Terms can also be linked to related terms via related_key_terms.

Editors can create and manage terms; managers can delete them.