ASP Street SUFI to Landonline Road Name SUFI Mappings

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

2743
39
Added
10 Feb 2015

This dataset was first added to LINZ Data Service on 10 Feb 2015.

In June 2014 the Authoritative Streets and Places (ASP) database was decommissioned, and at the same time a new Landonline SUFI was created for each unique road name / locality combination in the Landonline Road Name table.
Prior to this change the Landonline Road Name table held the ASP Street SUFI in its Locality field, and a join was made between these two tables in order to populate the Landonline Locality field with the ASP locality name prior to release on the LDS.
Following this change the Locality field in the Landonline Road Name table was updated to show the locality name as held in the ASP Street table.
This table shows the mapping between the new Landonline Road Name SUFI and the old ASP Street SUFI.
The Topo50 Road Centrelines data previously included the name_id attribute (equivalent to asp_sufi), which has now been changed to the new rna_sufi attribute (equivalent to landonline_sufi).

Table ID 52341
Data type Table
Row count 69607
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Unofficial Status (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

2093
67
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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.
Table ID 51212
Data type Table
Row count 2
Primary key code
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: TLA Codes (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

3354
177
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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 Territorial Authority Districts & Cities.

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.
Table ID 51211
Data type Table
Row count 77
Primary key code
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Street Type (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

3380
170
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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 used by the application to parse the road name field and warn the editor if it does not contain a valid street type.

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 'std_abb' column.
Table ID 51210
Data type Table
Row count 200
Primary key std_abb
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Street Part (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

3548
138
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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.


A street part record will exist for every electoral subdivision of a road/street, i.e. for every valid combination of territorial authority, general electoral, & maori electoral districts that apply to the road/street name concerned. Some times additional parts may be created for clarity e.g. if the same combination exists for disconnected parts of the same road/street name.

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 is recreated each time a new set of electoral boundaries takes effect (every 5 years). Prior to its replacement, a copy of the entire database is made and retained off-line to allow a mini Index to Places & Streets to be produced in the event of a by-election (by-elections are conducted on the same boundaries as the previous General election). The archival copy is deleted once the next General election has been held.
Table ID 51209
Data type Table
Row count 75735
Primary key id
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Street (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

8064
612
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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 contains the authoritative name assigned to a length of road. A street record will exist for every distinct length of named road. This may be split into several records if the road crosses a Territorial Authority (TA) boundary (because the TA is the naming authority), or if the road has multiple number ranges. Named roads that follow TA boundaries or meander backwards and forwards across a boundary will normally be treated as one record with multiple Street Parts.

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:

  • Some reports generated from ASP require the STREET_NAME+ LOCALITY+STATUS combination to be unique, so validation rules have been put in place enforce this.
  • The locality names currently used in the STREETS table are not ideal, and are considered a work in progress. The main function of LOCALITY in ASP is to achieve uniqueness, and where 2 streets of the same name exist, to be able to differentiate between them.
  • At the time of original conversion form the earlier Oracle database, in late 2004, the locality name was initially populated with the name of the locality in which most of the road centreline resided (based on meshblock to Place relationships held in Landonline), or where there was a relatively even split, to the closest locality. Some longer roads have had “Place to Place” locality names added e.g. “Christchurch-Kaiapoi”. We are aware that some of the names assigned are not ideal,
Table ID 51208
Data type Table
Row count 174364
Primary key id
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Status Types (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

906
62
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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.
Table ID 51207
Data type Table
Row count 2
Primary key status
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Processing Centres (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

2056
46
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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.
Table ID 51206
Data type Table
Row count 6
Primary key code
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Place Part (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

2182
82
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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 contains place part records for every electoral subdivision of a place, i.e. for every valid combination of territorial authority, general electoral, & maori electoral districts that apply to the place name concerned. Some times additional parts may be created for clarity e.g. if the same combination exists in disconnected areas covered by the same place name.

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 is recreated each time a new set of electoral boundaries takes effect (every 5 years). Prior to its replacement, a copy of the entire database is made and retained off-line to allow a mini Index to Places & Streets to be produced in the event of a by-election (by-elections are conducted on the same boundaries as the previous General election). The archival copy is deleted once the next General election has been held.
Table ID 51205
Data type Table
Row count 7671
Primary key id
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed

ASP: Place (Deprecated)

LINZ / Electoral
Licence

Creative Commons Attribution 4.0 International

You may use this work for commercial purposes.

You must attribute the creator in your own works.

4066
292
Updated
11 Oct 2015

This dataset was last updated on LINZ Data Service on 11 Oct 2015.

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 contains names that refers to a geographic area, and that can be used in lieu of, or to localise or refine, a street address.

A place record will exist for every name that is considered to fit this definition, including any alias or alternative names that also fit this definition.

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:

  • Some reports generated from ASP require the PLACE_NAME+ LOCALITY+STATUS combination to be unique, so validation rules have been put in place to enforce this.
  • The locality names currently used in the PLACES table are not ideal, and are considered a work in progress. The main function of LOCALITY in ASP is to achieve uniqueness, and where 2 places of the same name exist, to be able to differentiate between them.
Table ID 51204
Data type Table
Row count 15424
Primary key id
Services Web Feature Service (WFS), Catalog Service (CS-W), data.govt.nz Atom Feed
Results 1 to 10 of 20