{ "currentVersion" : 12, "id" : 5, "name" : "Reactive Works Programme 2026/2027", "type" : "Feature Layer", "serviceItemId" : "49c98ba248ac4aa1b677aaa3cb74a7e3", "cacheMaxAge" : 30, "displayField" : "Name", "description" : "Data Information- Details: This dataset represents the Reactive Works Programme for the 2026/2027 financial year. It records river management and operations works identified in response to changing river conditions, maintenance requirements or other operational needs during the year. Attributes provide information such as the 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 reactive river management and operations work records. As reactive works may be identified throughout the financial year, the dataset changes as new work is identified or existing work is updated. Locations provide a spatial representation of 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: This is a dynamic operational dataset and may change as reactive works are identified, updated or completed. Confirm current work details with the Engineering team where required.Temporal Information- Date of Creation: 2026- Update Frequency: Quarterly, with changes occurring as reactive works are identified.- 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 / as new information is supplied.- Date of last review: Update as applicable.- Date of next review: Quarterly / as required.", "copyrightText" : "Otago Regional Council", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1790809387856, "schemaLastEditDate" : 1790809387856, "dataLastEditDate" : 1790809387856 }, "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" : 1292248, "ymin" : 4887261, "xmax" : 1419328, "ymax" : 5036649, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Status","uniqueValueGroups":[{"heading":"","classes":[{"label":"Planning","description":"Planning","symbol":{"type":"esriPMS","url":"90511a27779398ad503ad626c94dbc19","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABqklEQVQokX3SP0iUYRwH8E8geEPg5RI4ttcSR0Q5GMQJEhEV3FpEBEEuCXfRYFRn5Wa0OTUJDQ05dIsNQhEOYbQEQeDgeOmQeLTEV987juPqt7wvD8/3+X3/jRg+JYwV/x3sDLs0MghqcOEIM+ep5uAP7S3aqzxv8Qn7w8DlOW6do9Hh13fWf/LjKBMXqVZYm6JZ53H3gS64FOAUdz6wsMi7K4zvUWrRbvLiGjP3eXWPvSWe9sChmo0F8M1Lnk1SKxcvr7BSZ36Ch1d5ssQqNgMuRWOoZmOA16kd79MzSy3fOvPT3HjA7SZ3Ax6LOdEYqpMDwK7109Tq1L+ycfrQzHLPsJgTjV2qg5PzKie2+XaKCkYD7iSOuBpz/oH1m3aL7bOM7x7e2w14Jzkmjrgac6IxVLuThnxmI/8nubzFeuI6oL3GowofE0dMUWgsFxsDvMnsHJdGOfae172o3vLlDM3kmDjyQMyJxlDNnQCrNFosFE3rlWQ/zUkBkmPiiKsxJxpDNRsDXGR5sGEHD6Q5KUByTBxxNeZEY6j+r9vd2UwBinRG42o/oH/+Akfljy96EklmAAAAAElFTkSuQmCC","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"values":[["Planning"]]},{"label":"Underway","description":"Underway","symbol":{"type":"esriPMS","url":"0e3cdaa2674bef7f5b6f2298d926998c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACBUlEQVQ4jX2TP0gbYRjGf+ARuDFm8gwEblRU7CCKVQghQ8BFiDi5li6hnapZAp2qju3YpbSLrSJChoMgnIMihJJBLNl0MJ4BIbeI5+Agz/WuHnL0W+7yvfe+7/MvBunHBKzoqTMAvLQPjRe/s8UiZctipVDgVSaDrcsgwO/16HQ6bHW7HOsqbUC2WOT9zAy1x0d8z+PE8/iqwtAQ9uQk1fFxWqenfGk2WY+HGMnmcpnG2Rk/dnb4GMEejerXjsNWtcrmxAS1uzt812VTQwxVBVubo+bt+Xlez87SGBn5S+Hmhov9fep7e7yrVPDn5mi4Lk3gtwaY4izY2qzm5WW+5fPP3PJ57FyOnwcHvBWSsTFKlQpvHIc/GmBJMHEWbG1ONsfHtmFhgQ/tNr/6fS6npyk5DlaIQGpHgo3GsNNOLhfWzNtbDgsFPqXZ+N+TyYSP4cS7qQHX8llW6V2CiXPagKsrOqKpbwcDLvRuAA/9PifyWQJJbQkmzsnT60G3y662Li5SOj/nMrYxaLf5vLbGknyWVVJbgomzoGqzmlstvq+usnF/T9bzqAN+qIHiqYQpJPJZSKR29F8QZ4XKVPPUFLWjI+quG9b/iRgonkqYQiKfZZXUVlGcBVub1SwkMbWkC4HiqYQpJPJZVomCBBNnwY43pw0IhyieSphCEt2Jhiio5r+05gn+FOElmhrTDAAAAABJRU5ErkJggg==","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0},"values":[["Underway"]]},{"label":"Completed","description":"Completed","symbol":{"type":"esriPMS","url":"f385cf9e686cdd899b3be4f1914907ed","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB30lEQVQokX2SP0gbYRjGf4KQGwSji5DRXZdwBIkOEeQCUoqokFUREQpmMfBFOijaU5st0q1Tp0CHDM3gLckgKOIghi5CQciQMU0Gg8GlPGcuhpD6Lnd8fM/3Pv9GGT4WMN797wDNYZdGB0HZLIsjIyzPz+Po4OWFRq1Go1TizPO4Bp6HgcOZDFvxONlOh78PD1w+PvJnbIzI0hKObVNOJHCN4Sh4IABbAiYS7FQqnORy/FpZYbLdxvI8Gq7L17U1lvf2+La7Szuf50sPLKra2AX+PD/ndGGBVDj8+nKhQMEYDiIRPq+ucpzPUwLuBbakUVS1UcD1dVJTU2960mlS+hrDQTLJxv4+267LJ4HHZY40iqo29gN9TRYkk6SMwVSr3EajvpnhnmEyRxoDqoOjc8dhul7n9+wsNhASuKM45KrM+U/uPD3R8Dzqc3NMtlr+vZbATeWoOOSqzJFGUQ2m2YSbG271PzPDx1qNS8Xl0y6XObRtrhSHTNGZNIqqNgq4uUk6k+FDKMTExQU/elEVi9zFYrjKUXHoAZkjjaKqOwI6DlnP46TbtF5JntUcFUA5Kg65KnOkUVS1UcBcju+DDfMfUHNUAOWoOOSqzJFGUX2v28HcqwBKR3HI1X5A//wDDxbOgJeTR+0AAAAASUVORK5CYII=","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"values":[["Completed"]]},{"label":"On Hold","description":"On Hold","symbol":{"type":"esriPMS","url":"2cc6ac93719686150e3205b483630ace","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABdElEQVQ4jYWSP0sDQRDFf8WCpIydJpA6tWAqIY1dvoG2ARFtbGOTxu5ECFhqKWJhFRBsxSpoJegHiHYXTIrEKvLCWzmOBQeO27vZmXl/JpCOCrDptyIHPlMXQ+m7CrSBDtAE6v4/A96BS+AZmKcaVIEDYB+YAi/AnXMNYBe4Am6AfmwSSsV6hkBm2DXnx8AAOAX2gG/gQk2CL7Q9eWiYLeAY2HD+y017Lj4EHoFRsFAdw85cfAb8+FGsO9c3kpYHvgWr3TTn3JNjYTEWQBe4tyPbqg1GULdgNcNONaBg7RNwkrLxv1iaTjxXghWe2aqxBYuXyvFhmg3TyIO5vdrngcXK/L8Ya8CDKWx52Dx4Ia6BHfvcs9pdc156sopvgSPvzTkwiRpoPbVhcUmERGprmugIts4q1h0tkfJ/IgqFpsYlkc/iKLUV4izYmqxiIVlF0QU1UVIbpiWRz7JKFNRMnAV7NTnVIDYZacPMXyHooqDcpOzLLzNpYxFS2dk7AAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0},"values":[["On Hold"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"90511a27779398ad503ad626c94dbc19","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABqklEQVQokX3SP0iUYRwH8E8geEPg5RI4ttcSR0Q5GMQJEhEV3FpEBEEuCXfRYFRn5Wa0OTUJDQ05dIsNQhEOYbQEQeDgeOmQeLTEV987juPqt7wvD8/3+X3/jRg+JYwV/x3sDLs0MghqcOEIM+ep5uAP7S3aqzxv8Qn7w8DlOW6do9Hh13fWf/LjKBMXqVZYm6JZ53H3gS64FOAUdz6wsMi7K4zvUWrRbvLiGjP3eXWPvSWe9sChmo0F8M1Lnk1SKxcvr7BSZ36Ch1d5ssQqNgMuRWOoZmOA16kd79MzSy3fOvPT3HjA7SZ3Ax6LOdEYqpMDwK7109Tq1L+ycfrQzHLPsJgTjV2qg5PzKie2+XaKCkYD7iSOuBpz/oH1m3aL7bOM7x7e2w14Jzkmjrgac6IxVLuThnxmI/8nubzFeuI6oL3GowofE0dMUWgsFxsDvMnsHJdGOfae172o3vLlDM3kmDjyQMyJxlDNnQCrNFosFE3rlWQ/zUkBkmPiiKsxJxpDNRsDXGR5sGEHD6Q5KUByTBxxNeZEY6j+r9vd2UwBinRG42o/oH/+Akfljy96EklmAAAAAElFTkSuQmCC","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Planning","label":"Planning"},{"symbol":{"type":"esriPMS","url":"0e3cdaa2674bef7f5b6f2298d926998c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACBUlEQVQ4jX2TP0gbYRjGf+ARuDFm8gwEblRU7CCKVQghQ8BFiDi5li6hnapZAp2qju3YpbSLrSJChoMgnIMihJJBLNl0MJ4BIbeI5+Agz/WuHnL0W+7yvfe+7/MvBunHBKzoqTMAvLQPjRe/s8UiZctipVDgVSaDrcsgwO/16HQ6bHW7HOsqbUC2WOT9zAy1x0d8z+PE8/iqwtAQ9uQk1fFxWqenfGk2WY+HGMnmcpnG2Rk/dnb4GMEejerXjsNWtcrmxAS1uzt812VTQwxVBVubo+bt+Xlez87SGBn5S+Hmhov9fep7e7yrVPDn5mi4Lk3gtwaY4izY2qzm5WW+5fPP3PJ57FyOnwcHvBWSsTFKlQpvHIc/GmBJMHEWbG1ONsfHtmFhgQ/tNr/6fS6npyk5DlaIQGpHgo3GsNNOLhfWzNtbDgsFPqXZ+N+TyYSP4cS7qQHX8llW6V2CiXPagKsrOqKpbwcDLvRuAA/9PifyWQJJbQkmzsnT60G3y662Li5SOj/nMrYxaLf5vLbGknyWVVJbgomzoGqzmlstvq+usnF/T9bzqAN+qIHiqYQpJPJZSKR29F8QZ4XKVPPUFLWjI+quG9b/iRgonkqYQiKfZZXUVlGcBVub1SwkMbWkC4HiqYQpJPJZVomCBBNnwY43pw0IhyieSphCEt2Jhiio5r+05gn+FOElmhrTDAAAAABJRU5ErkJggg==","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0},"value":"Underway","label":"Underway"},{"symbol":{"type":"esriPMS","url":"f385cf9e686cdd899b3be4f1914907ed","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB30lEQVQokX2SP0gbYRjGf4KQGwSji5DRXZdwBIkOEeQCUoqokFUREQpmMfBFOijaU5st0q1Tp0CHDM3gLckgKOIghi5CQciQMU0Gg8GlPGcuhpD6Lnd8fM/3Pv9GGT4WMN797wDNYZdGB0HZLIsjIyzPz+Po4OWFRq1Go1TizPO4Bp6HgcOZDFvxONlOh78PD1w+PvJnbIzI0hKObVNOJHCN4Sh4IABbAiYS7FQqnORy/FpZYbLdxvI8Gq7L17U1lvf2+La7Szuf50sPLKra2AX+PD/ndGGBVDj8+nKhQMEYDiIRPq+ucpzPUwLuBbakUVS1UcD1dVJTU2960mlS+hrDQTLJxv4+267LJ4HHZY40iqo29gN9TRYkk6SMwVSr3EajvpnhnmEyRxoDqoOjc8dhul7n9+wsNhASuKM45KrM+U/uPD3R8Dzqc3NMtlr+vZbATeWoOOSqzJFGUQ2m2YSbG271PzPDx1qNS8Xl0y6XObRtrhSHTNGZNIqqNgq4uUk6k+FDKMTExQU/elEVi9zFYrjKUXHoAZkjjaKqOwI6DlnP46TbtF5JntUcFUA5Kg65KnOkUVS1UcBcju+DDfMfUHNUAOWoOOSqzJFGUX2v28HcqwBKR3HI1X5A//wDDxbOgJeTR+0AAAAASUVORK5CYII=","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"Completed","label":"Completed"},{"symbol":{"type":"esriPMS","url":"2cc6ac93719686150e3205b483630ace","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABdElEQVQ4jYWSP0sDQRDFf8WCpIydJpA6tWAqIY1dvoG2ARFtbGOTxu5ECFhqKWJhFRBsxSpoJegHiHYXTIrEKvLCWzmOBQeO27vZmXl/JpCOCrDptyIHPlMXQ+m7CrSBDtAE6v4/A96BS+AZmKcaVIEDYB+YAi/AnXMNYBe4Am6AfmwSSsV6hkBm2DXnx8AAOAX2gG/gQk2CL7Q9eWiYLeAY2HD+y017Lj4EHoFRsFAdw85cfAb8+FGsO9c3kpYHvgWr3TTn3JNjYTEWQBe4tyPbqg1GULdgNcNONaBg7RNwkrLxv1iaTjxXghWe2aqxBYuXyvFhmg3TyIO5vdrngcXK/L8Ya8CDKWx52Dx4Ia6BHfvcs9pdc156sopvgSPvzTkwiRpoPbVhcUmERGprmugIts4q1h0tkfJ/IgqFpsYlkc/iKLUV4izYmqxiIVlF0QU1UVIbpiWRz7JKFNRMnAV7NTnVIDYZacPMXyHooqDcpOzLLzNpYxFS2dk7AAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0},"value":"On Hold","label":"On Hold"}],"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,100,155,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" : "Task_ID", "type" : "esriFieldTypeBigInteger", "alias" : "Task ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CompletedAt", "type" : "esriFieldTypeDateOnly", "alias" : "Completed At", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 8000, "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" : "QuarterPlanned", "type" : "esriFieldTypeString", "alias" : "Quarter Planned", "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" : "ActualCompletionDate", "type" : "esriFieldTypeDateOnly", "alias" : "Actual Completion Date", "sqlType" : "sqlTypeOther", "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" : "Status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ReactiveWork25_26_Status_1d378aca-833a-4660-8db4-147c02f2fff1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Planning", "code" : "Planning" }, { "name" : "Underway", "code" : "Underway" }, { "name" : "Completed", "code" : "Completed" }, { "name" : "On Hold", "code" : "On Hold" }, { "name" : "Not Required", "code" : "Not Required" } ] }, "defaultValue" : null }, { "name" : "DescriptionOfWorks", "type" : "esriFieldTypeString", "alias" : "Description of Works", "sqlType" : "sqlTypeOther", "length" : 800, "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" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EstimatedStartDate", "type" : "esriFieldTypeDate", "alias" : "EstimatedStartDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__RIVERS_W__F4B70D85969D60A7", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_12605.RIVERS_WORK_PROGRAMMES_REACTIVE_WORKS_PROGRAMME_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" : "Planning", "name" : "Planning", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "Planning", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Northing" : null, "EstimatedStartDate" : null, "Task_ID" : null, "CompletedAt" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "QuarterPlanned" : null, "RiverName" : null, "WorkType" : null, "ActualCompletionDate" : null, "Easting" : null, "Status" : "Planning", "DescriptionOfWorks" : null, "WorkExtent" : null } } } ] }, { "id" : "Underway", "name" : "Underway", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "Not Required", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Northing" : null, "EstimatedStartDate" : null, "Task_ID" : null, "CompletedAt" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "QuarterPlanned" : null, "RiverName" : null, "WorkType" : null, "ActualCompletionDate" : null, "Easting" : null, "Status" : "Underway", "DescriptionOfWorks" : null, "WorkExtent" : null } } }, { "name" : "Not Required (1)", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Northing" : null, "EstimatedStartDate" : null, "Task_ID" : null, "CompletedAt" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "QuarterPlanned" : null, "RiverName" : null, "WorkType" : null, "ActualCompletionDate" : null, "Easting" : null, "Status" : "Underway", "DescriptionOfWorks" : null, "WorkExtent" : null } } } ] }, { "id" : "Completed", "name" : "Completed", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "Completed", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Northing" : null, "EstimatedStartDate" : null, "Task_ID" : null, "CompletedAt" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "QuarterPlanned" : null, "RiverName" : null, "WorkType" : null, "ActualCompletionDate" : null, "Easting" : null, "Status" : "Completed", "DescriptionOfWorks" : null, "WorkExtent" : null } } } ] }, { "id" : "On Hold", "name" : "On Hold", "domains" : { "Status" : {"type" : "inherited"} }, "templates" : [ { "name" : "On Hold", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Northing" : null, "EstimatedStartDate" : null, "Task_ID" : null, "CompletedAt" : null, "Name" : null, "StartDate" : null, "DueDate" : null, "Projects" : null, "RM_Areas" : null, "QuarterPlanned" : null, "RiverName" : null, "WorkType" : null, "ActualCompletionDate" : null, "Easting" : null, "Status" : "On Hold", "DescriptionOfWorks" : null, "WorkExtent" : 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" }