{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "SewerRootControl", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriDecimalDegrees" }, "hasMetadata": true, "extent": { "xmin": -105.0154267765154, "ymin": 39.828262006269455, "xmax": -104.82517873145984, "ymax": 40.000723636193996, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "// Get today's date\nvar today = Now()\n\n// Get the LastTreatmentDate field\nvar treatmentDate = $feature.LastTreatmentDate\n\n// Check for null or empty date\nif (IsEmpty(treatmentDate)) {\n return \"Not Treated\"\n}\n\n// Calculate the difference in months\nvar monthsAgo = DateDiff(today, treatmentDate, \"months\")\n\n// Return category based on how long ago the treatment was\nif (monthsAgo <= 6) {\n return \"0-6 months\"\n} else if (monthsAgo <= 24) {\n return \"6-24 months\"\n} else if (monthsAgo <= 36) {\n return \"24-36 months\"\n} else {\n return \"36+ months\"\n}\n", "valueExpressionTitle": "Custom", "uniqueValueGroups": [ { "heading": "Custom", "classes": [ { "label": "0-6 months", "description": "0-6 months", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 1.5 }, "values": [ [ "0-6 months" ] ] }, { "label": "6-24 months", "description": "6-24 months", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 1.5 }, "values": [ [ "6-24 months" ] ] }, { "label": "36+ months", "description": "36+ months", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 1.5 }, "values": [ [ "36+ months" ] ] }, { "label": "Not Treated", "description": "Not Treated", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 1.5 }, "values": [ [ "Not Treated" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 1.5 }, "value": "0-6 months", "label": "0-6 months" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 152, 0, 255 ], "width": 1.5 }, "value": "6-24 months", "label": "6-24 months" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 1.5 }, "value": "36+ months", "label": "36+ months" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 1.5 }, "value": "Not Treated", "label": "Not Treated" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 192, 252, 198, 255 ], "toColor": [ 192, 252, 198, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 235, 179, 252, 255 ], "toColor": [ 235, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 198, 182, 255 ], "toColor": [ 252, 198, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 232, 252, 255 ], "toColor": [ 202, 232, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 244, 179, 255 ], "toColor": [ 252, 244, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 244, 255 ], "toColor": [ 252, 215, 244, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 194, 252, 255 ], "toColor": [ 179, 194, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 197, 252, 239, 255 ], "toColor": [ 197, 252, 239, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 234, 210, 255 ], "toColor": [ 252, 234, 210, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 202, 255 ], "toColor": [ 252, 179, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 232, 252, 204, 255 ], "toColor": [ 232, 252, 204, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 218, 207, 252, 255 ], "toColor": [ 218, 207, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 227, 252, 179, 255 ], "toColor": [ 227, 252, 179, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TYPE", "type": "esriFieldTypeInteger", "alias": "Type", "domain": null, "editable": true, "nullable": true, "defaultValue": 7, "modelName": "TYPE2" }, { "name": "PrimaryID", "type": "esriFieldTypeString", "alias": "Primary ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PrimaryID" }, { "name": "UNITID", "type": "esriFieldTypeString", "alias": "Unit ID - Start", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "UNITID" }, { "name": "UNITID2", "type": "esriFieldTypeString", "alias": "Unit ID - End", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "UNITID2" }, { "name": "DIAMETER", "type": "esriFieldTypeInteger", "alias": "Diameter (in)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Pipe_Type" }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OWNER" }, { "name": "YEAR_INSTALLED", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEAR_INSTALLED" }, { "name": "CIP_Year", "type": "esriFieldTypeSmallInteger", "alias": "CIP Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CIP_Year" }, { "name": "Asbuilt_Length", "type": "esriFieldTypeDouble", "alias": "Asbuilt Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Asbuilt_Length" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Location" }, { "name": "GXP_ID", "type": "esriFieldTypeString", "alias": "GXP ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GXP_ID" }, { "name": "TV_Pipe_Type", "type": "esriFieldTypeString", "alias": "TV - Material", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "TV_Pipe_Type" }, { "name": "TV_Pipe_Width", "type": "esriFieldTypeDouble", "alias": "TV - Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pipe_Width" }, { "name": "TV_Pipe_Shape", "type": "esriFieldTypeString", "alias": "TV - Shape", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "Pipe_Shape" }, { "name": "TV_Date_Start", "type": "esriFieldTypeDate", "alias": "TV - Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Start" }, { "name": "TV_Date_End", "type": "esriFieldTypeDate", "alias": "TV - End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_End" }, { "name": "TV_Reason", "type": "esriFieldTypeString", "alias": "TV - Reason", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "Reason" }, { "name": "TV_Pipe_Condition", "type": "esriFieldTypeString", "alias": "TV - Pipe Condition", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Condition" }, { "name": "TV_Surface_Condition", "type": "esriFieldTypeString", "alias": "TV - Surface Condition", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Surface_Condition" }, { "name": "TV_Footage", "type": "esriFieldTypeDouble", "alias": "TV - Footage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Surveyed_Footage" }, { "name": "TV_Operator", "type": "esriFieldTypeString", "alias": "TV - Operator", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Operator" }, { "name": "TV_Comment", "type": "esriFieldTypeString", "alias": "TV - Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TV_Comment" }, { "name": "DOCS_IDNum", "type": "esriFieldTypeInteger", "alias": "Docs ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOCS_IDNum" }, { "name": "ASBUILT", "type": "esriFieldTypeString", "alias": "AsBuilt", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ASBUILT" }, { "name": "LEGACY_ID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "LegacyID" }, { "name": "ID_UPDATE", "type": "esriFieldTypeString", "alias": "ID Update Note", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ID_Update" }, { "name": "GIS_STATUS", "type": "esriFieldTypeString", "alias": "GIS Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GIS_STATUS" }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CREATOR" }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "Create Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATE_DATE" }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EDITOR" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "Edit Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "GIS_ID", "type": "esriFieldTypeInteger", "alias": "GIS ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GIS_ID" }, { "name": "FID_1", "type": "esriFieldTypeInteger", "alias": "FID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FID_1" }, { "name": "FtrID", "type": "esriFieldTypeString", "alias": "FtrID", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FtrID" }, { "name": "LastTrt", "type": "esriFieldTypeString", "alias": "LastTrt", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "LastTrt" }, { "name": "Location_1", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location_1" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "Name" }, { "name": "PrimaryID_1", "type": "esriFieldTypeString", "alias": "PrimaryID", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "PrimaryID_1" }, { "name": "GXPID", "type": "esriFieldTypeString", "alias": "GXPID", "domain": null, "editable": true, "nullable": true, "length": 23, "defaultValue": null, "modelName": "GXPID" }, { "name": "UpMH", "type": "esriFieldTypeString", "alias": "UpMH", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "UpMH" }, { "name": "DnMH", "type": "esriFieldTypeString", "alias": "DnMH", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "DnMH" }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Size" }, { "name": "Feet", "type": "esriFieldTypeString", "alias": "Feet", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "Feet" }, { "name": "Material_1", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 14, "defaultValue": null, "modelName": "Material_1" }, { "name": "GuarEnd", "type": "esriFieldTypeString", "alias": "GuarEnd", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "GuarEnd" }, { "name": "NextTreate", "type": "esriFieldTypeString", "alias": "NextTreate", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "NextTreate" }, { "name": "LastTreatmentDate", "type": "esriFieldTypeDate", "alias": "LastTreatmentDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastTreatmentDate" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R623_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_623", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S372_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SewerRootControl", "description": "", "prototype": { "attributes": { "LastTreatmentDate": null, "NextTreate": null, "TYPE": 7, "PrimaryID": null, "UNITID": null, "UNITID2": null, "DIAMETER": null, "MATERIAL": null, "OWNER": null, "YEAR_INSTALLED": null, "CIP_Year": null, "Asbuilt_Length": null, "COMMENT": null, "Location": null, "GXP_ID": null, "TV_Pipe_Type": null, "TV_Pipe_Width": null, "TV_Pipe_Shape": null, "TV_Date_Start": null, "TV_Date_End": null, "TV_Reason": null, "TV_Pipe_Condition": null, "TV_Surface_Condition": null, "TV_Footage": null, "TV_Operator": null, "TV_Comment": null, "DOCS_IDNum": null, "ASBUILT": null, "LEGACY_ID": null, "ID_UPDATE": null, "GIS_STATUS": null, "CREATOR": null, "CREATE_DATE": null, "EDITOR": null, "EDIT_DATE": null, "ENABLED": 1, "GuarEnd": null, "GIS_ID": null, "FID_1": null, "FtrID": null, "LastTrt": null, "Location_1": null, "Name": null, "PrimaryID_1": null, "GXPID": null, "UpMH": null, "DnMH": null, "Size": null, "Feet": null, "Material_1": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }