{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Water Service Materials", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 32612, "latestWkid": 32612, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var citySide = $feature.SC_UTIL_TY\nIF (isEmpty(citySide)){\n citySide = 'Unknown'\n}\nvar custSide = $feature.SC_CONS_TY\nIF (isEmpty(custSide)){\n custSide = 'Unknown'\n}\nvar yearBuilt = $feature.AYB1ST\nvar numServices = $feature.NumberServices\n\n\nfunction calcYearBuilt(){\n If (!IsEmpty(yearBuilt)){\n var yearBuiltReport = When(yearBuilt >= 1968, 'Non-Lead', yearBuilt < 1942, 'Unknown, Original construction year before 1942, Records review and possibly potholing to determine material', 'Unknown, Original construction year between 1942 and 1967, Lead pipe less commonly used during this period and discontinued in 1967. Records review and possibly potholing to determine material')\n return yearBuiltReport}\n Else{\n return 'Unknown, Original construction year is unknown, Records review and possibly potholing to determine material'\n}\n}\n\nIF (isEmpty(numServices)){\n return calcYearBuilt()}\n\n\nIF (numServices == 1){\n IF (citySide == 'Lead' || custSide == 'Lead'){\n return 'Lead Found'}\n IF (citySide == 'Galvanized Requiring Repl' || custSide == 'Galvanized Requiring Repl'){\n return 'Galvanized Requiring Repl'}\n\n Else IF ((citySide != 'Unknown') && (custSide != 'Unknown') ) {\n return 'Non-Lead'\n}\n\n Else {\n return calcYearBuilt()\n}}\nElse IF (numServices > 1){\n var citySideList = Split(citySide, ',', -1, false)\n var custSideList = Split(custSide, ',', -1, false)\n\n if (Includes(citySideList, 'Lead')){return 'Lead Found'}\n if (Includes(custSideList, 'Lead')){return 'Lead Found'}\n if (Includes(citySideList, 'Galvanized Requiring Repl')){return 'Galvanized Requiring Repl'}\n if (Includes(custSideList, 'Galvanized Requiring Repl')){return 'Galvanized Requiring Repl'}\n if (Includes(citySideList, 'Unknown')){return calcYearBuilt()}\n if (Includes(custSideList, 'Unknown')){return calcYearBuilt()}\n Else{ return 'Non-Lead'}\n}\n\nElse {\n return 'Unknown, Original construction year is unknown, Records review and possibly potholing to determine material'}", "valueExpressionTitle": "Custom", "uniqueValueGroups": [ { "heading": "Water Service Materials", "classes": [ { "label": "Lead Found", "description": "Lead Found", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 230, 0, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "values": [ [ "Lead Found" ] ] }, { "label": "Galvanized Requiring Replacement", "description": "Galvanized Requiring Replacement", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 200, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "values": [ [ "Galvanized Requiring Repl" ] ] }, { "label": "Non-Lead", "description": "Non-Lead", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 56, 168, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "values": [ [ "Non-Lead" ] ] }, { "label": "Unknown, Original construction year before 1942, Records review and possibly potholing to determine material", "description": "Unknown, Original construction year before 1942, Records review and possibly potholing to determine material", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 170, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "values": [ [ "Unknown, Original construction year before 1942, Records review and possibly potholing to determine material" ] ] }, { "label": "Unknown, Original construction year between 1942 and 1967, Lead pipe less commonly used during this period and discontinued in 1967. Records review and possibly potholing to determine material", "description": "Unknown, Original construction year between 1942 and 1967, Lead pipe less commonly used during this period and discontinued in 1967. Records review and possibly potholing to determine material", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "values": [ [ "Unknown, Original construction year between 1942 and 1967, Lead pipe less commonly used during this period and discontinued in 1967. Records review and possibly potholing to determine material" ] ] }, { "label": "Unknown, Original construction year is unknown, Records review and possibly potholing to determine material", "description": "Unknown, Original construction year is unknown, Records review and possibly potholing to determine material", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 130, 130, 130, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "values": [ [ "Unknown, Original construction year is unknown, Records review and possibly potholing to determine material" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 230, 0, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "value": "Lead Found", "label": "Lead Found" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 200, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "value": "Galvanized Requiring Repl", "label": "Galvanized Requiring Replacement" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 56, 168, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "value": "Non-Lead", "label": "Non-Lead" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 170, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "value": "Unknown, Original construction year before 1942, Records review and possibly potholing to determine material", "label": "Unknown, Original construction year before 1942, Records review and possibly potholing to determine material" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 255, 0, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "value": "Unknown, Original construction year between 1942 and 1967, Lead pipe less commonly used during this period and discontinued in 1967. Records review and possibly potholing to determine material", "label": "Unknown, Original construction year between 1942 and 1967, Lead pipe less commonly used during this period and discontinued in 1967. Records review and possibly potholing to determine material" }, { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 130, 130, 130, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 178, 178, 178, 255 ], "width": 0.7 } }, "value": "Unknown, Original construction year is unknown, Records review and possibly potholing to determine material", "label": "Unknown, Original construction year is unknown, Records review and possibly potholing to determine material" } ], "fieldDelimiter": ";", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 207, 250, 255 ], "toColor": [ 252, 207, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 252, 179, 255 ], "toColor": [ 184, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 249, 252, 255 ], "toColor": [ 182, 249, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 211, 179, 255 ], "toColor": [ 252, 211, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 209, 252, 255 ], "toColor": [ 189, 209, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 247, 252, 192, 255 ], "toColor": [ 247, 252, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 188, 179, 252, 255 ], "toColor": [ 188, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 182, 255 ], "toColor": [ 252, 179, 182, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 199, 252, 222, 255 ], "toColor": [ 199, 252, 222, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 233, 179, 252, 255 ], "toColor": [ 233, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 222, 255 ], "toColor": [ 252, 210, 222, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 247, 215, 255 ], "toColor": [ 252, 247, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 228, 252, 255 ], "toColor": [ 179, 228, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 668009.5599999996, "ymin": 4285647, "xmax": 747594.0439999998, "ymax": 4354092.973200001, "spatialReference": { "wkid": 32612, "latestWkid": 32612, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PARCEL_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "PARCEL_NUM", "type": "esriFieldTypeString", "alias": "PARCEL_NUM", "length": 15, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "AYB1ST", "type": "esriFieldTypeInteger", "alias": "AYB1ST", "domain": null }, { "name": "NumberServices", "type": "esriFieldTypeInteger", "alias": "NumberServices", "domain": null }, { "name": "SC_UTIL_TY", "type": "esriFieldTypeString", "alias": "SC_UTIL_TY", "length": 100, "domain": null }, { "name": "SC_CONS_TY", "type": "esriFieldTypeString", "alias": "SC_CONS_TY", "length": 255, "domain": null }, { "name": "SC_NUMBER", "type": "esriFieldTypeString", "alias": "SC_NUMBER", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "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": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape_Length", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape_Area", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R396_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_396", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_396", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S385_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1687458133000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "4b9ec3d9bc994ac498bc726fd8cf7a55" }