Do you need to use the PSMA Geocoded National Address Files to obtain the latitude and longitude of your customer address data so that you can display them on a map? This data is maintained and made available on a three monthly basis.
In this module, you will learn how to extract both Location and Address from the G-NAF files.
The amount of data for all Australian addresses is in the tens of millions of records. With this amount of data, millions of rows, but not larger than 2 billion and the fact that it is not volatile means that it is an excellent candidate for placing it into a Calgary Database for fast retrieval.
In the Follow Me session we create the Location data for all Australian states. The second part of this is to create a Calgary Database and to check the performance of reading the data against reading the same data from an Excel workbook.
Then we create another workflow that joins all Australian addresses to address business data. Followed by creating a Calgary Database with all Australian addresses and showing the difference between the Calgary Join tool and using Calgary Input and the Join tool.
There are two challenges to use both Location and Address data.
You will understand the GNAF data can be joined to business data to provide the Latitude and Longitude so that your business data can be shown on a map by either location or even down to address level.