{ "currentVersion" : 12, "id" : 0, "name" : "Lateral Line Inventory", "type" : "Feature Layer", "serviceItemId" : "188014966b16428ba3bb981548e48275", "cacheMaxAge" : 30, "displayField" : "r_St_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "DateCreated", "creatorField" : "CreatedBy", "editDateField" : "LastUpdate", "editorField" : "LastEditor" }, "editingInfo" : { "lastEditDate" : 1792159200564, "schemaLastEditDate" : 1792159200564, "dataLastEditDate" : 1792159200564 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 2236866.1329354495, "ymin" : 10454002.141095519, "xmax" : 2286305.64265202, "ymax" : 10518867.703621358, "spatialReference" : { "wkid" : 102739, "latestWkid" : 2277 } }, "spatialReference" : { "wkid" : 102739, "latestWkid" : 2277 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"r_Entire_ServiceLine_Material","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"Entire_Classification","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[52,52,52,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.2}},"values":[["Unknown"]]},{"label":"Non-Lead","description":"Non-Lead","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,168,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[152,230,0,255],"width":0.2}},"values":[["Non-Lead"]]},{"label":"Galvanized Requiring Replacement","description":"Galvanized Requiring Replacement","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[232,252,192,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Galvanized Requiring Replacement"]]},{"label":"Lead","description":"Lead","symbol":{"type":"esriPMS","url":"7089a1df5140e061e2dfb52584a409ae","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAYAAACprHcmAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAx0lEQVQYlaXQMUsCARjG8d9wSxhIk7tSgy5tLbq3hiStTS1u4SR9CwOnlhZpiAyhoaFBBL9AcOAcYZQYGELcEAceHHYE4TP++b/wvE/gHwk2kfcOOP2iGPEQMsB7lly9pHtIZQevNNoM7zjCR1oOTmjVqRRWID64oPbM8YRuWs7lKCVikiJ22Z+s1fieMltiKyXP8MnLeuflgM4VtbMVfMM14Yhe1oM3TaJHzsvkx4RPdJC0+DXdbZ/7PttYIPpr5zixMM/gfgCdUC7QmL5hFQAAAABJRU5ErkJggg==","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"values":[["Lead"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[52,52,52,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.2}},"value":"Unknown","label":"Unknown"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,168,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[152,230,0,255],"width":0.2}},"value":"Non-Lead","label":"Non-Lead"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[232,252,192,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Galvanized Requiring Replacement","label":"Galvanized Requiring Replacement"},{"symbol":{"type":"esriPMS","url":"7089a1df5140e061e2dfb52584a409ae","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAYAAACprHcmAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAx0lEQVQYlaXQMUsCARjG8d9wSxhIk7tSgy5tLbq3hiStTS1u4SR9CwOnlhZpiAyhoaFBBL9AcOAcYZQYGELcEAceHHYE4TP++b/wvE/gHwk2kfcOOP2iGPEQMsB7lly9pHtIZQevNNoM7zjCR1oOTmjVqRRWID64oPbM8YRuWs7lKCVikiJ22Z+s1fieMltiKyXP8MnLeuflgM4VtbMVfMM14Yhe1oM3TaJHzsvkx4RPdJC0+DXdbZ/7PttYIPpr5zixMM/gfgCdUC7QmL5hFQAAAABJRU5ErkJggg==","contentType":"image/png","width":8,"height":8,"angle":0,"xoffset":0,"yoffset":0},"value":"Lead","label":"Lead"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,237,182,255],"toColor":[252,237,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[243,182,252,255],"toColor":[243,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,244,252,255],"toColor":[192,244,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,190,255],"toColor":[252,189,190,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,252,187,255],"toColor":[188,252,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,205,252,255],"toColor":[192,205,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,252,255],"toColor":[252,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,252,226,255],"toColor":[189,252,226,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,228,212,255],"toColor":[252,228,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,252,207,255],"toColor":[225,252,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,222,252,255],"toColor":[179,222,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[191,182,252,255],"toColor":[191,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,214,255],"toColor":[252,184,214,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "timeInfo" : { "startTimeField" : "", "endTimeField" : "", "trackIdField" : "", "timeExtent" : [], "timeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : true }, "timeInterval" : 0, "timeIntervalUnits" : "", "exportOptions" : "", "hasLiveData" : false }, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "r_Entire_ServiceLine_Material", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "r_WSLID", "type" : "esriFieldTypeString", "alias" : "WSLID", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "r_St_Number", "type" : "esriFieldTypeDouble", "alias" : "St_Num", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "r_St_Name", "type" : "esriFieldTypeString", "alias" : "St_Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "r_City", "type" : "esriFieldTypeString", "alias" : "City_Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "City", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "City", "codedValues" : [ { "name" : "San Angelo", "code" : "San Angelo" }, { "name" : "Other", "code" : "Other" } ] }, "defaultValue" : null }, { "name" : "r_Zipcode", "type" : "esriFieldTypeDouble", "alias" : "Zip_Address", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "o_Other_Loc_Identifiers", "type" : "esriFieldTypeString", "alias" : "o_Other_Loc_Desc", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "o_Latitude", "type" : "esriFieldTypeDouble", "alias" : "Y_Coord", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "o_Longitude", "type" : "esriFieldTypeDouble", "alias" : "X_Coord", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "r_System_Material", "type" : "esriFieldTypeString", "alias" : "System_Material", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ServiceLineMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Serivce Line Material - Customer and City sides", "codedValues" : [ { "name" : "Lead", "code" : "Lead" }, { "name" : "Galvanized", "code" : "Galvanized" }, { "name" : "Unknown - Likely Lead", "code" : "Unknown - Likely Lead" }, { "name" : "Unknown - Unlikely Lead", "code" : "Unknown - Unlikely Lead" }, { "name" : "Unknown - Material Unknown", "code" : "Unknown - Material Unknown" }, { "name" : "Non-Lead - Copper", "code" : "Non-Lead - Copper" }, { "name" : "Non-Lead - Plastic", "code" : "Non-Lead - Plastic" }, { "name" : "Non-Lead - Other", "code" : "Non-Lead - Other" }, { "name" : "Lead-lined galvanized", "code" : "Lead-lined galvanized" } ] }, "defaultValue" : null }, { "name" : "o_Material_Prev_Lead", "type" : "esriFieldTypeString", "alias" : "o_Material_Prev_Lead", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNoDK", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes No Don't Know", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" }, { "name" : "Don't Know", "code" : "Don't Know" } ] }, "defaultValue" : null }, { "name" : "o_System_Install_Date", "type" : "esriFieldTypeString", "alias" : "o_System_Install_Date", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Install_Date", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "System and Customer install date", "codedValues" : [ { "name" : "Before 1989", "code" : "Before 1989" }, { "name" : "Between 1989 and 2014", "code" : "Between 1989 and 2014" }, { "name" : "After 2014", "code" : "After 2014" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "o_System_Notes", "type" : "esriFieldTypeString", "alias" : "o_System_Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EPA_System_Diameter", "type" : "esriFieldTypeString", "alias" : "System_Diameter", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Service line diameter", "codedValues" : [ { "name" : "3/8\"", "code" : "3/8\"" }, { "name" : "1/4\"", "code" : "1/4\"" }, { "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" : "2 1/4\"", "code" : "2 1/4\"" } ] }, "defaultValue" : null }, { "name" : "EPA_System_Class_Reason", "type" : "esriFieldTypeString", "alias" : "System_Classification_Reason", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Classification_Reason", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Classification_Reason", "codedValues" : [ { "name" : "Water Sampling Only With No Records", "code" : "Water Sampling Only With No Records" }, { "name" : "Tap Card", "code" : "Tap Card" }, { "name" : "Repair/Replacement Record", "code" : "Repair/Replacement Record" }, { "name" : "Previous Materials Evaluation", "code" : "Previous Materials Evaluation" }, { "name" : "Predictive Model", "code" : "Predictive Model" }, { "name" : "Installation After Lead Ban Date", "code" : "Installation After Lead Ban Date" }, { "name" : "Field Inspection Only With No Records", "code" : "Field Inspection Only With No Records" }, { "name" : "Diameter \u003e 2-inch", "code" : "Diameter \u003e 2-inch" }, { "name" : "Construction Date After Lead Ban Date", "code" : "Construction Date After Lead Ban Date" }, { "name" : "As-Built", "code" : "As-Built" } ] }, "defaultValue" : null }, { "name" : "EPA_System_Material_Verified", "type" : "esriFieldTypeString", "alias" : "System_Material_Verified", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNoDK", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes No Don't Know", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" }, { "name" : "Don't Know", "code" : "Don't Know" } ] }, "defaultValue" : null }, { "name" : "EPA_Syst_Verification_Method", "type" : "esriFieldTypeString", "alias" : "System_Verification_Method", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Verification_Method", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Verification_Method", "codedValues" : [ { "name" : "CCTV", "code" : "CCTV" }, { "name" : "City Verified", "code" : "City Verified" }, { "name" : "Customer Self-Identified", "code" : "Customer Self-Identified" }, { "name" : "Excavation", "code" : "Excavation" }, { "name" : "Hydroexcavation", "code" : "Hydroexcavation" }, { "name" : "Lead Swab", "code" : "Lead Swab" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Visual Inspection", "code" : "Visual Inspection" }, { "name" : "Water Quality Sampling", "code" : "Water Quality Sampling" } ] }, "defaultValue" : null }, { "name" : "EPA_System_Verification_Date", "type" : "esriFieldTypeDate", "alias" : "System_Verification_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "r_Customer_Material", "type" : "esriFieldTypeString", "alias" : "Customer_Material", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ServiceLineMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Serivce Line Material - Customer and City sides", "codedValues" : [ { "name" : "Lead", "code" : "Lead" }, { "name" : "Galvanized", "code" : "Galvanized" }, { "name" : "Unknown - Likely Lead", "code" : "Unknown - Likely Lead" }, { "name" : "Unknown - Unlikely Lead", "code" : "Unknown - Unlikely Lead" }, { "name" : "Unknown - Material Unknown", "code" : "Unknown - Material Unknown" }, { "name" : "Non-Lead - Copper", "code" : "Non-Lead - Copper" }, { "name" : "Non-Lead - Plastic", "code" : "Non-Lead - Plastic" }, { "name" : "Non-Lead - Other", "code" : "Non-Lead - Other" }, { "name" : "Lead-lined galvanized", "code" : "Lead-lined galvanized" } ] }, "defaultValue" : null }, { "name" : "o_Customer_Install_Date", "type" : "esriFieldTypeString", "alias" : "o_Customer_Install_Date", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Install_Date", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "System and Customer install date", "codedValues" : [ { "name" : "Before 1989", "code" : "Before 1989" }, { "name" : "Between 1989 and 2014", "code" : "Between 1989 and 2014" }, { "name" : "After 2014", "code" : "After 2014" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "o_Customer_Notes", "type" : "esriFieldTypeString", "alias" : "o_Customer_Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EPA_Customer_Diameter", "type" : "esriFieldTypeString", "alias" : "Customer_Diameter", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Diameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Service line diameter", "codedValues" : [ { "name" : "3/8\"", "code" : "3/8\"" }, { "name" : "1/4\"", "code" : "1/4\"" }, { "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" : "2 1/4\"", "code" : "2 1/4\"" } ] }, "defaultValue" : null }, { "name" : "EPA_Customer_Class_Reason", "type" : "esriFieldTypeString", "alias" : "Customer_Classification_Reason", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Classification_Reason", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Classification_Reason", "codedValues" : [ { "name" : "Water Sampling Only With No Records", "code" : "Water Sampling Only With No Records" }, { "name" : "Tap Card", "code" : "Tap Card" }, { "name" : "Repair/Replacement Record", "code" : "Repair/Replacement Record" }, { "name" : "Previous Materials Evaluation", "code" : "Previous Materials Evaluation" }, { "name" : "Predictive Model", "code" : "Predictive Model" }, { "name" : "Installation After Lead Ban Date", "code" : "Installation After Lead Ban Date" }, { "name" : "Field Inspection Only With No Records", "code" : "Field Inspection Only With No Records" }, { "name" : "Diameter \u003e 2-inch", "code" : "Diameter \u003e 2-inch" }, { "name" : "Construction Date After Lead Ban Date", "code" : "Construction Date After Lead Ban Date" }, { "name" : "As-Built", "code" : "As-Built" } ] }, "defaultValue" : null }, { "name" : "EPA_Cust_Material_Verified", "type" : "esriFieldTypeString", "alias" : "Customer_Material_Verified", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNoDK", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes No Don't Know", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" }, { "name" : "Don't Know", "code" : "Don't Know" } ] }, "defaultValue" : null }, { "name" : "EPA_Cust_Verification_Method", "type" : "esriFieldTypeString", "alias" : "Customer_Verification_Method", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Verification_Method", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Verification_Method", "codedValues" : [ { "name" : "CCTV", "code" : "CCTV" }, { "name" : "City Verified", "code" : "City Verified" }, { "name" : "Customer Self-Identified", "code" : "Customer Self-Identified" }, { "name" : "Excavation", "code" : "Excavation" }, { "name" : "Hydroexcavation", "code" : "Hydroexcavation" }, { "name" : "Lead Swab", "code" : "Lead Swab" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Visual Inspection", "code" : "Visual Inspection" }, { "name" : "Water Quality Sampling", "code" : "Water Quality Sampling" } ] }, "defaultValue" : null }, { "name" : "EPA_Cust_Verification_Date", "type" : "esriFieldTypeDate", "alias" : "Customer_Verification_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "r_Entire_ServiceLine_Material", "type" : "esriFieldTypeString", "alias" : "Entire_Classification", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EntireServiceLineMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Serivce Line Classification for both Customer and City sides", "codedValues" : [ { "name" : "Galvanized Requiring Replacement", "code" : "Galvanized Requiring Replacement" }, { "name" : "Lead", "code" : "Lead" }, { "name" : "Non-Lead", "code" : "Non-Lead" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "o_Lead_Connector", "type" : "esriFieldTypeString", "alias" : "Lead_Connector", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNoDK", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes No Don't Know", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" }, { "name" : "Don't Know", "code" : "Don't Know" } ] }, "defaultValue" : null }, { "name" : "o_Lead_Solder", "type" : "esriFieldTypeString", "alias" : "Lead_Solder", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNoDK", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes No Don't Know", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" }, { "name" : "Don't Know", "code" : "Don't Know" } ] }, "defaultValue" : null }, { "name" : "o_Connector_Solder_Desc", "type" : "esriFieldTypeString", "alias" : "Connector_Solder_Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "o_Building_Type", "type" : "esriFieldTypeString", "alias" : "Building_Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BuildingType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "BuildingType", "codedValues" : [ { "name" : "Other", "code" : "Other" }, { "name" : "Building", "code" : "Building" }, { "name" : "Single Family Residence", "code" : "Single Family Residence" }, { "name" : "Multiple Family Residence", "code" : "Multiple Family Residence" } ] }, "defaultValue" : null }, { "name" : "o_Pnt_Entry_Trtmnt_Present", "type" : "esriFieldTypeString", "alias" : "o_Pnt_Entry_Trtmnt_Present", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNoUnk", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes No Unknown", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "o_Int_Bldg_LC_Pipes_07011989", "type" : "esriFieldTypeString", "alias" : "o_Int_Bldg_LC_Pipes_07011989", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNoUnk", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Yes No Unknown", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "o_Current_LCR_Sample_Site", "type" : "esriFieldTypeString", "alias" : "o_Current_LCR_Sample_Site", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "YesNo", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "o_Site_Tier", "type" : "esriFieldTypeString", "alias" : "o_Site_Tier", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Site_Tier", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Sample site selection criteria (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" } ] }, "defaultValue" : null }, { "name" : "o_System_LSLR_Date", "type" : "esriFieldTypeDate", "alias" : "o_System_LSLR_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "o_Customer_LSLR_Date", "type" : "esriFieldTypeDate", "alias" : "o_Customer_LSLR_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CAD_Year_Built", "type" : "esriFieldTypeDouble", "alias" : "Appraisal District Year Built", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SAN_Meter_Number", "type" : "esriFieldTypeString", "alias" : "Meter Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "SAN_Meter_Manufacture_Date", "type" : "esriFieldTypeDate", "alias" : "Meter Manufacture Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "SAN_Meter_Initiation_Date", "type" : "esriFieldTypeDate", "alias" : "Location Initiation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "SAN_Meter_Termination_Date", "type" : "esriFieldTypeString", "alias" : "Location Termination Date", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "" }, { "name" : "SAN_Meter_Install_Date", "type" : "esriFieldTypeDate", "alias" : "Meter_Install_Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "SAN_Meter_Material", "type" : "esriFieldTypeString", "alias" : "Meter_Material", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SAN_Meter_Size", "type" : "esriFieldTypeString", "alias" : "Meter_Size", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SAN_Meter_Subtype", "type" : "esriFieldTypeString", "alias" : "Meter_Subtype", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_Full_Address", "type" : "esriFieldTypeString", "alias" : "Full_Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_Pre_Dir", "type" : "esriFieldTypeString", "alias" : "St_PreDir", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "St_PreDir", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "St_PreDir", "codedValues" : [ { "name" : "N", "code" : "N" }, { "name" : "E", "code" : "E" }, { "name" : "W", "code" : "W" }, { "name" : "S", "code" : "S" }, { "name" : "NW", "code" : "NW" }, { "name" : "NE", "code" : "NE" }, { "name" : "SW", "code" : "SW" }, { "name" : "SE", "code" : "SE" } ] }, "defaultValue" : null }, { "name" : "FNI_St_Name", "type" : "esriFieldTypeString", "alias" : "FNI_St_Name", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_Street_Type", "type" : "esriFieldTypeString", "alias" : "St_Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "St_Type_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "St_Type", "codedValues" : [ { "name" : "Ave", "code" : "Ave" }, { "name" : "Blvd", "code" : "Blvd" }, { "name" : "Br", "code" : "Br" }, { "name" : "Cir", "code" : "Cir" }, { "name" : "Ct", "code" : "Ct" }, { "name" : "Dr", "code" : "Dr" }, { "name" : "Expy", "code" : "Expy" }, { "name" : "Fwy", "code" : "Fwy" }, { "name" : "Hwy", "code" : "Hwy" }, { "name" : "Ln", "code" : "Ln" }, { "name" : "Loop", "code" : "Loop" }, { "name" : "Path", "code" : "Path" }, { "name" : "Pkwy", "code" : "Pkwy" }, { "name" : "Pl", "code" : "Pl" }, { "name" : "Plz", "code" : "Plz" }, { "name" : "Ramp", "code" : "Ramp" }, { "name" : "Rd", "code" : "Rd" }, { "name" : "Run", "code" : "Run" }, { "name" : "Spur", "code" : "Spur" }, { "name" : "St", "code" : "St" }, { "name" : "Ter", "code" : "Ter" }, { "name" : "Trl", "code" : "Trl" }, { "name" : "Way", "code" : "Way" } ] }, "defaultValue" : null }, { "name" : "FNI_Dir_Suf", "type" : "esriFieldTypeString", "alias" : "St_Suffix", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "St_Dir_Suf", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "St_DirSuf", "codedValues" : [ { "name" : "N", "code" : "N" }, { "name" : "E", "code" : "E" }, { "name" : "W", "code" : "W" }, { "name" : "S", "code" : "S" }, { "name" : "NW", "code" : "NW" }, { "name" : "NE", "code" : "NE" }, { "name" : "SW", "code" : "SW" }, { "name" : "SE", "code" : "SE" }, { "name" : "EB", "code" : "EB" }, { "name" : "WB", "code" : "WB" }, { "name" : "NB", "code" : "NB" }, { "name" : "SB", "code" : "SB" } ] }, "defaultValue" : null }, { "name" : "FNI_Unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_Parcel_Class", "type" : "esriFieldTypeString", "alias" : "Parcel Classification", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_Meter_Status", "type" : "esriFieldTypeString", "alias" : "Meter Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_MHI_2022", "type" : "esriFieldTypeInteger", "alias" : "MHI 2022", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_PAR_ID", "type" : "esriFieldTypeString", "alias" : "FNI_PAR_ID", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FNI_Inventory_Notes", "type" : "esriFieldTypeString", "alias" : "FNI_Inventory_Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DateCreated", "type" : "esriFieldTypeDate", "alias" : "DateCreated", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CreatedBy", "type" : "esriFieldTypeString", "alias" : "CreatedBy", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "LastUpdate", "type" : "esriFieldTypeDate", "alias" : "LastUpdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LastEditor", "type" : "esriFieldTypeString", "alias" : "LastEditor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Work_Order_Type", "type" : "esriFieldTypeString", "alias" : "Work Order Type", "sqlType" : "sqlTypeOther", "length" : 35, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "LeadPipeWO_Type", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Lead Pipe Work Order Type", "codedValues" : [ { "name" : "Meter Change Out", "code" : "Meter Change Out" }, { "name" : "Retrofit", "code" : "Retrofit" }, { "name" : "Unable to Locate", "code" : "Unable to Locate" }, { "name" : "Unable to Complete", "code" : "Unable to Complete" }, { "name" : "Already Completed", "code" : "Already Completed" }, { "name" : "Pre-Plan/GPS", "code" : "Pre-Plan/GPS" } ] }, "defaultValue" : null }, { "name" : "Final_Read", "type" : "esriFieldTypeDouble", "alias" : "Final Read", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Meter_Make", "type" : "esriFieldTypeString", "alias" : "Meter Make", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Meter_Model", "type" : "esriFieldTypeString", "alias" : "Meter Model", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "LeadPipe_MeterModel", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Lead Pipe Meter Model", "codedValues" : [ { "name" : "T-10", "code" : "T-10" }, { "name" : "Mach-10", "code" : "Mach-10" } ] }, "defaultValue" : null }, { "name" : "New_Meter_Size", "type" : "esriFieldTypeString", "alias" : "New Meter Size", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "LeadPipeNewMeterSize", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Lead Pipe New Meter Size", "codedValues" : [ { "name" : "5/8\"", "code" : "5/8\"" }, { "name" : "3/4\"", "code" : "3/4\"" }, { "name" : "1\"", "code" : "1\"" }, { "name" : "1.5\"", "code" : "1.5\"" }, { "name" : "2\"", "code" : "2\"" }, { "name" : "3\"", "code" : "3\"" }, { "name" : "4\"", "code" : "4\"" }, { "name" : "6\"", "code" : "6\"" }, { "name" : "8\"", "code" : "8\"" }, { "name" : "10\"", "code" : "10\"" } ] }, "defaultValue" : null }, { "name" : "New_Meter_Read", "type" : "esriFieldTypeDouble", "alias" : "New Meter Read", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "New_Meter_Number", "type" : "esriFieldTypeString", "alias" : "New Meter Number", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "New_Radio_Number", "type" : "esriFieldTypeString", "alias" : "New Radio Number", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Additional_Work", "type" : "esriFieldTypeString", "alias" : "Additional Work", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Plumbing_Work", "type" : "esriFieldTypeString", "alias" : "Plumbing Work", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LocationID", "type" : "esriFieldTypeString", "alias" : "LocationID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__LATERAL___F4B70D85805C15D4", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_16840.LATERAL_LINE_INVENTORY_LATERAL_LINE_INVENTORY_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "DateCreatedIndex", "fields" : "DateCreated", "isAscending" : true, "isUnique" : false, "description" : "DateCreated Field index", "indexType" : "Attribute" }, { "name" : "CreatedByIndex", "fields" : "CreatedBy", "isAscending" : false, "isUnique" : false, "description" : "CreatedBy Field index", "indexType" : "Attribute" }, { "name" : "LastUpdateIndex", "fields" : "LastUpdate", "isAscending" : true, "isUnique" : false, "description" : "LastUpdate Field index", "indexType" : "Attribute" }, { "name" : "LastEditorIndex", "fields" : "LastEditor", "isAscending" : false, "isUnique" : false, "description" : "LastEditor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Unknown", "name" : "Unknown", "domains" : { "r_City" : {"type" : "inherited"}, "r_System_Material" : {"type" : "inherited"}, "o_Material_Prev_Lead" : {"type" : "inherited"}, "o_System_Install_Date" : {"type" : "inherited"}, "EPA_System_Diameter" : {"type" : "inherited"}, "EPA_System_Class_Reason" : {"type" : "inherited"}, "EPA_System_Material_Verified" : {"type" : "inherited"}, "EPA_Syst_Verification_Method" : {"type" : "inherited"}, "r_Customer_Material" : {"type" : "inherited"}, "o_Customer_Install_Date" : {"type" : "inherited"}, "EPA_Customer_Diameter" : {"type" : "inherited"}, "EPA_Customer_Class_Reason" : {"type" : "inherited"}, "EPA_Cust_Material_Verified" : {"type" : "inherited"}, "EPA_Cust_Verification_Method" : {"type" : "inherited"}, "r_Entire_ServiceLine_Material" : {"type" : "inherited"}, "o_Lead_Connector" : {"type" : "inherited"}, "o_Lead_Solder" : {"type" : "inherited"}, "o_Building_Type" : {"type" : "inherited"}, "o_Pnt_Entry_Trtmnt_Present" : {"type" : "inherited"}, "o_Int_Bldg_LC_Pipes_07011989" : {"type" : "inherited"}, "o_Current_LCR_Sample_Site" : {"type" : "inherited"}, "o_Site_Tier" : {"type" : "inherited"}, "FNI_Pre_Dir" : {"type" : "inherited"}, "FNI_Street_Type" : {"type" : "inherited"}, "FNI_Dir_Suf" : {"type" : "inherited"}, "Work_Order_Type" : {"type" : "inherited"}, "Meter_Model" : {"type" : "inherited"}, "New_Meter_Size" : {"type" : "inherited"} }, "templates" : [ { "name" : "Unknown", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Comment" : null, "Plumbing_Work" : null, "r_WSLID" : null, "r_St_Number" : null, "r_St_Name" : null, "r_City" : null, "r_Zipcode" : null, "o_Other_Loc_Identifiers" : null, "o_Latitude" : null, "o_Longitude" : null, "r_System_Material" : null, "o_Material_Prev_Lead" : null, "o_System_Install_Date" : null, "o_System_Notes" : null, "EPA_System_Diameter" : null, "EPA_System_Class_Reason" : null, "EPA_System_Material_Verified" : null, "EPA_Syst_Verification_Method" : null, "EPA_System_Verification_Date" : null, "r_Customer_Material" : null, "o_Customer_Install_Date" : null, "o_Customer_Notes" : null, "EPA_Customer_Diameter" : null, "EPA_Customer_Class_Reason" : null, "EPA_Cust_Material_Verified" : null, "EPA_Cust_Verification_Method" : null, "EPA_Cust_Verification_Date" : null, "r_Entire_ServiceLine_Material" : "Unknown", "o_Lead_Connector" : null, "o_Lead_Solder" : null, "o_Connector_Solder_Desc" : null, "o_Building_Type" : null, "o_Pnt_Entry_Trtmnt_Present" : null, "o_Int_Bldg_LC_Pipes_07011989" : null, "o_Current_LCR_Sample_Site" : null, "o_Site_Tier" : null, "o_System_LSLR_Date" : null, "o_Customer_LSLR_Date" : null, "CAD_Year_Built" : null, "SAN_Meter_Number" : "", "SAN_Meter_Manufacture_Date" : null, "SAN_Meter_Initiation_Date" : null, "SAN_Meter_Termination_Date" : "", "SAN_Meter_Install_Date" : null, "SAN_Meter_Material" : null, "SAN_Meter_Size" : null, "SAN_Meter_Subtype" : null, "FNI_Full_Address" : null, "FNI_Pre_Dir" : null, "FNI_St_Name" : null, "FNI_Street_Type" : null, "FNI_Dir_Suf" : null, "FNI_Unit" : null, "FNI_Parcel_Class" : null, "FNI_Meter_Status" : null, "FNI_MHI_2022" : null, "FNI_PAR_ID" : null, "FNI_Inventory_Notes" : null, "LocationID" : null, "Additional_Work" : null, "New_Radio_Number" : null, "New_Meter_Number" : null, "New_Meter_Read" : null, "Work_Order_Type" : null, "Final_Read" : null, "Meter_Make" : null, "Meter_Model" : null, "New_Meter_Size" : null } } } ] }, { "id" : "Non-Lead", "name" : "Non-Lead", "domains" : { "r_City" : {"type" : "inherited"}, "r_System_Material" : {"type" : "inherited"}, "o_Material_Prev_Lead" : {"type" : "inherited"}, "o_System_Install_Date" : {"type" : "inherited"}, "EPA_System_Diameter" : {"type" : "inherited"}, "EPA_System_Class_Reason" : {"type" : "inherited"}, "EPA_System_Material_Verified" : {"type" : "inherited"}, "EPA_Syst_Verification_Method" : {"type" : "inherited"}, "r_Customer_Material" : {"type" : "inherited"}, "o_Customer_Install_Date" : {"type" : "inherited"}, "EPA_Customer_Diameter" : {"type" : "inherited"}, "EPA_Customer_Class_Reason" : {"type" : "inherited"}, "EPA_Cust_Material_Verified" : {"type" : "inherited"}, "EPA_Cust_Verification_Method" : {"type" : "inherited"}, "r_Entire_ServiceLine_Material" : {"type" : "inherited"}, "o_Lead_Connector" : {"type" : "inherited"}, "o_Lead_Solder" : {"type" : "inherited"}, "o_Building_Type" : {"type" : "inherited"}, "o_Pnt_Entry_Trtmnt_Present" : {"type" : "inherited"}, "o_Int_Bldg_LC_Pipes_07011989" : {"type" : "inherited"}, "o_Current_LCR_Sample_Site" : {"type" : "inherited"}, "o_Site_Tier" : {"type" : "inherited"}, "FNI_Pre_Dir" : {"type" : "inherited"}, "FNI_Street_Type" : {"type" : "inherited"}, "FNI_Dir_Suf" : {"type" : "inherited"}, "Work_Order_Type" : {"type" : "inherited"}, "Meter_Model" : {"type" : "inherited"}, "New_Meter_Size" : {"type" : "inherited"} }, "templates" : [ { "name" : "Non-Lead", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Comment" : null, "Plumbing_Work" : null, "r_WSLID" : null, "r_St_Number" : null, "r_St_Name" : null, "r_City" : null, "r_Zipcode" : null, "o_Other_Loc_Identifiers" : null, "o_Latitude" : null, "o_Longitude" : null, "r_System_Material" : null, "o_Material_Prev_Lead" : null, "o_System_Install_Date" : null, "o_System_Notes" : null, "EPA_System_Diameter" : null, "EPA_System_Class_Reason" : null, "EPA_System_Material_Verified" : null, "EPA_Syst_Verification_Method" : null, "EPA_System_Verification_Date" : null, "r_Customer_Material" : null, "o_Customer_Install_Date" : null, "o_Customer_Notes" : null, "EPA_Customer_Diameter" : null, "EPA_Customer_Class_Reason" : null, "EPA_Cust_Material_Verified" : null, "EPA_Cust_Verification_Method" : null, "EPA_Cust_Verification_Date" : null, "r_Entire_ServiceLine_Material" : "Non-Lead", "o_Lead_Connector" : null, "o_Lead_Solder" : null, "o_Connector_Solder_Desc" : null, "o_Building_Type" : null, "o_Pnt_Entry_Trtmnt_Present" : null, "o_Int_Bldg_LC_Pipes_07011989" : null, "o_Current_LCR_Sample_Site" : null, "o_Site_Tier" : null, "o_System_LSLR_Date" : null, "o_Customer_LSLR_Date" : null, "CAD_Year_Built" : null, "SAN_Meter_Number" : "", "SAN_Meter_Manufacture_Date" : null, "SAN_Meter_Initiation_Date" : null, "SAN_Meter_Termination_Date" : "", "SAN_Meter_Install_Date" : null, "SAN_Meter_Material" : null, "SAN_Meter_Size" : null, "SAN_Meter_Subtype" : null, "FNI_Full_Address" : null, "FNI_Pre_Dir" : null, "FNI_St_Name" : null, "FNI_Street_Type" : null, "FNI_Dir_Suf" : null, "FNI_Unit" : null, "FNI_Parcel_Class" : null, "FNI_Meter_Status" : null, "FNI_MHI_2022" : null, "FNI_PAR_ID" : null, "FNI_Inventory_Notes" : null, "LocationID" : null, "Additional_Work" : null, "New_Radio_Number" : null, "New_Meter_Number" : null, "New_Meter_Read" : null, "Work_Order_Type" : null, "Final_Read" : null, "Meter_Make" : null, "Meter_Model" : null, "New_Meter_Size" : null } } } ] }, { "id" : "Galvanized Requiring Replacement", "name" : "Galvanized Requiring Replacement", "domains" : { "r_City" : {"type" : "inherited"}, "r_System_Material" : {"type" : "inherited"}, "o_Material_Prev_Lead" : {"type" : "inherited"}, "o_System_Install_Date" : {"type" : "inherited"}, "EPA_System_Diameter" : {"type" : "inherited"}, "EPA_System_Class_Reason" : {"type" : "inherited"}, "EPA_System_Material_Verified" : {"type" : "inherited"}, "EPA_Syst_Verification_Method" : {"type" : "inherited"}, "r_Customer_Material" : {"type" : "inherited"}, "o_Customer_Install_Date" : {"type" : "inherited"}, "EPA_Customer_Diameter" : {"type" : "inherited"}, "EPA_Customer_Class_Reason" : {"type" : "inherited"}, "EPA_Cust_Material_Verified" : {"type" : "inherited"}, "EPA_Cust_Verification_Method" : {"type" : "inherited"}, "r_Entire_ServiceLine_Material" : {"type" : "inherited"}, "o_Lead_Connector" : {"type" : "inherited"}, "o_Lead_Solder" : {"type" : "inherited"}, "o_Building_Type" : {"type" : "inherited"}, "o_Pnt_Entry_Trtmnt_Present" : {"type" : "inherited"}, "o_Int_Bldg_LC_Pipes_07011989" : {"type" : "inherited"}, "o_Current_LCR_Sample_Site" : {"type" : "inherited"}, "o_Site_Tier" : {"type" : "inherited"}, "FNI_Pre_Dir" : {"type" : "inherited"}, "FNI_Street_Type" : {"type" : "inherited"}, "FNI_Dir_Suf" : {"type" : "inherited"}, "Work_Order_Type" : {"type" : "inherited"}, "Meter_Model" : {"type" : "inherited"}, "New_Meter_Size" : {"type" : "inherited"} }, "templates" : [ { "name" : "Galvanized Requiring Replacement", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Comment" : null, "Plumbing_Work" : null, "r_WSLID" : null, "r_St_Number" : null, "r_St_Name" : null, "r_City" : null, "r_Zipcode" : null, "o_Other_Loc_Identifiers" : null, "o_Latitude" : null, "o_Longitude" : null, "r_System_Material" : null, "o_Material_Prev_Lead" : null, "o_System_Install_Date" : null, "o_System_Notes" : null, "EPA_System_Diameter" : null, "EPA_System_Class_Reason" : null, "EPA_System_Material_Verified" : null, "EPA_Syst_Verification_Method" : null, "EPA_System_Verification_Date" : null, "r_Customer_Material" : null, "o_Customer_Install_Date" : null, "o_Customer_Notes" : null, "EPA_Customer_Diameter" : null, "EPA_Customer_Class_Reason" : null, "EPA_Cust_Material_Verified" : null, "EPA_Cust_Verification_Method" : null, "EPA_Cust_Verification_Date" : null, "r_Entire_ServiceLine_Material" : "Galvanized Requiring Replacement", "o_Lead_Connector" : null, "o_Lead_Solder" : null, "o_Connector_Solder_Desc" : null, "o_Building_Type" : null, "o_Pnt_Entry_Trtmnt_Present" : null, "o_Int_Bldg_LC_Pipes_07011989" : null, "o_Current_LCR_Sample_Site" : null, "o_Site_Tier" : null, "o_System_LSLR_Date" : null, "o_Customer_LSLR_Date" : null, "CAD_Year_Built" : null, "SAN_Meter_Number" : "", "SAN_Meter_Manufacture_Date" : null, "SAN_Meter_Initiation_Date" : null, "SAN_Meter_Termination_Date" : "", "SAN_Meter_Install_Date" : null, "SAN_Meter_Material" : null, "SAN_Meter_Size" : null, "SAN_Meter_Subtype" : null, "FNI_Full_Address" : null, "FNI_Pre_Dir" : null, "FNI_St_Name" : null, "FNI_Street_Type" : null, "FNI_Dir_Suf" : null, "FNI_Unit" : null, "FNI_Parcel_Class" : null, "FNI_Meter_Status" : null, "FNI_MHI_2022" : null, "FNI_PAR_ID" : null, "FNI_Inventory_Notes" : null, "LocationID" : null, "Additional_Work" : null, "New_Radio_Number" : null, "New_Meter_Number" : null, "New_Meter_Read" : null, "Work_Order_Type" : null, "Final_Read" : null, "Meter_Make" : null, "Meter_Model" : null, "New_Meter_Size" : null } } } ] }, { "id" : "Lead", "name" : "Lead", "domains" : { "r_City" : {"type" : "inherited"}, "r_System_Material" : {"type" : "inherited"}, "o_Material_Prev_Lead" : {"type" : "inherited"}, "o_System_Install_Date" : {"type" : "inherited"}, "EPA_System_Diameter" : {"type" : "inherited"}, "EPA_System_Class_Reason" : {"type" : "inherited"}, "EPA_System_Material_Verified" : {"type" : "inherited"}, "EPA_Syst_Verification_Method" : {"type" : "inherited"}, "r_Customer_Material" : {"type" : "inherited"}, "o_Customer_Install_Date" : {"type" : "inherited"}, "EPA_Customer_Diameter" : {"type" : "inherited"}, "EPA_Customer_Class_Reason" : {"type" : "inherited"}, "EPA_Cust_Material_Verified" : {"type" : "inherited"}, "EPA_Cust_Verification_Method" : {"type" : "inherited"}, "r_Entire_ServiceLine_Material" : {"type" : "inherited"}, "o_Lead_Connector" : {"type" : "inherited"}, "o_Lead_Solder" : {"type" : "inherited"}, "o_Building_Type" : {"type" : "inherited"}, "o_Pnt_Entry_Trtmnt_Present" : {"type" : "inherited"}, "o_Int_Bldg_LC_Pipes_07011989" : {"type" : "inherited"}, "o_Current_LCR_Sample_Site" : {"type" : "inherited"}, "o_Site_Tier" : {"type" : "inherited"}, "FNI_Pre_Dir" : {"type" : "inherited"}, "FNI_Street_Type" : {"type" : "inherited"}, "FNI_Dir_Suf" : {"type" : "inherited"}, "Work_Order_Type" : {"type" : "inherited"}, "Meter_Model" : {"type" : "inherited"}, "New_Meter_Size" : {"type" : "inherited"} }, "templates" : [ { "name" : "Lead", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Comment" : null, "Plumbing_Work" : null, "r_WSLID" : null, "r_St_Number" : null, "r_St_Name" : null, "r_City" : null, "r_Zipcode" : null, "o_Other_Loc_Identifiers" : null, "o_Latitude" : null, "o_Longitude" : null, "r_System_Material" : null, "o_Material_Prev_Lead" : null, "o_System_Install_Date" : null, "o_System_Notes" : null, "EPA_System_Diameter" : null, "EPA_System_Class_Reason" : null, "EPA_System_Material_Verified" : null, "EPA_Syst_Verification_Method" : null, "EPA_System_Verification_Date" : null, "r_Customer_Material" : null, "o_Customer_Install_Date" : null, "o_Customer_Notes" : null, "EPA_Customer_Diameter" : null, "EPA_Customer_Class_Reason" : null, "EPA_Cust_Material_Verified" : null, "EPA_Cust_Verification_Method" : null, "EPA_Cust_Verification_Date" : null, "r_Entire_ServiceLine_Material" : "Lead", "o_Lead_Connector" : null, "o_Lead_Solder" : null, "o_Connector_Solder_Desc" : null, "o_Building_Type" : null, "o_Pnt_Entry_Trtmnt_Present" : null, "o_Int_Bldg_LC_Pipes_07011989" : null, "o_Current_LCR_Sample_Site" : null, "o_Site_Tier" : null, "o_System_LSLR_Date" : null, "o_Customer_LSLR_Date" : null, "CAD_Year_Built" : null, "SAN_Meter_Number" : "", "SAN_Meter_Manufacture_Date" : null, "SAN_Meter_Initiation_Date" : null, "SAN_Meter_Termination_Date" : "", "SAN_Meter_Install_Date" : null, "SAN_Meter_Material" : null, "SAN_Meter_Size" : null, "SAN_Meter_Subtype" : null, "FNI_Full_Address" : null, "FNI_Pre_Dir" : null, "FNI_St_Name" : null, "FNI_Street_Type" : null, "FNI_Dir_Suf" : null, "FNI_Unit" : null, "FNI_Parcel_Class" : null, "FNI_Meter_Status" : null, "FNI_MHI_2022" : null, "FNI_PAR_ID" : null, "FNI_Inventory_Notes" : null, "LocationID" : null, "Additional_Work" : null, "New_Radio_Number" : null, "New_Meter_Number" : null, "New_Meter_Read" : null, "Work_Order_Type" : null, "Final_Read" : null, "Meter_Make" : null, "Meter_Model" : null, "New_Meter_Size" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }