Layer: Service Line (ID:33)

View In: Map Viewer

Name: Service Line

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 3000

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":[69,173,145,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1.225}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.GISLINK"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","removeDuplicates":"none","stackLabel":false,"useCodedValues":true,"maxScale":0,"minScale":1000,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
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)
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: [UN: Unknown], [O: Other], [C: Copper], ... 7 more ...)
everlead (type: esriFieldTypeString, alias: Ever Lead?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: 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: [12: 12"], [10: 10"], [8: 8"], ... 15 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], ... 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 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], ... 2 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: [UN: Unknown], [O: Other], [C: Copper], ... 7 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: [12: 12"], [10: 10"], [8: 8"], ... 15 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], ... 2 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: [Y: Yes], [N: No], [UN: 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)
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 ...)
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)
Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Public-PWS: Public-PWS], [Private-Customer: Private-Customer], [Public and Private: Public and Private])
Lead_Upstream (type: esriFieldTypeString, alias: Was Lead Ever Upstream?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [UN: Unknown])
In_Service (type: esriFieldTypeString, alias: In Service, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
GIS_Link (type: esriFieldTypeString, alias: GIS Link, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Utility_Order_No (type: esriFieldTypeString, alias: Utility Order Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Utility_Excav (type: esriFieldTypeString, alias: Utility Excavator, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Corp_Loc (type: esriFieldTypeString, alias: Corporation Location, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Curb_Loc (type: esriFieldTypeString, alias: Curb Cock Location, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Cust_Excav (type: esriFieldTypeString, alias: Customer Excavator, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Cust_Order_No (type: esriFieldTypeString, alias: Customer Order Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
location2 (type: esriFieldTypeString, alias: Other Location Identifier 2 , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
GIS_ID (type: esriFieldTypeString, alias: GIS ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
CheckedAgainstHC (type: esriFieldTypeString, alias: Checked Against Hard Card?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Global (type: esriFieldTypeString, alias: Global, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Tap_Size (type: esriFieldTypeString, alias: Tap Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Utility_Length (type: esriFieldTypeString, alias: Utility_Length, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Customer_Length (type: esriFieldTypeString, alias: Customer Length, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Curb_Size (type: esriFieldTypeString, alias: Curb_Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Hyperlink (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Hyperlink_HC (type: esriFieldTypeString, alias: Hyperlink Hard Card, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Meter_Valve (type: esriFieldTypeString, alias: Meter_Valve, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Water_Main_Size (type: esriFieldTypeString, alias: Water_Main_Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Water_Main_Type (type: esriFieldTypeString, alias: Water_Main_Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Remarks (type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
Remarks_2 (type: esriFieldTypeString, alias: Remarks_2, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
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)
Service_Installation (type: esriFieldTypeString, alias: Service_Installation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Relationships:

MCGIS.Servwork (0) -- Related To: Servwork (157)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/21/2025 6:56:17 PM

Schema Last Edit Date: 2/21/2025 6:56:17 PM

Data Last Edit Date: 2/21/2025 6:56:17 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