Name: AssetManagementDataStandard_RouteName

Display Field:

Type: Table

Description: <div style="text-align:Left;"><div><div><p><span>The Asset Management Data Standard (AMDS) Network Model Route Names dataset contains the Route Naming as part of the base network model data for New Zealand, sourced from various Road Controlling Authority (RCA) Asset Management Systems, Land Information New Zealand (LINZ) and KiwiRail.</span></p><p><span>This is related to the AMDS Network Model (Network Element) Segment table as a many to many (M:M). This allows for multi names to be recorded against any given centreline segment. Names could include but not limited to: Route Names, Authorised Names, Operational Names, or Alternative Names.</span></p><p><span>The Route names provides Full and Abbreviated Names which are generated using a specific naming conventions defined by the Road Name Group, which is evaluated as an expression of its parts, such as:</span></p><p><span>- An expression for a Route Name could be: Route Number + Route Alpha + (Body2)</span></p><p><span>- An expression for an Authorised Name could be: Prefix + Body + Type + Suffix</span></p><p><span>It is expected that Names may contain macrons. A macron is type of special character used for some languages. In the Māori language, a macron is a line that appears over Māori vowels, such as a, e, i, o, u. Example: ā, Ā, ē, Ē, ī, Ī, ō, Ō, ū, Ū.</span></p><p><span>Non-Spatial (aspatial) data is to be provided in UTF-8 format. To support customers of the AMDS Network Model datasets and enable backwards compatibility, additional fields are provided in this dataset that will contain ASCII format data.</span></p><p style="margin:0;"><span><strong>Data/Schema Update Frequency</strong></span></p><p style="margin:0;"><span>Data Update Frequency: Dependent on Data Managing Organisation</span></p><p style="margin:0;"><span>Schema Revised: October 2025</span></p><p style="margin:0;"><span>Published: October 2025</span></p></div></div></div>

Copyright Text: New Zealand Transport Agency Waka Kotahi, KiwiRail, Land Information New Zealand and Controlling Authorities.

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• amdsIDRouteName (type: esriFieldTypeString, alias: AMDS ID Route Name, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• dataManagingOrganisation (type: esriFieldTypeSmallInteger, alias: Data Managing Organisation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Waka Kotahi NZ Transport Agency], [2: Department of Conservation], [33: Ashburton District Council], ... 114 more ...)
• routeGroup (type: esriFieldTypeSmallInteger, alias: Route Group, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Busway], [4: Pathway], [5: Railway], ... 4 more ...)
• routeNumber1 (type: esriFieldTypeSmallInteger, alias: Route Number 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• routeAlpha1 (type: esriFieldTypeString, alias: Route Alpha 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• namePrefix (type: esriFieldTypeSmallInteger, alias: Name Prefix, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Back], [2: Front], [3: Lower], ... 5 more ...)
• nameBody1 (type: esriFieldTypeString, alias: Name Body 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nameType (type: esriFieldTypeSmallInteger, alias: Name Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Access], [2: Access Road], [3: Alley], ... 85 more ...)
• nameSuffix (type: esriFieldTypeSmallInteger, alias: Name Suffix, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Central], [2: East], [3: Extension], ... 5 more ...)
• nameBody2 (type: esriFieldTypeString, alias: Name Body 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• isMacronated (type: esriFieldTypeSmallInteger, alias: Is Macronated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• routeNameFull (type: esriFieldTypeString, alias: Route Name Full, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• routeNameAbbreviated (type: esriFieldTypeString, alias: Route Name Abbreviated, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• routeNameFullASCII (type: esriFieldTypeString, alias: Route Name Full ASCII, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• routeNameAbbreviatedASCII (type: esriFieldTypeString, alias: Route Name Abbreviated ASCII, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• referenceStation (type: esriFieldTypeSmallInteger, alias: Reference Station, SQL Type: sqlTypeOther, nullable: true, editable: true)
• distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rampNumber (type: esriFieldTypeSmallInteger, alias: Ramp Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• interchangeNumber (type: esriFieldTypeSmallInteger, alias: Interchange Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lrsEnabled (type: esriFieldTypeSmallInteger, alias: Is LRS Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• localityName (type: esriFieldTypeSmallInteger, alias: Locality Name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ongaroto], [2: Tirau], [3: Putaruru], ... 215 more ...)
• effectiveFrom (type: esriFieldTypeDate, alias: Effective From Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• effectiveTo (type: esriFieldTypeDate, alias: Effective To Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• externalSystemName (type: esriFieldTypeString, alias: External Source Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• externalSystemGUID (type: esriFieldTypeString, alias: External System GUID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• routeNumber2 (type: esriFieldTypeSmallInteger, alias: Route Number 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• routeAlpha2 (type: esriFieldTypeString, alias: Route Alpha 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• direction (type: esriFieldTypeSmallInteger, alias: Direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Increasing], [2: Decreasing], [3: Westbound], ... 7 more ...)
• rampType (type: esriFieldTypeSmallInteger, alias: Ramp Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Off], [2: On], [3: Off/On])
• routeSubGroup (type: esriFieldTypeSmallInteger, alias: Route Sub Group, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Accessway], [4: Bus], [5: Carpark], ... 27 more ...)
• includeLocalityInName (type: esriFieldTypeSmallInteger, alias: Include Locality in name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• authorisedAlternative (type: esriFieldTypeSmallInteger, alias: Authorised/Alternative, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Authorised], [2: Alternative])
• status (type: esriFieldTypeSmallInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Current], [2: Retired], [3: Future], ... 3 more ...)
• externalReference (type: esriFieldTypeString, alias: External Reference GUID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• AMDS_NetworkModel_AMDS_RouteName (10) -- Related To: AssetManagementDataStandard_NetworkModel (1)
• AMDS_RouteName_AMDS_LinearRefSysRoute (12) -- Related To: AssetManagementDataStandard_LinearRefSysRoute (7)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/5/2025 3:16:28 AM

Schema Last Edit Date: 11/5/2025 3:16:24 AM

Data Last Edit Date: 11/4/2025 6:32:01 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat