{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "Sanitary Manhole Inspection Status", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": null, "xyTolerance": 1.0E-6, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.50359960495E7, "falseY": -4.50359960495E7, "xyUnits": 9999999.999999754, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var ParentGUID = $feature.ParentGUID // null = no inspection exists, otherwise an inspection exist and proceed to check next conditions\n\n//vars to test if manhole needs immediate attention (red)\n// // Following fields are new and will be derived from Valve_Issues field\nvar Locatable = $feature.Locatable // 'N' -> RED\nvar Lid_label = $feature.Lid_label // 'N' -> RED\nvar H2S = $feature.H2S // '>5' -> RED\nvar Lid_Condition = $feature.Lid_Condition // 'Damaged' -> RED, 'Seized' -> RED\nvar Ring_Condition = $feature.Ring_Condition // 'Damaged' -> RED\nvar Rung_Condition = $feature.Rung_Condition // 'Poor' -> RED, 'Fair' -> RED\nvar Concrete_Condition = $feature.Concrete_Condition // 'Poor' -> RED\nvar drop_struct_condition = $feature.drop_struct_condition //'Poor' -> RED\nvar bench_condition = $feature.bench_condition //'Poor' -> RED\nvar channel_condition = $feature.channel_condition //'Poor' -> RED\nvar Cleaning = $feature.drop_struct_condition //'Y' -> RED\nvar Raise_Lower = $feature.Raise_Lower //'Y' -> RED\nvar Infiltration = $feature.Infiltration //'Y' -> RED\n\n// vars to test if inspection is stale\nvar inspection_date = $feature.created_date //e.g. test value: Date(2019,3,5) - inspection year. month integer ranges from 0-11, which is not intuitive. 0 is January. adjust date in statement as required\nvar current_date = Date() // current year\nvar inspection_age = DateDiff(current_date, inspection_date, 'years')\n\n//compare the inspection year to the current year and return true (stale) if it is from year(s) prior to current\nvar stale_inspection = false\nif (inspection_age > 2){\n var stale_inspection = true}\n\n//check if valve should be flagged as red or orange\nvar RED_check = false\nif (Locatable == \"N\" || Lid_Condition == \"Seized\" || Lid_Condition == \"Damaged\" || Ring_Condition == \"Damaged\" || Rung_Condition == \"Poor\" || drop_struct_condition == \"Poor\" || Cleaning == \"Y\"|| Lid_label == \"N\" || Concrete_Condition == \"Poor\" || bench_condition == \"Poor\" || channel_condition == \"Poor\" || Raise_Lower == \"Y\" || H2S == \">5\" || Infiltration == \"Y\"){\n var RED_check = true}\n\nWhen(RED_check, \"Immediate Attention Required\",\nIsEmpty(ParentGUID) || stale_inspection, \"Inspection Not Started/Stale\",\n\"Inspection Completed\") //last argument is default value if no expression/result pair evaluates to true", "valueExpressionTitle": "Custom", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "049ad3ed1dc7a3432c55a9639211347e", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAPCAYAAADtc08vAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABGklEQVQokaXSvyvEYRzA8dfwtbjFr05iNFwpSbGclEgG6hZ16GSQcspZLFdKyWC0sFiNSvIHUOI/0P0BVzaS4ZRFz/nRuY5zvOvpqefp8/78eJ7IP4nq3I+871d/EXT0kEd/kQkUGhI0k51jtJPYLrkHVhsRJPpYmyHWiwvS5+zXqiKqFd1KbpV4CA4s03LJ4RNjvxGMJElPVRwMY5LkCSmc/iiIsxkyVp/naLomf1dHkJpmPGSsJrSzyMBeuSNHtQSJLvJLxHxDhqZjtotv/6LwRdDOQsjwMbhatGGD7i2yJdYrBYkhVkKGH+LLzOOEzA0HoYqyIDzbIPF7hFWPMVpu2Xlktix45uWIs8/J/IKocgahn1IDwZW8AsqWNdJDeDSlAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Immediate Attention Required", "label": "Immediate Attention Required" }, { "symbol": { "type": "esriPMS", "url": "5a2918b2fb8b2acd474b30c65a50513c", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAPCAYAAADtc08vAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABSklEQVQokaWSvUtCURiHn+pqxVW7mSkmNAVdCEKIKEiCzIiGQIJAiLYIMsipxUnoL2ippaUlaIsWp6ZcGmsox6RF4iJlX1zFinNLMrl+1QOHA+fwe97znnMk/onUYD/wPaf+InB1uogDo7pGCEi3JGjvItofZNqqIGeOiJWe2WhFoMqDbPZNIncPwMMlkdwFu2ankMzSHTZi3kXcIizwLqA8XrFfemOmGUGgZ4SIc/xnwa5C7xhTWoowcFJXYFXYFhWr131LWPLXxAu5+oKwc4JZUbEa0Y5nDv/dMWvAgZlAtTqJe+aRqYEnhOX+jISuGf8i/UsgOVgRFcoXZ4ZkN1rx3R4SfdfZqhSojmHWRYXa8S/cQdDOWc3fsCdOYQjEs9mGcBefQIxGKH6Ulww7pVeWDcFHkWI2yWk22Thcpk2quAPRT0FvPlzJJ53oT8KVfRdPAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Inspection Completed", "label": "Inspection Completed" }, { "symbol": { "type": "esriPMS", "url": "10e290d9cefa5afa0625d4caeffe9238", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAPCAYAAADtc08vAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABVElEQVQokWNhoBCwEJC3gdJHyDFAhE9UvoqRgUHv4+uHLgwMDDdIMoCNgydL1zXZjltIkvvQoor8H5/eZpJigIaIgl62mk0ot5CMBsOD8zsjbh1dMxGbK1iw6ebgE843DSoVA2kGASPffIGHF3ZP//n1oyMxBtjI6TpGqFgEwAWktWwYlE18ra8dXAIS3IDXAB4BiVKQjeji5uHVrI+vHKj6/PYJXgMCVK1DnUE2ogOQd/Q9Mw2OLKlOYWBgmIPNAA1eYZkqA+8sbgYcQM8jjfXyzlkNH18/PAILUBaYJJeAaDTIBljAYQOcfCIM5uE10vtn52f9/vktD9kADSkN6zSQDTh1Q4GuWwrD9QNLYh9fOTgN5AqwAaBok1QzF/v+6Q0DCBMCCkYeAq8eXGz++eVDKNiAvz+//z6/aeKm85tAaYU4wMzCiggDkH9+//xGtGZkAADLkW4VLXeVzQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 12, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Inspection Not Started/Stale", "label": "Inspection Not Started/Stale" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 238, 252, 192, 255 ], "toColor": [ 238, 252, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 179, 252, 255 ], "toColor": [ 179, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 191, 255 ], "toColor": [ 252, 179, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 240, 252, 255 ], "toColor": [ 184, 240, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 184, 252, 255 ], "toColor": [ 251, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 217, 255 ], "toColor": [ 179, 252, 217, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 216, 184, 255 ], "toColor": [ 252, 216, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 215, 252, 255 ], "toColor": [ 215, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 188, 252, 179, 255 ], "toColor": [ 188, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 230, 255 ], "toColor": [ 252, 212, 230, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 252, 243, 255 ], "toColor": [ 215, 252, 243, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 221, 189, 252, 255 ], "toColor": [ 221, 189, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 244, 215, 255 ], "toColor": [ 252, 244, 215, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -4.50359960495E7, "ymin": -4.50359960495E7, "xmax": 8.556839294246211E8, "ymax": 8.556839294246211E8, "spatialReference": { "wkid": 102187, "latestWkid": 3776, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5622600, "falseY": -10001100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSET_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeString", "alias": "ASSET_ID", "length": 14, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 8, "domain": null }, { "name": "RIM", "type": "esriFieldTypeString", "alias": "RIM", "length": 10, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "ParentGUID", "length": 38, "domain": null }, { "name": "Operator_Name", "type": "esriFieldTypeString", "alias": "Operator_Name", "length": 255, "domain": null }, { "name": "Lid_label", "type": "esriFieldTypeString", "alias": "Lid_label", "length": 10, "domain": null }, { "name": "INSTALL_YR", "type": "esriFieldTypeDouble", "alias": "INSTALL_YR", "domain": null }, { "name": "Locatable", "type": "esriFieldTypeString", "alias": "Locatable", "length": 10, "domain": null }, { "name": "H2S", "type": "esriFieldTypeString", "alias": "H2S", "length": 20, "domain": null }, { "name": "Lid_Condition", "type": "esriFieldTypeString", "alias": "Lid_Condition", "length": 255, "domain": null }, { "name": "Ring_Condition", "type": "esriFieldTypeString", "alias": "Ring_Condition", "length": 255, "domain": null }, { "name": "Concrete_Condition", "type": "esriFieldTypeString", "alias": "Concrete_Condition", "length": 255, "domain": null }, { "name": "drop_struct_pres", "type": "esriFieldTypeString", "alias": "drop_struct_pres", "length": 10, "domain": null }, { "name": "drop_struct_condition", "type": "esriFieldTypeString", "alias": "drop_struct_condition", "length": 255, "domain": null }, { "name": "bench_condition", "type": "esriFieldTypeString", "alias": "bench_condition", "length": 255, "domain": null }, { "name": "channel_condition", "type": "esriFieldTypeString", "alias": "channel_condition", "length": 255, "domain": null }, { "name": "Cleaning", "type": "esriFieldTypeString", "alias": "Cleaning", "length": 10, "domain": null }, { "name": "Parson_Plug", "type": "esriFieldTypeString", "alias": "Parson_Plug", "length": 10, "domain": null }, { "name": "Infiltration", "type": "esriFieldTypeString", "alias": "Infiltration", "length": 10, "domain": null }, { "name": "Raise_Lower", "type": "esriFieldTypeString", "alias": "Raise_Lower", "length": 10, "domain": null }, { "name": "San_Lat", "type": "esriFieldTypeString", "alias": "San_Lat", "length": 10, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 500, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "Rung_Condition", "type": "esriFieldTypeString", "alias": "Rung_Condition", "length": 255, "domain": null }, { "name": "Location_Accuracy", "type": "esriFieldTypeString", "alias": "Location_Accuracy", "length": 10, "domain": null }, { "name": "redline_submission", "type": "esriFieldTypeString", "alias": "redline_submission", "length": 10, "domain": null }, { "name": "Expr1", "type": "esriFieldTypeGUID", "alias": "Expr1", "length": 38, "domain": null }, { "name": "H2S_Comment", "type": "esriFieldTypeString", "alias": "H2S_Comment", "length": 20, "domain": null }, { "name": "drop_struct_type", "type": "esriFieldTypeString", "alias": "drop_struct_type", "length": 255, "domain": null }, { "name": "drop_struct_clean", "type": "esriFieldTypeString", "alias": "drop_struct_clean", "length": 255, "domain": null }, { "name": "Odor_control", "type": "esriFieldTypeString", "alias": "Odor_control", "length": 255, "domain": null }, { "name": "Lid_Size", "type": "esriFieldTypeString", "alias": "Lid_Size", "length": 25, "domain": null }, { "name": "Drop_Structure", "type": "esriFieldTypeString", "alias": "Drop_Structure", "length": 25, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": false }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "9c11182cd0d14c3082b83b91714e745c" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "Sanitary Main Inspection Status", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": null, "xyTolerance": 1.0E-6, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.50359960495E7, "falseY": -4.50359960495E7, "xyUnits": 9999999.999999754, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var value = $feature.SEWER_RAT_SCORE;\nvar ParentGUID = $feature.ParentGUID // null = no inspection exists, otherwise an inspection exist and proceed to check next conditions\nif (IsEmpty(ParentGUID)) {\n return \"Not Inspected\";\n} else if (value >= 0 && value <= 3) {\n return \"Poor\";\n} else if (value >= 4 && value <= 7) {\n return \"Fair\";\n} else if (value >= 8 && value <= 10) {\n return \"Good\";\n} else {\n return \"Incorrect Value\"; // Default color if outside the specified ranges\n}", "valueExpressionTitle": "Custom", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 3 }, "value": "Poor", "label": "Poor" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 3 }, "value": "Fair", "label": "Fair" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 170, 255, 0, 255 ], "width": 3 }, "value": "Good", "label": "Good" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 108, 171, 231, 255 ], "width": 3 }, "value": "Not Inspected", "label": "Not Inspected" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 238, 252, 192, 255 ], "toColor": [ 238, 252, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 179, 252, 255 ], "toColor": [ 179, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 191, 255 ], "toColor": [ 252, 179, 191, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 240, 252, 255 ], "toColor": [ 184, 240, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 251, 184, 252, 255 ], "toColor": [ 251, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 217, 255 ], "toColor": [ 179, 252, 217, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 216, 184, 255 ], "toColor": [ 252, 216, 184, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 215, 252, 255 ], "toColor": [ 215, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 188, 252, 179, 255 ], "toColor": [ 188, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 212, 230, 255 ], "toColor": [ 252, 212, 230, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 252, 243, 255 ], "toColor": [ 215, 252, 243, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 221, 189, 252, 255 ], "toColor": [ 221, 189, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 244, 215, 255 ], "toColor": [ 252, 244, 215, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -4.50359960495E7, "ymin": -4.50359960495E7, "xmax": 8.556839294246211E8, "ymax": 8.556839294246211E8, "spatialReference": { "wkid": 102187, "latestWkid": 3776, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5622600, "falseY": -10001100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ASSET_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeString", "alias": "ASSET_ID", "length": 15, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "ParentGUID", "length": 38, "domain": null }, { "name": "SEWER_RAT_SCORE", "type": "esriFieldTypeString", "alias": "SEWER_RAT_SCORE", "length": 255, "domain": null }, { "name": "OperatorName", "type": "esriFieldTypeString", "alias": "OperatorName", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 500, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "DMTR_MM", "type": "esriFieldTypeDouble", "alias": "DMTR_MM", "domain": null }, { "name": "Expr1", "type": "esriFieldTypeString", "alias": "Expr1", "length": 50, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": false }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "9c11182cd0d14c3082b83b91714e745c" } ], "tables": [] }