Name: AssetManagementDataStandard_LinearRefSysRoute

Display Field:

Type: Table

Description: <div style="text-align:Left;"><div><div><p><span>The Asset Management Data Standard (AMDS) Network Model Linear Referencing System (LRS) Route dataset contains the LRS Route 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>Table for defining the LRS Route Name and extents, as part of the AMDS Linear Referencing System. The LRS Route Name is linked to AMDS Route Name table.</span></p><p><span>Extents include Start and End Measures, and Start and End X, Y, Z coordinates or the LRS Route.</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)
• amdsIDLinearRefSysRoute (type: esriFieldTypeString, alias: AMDS ID Linear Reference System Route, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• amdsIDLinearRefSysNetwork (type: esriFieldTypeString, alias: AMDS ID Linear Reference System Network, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• linearRefSysRouteName (type: esriFieldTypeString, alias: Linear Reference System Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• minimumStartMeasure (type: esriFieldTypeDouble, alias: Minimum Start Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maximumEndMeasure (type: esriFieldTypeDouble, alias: Maximum End Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• xStart (type: esriFieldTypeDouble, alias: X Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
• xEnd (type: esriFieldTypeDouble, alias: X End, SQL Type: sqlTypeOther, nullable: true, editable: true)
• yStart (type: esriFieldTypeDouble, alias: Y Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
• yEnd (type: esriFieldTypeDouble, alias: Y End, SQL Type: sqlTypeOther, nullable: true, editable: true)
• zStart (type: esriFieldTypeDouble, alias: Z Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
• zEnd (type: esriFieldTypeDouble, alias: Z End, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• 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)
• amdsIDRouteName (type: esriFieldTypeString, alias: AMDS ID Route Name, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• externalReference (type: esriFieldTypeString, alias: External Reference GUID, SQL Type: sqlTypeOther, length: 255, 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 ...)
• externalSystemName (type: esriFieldTypeString, alias: External Source Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• AMDS_LinearRefSysNetwork_AMDS_LinearRefSysRoute (1) -- Related To: AssetManagementDataStandard_LinearRefSysNetwork (6)
• AMDS_LinearRefSysRoute_AMDS_LinearRefSysCalibration (2) -- Related To: AssetManagementDataStandard_LinearRefSysCalibration (0)
• AMDS_LinearRefSysRoute_AMDS_LinearRefSysSequence (3) -- Related To: AssetManagementDataStandard_LinearRefSysSequence (8)
• AMDS_RouteName_AMDS_LinearRefSysRoute (12) -- Related To: AssetManagementDataStandard_RouteName (11)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/7/2026 2:32:48 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