Name: wsPipe

Display Field: description

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2341789.85799864
YMin: 569695.401087478
XMax: 2368514.31012705
YMax: 584956.964068219
Spatial Reference: 102748 (2285)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SubtypeCode","field2":null,"field3":null,"defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[171,140,0,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[77,128,0,255],"width":1},"value":"5","label":"Abandoned Pipe","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[135,23,0,255],"width":1},"value":"3","label":"Drain","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,26,176,255],"width":1},"value":"2","label":"Fire Main","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,42,133,255],"width":1},"value":"4","label":"Irrigation","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":2},"value":"0","label":"Main","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,133,102,255],"width":1},"value":"7","label":"Proposed","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[171,145,0,255],"width":1},"value":"6","label":"Reclaimed Water","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,92,230,255],"width":1},"value":"1","label":"Service Lateral","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: SubtypeCode

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SubtypeCode (type: esriFieldTypeSmallInteger, alias: Subtype Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• pipeID (type: esriFieldTypeString, alias: Pipe ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [COC: City of Colville], [PVT: Private])
• operationalStatus (type: esriFieldTypeString, alias: Operational Status, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [INSVC: In Service], [NOSVC: Not in Service], [ABND: Abandoned], ... 1 more ...)
• pipeDiameter (type: esriFieldTypeDouble, alias: Pipe Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4 in], [1: 1 in], [1.25: 1.25 in], ... 12 more ...)
• pipeMaterial (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [AC: Asbestos Lined Concrete], [AML: AM-Liner], [CLAY: Clay], ... 10 more ...)
• pipeLength (type: esriFieldTypeDouble, alias: Pipe Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• projectPriorityCode (type: esriFieldTypeSmallInteger, alias: Project Priority Code, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 100])
• yearInstalled (type: esriFieldTypeSmallInteger, alias: Year Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lastRepairDate (type: esriFieldTypeDate, alias: Last Repair Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• criticalAnnotation (type: esriFieldTypeString, alias: Critical Annotation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fireSystem (type: esriFieldTypeString, alias: Fire System, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• servicePressureZone (type: esriFieldTypeString, alias: Service Pressure Zone, SQL Type: sqlTypeOther, length: 4, nullable: false, editable: true, Coded Values: [HAW: Hawthorne-PRV], [LOW: Lower], [MAD: Madison-PRV], ... 1 more ...)
• Dia_Num (type: esriFieldTypeDouble, alias: Dia_Num, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4 in], [1: 1 in], [1.25: 1.25 in], ... 12 more ...)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 5
Name: Abandoned Pipe
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
Templates:

Name: Abandoned Pipe
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 5
• ownership: COC
• projectPriorityCode: 0
• fireSystem: N
• description: Abandoned Pipe
• operationalStatus: ABND
• yearInstalled: 0
• servicePressureZone:

---

ID: 3
Name: Drain
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
Templates:

Name: Drain
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 3
• ownership: PVT
• projectPriorityCode: 0
• fireSystem: N
• description: Drain
• operationalStatus: INSVC
• yearInstalled: 0
• servicePressureZone:

---

ID: 2
Name: Fire Main
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
Templates:

Name: Fire Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 2
• ownership: COC
• operationalStatus: INSVC
• pipeDiameter: 6
• projectPriorityCode: 0
• fireSystem: Y
• description: Fire Main
• pipeMaterial: DI
• yearInstalled: 0
• servicePressureZone:

---

ID: 4
Name: Irrigation
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
Templates:

Name: Irrigation
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 4
• ownership: PVT
• operationalStatus: INSVC
• pipeDiameter: 2
• projectPriorityCode: 0
• fireSystem: N
• description: Irrigation
• pipeMaterial: PVC
• yearInstalled: 0
• servicePressureZone:

---

ID: 0
Name: Main
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
Templates:

Name: Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 0
• ownership: COC
• projectPriorityCode: 0
• fireSystem: N
• description: Main
• operationalStatus: INSVC
• yearInstalled: 0
• servicePressureZone:

---

ID: 7
Name: Proposed
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
• Field Name: Dia_Num
  Inherited
  
Templates:

Name: Proposed
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 7
• ownership: COC
• projectPriorityCode: 0
• fireSystem: N
• description: Proposed
• operationalStatus: PROP
• yearInstalled: 0
• servicePressureZone:

---

ID: 6
Name: Reclaimed Water
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
• Field Name: Dia_Num
  Inherited
  
Templates:

Name: Reclaimed Water
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 6
• ownership: COC
• operationalStatus: INSVC
• projectPriorityCode: 0
• fireSystem: N
• description: Reclaimed Water
• pipeDiameter: 8
• yearInstalled: 0
• servicePressureZone:

---

ID: 1
Name: Service Lateral
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: fireSystem
  Inherited
  
• Field Name: servicePressureZone
  Inherited
  
Templates:

Name: Service Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 1
• ownership: PVT
• operationalStatus: INSVC
• pipeDiameter: 1
• projectPriorityCode: 0
• fireSystem: N
• description: Service Lateral
• pipeMaterial: HDPE
• yearInstalled: 0
• servicePressureZone:

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/15/2026 10:15:43 PM

Schema Last Edit Date: 1/26/2024 9:14:54 PM

Data Last Edit Date: 9/15/2026 10:15:43 PM

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