{ "currentVersion" : 12, "id" : 8, "name" : "AssetManagementDataStandard_LinearRefSysSequence", "type" : "Table", "serviceItemId" : "f955c118272b462e9ce757405890b87f", "cacheMaxAge" : 30, "displayField" : "", "description" : "<div style=\"text-align:Left;\"><div><div><p><span>The Asset Management Data Standard (AMDS) Network Model Linear Referencing System (LRS) Sequence dataset contains the LRS Sequence 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>Key table for Many to Many (M:M) relationship between the base centerline geometry (AMDS Network Model Segments) and the LRS Route Name (AMDS Linear Reference System Name) as part of the AMDS Linear Referencing System.</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>", "copyrightText" : "New Zealand Transport Agency Waka Kotahi, KiwiRail, Land Information New Zealand and Controlling Authorities.", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "created_date", "creatorField" : "created_user", "editDateField" : "last_edited_date", "editorField" : "last_edited_user" }, "editingInfo" : { "lastEditDate" : 1767753168419, "schemaLastEditDate" : 1762312584054, "dataLastEditDate" : 1762237921062 }, "relationships" : [ { "id" : 3, "name" : "AMDS_LinearRefSysRoute_AMDS_LinearRefSysSequence", "relatedTableId" : 7, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "amdsIDLinearRefSysRoute", "composite" : false }, { "id" : 7, "name" : "AMDS_NetworkModel_AMDS_LinearRefSysSequence", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "amdsIDNetworkModel", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "", "required" : true }, { "name" : "amdsIDLinearRefSysSequence", "type" : "esriFieldTypeString", "alias" : "AMDS ID Linear Reference System Sequence", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "amdsIDLinearRefSysRoute", "type" : "esriFieldTypeString", "alias" : "AMDS ID Linear Reference System Route", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "amdsIDNetworkModel", "type" : "esriFieldTypeString", "alias" : "AMDS ID Network Element", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "lineSequence", "type" : "esriFieldTypeInteger", "alias" : "Line Sequence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "effectiveFrom", "type" : "esriFieldTypeDate", "alias" : "Effective From Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -2208988800000, "precision" : 1 }, { "name" : "effectiveTo", "type" : "esriFieldTypeDate", "alias" : "Effective To Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 253402214400000, "precision" : 1 }, { "name" : "created_user", "type" : "esriFieldTypeString", "alias" : "Created User", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "" }, { "name" : "created_date", "type" : "esriFieldTypeDate", "alias" : "Created Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "", "precision" : 1 }, { "name" : "last_edited_user", "type" : "esriFieldTypeString", "alias" : "Last Edited User", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "" }, { "name" : "last_edited_date", "type" : "esriFieldTypeDate", "alias" : "Last Edited Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : "", "precision" : 1 }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "required" : true }, { "name" : "linearRefSysElementType", "type" : "esriFieldTypeSmallInteger", "alias" : "Linear Reference System Element Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlLinearRefSysElementType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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 } ] }, "defaultValue" : "" }, { "name" : "externalReference", "type" : "esriFieldTypeString", "alias" : "External Reference GUID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "dataManagingOrganisation", "type" : "esriFieldTypeSmallInteger", "alias" : "Data Managing Organisation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlDataMaintainingAuthorityName", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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 } ] }, "defaultValue" : "" }, { "name" : "lrsDirectionMatchesGeometry", "type" : "esriFieldTypeSmallInteger", "alias" : "Linear Reference System Direction Matches Geometry Direction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlBoolean", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "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 } ] }, "defaultValue" : "" }, { "name" : "externalSystemName", "type" : "esriFieldTypeString", "alias" : "External Source Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G394amdsIDLinear", "fields" : "amdsIDLinearRefSysRoute", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G394amdsIDNetwor", "fields" : "amdsIDNetworkModel", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I394amdsIDLinear", "fields" : "amdsIDLinearRefSysRoute,lineSequence", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I394dataManaging", "fields" : "dataManagingOrganisation", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I394dataManaging_1", "fields" : "dataManagingOrganisation,externalSystemName,externalReference", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I394dataManaging_2", "fields" : "dataManagingOrganisation,amdsIDLinearRefSysRoute", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I394amdsIDLinear_1", "fields" : "amdsIDLinearRefSysSequence", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__AMDS_NET__F4B70D85B8FF980E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "created_dateIndex", "fields" : "created_date", "isAscending" : true, "isUnique" : false, "description" : "created_date Field index", "indexType" : "Attribute" }, { "name" : "created_userIndex", "fields" : "created_user", "isAscending" : false, "isUnique" : false, "description" : "created_user Field index", "indexType" : "Attribute" }, { "name" : "last_edited_dateIndex", "fields" : "last_edited_date", "isAscending" : true, "isUnique" : false, "description" : "last_edited_date Field index", "indexType" : "Attribute" }, { "name" : "last_edited_userIndex", "fields" : "last_edited_user", "isAscending" : false, "isUnique" : false, "description" : "last_edited_user Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" }