Layer: ServiceLine_SurveyJoin (ID:0)

View In: Map Viewer

Name: ServiceLine_SurveyJoin

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

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:

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:

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:

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: 12/5/2025 8:29:20 PM

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

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