Geocoder

Introduction

Geocoding lets you map a table of addresses to their respective spatial locations. It turns an address into an latitude and longitude, by finding that address on a geo-located database

Inputs

To show the geocoder tool in use, we will run it on the addresses of three post offices in the inner north of Melbourne. To do this:

  • Prepare a .csv file with an address field in the format (note that “ID” must be uppercase) shown below:

ID, address1
1,"69 Fitzgibbon Street, Parkville, VIC, 3052"
2,"Shop 12 300 Grattan Street, Royal Melbourne Hospital, VIC, 3050"
3,"70 Errol Street, North Melbourne, VIC, 3051"

  • Import the dataset into your file to the Geocoder tool
  • Navigate to the location of your dataset
  • Give it a descriptive Title and Abstract. Remember to choose Non-Aggregated  for Aggregation Level and ID as the Key (shown below)

 

  • Once your dataset has been imported, it is important to check to see if it was a successful upload. Your dataset should look something like the table below

post

  • Navigate to the Geocoder tool (Tools → Spatial Data Manipulation → Geocoder) and enter the parameters as shown in the image below (these are also explained under the image)
[Click to Enlarge]

[Click to Enlarge]

  • Addresses Dataset: The dataset that you would like to geocode. In this instance we use Post Offices
  • Address Field: The field containing the address. Here we use address1

Once you have added these parameters click Add and Run

Outputs

Once your tool has run, right click on the spanner icon in the output dataset (named Output: geocoder-workflow XXXX – you can rename this) and click Display on Map. Select the colours you would like and click Display. If you open your data table and hover over the rows, they should show up on the map. It should look something like the map below

[Click to Enlarge]

[Click to Enlarge]