Name: ServiceLine
Display Field: address
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: An inventory of point locations representing all known service lines, including their materials and other relevant attributes.
Copyright Text:
Min. Scale: 500000
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -8508845.91407691
YMin: 4405799.13478402
XMax: -8454882.30080235
YMax: 4434703.99659408
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"if($feature.utilverified != \"Yes\" && $feature.custverified != \"Yes\") {return \" ●●\"}\nelse if($feature.utilverified != \"Yes\" && $feature.custverified == \"Yes\") {return \"●\"}\nelse if($feature.custverified != \"Yes\" && $feature.utilverified == \"Yes\") {return \" ●\"}","title":"Unverified Service Lines"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackAlignment":"textSymbol","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":5000,"name":"Class 1","priority":0,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":-2,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":0.5,"font":{"family":"Arial","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: true
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- InventoryID (type: esriFieldTypeString, alias: Inventory ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- location (type: esriFieldTypeString, alias: Other Location Identifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sensitivepop (type: esriFieldTypeString, alias: Sensitive Population, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes - School: Yes - School], [Yes - Day Care: Yes - Day Care], [Yes - MultiHse: Yes - Multifamily House], ... 2 more ...)
- disadvantaged (type: esriFieldTypeString, alias: Disadvantaged Neighborhood, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- buildingtype (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Single Family Residence: Single Family Residence], [Multiple Family Residence: Multiple Family Residence], [Building: Building], ... 1 more ...)
- utilmaterial (type: esriFieldTypeString, alias: Utility Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown], [Unknown - Likely Lead: Unknown - Likely Lead], [Unknown - Unlikely Lead: Unknown - Unlikely Lead], ... 6 more ...)
- utilinstalldate (type: esriFieldTypeDate, alias: Utility Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- utildiameter (type: esriFieldTypeDouble, alias: Utility Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.625: 5/8"], ... 16 more ...)
- utilsource (type: esriFieldTypeString, alias: Utility Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)], [Water sampling only with no records: Water quality sampling], [Field inspection only with no records: Field Inspection], ... 6 more ...)
- utilverified (type: esriFieldTypeString, alias: Utility Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- utilverifmethod (type: esriFieldTypeString, alias: Utility Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Visual inspection at meter pit: Visual inspection at the meter pit], [Customer self-identification: Customer self-identification], [CCTV Inspection at Curb Box - Internal: CCTV inspection at curb box - internal], ... 9 more ...)
- utilverifdate (type: esriFieldTypeDate, alias: Utility Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- utilstatus (type: esriFieldTypeSmallInteger, alias: Utility Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
- utilnotes (type: esriFieldTypeString, alias: Utility Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- custmaterial (type: esriFieldTypeString, alias: Customer Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown], [Unknown - Likely Lead: Unknown - Likely Lead], [Unknown - Unlikely Lead: Unknown - Unlikely Lead], ... 6 more ...)
- custinstalldate (type: esriFieldTypeDate, alias: Customer Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- custdiameter (type: esriFieldTypeDouble, alias: Customer Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.625: 5/8"], ... 16 more ...)
- custsource (type: esriFieldTypeString, alias: Customer Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)], [Water sampling only with no records: Water quality sampling], [Field inspection only with no records: Field Inspection], ... 6 more ...)
- custverified (type: esriFieldTypeString, alias: Customer Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- custverifmethod (type: esriFieldTypeString, alias: Customer Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Visual inspection at meter pit: Visual inspection at the meter pit], [Customer self-identification: Customer self-identification], [CCTV Inspection at Curb Box - Internal: CCTV inspection at curb box - internal], ... 9 more ...)
- custverifdate (type: esriFieldTypeDate, alias: Customer Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- custstatus (type: esriFieldTypeSmallInteger, alias: Customer Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
- custnotes (type: esriFieldTypeString, alias: Customer Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- bothsidesstatus (type: esriFieldTypeString, alias: Entire Service Line Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Lead: Lead], [Non-Lead: Non-Lead], ... 1 more ...)
- everlead (type: esriFieldTypeString, alias: Ever Lead?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- leadconnector (type: esriFieldTypeString, alias: Lead Connector, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Don't know])
- leadsolder (type: esriFieldTypeString, alias: Lead Solder, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Don't know])
- otherfittings (type: esriFieldTypeString, alias: Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- pointofentry (type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- copperwithlead (type: esriFieldTypeString, alias: Copper Pipes with Lead Solder Before Lead Ban, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- samplingsite (type: esriFieldTypeString, alias: 2022 LCR Sampling Site, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- utilreplacedate (type: esriFieldTypeDate, alias: Utility Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- custreplacedate (type: esriFieldTypeDate, alias: Customer Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- hrsd_LastUpdate (type: esriFieldTypeDate, alias: HRSD – Last Update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- hrsd_AccOccID (type: esriFieldTypeString, alias: HRSD – Acc/Occ, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Templates:
Name: Lead | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 1
- custstatus: 1
- lcrr_WaterSystemPWSID: 3710100
Name: Lead | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 1
- custstatus: 3
- lcrr_WaterSystemPWSID: 3710100
Name: Galvanized Requiring Replacement | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 3
- custstatus: 1
- lcrr_WaterSystemPWSID: 3710100
Name: Lead | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 1
- custstatus: 0
- lcrr_WaterSystemPWSID: 3710100
Name: Unknown | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 0
- custstatus: 1
- lcrr_WaterSystemPWSID: 3710100
Name: Lead | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 1
- custstatus: 2
- lcrr_WaterSystemPWSID: 3710100
Name: Non-Lead | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 2
- custstatus: 1
- lcrr_WaterSystemPWSID: 3710100
Name: Galvanized Requiring Replacement | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 3
- custstatus: 3
- lcrr_WaterSystemPWSID: 3710100
Name: Galvanized Requiring Replacement | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 3
- custstatus: 0
- lcrr_WaterSystemPWSID: 3710100
Name: Unknown | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 0
- custstatus: 3
- lcrr_WaterSystemPWSID: 3710100
Name: Galvanized Requiring Replacement | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 3
- custstatus: 2
- lcrr_WaterSystemPWSID: 3710100
Name: Non-Lead | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 2
- custstatus: 3
- lcrr_WaterSystemPWSID: 3710100
Name: Unknown | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 0
- custstatus: 0
- lcrr_WaterSystemPWSID: 3710100
Name: Unknown | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 0
- custstatus: 2
- lcrr_WaterSystemPWSID: 3710100
Name: Non-Lead | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 2
- custstatus: 0
- lcrr_WaterSystemPWSID: 3710100
Name: Non-Lead | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilstatus: 2
- custstatus: 2
- lcrr_WaterSystemPWSID: 3710100
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/24/2026 12:46:57 AM
Schema Last Edit Date: 9/14/2026 5:07:10 PM
Data Last Edit Date: 9/24/2026 12:46:57 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat