Name: Pipe

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 1320858.27420972
YMin: 356568.718745887
XMax: 1343448.98296522
YMax: 379087.373839721
Spatial Reference: 102748 (2285)
Vertical Spatial Reference: 105790 (3855)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: true

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)
• assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [4: Force Main], [3: Gravity], ... 3 more ...)
• StructuralIntegrity (type: esriFieldTypeString, alias: Structural Integrity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1Excellent: 1 - Excellent], [2Good: 2 - Good], [3Fair: 3 - Fair], ... 2 more ...)
• HydraulicCapacity (type: esriFieldTypeString, alias: Hydraulic Capacity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1Excellent: 1 - Excellent], [2Good: 2 - Good], [3Fair: 3 - Fair], ... 2 more ...)
• CorrosionWear (type: esriFieldTypeString, alias: Corrosion/Wear, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1Excellent: 1 - Excellent], [2Good: 2 - Good], [3Fair: 3 - Fair], ... 2 more ...)
• JointCondition (type: esriFieldTypeString, alias: Joint Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1Excellent: 1 - Excellent], [2Good: 2 - Good], [3Fair: 3 - Fair], ... 2 more ...)
• RootIntrusion (type: esriFieldTypeString, alias: Root Intrusion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1Excellent: 1 - Excellent], [2Good: 2 - Good], [3Fair: 3 - Fair], ... 2 more ...)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cleaned: Cleaned], [NeedsCleaning: Needs Cleaning], [ReadyForCCTV: Ready For CCTV], ... 3 more ...)
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 27 more ...)
• material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unkown], [2: HDPE Smooth], [3: PVC], ... 11 more ...)
• StaffQAQCCCTV (type: esriFieldTypeString, alias: Staff QAQC CCTV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [YesButIssues: Yes But Issues with edits])
• InventoryPriority (type: esriFieldTypeString, alias: Inventory Priority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Contractor: Contractor], [COLS: COLS])
• WorkOrderStatus (type: esriFieldTypeSmallInteger, alias: WorkOrderStatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Inspection Done], [2: Asset Inspected, Meets Maintenance Standards], [5: Work Completed], ... 4 more ...)
• CleanDate (type: esriFieldTypeDate, alias: CleanDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: InspectionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaintenanceDate (type: esriFieldTypeDate, alias: MaintenanceDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• upelev (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• downelev (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 7 more ...)
• lined (type: esriFieldTypeSmallInteger, alias: Lined?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• lineryear (type: esriFieldTypeSmallInteger, alias: Liner Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1800 - 2060])
• linermethod (type: esriFieldTypeSmallInteger, alias: Liner Method, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Cured In Place - CIP], [2: Fold and Form or Deform/Reform - FF], ... 11 more ...)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: City of Lake Stevens], [3: WSDOT], [4: Snohomish County], ... 5 more ...)
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: City of Lake Stevens], [3: WSDOT], [4: Snohomish County], ... 5 more ...)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• VueWorksInstallYear (type: esriFieldTypeSmallInteger, alias: VueWorksInstallYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VueCondition (type: esriFieldTypeSmallInteger, alias: VueCondition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VueType (type: esriFieldTypeString, alias: VueType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VueUnits (type: esriFieldTypeDouble, alias: VueUnits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LetterSent (type: esriFieldTypeDate, alias: LetterSent, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Pipe
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 0
• diameter: 0
• lifecyclestatus: 8
• lined: 0
• linermethod: 0
• ownedby: 9
• maintby: 9
• spatialsource: 0
• spatialconfidence: 0

Relationships:

• (21) -- Related To: Inspection_Pipe (51)
• (23) -- Related To: WorkOrder_Pipe (79)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/6/2026 6:56:09 PM

Schema Last Edit Date: 8/6/2026 6:55:19 PM

Data Last Edit Date: 8/6/2026 6:55:19 PM

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