The examples in this section show how to use the IDLink table to establish relationships between different Precisely data products.
Example 1: Using a Parcel ID to look up PreciselyID addresses
To identify addresses associated with a specific parcel (represented by the Parcel ID) , query the Parcel ID (PRCLID) value in the IDLink table to retrieve the corresponding PreciselyID (PBKEY) value, which uniquely identifies the addresses associated with that parcel. For example, to find the addresses associated with Parcel ID C000PPOHSCZZ (representing a parcel in a residential area), search for the Precisely ID (PBKEY value) where the relationship class is 1 (Address and Parcel Boundary) and the PRCLID is C000PPOHSCZZ . The query will return the following results:
- PreciselyID: P0002JZB8ZL7 (11 ST. PAUL'S ROAD, SPALDING, PE11 2LU, UNITED KINGDOM)
- PreciselyID: P0002JW8PVBU (11 ST. PAUL'S ROAD, SPALDING, PE11 2LT, UNITED KINGDOM)
- PreciselyID: P0002JW6M6VC (9 ST. PAUL'S ROAD, SPALDING, PE11 2LT, UNITED KINGDOM)
- PreciselyID: P0002JZB8ZMO (9 ST. PAUL'S ROAD, SPALDING, PE11 2LU, UNITED KINGDOM)
These PreciselyIDs can then be used to retrieve additional details about each address, such as address attributes or parcel geometry from other licensed Precisely products.
Example 2: Using a Parcel ID to look up a building structure
To retrieve building structure information tied to a specific parcel boundary, query the Parcel ID (PRCLID value) to find the associated Building ID (BLDGID), which represents the structure located on that parcel. For example, to find building structures associated with Parcel ID C000PPOPJLMS (representing a commercial property lot), search for the Building ID (BLDGID) where the relationship class is 4 (Building Structure and Parcel Boundary) and the PRCLID is C000PPOPJLMS. The query returns the following result:
- Building ID: B00PRTAFTWP (representing a commercial building on the parcel)
Additional building characteristics and other attributes can now be retrieved.
The PreciselyID, PRCLID, and BLDGID values in these examples are unique and persistent identifiers, allowing users to link to, and explore, additional property and address data.