Joining building units and building structures - buildings - Latest

Buildings Great Britain Product Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Properties > Property Features
Product
Buildings
Version
Latest
ft:locale
en-US
Product name
Buildings Great Britain
ft:title
Buildings Great Britain Product Guide
Copyright
2025
First publish date
2024
ft:lastEdition
2026-01-05
ft:lastPublication
2026-01-05T11:36:58.742000

Building units and building structures are spatially related entities in the Buildings Great Britain database. Building structures are represented as polygons that show the spatial footprint of buildings. Building units are represented as points, indicating specific units or spaces within a building.

The building_unit and building_structure tables can be joined using the BLDGID field, which is present in both tables. The value of this field in the building_structure table establishes a relational link between each building unit and its corresponding building structure.

Since each building unit can belong to only one building structure, the relationship between building units and building structures is many-to-one, meaning that while many building units can be associated with a single building structure, a building unit cannot be linked to more than one structure.