Name: ServiceLine

Display Field:

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:

XMin: -10665529.3146
YMin: 4711337.6642
XMax: -10641755.9107
YMax: 4741728.213
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}

HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

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: EPA 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: 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 - MF Home: Yes - Multifamily Home], ... 2 more ...)
• disadvantaged (type: esriFieldTypeString, alias: Disadvantaged Neighborhood, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• 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: [Lead: Lead], [Copper: Copper], [Galvanized Steel: Galvanized Steel], ... 6 more ...)
• everlead (type: esriFieldTypeString, alias: Ever Lead?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• 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: [-1: Unknown], [0.25: 1/4"], [0.5: 1/2"], ... 18 more ...)
• utilverified (type: esriFieldTypeString, alias: Utility Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• utilverifmethod (type: esriFieldTypeString, alias: Utility Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Visual inspection at the meter pit: Visual inspection at the meter pit], [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal], [CCTV investigation at curb stop - external: CCTV investigation at curb stop - external], ... 4 more ...)
• utilverifdate (type: esriFieldTypeDate, alias: Utility Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• utilstatus (type: esriFieldTypeString, alias: Utility Service Line Lead Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non-Lead: Non-Lead], [Unknown: Unknown])
• 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: [Lead: Lead], [Copper: Copper], [Galvanized Steel: Galvanized Steel], ... 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: [-1: Unknown], [0.25: 1/4"], [0.5: 1/2"], ... 18 more ...)
• custverified (type: esriFieldTypeString, alias: Customer Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• custverifmethod (type: esriFieldTypeString, alias: Customer Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Visual inspection at the meter pit: Visual inspection at the meter pit], [Customer self-identification: Customer self-identification], [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal], ... 5 more ...)
• custverifdate (type: esriFieldTypeDate, alias: Customer Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• custstatus (type: esriFieldTypeString, alias: Customer Service Line Lead Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Lead: Lead], [Non-Lead: Non-Lead], ... 1 more ...)
• custnotes (type: esriFieldTypeString, alias: Customer Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• bothsidesstatus (type: esriFieldTypeString, alias: Full Service Line Lead Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non-Lead: Non-Lead], [Galvanized Requiring Replacement: Galvanized Requiring Replacement], ... 1 more ...)
• leadsolder (type: esriFieldTypeString, alias: Lead Solder in Service Line, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Don't Know: Don't Know])
• otherfittings (type: esriFieldTypeString, alias: Premise Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• buildingtype (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Building: Building], [Other: Other], [Single Family: Single Family], ... 1 more ...)
• pointofentry (type: esriFieldTypeString, alias: Premise 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: Premise 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: Compliance Sampling Site, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• utilscheddate (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)
• filter (type: esriFieldTypeString, alias: Water Pitcher Filter, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Never Required: Never Required], [Required: Required])
• 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)
• filterscheddate (type: esriFieldTypeDate, alias: Water Pitcher Filter Date Scheduled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• filterprovidedate (type: esriFieldTypeDate, alias: Water Pitcher Filter Date Provided, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• serviceuse (type: esriFieldTypeString, alias: Service Line Use, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Irrigation: Irrigation], [Fire: Fire], [Potable: Potable], ... 1 more ...)
• utilpredmat (type: esriFieldTypeString, alias: Utility Predicted Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• utilpredprob (type: esriFieldTypeDouble, alias: Utility Predicted Material Probability, SQL Type: sqlTypeOther, nullable: true, editable: true)
• custpredmat (type: esriFieldTypeString, alias: Customer Predicted Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• custpredprob (type: esriFieldTypeDouble, alias: Customer Predicted Material Probability, SQL Type: sqlTypeOther, nullable: true, editable: true)
• servicestatus (type: esriFieldTypeString, alias: Service Line Working Status , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [In Service: In Service], [Out of Service: Out of Service], [Abandoned/Disconnected: Abandoned/Disconnected])
• lastmodeldate (type: esriFieldTypeDate, alias: Predictive Model Last Run Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• connectorstatus (type: esriFieldTypeString, alias: Connector Classification, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Unknown: Unknown], [Copper: Copper], ... 2 more ...)
• connectorscheddate (type: esriFieldTypeDate, alias: Connector Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• connectorreplacedate (type: esriFieldTypeDate, alias: Connector Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• utilreplacestatus (type: esriFieldTypeString, alias: Utility Side Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Needs Replacement: Needs Replacement], [Scheduled Replacement: Scheduled Replacement], ... 3 more ...)
• custreplacestatus (type: esriFieldTypeString, alias: Customer Side Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Needs Replacement: Needs Replacement], [Scheduled Replacement: Scheduled Replacement], ... 4 more ...)
• custresponsetotal (type: esriFieldTypeString, alias: Customer Response to Replacement Requests, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Approved Replacement: Approved Replacement], [Denied Replacement: Denied Replacement], [Doesn't Need Replacement: Doesn't Need Replacement], ... 7 more ...)
• custmaterialoriginal (type: esriFieldTypeString, alias: Customer Material Original, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Lead-lined galvanized: Lead-lined galvanized], [Galvanized: Galvanized], ... 6 more ...)
• utilmaterialoriginal (type: esriFieldTypeString, alias: Utility Material Original, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Lead-lined galvanized: Lead-lined galvanized], [Galvanized: Galvanized], ... 6 more ...)
• tier (type: esriFieldTypeString, alias: Tier, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Tier 1: Tier 1], [Tier 2: Tier 2], [Tier 3: Tier 3], ... 3 more ...)
• utilmaterialreplaced (type: esriFieldTypeString, alias: Utility Side Replaced Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], [Non-Lead - Other: Non-Lead - Other])
• custmaterialreplaced (type: esriFieldTypeString, alias: Customer Side Replaced Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], [Non-Lead - Other: Non-Lead - Other])
• replacestatus (type: esriFieldTypeString, alias: Full Line Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Both Sides Need Replaced: Both Sides Need Replaced], [Utility Side Needs Replaced: Utility Side Needs Replaced], ... 10 more ...)
• custbasisclass (type: esriFieldTypeString, alias: Customer Basis of Material Classification, SQL Type: sqlTypeOther, length: 256, 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 ...)
• utilbasisclass (type: esriFieldTypeString, alias: Utility Basis of Material Classification, SQL Type: sqlTypeOther, length: 256, 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 ...)
• replpriorityrank (type: esriFieldTypeInteger, alias: Replacement Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• schoolpriorityrank (type: esriFieldTypeInteger, alias: School Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ccpriorityrank (type: esriFieldTypeInteger, alias: Childcare Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• newcustomerdate (type: esriFieldTypeDate, alias: newcustomerdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• Notifications (0) -- Related To: Notifications (1)
• SchoolChildcareSampling (1) -- Related To: School_Childcare_Sampling (2)
• Sampling (2) -- Related To: Sampling (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/31/2026 6:32:56 PM

Schema Last Edit Date: 8/5/2026 9:09:02 PM

Data Last Edit Date: 8/31/2026 6:32:56 PM

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