Property Graph can be used to join addresses with building footprints. 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 Canada
- Property Graph Canada
- Canada Address Fabric Data™
To join address strings from Canada Address Fabric Data™ to building footprints from Buildings Canada:
- Join Buildings Canada (BLDGID) to the Property Graph Relationship Class 2 secondary key (BLDGID).
- Join the PreciselyID (PBKEY) from Canada Address Fabric Data™ or Master Location Data to the Property Graph Relationship Class 2 primary key (PBKEY).
- Inherit Canada Address Fabric Data™ address fields to building objects.