Reverse geocoding is the process of pin-pointing a physical address from a latitude and longitude GPS location. Street addresses with suburbs, cities and postcodes are human readable whereas long, high precision lat/long point location digits are difficult to read without a pin on a map.
Addy's bulk reverse geocoding service allows you to turn a large list of coordinate points from a CSV spreadsheet into the nearest, readable street addresses. The distance in metres (kilometre decimals) between the GPS coordinates and the physical addresses are included with every successful point to address conversion.
Download CSV Template with sample X and Y coordinates to get started; or
Below is a screenshot of the geocoding validation step:
The original address columns will be preserved, and additional address columns will be added for each validated address.
The table below describes each column in the Excel CSV spreadsheet. To find a complete description of all the fields, see the response properties for the Address Details API.
|Reason||The reason why reverse geocoding failed. This field will be blank if the address was matched successfully||
X and Y coordinates must be specified.
The X or Y coordinate is not a valid number.
|DistanceKM||The distance in kilometres from the coordinates to the address.||0.01113451|
|DistanceM||The distance in metres from the coordinates to the address.||11.13451031|
|Address||Full address in a single line||80 Queen Street, Auckland Central, Auckland 1010|
|Display Line||Holds the single line address display name||Floor 2, 1 Blair Street|
|Street||Holds the name and type of the street||Blair Street|
|Suburb||Holds the name applied to a group of geographically associated streets||Te Aro|
|City||Holds the name of the Town/City provided by Land Information New Zealand (LINZ)||Wellington|
|Mailtown||Holds the name of the Town/City/Mailtown associated with this delivery point||Wellington|
|Postcode||Holds the four digit code defined by New Zealand Post, which is used to describe the locations linked to sorting zones for mail sorting purposes||0622|
|X||Holds the longitude coordinates in WGS84 format||174.7835236|
|Y||Holds the latitude coordinates in WGS84 format||-41.29302216|
|ID||Holds the unique Addy Identifier||2392921|
|DPID||Holds the unique reference number assigned by NZ Post to each delivery point address||1500136|
|LINZ ID||Holds the unique reference number assigned by Land Information New Zealand (LINZ) to each street address||25003|
|Parcel ID||Holds the unique spatial object number representing a land parcel where the postal address resides as assigned by Land Information New Zealand (LINZ)||3757439|
|Meshblock||Holds the foreign key value to link to census and statistical datasets as assigend by Statistics New Zealand (Stats NZ)||2135700|
|Number||Holds the base street number. For Rural addresses these are allocated by territorial authorities||1|
|RD Number||Holds the rural delivery route number|
|Alpha||Holds the alpha component of a street number||B|
|Unit Type||Holds the category description of a sub-dwelling type within a building of building compiles. This is used in conjunction with the Unit Number address element||Flat|
|Unit Number||Holds the address elements that identifies a specific deliver sub dwelling delivery point within a building or building complex||3|
|Floor||Holds the Floor type and identifier in a multi level building||Floor 2|
|Territory||Holds the territorial authority of the address. See districts of NZ<||Wellington City|
|Region||Holds the regional authority of the address. See regions of NZ||Wellington|
|Building||Holds the building property name for a recognised significant building|
|Type||Holds the type of delivery point (Urban, Rural, PostBox, NonPostal)||Urban|
|Box Bag Number||Holds the PO Box/Private Bag number|
|Ouput Field 1||Holds the correctly formatted address in line 1||Floor 2|
|Output Field 2||Holds the correctly formatted address in line 2||1 Blair Street|
|Output Field 3||Holds the correctly formatted address in line 3||Te Aro|
|Output Field 4||Holds the correctly formatted address in line 4||Wellington 6011|
|Modified||Holds the last modified date of the address||22/01/2018|
|PAF Source||Holds a flag to state if the address was sourced from the New Zealand Postal Address File (TRUE) or Land Information New Zealand (FALSE)||TRUE|
|Deleted||Holds a flag to state if the address was deleted||FALSE|