{
 "currentVersion": 10.81,
 "cimVersion": "2.6.0",
 "id": 19,
 "name": "LRS Sequence",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "externalSystemName",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "amdsIDLinearRefSysSequence",
   "type": "esriFieldTypeString",
   "alias": "AMDS ID Linear Reference System Sequence",
   "length": 512,
   "domain": null
  },
  {
   "name": "amdsIDLinearRefSysRoute",
   "type": "esriFieldTypeString",
   "alias": "AMDS ID Linear Reference System Route",
   "length": 512,
   "domain": null
  },
  {
   "name": "amdsIDNetworkModel",
   "type": "esriFieldTypeString",
   "alias": "AMDS ID Network Element",
   "length": 512,
   "domain": null
  },
  {
   "name": "lineSequence",
   "type": "esriFieldTypeInteger",
   "alias": "Line Sequence",
   "domain": null
  },
  {
   "name": "linearRefSysElementType",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Linear Reference System Element Type",
   "domain": {
    "type": "codedValue",
    "name": "vlLinearRefSysElementType",
    "description": "What type of element is the segment within the linear reference system network?",
    "codedValues": [
     {
      "name": "Normal",
      "code": 1
     },
     {
      "name": "Increasing Divided",
      "code": 2
     },
     {
      "name": "Decreasing Divided",
      "code": 3
     },
     {
      "name": "Roundabout",
      "code": 4
     },
     {
      "name": "Ramp",
      "code": 5
     },
     {
      "name": "Slip Access",
      "code": 6
     },
     {
      "name": "Branch",
      "code": 7
     },
     {
      "name": "Hammerhead",
      "code": 8
     },
     {
      "name": "Extension",
      "code": 9
     },
     {
      "name": "Loop",
      "code": 10
     },
     {
      "name": "Cul de sac",
      "code": 11
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "dataManagingOrganisation",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Data Managing Organisation",
   "domain": {
    "type": "codedValue",
    "name": "vlDataMaintainingAuthorityName",
    "description": "What entity maintains the data for the centerline?",
    "codedValues": [
     {
      "name": "Waka Kotahi NZ Transport Agency",
      "code": 1
     },
     {
      "name": "Department of Conservation",
      "code": 2
     },
     {
      "name": "Ashburton District Council",
      "code": 33
     },
     {
      "name": "Auckland Transport",
      "code": 34
     },
     {
      "name": "Buller District Council",
      "code": 35
     },
     {
      "name": "Carterton District Council",
      "code": 36
     },
     {
      "name": "Central Hawke's Bay District Council",
      "code": 37
     },
     {
      "name": "Central Otago District Council",
      "code": 38
     },
     {
      "name": "Chatham Islands Council",
      "code": 39
     },
     {
      "name": "Christchurch City Council",
      "code": 40
     },
     {
      "name": "Clutha District Council",
      "code": 41
     },
     {
      "name": "Dunedin City Council",
      "code": 42
     },
     {
      "name": "Far North District Council",
      "code": 43
     },
     {
      "name": "Gisborne District Council",
      "code": 44
     },
     {
      "name": "Gore District Council",
      "code": 45
     },
     {
      "name": "Grey District Council",
      "code": 46
     },
     {
      "name": "Hamilton City Council",
      "code": 47
     },
     {
      "name": "Hastings District Council",
      "code": 48
     },
     {
      "name": "Hauraki District Council",
      "code": 49
     },
     {
      "name": "Horowhenua District Council",
      "code": 50
     },
     {
      "name": "Hurunui District Council",
      "code": 51
     },
     {
      "name": "Hutt City Council",
      "code": 52
     },
     {
      "name": "Invercargill City Council",
      "code": 53
     },
     {
      "name": "Kaipara District Council",
      "code": 55
     },
     {
      "name": "Kawerau District Council",
      "code": 57
     },
     {
      "name": "Mackenzie District Council",
      "code": 58
     },
     {
      "name": "Manawatu District Council",
      "code": 59
     },
     {
      "name": "Marlborough District Council",
      "code": 60
     },
     {
      "name": "Masterton District Council",
      "code": 61
     },
     {
      "name": "Matamata-Piako District Council",
      "code": 62
     },
     {
      "name": "Napier City Council",
      "code": 63
     },
     {
      "name": "Nelson City Council",
      "code": 64
     },
     {
      "name": "New Plymouth District Council",
      "code": 65
     },
     {
      "name": "Palmerston North City Council",
      "code": 68
     },
     {
      "name": "Porirua City Council",
      "code": 69
     },
     {
      "name": "Queenstown-Lakes District Council",
      "code": 70
     },
     {
      "name": "Rotorua Lakes Council",
      "code": 72
     },
     {
      "name": "Ruapehu District Council",
      "code": 73
     },
     {
      "name": "Selwyn District Council",
      "code": 74
     },
     {
      "name": "South Taranaki District Council",
      "code": 75
     },
     {
      "name": "South Waikato District Council",
      "code": 76
     },
     {
      "name": "South Wairarapa District Council",
      "code": 77
     },
     {
      "name": "Southland District Council",
      "code": 78
     },
     {
      "name": "Stratford District Council",
      "code": 79
     },
     {
      "name": "Tararua District Council",
      "code": 80
     },
     {
      "name": "Tasman District Council",
      "code": 81
     },
     {
      "name": "Tauranga City Council",
      "code": 83
     },
     {
      "name": "Thames-Coromandel District Council",
      "code": 84
     },
     {
      "name": "Timaru District Council",
      "code": 85
     },
     {
      "name": "Upper Hutt City Council",
      "code": 86
     },
     {
      "name": "Waikato District Council",
      "code": 87
     },
     {
      "name": "Waimakariri District Council",
      "code": 88
     },
     {
      "name": "Waimate District Council",
      "code": 89
     },
     {
      "name": "Wairoa District Council",
      "code": 91
     },
     {
      "name": "Waitaki District Council",
      "code": 92
     },
     {
      "name": "Waitomo District Council",
      "code": 93
     },
     {
      "name": "Wellington City Council",
      "code": 94
     },
     {
      "name": "Western Bay of Plenty District Council",
      "code": 95
     },
     {
      "name": "Westland District Council",
      "code": 96
     },
     {
      "name": "Whanganui District Council",
      "code": 98
     },
     {
      "name": "Private",
      "code": 100
     },
     {
      "name": "KiwiRail Holdings Limited",
      "code": 102
     },
     {
      "name": "Land Information New Zealand",
      "code": 103
     },
     {
      "name": "Auckland Council",
      "code": 104
     },
     {
      "name": "(NOC) CENTRAL WAIKATO",
      "code": 105
     },
     {
      "name": "(NOC) SOUTH CANTERBURY",
      "code": 106
     },
     {
      "name": "(NOC) WEST WAIKATO",
      "code": 107
     },
     {
      "name": "(NOC) BOP WEST",
      "code": 108
     },
     {
      "name": "(NOC) WEST COAST",
      "code": 109
     },
     {
      "name": "AUCK ALLIANCE (ASM)",
      "code": 110
     },
     {
      "name": "(NOC) COASTAL OTAGO",
      "code": 111
     },
     {
      "name": "(NOC) TARANAKI",
      "code": 112
     },
     {
      "name": "(NOC) Tairawhiti",
      "code": 113
     },
     {
      "name": "(NOC) NORTH CANTERBURY",
      "code": 114
     },
     {
      "name": "(NOC) WELLINGTON",
      "code": 115
     },
     {
      "name": "(NOC) MILFORD",
      "code": 116
     },
     {
      "name": "(NOC) MANAWATU-WHANGANUI",
      "code": 117
     },
     {
      "name": "(NOC) BOP EAST",
      "code": 118
     },
     {
      "name": "(NOC) TAIRAWHITI ROADS WESTERN",
      "code": 119
     },
     {
      "name": "(NOC) SOUTHLAND",
      "code": 120
     },
     {
      "name": "(NOC) OTAGO CENTRAL",
      "code": 121
     },
     {
      "name": "(NOC) NELSON-TASMAN",
      "code": 122
     },
     {
      "name": "(NOC) EAST WAIKATO",
      "code": 123
     },
     {
      "name": "(NOC) HAWKES BAY",
      "code": 124
     },
     {
      "name": "(EC) MARLBOROUGH",
      "code": 125
     },
     {
      "name": "(NOC) NORTHLAND",
      "code": 126
     },
     {
      "name": "(NOC) TAIRAWHITI ROADS NORTHERN",
      "code": 127
     },
     {
      "name": "WTA - Wellington Transport Alliance",
      "code": 128
     },
     {
      "name": "RATA - Regional Asset Technical Accord",
      "code": 129
     },
     {
      "name": "AT - Auckland Transport Alliance",
      "code": 130
     },
     {
      "name": "FN - Far North - Northland Transport Alliance",
      "code": 131
     },
     {
      "name": "NTA - Northern Transport Alliance",
      "code": 132
     },
     {
      "name": "Baseline Dataset (For Development Only)",
      "code": 101
     },
     {
      "name": "Kaikōura District Council",
      "code": 54
     },
     {
      "name": "Kāpiti Coast District Council",
      "code": 56
     },
     {
      "name": "Ōpōtiki District Council",
      "code": 66
     },
     {
      "name": "Ōtorohanga District Council",
      "code": 67
     },
     {
      "name": "Rangītikei District Council",
      "code": 71
     },
     {
      "name": "Taupō District Council",
      "code": 82
     },
     {
      "name": "Waipā District Council",
      "code": 90
     },
     {
      "name": "Whakatāne District Council",
      "code": 97
     },
     {
      "name": "Whangārei District Council",
      "code": 99
     },
     {
      "name": "Greater Wellington Regional Council",
      "code": 133
     },
     {
      "name": "Lakeland Network Ltd",
      "code": 134
     },
     {
      "name": "Watercare",
      "code": 135
     },
     {
      "name": "Ministry of Education",
      "code": 136
     },
     {
      "name": "Northland Regional Council",
      "code": 137
     },
     {
      "name": "Waikato Regional Council",
      "code": 138
     },
     {
      "name": "Bay of Plenty Regional Council",
      "code": 139
     },
     {
      "name": "Hawke's Bay Regional Council",
      "code": 140
     },
     {
      "name": "Taranaki Regional Council",
      "code": 141
     },
     {
      "name": "Horizons Regional Council",
      "code": 142
     },
     {
      "name": "Greater Wellington Regional Council",
      "code": 143
     },
     {
      "name": "West Coast Regional Council",
      "code": 144
     },
     {
      "name": "Environment Canterbury",
      "code": 145
     },
     {
      "name": "Otago Regional Council",
      "code": 146
     },
     {
      "name": "Southland Regional Council",
      "code": 147
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "lrsDirectionMatchesGeometry",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Linear Reference System Direction Matches Geometry Direction",
   "domain": {
    "type": "codedValue",
    "name": "vlBoolean",
    "description": "Yes or No options. Used for enabling modes or enabling options in supplementary tables. Depending on the Y or N there may be information required to sustain the choice.",
    "codedValues": [
     {
      "name": "Yes",
      "code": 1
     },
     {
      "name": "No",
      "code": 0
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "externalSystemName",
   "type": "esriFieldTypeString",
   "alias": "External Source Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "externalReference",
   "type": "esriFieldTypeString",
   "alias": "External Reference GUID",
   "length": 255,
   "domain": null
  },
  {
   "name": "effectiveFrom",
   "type": "esriFieldTypeDate",
   "alias": "Effective From Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "effectiveTo",
   "type": "esriFieldTypeDate",
   "alias": "Effective To Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "Created User",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "Created Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "Last Edited User",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "Last Edited Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R136_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_1744_amdsIDL",
   "fields": "amdsIDLinearRefSysRoute",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "GDB_1744_amdsIDN",
   "fields": "amdsIDNetworkModel",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_136",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_OID_136",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "IDX_LRSSeq_Route",
   "fields": "amdsIDLinearRefSysRoute,lineSequence",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IDX_LRSSeq_DMO",
   "fields": "dataManagingOrganisation",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IDX_LRSSeq_DMO_E",
   "fields": "dataManagingOrganisation,externalSystemName,externalReference",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IDX_LRSSeq_DMO_a",
   "fields": "dataManagingOrganisation,amdsIDLinearRefSysRoute",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "IDX_LRSSeq_amdsI",
   "fields": "amdsIDLinearRefSysSequence",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "AMDSADMIN.AssetManagementDataStandard_NetworkModel",
   "relatedTableId": 4,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDNetworkModel",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 12,
   "name": "AMDSADMIN.AssetManagementDataStandard_NetworkModel",
   "relatedTableId": 5,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDNetworkModel",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 21,
   "name": "AMDSADMIN.AssetManagementDataStandard_NetworkModel",
   "relatedTableId": 12,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDNetworkModel",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 30,
   "name": "AMDSADMIN.AssetManagementDataStandard_NetworkModel",
   "relatedTableId": 7,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDNetworkModel",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 39,
   "name": "AMDSADMIN.AssetManagementDataStandard_NetworkModel",
   "relatedTableId": 8,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDNetworkModel",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 48,
   "name": "AMDSADMIN.AssetManagementDataStandard_NetworkModel",
   "relatedTableId": 13,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDNetworkModel",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 57,
   "name": "AMDSADMIN.AssetManagementDataStandard_NetworkModel",
   "relatedTableId": 11,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDNetworkModel",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 65,
   "name": "AMDSADMIN.AssetManagementDataStandard_LinearRefSysRoute",
   "relatedTableId": 24,
   "role": "esriRelRoleDestination",
   "keyField": "amdsIDLinearRefSysRoute",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1707307502000
 },
 "serviceItemId": "78514651d2484ab0900e19aced210bbd"
}