LOCATEXL USER GUIDE
|Top Previous Next|
The Geocode Results will display in columns at the end of your spreadsheet as follows:
This is a code to display which parts of the address were correctly matched. If there is no match the result will return a blank _
The Geocode codes and what they represent can be seen in the geocode data settings:
B = Building match ( e.g The Sandcastle)
N = Street number match (e.g 23 Falcon Street)
S = Street match (e.g 23 Falcon Street)
P = Place (suburb) match
L = Locale (town) match
R = Province match
C = Postal code match
M = MnType (Municipality Type)
I = Primary land use ( e.g Residential)
G = GtiType (Geoterra Image Type, type of area per GTI classification e.g Metro Urban)
These can be changed as desired in the settings to your own codes for each field by just clicking and entering them in. If you don't want a field represented in the results then leave the prefix for it blank.
*Note in an unstructured situation you may get false positives, for example Pretoria Town could match to Pretoria Street, you will get an S in the Status, even though it is not a correct match.
As the results are returned in your excel spreadsheet you can sort or filter on the Geocode Status column to identify records with the best matches, and those that require further geocoding or manual interaction.
NS___PLR_ Good Match - Number, Road, Suburb, Town and Province
N______R_ Poor Match – Number and Province only
You can also use the ‘Geocode Check Distance’ column for further verification
The building name.
The Street Number
The street name
The suburb name
The town name
The province name
The postal code
The municipality type, refers to Local municipality type as published in the 2011 StatsSA spatial data release. (This field is just returned when geocoding and is not an actual weight to adjust.)
The primary land use of the area, refers to Area based primary land use per EA, e.g Residential. (This field is just returned when geocoding and is not an actual weight to adjust.)
Geoterra Image Type, type of area per GTI classification, for example Metro Urban, Non-Metro Urban, etc. (This field is just returned when geocoding and is not an actual weight to adjust)
A count of the number of fields that matched.
For example _S__PLR_ means that the street, suburb, town and province matched so the score is 4. If you changed your weightings in the settings box it will count accordingly
•Str = Street matches
•Cnr = Corner matches
•POI = POI matches
The dataset that the geocode result comes from. Currently we are only using MapIT (Tom Tom) data as a source but a user can also add their own custom data sets if available
X and Y
The coordinates of the result
Geocode Check Distance
Results will be returned in this field if the distance check was set before geocoding. The distance check measures the distance in meters from a point in the suburb/town geocode result, to a point in the suburb/town provided in the street address. You can use this distance check to confirm matches where suburb/town names are different in the data and results. For example, if the address is 23 Katherine Street Sandhurst and the geocode result is 23 Katherine Street Sandton, the suburb is different, but the distance check is less than 1km it means that sandhurst and sandton are in close proximity and the result is most likely correct, even though the suburb names are different.
*Only returned if you are running a classification to a layer e.g. municipality etc.