13. Appendix C – Data Dictionary

The following describes how the various fields should be interpreted in the respective metadata tables in the Feature Catalogue below.

Schema Table Summary

Column	Abbreviation	Description
Name	Name	The name of the column in the Integrated Database
Data Type	Data type	The Oracle data type of the column. Mapinfo TAB files have similar data types.
Description	Description	A description of the column and what the expected contents are
Primary Key	Prim Key	If ‘Y’ then this column must always have a unique value. (has # entry in the data model tables)
Obligation	Man	Y = mandatory. If ‘Y’ (mandatory), this column must be populated with data. That is, all ACTIVE records must have values in this column.
Foreign Key Table	F K TABLE	Represents a column in the ‘Foreign Key Table’ that this column is referred to by another table. (has * entry in the data model tables)
Foreign Key Column	F K Col	Represents a table in the Integrated Database that this column is referred to.
10 Character Alias	10 Char Alias	An alias for this column name - up to 10 characters maximum. Used to define the name of the column when in ESRI Shapefile format.

ADDRESS_ALIAS

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_ALIAS_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			ADD_AL_PID
DATE_CREATED	Date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	Date	Date this record was retired.	N	N			DT_RETIRE
PRINCIPAL_PID	varchar2(15)	Persistent identifier (i.e. ADDRESS_DETAIL_PID) of the principal address.	N	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	PRINC_PID
ALIAS_PID	varchar2(15)	Persistent identifier (i.e. ADDRESS_DETAIL_PID) of the alias address.	N	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	ALIAS_PID
ALIAS_TYPE_CODE	varchar2(10)	Alias type (e.g. “Synonym”).	N	Y	ADDRESS_ALIAS_TYPE_AUT	CODE	ALTYP_CODE
ALIAS_COMMENT	varchar2(200)	Comment about the alias (e.g. Corner address).	N	N			ALIAS_CMT

ADDRESS_ALIAS_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(10)	Unique abbreviation of address alias type. This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the address alias type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(30)	Description of the address alias type code.	N	N			DSCPN_AUT

ADDRESS_ALIAS_TYPE_AUT CODES

CODE	NAME
SYN	Synonym
CD	Contributor Defined
AL	Alternative Locality
RA	Ranged Address
LD	Level Duplication
FNNFS	Flat Number – No First Suffix Correlation
MR	Maintenance Reference

ADDRESS_DETAIL

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_DETAIL_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y	-	-	ADD_DT_PID
DATE_CREATED	Date	Date this record was created.	N	Y	-	-	DT_CREATE
DATE_LAST_MODIFIED	Date	Date this record was last modified (not retired/recreated in line with ICSM standard).	N	N	-	-	DT_LST_MOD
DATE_RETIRED	Date	Date this record was retired.	N	N	-	-	DT_RETIRE
BUILDING_NAME	varchar2(200)	Combines both building/property name fields. Field length: up to 200 alphanumeric characters (AS4590:2006 5.7).	N	N	-	-	BLDNG_NAME
LOT_NUMBER_PREFIX	varchar2(2)	Lot number prefix. Field length: up to two alphanumeric characters (AS4590:2006 5.8.1).	N	N	-	-	LTNBR_PREF
LOT_NUMBER	varchar2(5)	Lot number. Field length: up to five alphanumeric characters (AS4590:2006 5.8.1).	N	N	-	-	LOT_NUMBER
LOT_NUMBER_SUFFIX	varchar2(2)	Lot number suffix. Field length: up to two alphanumeric characters (AS4590:2006 5.8.1).	N	N	-	-	LT_NB_SUFF
FLAT_TYPE_CODE	varchar2(7)	Specification of the type of a separately identifiable portion within a building/complex. Field Length: up to seven upper case alpha characters (AS4590:2006 5.5.1.1).	N	N	FLAT_TYPE_AUT	CODE	FTTYP_CODE
FLAT_NUMBER_PREFIX	varchar2(2)	Flat/unit number prefix. Field length: up to two alphanumeric characters (AS4590:2006 5.5.1.2).	N	N	-	-	FLTNB_PREF
FLAT_NUMBER	number(5)	Flat/unit number. Field length: up to five numeric characters (AS4590:2006 5.5.1.2).	N	N	-	-	FLT_NBR
FLAT_NUMBER_SUFFIX	varchar2(2)	Flat/unit number suffix Field length: up to two alphanumeric characters (AS4590:2006 5.5.1.2).	N	N	-	-	FLTNB_SUFF
LEVEL_TYPE_CODE	varchar2(4)	Level type. Field length: up to four alphanumeric characters (AS4590:2006 5.5.2.1).	N	N	LEVEL_TYPE_AUT	CODE	LVTYP_CODE
LEVEL_NUMBER_PREFIX	varchar2(2)	Level number prefix. Field length: up to two alphanumeric characters (AS4590:2006 5.5.2.2).	N	N	-	-	LVLNB_PREF
LEVEL_NUMBER	number(3)	Level number. Field length: up to three numeric characters (AS4590:2006 5.5.2.2).	N	N	-	-	LVL_NBR
LEVEL_NUMBER_SUFFIX	varchar2(2)	Level number suffix. Field length: up to two alphanumeric characters (AS4590:2006 5.5.2.2).	N	N	-	-	LVLNB_SUFF
NUMBER_FIRST_PREFIX	varchar2(3)	Prefix for the first (or only) number in range. Field length: up to three uppercase alphanumeric characters (AS4590:2006 5.5.3.1).	N	N	-	-	NBFST_PREF
NUMBER_FIRST	number(6)	Identifies first (or only) street number in range. Field length: up to six numeric characters (AS4590:2006 5.5.3.1).	N	N	-	-	NBR_FRST
NUMBER_FIRST_SUFFIX	varchar2(2)	Suffix for the first (or only) number in range. Field length: up to two uppercase alphanumeric characters (AS4590:2006 5.5.3.1).	N	N	-	-	NBFST_SUFF
NUMBER_LAST_PREFIX	varchar2(3)	Prefix for the last number in range. Field length: up to three uppercase alphanumeric characters (AS4590:2006 5.5.3.2).	N	N	-	-	NBLST_PREF
NUMBER_LAST	number(6)	Identifies last number in range. Field length: up to six numeric characters (AS4590:2006 5.5.3.2).	N	N	-	-	NBR_LAST
NUMBER_LAST_SUFFIX	varchar2(2)	Suffix for the last number in range. Field length: up to two uppercase alphanumeric characters (AS4590:2006 5.5.3.2).	N	N	-	-	NBLST_SUFF
STREET_LOCALITY_PID	varchar2(15)	Street/Locality of this address - not mandatory as some records in G-NAF may not require street (e.g. remote rural property).	N	N	STREET_LOCALITY	STREET_LOCALITY_PID	ST_LOC_PID
LOCATION_DESCRIPTION	varchar2(45)	A general field to capture various references to address locations alongside another physical location. Field length: up to 45 alphanumeric characters (AS4590:2006 5.16).	N	N	-	-	LOC_DESC
LOCALITY_PID	varchar2(15)	The unique identifier for the locality.	N	Y	LOCALITY	LOCALITY_PID	LOC_PID
ALIAS_PRINCIPAL	char(1)	A = Alias record, P = Principal record.	N	N	-	-	ALS_PRNCPL
POSTCODE	varchar2(4)	Postcodes are optional as prescribed by AS4819 and AS4590:2006 5.13.	N	N	-	-	POSTCODE
PRIVATE_STREET	varchar2(75)	Private street information. This is not broken up into name/type/suffix. Field length: up to 75 alphanumeric characters. This is not currently populated.	N	N	-	-	PRIV_ST
LEGAL_PARCEL_ID	varchar2(20)	Generic parcel id field derived from the Geoscape Australia’s Cadastre parcel where available.	N	N	-	-	LGLPARC_ID
CONFIDENCE	number(1)	Reflects how many contributor databases this address appears in (0 = 1 database, 1 = 2 database etc.).	N	N	-	-	CONFIDENCE
ADDRESS_SITE_PID	varchar2(15)	Address site Persistent Identifier.	N	Y	ADDRESS_SITE	ADDRESS_SITE_PID	ADD_ST_PID
LEVEL_GEOCODED_CODE	number(2)	Binary indicator of the level of geocoding this address has. e.g. 0 = 000 = (No geocode), 1 = 001 = (No Locality geocode, No Street geocode, Address geocode), etc.	N	Y	GEOCODED_LEVEL_TYPE_AUT	CODE	LVLGC_CODE
PROPERTY_PID	varchar2(15)	Property persistent identifier referenced to relevant cadastral model. This field is not currently populated.	N	N	-	-	PR_PID
GNAF_PROPERTY_PID	varchar2(15)	This field stores the property identifier provided by the jurisdiction for the property associated with the address. This identifier is the same as the CONTRIBUTOR_ID in the Property product.	N	N	-	-	GF_PRP_PID
PRIMARY_SECONDARY	varchar2(1)	Indicator that identifies if the address is P (Primary) or S (secondary).	N	N	-	-	PRIM_SEC

PRIMARY_SECONDARY

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
PRIMARY_SECONDARY_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			PRIM_S_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
PRIMARY_PID	varchar2(15)	Persistent identifier for the primary address.-Defined as a principal address which does not have a flat number or level number but which matches the secondary address in all other respects OR is designated as owning secondary addresses by Geoscape (e.g. involves private road in complex development).	N	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	PRIM _PID
SECONDARY_PID	varchar2(15)	Secondary persistent identifier for the Secondary address - defined as any address where flat number or level number information is not null, i.e. includes PREFIX, NUMBER or SUFFIX, OR is designated as being linked to a primary address by Geoscape (e.g. involves private road in complex development).	N	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	SEC_PID
PS_JOIN_TYPE_CODE	number(2)	Code of 1 OR 2 when the root address:-	N	Y	PS_JOIN_TYPE_CODE_AUT	CODE	JNTYP_CODE
		Code 1: Automatically generated when the primary and secondary addresses share the same street number, street name (and type) and locality name components.
		Code 2: Manually generated where the primary and secondary addresses MAY or MAY NOT share the same street number, street name (and type) and locality name components
PS_JOIN_COMMENT	varchar2(500)	Details of join type can be given.	N	N			PS_JN_CMNT

PS_JOIN_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(2)	Defines the type of join (e.g. “1”,”2”).	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the join type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(500)	Description of the join type code.	N	N			DSCPN_AUT

PS_JOIN_TYPE_AUT CODES

CODE	DESCRIPTION	Name
1	AUTOMATICALLY MATCHED PRIMARY AND SECONDARY WHEN THE PRIMARY AND SECONDARY ADDRESSES SHARE THE SAME STREET NUMBER, STREET NAME (AND TYPE) AND LOCALITY NAME COMPONENTS	AUTO
2	MANUALLY GENERATED LINK, PRIMARY AND SECONDARY ADDRESSES MAY OR MAY NOT SHARE THE SAME STREET NUMBER, STREET NAME (AND TYPE) AND LOCALITY NAME COMPONENTS	MANUAL

ADDRESS_FEATURE

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_FEATURE_ID	varchar2(16)	The Identifier is unique to the record within the table. The ID is prefixed with the state or territory abbreviation, e.g. NSW123456	Y	Y			ADD_FT_ID
ADDRESS_FEATURE_PID	varchar2(16)	The Persistent Identifier is the unique identifier for the addressable object this record represents. The PID allows for tracking change to the ADDRESS_DETAIL_PID associated with an addressable object over time. The PID is prefixed with AF and the state or territory abbreviation, e.g. AFNSW123456	N	Y			ADD_FT_PID
ADDRESS_DETAIL_PID	varchar2(15)	The Persistent Identifier that is unique to the real world feature this record represents.	Y	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	ADD_DT_PID
DATE_ADDRESS_DETAIL_CREATED	Date	Date the address (ADDRESS_DETAIL) record was created.	N	Y			DT_AD_CR
DATE_ADDRESS_DETAIL_RETIRED	Date	Date the address (ADDRESS_DETAIL) record was retired.	N	N			DT_AD_RT
ADDRESS_CHANGE_TYPE_CODE	varchar(50)	The code indicating the type of change, for example, LOC-STN for locality name and street name change.	N	N	ADDRESS_CHANGE_TYPE_AUT	CODE	CODE

ADDRESS_CHANGE_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar(50)	An abbreviated name of the type of change. Field length: up to fifty characters. This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(100)	Name of the address change type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(500)	Description of address change type code.	N	N			DSCPN_AUT

Note

The codes are not listed due to the large number of change types. Please look at the tables within the data.

ADDRESS_MESH_BLOCK_2016

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_MESH_BLOCK_2016_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			A_MB_16PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
ADDRESS_DETAIL_PID	varchar2(15)	Persistent identifier (i.e. ADDRESS_DETAIL_PID) of the principal address.	N	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	ADD_DT_PID
MB_MATCH_CODE	Varchar2(15)	Code for mesh block match e.g. 1.	N	Y	MB_MATCH_CODE	CODE	MB_MATCHED
MB_2016_PID	varchar2(15)	Mesh block 2016 Persistent Identifier.	N	Y	MB_2016	MB_2016_PID	MB_16PID

ADDRESS_MESH_BLOCK_2021

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_MESH_BLOCK_2021_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			A_MB_21PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
ADDRESS_DETAIL_PID	varchar2(15)	Persistent identifier (i.e. ADDRESS_DETAIL_PID) of the principal address.	N	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	ADD_DT_PID
MB_MATCH_CODE	Varchar2(15)	Code for mesh block match e.g. 1.	N	Y	MB_MATCH_CODE	CODE	MB_MATCHED
MB_2021_PID	varchar2(15)	Mesh block 2021 Persistent Identifier.	N	Y	MB_2021	MB_2021_PID	MB_21PID

MB_MATCH_CODE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(15)	Code e.g. 1. This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(100)	Name of the match code. e.g. PARCEL LEVEL MATCH.	N	Y			NAME_AUT
DESCRIPTION	varchar2(250)	Description of what the match code means.	N	N			DESC_AUT

MB_MATCH_CODE_AUT CODES

CODE	NAME	DESCRIPTION
1	PARCEL LEVEL MATCH	A parcel level geocode for the address has been applied and clearly within the boundaries of a single mesh block. The mesh block ID allocated to the address in most cases is at a very high level of confidence.
2	GAP GEOCODED ADDRESS LEVEL MATCH	A gap geocoded match for the address has been applied and clearly within the boundaries of a single mesh block. The mesh block ID allocated to the address in most cases is at a high level of confidence.
3	STREET LOCALITY LEVEL SINGLE MATCH	A street-locality level geocode for the address has been applied and clearly within the boundaries of a single mesh block. The mesh block ID allocated to the address in most cases is at a high level of confidence.
4	STREET LOCALITY LEVEL MULTIPLE MATCH	A street-locality level geocode for the address has been applied and is within the boundaries of a multiple mesh blocks. The mesh block ID allocated to the address is at a low level of confidence.
5	LOCALITY LEVEL MULTIPLE MATCH	A locality level geocode for the address has been applied and is within the boundaries of a multiple mesh blocks. The mesh block ID allocated to the address is at a very low level of confidence.

ADDRESS_SITE

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_SITE_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			ADD_ST_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
ADDRESS_TYPE	varchar2(8)	Address type (e.g. “Postal”, Physical”).	N	N	ADDRESS_TYPE_AUT	CODE	ADDR_TYPE
ADDRESS_SITE_NAME	varchar2(200)	Address site name. Field length: 200 alphanumeric characters.	N	N			NAME

ADDRESS_SITE_GEOCODE

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_SITE_GEOCODE_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			AS_GCD_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
ADDRESS_SITE_PID	varchar2(15)	Address site Persistent Identifier.	N	N	ADDRESS_SITE	ADDRESS_SITE_PID	ADD_ST_PID
GEOCODE_SITE_NAME	varchar2(200)	An identifier that relates to this specific geocoded site (e.g. “Transformer 75658”).	N	N			GC_ST_NAME
GEOCODE_SITE_DESCRIPTION	varchar2(45)	Additional textual data e.g. “Warning: Access to water riser is located at rear of building via SMITH LANE”.	N	N			GCD_ST_DES
GEOCODE_TYPE_CODE	varchar2(4)	Unique abbreviation for geocode feature. (e.g. “PRCL”) (SAWG 7.4.1).	N	N	GEOCODE_TYPE_AUT	CODE	GCTYP_CODE
RELIABILITY_CODE	number(1)	Spatial precision of the geocode expressed as number in the range, 1 (unique identification of feature) to 6 (feature associated to region i.e. postcode).	N	Y	GEOCODE_RELIABILITY_AUT	CODE	RLBTY_CODE
BOUNDARY_EXTENT	number(7)	Measurement (metres) of a geocode from other geocodes associated with the same address persistent identifier.	N	N			BNDRY_EXT
PLANIMETRIC_ACCURACY	number(12)	Planimetric accuracy.	N	N			PLANIM_ACC
ELEVATION	number(7)	Elevation. This field is not currently populated.	N	N			ELEVATION
GEOMETRY	point	Point geometry – calculated by the longitude/latitude of record (not part of the product).	N	Y			GEOMETRY
LONGITUDE	number(11,8)	Longitude.	N	N			LONGITUDE
LATITUDE	number(10,8)	Latitude.	N	N			LATITUDE

ADDRESS_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(8)	Defines the type of address (e.g. “Rural”, “Urban”).	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the address type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(30)	Description of address type code.	N	N			DSCPN_AUT

ADDRESS_TYPE_AUT CODES

CODE	NAME		CODE	NAME
R	Rural		UN/POR	Unknown Portion
UN	Unknown		UN/PTHS	Unknown Penthouse
UR	Urban		UN/REAR	Unknown Rear

FLAT_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(7)	Specification of the type of a separately identifiable portion of a building complex. Field length: one to seven uppercase alpha characters (AS4590:2006 5.5.1.1). This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name for the of the flat type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(30)	Description of flat type code.	N	N			DSCPN_AUT

FLAT_TYPE_AUT CODES

CODE	NAME		CODE	NAME		CODE	NAME		CODE	NAME
ANT	ANTENNA		CARP	CARPARK		LOT	LOT		STR	STRATA UNIT
APT	APARTMENT		CARS	CARSPACE		LSE	LEASE		SUBS	SUBSTATION
ATM	AUTOMATED TELLER MACHINE		CLUB	CLUB		MBTH	MARINE BERTH		TNCY	TENANCY
BBQ	BARBECUE		COOL	COOLROOM		MSNT	MAISONETTE		TNHS	TOWNHOUSE
BLCK	BLOCK		CTGE	COTTAGE		SE	SUITE		TWR	TOWER
OFFC	OFFICE		DUPL	DUPLEX		SEC	SECTION		UNIT	UNIT
PTHS	PENTHOUSE		FLAT	FLAT		SHED	SHED		VLLA	VILLA
REAR	REAR		FCTY	FACTORY		SHOP	SHOP		VLT	VAULT
ROOM	ROOM		GRGE	GARAGE		SHRM	SHOWROOM		WARD	WARD
RESV	RESERVE		HALL	HALL		SIGN	SIGN		WHSE	WAREHOUSE
BTSD	BOATSHED		HSE	HOUSE		SITE	SITE		WKSH	WORKSHOP
BLDG	BUILDING		KSK	KIOSK		STLL	STALL
BNGW	BUNGALOW		LBBY	LOBBY		STOR	STORE
CAGE	CAGE		LOFT	LOFT		STU	STUDIO

GEOCODE_RELIABILITY_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(1)	Geocode reliability code. This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the geocode reliability code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(100)	Description of the geocode reliability code.	N	N			DSCPN_AUT

GEOCODE_RELIABILITY_AUT CODES

CODE	DESCRIPTION	NAME
1	Geocode accuracy recorded to appropriate surveying standard	Surveying Standard
2	Geocode accuracy sufficient to place geocode within address site boundary or access point	Within Address Site Boundary or Access Point
3	Geocode accuracy sufficient to place geocode near (or possibly within) address site boundary	Near (Or Possibly Within) Address Site Boundary
4	Geocode accuracy sufficient to associate address site with a unique road feature	Unique Road Feature
5	Geocode accuracy sufficient to associate address site with a unique locality or neighbourhood	Unique Locality Or Neighbourhood
6	Geocode accuracy sufficient to associate address site with a unique region	Unique Region

GEOCODE_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(4)	Stores unique abbreviations for geocode features. (e.g. “BC”; Building Centroid). This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the geocode type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(250)	Description of geocode type code.	N	N			DSCPN_AUT

GEOCODE_TYPE_AUT CODES

CODE	NAME	DESCRIPTION
BAP	BUILDING ACCESS POINT	POINT OF ACCESS TO THE BUILDING.
BC	BUILDING CENTROID	POINT AS CENTRE OF BUILDING AND LYING WITHIN ITS BOUNDS (E.G. FOR U-SHAPED BUILDING).
CDF	CENTRE-LINE DROPPED FRONTAGE	A POINT ON THE ROAD CENTRE-LINE OPPOSITE THE CENTRE OF THE ROAD FRONTAGE OF AN ADDRESS SITE.
DF	DRIVEWAY FRONTAGE	CENTRE OF DRIVEWAY ON ADDRESS SITE FRONTAGE.
EA	EMERGENCY ACCESS	SPECIFIC BUILDING OR PROPERTY ACCESS POINT FOR EMERGENCY SERVICES.
EAS	EMERGENCY ACCESS SECONDARY	SPECIFIC BUILDING OR PROPERTY SECONDARY ACCESS POINT FOR EMERGENCY SERVICES.
FDA	FRONT DOOR ACCESS	FRONT DOOR OF BUILDING.
FC	FRONTAGE CENTRE	POINT ON THE CENTRE OF THE ADDRESS SITE FRONTAGE.
FCS	FRONTAGE CENTRE SETBACK	A POINT SET BACK FROM THE CENTRE OF THE ROAD FRONTAGE WITHIN AN ADDRESS SITE.
LB	LETTERBOX	PLACE WHERE MAIL IS DEPOSITED.
PAP	PROPERTY ACCESS POINT	ACCESS POINT (CENTRE OF) AT THE ROAD FRONTAGE OF THE PROPERTY.
PAPS	PROPERTY ACCESS POINT SETBACK	A POINT SET BACK FROM THE (CENTRE OF THE) ACCESS POINT AT THE ROAD FRONTAGE OF THE PROPERTY.
PC	PROPERTY CENTROID	POINT OF CENTRE OF PARCELS MAKING UP A PROPERTY AND LYING WITHIN ITS BOUNDARIES (E.G. FOR L-SHAPED PROPERTY).
PCM	PROPERTY CENTROID MANUAL	POINT MANUALLY PLACED APPROXIMATELY AT CENTRE OF PARCELS MAKING UP A PROPERTY AND LYING WITHIN ITS BOUNDARIES (E.G. FOR L-SHAPED PROPERTY).
UC	UNIT CENTROID	POINT AT CENTRE OF UNIT AND LYING WITHIN ITS BOUNDS (E.G. FOR U-SHAPED UNIT).
UCM	UNIT CENTROID MANUAL	POINT MANUALLY PLACED APPROXIMATELY AT CENTRE OF UNIT AND LYING WITHIN ITS BOUNDS (E.G. FOR U-SHAPED UNIT).
GG	GAP GEOCODE	POINT PROGRAMMATICALLY ALLOCATED DURING THE G-NAF PRODUCTION PROCESS PROPORTIONALLY BETWEEN ADJACENT ADDRESS LOCATIONS (BASED ON NUMBER_FIRST).
WCP	WATER CONNECTION POINT	WATER CONNECTION POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
WM	WATER METER	WATER METER POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
SCP	SEWERAGE CONNECTION POINT	SEWERAGE CONNECTION POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
GCP	GAS CONNECTION POINT	GAS CONNECTION POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
GM	GAS METER	GAS METER POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
TCP	TELEPHONE CONNECTION POINT	TELEPHONE CONNECTION POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
ECP	ELECTRICITY CONNECTION POINT	ELECTRICITY CONNECTION POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
EM	ELECTRICITY METER	ELECTRICITY METER POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
ICP	INTERNET CONNECTION POINT	INTERNET CONNECTION POINT (E.G. BOX, OR UNDERGROUND CHAMBER).
UNK	UNKNOWN	THE TYPE OF REAL WORLD FEATURE THE POINT REPRESENTS IS NOT KNOWN.
STL	STREET LOCALITY	POINT REPRESENTING THE EXTENT OF A STREET WITHIN A LOCALITY
LOC	LOCALITY	POINT REPRESENTING A LOCALITY

ADDRESS_DEFAULT_GEOCODE

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
ADDRESS_DEFAULT_GEOCODE_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			A_D_G_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
ADDRESS_DETAIL_PID	varchar2(15)	Persistent identifier from the ADDRESS_DETAIL table.	N	Y	ADDRESS_DETAIL	ADDRESS_DETAIL_PID	ADD_DT_PID
GEOCODE_TYPE_CODE	varchar2(4)	Unique abbreviation for the geocode type.	N	Y	GEOCODE_TYPE_AUT	CODE	GCTYP_CODE
GEOMETRY	point	Point geometry – calculated by the longitude/ latitude of record (not part of the product).	N	Y			GEOMETRY
LONGITUDE	number(11,8)	Longitude.	N	N			LONGITUDE
LATITUDE	number(10,8)	Latitude.	N	N			LATITUDE

GEOCODE_LEVEL_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	number(2)	Stores the level geocoded code for each address (e.g. 1).	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the geocode level type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(70)	Description of geocode level type code.	N	N			DSCPN_AUT

GEOCODE_LEVEL_TYPE_AUT CODES

CODE	Description
0	000 = (No geocode)
1	001 = (No Locality geocode, No Street geocode, Address geocode)
2	010 = (No Locality geocode, Street geocode, No Address geocode)
3	011 = (No Locality geocode, Street geocode, Address geocode)
4	100 = (Locality geocode, No Street geocode, No Address geocode)
5	101 = (Locality geocode, No Street geocode, Address geocode)
6	110 = (Locality geocode, Street geocode, No Address geocode)
7	111 = (Locality geocode, Street geocode, Address geocode)

LEVEL_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(4)	Level type. Field length: up to four alphanumeric characters (AS4590:2006 5.5.2.1). This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the level type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(30)	Description of level type code.	N	N			DSCPN_AUT

LEVEL_TYPE_AUT CODES

CODE	NAME
B	BASEMENT
FL	FLOOR
G	GROUND
P	PARKING
PTHS	PENTHOUSE
PDM	PODIUM
L	LEVEL
LB	LOBBY
LG	LOWER GROUND FLOOR
M	MEZZANINE
OD	OBSERVATION DECK
PLF	PLATFORM
RT	ROOFTOP
SB	SUB-BASEMENT
UG	UPPER GROUND FLOOR

LOCALITY_CLASS_AUT

Name	Data Type	Description	Prim Key	Man	F K T	F K Col	10 Char Alias
CODE	char(1)	Locality class code. This is the persistent Identifier of the record.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the locality class code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(200)	Description of what this locality type code represents (e.g. Gazetted Locality).	N	N			DSCPN_AUT

LOCALITY_CLASS_AUT CODES

CODE	NAME	DESCRIPTION
A	ALIAS ONLY LOCALITY	ALIAS ONLY LOCALITY
D	DISTRICT	DISTRICT
G	GAZETTED LOCALITY	GAZETTED LOCALITY
H	HUNDRED	HUNDRED
I	INDIGENOUS LOCATION	Location identified in the Australian government indigenous programs and policy locations (AGIL) dataset available at https://data.gov.au
M	MANUALLY VALIDATED	MANUALLY VALIDATED
T	TOPOGRAPHIC LOCALITY	TOPOGRAPHIC LOCALITY
U	UNOFFICIAL SUBURB	UNOFFICIAL SUBURB
V	UNOFFICIAL TOPOGRAPHIC FEATURE	UNOFFICIAL TOPOGRAPHIC FEATURE

LOCALITY

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
LOCALITY_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			LOC_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
LOCALITY_NAME	varchar2(100)	The name of the locality or suburb.	N	Y			NAME
PRIMARY_POSTCODE	varchar2(4)	Required to differentiate localities of the same name within a state.	N	N			PRIM_PCODE
LOCALITY_CLASS_CODE	char(1)	Describes the class of locality (e.g. Gazetted, topographic feature etc.). Lookup to locality class.	N	Y	LOCALITY_CLASS_AUT	CODE	LOCCL_CODE
STATE_PID	varchar2(15)	State persistent identifier.	N	Y	STATE	STATE_PID	STATE_PID
GNAF_LOCALITY_PID	varchar2(15)	Internal identifier used in the management of G-NAF.	N	N			GF_LOC_PID
GNAF_RELIABILITY_CODE	number(1)	= 5 if suburb locality, else = 6. Spatial precision of the geocode expressed as number in the range, 1 (unique identification of feature) to 6 (feature associated to region i.e. postcode).	N	N	GEOCODE_RELIABILITY_AUT	CODE	GF_RL_CODE

LOCALITY_ALIAS

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
LOCALITY_ALIAS_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			LOC_AL_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
LOCALITY_PID	varchar2(15)	Locality persistent identifier.	N	Y	LOCALITY	LOCALITY_PID	LOC_PID
NAME	varchar2(100)	The alias name for the locality or suburb.	N	Y			NAME
POSTCODE	varchar2(4)	Postcode.	N	N			POSTCODE
ALIAS_TYPE_CODE	varchar2(10)	Alias type code for the locality.	N	Y	LOCALITY_ALIAS_TYPE_AUT	CODE	ALTYP_CODE
STATE_PID	varchar2(15)	State persistent identifier.	N	Y	STATE	STATE_PID	STATE_PID

LOCALITY_ALIAS_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(10)	Code (e.g. SR). This is the persistent identifier for the record.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name	N	Y			NAME_AUT
DESCRIPTION	varchar2(100)	Description of what the code means (e.g. Spatially Related).	N	N			DSCPN_AUT

LOCALITY_ALIAS_TYPE_AUT CODES

CODE	NAME
SR	SPATIALLY RELATED
SYN	SYNONYM

LOCALITY_NEIGHBOUR

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
LOCALITY_NEIGHBOUR_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			LOC_NB_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
LOCALITY_PID	varchar2(15)	Locality persistent identifier.	N	Y	LOCALITY	LOCALITY_PID	LOC_PID
NEIGHBOUR_LOCALITY_PID	varchar2(15)	The neighbour locality persistent identifier.	N	Y	LOCALITY	LOCALITY_PID	NB_LOC_PID

LOCALITY_POINT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
LOCALITY_POINT_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			LC_PNT_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
LOCALITY_PID	varchar2(15)	Locality persistent identifier.	N	Y	LOCALITY	LOCALITY_PID	LOC_PID
PLANIMETRIC_ACCURACY	number(12)	Planimetric accuracy of geocode (if known).	N	N			PLANIM_ACC
GEOMETRY	point	Point geometry – calculated by the longitude/latitude of record (not part of the product).	N	Y			GEOMETRY
LONGITUDE	number(11,8)	Longitude of calculated geocode of gazetted locality.	N	Y			LONGITUDE
LATITUDE	number(10,8)	Latitude of calculated geocode of gazetted locality.	N	Y			LATITUDE

MB_2016

MB_2016_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			MB_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
MB_2016_CODE	varchar2(15)	The 2016 mesh block code.	N	Y			MB_CODE

MB_2021

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
MB_2021_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			MB_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE

STREET_CLASS_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	char(1)	Street class code. This is the persistent Identifier of the record.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the street class code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(200)	Description of what this street class code represents (e.g. Gazetted Street, Unconfirmed Street).	N	N			DSCPN_AUT

STREET_CLASS_AUT CODES

Code	Name	Description
C	CONFIRMED	A confirmed street is present in the roads data of the Geoscape Roads product for the same release.
U	UNCONFIRMED	An unconfirmed street is NOT present in the roads data of the Geoscape Roads product for the same release and will not have a street locality geocode.

STREET_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(15)	Street type in full text (e.g. AVENUE, PARADE, STREET) This is the persistent identifier (AS4590:2006 5.9.2).	Y	Y			CODE_AUT
NAME	varchar2(50)	Street type as an abbreviation (e.g. AV, PDE, ST), based on AS4590 road types, where applicable.	N	Y			NAME_AUT
DESCRIPTION	varchar2(15)	Street type as an abbreviation (e.g. AV, PDE, ST), based on AS4590 road types, where applicable.	N	N			DSCPN_AUT

Note

The usage of the code, name and description is intentional (i.e. full text street type is used for the code) due to the initial development of the model and the dependencies at the time of developing the integrated data model. Ideally this table should be changed, but there are no current plans to change due to the impact for users on changing the model.

Note

Note: the list of street types may not necessarily have G-NAF addresses, the list of codes are mainly derived from the roads data (Geoscape’s Roads product) and in some cases there are roads with no addresses. There are some additional street types not listed in the AS4590 (road abbreviations) that are due to the reasons explained, but also due to the street types provided by the contributors.

STREET_TYPE_AUT CODES

CODE	NAME		CODE	NAME		CODE	NAME
ACCESS	ACCS		ESTATE	EST		POINT	PNT
ACRE	ACRE		EXPRESSWAY	EXP		PORT	PORT
AIRWALK	AWLK		EXTENSION	EXTN		PRECINCT	PREC
ALLEY	ALLY		FAIRWAY	FAWY		PROMENADE	PROM
ALLEYWAY	ALWY		FIREBREAK	FBRK		PURSUIT	PRST
AMBLE	AMBL		FIRELINE	FLNE		QUAD	QUAD
ANNEX	ANNEX		FIRETRACK	FTRK		QUADRANT	QDRT
APPROACH	APP		FIRETRAIL	FITR		QUAY	QY
ARCADE	ARC		FLAT	FLAT		QUAYS	QYS
ARTERIAL	ARTL		FLATS	FLTS		RAMBLE	RMBL
ARTERY	ARTY		FOLLOW	FOLW		RAMP	RAMP
AVENUE	AV		FOOTWAY	FTWY		RANGE	RNGE
BANAN	BA		FORD	FORD		REACH	RCH
BANK	BANK		FORESHORE	FSHR		REEF	REEF
BAY	BAY		FORK	FORK		RESERVE	RES
BEACH	BCH		FORMATION	FORM		REST	REST
BEND	BEND		FREEWAY	FWY		RETREAT	RTT
BIDI	BIDI		FRONT	FRNT		RETURN	RTN
BOARDWALK	BWLK		FRONTAGE	FRTG		RIDE	RIDE
BOULEVARD	BVD		GAP	GAP		RIDGE	RDGE
BOULEVARDE	BVDE		GARDEN	GDN		RIGHT OF WAY	ROFW
BOUNDARY	BDY		GARDENS	GDNS		RING	RING
BOWL	BOWL		GATE	GTE		RISE	RISE
BRACE	BR		GATEWAY	GWY		RISING	RSNG
BRAE	BRAE		GLADE	GLDE		RIVER	RVR
BRANCH	BRAN		GLEN	GLEN		ROAD	RD
BREAK	BRK		GRANGE	GRA		ROADS	RDS
BRETT	BRET		GREEN	GRN		ROADWAY	RDWY
BRIDGE	BDGE		GROVE	GR		ROTARY	RTY
BROADWALK	BRDWLK		GULLY	GLY		ROUND	RND
BROADWAY	BDWY		HARBOUR	HRBR		ROUTE	RTE
BROW	BROW		HAVEN	HVN		ROW	ROW
BULL	BULL		HEATH	HTH		ROWE	ROWE
BUSWAY	BSWY		HEIGHTS	HTS		RUE	RUE
BYPASS	BYPA		HIGHROAD	HIRD		RUN	RUN
BYWAY	BYWY		HIGHWAY	HWY		SERVICEWAY	SVWY
CAUSEWAY	CSWY		HIKE	HIKE		SHUNT	SHUN
CENTRE	CTR		HILL	HILL		SIDING	SDNG
CENTREWAY	CNWY		HILLS	HILLS		SKYLINE	SKLN
CHASE	CH		HOLLOW	HLLW		SLOPE	SLPE
CIRCLE	CIR		HUB	HUB		SOUTH	STH
CIRCLET	CLT		INLET	INLT		SPUR	SPUR
CIRCUIT	CCT		INTERCHANGE	INTG		SQUARE	SQ
CIRCUS	CRCS		ISLAND	ID		STEPS	STPS
CLOSE	CL		JUNCTION	JNC		STRAIGHT	STRT
CLUSTER	CLR		KEY	KEY		STRAIT	STAI
COLONNADE	CLDE		KEYS	KEYS		STRAND	STRA
COMMON	CMMN		KNOLL	KNOL		STREET	ST
COMMONS	CMMNS		LADDER	LADR		STRIP	STRP
CONCORD	CNCD		LANDING	LDG		SUBWAY	SBWY
CONCOURSE	CON		LANE	LANE		TARN	TARN
CONNECTION	CNTN		LANEWAY	LNWY		TERRACE	TCE
CONNECTOR	CONR		LEAD	LEAD		THOROUGHFARE	THFR
COPSE	CPS		LEADER	LEDR		THROUGHWAY	THRU
CORNER	CNR		LINE	LINE		TOLLWAY	TLWY
CORSO	CSO		LINK	LINK		TOP	TOP
COURSE	CRSE		LINKWAY	LNKWAY		TOR	TOR
COURT	CT		LOOKOUT	LKT		TRACK	TRK
COURTYARD	CTYD		LOOP	LOOP		TRAIL	TRL
COVE	COVE		LYNNE	LYNN		TRAMWAY	TMWY
CRESCENT	CR		MALL	MALL		TRAVERSE	TVSE
CREST	CRST		MANOR	MANR		TRIANGLE	TRIANGLE
CRIEF	CRF		MART	MART		TRUNKWAY	TKWY
CROOK	CRK		MAZE	MZ		TUNNEL	TUNL
CROSS	CRSS		MEAD	MEAD		TURN	TURN
CROSSING	CRSG		MEANDER	MNDR		TWIST	TWIST
CROSSOVER	CRVR		MEW	MEW		UNDERPASS	UPAS
CRUISEWAY	CUWY		MEWS	MEWS		VALE	VALE
CUL-DE-SAC	CSAC		MILE	MILE		VALLEY	VLLY
CUT	CUT		MOTORWAY	MTWY		VERGE	VERGE
CUTTING	CUTT		NEST	NEST		VIADUCT	VIAD
DALE	DALE		NOOK	NOOK		VIEW	VIEW
DASH	DASH		NORTH	NTH		VIEWS	VWS
DELL	DELL		OUTLET	OTLT		VILLA	VLLA
DENE	DENE		OUTLOOK	OTLK		VILLAGE	VLGE
DEVIATION	DE		OVAL	OVAL		VILLAS	VLLS
DIP	DIP		PALMS	PLMS		VISTA	VSTA
DISTRIBUTOR	DSTR		PARADE	PDE		VUE	VUE
DIVIDE	DIV		PARADISE	PRDS		WADE	WADE
DOCK	DOCK		PARK	PARK		WALK	WALK
DOMAIN	DOM		PARKWAY	PWY		WALKWAY	WKWY
DOWN	DOWN		PART	PART		WATERS	WTRS
DOWNS	DWNS		PASS	PASS		WATERWAY	WTWY
DRIVE	DR		PASSAGE	PSGE		WAY	WAY
DRIVEWAY	DVWY		PATH	PATH		WEST	WEST
EASEMENT	ESMT		PATHWAY	PWAY		WHARF	WHRF
EAST	EAST		PENINSULA	PSLA		WOOD	WD
EDGE	EDGE		PERCH	PRCH		WOODS	WDS
ELBOW	ELB		PIAZZA	PIAZ		WYND	WYND
END	END		PLACE	PL		YARD	YARD
ENTRANCE	ENT		PLAZA	PLZA		YARDS	YARDS
ESPLANADE	ESP		POCKET	PKT

STREET_LOCALITY

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
STREET_LOCALITY_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			ST_LOC_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
STREET_CLASS_CODE	char(1)	Defines whether this street represents a confirmed or unconfirmed street.	N	Y	STREET_CLASS_AUT	CODE	STCLS_CODE
STREET_NAME	varchar2(100)	Street name. e.g. “POPLAR”.	N	Y			NAME
STREET_TYPE_CODE	varchar2(15)	The street type code. e.g. “PLACE”.	N	N	STREET_TYPE_AUT	CODE	STTYP_CODE
STREET_SUFFIX_CODE	varchar2(15)	The street suffix code. e.g. “WEST”.	N	N	STREET_SUFFIX_AUT	CODE	STSFX_CODE
LOCALITY_PID	varchar2(15)	The locality persistent identifier.	N	Y	LOCALITY	LOCALITY_PID	LOC_PID
GNAF_STREET_PID	varchar2(15)	Internal identifier used in the management of G-NAF.	N	N			GF_ST_PID
GNAF_STREET_CONFIDENCE	number(1)	The street confidence level.	N	N			GNAF_S_CNF
GNAF_RELIABILITY_CODE	number(1)	Always = 4. Spatial precision of the geocode expressed as number in the range, 1 (unique identification of feature) to 6 (feature associated to region i.e. postcode).	N	N	GEOCODE_RELIABILITY_AUT	CODE	GF_RL_CODE

STREET_LOCALITY_POINT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
STREET_LOCALITY_POINT_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			SL_PNT_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
STREET_LOCALITY_PID	varchar2(15)	Street locality persistent identifier.	N	Y	STREET_LOCALITY	STREET_LOCALITY_PID	ST_LOC_PID
BOUNDARY_EXTENT	number(7)	Boundary extent is defined as the straight-line distance from the street centroid to the furthest centreline point on the street segment. The value of the street boundary extent will be expressed in km.	N	N			BNDRY_EXT
PLANIMETRIC_ACCURACY	number(12)	Planimetric accuracy of geocode (if known).	N	N			PLANIM_ACC
GEOMETRY	point	Point geometry – calculated by the longitude/latitude of record (not part of the product).	N	Y			GEOMETRY
LONGITUDE	number(11,8)	Longitude of programmatically calculated centroid of street centreline within the gazetted locality.	N	Y			LONGITUDE
LATITUDE	number(10.8)	Latitude of programmatically calculated centroid of street centreline within the gazetted locality.	N	Y			LATITUDE

STREET_LOCALITY_ALIAS

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
STREET_LOCALITY_ALIAS_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			SL_ALI_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
STREET_LOCALITY_PID	varchar2(15)	Street locality persistent identifier.	N	Y	STREET_LOCALITY	STREET_LOCALITY_PID	ST_LOC_PID
STREET_NAME	varchar2(100)	The street alias name. e.g. “POPLAR”.	N	Y			NAME
STREET_TYPE_CODE	varchar2(15)	The street type code. e.g. “PLACE”	N	N	STREET_TYPE_AUT	CODE	STTYP_CODE
STREET_SUFFIX_CODE	varchar2(15)	The street suffix code. e.g. “WEST”	N	N	STREET_SUFFIX_AUT	CODE	STSFX_CODE
ALIAS_TYPE_CODE	varchar2(10)	The alias type code.	N	Y	STREET_LOCALITY_ALIAS_TYPE_AUT	CODE	ALTYP_CODE

STREET_LOCALITY_ALIAS_TYPE_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(10)	Street class code. This is the persistent Identifier of the record.	Y	Y			CODE_AUT
NAME	varchar2(50)	Name of the street locality alias type code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(15)	Description of what this street type code represents (e.g. Gazetted Street, Unconfirmed Street).	N	N			DSCPN_AUT

STREET_LOCALITY_ALIAS_TYPE_AUT CODES

CODE	NAME
ALT	ALTERNATIVE
SYN	SYNONYM

STREET_SUFFIX_AUT

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
CODE	varchar2(15)	Code (e.g. “WEST” or “W”).(AS4590:2006 5.9.3). This is the persistent identifier.	Y	Y			CODE_AUT
NAME	varchar2(50)	The name of the street suffix code.	N	Y			NAME_AUT
DESCRIPTION	varchar2(30)	Description of street suffix code.	N	N			DSCPN_AUT

STREET_SUFFIX_AUT CODES

CODE	NAME		CODE	NAME
CN	CENTRAL		SE	SOUTH EAST
DE	DEVIATION		SW	SOUTH WEST
E	EAST		UP	UPPER
EX	EXTENSION		W	WEST
LR	LOWER		IN	INNER
ML	MALL		OF	OFF
N	NORTH		ON	ON
NE	NORTH EAST		OP	OVERPASS
NW	NORTH WEST		OT	OUTER
S	SOUTH

STATE

Name	Data Type	Description	Prim Key	Man	F K TABLE	F K Col	10 Char Alias
STATE_PID	varchar2(15)	The Persistent Identifier is unique to the real world feature this record represents.	Y	Y			STATE_PID
DATE_CREATED	date	Date this record was created.	N	Y			DT_CREATE
DATE_RETIRED	date	Date this record was retired.	N	N			DT_RETIRE
STATE_NAME	varchar2(50)	The state or territory name. All in uppercase. E.g. TASMANIA.	N	Y			STATE_NAME
STATE_ABBREVIATION	varchar2(3)	The state or territory abbreviation.	N	Y			ST_ABBREV

APPLIED GEOCODE PRIORITY ORDER

GEOCODE_TYPE_AUT NAME	PRIORITY ORDER	DESCRIPTION
BUILDING ACCESS POINT	1	Point of access to the building
FRONT DOOR ACCESS	2	Front door of building
BUILDING CENTROID	3	Point within the boundaries of a building that is often derived visually using imagery. However the point shall lie within the bounded polygon (e.g. for U shaped building).
UNIT CENTROID MANUAL	4	A centroid manually placed within the bounded polygon of the unit
UNIT CENTROID	5	Geometrically defined centre of unit. The point has to lie within the bounded polygon (e.g. for U shaped unit)
PROPERTY ACCESS POINT SETBACK	6	A point set back from the (centre of the) access point at the road frontage of the property. The setback should be specified]
EMERGENCY ACCESS	7	Specific building or property access point for emergency services
EMERGENCY ACCESS SECONDARY	8	Specific building or property secondary access point for emergency services
FRONTAGE CENTRE SETBACK	9	A point setback from the centre of the road frontage within an address site. The setback should be specified.
DRIVEWAY FRONTAGE	10	Centre of driveway on address site frontage
PROPERTY ACCESS POINT	11	Access point (centre of) at the road frontage of the property
FRONTAGE CENTRE	12	Point on the centre of the address site frontage
PROPERTY CENTROID MANUAL	13	A point manually placed within a property usually where the geometrically defined position would result in relative location issues such as being in the incorrect administrative in the case of large properties.
PROPERTY CENTROID	14	Geometrically defined centre of parcels making up a property. However the point shall lie within the bounded polygon (e.g. for U shaped property).
TELEPHONE CONNECTION POINT	15	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
INTERNET CONNECTION POINT	16	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
ELECTRICITY METER	17	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
GAS METER	18	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
WATER METER	19	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
LETTERBOX	20	The mailbox
ELECTRICITY CONNECTION POINT	21	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
GAS CONNECTION POINT	22	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
WATER CONNECTION POINT	23	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
SEWERAGE CONNECTION POINT	24	The utility meter (e.g. box, or underground chamber). ‘Service type’ to be specified (e.g. water, electricity, gas, telephone)
CENTRE-LINE DROPPED FRONTAGE	25	A point on the road centreline opposite the centre of the road frontage of an address site
GAP GEOCODE	26	A geocode created programmatically based on address ranging in the absence of a geocode being allocated to a specific property. This geocode may not necessarily lie within a property polygon.
UNKNOWN	27	The approach to the allocation of the geocode location is not known.
STREET - LOCALITY	28	A geocode created for the centre of a street segment located within a particular locality.
LOCALITY	29	A geocode created approximately in the centre of the bounding area of the locality.