Layer: CoB_Water_Meters_LCRR_Final

View In: Map Viewer

Name: CoB_Water_Meters_LCRR_Final_20240320

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Overall_ServiceLine_Status","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"Lead","label":"Lead"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,92,230,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"Non_Lead","label":"Non-Lead"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"Gavanized_Req_Replacement","label":"Galvanized Requiring Replacement"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"Unknown","label":"Unknown"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,249,255],"toColor":[207,252,249,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,182,252,255],"toColor":[249,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,195,179,255],"toColor":[252,195,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,252,179,255],"toColor":[227,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,205,252,255],"toColor":[182,205,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,229,255],"toColor":[252,199,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,249,215,255],"toColor":[252,249,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,211,255],"toColor":[197,252,211,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,179,252,255],"toColor":[188,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[229,199,252,255],"toColor":[229,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,232,252,255],"toColor":[210,232,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,220,212,255],"toColor":[252,220,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[183,252,179,255],"toColor":[183,252,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: Overall_ServiceLine_Status

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Inventory_ID (type: esriFieldTypeString, alias: Inventory_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Meter_Address (type: esriFieldTypeString, alias: Meter Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Meter_SerialNumber (type: esriFieldTypeString, alias: Meter Serial Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Meter_Size (type: esriFieldTypeString, alias: Meter Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Meter_InstallDate (type: esriFieldTypeDate, alias: Meter Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Parcel_ID (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HighRiskArea (type: esriFieldTypeString, alias: High Risk Area?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
HighPrioritySite (type: esriFieldTypeString, alias: HighPrioritySite, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
HighPrioritySiteType (type: esriFieldTypeString, alias: HighPrioritySiteType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
FullAddress (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StreetNumber (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityAsset_ID (type: esriFieldTypeString, alias: Utility Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityServiceLineMaterial (type: esriFieldTypeString, alias: Utility Service Line Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
UtilitySolderMaterial (type: esriFieldTypeString, alias: Utility Solder Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
UtilityDiameter (type: esriFieldTypeDouble, alias: Utility Service Line Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 1/2"], [0.75: 3/4"], [1: 1"], ... 15 more ...)
UtilityInstallDate (type: esriFieldTypeDate, alias: Utility Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
UtilititySource (type: esriFieldTypeString, alias: Utility Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Field_Inspection: Field Inspection], [Diameter_LessThan2In: Diameter > 2"], [Install_Dt_After_Lead_Ban: Installation Date After Lead Ban], ... 5 more ...)
UtilityStatus (type: esriFieldTypeString, alias: Utility Service Line Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non_Lead: Non-Lead], [Gavanized_Req_Replacement: Galvanized Requiring Replacement], ... 1 more ...)
CustomerAsset_ID (type: esriFieldTypeString, alias: Customer Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CustomerServiceLineMaterial (type: esriFieldTypeString, alias: Customer Service Line Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
CustomerSolderMaterial (type: esriFieldTypeString, alias: Customer Solder Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
CustomerDiameter (type: esriFieldTypeDouble, alias: Customer Service Line Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 1/2"], [0.75: 3/4"], [1: 1"], ... 15 more ...)
CustomerInstallDate (type: esriFieldTypeDate, alias: Customer Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CustomerSource (type: esriFieldTypeString, alias: Customer Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Field_Inspection: Field Inspection], [Diameter_LessThan2In: Diameter > 2"], [Install_Dt_After_Lead_Ban: Installation Date After Lead Ban], ... 5 more ...)
CustomerStatus (type: esriFieldTypeString, alias: Customer Service Line Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non_Lead: Non-Lead], [Gavanized_Req_Replacement: Galvanized Requiring Replacement], ... 1 more ...)
Overall_ServiceLine_Status (type: esriFieldTypeString, alias: Overall_ServiceLine_Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non_Lead: Non-Lead], [Gavanized_Req_Replacement: Galvanized Requiring Replacement], ... 1 more ...)
ServiceLineType (type: esriFieldTypeString, alias: Service Line Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Residential: Residential Service], [Commercial: Commercial Service], ... 5 more ...)
NewlyIdentifiedSL (type: esriFieldTypeString, alias: Newly Identified Service Line?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Gooseneck_Material (type: esriFieldTypeString, alias: Gooseneck Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
PreviouslyLead (type: esriFieldTypeString, alias: Previously Lead?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
DownstreamOfLead (type: esriFieldTypeString, alias: Downstream of Lead?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
WaterMainInstallDate (type: esriFieldTypeDate, alias: Water Main Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
WaterServiceArea (type: esriFieldTypeString, alias: Water Service Area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PropertyYearBuilt (type: esriFieldTypeDate, alias: Property Year Built, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ParcelYearBuilt (type: esriFieldTypeSmallInteger, alias: ParcelYearBuilt, SQL Type: sqlTypeOther, nullable: true, editable: true)
InspectionRequired (type: esriFieldTypeString, alias: Inspection Required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
UtilityInspectOrVerify_Date (type: esriFieldTypeDate, alias: Utility Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CustomerInspectorVerify_Date (type: esriFieldTypeDate, alias: Customer Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ReplacementRequired (type: esriFieldTypeString, alias: Replacement Required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
CustomerNotifiedOfLSL_Date (type: esriFieldTypeDate, alias: Date Customer Notified of LSL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Waiver_or_IDPH_Notification_Dat (type: esriFieldTypeDate, alias: Waiver or IDPH Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PermissionToAccess (type: esriFieldTypeString, alias: Permission to Access Property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
ReplacedServiceLine (type: esriFieldTypeString, alias: Replaced Lead Service Line?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Replaced_Material (type: esriFieldTypeString, alias: Replacement Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
ReplacementDate (type: esriFieldTypeDate, alias: Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CoB_Updated_UtilityMaterial (type: esriFieldTypeString, alias: CoB_UpdatedMaterial, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
CoB_Updated_CustomerMaterial (type: esriFieldTypeString, alias: CoB_UpdatedMaterial_Side, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos_Cement_AC: Asbestos Cement (AC)], [Brass _BR: Brass (BR)], [Cast_Iron_CI: Cast Iron (CI)], ... 13 more ...)
CoB_Updated_UtilitySource (type: esriFieldTypeString, alias: CoB_UpdatedMaterial_Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Field_Inspection: Field Inspection], [Diameter_LessThan2In: Diameter > 2"], [Install_Dt_After_Lead_Ban: Installation Date After Lead Ban], ... 5 more ...)
CoB_Updated_CustomerSource (type: esriFieldTypeString, alias: CoB_Updated_CustomerSource, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Field_Inspection: Field Inspection], [Diameter_LessThan2In: Diameter > 2"], [Install_Dt_After_Lead_Ban: Installation Date After Lead Ban], ... 5 more ...)
CoB_Updated_Status (type: esriFieldTypeString, alias: CoB_Updated_UtilityStatus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non_Lead: Non-Lead], [Gavanized_Req_Replacement: Galvanized Requiring Replacement], ... 1 more ...)
Unknown_Susp_NL_Desc (type: esriFieldTypeString, alias: Unk Susp NonLead Desc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [overall_sl: Overall Service Line], [utility_side_only: Utility-Side Only])
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Types:

Field Name: HighRiskArea
Inherited
Field Name: UtilityServiceLineMaterial
Inherited
Field Name: UtilitySolderMaterial
Inherited
Field Name: UtilityDiameter
Inherited
Field Name: UtilititySource
Inherited
Field Name: UtilityStatus
Inherited
Field Name: CustomerServiceLineMaterial
Inherited
Field Name: CustomerSolderMaterial
Inherited
Field Name: CustomerDiameter
Inherited
Field Name: CustomerSource
Inherited
Field Name: CustomerStatus
Inherited
Field Name: Overall_ServiceLine_Status
Inherited
Field Name: ServiceLineType
Inherited
Field Name: NewlyIdentifiedSL
Inherited
Field Name: Gooseneck_Material
Inherited
Field Name: PreviouslyLead
Inherited
Field Name: DownstreamOfLead
Inherited
Field Name: InspectionRequired
Inherited
Field Name: ReplacementRequired
Inherited
Field Name: PermissionToAccess
Inherited
Field Name: ReplacedServiceLine
Inherited
Field Name: Replaced_Material
Inherited
Field Name: CoB_Updated_UtilityMaterial
Inherited
Field Name: CoB_Updated_CustomerMaterial
Inherited
Field Name: CoB_Updated_UtilitySource
Inherited
Field Name: CoB_Updated_CustomerSource
Inherited
Field Name: CoB_Updated_Status
Inherited
Field Name: Unknown_Susp_NL_Desc
Inherited

Overall_ServiceLine_Status: Lead

Field Name: HighRiskArea
Inherited
Field Name: UtilityServiceLineMaterial
Inherited
Field Name: UtilitySolderMaterial
Inherited
Field Name: UtilityDiameter
Inherited
Field Name: UtilititySource
Inherited
Field Name: UtilityStatus
Inherited
Field Name: CustomerServiceLineMaterial
Inherited
Field Name: CustomerSolderMaterial
Inherited
Field Name: CustomerDiameter
Inherited
Field Name: CustomerSource
Inherited
Field Name: CustomerStatus
Inherited
Field Name: Overall_ServiceLine_Status
Inherited
Field Name: ServiceLineType
Inherited
Field Name: NewlyIdentifiedSL
Inherited
Field Name: Gooseneck_Material
Inherited
Field Name: PreviouslyLead
Inherited
Field Name: DownstreamOfLead
Inherited
Field Name: InspectionRequired
Inherited
Field Name: ReplacementRequired
Inherited
Field Name: PermissionToAccess
Inherited
Field Name: ReplacedServiceLine
Inherited
Field Name: Replaced_Material
Inherited
Field Name: CoB_Updated_UtilityMaterial
Inherited
Field Name: CoB_Updated_CustomerMaterial
Inherited
Field Name: CoB_Updated_UtilitySource
Inherited
Field Name: CoB_Updated_CustomerSource
Inherited
Field Name: CoB_Updated_Status
Inherited
Field Name: Unknown_Susp_NL_Desc
Inherited

Overall_ServiceLine_Status: Non_Lead

Field Name: HighRiskArea
Inherited
Field Name: UtilityServiceLineMaterial
Inherited
Field Name: UtilitySolderMaterial
Inherited
Field Name: UtilityDiameter
Inherited
Field Name: UtilititySource
Inherited
Field Name: UtilityStatus
Inherited
Field Name: CustomerServiceLineMaterial
Inherited
Field Name: CustomerSolderMaterial
Inherited
Field Name: CustomerDiameter
Inherited
Field Name: CustomerSource
Inherited
Field Name: CustomerStatus
Inherited
Field Name: Overall_ServiceLine_Status
Inherited
Field Name: ServiceLineType
Inherited
Field Name: NewlyIdentifiedSL
Inherited
Field Name: Gooseneck_Material
Inherited
Field Name: PreviouslyLead
Inherited
Field Name: DownstreamOfLead
Inherited
Field Name: InspectionRequired
Inherited
Field Name: ReplacementRequired
Inherited
Field Name: PermissionToAccess
Inherited
Field Name: ReplacedServiceLine
Inherited
Field Name: Replaced_Material
Inherited
Field Name: CoB_Updated_UtilityMaterial
Inherited
Field Name: CoB_Updated_CustomerMaterial
Inherited
Field Name: CoB_Updated_UtilitySource
Inherited
Field Name: CoB_Updated_CustomerSource
Inherited
Field Name: CoB_Updated_Status
Inherited
Field Name: Unknown_Susp_NL_Desc
Inherited

Overall_ServiceLine_Status: Gavanized_Req_Replacement

Field Name: HighRiskArea
Inherited
Field Name: UtilityServiceLineMaterial
Inherited
Field Name: UtilitySolderMaterial
Inherited
Field Name: UtilityDiameter
Inherited
Field Name: UtilititySource
Inherited
Field Name: UtilityStatus
Inherited
Field Name: CustomerServiceLineMaterial
Inherited
Field Name: CustomerSolderMaterial
Inherited
Field Name: CustomerDiameter
Inherited
Field Name: CustomerSource
Inherited
Field Name: CustomerStatus
Inherited
Field Name: Overall_ServiceLine_Status
Inherited
Field Name: ServiceLineType
Inherited
Field Name: NewlyIdentifiedSL
Inherited
Field Name: Gooseneck_Material
Inherited
Field Name: PreviouslyLead
Inherited
Field Name: DownstreamOfLead
Inherited
Field Name: InspectionRequired
Inherited
Field Name: ReplacementRequired
Inherited
Field Name: PermissionToAccess
Inherited
Field Name: ReplacedServiceLine
Inherited
Field Name: Replaced_Material
Inherited
Field Name: CoB_Updated_UtilityMaterial
Inherited
Field Name: CoB_Updated_CustomerMaterial
Inherited
Field Name: CoB_Updated_UtilitySource
Inherited
Field Name: CoB_Updated_CustomerSource
Inherited
Field Name: CoB_Updated_Status
Inherited
Field Name: Unknown_Susp_NL_Desc
Inherited

Overall_ServiceLine_Status: Unknown

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 2:43:22 PM

Schema Last Edit Date: 5/7/2024 8:08:12 PM

Data Last Edit Date: 8/13/2026 2:43:22 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: CoB_Water_Meters_LCRR_Final_20240320 (ID:0)