Additional primary relationships in VIC and WA
In the December 2023 Release, it has been observed that a large number of additional primary relationships to cadastre have been included in the planning_insights tables for VIC and WA that were provided as secondary relationships in the previous release.
For example, in the September 2023 release at a high-rise site, only a single Lot parcel with base_cadastre_pid of ‘cadc67070d7457c’ had a primary link. Using this base_cadastre_pid, a secondary link could be made to the the 20 Strata parcels that also exist at the site and were assigned with the same base_cadastre_pid (these parcels would have different cadastre_pid values).
cadastre_polygon_pid |
cadastre_pid |
parcel_type |
base_cadastre_pid |
cp7c9e018f9cb79 |
cadc67070d7457c |
Lot |
cadc67070d7457c |
cpfd079c5f5bb7e |
cad76750d10765f |
Strata |
cadc67070d7457c |
cp0de474848c212 |
cad5ff87ede7db0 |
Strata |
cadc67070d7457c |
cp192340188efeb |
cad7eb56c73e382 |
Strata |
cadc67070d7457c |
cpf63a91ad4de0b |
cad788a5e7d606c |
Strata |
cadc67070d7457c |
cp533db1741120c |
cadfa24a66d3cb7 |
Strata |
cadc67070d7457c |
However, in the December 2023 release, all 21 of these parcel cadastre_pid values are assigned as a base_cadastre_pid meaning that each of these parcels has a primary link.
cadastre_polygon_pid |
cadastre_pid |
parcel_type |
base_cadastre_pid |
cp7c9e018f9cb79 |
cadc67070d7457c |
Lot |
cadc67070d7457c |
cp23fea247c8458 |
cad7b53848b9e45 |
Strata |
cad7b53848b9e45 |
This change is especially evident in the planning_insights_address table count changes which have increased by over 900,000 for VIC and WA. Where an address had a primary link to a single Lot parcel in the past, it can now link to many (can be 50+ in high-rise locations) Strata parcels in addition to the Lot parcel.
We are investigating this change with our data supplier and intend to resolve this issue for a future release.