Stormwater Structures
Federal Way Storm Structure Layer
- Records
- 23,016
- Formats
- 4
- Last updated
- Feb 21, 2023
Download & API
STRMSTRCR (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
STRMSTRCR (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
STRMSTRCR (map tiles)pmtiles
Vector tiles — embed in a map
Live ArcGIS layer (source)arcgis
Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works
Schema
| Field | Type | Values |
|---|---|---|
Asset ID ASSETID | string | |
Lid Type LIDTYPE | string | |
Structure Material SMATERIAL | string | 3 values: CONC (22,747), OTHER (173), BRICK (65) |
Locking Lid LOCKING | string | 3 values: N (19,697), Y (962), L (1) |
RIM Elevation RIM | number | 0 to 507 |
Diameter DIM | string | |
Sump Depth SUMPD | number | -20 to 288 |
Maintenance Responsibility MAINTRESP | string | 3 values: PUB (13,164), PRI (9,794), UNK (6) |
Notes NOTES | string | |
Installation Date INSTALLDATE | integer | 0 to 2,024 |
Special Mods MODS | string | 10 values: NONE (22,618), CTRLSTRCTR (190), OWS (68)… |
Condition Score (0-100) CONDITION | integer | 0 to 642 |
Inspection Year INSPYEAR | integer | 0 to 2,028 |
Needs Cleaning NEEDCLEAN | string | 5 values: N (11,556), 0 (6,134), A (680)… |
Last Cleaned LASTCLEAN | integer | 0 to 2,826 |
| CREATOR | string | 11 values: PHELLER (693), SCURRY (221), JLarson@cfw.local (187)… |
| CREATEDATE | datetime | |
| EDITOR | string | 12 values: SCURRY (15,936), SEidsmoe@cfw.local (5,463), RSzkutnik@cfw.local (770)… |
| EDITDATE | datetime | |
Total Depth TDEPTH | number | -52 to 328 |
Invert Depth IDEPTH | number | -75 to 2,024 |
Sediment Depth SDEPTH | number | -40 to 2,025 |
INSPDATAE INSPDATE | datetime | |
CB Type CBTYPE | string | 5 values: T1 (7,712), T2 (2,875), T26 (667)… |
Need Maintenance NEEDMAINT | string | 12 values: NO (350), RGRT (96), ODN (74)… |
Date Cleaned DATECLEANED | datetime | |
Road Classification ROADCLASS | string | 1 values: LOCAL (125) |
Completed by Vactor VACTOR | string | 4 values: Y (1,925), N (99), A (67)… |
| ENTITYUID | string | |
| LOCATION | string | |
| STATUS | string | |
WARRANTY DATE WARRANTYDATE | datetime | |
| LEGACYID | string | |
CONTION DATE CONDITIONDATE | datetime | |
DECOMISSION DATE DECOMISSIONEDDATE | datetime | |
EXPECTED LIFE EXPECTEDLIFE | integer | |
REMAINING LIFE REMAININGLIFE | integer | |
PROBABILITY OF FAILURE PROBABILITYFAIL | integer | |
CONSQUENCE OF FAILURE CONSQUENCEFAIL | integer | |
BUISNESS RISK OF EXPOSURE BUISRISKEXPOSURE | integer | |
UNDER MAINTAINED SCORE UNDERMAINTAINEDSCORE | integer | |
OVER MAINTAINED SCORE OVERMAINTAINEDSCORE | integer | |
REACTIVE MAINTENANCE SCORE REACTIVEMAINTSCORE | integer | |
ASSET CALCULATION DATE ASSETCALCULATION | datetime |