Name: ssPipe

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: 2341805.23001514
YMin: 571739.87731348
XMax: 2359444.61894889
YMax: 585103.641924471
Spatial Reference: 102748 (2285)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SubtypeCode","field2":null,"field3":null,"defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,140,133,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[225,225,225,255],"width":1},"value":"5","label":"Abandoned","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2},"value":"3","label":"Force Main","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[11,171,0,255],"width":2},"value":"0","label":"Main","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,0,0,255],"width":1},"value":"2","label":"Pressure Lateral","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[56,168,0,255],"width":1},"value":"1","label":"Service Lateral","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":1},"value":"4","label":"Unknown","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: SubtypeCode, 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: Sewer 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])
• pipeDiameter (type: esriFieldTypeSmallInteger, alias: Pipe Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [2: 2 in.], [4: 4 in.], ... 8 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], ... 9 more ...)
• pipeLength (type: esriFieldTypeDouble, alias: Pipe Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pipeSlopePercentage (type: esriFieldTypeDouble, alias: Pipe Slope Percentage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maintenanceSchedule (type: esriFieldTypeString, alias: Maintenance Schedule, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [C: Camera], [CY1: Camera and Clean], [Y: Yearly Clean], ... 1 more ...)
• 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)
• rate (type: esriFieldTypeSmallInteger, alias: Rate, SQL Type: sqlTypeOther, 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)
• verifiedGPS (type: esriFieldTypeString, alias: Verified GPS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• sewerBasin (type: esriFieldTypeString, alias: Sewer Basin, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: Basin A], [B: Basin B], [C: Basin C])
• dateExported (type: esriFieldTypeDate, alias: Date Exported, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CIPP (type: esriFieldTypeString, alias: CIPP, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• prioroty_CIPP (type: esriFieldTypeSmallInteger, alias: prioroty_CIPP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lastRoddedDate (type: esriFieldTypeDate, alias: lastRoddedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 5
Name: Abandoned
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: maintenanceSchedule
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: verifiedGPS
  Inherited
  
• Field Name: sewerBasin
  Inherited
  
Templates:

Name: Abandoned
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 5
• ownership: COC
• operationalStatus: ABND
• pipeDiameter: 8
• projectPriorityCode: 0
• description: Main
• pipeMaterial: PVC
• pipeSlopePercentage: 0
• yearInstalled: 0
• verifiedGPS: N

---

ID: 3
Name: Force Main
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: maintenanceSchedule
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: verifiedGPS
  Inherited
  
• Field Name: sewerBasin
  Inherited
  
Templates:

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

Attributes:

• SubtypeCode: 3
• ownership: COC
• operationalStatus: INSVC
• pipeDiameter: 8
• projectPriorityCode: 0
• description: Force Main
• pipeMaterial: PVC
• pipeSlopePercentage: 0
• yearInstalled: 0
• verifiedGPS: N

---

ID: 0
Name: Main
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: maintenanceSchedule
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: verifiedGPS
  Inherited
  
• Field Name: sewerBasin
  Inherited
  
Templates:

Name: Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 0
• ownership: COC
• operationalStatus: INSVC
• pipeDiameter: 8
• projectPriorityCode: 0
• description: Main
• pipeMaterial: PVC
• pipeSlopePercentage: 0
• yearInstalled: 0
• verifiedGPS: N

---

ID: 2
Name: Pressure Lateral
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: maintenanceSchedule
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: verifiedGPS
  Inherited
  
• Field Name: sewerBasin
  Inherited
  
Templates:

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

Attributes:

• SubtypeCode: 2
• ownership: COC
• operationalStatus: INSVC
• pipeDiameter: 8
• projectPriorityCode: 0
• description: Pressure Lateral
• pipeMaterial: PVC
• pipeSlopePercentage: 0
• yearInstalled: 0
• verifiedGPS: N

---

ID: 1
Name: Service Lateral
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: maintenanceSchedule
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: verifiedGPS
  Inherited
  
• Field Name: sewerBasin
  Inherited
  
Templates:

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

Attributes:

• SubtypeCode: 1
• ownership: COC
• operationalStatus: INSVC
• pipeDiameter: 4
• projectPriorityCode: 0
• description: Service Lateral
• pipeMaterial: PVC
• pipeSlopePercentage: 0
• yearInstalled: 0
• verifiedGPS: N

---

ID: 4
Name: Unknown
Domains:

• Field Name: ownership
  Inherited
  
• Field Name: operationalStatus
  Inherited
  
• Field Name: pipeDiameter
  Inherited
  
• Field Name: pipeMaterial
  Inherited
  
• Field Name: maintenanceSchedule
  Inherited
  
• Field Name: projectPriorityCode
  Inherited
  
• Field Name: verifiedGPS
  Inherited
  
• Field Name: sewerBasin
  Inherited
  
Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SubtypeCode: 4
• ownership: COC
• operationalStatus: INSVC
• pipeDiameter: 8
• projectPriorityCode: 0
• description: Unknown
• pipeMaterial: PVC
• pipeSlopePercentage: 0
• yearInstalled: 0
• verifiedGPS: N

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/30/2026 6:25:53 PM

Schema Last Edit Date: 12/1/2023 6:47:38 PM

Data Last Edit Date: 6/30/2026 6:25:53 PM

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