Layers:

Layer: ServiceLine_SurveyJoin (0)


Name: ServiceLine_SurveyJoin

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Description: AttributeJoin

Copyright Text:

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1422103.18047708
YMin: 449799.037524163
XMax: 1485427.53557476
YMax: 488837.427040968
Spatial Reference: 102685 (2248)


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:

Name : ObjectId

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• 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 ...)
• custconnections (type: esriFieldTypeInteger, alias: Number of Customer Side Connections, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FormattedLoc (type: esriFieldTypeString, alias: FormattedLoc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AddressFinal (type: esriFieldTypeString, alias: AddressFinal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Annexation (type: esriFieldTypeString, alias: Annexation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Parcel_PIN (type: esriFieldTypeString, alias: Parcel_PIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pg_4_AJ (type: esriFieldTypeInteger, alias: 2ND_PORTION_SL_INVGN_MET_RR_FOR_CURRENT_PIPE_MATERIAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• globalid_1764966818286 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• GUID_ServiceLine (type: esriFieldTypeGUID, alias: ServiceLine GlobalID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address_1764966818286 (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• account_no (type: esriFieldTypeString, alias: ServiceLine ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• occupancy_type (type: esriFieldTypeString, alias: Type of Occupancy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Owner: Owner], [Property Manager: Property Manager], [Renter/Tenant: Renter/Tenant])
• service_line_accessible (type: esriFieldTypeString, alias: Can you locate your service line?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• inaccessible_reason (type: esriFieldTypeString, alias: Could you please explain why the service line is currently inaccessible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• service_line_magnetic (type: esriFieldTypeString, alias: Magnet Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• service_line_color (type: esriFieldTypeString, alias: Scratch Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Copper or orange: Copper or orange], [Shiny silver: Shiny silver], [Dull gray: Dull gray], ... 1 more ...)
• service_line_color_explain (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pipe_material (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Copper: Copper], [Plastic / HDPE / PVC: Plastic / HDPE / PVC], [Galvanized: Galvanized], ... 2 more ...)
• unknown_material_comments (type: esriFieldTypeString, alias: Please describe why you are unsure of the material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• full_name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Submitted: Submitted], [In Progress: In Progress], [Accepted: Accepted], ... 5 more ...)
• phone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate_1764966818286 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1764966818286 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1764966818286 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1764966818286 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• qc_reviewer (type: esriFieldTypeString, alias: QC Reviewer, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• qc_comments (type: esriFieldTypeString, alias: QC Comments (Public Facing), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• qc_pipe_material (type: esriFieldTypeString, alias: QC of Pipe Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Copper: Copper], [Plastic / HDPE / PVC: Plastic / HDPE / PVC], [Galvanized: Galvanized], ... 3 more ...)
• qc_custstatus (type: esriFieldTypeInteger, alias: QC'd Customer Side Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
• qc_completed (type: esriFieldTypeDate, alias: QC Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• service_line_replaced (type: esriFieldTypeString, alias: Have you had your service line replaced?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
• service_line_documentation (type: esriFieldTypeString, alias: Do you have documentation to demonstrate service line replacement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• everlead_1764966818286 (type: esriFieldTypeString, alias: Utility Side Everlead?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• utilinstalldate_1764966818286 (type: esriFieldTypeDate, alias: utilinstalldate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• cust_follow_up_comments (type: esriFieldTypeString, alias: Customer Follow-Up Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• investigation_comments (type: esriFieldTypeString, alias: Investigation Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Archive (type: esriFieldTypeString, alias: Archive, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• has_duplicates (type: esriFieldTypeString, alias: Has Duplicates, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• most_recent_survey (type: esriFieldTypeString, alias: Most Recent Survey, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: ServiceLine
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2026 12:03:44 AM

Schema Last Edit Date: 12/5/2025 8:29:20 PM

Data Last Edit Date: 12/5/2025 8:29:20 PM