Name: Route Name

Display Field: routeNameFull

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 78514651d2484ab0900e19aced210bbd

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

Relationships:

• AMDSADMIN.AssetManagementDataStandard_LinearRefSysRoute (66) -- Related To: LRS Route (24)
• AMDSADMIN.AssetManagementDataStandard_NetworkModel (2) -- Related To: Connectors (4)
• AMDSADMIN.AssetManagementDataStandard_NetworkModel (11) -- Related To: Waterways (5)
• AMDSADMIN.AssetManagementDataStandard_NetworkModel (20) -- Related To: Railways (12)
• AMDSADMIN.AssetManagementDataStandard_NetworkModel (29) -- Related To: Pathways - Unformed (7)
• AMDSADMIN.AssetManagementDataStandard_NetworkModel (38) -- Related To: Pathways - Formed (8)
• AMDSADMIN.AssetManagementDataStandard_NetworkModel (47) -- Related To: Pathways - By Is Counted (13)
• AMDSADMIN.AssetManagementDataStandard_NetworkModel (56) -- Related To: Roadways (11)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata