ASP: Street (Deprecated)

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,