Implementation of Incremental Updates - suburbs_and_localities - Latest

Suburbs and Localities Australia Product Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Boundaries > Postcode and Administrative Boundaries
Product
Suburbs and Localities
Version
Latest
Language
English
Product name
Suburbs and Localities Australia
Title
Suburbs and Localities Australia Product Guide
Copyright
2023
First publish date
2000
Last updated
2024-06-20
Published on
2024-06-20T15:36:59.872547

An incremental update can be carried out using the following procedure:

  1. Select records from the previous release of Suburbs and Localities data where the SL_UFI values match those of the Changelog and the Change type = D or U (Deletion or Update respectively).
  2. Delete the selected records from the old Suburbs and Localities data.
  3. Select from the new Suburbs and Localities data where the SL_UFI values match those of the changelog and the change type = I or U (Insertion or Update respectively).
  4. Append the selected records to the old Suburbs and Localities data. The resulting table will be equivalent to the supplied table of the new version.