{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Water Lead Service Line Inventory", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "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" }, "hasMetadata": true, "extent": { "xmin": 327845.7694366425, "ymin": 2859500.7313875556, "xmax": 360163.06339772046, "ymax": 2886139.644645065, "spatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.002, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.3190224931465885E8, "falseY": -1.0361886448540163E8, "xyUnits": 3.397449712481741E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102686, "latestWkid": 2249, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119851500, "falseY": -94498200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 107, 77, 155, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "TIECardFileName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "SITE ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SiteID" }, { "name": "LocationalIdentifer", "type": "esriFieldTypeString", "alias": "LOCATIONAL IDENTIFIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LocationalIdentifer" }, { "name": "LCRLocation", "type": "esriFieldTypeString", "alias": "LCR SAMPLING LOCATION?", "domain": { "type": "codedValue", "name": "LCRLocation", "description": "LCR Sampling Location", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LCRLocation" }, { "name": "ConnectorPresent", "type": "esriFieldTypeString", "alias": "CONNECTOR (GOOSENECK / PIGTAIL) CURRENTLY PRESENT?", "domain": { "type": "codedValue", "name": "ConnectorPresent", "description": "Connector Present", "codedValues": [ { "name": "Yes, Known with Certainty", "code": "YES" }, { "name": "No, Known with Certainty", "code": "NO" }, { "name": "Unknown, Not Known with Certainty", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ConnectorPresent" }, { "name": "CONNECTORMATERIAL", "type": "esriFieldTypeString", "alias": "CONNECTOR (GOOSENECK /PIGTAIL) MATERIAL", "domain": { "type": "codedValue", "name": "ConnectorMaterial", "description": "Connector Material", "codedValues": [ { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Brass", "code": "B" }, { "name": "Steel", "code": "S" }, { "name": "Plastic", "code": "P" }, { "name": "Other, does not contain lead of lead solder", "code": "O" }, { "name": "Unknown, definitely does not contain lead or galvanized", "code": "UNK-NOLG" }, { "name": "Plastic (PVC)", "code": "PVC" }, { "name": "Plastic (HDPE)", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CONNECTORMATERIAL" }, { "name": "CurrentPublicSLMaterial", "type": "esriFieldTypeString", "alias": "CURRENT PUBLIC SERVICE LINE MATERIAL", "domain": { "type": "codedValue", "name": "CurrentPublicSLMaterial", "description": "Current Public Service Line Material", "codedValues": [ { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Galvanized", "code": "G" }, { "name": "Plastic", "code": "P" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Lined Cast Iron", "code": "CI-L" }, { "name": "Unlined Cast Iron", "code": "CI-U" }, { "name": "Brass", "code": "B" }, { "name": "Unknown, may contain lead and/or galvanized", "code": "UNK-LG" }, { "name": "Unknown, definitely does not contain lead or galvanized", "code": "UNK-NOLG" }, { "name": "Plastic (PVC)", "code": "PVC" }, { "name": "Plastic (HDPE)", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CurrentPublicSLMaterial" }, { "name": "PublicSLPrevLead", "type": "esriFieldTypeString", "alias": "WAS PUBLIC SERVICE LINE MATERIAL EVER PREVIOUSLY LEAD?", "domain": { "type": "codedValue", "name": "PublicSLPrevLead", "description": "Public Service Line Material Ever Previously Lead", "codedValues": [ { "name": "Yes, Known with Certainty", "code": "YES" }, { "name": "No, Known with Certainty", "code": "NO" }, { "name": "Unknown, Not Known with Certainty", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "UNK", "modelName": "PublicSLPrevLead" }, { "name": "PublicSLSize", "type": "esriFieldTypeString", "alias": "PUBLIC SERVICE LINE SIZE\n(inches)", "domain": { "type": "codedValue", "name": "PublicSLSize", "description": "Public Service Line Size", "codedValues": [ { "name": "3/8\"", "code": "3/8\"" }, { "name": "1/2\"", "code": "1/2\"" }, { "name": "5/8\"", "code": "5/8\"" }, { "name": "3/4\"", "code": "3/4\"" }, { "name": "1\"", "code": "1\"" }, { "name": "1 1/4\"", "code": "1 1/4\"" }, { "name": "1 1/2\"", "code": "1 1/2\"" }, { "name": "1 3/4\"", "code": "1 3/4\"" }, { "name": "2\"", "code": "2\"" }, { "name": "3\"", "code": "3\"" }, { "name": "4\"", "code": "4\"" }, { "name": "6\"", "code": "6\"" }, { "name": "8\"", "code": "8\"" }, { "name": "10\"", "code": "10\"" }, { "name": "12\"", "code": "12\"" }, { "name": "14\"", "code": "14\"" }, { "name": "16\"", "code": "16\"" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PublicSLSize" }, { "name": "Public_SLInstallDate", "type": "esriFieldTypeString", "alias": "PUBLIC SERVICE LINE INSTALL DATE\n(YYYY)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Public_SLInstallDate" }, { "name": "CurrentPrivateSLMaterial", "type": "esriFieldTypeString", "alias": "CURRENT PRIVATE SERVICE LINE MATERIAL", "domain": { "type": "codedValue", "name": "CurrentPrivateSLMaterial", "description": "Current Private Service Line Material", "codedValues": [ { "name": "Plastic", "code": "P" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Lined Cast Iron", "code": "CI-L" }, { "name": "Unlined Cast Iron", "code": "CI-U" }, { "name": "Brass", "code": "B" }, { "name": "Unknown, may contain lead and/or galvanized", "code": "UNK-LG" }, { "name": "Unknown, definitely does not contain lead or galvanized", "code": "UNK-NOLG" }, { "name": "Plastic (PVC)", "code": "PVC" }, { "name": "Plastic (HDPE)", "code": "HDPE" }, { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Galvanized", "code": "G" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CurrentPrivateSLMaterial" }, { "name": "PrivateSLSize", "type": "esriFieldTypeString", "alias": "PRIVATE SERVICE LINE SIZE\n(inches)", "domain": { "type": "codedValue", "name": "PrivateSLSize", "description": "Private Service Line Size", "codedValues": [ { "name": "3/8\"", "code": "3/8\"" }, { "name": "1/2\"", "code": "1/2\"" }, { "name": "5/8\"", "code": "5/8\"" }, { "name": "3/4\"", "code": "3/4\"" }, { "name": "1\"", "code": "1\"" }, { "name": "1 1/4\"", "code": "1 1/4\"" }, { "name": "1 1/2\"", "code": "1 1/2\"" }, { "name": "1 3/4\"", "code": "1 3/4\"" }, { "name": "2\"", "code": "2\"" }, { "name": "3\"", "code": "3\"" }, { "name": "4\"", "code": "4\"" }, { "name": "6\"", "code": "6\"" }, { "name": "8\"", "code": "8\"" }, { "name": "10\"", "code": "10\"" }, { "name": "12\"", "code": "12\"" }, { "name": "14\"", "code": "14\"" }, { "name": "16\"", "code": "16\"" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PrivateSLSize" }, { "name": "Private_SLInstallDate", "type": "esriFieldTypeString", "alias": "PRIVATE SERVICE LINE INSTALL DATE\n(YYYY)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Private_SLInstallDate" }, { "name": "EntireServiceLine", "type": "esriFieldTypeString", "alias": "ENTIRE SERVICE LINE CLASSIFICATION", "domain": { "type": "codedValue", "name": "EntireServiceLine", "description": "Entire Service Line Classification", "codedValues": [ { "name": "LEAD", "code": "LEAD" }, { "name": "NON-LEAD", "code": "NON-LEAD" }, { "name": "LEAD STATUS UNKNOWN", "code": "LEAD STATUS UNKNOWN" }, { "name": "GALVANIZED REQUIRING REPLACEMENT", "code": "GALVANIZED REQUIRING REPLACEMENT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EntireServiceLine" }, { "name": "VerificationMethod", "type": "esriFieldTypeString", "alias": "VERIFICATION\nMETHOD", "domain": { "type": "codedValue", "name": "VerificationMethod", "description": "Verification Method", "codedValues": [ { "name": "Field Inspection by PWS", "code": "F" }, { "name": "Records Review", "code": "V" }, { "name": "Statistical Analysis", "code": "A" }, { "name": "Customer Self-Identification", "code": "C" }, { "name": "Sequential Monitoring", "code": "S" }, { "name": "Other MassDEP-Approved Method", "code": "O" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VerificationMethod" }, { "name": "OtherMassDEPMethod", "type": "esriFieldTypeString", "alias": "OTHER MASSDEP APPROVED VERIFICATION METHOD", "domain": { "type": "codedValue", "name": "OtherMassDEPMethod", "description": "Other MassDEP Approved Verification Method", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherMassDEPMethod" }, { "name": "BuildingType", "type": "esriFieldTypeString", "alias": "BUILDING TYPE", "domain": { "type": "codedValue", "name": "BuildingType", "description": "Building Type", "codedValues": [ { "name": "Single-Family", "code": "SF" }, { "name": "Multi-Family", "code": "MF" }, { "name": "School/Childcare", "code": "SCH/CC" }, { "name": "Residential & In-Home Child Care", "code": "RES/CC" }, { "name": "Nonresidential, Non-School, Non-Childcare", "code": "NONRES" }, { "name": "Mixed Residential & Nonresidential", "code": "MIX" }, { "name": "Other", "code": "O" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BuildingType" }, { "name": "POEPOUTreatment", "type": "esriFieldTypeString", "alias": "POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT?", "domain": { "type": "codedValue", "name": "POEPOUTreatment", "description": "POE/POU Treatment Present", "codedValues": [ { "name": "Yes, Known with Certainty", "code": "YES" }, { "name": "No, Known with Certainty", "code": "NO" }, { "name": "Unknown, Not Known with Certainty", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "POEPOUTreatment" }, { "name": "BuildingPlumbingMaterial1", "type": "esriFieldTypeString", "alias": "BUILDING PLUMBING MATERIAL 1", "domain": { "type": "codedValue", "name": "BuildingPlumbingMaterial1", "description": "Building Plumbing Material 1", "codedValues": [ { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Copper w/ Lead Solder", "code": "CLS" }, { "name": "Brass", "code": "B" }, { "name": "Cross-Linked Polyethylene", "code": "PEX" }, { "name": "Other, does not contain Lead or Lead Solder", "code": "O" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BuildingPlumbingMaterial1" }, { "name": "BuildingPlumbingMaterial2", "type": "esriFieldTypeString", "alias": "BUILDING PLUMBING MATERIAL 2", "domain": { "type": "codedValue", "name": "BuildingPlumbingMaterial2", "description": "Building Plumbing Material 2", "codedValues": [ { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Copper w/ Lead Solder", "code": "CLS" }, { "name": "Brass", "code": "B" }, { "name": "Cross-Linked Polyethylene", "code": "PEX" }, { "name": "Other, does not contain Lead or Lead Solder", "code": "O" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BuildingPlumbingMaterial2" }, { "name": "BuildingPlumbingInstallDate", "type": "esriFieldTypeString", "alias": "BUILDING PLUMBING MATERIAL INSTALL DATE\n(YYYY)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BuildingPlumbingInstallDate" }, { "name": "SamplingPlanLocation", "type": "esriFieldTypeString", "alias": " SAMPLING PLAN LOCATION", "domain": { "type": "codedValue", "name": "SamplingPlanLocation", "description": "Sampling Plan Location", "codedValues": [ { "name": "Routine Site", "code": "R" }, { "name": "Alternative Site", "code": "A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SamplingPlanLocation" }, { "name": "tier", "type": "esriFieldTypeString", "alias": "SAMPLING SITE TIER", "domain": { "type": "codedValue", "name": "tier", "description": "Sampling Site Tier", "codedValues": [ { "name": "TIER 1", "code": "TIER 1" }, { "name": "TIER 2", "code": "TIER 2" }, { "name": "TIER 3", "code": "TIER 3" }, { "name": "TIER 4", "code": "TIER 4" }, { "name": "TIER 5", "code": "TIER 5" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tier" }, { "name": "ReplacedSL", "type": "esriFieldTypeString", "alias": "REPLACED LSL PUBLIC OR PRIVATE SIDE? (DURING OR AFTER 2024)", "domain": { "type": "codedValue", "name": "ReplacedSL", "description": "Replaced Service Line", "codedValues": [ { "name": "Yes, public side of LSL", "code": "PUBLIC" }, { "name": "Yes, private side of LSL", "code": "PRIVATE" }, { "name": "Yes, both public and private side of LSL", "code": "BOTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReplacedSL" }, { "name": "ReplacedMaterial", "type": "esriFieldTypeString", "alias": "NEW REPLACED SERVICE LINE MATERIAL ", "domain": { "type": "codedValue", "name": "ReplacedMaterial", "description": "New Replaced Material", "codedValues": [ { "name": "Copper", "code": "C" }, { "name": "Plastic", "code": "P" }, { "name": "Other Material", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReplacedMaterial" }, { "name": "LSLReplacementDate", "type": "esriFieldTypeString", "alias": "LSL REPLACEMENT DATE\n(MM/DD/YYYY)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LSLReplacementDate" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "XCoordinate", "type": "esriFieldTypeDouble", "alias": "X Coordinate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "XCoordinate" }, { "name": "YCoordinate", "type": "esriFieldTypeDouble", "alias": "Y Coordinate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YCoordinate" }, { "name": "CAMAYearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "CAMA Year Built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CAMAYearBuilt" }, { "name": "CAMALUCode", "type": "esriFieldTypeString", "alias": "CAMA Land Use Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CAMALUCode" }, { "name": "Public_Verification", "type": "esriFieldTypeString", "alias": "Public_Verification", "domain": { "type": "codedValue", "name": "TBPublicPrivateVerification", "description": "Public/Private Verification", "codedValues": [ { "name": "Field Inspection by PWS", "code": "F" }, { "name": "Records Review", "code": "V" }, { "name": "Statistical Analysis", "code": "A" }, { "name": "Customer Self-Identification", "code": "C" }, { "name": "Sequential Monitoring", "code": "S" }, { "name": "Other MassDEP- Approved Method", "code": "O" }, { "name": "Water Department", "code": "Water Department" }, { "name": "Water Main", "code": "Water Main" }, { "name": "CAMA Year Built", "code": "CAMA" }, { "name": "No Data", "code": "No Data" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Public_Verification" }, { "name": "Private_Verification", "type": "esriFieldTypeString", "alias": "Private_Verification", "domain": { "type": "codedValue", "name": "TBPublicPrivateVerification", "description": "Public/Private Verification", "codedValues": [ { "name": "Field Inspection by PWS", "code": "F" }, { "name": "Records Review", "code": "V" }, { "name": "Statistical Analysis", "code": "A" }, { "name": "Customer Self-Identification", "code": "C" }, { "name": "Sequential Monitoring", "code": "S" }, { "name": "Other MassDEP- Approved Method", "code": "O" }, { "name": "Water Department", "code": "Water Department" }, { "name": "Water Main", "code": "Water Main" }, { "name": "CAMA Year Built", "code": "CAMA" }, { "name": "No Data", "code": "No Data" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Private_Verification" }, { "name": "Main_YearInstalled", "type": "esriFieldTypeString", "alias": "Main_YearInstalled", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_YearInstalled" }, { "name": "Main_Material", "type": "esriFieldTypeString", "alias": "Main_Material", "domain": { "type": "codedValue", "name": "CurrentPublicSLMaterial", "description": "Current Public Service Line Material", "codedValues": [ { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Galvanized", "code": "G" }, { "name": "Plastic", "code": "P" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Lined Cast Iron", "code": "CI-L" }, { "name": "Unlined Cast Iron", "code": "CI-U" }, { "name": "Brass", "code": "B" }, { "name": "Unknown, may contain lead and/or galvanized", "code": "UNK-LG" }, { "name": "Unknown, definitely does not contain lead or galvanized", "code": "UNK-NOLG" }, { "name": "Plastic (PVC)", "code": "PVC" }, { "name": "Plastic (HDPE)", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_Material" }, { "name": "Main_New_Replaced", "type": "esriFieldTypeString", "alias": "Main_New_Replaced", "domain": { "type": "codedValue", "name": "New_Replaced", "description": "New or Replaced", "codedValues": [ { "name": "New", "code": "New" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_New_Replaced" }, { "name": "Main_PublicService_Installed", "type": "esriFieldTypeString", "alias": "Main_PublicServices_Installed", "domain": { "type": "codedValue", "name": "ConnectorPresent", "description": "Connector Present", "codedValues": [ { "name": "Yes, Known with Certainty", "code": "YES" }, { "name": "No, Known with Certainty", "code": "NO" }, { "name": "Unknown, Not Known with Certainty", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_PublicService_Installed" }, { "name": "Main_PublicServiceMaterial", "type": "esriFieldTypeString", "alias": "Main_PublicServiceMaterial", "domain": { "type": "codedValue", "name": "CurrentPublicSLMaterial", "description": "Current Public Service Line Material", "codedValues": [ { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Galvanized", "code": "G" }, { "name": "Plastic", "code": "P" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Lined Cast Iron", "code": "CI-L" }, { "name": "Unlined Cast Iron", "code": "CI-U" }, { "name": "Brass", "code": "B" }, { "name": "Unknown, may contain lead and/or galvanized", "code": "UNK-LG" }, { "name": "Unknown, definitely does not contain lead or galvanized", "code": "UNK-NOLG" }, { "name": "Plastic (PVC)", "code": "PVC" }, { "name": "Plastic (HDPE)", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_PublicServiceMaterial" }, { "name": "Main_PrivateService_Installed", "type": "esriFieldTypeString", "alias": "Main_PrivateServices_Installe", "domain": { "type": "codedValue", "name": "ConnectorPresent", "description": "Connector Present", "codedValues": [ { "name": "Yes, Known with Certainty", "code": "YES" }, { "name": "No, Known with Certainty", "code": "NO" }, { "name": "Unknown, Not Known with Certainty", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_PrivateService_Installed" }, { "name": "Main_PrivateServicesMaterial", "type": "esriFieldTypeString", "alias": "Main_PrivateServicesMaterial", "domain": { "type": "codedValue", "name": "CurrentPrivateSLMaterial", "description": "Current Private Service Line Material", "codedValues": [ { "name": "Plastic", "code": "P" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Lined Cast Iron", "code": "CI-L" }, { "name": "Unlined Cast Iron", "code": "CI-U" }, { "name": "Brass", "code": "B" }, { "name": "Unknown, may contain lead and/or galvanized", "code": "UNK-LG" }, { "name": "Unknown, definitely does not contain lead or galvanized", "code": "UNK-NOLG" }, { "name": "Plastic (PVC)", "code": "PVC" }, { "name": "Plastic (HDPE)", "code": "HDPE" }, { "name": "Lead", "code": "L" }, { "name": "Copper", "code": "C" }, { "name": "Galvanized", "code": "G" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_PrivateServicesMaterial" }, { "name": "TIECardFileName", "type": "esriFieldTypeString", "alias": "TIE Card File Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TIECardFileName" }, { "name": "TIECardFilePath", "type": "esriFieldTypeString", "alias": "TIE Card File Path", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "TIECardFilePath" }, { "name": "Active_Inactive", "type": "esriFieldTypeString", "alias": "Active or Inactive?", "domain": { "type": "codedValue", "name": "Active_Inactive", "description": "Active or Inactive", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Active_Inactive" }, { "name": "PublicRandom", "type": "esriFieldTypeDouble", "alias": "PublicRandom", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PublicRandom" }, { "name": "PrivateRandom", "type": "esriFieldTypeDouble", "alias": "PrivateRandom", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrivateRandom" }, { "name": "Public_InspectionTarget", "type": "esriFieldTypeSmallInteger", "alias": "Public_InspectionTarget", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Public_InspectionTarget" }, { "name": "Private_InspectionTarget", "type": "esriFieldTypeSmallInteger", "alias": "Private_InspectionTaeget", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Private_InspectionTarget" }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "CreationDate" }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Creator" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "EditDate" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Editor" }, { "name": "LUDesc", "type": "esriFieldTypeString", "alias": "LU Description", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "LUDesc" }, { "name": "OwnerName", "type": "esriFieldTypeString", "alias": "OwnerName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OwnerName" }, { "name": "MailingCity", "type": "esriFieldTypeString", "alias": "MailingCity", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailingCity" }, { "name": "MailingState", "type": "esriFieldTypeString", "alias": "MailingState", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailingState" }, { "name": "MailingZipCode", "type": "esriFieldTypeString", "alias": "MailingZipCode", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailingZipCode" }, { "name": "MailingAddress", "type": "esriFieldTypeString", "alias": "MailingAddress", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailingAddress" }, { "name": "PrivateVerificationDescriptio", "type": "esriFieldTypeString", "alias": "PrivateVerificationDescriptio", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PrivateVerificationDescriptio" }, { "name": "PublicVerificationDescription", "type": "esriFieldTypeString", "alias": "PublicVerificationDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PublicVerificationDescription" }, { "name": "FacilityID_FromPublic", "type": "esriFieldTypeString", "alias": "FacilityID_FromPublic", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FacilityID_FromPublic" }, { "name": "FacilityID_FromPrivate", "type": "esriFieldTypeString", "alias": "FacilityID_FromPrivate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FacilityID_FromPrivate" }, { "name": "MultipleLaterals", "type": "esriFieldTypeString", "alias": "MultipleLaterals", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MultipleLaterals" }, { "name": "FacilityID_FromUNKOwner", "type": "esriFieldTypeString", "alias": "FacilityID_FromUNKOwner", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FacilityID_FromUNKOwner" }, { "name": "ESL_RandomNumber", "type": "esriFieldTypeDouble", "alias": "ESL_RandomNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESL_RandomNumber" }, { "name": "ESL_InspectionSelection", "type": "esriFieldTypeDouble", "alias": "ESL_InspectionSelection", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESL_InspectionSelection" }, { "name": "ValidationPoolPrivateRandomNumb", "type": "esriFieldTypeDouble", "alias": "Validation Pool Private Random Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ValidationPoolPrivateRandomNumb" }, { "name": "ValidationPoolPublicRandomNumbe", "type": "esriFieldTypeDouble", "alias": "Validation Pool Public Random Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ValidationPoolPublicRandomNumbe" }, { "name": "ValidationInspectionPool", "type": "esriFieldTypeInteger", "alias": "Validation Inspection Pool", "domain": { "type": "codedValue", "name": "ServicePoint_ValidationInspectionPool_4bbd0877-4f96-43bf-9cd4-564fec6a0dea", "description": "", "codedValues": [ { "name": "No Selection", "code": 0 }, { "name": "Private Side Validation Inspection Pool", "code": 1 }, { "name": "Public Side Validation Inspection Pool", "code": 2 }, { "name": "Both Sides Apart of Validation Inspection Pool", "code": 3 }, { "name": "Private Side Geographic Alternative", "code": 4 }, { "name": "Public Side Geographic Alternative", "code": 5 }, { "name": "Both Sides Geographic Alternatives", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ValidationInspectionPool" }, { "name": "ValidationPoolInspectionStatus", "type": "esriFieldTypeString", "alias": "Validation Pool Inspection Status", "domain": { "type": "codedValue", "name": "ServicePoint_ValidationPoolInspectionStatus_78c18203-1942-478c-a149-57d68d10a9c4", "description": "", "codedValues": [ { "name": "Private Side Not Inspected", "code": "Private Side Not Inspected" }, { "name": "Public Side Not Inspected", "code": "Public Side Not Inspected" }, { "name": "Neither Side Inspected", "code": "Neither Side Inspected" }, { "name": "Private Side Inspected", "code": "Private Side Inspected" }, { "name": "Public Side Inspected", "code": "Public Side Inspected" }, { "name": "Both Sides Inspected", "code": "Both Sides Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "ValidationPoolInspectionStatus" }, { "name": "ValidationPoolClassification", "type": "esriFieldTypeString", "alias": "Validation Pool Classification", "domain": { "type": "codedValue", "name": "ServicePoint_ValidationPoolClassification_eae1d773-8c3f-4be9-8873-40983ecda766", "description": "", "codedValues": [ { "name": "Private Side Verified Non-Lead", "code": "Private Side Verified Non-Lead" }, { "name": "Public Side Verified Non-Lead", "code": "Public Side Verified Non-Lead" }, { "name": "Both Sides Verified Non-Lead", "code": "Both Sides Verified Non-Lead" }, { "name": "Private Side Verified Lead", "code": "Private Side Verified Lead" }, { "name": "Public Side Verified Lead", "code": "Public Side Verified Lead" }, { "name": "Both Sides Verified Lead", "code": "Both Sides Verified Lead" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "ValidationPoolClassification" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1169_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1169", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S715_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Lead Service Line Inventory", "description": "", "prototype": { "attributes": { "ValidationPoolInspectionStatus": null, "ValidationInspectionPool": null, "SiteID": null, "LocationalIdentifer": null, "LCRLocation": null, "ConnectorPresent": null, "CONNECTORMATERIAL": null, "CurrentPublicSLMaterial": null, "PublicSLPrevLead": "UNK", "PublicSLSize": null, "Public_SLInstallDate": null, "CurrentPrivateSLMaterial": null, "PrivateSLSize": null, "Private_SLInstallDate": null, "EntireServiceLine": null, "VerificationMethod": null, "OtherMassDEPMethod": null, "BuildingType": null, "POEPOUTreatment": null, "BuildingPlumbingMaterial1": null, "BuildingPlumbingMaterial2": null, "BuildingPlumbingInstallDate": null, "SamplingPlanLocation": null, "tier": null, "ReplacedSL": null, "ReplacedMaterial": null, "LSLReplacementDate": null, "COMMENTS": null, "ValidationPoolClassification": null, "XCoordinate": null, "YCoordinate": null, "CAMAYearBuilt": null, "CAMALUCode": null, "Public_Verification": null, "Private_Verification": null, "Main_YearInstalled": null, "Main_Material": null, "Main_New_Replaced": null, "Main_PublicService_Installed": null, "Main_PublicServiceMaterial": null, "Main_PrivateService_Installed": null, "Main_PrivateServicesMaterial": null, "TIECardFileName": null, "TIECardFilePath": null, "Active_Inactive": null, "PublicRandom": null, "PrivateRandom": null, "Public_InspectionTarget": null, "Private_InspectionTarget": null, "CreationDate": null, "Creator": null, "EditDate": null, "Editor": null, "LUDesc": null, "OwnerName": null, "MailingCity": null, "MailingState": null, "MailingZipCode": null, "MailingAddress": null, "PrivateVerificationDescriptio": null, "PublicVerificationDescription": null, "FacilityID_FromPublic": null, "FacilityID_FromPrivate": null, "MultipleLaterals": null, "FacilityID_FromUNKOwner": null, "ESL_RandomNumber": null, "ESL_InspectionSelection": null, "ValidationPoolPrivateRandomNumb": null, "ValidationPoolPublicRandomNumbe": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }