Name: Connect Sump and No Sump

Display Field: DBAssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: 1221440.10395198
YMin: 33542.3260860592
XMax: 1559332.27757572
YMax: 292269.281728223
Spatial Reference: 2926 (2926)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[133,0,11,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

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)
• AssetID (type: esriFieldTypeInteger, alias: AssetID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DBAssetID (type: esriFieldTypeString, alias: DB Asset ID, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• FunctionType (type: esriFieldTypeString, alias: Function Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [No Sump: No Sump], [Sump: Sump])
• Component (type: esriFieldTypeString, alias: Component, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [Catch Basin: Catch Basin], [Non-Standard: Non-Standard], [Grate Inlet: Grate Inlet], ... 5 more ...)
• ComponentType (type: esriFieldTypeString, alias: Component Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [CB Type 1: CB Type 1], [CB Type 1L: CB Type 1L], [CB Type 1P: CB Type 1P], ... 10 more ...)
• DesignType (type: esriFieldTypeString, alias: Design Type, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Standard: Standard], [Non-Standard: Non-Standard])
• PipeCount (type: esriFieldTypeSmallInteger, alias: Pipe Count, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [1 - 9])
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [Concrete: Concrete], [Brick: Brick], [Metal: Metal], ... 1 more ...)
• Diameter (type: esriFieldTypeString, alias: Diameter (in), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [36: 36], [48: 48], [>=54: >=54], ... 4 more ...)
• WidthA (type: esriFieldTypeSmallInteger, alias: Width A (in), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 150])
• WidthB (type: esriFieldTypeSmallInteger, alias: Width B (in), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 150])
• StructureShape (type: esriFieldTypeString, alias: Structure Shape, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Rectangle: Rectangle], [Round: Round], [Other: Other])
• OutletDepth (type: esriFieldTypeDouble, alias: Outlet Depth (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SumpDepth (type: esriFieldTypeDouble, alias: Sump Depth (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalDepth (type: esriFieldTypeDouble, alias: Total Depth (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• CoverSize (type: esriFieldTypeString, alias: Cover Size (in), SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [18x24: 18x24], [20x24: 20x24], [24x47: 24x47], ... 10 more ...)
• CoverStyle (type: esriFieldTypeString, alias: Cover Style, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [Beehive: Beehive], [Birdcage: Birdcage], [Grate: Grate], ... 6 more ...)
• MeasSource (type: esriFieldTypeString, alias: Measurement Source, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Field estimate: Field estimate], [Field measurement: Field measurement], [Plans: Plans], ... 5 more ...)
• CoverElevation (type: esriFieldTypeDouble, alias: Cover Elevation (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletElevation (type: esriFieldTypeDouble, alias: Outlet Elevation (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LockingCover (type: esriFieldTypeString, alias: Locking Cover, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• JailHouseWindow (type: esriFieldTypeString, alias: JailHouseWindow, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ControlStructure (type: esriFieldTypeString, alias: Control Structure, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SpillControl (type: esriFieldTypeString, alias: SpillControl, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [None: None], [T-section: T-section], [Downturn elbow: Downturn elbow], ... 1 more ...)
• FlowSplitter (type: esriFieldTypeString, alias: FlowSplitter, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [None: None], [Multiple outlets: Multiple outlets], [Baffle wall: Baffle wall], ... 2 more ...)
• Intent (type: esriFieldTypeString, alias: Intent, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Convey stormwater: Convey stormwater], [Convey natural water body: Convey natural water body], [Maintenance Only: Maintenance Only])
• OwnerEntity (type: esriFieldTypeString, alias: Owner Entity, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [Roads: KC DLS - Road Services Division], [WLRD: KC DNRP - Water and Land Resources Division], [WTD: KC DNRP - Waste Water Treatment Division], ... 13 more ...)
• Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true, Coded Values: [King County: King County], [Algona: Algona], [Auburn: Auburn], ... 43 more ...)
• DataStage (type: esriFieldTypeString, alias: Data Stage, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [Acquire: Acquire], [Process: Process], [Approved: Approved], ... 6 more ...)
• CurrentStatus (type: esriFieldTypeString, alias: Current Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Active: Active], [Retired: Retired], [Removed: Removed], ... 4 more ...)
• XYSource (type: esriFieldTypeString, alias: XY Source, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [CAD: CAD], [GPS: GPS], [Picked from aerial: Picked from aerial], ... 5 more ...)
• DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [SWSS Mapping: KC DNRP - WLRD SWSS Mapping], [WTD LinearNetwork: KC DNRP - WTD Linear Network], [WTD PointNetwork: KC DNRP - WTD Point Network], ... 10 more ...)
• FieldVisitDate (type: esriFieldTypeDate, alias: Field Visit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastEditDate (type: esriFieldTypeDate, alias: Last Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlanLink (type: esriFieldTypeString, alias: Plan Link, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• PAA (type: esriFieldTypeString, alias: PAA, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• CCTVInspectionDate (type: esriFieldTypeDate, alias: Most Recent CCTV Inspection, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CBInsert (type: esriFieldTypeString, alias: CB Insert, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Ladder (type: esriFieldTypeString, alias: Ladder, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true, Coded Values: [None: None], [Hanging: Hanging], [Other: Other], ... 1 more ...)
• GravelFilter (type: esriFieldTypeString, alias: Gravel Filter, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• OutletStructure (type: esriFieldTypeString, alias: Outlet Structure (WQ elevation control), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes (no internal structure)], [T-section: T-section], ... 1 more ...)
• OverflowType (type: esriFieldTypeString, alias: Overflow Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [High-flow bypass: High-flow bypass], [Overflow: Overflow], ... 1 more ...)
• KingCountyMS4 (type: esriFieldTypeString, alias: King County MS4, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD])

Templates:

Name: Connect Sump and No Sump
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Ladder: None
• CBInsert: No
• Component:
• DesignType: Standard
• PipeCount: 2
• Material: Concrete
• CoverSize:
• CoverStyle: Grate
• MeasSource: Field estimate
• LockingCover: No
• JailHouseWindow: No
• ControlStructure: No
• EmergencyOverflow: None
• SpillControl: None
• FlowSplitter: None
• Intent: Convey stormwater
• OwnerEntity:
• Jurisdiction: King County
• DataStage: Acquire
• CurrentStatus: Active
• XYSource: Picked from aerial
• DataSource:
• GravelFilter: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/11/2026 1:31:14 PM

Schema Last Edit Date: 7/11/2026 1:31:08 PM

Data Last Edit Date: 7/11/2026 1:31:01 PM

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