Roads and Addresses Data - Page 6

In June 2014, LINZ moved the information from the Authoritative Streets and Places database (ASP) into Landonline and the ASP database is no longer maintained.

This table is a lookup table identifying NZ Map Grid 1:10000 sheet references (which are a break down on the NZMG 260 map sheets).

This table is part of the Authoritative Streets and Places (ASP) Database. For more information about the database including the data model see here.

Notes:

• This table contains a static unique identifier 'id' column that is not part of the original published ASP database. This column has been added to support incremental changesets on LDS. There is a direct relationship between this column and the original primary key on the 'map_id' column.

In June 2014, LINZ moved the information from the Authoritative Streets and Places database (ASP) into Landonline and the ASP database is no longer maintained.

This table is a lookup table identifying valid record statuses.

This table is part of the Authoritative Streets and Places (ASP) Database. For more information about the database including the data model see here.

Notes:

• This table contains static unique identifier 'id' column that is not part of the original published ASP database. This column has been added to support incremental changesets on LDS. There is a direct relationship between this column and the original primary key on the 'status' column.

In June 2014, LINZ moved the information from the Authoritative Streets and Places database (ASP) into Landonline and the ASP database is no longer maintained.

This table is a lookup table identifying valid states for the unofficial field in the street and place tables. Records are set to Unofficial where it is known that the name is not recognised by the TA, or if a privately named road, or a place name missing necessary macrons.

This table is part of the Authoritative Streets and Places (ASP) Database. For more information about the database including the data model see here.

Notes:

• This table contains a static unique identifier 'id' column that is not part of the original published ASP database. This column has been added to support incremental changesets on LDS. There is a direct relationship between this column and the original primary key on the 'code' column.

In June 2014, LINZ moved the information from the Authoritative Streets and Places database (ASP) into Landonline and the ASP database is no longer maintained.

This table is a lookup table identifying valid Maori Electorates.

This table is part of the Authoritative Streets and Places (ASP) Database. For more information about the database including the data model see here.

Notes:

• This table contains a static unique identifier 'id' column that is not part of the original published ASP database. This column has been added to support incremental changesets on LDS. There is a direct relationship between this column and the original primary key on the 'code' column.

In June 2014, LINZ moved the information from the Authoritative Streets and Places database (ASP) into Landonline and the ASP database is no longer maintained.

This table allows the application to check for invalid combinations of TLA, Electorate, Maori & 260 sheet references at the time of data entry. This table is recreated every time a new set of electoral boundaries takes effect, and is subsequently updated if new valid combinations are discovered.

This table is part of the Authoritative Streets and Places (ASP) Database. For more information about the database including the data model see here.

Notes:

• This table contains a static unique identifier 'id' column that is not part of the original published ASP database. This column has been added to support incremental changesets on LDS. There is a direct relationship between this column and the original primary key on the 'combination' column.

In June 2014, LINZ moved the information from the Authoritative Streets and Places database (ASP) into Landonline and the ASP database is no longer maintained.

This table is a lookup table identifying valid LINZ Processing Centres.

This table is part of the Authoritative Streets and Places (ASP) Database. For more information about the database including the data model see here.

Notes:

• This table contains a static unique identifier 'id' column that is not part of the original published ASP database. This column has been added to support incremental changesets on LDS. There is a direct relationship between this column and the original primary key on the 'code' column.

Please read: This is the Address Range Road table and is part of the set of NZ Roads tables. The Address Range Road table provides an identifier that groups one or more Road Sections that have a non-standard address range. This currently includes roads that consist of multiple address ranges. The address range values are not held or provided as part of this dataset.

The NZ Roads dataset includes eight data tables and eleven lookup tables. The dataset has been sourced from LINZ’s NZ Roads database, a database for the management of national roads, including those managed for addressing purposes. This set of normalised tables replaces the Landonline: Road Centre Line layer and the Landonline: Road Name and Landonline: Road Name Association tables currently published on LDS.

These centrelines are required to indicate the presence of an authoritative road name. Named centrelines are not intended to represent the exact location of a road formation. Named centrelines do not indicate the presence of legal access.

For a simplified version of the data contained within these tables see NZ Roads (Addressing), which aggregates geometries based on road name, and NZ Roads Subsections (Addressing), which holds the individual geometries.

Please refer to the NZ Roads Data Dictionary for detailed metadata and information about this layer.