Property Graph can be used to join addresses with building structures and building units. The process for doing so is based on the following assumptions:
- Data is loaded into a relational database
- SQL operations are performed on the relational database
- The following products are used –
- Buildings Great Britain
- Property Graph Great Britain
- United Kingdom Address Fabric Data™
Joining building structures
To join address strings from United Kingdom Address Fabric Data™ to building structures from Buildings Great Britain:
- Join building structures from Buildings Great Britain (BLDGID) to the Property Graph Relationship Class 2 secondary key (BLDGID).
- Join the PreciselyID (PBKEY) from United Kingdom Address Fabric Data™ the Property Graph Relationship Class 2 primary key (PBKEY).
- Inherit United Kingdom Address Fabric Data™ fields to building structures.
Joining building units
To join address strings from United Kingdom Address Fabric Data™ to building units from Buildings Great Britain:
- Join building units from Buildings Great Britain (BLDGUID) to the Property Graph Relationship Class 11 secondary key (BLDGUID).
- Join the PreciselyID (PBKEY) from United Kingdom Address Fabric Data™ to the Property Graph Relationship Class 11 primary key (PBKEY).
- Inherit United Kingdom Address Fabric Data™ address fields to building units.