Name: Service Line Inventory

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

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: -151257.64035807
YMin: 267740.808352725
XMax: 635450.692145247
YMax: 913074.05070124
Spatial Reference: 103118 (6535)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"2a5303b455e832463b15236e05f0dc0a","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA9UlEQVQokaWSsQ3CMBBFXxEJSrooFGQDOkZIB0yQOmxAzxihQ2KCUDIDTUagQKIjG6BvYjgiJxR8CYnYfuf79x3xh6LA2hRYAiuzdgM2v2ABJZAEihbAGjiFYIGV/sxySHMYxdDUcD/D9ejOVLZAZFrVjSwOEGefiuPs9T2ZQ711S2UXlsdEN1rQSnuP2nWQtBb2HnbDUatDSvN3+ysLO8njkEad/S9Yw5HHPjV1GFaObqp9nv1+q4uF9QAK+dFUNZyuTFwX+bWwpPwqxaGp9uQs7XynFlZ2KlAqDnPYtiow+MJ8Af2Uo33bvlV3Yx/spYPO15CeCt5Ezsseq6YAAAAASUVORK5CYII=","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• streetaddress (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• town (type: esriFieldTypeString, alias: Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• zipcode (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• leadgoosenck (type: esriFieldTypeString, alias: Lead Gooseneck, Pigtail or Connector Currently Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• m_c_gooseneck (type: esriFieldTypeString, alias: Main to CopperRB Stop : Gooseneck, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• public_material (type: esriFieldTypeString, alias: Current Public Side SL Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead including lead-lined galvanized: Lead including lead-lined galvanized], [Copper: Copper], [Galvanized: Galvanized], ... 5 more ...)
• m_c_material (type: esriFieldTypeString, alias: Main to CopperRB Stop : Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cast Iron: Cast Iron], [Copper: Copper], [Copper/Galvanized: Copper/Galvanized], ... 7 more ...)
• public_everlead (type: esriFieldTypeString, alias: Was Public SL Material Ever Previously Lead?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• public_verification (type: esriFieldTypeString, alias: Public SL Material Verification Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Records: Records], [Field Inspection: Field Inspection], [Excavation: Excavation], ... 4 more ...)
• public_install (type: esriFieldTypeDate, alias: Public SL Installation or Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• m_c_month (type: esriFieldTypeString, alias: Main to CopperRB Stop : Month Install, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• m_c_yearinstall (type: esriFieldTypeString, alias: Main to CopperRB Stop : Year Install, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• public_size (type: esriFieldTypeString, alias: Public SL Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Upto 1": Upto 1"], [1" < SL ≤ 1.5": 1" < SL ≤ 1.5"], [1.5" < SL ≤ 2": 1.5" < SL ≤ 2"], ... 2 more ...)
• m_c_size (type: esriFieldTypeString, alias: Main to CopperRB Stop : Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• customer_material (type: esriFieldTypeString, alias: Customer SL Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead including lead-lined galvanized: Lead including lead-lined galvanized], [Copper: Copper], [Galvanized: Galvanized], ... 5 more ...)
• c_h_material (type: esriFieldTypeString, alias: Curb Stop to Meter : Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cast Iron: Cast Iron], [Copper: Copper], [Copper/Galvanized: Copper/Galvanized], ... 7 more ...)
• customer_verification (type: esriFieldTypeString, alias: Customer SL Material Verification Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Records: Records], [Field Inspection: Field Inspection], [Excavation: Excavation], ... 4 more ...)
• lead_solder (type: esriFieldTypeString, alias: Lead Solder Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• building_type (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Single Family: Single Family], [Multi Family: Multi Family], [School or Childcare: School or Childcare], ... 2 more ...)
• poe_treatment (type: esriFieldTypeString, alias: POU or POE Treatment Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• customer_install (type: esriFieldTypeDate, alias: Customer SL Installation or Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• c_h_month (type: esriFieldTypeString, alias: Curb Stop to Meter : Month Install, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c_h_yearinstall (type: esriFieldTypeString, alias: Curb Stop to Meter : Year Install, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• customer_size (type: esriFieldTypeString, alias: Customer SL Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Upto 1": Upto 1"], [1" < SL ≤ 1.5": 1" < SL ≤ 1.5"], [1.5" < SL ≤ 2": 1.5" < SL ≤ 2"], ... 2 more ...)
• c_h_size (type: esriFieldTypeString, alias: Curb Stop to Meter : Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sl_category (type: esriFieldTypeString, alias: SL Category (Leave Blank), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• note (type: esriFieldTypeString, alias: Note, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• full_address (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PropertyPhoneNumber (type: esriFieldTypeString, alias: Property Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PropertyEmail (type: esriFieldTypeString, alias: Property Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• replacestatus (type: esriFieldTypeString, alias: 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], ... 1 more ...)
• 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: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Line Break: Line Break], [Other: Other])
• custnotified (type: esriFieldTypeString, alias: Notified Customer, SQL Type: sqlTypeOther, length: 256, 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)
• RplcDt (type: esriFieldTypeDate, alias: Date Replacement Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PhotoAttached (type: esriFieldTypeString, alias: Photo Attached?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• y (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• x (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• service_num (type: esriFieldTypeString, alias: Service Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• wono (type: esriFieldTypeString, alias: W.O.No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• main_newest_card_Year (type: esriFieldTypeString, alias: Main : Newest card Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• main_material (type: esriFieldTypeString, alias: Main : Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• main_size (type: esriFieldTypeString, alias: Main : Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• main_depth (type: esriFieldTypeString, alias: Main : Depth (Inches), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• material_list (type: esriFieldTypeString, alias: Detailed Materials List, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• m_c_copperrb (type: esriFieldTypeString, alias: Main to CopperRB Stop : Copperrb Stop, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• m_c_length (type: esriFieldTypeString, alias: Main to CopperRB Stop : Length, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c_h_length (type: esriFieldTypeString, alias: Curb Stop to Meter : Length, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• galvanized (type: esriFieldTypeString, alias: Galvanized in Service Line, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contractor (type: esriFieldTypeString, alias: Installed by Contractor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• customer_owned (type: esriFieldTypeString, alias: Customer Owned?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments (From Spreadsheet), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Survey123: Survey123], [Excel: Excel], [Field Verified : Field Verified], ... 3 more ...)
• Public_Source (type: esriFieldTypeString, alias: Public Side Data Source, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Records Review: Records Review], [Visual Inspection: Visual Inspection], [Customer Reported: Customer Reported], ... 1 more ...)
• Customer_Source (type: esriFieldTypeString, alias: Customer Side Data Source, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Records Review: Records Review], [Visual Inspection: Visual Inspection], [Customer Reported: Customer Reported], ... 1 more ...)
• Public_Office_Verified (type: esriFieldTypeString, alias: Public Side - Office Verified, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Customer_Office_Verified (type: esriFieldTypeString, alias: Customer Side - Office Verified, 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, Coded Values: [Proposed: Proposed], [In Service: In Service], [Removed: Removed], ... 1 more ...)
• numberofmeter (type: esriFieldTypeInteger, alias: Number of Meters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• publicsldiameter (type: esriFieldTypeString, alias: Public - SL Diameter, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [0.5": 0.50"], [0.75": 0.75"], [1.00": 1.00"], ... 9 more ...)
• privatesldiameter (type: esriFieldTypeString, alias: Private - SL Diameter, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [0.5": 0.50"], [0.75": 0.75"], [1.00": 1.00"], ... 9 more ...)
• verified (type: esriFieldTypeString, alias: Verified, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CurbStop_Location (type: esriFieldTypeString, alias: Curb Stop Location, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Sidewalk: Sidewalk], [Street: Street], [Subway: Subway], ... 2 more ...)
• Curb_Box_Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Curb_Box_Replaced (type: esriFieldTypeString, alias: Curb Box Replaced, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Service_Depth (type: esriFieldTypeString, alias: Service Depth, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Notes_Main_to_Curb (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Notes_Curb_to_Meter (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SLP_Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [GPS: GPS], [Estimated: Estimated])
• Curb_to_Meter_2ndVerification (type: esriFieldTypeString, alias: Secondary Verification, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Records: Records], [Field Inspection: Field Inspection], [Excavation: Excavation], ... 1 more ...)
• Ground (type: esriFieldTypeString, alias: Ground on service?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Templates:

Name: Service Line Inventory
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• leadgoosenck: Unknown
• public_everlead: Unknown
• public_verification: Not Verified
• customer_verification: Not Verified
• lead_solder: Unknown
• poe_treatment: Unknown
• PhotoAttached: No
• Status: In Service
• numberofmeter: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/9/2026 3:10:34 PM

Schema Last Edit Date: 9/22/2026 12:44:15 PM

Data Last Edit Date: 10/9/2026 3:10:34 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat