Name: AssetManagementDataStandard_RestrictedTurn

Display Field:

Type: Table

Description:

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)
• amdsIDNetworkModel1 (type: esriFieldTypeString, alias: AMDS ID Network Element 1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position1 (type: esriFieldTypeDouble, alias: Position 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amdsIDNetworkModel2 (type: esriFieldTypeString, alias: AMDS ID Network Element 2, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position2 (type: esriFieldTypeDouble, alias: Position 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amdsIDNetworkModel3 (type: esriFieldTypeString, alias: AMDS ID Network Element 3, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position3 (type: esriFieldTypeDouble, alias: Position 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amdsIDNetworkModel4 (type: esriFieldTypeString, alias: AMDS ID Network Element 4, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position4 (type: esriFieldTypeDouble, alias: Position 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amdsIDNetworkModel5 (type: esriFieldTypeString, alias: AMDS ID Network Element 5, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position5 (type: esriFieldTypeDouble, alias: Position 5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amdsIDNetworkModel6 (type: esriFieldTypeString, alias: AMDS ID Network Element 6, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position6 (type: esriFieldTypeDouble, alias: Position 6, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amdsIDNetworkModel7 (type: esriFieldTypeString, alias: AMDS ID Network Element 7, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position7 (type: esriFieldTypeDouble, alias: Position 7, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amdsIDNetworkModel8 (type: esriFieldTypeString, alias: AMDS ID Network Element 8, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• position8 (type: esriFieldTypeDouble, alias: Position 8, SQL Type: sqlTypeOther, nullable: true, editable: true)
• modeEmergencyRestricted (type: esriFieldTypeSmallInteger, alias: Emergency Management Services are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modeVehicleRestricted (type: esriFieldTypeSmallInteger, alias: All Other Vehicles are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modeVehicleHeavyRestricted (type: esriFieldTypeSmallInteger, alias: Vehicles that are HCVI or HCVII classified are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modePedestrianRestricted (type: esriFieldTypeSmallInteger, alias: Pedestrians are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modeCyclingRestricted (type: esriFieldTypeSmallInteger, alias: Cycles are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modeMicroModeRestricted (type: esriFieldTypeSmallInteger, alias: Micro Modes are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modeBusRestricted (type: esriFieldTypeSmallInteger, alias: Buses are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modePublicTransportRestricted (type: esriFieldTypeSmallInteger, alias: Public Transports is restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modeRailRestricted (type: esriFieldTypeSmallInteger, alias: Trains are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• modeFerryRestricted (type: esriFieldTypeSmallInteger, alias: Ferries are restricted from making this turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• 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)
• amdsIDRestrictedTurn (type: esriFieldTypeString, alias: AMDS ID Restricted Turn, SQL Type: sqlTypeOther, length: 512, 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)
• isEndOfFirstSegment (type: esriFieldTypeSmallInteger, alias: Is End of First Segment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• 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)
• status (type: esriFieldTypeSmallInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Current], [2: Retired], [3: Future], ... 3 more ...)

Relationships:

• AMDS_NetworkModel_AMDS_RestrictedTurn (8) -- Related To: AssetManagementDataStandard_NetworkModel (1)
• AMDS_NetworkModel_AMDS_RestrictedTurn2 (13) -- Related To: AssetManagementDataStandard_NetworkModel (1)

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