11. Appendix A – Addressing Standards and NAMF Relationship¶
The field names used for G-NAF differ from those used by the address standard AS4590:2006 and the National Address Management Framework (NAMF). Geoscape recommends applying the following G-NAF fields to provide the relationship to AS4590 and NAMF fields.
NAMF Field |
AS4590 Field |
G‑NAF Field(s) |
Description |
|---|---|---|---|
complexLevelType |
COMPLEX.LEVEL TYPE CODE |
LEVEL_TYPE_AUT.DESCRIPTION |
Full name of level type |
complexLevelNumber |
COMPLEX.LEVEL NUMBER |
ADDRESS_DETAIL.LEVEL_NUMBER_PREFIX, ADDRESS_DETAIL.LEVEL_NUMBER, ADDRESS_DETAIL.LEVEL_NUMBER_SUFFIX |
Level number is a concatenation of the three fields |
complexUnitType |
COMPLEX.SUB DWELLING UNIT TYPE CODE |
FLAT_TYPE_AUT.DESCRIPTION |
Full name of flat type |
complexUnitIdentifier |
COMPLEX.SUB DWELLING UNIT NUMBER |
ADDRESS_DETAIL.FLAT_NUMBER_PREFIX, ADDRESS_DETAIL.FLAT_NUMBER, ADDRESS_DETAIL.FLAT_NUMBER_SUFFIX |
Flat number is a concatenation of the three fields |
complexStreetNumber1 |
COMPLEX.COMPLEX ROAD NUMBER 1 |
ADDRESS_DETAIL.NUMBER_FIRST_PREFIX, ADDRESS_DETAIL.NUMBER_FIRST, ADDRESS_DETAIL.NUMBER_FIRST_SUFFIX |
Applicable if, and only if, a primary secondary relationship is identified in G‑NAF. The first street number of the secondary address is a concatenation of the three fields |
complexStreetNumber2 |
COMPLEX.COMPLEX ROAD NUMBER 2 |
ADDRESS_DETAIL.NUMBER_LAST_PREFIX, ADDRESS_DETAIL.NUMBER_LAST, ADDRESS_DETAIL.NUMBER_LAST_SUFFIX |
Applicable if, and only if, a primary secondary relationship is identified in G‑NAF. The last street number of the secondary address is a concatenation of the three fields |
complexStreetName |
COMPLEX.COMPLEX ROAD NAME |
STREET_LOCALITY.STREET_NAME |
Applicable if, and only if, a primary secondary relationship is identified in G‑NAF. Street name of the secondary address |
complexStreetType |
COMPLEX.COMPLEX ROAD TYPE CODE |
STREET_TYPE_AUT.DESCRIPTION |
Applicable if, and only if, a primary secondary relationship is identified in G‑NAF. Abbreviation of street type of the secondary address |
complexStreetSuffix |
COMPLEX.COMPLEX ROAD SUFFIX CODE |
STREET_SUFFIX_AUT.DESCRIPTION |
Applicable if, and only if, a primary secondary relationship is identified in G‑NAF. Full name of street suffix of the secondary address |
siteName |
ADDRESS SITE NAME |
ADDRESS_DETAIL.BUILDING_NAME |
Building name. This may require review, as there is also a name in the ADDRESS_SITE table. Perhaps a business rule similar to:
# CASE
# WHEN ADDRESS_DETAIL.BUILDING_NAME IS NOT NULL THEN ADDRESS_DETAIL.BUILDING_NAME
# ELSE ADDRESS_SITE.ADDRESS_SITE_NAME
# END
|
lotIdentifier |
ROAD NUMBER.LOT NUMBER |
ADDRESS_DETAIL.LOT_NUMBER_PREFIX, ADDRESS_DETAIL.LOT_NUMBER, ADDRESS_DETAIL.LOT_NUMBER_SUFFIX |
Lot number is a concatenation of the three fields |
streetNumber1 |
ROAD NUMBER.ROAD NUMBER 1 |
ADDRESS_DETAIL.NUMBER_FIRST_PREFIX, ADDRESS_DETAIL.NUMBER_FIRST, ADDRESS_DETAIL.NUMBER_FIRST_SUFFIX |
The first street number is a concatenation of the three fields |
streetNumber2 |
ROAD NUMBER.ROAD NUMBER 2 |
ADDRESS_DETAIL.NUMBER_LAST_PREFIX, ADDRESS_DETAIL.NUMBER_LAST, ADDRESS_DETAIL.NUMBER_LAST_SUFFIX |
The last street number is a concatenation of the three fields |
streetName |
ROAD.ROAD NAME |
STREET_LOCALITY.STREET_NAME |
Street name |
streetType |
ROAD.ROAD TYPE CODE |
STREET_TYPE_AUT.DESCRIPTION |
Abbreviation of street type |
streetSuffix |
ROAD.ROAD SUFFIX CODE |
STREET_SUFFIX_AUT.DESCRIPTION |
Full name of street suffix |
localityName |
LOCALITY NAME |
LOCALITY.LOCALITY_NAME |
Locality name |
stateTerritory |
STATE OR TERRITORY CODE |
STATE.STATE_ABBREVIATION |
State or territory abbreviation |
geoNorthSouthCoordinate |
GEOCODE.GEOCODE LATITUDE |
ADDRESS_SITE_GEOCODE.LATITUDE OR STREET_LOCALITY_POINT.LATITUDE OR LOCALITY_POINT.LATITUDE |
Business rule:
# CASE
# WHEN ADDRESS_SITE_GEOCODE.LATITUDE IS NOT NULL THEN ADDRESS_SITE_GEOCODE.LATITUDE
# WHEN STREET_LOCALITY_POINT.LATITUDE IS NOT NULL THEN STREET_LOCALITY_POINT.LATITUDE
# ELSE LOCALITY_POINT.LATITUDE
# END
|
geoEastWestCoordinate |
GEOCODE.GEOCODE LONGITUDE |
ADDRESS_SITE_GEOCODE.LONGITUDE OR STREET_LOCALITY_POINT.LONGITUDE OR LOCALITY_POINT.LONGITUDE |
Business rule:
# CASE
# WHEN ADDRESS_SITE_GEOCODE.LONGITUDE IS NOT NULL THEN ADDRESS_SITE_GEOCODE.LONGITUDE
# WHEN STREET_LOCALITY_POINT.LONGITUDE IS NOT NULL THEN STREET_LOCALITY_POINT.LONGITUDE
# ELSE LOCALITY_POINT.LONGITUDE
# END
|
geoFeature |
GEOCODE.GEOCODE FEATURE |
GEOCODE_TYPE_AUT.NAME OR “STREET LOCALITY CENTROID” OR “LOCALITY CENTROID” |
Business rule:
# CASE
# WHEN ADDRESS_SITE_GEOCODE.GEOCODE_TYPE_CODE IS NOT NULL THEN GEOCODE_TYPE_AUT.NAME
# WHEN ADDRESS_SITE_GEOCODE.LONGITUDE IS NOT NULL THEN ‘PROPERTY/PARCEL GEOCODE’
# WHEN STREET_LOCALITY_POINT.LONGITUDE IS NOT NULL THEN ‘STREET LOCALITY CENTROID’
# ELSE ‘LOCALITY CENTROID’
# END
|
geoDatumCode |
GEOCODE.GEOCODE GEOGRAPHIC DATUM |
“GDA94” or “GDA2020” |