All Layers and Tables (Service_Line

Layers:

Layer: Service Line Inventory (4)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

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:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

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:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Service_Line_Inventory)

Layers:

Layer: Service Line Inventory (4)