{ "currentVersion" : 12, "id" : 1, "name" : "Annual Programme of Works 2026/2027", "type" : "Feature Layer", "serviceItemId" : "49c98ba248ac4aa1b677aaa3cb74a7e3", "cacheMaxAge" : 30, "displayField" : "Name", "description" : "Data Information- Details: This dataset represents the Annual Programme of Works for the 2026/2027 financial year. It identifies planned river management and operations activities undertaken to support the resilience of river ecosystems and reduce flood risk to communities. Attributes provide information such as the project or work name, river management area, river or waterway, work type, activity classification and current status.- Data originator: Otago Regional Council – Engineering.- Creation and quality: Compiled from the annual programme of river management and operations works. Locations provide a spatial representation of planned works and should not be interpreted as survey-accurate locations.- Links or reports: https://www.orc.govt.nz/managing-natural-hazards/flood-defences/operations-and-rivers-work-programmes- Data owner: Otago Regional Council – Engineering.- Scale: Regional operational planning and programme overview.- Usage constraints: Intended for ORC operational and information purposes. Confirm current work details with the Engineering team where required.Temporal Information- Date of Creation: 2026- Update Frequency: Quarterly during the financial year.- Date of Last Update: Update as applicable.Automations and Maintenance- Data custodian: Otago Regional Council – GIS and Engineering.- Spatial Reference: NZGD2000 / NZTM2000.- Update Frequency: Quarterly.- Date of last review: October 2026.- Date of next review: Quarterly / as required.", "copyrightText" : "Otago Regional Council", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1790809387574, "schemaLastEditDate" : 1790809387574, "dataLastEditDate" : 1790809387574 }, "relationships" : [], "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1236321, "ymin" : 4877506, "xmax" : 1434309.9800000004, "ymax" : 5086463, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Status","uniqueValueGroups":[{"heading":"","classes":[{"label":"Planned","description":"Planned","symbol":{"type":"esriPMS","url":"da04346512cfaae4977d3d5a25263ce2","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAASCAYAAABvqT8MAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA5ElEQVQokZWSjQ2CMBBGH4lLgGPAGOIYMAZ1DLtGXYMxlDFqzvZqsYjxSxpoe6/3e+BPHT4PPAzZdq5g3gQ8tMCV8M0fmIFzBY8ERGMH1AwDr9U0YC0YI3d3D0eB1IOEUWMMTNP7ef03hui9VyCEcTqVWU6TAq/LNdCuwg9alp0qScwSfy7nEpoDUomWcQzJamjywDgqMJeAqO/LsDaAS6zUnlwCpL4e7A5kteN50t+8LALoJgHRi2QoDcpl8nlalbUCG4dPG3KTs9ymmNYKOh8GTVaq6VcgqpPZ0gn9CUTDwlgun+W6Pseyz2msAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":13,"angle":0,"xoffset":0,"yoffset":0},"values":[["Planned"]]},{"label":"Underway","description":"Underway","symbol":{"type":"esriPMS","url":"11dfb9ff45cbf972927aab31260105c8","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAASCAYAAABvqT8MAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABU0lEQVQokZWSMU/CQBTH/69l0NGEBRxZTHArSTH4EUCdCM6Y8gmcqSMfwYadxklTv4GSQEI3Vt0sC7uL7TN3bc/TFo1vubt397v33v+9Cv5plZ8O24ejDgbCZR9hKWDfwaIEtwAsdZsAbR+hyTibXyJSgHiMGAEItYuGg/OGg+peHQ+vHqZr14oJb50ZDgUkASOBw4Ta1bGLYXOsAuT76dpFTDJ6TwKcpdGpdwtFDptjCQDo6jVI4OjgK/3ctu+b3Srdv3gQNej2HAVyZcZGB4R01mQ1QnW/jtMsNfHBZDWSe6JUXgkQEOZ1XD/1CmlJYw0wGDcxaQ0rMTYRKEDoe+LDY5RDBHiLrOOq6F1RmLFhE15+VoCIYvsYEWSD9O9dfZ6+ybocwGunw5c35FH49DeFaV0M0LJniIgQmYxU09+AzNn6MFCb99MJ/RPIRrnwWFx+Ar3bbfui6tnFAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":13,"angle":0,"xoffset":0,"yoffset":0},"values":[["Underway"]]},{"label":"On Hold","description":"On Hold","symbol":{"type":"esriPMS","url":"976c56c711767078e18b94a5b0c46c8c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAASCAYAAABvqT8MAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABXUlEQVQokZWSPUjDQBTH/3fpLg0VSYuzB+KUrg7iqkIXhY6FtggZKk5dik4du3Rpuju4ONTRQXDOXmcxgVICnfX65NLeNTZV8U338X7v/d9HDv+03PqD7YiGPksgmEXjYCOw5QjXYhgQ4Oo3rgIURcAtOpu+vYYGUM6cYUSAUz2voHpRwc52AXf3D+j1h66U7L2wu1dSUAJwjgYIzpVXR8urm/T63OsPISUbADhNAEZwCcDx0WGmyJZXTwAAJ0aS1n2wLzLAZDL9uUtKs6ohbU/PL/oYGYABgcrS7nSTYrU0FaDd6WogWEliCEALWbXL64wsHdQAFqdbKZkZ2CaThJEBVH/zJeGDsBli8GfhYuKm6F+yRPM5fH0xgMpiO6JJDGpAq+CEm/Q+fWtrHI19uygaqX16VG9pn8y2xuG4nC+KkAEht6i5/p8BknosKn98MidebuifwHKVM87q8wudIoRHD5z7dgAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":13,"angle":0,"xoffset":0,"yoffset":0},"values":[["On Hold"]]},{"label":"Completed","description":"Completed","symbol":{"type":"esriPMS","url":"c623727dcfbeb08f36057c945c5f2c99","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAUCAYAAAC9BQwsAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACLElEQVQ4jZ2TMUgbYRTHf14uYoxnUMgi6OBQwQgGKiEIoZUTtwylKZZAQym1IBSyFEKhdgzGoZhJKMVBsQSapYVQaC0FkSo4SDQ9cNdBShJUYkg8QvkuuXBJ49L/cNx73//3vfe9707mPyW3xY6tLfxeL2pfH26RuLiA9XXWVlf5Ddx0Avt3dlj2eFgcHGzdbWmJF6rKWjDIG6BgBR0C8npZtNtFladI0jNqNTe6nsHpfIWqsri9jXt2lghQNsBkkhkTKpdTKMpDZLm+Z612h2JxCJcrjM9HKJFgMxbji7Hq86EqClxfz+F0PmhCQpIk4XI9olpNoChZpqYYhwY4PMw9w8Uk3d3dtEuWZarVSSDL2BghYNkAKxXT8g1dj7dUFNJ13YCsMhy6zh8jkLNcXe0yMHC/xVQq7WG318FSqeEVj3y+HoguK5XHFIspZPkuNpuNSuUDkhSnt9cowNkZWhM8OCA1McETMSBFOQdmqNXq1Xp6xIDq75eXcHzMjyYYjfJTVdE8HmNihqSG2ap8Hi0aZbcJigs9OiI9Ospbh+NfQKhchpMTNkVhETfHFw6TzOUIWatadXqKFgzy3oytcy9kMrweGeGzOKtVhQLs7/PO/E6FWi4sFuPr9DRpv5+QeZWiRU0jHYnwyept/61uAgFe5nKMmy2LFkXOPNttoND5ygrP43F+dXWhHR6yInLtpk4gGxvsBQLM9fczND/Px06ejqDQwgLfb1sT+b8sAa0n83XaFwAAAABJRU5ErkJggg==","contentType":"image/png","width":10,"height":15,"angle":0,"xoffset":0,"yoffset":0},"values":[["Completed"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"da04346512cfaae4977d3d5a25263ce2","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAASCAYAAABvqT8MAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA5ElEQVQokZWSjQ2CMBBGH4lLgGPAGOIYMAZ1DLtGXYMxlDFqzvZqsYjxSxpoe6/3e+BPHT4PPAzZdq5g3gQ8tMCV8M0fmIFzBY8ERGMH1AwDr9U0YC0YI3d3D0eB1IOEUWMMTNP7ef03hui9VyCEcTqVWU6TAq/LNdCuwg9alp0qScwSfy7nEpoDUomWcQzJamjywDgqMJeAqO/LsDaAS6zUnlwCpL4e7A5kteN50t+8LALoJgHRi2QoDcpl8nlalbUCG4dPG3KTs9ymmNYKOh8GTVaq6VcgqpPZ0gn9CUTDwlgun+W6Pseyz2msAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Planned","label":"Planned"},{"symbol":{"type":"esriPMS","url":"11dfb9ff45cbf972927aab31260105c8","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAASCAYAAABvqT8MAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABU0lEQVQokZWSMU/CQBTH/69l0NGEBRxZTHArSTH4EUCdCM6Y8gmcqSMfwYadxklTv4GSQEI3Vt0sC7uL7TN3bc/TFo1vubt397v33v+9Cv5plZ8O24ejDgbCZR9hKWDfwaIEtwAsdZsAbR+hyTibXyJSgHiMGAEItYuGg/OGg+peHQ+vHqZr14oJb50ZDgUkASOBw4Ta1bGLYXOsAuT76dpFTDJ6TwKcpdGpdwtFDptjCQDo6jVI4OjgK/3ctu+b3Srdv3gQNej2HAVyZcZGB4R01mQ1QnW/jtMsNfHBZDWSe6JUXgkQEOZ1XD/1CmlJYw0wGDcxaQ0rMTYRKEDoe+LDY5RDBHiLrOOq6F1RmLFhE15+VoCIYvsYEWSD9O9dfZ6+ybocwGunw5c35FH49DeFaV0M0LJniIgQmYxU09+AzNn6MFCb99MJ/RPIRrnwWFx+Ar3bbfui6tnFAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Underway","label":"Underway"},{"symbol":{"type":"esriPMS","url":"976c56c711767078e18b94a5b0c46c8c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAASCAYAAABvqT8MAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABXUlEQVQokZWSPUjDQBTH/3fpLg0VSYuzB+KUrg7iqkIXhY6FtggZKk5dik4du3Rpuju4ONTRQXDOXmcxgVICnfX65NLeNTZV8U338X7v/d9HDv+03PqD7YiGPksgmEXjYCOw5QjXYhgQ4Oo3rgIURcAtOpu+vYYGUM6cYUSAUz2voHpRwc52AXf3D+j1h66U7L2wu1dSUAJwjgYIzpVXR8urm/T63OsPISUbADhNAEZwCcDx0WGmyJZXTwAAJ0aS1n2wLzLAZDL9uUtKs6ohbU/PL/oYGYABgcrS7nSTYrU0FaDd6WogWEliCEALWbXL64wsHdQAFqdbKZkZ2CaThJEBVH/zJeGDsBli8GfhYuKm6F+yRPM5fH0xgMpiO6JJDGpAq+CEm/Q+fWtrHI19uygaqX16VG9pn8y2xuG4nC+KkAEht6i5/p8BknosKn98MidebuifwHKVM87q8wudIoRHD5z7dgAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"On Hold","label":"On Hold"},{"symbol":{"type":"esriPMS","url":"c623727dcfbeb08f36057c945c5f2c99","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAUCAYAAAC9BQwsAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACLElEQVQ4jZ2TMUgbYRTHf14uYoxnUMgi6OBQwQgGKiEIoZUTtwylKZZAQym1IBSyFEKhdgzGoZhJKMVBsQSapYVQaC0FkSo4SDQ9cNdBShJUYkg8QvkuuXBJ49L/cNx73//3vfe9707mPyW3xY6tLfxeL2pfH26RuLiA9XXWVlf5Ddx0Avt3dlj2eFgcHGzdbWmJF6rKWjDIG6BgBR0C8npZtNtFladI0jNqNTe6nsHpfIWqsri9jXt2lghQNsBkkhkTKpdTKMpDZLm+Z612h2JxCJcrjM9HKJFgMxbji7Hq86EqClxfz+F0PmhCQpIk4XI9olpNoChZpqYYhwY4PMw9w8Uk3d3dtEuWZarVSSDL2BghYNkAKxXT8g1dj7dUFNJ13YCsMhy6zh8jkLNcXe0yMHC/xVQq7WG318FSqeEVj3y+HoguK5XHFIspZPkuNpuNSuUDkhSnt9cowNkZWhM8OCA1McETMSBFOQdmqNXq1Xp6xIDq75eXcHzMjyYYjfJTVdE8HmNihqSG2ap8Hi0aZbcJigs9OiI9Ospbh+NfQKhchpMTNkVhETfHFw6TzOUIWatadXqKFgzy3oytcy9kMrweGeGzOKtVhQLs7/PO/E6FWi4sFuPr9DRpv5+QeZWiRU0jHYnwyept/61uAgFe5nKMmy2LFkXOPNttoND5ygrP43F+dXWhHR6yInLtpk4gGxvsBQLM9fczND/Px06ejqDQwgLfb1sT+b8sAa0n83XaFwAAAABJRU5ErkJggg==","contentType":"image/png","width":10,"height":15,"angle":0,"xoffset":0,"yoffset":0},"value":"Completed","label":"Completed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"algorithmic","algorithm":"esriHSVAlgorithm","fromColor":[214,214,255,255],"toColor":[0,57,148,255]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature[\"Name\"]"},"labelPlacement":"esriServerPointLabelPlacementBelowCenter","deconflictionStrategy":"dynamic","stackLabel":true,"stackAlignment":"textSymbol","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":40000,"name":"Label Class 1","priority":0,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":[0,62,96,255],"borderLineColor":[255,255,255,0],"borderLineSize":0.75,"verticalAlignment":"baseline","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":-10,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "Status", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "TaskID", "type" : "esriFieldTypeBigInteger", "alias" : "Task ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreatedAt", "type" : "esriFieldTypeDateOnly", "alias" : "Created At", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LastModified", "type" : "esriFieldTypeDateOnly", "alias" : "Last Modified", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StartDate", "type" : "esriFieldTypeDateOnly", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DueDate", "type" : "esriFieldTypeDateOnly", "alias" : "Estimated Start Date", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Projects", "type" : "esriFieldTypeString", "alias" : "Projects", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RM_Areas", "type" : "esriFieldTypeString", "alias" : "RM Areas", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RiverName", "type" : "esriFieldTypeString", "alias" : "River Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkType", "type" : "esriFieldTypeString", "alias" : "Work Type/s", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkPlanningType", "type" : "esriFieldTypeString", "alias" : "Work Planning Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Easting", "type" : "esriFieldTypeDouble", "alias" : "Easting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Northing", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WorkExtent", "type" : "esriFieldTypeDouble", "alias" : "Extent (m)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AnnualProgramme25_26_Status_42bd6258-b7ad-4d7d-986a-ccc8efa7d9e1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Planned", "code" : "Planned" }, { "name" : "Completed", "code" : "Completed" }, { "name" : "Underway", "code" : "Underway" }, { "name" : "On Hold", "code" : "On Hold" } ] }, "defaultValue" : null }, { "name" : "ActualCompletionDate", "type" : "esriFieldTypeDate", "alias" : "Actual Completion Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DescriptionOfWorks", "type" : "esriFieldTypeString", "alias" : "DescriptionOfWorks", "sqlType" : "sqlTypeOther", "length" : 900, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__RIVERS_W__F4B70D859A6FD874", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_12605.RIVERS_WORK_PROGRAMMES_ANNUAL_PROGRAMME_OF_WORKS_2026_2027_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Planned", "name" : "Planned", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "Planned", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "WorkExtent" : null, "DescriptionOfWorks" : null, "TaskID" : null, "CreatedAt" : null, "LastModified" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "RiverName" : null, "WorkType" : null, "WorkPlanningType" : null, "Easting" : null, "Northing" : null, "Status" : "Planned", "ActualCompletionDate" : null } } } ] }, { "id" : "Underway", "name" : "Underway", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "Underway", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "WorkExtent" : null, "DescriptionOfWorks" : null, "TaskID" : null, "CreatedAt" : null, "LastModified" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "RiverName" : null, "WorkType" : null, "WorkPlanningType" : null, "Easting" : null, "Northing" : null, "Status" : "Underway", "ActualCompletionDate" : null } } } ] }, { "id" : "On Hold", "name" : "On Hold", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "On Hold", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "WorkExtent" : null, "DescriptionOfWorks" : null, "TaskID" : null, "CreatedAt" : null, "LastModified" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "RiverName" : null, "WorkType" : null, "WorkPlanningType" : null, "Easting" : null, "Northing" : null, "Status" : "On Hold", "ActualCompletionDate" : null } } } ] }, { "id" : "Completed", "name" : "Completed", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "Completed", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "WorkExtent" : null, "DescriptionOfWorks" : null, "TaskID" : null, "CreatedAt" : null, "LastModified" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "RiverName" : null, "WorkType" : null, "WorkPlanningType" : null, "Easting" : null, "Northing" : null, "Status" : "Completed", "ActualCompletionDate" : null } } } ] } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }