{ "currentVersion" : 12, "id" : 11, "name" : "AssetManagementDataStandard_RouteName", "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 Route Names dataset contains the Route Naming 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>This is related to the AMDS Network Model (Network Element) Segment table as a many to many (M:M). This allows for multi names to be recorded against any given centreline segment. Names could include but not limited to: Route Names, Authorised Names, Operational Names, or Alternative Names.</span></p><p><span>The Route names provides Full and Abbreviated Names which are generated using a specific naming conventions defined by the Road Name Group, which is evaluated as an expression of its parts, such as:</span></p><p><span>- An expression for a Route Name could be: Route Number + Route Alpha + (Body2)</span></p><p><span>- An expression for an Authorised Name could be: Prefix + Body + Type + Suffix</span></p><p><span>It is expected that Names may contain macrons. A macron is type of special character used for some languages. In the Māori language, a macron is a line that appears over Māori vowels, such as a, e, i, o, u. Example: ā, Ā, ē, Ē, ī, Ī, ō, Ō, ū, Ū.</span></p><p><span>Non-Spatial (aspatial) data is to be provided in UTF-8 format. To support customers of the AMDS Network Model datasets and enable backwards compatibility, additional fields are provided in this dataset that will contain ASCII format data.</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" : 10, "name" : "AMDS_NetworkModel_AMDS_RouteName", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityManyToMany", "role" : "esriRelRoleDestination", "keyField" : "amdsIDRouteName", "composite" : false, "relationshipTableId" : 13, "keyFieldInRelationshipTable" : "amdsIDRouteName" }, { "id" : 12, "name" : "AMDS_RouteName_AMDS_LinearRefSysRoute", "relatedTableId" : 7, "cardinality" : "esriRelCardinalityOneToOne", "role" : "esriRelRoleOrigin", "keyField" : "amdsIDRouteName", "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" : "amdsIDRouteName", "type" : "esriFieldTypeString", "alias" : "AMDS ID Route Name", "sqlType" : "sqlTypeOther", "length" : 512, "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" : "routeGroup", "type" : "esriFieldTypeSmallInteger", "alias" : "Route Group", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlRouteNameGroup", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What is the naming convention group for the route name?", "codedValues" : [ { "name" : "Busway", "code" : 3 }, { "name" : "Pathway", "code" : 4 }, { "name" : "Railway", "code" : 5 }, { "name" : "Roadway Local", "code" : 6 }, { "name" : "Route", "code" : 7 }, { "name" : "Roadway State Highway", "code" : 1 }, { "name" : "Waterway", "code" : 2 } ] }, "defaultValue" : "" }, { "name" : "routeNumber1", "type" : "esriFieldTypeSmallInteger", "alias" : "Route Number 1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "routeAlpha1", "type" : "esriFieldTypeString", "alias" : "Route Alpha 1", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "namePrefix", "type" : "esriFieldTypeSmallInteger", "alias" : "Name Prefix", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlRouteNamePrefix", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "A component of the route name shown before the name body that may consist of qualifying terminology, a cardinal indicator or similar.", "codedValues" : [ { "name" : "Back", "code" : 1 }, { "name" : "Front", "code" : 2 }, { "name" : "Lower", "code" : 3 }, { "name" : "Mid", "code" : 4 }, { "name" : "Upper", "code" : 5 }, { "name" : "The", "code" : 6 }, { "name" : "Mount", "code" : 7 }, { "name" : "Saint", "code" : 8 } ] }, "defaultValue" : "" }, { "name" : "nameBody1", "type" : "esriFieldTypeString", "alias" : "Name Body 1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "nameType", "type" : "esriFieldTypeSmallInteger", "alias" : "Name Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlRouteNameType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What type of route name is this (i.e. road, street, avenue, line etc.)?", "codedValues" : [ { "name" : "Access", "code" : 1 }, { "name" : "Access Road", "code" : 2 }, { "name" : "Alley", "code" : 3 }, { "name" : "Arcade", "code" : 4 }, { "name" : "Avenue", "code" : 5 }, { "name" : "Bay", "code" : 6 }, { "name" : "Belt", "code" : 7 }, { "name" : "Bend", "code" : 8 }, { "name" : "Boulevard", "code" : 9 }, { "name" : "Brae", "code" : 10 }, { "name" : "Bridge", "code" : 11 }, { "name" : "Bypass", "code" : 12 }, { "name" : "Circle", "code" : 13 }, { "name" : "Close", "code" : 14 }, { "name" : "Common", "code" : 15 }, { "name" : "Court", "code" : 16 }, { "name" : "Courts", "code" : 17 }, { "name" : "Cove", "code" : 18 }, { "name" : "Crescent", "code" : 19 }, { "name" : "Crest", "code" : 20 }, { "name" : "Dell", "code" : 21 }, { "name" : "Downs", "code" : 22 }, { "name" : "Drive", "code" : 23 }, { "name" : "End", "code" : 24 }, { "name" : "Esplanade", "code" : 25 }, { "name" : "Express", "code" : 1002 }, { "name" : "Expressway", "code" : 26 }, { "name" : "Gardens", "code" : 27 }, { "name" : "Gate", "code" : 28 }, { "name" : "Glade", "code" : 29 }, { "name" : "Glen", "code" : 30 }, { "name" : "Green", "code" : 31 }, { "name" : "Greens", "code" : 32 }, { "name" : "Grove", "code" : 33 }, { "name" : "Haven", "code" : 34 }, { "name" : "Heights", "code" : 35 }, { "name" : "Highway", "code" : 36 }, { "name" : "Hill", "code" : 37 }, { "name" : "Island", "code" : 1001 }, { "name" : "Key", "code" : 38 }, { "name" : "Landing", "code" : 39 }, { "name" : "Lane", "code" : 40 }, { "name" : "Line", "code" : 41 }, { "name" : "Link", "code" : 42 }, { "name" : "Loop", "code" : 43 }, { "name" : "Loop Road", "code" : 44 }, { "name" : "Mall", "code" : 45 }, { "name" : "Mews", "code" : 46 }, { "name" : "Mile", "code" : 47 }, { "name" : "Motorway", "code" : 48 }, { "name" : "Oaks", "code" : 49 }, { "name" : "Paddock", "code" : 50 }, { "name" : "Parade", "code" : 51 }, { "name" : "Park", "code" : 52 }, { "name" : "Parkway", "code" : 53 }, { "name" : "Pass", "code" : 54 }, { "name" : "Place", "code" : 55 }, { "name" : "Point", "code" : 56 }, { "name" : "Promenade", "code" : 57 }, { "name" : "Quay", "code" : 58 }, { "name" : "Range", "code" : 1003 }, { "name" : "Ridge", "code" : 59 }, { "name" : "Rise", "code" : 60 }, { "name" : "Road", "code" : 61 }, { "name" : "Roadway", "code" : 62 }, { "name" : "Row", "code" : 63 }, { "name" : "Side Road", "code" : 64 }, { "name" : "Spur", "code" : 65 }, { "name" : "Square", "code" : 66 }, { "name" : "Steps", "code" : 67 }, { "name" : "Straight", "code" : 1005 }, { "name" : "Strand", "code" : 68 }, { "name" : "Street", "code" : 69 }, { "name" : "Terrace", "code" : 70 }, { "name" : "Town", "code" : 1004 }, { "name" : "Track", "code" : 71 }, { "name" : "Vale", "code" : 72 }, { "name" : "Valley", "code" : 73 }, { "name" : "View", "code" : 74 }, { "name" : "Views", "code" : 75 }, { "name" : "Vista", "code" : 76 }, { "name" : "Walk", "code" : 77 }, { "name" : "Way", "code" : 78 }, { "name" : "Wharf", "code" : 79 }, { "name" : "Not Applicable", "code" : 0 }, { "name" : "Rue", "code" : 1006 }, { "name" : "Rue De", "code" : 1007 }, { "name" : "Rue De La", "code" : 1008 } ] }, "defaultValue" : "" }, { "name" : "nameSuffix", "type" : "esriFieldTypeSmallInteger", "alias" : "Name Suffix", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlRouteNameSuffix", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "A component of the route name shown after the name body that may consist of qualifying terminology, a cardinal indicator or similar.", "codedValues" : [ { "name" : "Central", "code" : 1 }, { "name" : "East", "code" : 2 }, { "name" : "Extension", "code" : 3 }, { "name" : "Lower", "code" : 4 }, { "name" : "North", "code" : 5 }, { "name" : "South", "code" : 6 }, { "name" : "Upper", "code" : 7 }, { "name" : "West", "code" : 8 } ] }, "defaultValue" : "" }, { "name" : "nameBody2", "type" : "esriFieldTypeString", "alias" : "Name Body 2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "isMacronated", "type" : "esriFieldTypeSmallInteger", "alias" : "Is Macronated", "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" : 0 }, { "name" : "routeNameFull", "type" : "esriFieldTypeString", "alias" : "Route Name Full", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "routeNameAbbreviated", "type" : "esriFieldTypeString", "alias" : "Route Name Abbreviated", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "routeNameFullASCII", "type" : "esriFieldTypeString", "alias" : "Route Name Full ASCII", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "routeNameAbbreviatedASCII", "type" : "esriFieldTypeString", "alias" : "Route Name Abbreviated ASCII", "sqlType" : "sqlTypeOther", "length" : 512, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "referenceStation", "type" : "esriFieldTypeSmallInteger", "alias" : "Reference Station", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "distance", "type" : "esriFieldTypeDouble", "alias" : "Distance", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "rampNumber", "type" : "esriFieldTypeSmallInteger", "alias" : "Ramp Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "interchangeNumber", "type" : "esriFieldTypeSmallInteger", "alias" : "Interchange Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "lrsEnabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Is LRS Enabled", "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" : 0 }, { "name" : "localityName", "type" : "esriFieldTypeSmallInteger", "alias" : "Locality Name", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlLocalityName", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What is the name of the locality?", "codedValues" : [ { "name" : "Ongaroto", "code" : 1 }, { "name" : "Tirau", "code" : 2 }, { "name" : "Putaruru", "code" : 3 }, { "name" : "Tokoroa", "code" : 4 }, { "name" : "Arapuni", "code" : 5 }, { "name" : "Akaroa", "code" : 6 }, { "name" : "Bishopdale", "code" : 7 }, { "name" : "Dallington", "code" : 8 }, { "name" : "Halswell", "code" : 9 }, { "name" : "Lyttelton/Mt Herbert", "code" : 10 }, { "name" : "Redwood", "code" : 11 }, { "name" : "Riccarton", "code" : 12 }, { "name" : "Wainui", "code" : 13 }, { "name" : "Wairewa", "code" : 14 }, { "name" : "Aro Valley", "code" : 15 }, { "name" : "Berhampore", "code" : 16 }, { "name" : "Breaker Bay", "code" : 17 }, { "name" : "Broadmeadows", "code" : 18 }, { "name" : "Brooklyn", "code" : 19 }, { "name" : "Churton Park", "code" : 20 }, { "name" : "Crofton Downs", "code" : 21 }, { "name" : "Glenside", "code" : 22 }, { "name" : "Grenada North", "code" : 23 }, { "name" : "Grenada Village", "code" : 24 }, { "name" : "Hataitai", "code" : 25 }, { "name" : "Highbury", "code" : 26 }, { "name" : "Horokiwi", "code" : 27 }, { "name" : "Houghton Bay", "code" : 28 }, { "name" : "Island Bay", "code" : 29 }, { "name" : "Johnsonville", "code" : 30 }, { "name" : "Kaiwharawhara", "code" : 31 }, { "name" : "Karaka Bays", "code" : 32 }, { "name" : "Karori", "code" : 33 }, { "name" : "Kelburn", "code" : 34 }, { "name" : "Khandallah", "code" : 35 }, { "name" : "Kilbirnie", "code" : 36 }, { "name" : "Kingston", "code" : 37 }, { "name" : "Lyall Bay", "code" : 38 }, { "name" : "Makara", "code" : 39 }, { "name" : "Makara Beach", "code" : 40 }, { "name" : "Maupuia", "code" : 41 }, { "name" : "Melrose", "code" : 42 }, { "name" : "Miramar", "code" : 43 }, { "name" : "Moa Point", "code" : 44 }, { "name" : "Mornington", "code" : 45 }, { "name" : "Mt Cook", "code" : 46 }, { "name" : "Mt Victoria", "code" : 47 }, { "name" : "Newlands", "code" : 48 }, { "name" : "Newtown", "code" : 49 }, { "name" : "Ngaio", "code" : 50 }, { "name" : "Ngauranga", "code" : 51 }, { "name" : "Northland", "code" : 52 }, { "name" : "Ohariu", "code" : 53 }, { "name" : "Oriental Bay", "code" : 54 }, { "name" : "Owhiro Bay", "code" : 55 }, { "name" : "Paparangi", "code" : 56 }, { "name" : "Pipitea", "code" : 57 }, { "name" : "Rongotai", "code" : 58 }, { "name" : "Roseneath", "code" : 59 }, { "name" : "Seatoun", "code" : 60 }, { "name" : "Southgate", "code" : 61 }, { "name" : "Strathmore Park", "code" : 62 }, { "name" : "Takapu Valley", "code" : 63 }, { "name" : "Tawa", "code" : 64 }, { "name" : "Te Aro", "code" : 65 }, { "name" : "Thorndon", "code" : 66 }, { "name" : "Vogeltown", "code" : 67 }, { "name" : "Wadestown", "code" : 68 }, { "name" : "Wellington Central", "code" : 69 }, { "name" : "Wilton", "code" : 70 }, { "name" : "Woodridge", "code" : 71 }, { "name" : "Arero", "code" : 72 }, { "name" : "Awapuni", "code" : 73 }, { "name" : "Bushmere", "code" : 74 }, { "name" : "Elgin", "code" : 75 }, { "name" : "Gisborne Central", "code" : 76 }, { "name" : "Hangaroa", "code" : 77 }, { "name" : "Hicks Bay", "code" : 78 }, { "name" : "Inner Kaiti", "code" : 79 }, { "name" : "Kaiti", "code" : 80 }, { "name" : "Kanakanaia", "code" : 81 }, { "name" : "Makaraka", "code" : 82 }, { "name" : "Mangapapa", "code" : 83 }, { "name" : "Mangatu", "code" : 84 }, { "name" : "Matawai", "code" : 85 }, { "name" : "Matawhero", "code" : 86 }, { "name" : "Motu", "code" : 87 }, { "name" : "Okitu", "code" : 88 }, { "name" : "Ormond", "code" : 89 }, { "name" : "Patutahi", "code" : 90 }, { "name" : "Poututu", "code" : 91 }, { "name" : "Puha", "code" : 92 }, { "name" : "Rakauroa", "code" : 93 }, { "name" : "Riverdale", "code" : 94 }, { "name" : "Ruatoria", "code" : 95 }, { "name" : "Te Araroa", "code" : 96 }, { "name" : "Te Hapara", "code" : 97 }, { "name" : "Te Karaka", "code" : 98 }, { "name" : "Te Puia Springs", "code" : 99 }, { "name" : "Tikitiki", "code" : 100 }, { "name" : "Tiniroto", "code" : 101 }, { "name" : "Tokomaru Bay", "code" : 102 }, { "name" : "Tolaga Bay", "code" : 103 }, { "name" : "Waerengaahika", "code" : 104 }, { "name" : "Waihirere", "code" : 105 }, { "name" : "Waipiro Bay", "code" : 107 }, { "name" : "Whatatutu", "code" : 108 }, { "name" : "Whataupoko", "code" : 109 }, { "name" : "Wairoa", "code" : 110 }, { "name" : "Wairoa Northern", "code" : 111 }, { "name" : "Wairoa Central", "code" : 112 }, { "name" : "Ruakituri", "code" : 113 }, { "name" : "Southern", "code" : 114 }, { "name" : "Frasertown", "code" : 115 }, { "name" : "Mahia Beach", "code" : 116 }, { "name" : "Mahanga", "code" : 117 }, { "name" : "Nuhaka", "code" : 118 }, { "name" : "Tuai", "code" : 119 }, { "name" : "Waikaremoana", "code" : 121 }, { "name" : "Tararua Northern", "code" : 122 }, { "name" : "Pahiatua-Woodville", "code" : 123 }, { "name" : "Eketahuna", "code" : 124 }, { "name" : "Ahuriri", "code" : 125 }, { "name" : "Awatoto", "code" : 126 }, { "name" : "Bay View", "code" : 127 }, { "name" : "Greenmeadows", "code" : 128 }, { "name" : "Jervoistown", "code" : 129 }, { "name" : "Knightsbridge", "code" : 130 }, { "name" : "Maraenui", "code" : 131 }, { "name" : "Marewa", "code" : 132 }, { "name" : "Meeanee", "code" : 133 }, { "name" : "Mission View", "code" : 134 }, { "name" : "Napier City", "code" : 135 }, { "name" : "Napier South", "code" : 136 }, { "name" : "Onekawa", "code" : 137 }, { "name" : "Onekawa Indust", "code" : 138 }, { "name" : "Pandora", "code" : 139 }, { "name" : "Parklands", "code" : 140 }, { "name" : "Pirimai", "code" : 141 }, { "name" : "Poraiti", "code" : 142 }, { "name" : "Scinde Hill", "code" : 143 }, { "name" : "Tamatea", "code" : 144 }, { "name" : "Taradale", "code" : 145 }, { "name" : "Westshore", "code" : 146 }, { "name" : "Anakiwa", "code" : 147 }, { "name" : "Anakoha", "code" : 148 }, { "name" : "Ben Morven", "code" : 149 }, { "name" : "Blenheim", "code" : 150 }, { "name" : "Bulwer", "code" : 151 }, { "name" : "Burleigh", "code" : 152 }, { "name" : "Conders Bend", "code" : 153 }, { "name" : "Dillons Point", "code" : 154 }, { "name" : "Duncan Bay", "code" : 155 }, { "name" : "Elaine Bay", "code" : 156 }, { "name" : "Flaxbourne", "code" : 157 }, { "name" : "Hallam Cove", "code" : 158 }, { "name" : "Havelock", "code" : 159 }, { "name" : "Leatham", "code" : 160 }, { "name" : "Marlborough Ridge", "code" : 161 }, { "name" : "Moetapu Bay", "code" : 162 }, { "name" : "Ngakuta Bay", "code" : 163 }, { "name" : "Okiwi Bay", "code" : 164 }, { "name" : "Old Renwick", "code" : 165 }, { "name" : "Omaka", "code" : 166 }, { "name" : "Onahau Bay", "code" : 167 }, { "name" : "Onamalutu", "code" : 168 }, { "name" : "Penzance Bay", "code" : 169 }, { "name" : "Rapaura", "code" : 170 }, { "name" : "Rarangi", "code" : 171 }, { "name" : "Renwick", "code" : 172 }, { "name" : "Riverlands Industrial", "code" : 174 }, { "name" : "Roselands", "code" : 175 }, { "name" : "Seddon", "code" : 176 }, { "name" : "Solar Heights", "code" : 177 }, { "name" : "Springlands", "code" : 178 }, { "name" : "Spy Station", "code" : 179 }, { "name" : "Taimate", "code" : 180 }, { "name" : "Tara Bay", "code" : 181 }, { "name" : "Te Towaka", "code" : 182 }, { "name" : "Tirimoana", "code" : 183 }, { "name" : "Titirangi Bay", "code" : 184 }, { "name" : "Torea Bay", "code" : 185 }, { "name" : "Tuna Bay", "code" : 186 }, { "name" : "Twidles Island", "code" : 187 }, { "name" : "Ure River", "code" : 188 }, { "name" : "Wairau", "code" : 189 }, { "name" : "Wairau Valley", "code" : 190 }, { "name" : "Wharanui", "code" : 191 }, { "name" : "Witherlea", "code" : 192 }, { "name" : "Woodbourne", "code" : 193 }, { "name" : "Arthurton", "code" : 194 }, { "name" : "Brydone", "code" : 195 }, { "name" : "Charlton", "code" : 196 }, { "name" : "Chatton", "code" : 197 }, { "name" : "Chatton North", "code" : 198 }, { "name" : "East Chatton", "code" : 199 }, { "name" : "Ferndale", "code" : 200 }, { "name" : "Gore", "code" : 201 }, { "name" : "Kaiwera", "code" : 202 }, { "name" : "Knapdale", "code" : 203 }, { "name" : "Maitland", "code" : 204 }, { "name" : "Mandeville", "code" : 205 }, { "name" : "Mataura", "code" : 206 }, { "name" : "Mcnab", "code" : 207 }, { "name" : "Otama", "code" : 208 }, { "name" : "Otama Valley", "code" : 209 }, { "name" : "Otaraia", "code" : 210 }, { "name" : "Otikerama", "code" : 211 }, { "name" : "Pukerau", "code" : 212 }, { "name" : "Te Tipua", "code" : 213 }, { "name" : "Tuturau", "code" : 214 }, { "name" : "Upper Charlton", "code" : 215 }, { "name" : "Waikaka", "code" : 216 }, { "name" : "Waikana", "code" : 217 }, { "name" : "Waimumu", "code" : 218 }, { "name" : "Wendon", "code" : 219 }, { "name" : "Wendon Valley", "code" : 220 }, { "name" : "Whiterigg", "code" : 221 } ] }, "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" : "externalSystemName", "type" : "esriFieldTypeString", "alias" : "External Source Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "externalSystemGUID", "type" : "esriFieldTypeString", "alias" : "External System GUID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "required" : true }, { "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" : "routeNumber2", "type" : "esriFieldTypeSmallInteger", "alias" : "Route Number 2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "routeAlpha2", "type" : "esriFieldTypeString", "alias" : "Route Alpha 2", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "direction", "type" : "esriFieldTypeSmallInteger", "alias" : "Direction", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlRouteNameDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The direction (or vector orientation) of the route name.", "codedValues" : [ { "name" : "Increasing", "code" : 1 }, { "name" : "Decreasing", "code" : 2 }, { "name" : "Westbound", "code" : 3 }, { "name" : "Eastbound", "code" : 4 }, { "name" : "Northbound", "code" : 5 }, { "name" : "Southbound", "code" : 6 }, { "name" : "Right Hand Side", "code" : 7 }, { "name" : "Left Hand Side", "code" : 8 }, { "name" : "Left", "code" : 9 }, { "name" : "Right", "code" : 10 } ] }, "defaultValue" : "" }, { "name" : "rampType", "type" : "esriFieldTypeSmallInteger", "alias" : "Ramp Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlRampType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "The type of ramp (OFF, ON, OFF/ON)", "codedValues" : [ { "name" : "Off", "code" : 1 }, { "name" : "On", "code" : 2 }, { "name" : "Off/On", "code" : 3 } ] }, "defaultValue" : "" }, { "name" : "routeSubGroup", "type" : "esriFieldTypeSmallInteger", "alias" : "Route Sub Group", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlRouteNameSubGroup", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What is the naming convention sub-group for the route name?", "codedValues" : [ { "name" : "Accessway", "code" : 3 }, { "name" : "Bus", "code" : 4 }, { "name" : "Carpark", "code" : 5 }, { "name" : "Cycleway", "code" : 6 }, { "name" : "Ferry", "code" : 7 }, { "name" : "Footpath", "code" : 8 }, { "name" : "Hammerhead", "code" : 9 }, { "name" : "High Level Access", "code" : 10 }, { "name" : "Line", "code" : 11 }, { "name" : "Local Road", "code" : 12 }, { "name" : "Loop", "code" : 13 }, { "name" : "Low Level Access", "code" : 14 }, { "name" : "Ramp", "code" : 16 }, { "name" : "Reference Station", "code" : 18 }, { "name" : "Reserve", "code" : 19 }, { "name" : "Roundabout", "code" : 21 }, { "name" : "Service Lane", "code" : 23 }, { "name" : "Shared Path", "code" : 24 }, { "name" : "Slip", "code" : 25 }, { "name" : "State Highway", "code" : 26 }, { "name" : "Tourist", "code" : 27 }, { "name" : "Trail", "code" : 28 }, { "name" : "Dedicated National Detour", "code" : 2 }, { "name" : "Dedicated Hazardous Material", "code" : 15 }, { "name" : "Dedicated Lifeline", "code" : 17 }, { "name" : "Walkway", "code" : 20 }, { "name" : "Toll Road", "code" : 22 }, { "name" : "High Performance Motor Vehicle", "code" : 1 }, { "name" : "Cul-De-Sac", "code" : 29 }, { "name" : "Crossing", "code" : 30 } ] }, "defaultValue" : "" }, { "name" : "includeLocalityInName", "type" : "esriFieldTypeSmallInteger", "alias" : "Include Locality in name", "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" : 0 }, { "name" : "authorisedAlternative", "type" : "esriFieldTypeSmallInteger", "alias" : "Authorised/Alternative", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlAuthorisedAlternative", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "Is the route name authorised (e.g., published through LINZ) or alternative (e.g., an operational name)?", "codedValues" : [ { "name" : "Authorised", "code" : 1 }, { "name" : "Alternative", "code" : 2 } ] }, "defaultValue" : 2 }, { "name" : "status", "type" : "esriFieldTypeSmallInteger", "alias" : "Status", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "vlStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "description" : "What is the status of this record? (current, retired, future or proposed/indicative)", "codedValues" : [ { "name" : "Current", "code" : 1 }, { "name" : "Retired", "code" : 2 }, { "name" : "Future", "code" : 3 }, { "name" : "Proposed/Indicative", "code" : 4 }, { "name" : "Under Review", "code" : 5 }, { "name" : "Under Review", "code" : 0 } ] }, "defaultValue" : 1 }, { "name" : "externalReference", "type" : "esriFieldTypeString", "alias" : "External Reference GUID", "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" : "G397amdsIDRouteN", "fields" : "amdsIDRouteName", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I397dataManaging", "fields" : "dataManagingOrganisation", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I397dataManaging_1", "fields" : "dataManagingOrganisation,externalSystemName,externalReference", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "I397routeNameFul", "fields" : "routeNameFull", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__AMDS_NET__F4B70D85B75470A1", "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" }