Primary and secondary keys - Latest

Property Graph Product Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Addresses > World Addresses
Product
Property Graph
Version
Latest
Language
English
Product name
Property Graph
Title
Property Graph Product Guide
Copyright
2024
First publish date
2021
Last updated
2024-11-04
Published on
2024-11-04T16:18:17.362992

Precisely's global ID system creates unique and persistent identifiers for each feature. Each feature is represented by a 12-character alphanumeric value. The character in the first position can be used to identify the feature:

Feature Description Source Product Source Field First Character
Address PreciselyID Master Location Data and Address Fabricâ„¢ Data PBKEY P
Building footprint Building ID Buildings BLDGID B
Parcel boundary Parcel ID Parcel Boundaries PRCLID C
Property attribute Property attribute ID Property Attributes Assessment PAID A
Point of interest Point of interest ID World Points of Interest Premium POIID D

Primary and secondary keys for each Relationship Class are shown in the following table:

Class Primary Key Field Name Primary Key Field Description Primary Key Example Secondary Key Field Name Secondary Field Key Description Secondary Key Example
1 PBKEY Precisely ID (addressable location) P0000N0K91FD PRCLID Parcel ID C000CU62GES7
2 PBKEY Precisely ID (addressable location) P0000N0K91FD BLDGID Building ID B000CTQKY48Y
3 BLDGID Building ID B000CTQKY48Y PRCLID Parcel ID C000CU62GES7
4 PBKEY Precisely ID (addressable location) P0000N0K91FD PAID Property attribute ID A000PK7ZUB5C
5 PBKEY Precisely ID (addressable location) P0000N0K91FD POIID Point of interest ID D000PISPU15U
6 PBKEY Precisely ID (addressable location) P0000N0K91FD PBKEY Precisely ID (addressable location) P0000N0K91FD
7 PRCLID Parcel ID C000CU62GES7 PAID Property attribute ID A000PK7ZUB5C
8 PRCLID Parcel ID C000CU62GES7 POIID Point of interest ID D000PISPU15U
9 BLDGID Building ID B000CTQKY48Y PAID Property attribute ID A000PK7ZUB5C
10 BLDGID Building ID B000CTQKY48Y POIID Point of interest ID D000PISPU15U