Layer: ServiceLine (ID:0)

View In: Map Viewer

Name: ServiceLine

Display Field: accountid

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":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[131,63,135,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: true

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 255, 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: 256, 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 - Other: Yes - Other], ... 1 more ...)
disadvantaged (type: esriFieldTypeString, alias: Disadvantaged Neighborhood, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
utilassetid (type: esriFieldTypeString, alias: Utility Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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.75: 3/4"], ... 13 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 sampling only with no records], [Field inspection only with no records: Field inspection only with no records], ... 10 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 meter pit], [Customer self-identification: Customer self-identification], [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal], ... 7 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)
custassetid (type: esriFieldTypeString, alias: Customer Asset ID, SQL Type: sqlTypeOther, length: 255, 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.75: 3/4"], ... 13 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 sampling only with no records], [Field inspection only with no records: Field inspection only with no records], ... 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 meter pit], [Customer self-identification: Customer self-identification], [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal], ... 7 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 ...)
leadconnector (type: esriFieldTypeString, alias: Lead Connector, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
leadsolder (type: esriFieldTypeString, alias: Lead Solder, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
otherfittings (type: esriFieldTypeString, alias: Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 100, 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: Current LCR Sampling Site, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
replacestatus (type: esriFieldTypeString, alias: Replacement Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Needs Replacement: Needs Replacement], [Scheduled Replacement: Scheduled Replacement], ... 1 more ...)
scheddate (type: esriFieldTypeDate, alias: Utility Side Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utilreplacedate (type: esriFieldTypeDate, alias: Utility Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custscheddate (type: esriFieldTypeDate, alias: Customer Side Scheduled 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)
replacereason (type: esriFieldTypeString, alias: Reason for Replacement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Other: Other])
custnotified (type: esriFieldTypeString, alias: Notified Customer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
notifydate (type: esriFieldTypeDate, alias: Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
yearstructbuilt (type: esriFieldTypeSmallInteger, alias: Year Structure Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
watermain_installyear (type: esriFieldTypeString, alias: Water Main Install Year, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
watermain_asbuiltdate (type: esriFieldTypeDate, alias: Water Main AsBuilt Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
resityp (type: esriFieldTypeString, alias: resityp, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
everlead (type: esriFieldTypeString, alias: Ever Lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
growthstart (type: esriFieldTypeDouble, alias: Growth Period Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
growthend (type: esriFieldTypeDouble, alias: Growth Period End, SQL Type: sqlTypeOther, nullable: true, editable: true)
GIS_MeterID (type: esriFieldTypeInteger, alias: GIS_MeterID, SQL Type: sqlTypeOther, nullable: true, editable: true)
legal2 (type: esriFieldTypeString, alias: legal2, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
MeterSerial (type: esriFieldTypeDouble, alias: MeterSerial, SQL Type: sqlTypeOther, nullable: true, editable: true)
FULL_ADDRESS (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
D1_MeterSizeDesc (type: esriFieldTypeString, alias: MeterSizeDesc, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
CityAACOorUSNA (type: esriFieldTypeString, alias: CityAACOorUSNA, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
buildingtype (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Residential (Single-Family): Residential (Single-Family)], [Residential (Multi-Family): Residential (Multi-Family)], [Residential (School Dormitory): Residential (School Dormitory)], ... 18 more ...)
Parcel_PIN (type: esriFieldTypeString, alias: Parcel_PIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2026 4:02:07 AM

Schema Last Edit Date: 6/22/2026 6:09:35 PM

Data Last Edit Date: 7/22/2026 4:02:07 AM

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