Name: STCH_Service_Line_Inventory

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10082151.6232768
YMin: 4684675.19365465
XMax: -10070003.9951635
YMax: 4699061.77331743
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"authoringInfo":{},"type":"uniqueValue","field1":"PWS_OWNED_SERVICE_LINE_MATERIAL","uniqueValueInfos":[{"value":"Copper","symbol":{"color":[0,112,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Copper"},{"value":"Galvanized","symbol":{"color":[255,170,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Galvanized"},{"value":"Unknown","symbol":{"color":[255,255,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[26,26,26,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Unknown"},{"value":"Other-Non-Lead","symbol":{"color":[115,178,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[115,178,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Other-Non-Lead"}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId2

Unique ID Field:

Name : ObjectId2

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: PWS_OWNED_SERVICE_LINE_MATERIAL

Fields:

• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• WATER_SYSTEM_ID_NUMBER (type: esriFieldTypeString, alias: WATER SYSTEM ID NUMBER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SYSTEM_SPECIFIC_ID (type: esriFieldTypeString, alias: SYSTEM SPECIFIC ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WATER_SYSTEM_COMMON_NAME (type: esriFieldTypeString, alias: WATER SYSTEM COMMON NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SERVICE_ADDRESS (type: esriFieldTypeString, alias: SERVICE ADDRESS, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ZIPCODE (type: esriFieldTypeInteger, alias: ZIPCODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• WATER_MAIN_MATERIAL (type: esriFieldTypeString, alias: WATER MAIN MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CONNECTOR_OR_GOOSENECK_MATERIAL (type: esriFieldTypeString, alias: CONNECTOR OR GOOSENECK MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WAS_LEAD_EVER_UPSTREAM_OF_THIS_ (type: esriFieldTypeString, alias: WAS LEAD EVER UPSTREAM OF THIS SERVICE?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PWS_OWNED_SERVICE_LINE_MATERIAL (type: esriFieldTypeString, alias: PWS-OWNED SERVICE LINE MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WAS_PWS_OWNED_SERVICE_LINE_EVER (type: esriFieldTypeString, alias: WAS PWS-OWNED SERVICE LINE EVER LEAD?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PWS_OWNED_SERVICE_LINE_SIZE (type: esriFieldTypeString, alias: PWS-OWNED SERVICE LINE SIZE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• YEAR_PWS_OWNED_SERVICE_LINE_INS (type: esriFieldTypeInteger, alias: YEAR PWS-OWNED SERVICE LINE INSTALLED, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CUSTOMER_OWNED_SERVICE_LINE_MAT (type: esriFieldTypeString, alias: CUSTOMER-OWNED SERVICE LINE MATERIAL, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CUSTOMER_OWNED_SERVICE_LINE_SIZ (type: esriFieldTypeString, alias: CUSTOMER-OWNED SERVICE LINE SIZE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• YEAR_CUSTOMER_OWNED_SERVICE_LIN (type: esriFieldTypeInteger, alias: YEAR CUSTOMER-OWNED SERVICE LINE INSTALLED, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• BUILDING_TYPE (type: esriFieldTypeString, alias: BUILDING TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• POINT_OF_ENTRY_OR_POINT_OF_USE_ (type: esriFieldTypeString, alias: POINT-OF-ENTRY OR POINT-OF-USE TREATEMENT PRESENT?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STRUCTURE____PRIMARY_PLUMBING_M (type: esriFieldTypeString, alias: STRUCTURE - PRIMARY PLUMBING MATERIAL 1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• YEAR_STRUCTURE_PLUMBING_INSTALL (type: esriFieldTypeInteger, alias: YEAR STRUCTURE PLUMBING INSTALLED, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• YEAR__RANGE__STRUCTURE_PLUMBING (type: esriFieldTypeString, alias: YEAR (RANGE) STRUCTURE PLUMBING MATERIAL INSTALLED, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• THIS_LOCATION_WILL_BE_USED_FOR_ (type: esriFieldTypeString, alias: THIS LOCATION WILL BE USED FOR LEAD AND COPPER SAMPLE SITE PLAN?, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SOURCE_1__PWS_OWNED_SERVICE_LIN (type: esriFieldTypeInteger, alias: SOURCE 1: PWS-OWNED SERVICE LINE ID METHOD OR INFO USED (ENTER ONE OR MORE), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SOURCE_2__CUSTOMER_OWNED_SERVIC (type: esriFieldTypeInteger, alias: SOURCE 2: CUSTOMER-OWNED SERVICE LINE ID METHOD OR INFO USED (ENTER ONE OR MORE), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• x (type: esriFieldTypeDouble, alias: x, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• y (type: esriFieldTypeDouble, alias: y, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• ObjectId2 (type: esriFieldTypeOID, alias: ObjectId2, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

ID: Copper
Name: Copper
Domains:

Templates:

Name: Copper
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PWS_OWNED_SERVICE_LINE_MATERIAL: Copper

---

ID: Galvanized
Name: Galvanized
Domains:

Templates:

Name: Galvanized
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PWS_OWNED_SERVICE_LINE_MATERIAL: Galvanized

---

ID: Unknown
Name: Unknown
Domains:

Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PWS_OWNED_SERVICE_LINE_MATERIAL: Unknown

---

ID: Other-Non-Lead
Name: Other-Non-Lead
Domains:

Templates:

Name: Other-Non-Lead
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PWS_OWNED_SERVICE_LINE_MATERIAL: Other-Non-Lead

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/25/2026 6:13:19 PM

Schema Last Edit Date: 6/5/2025 1:05:41 PM

Data Last Edit Date: 6/25/2026 6:13:19 PM

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