Stormwater Open Channels
Federal Way Open Conveyance Layer
- Records
- 2,722
- Formats
- 5
- Last updated
- Feb 21, 2023
Download & API
STRMLINE (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
STRMLINE (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
STRMLINE (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
STRMLINE (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 | |
Channel Material CMATERIAL | string | 3 values: GRASS (2,718), ROCK (3), OTHER (1) |
Channel Size CSIZE | string | 1 values: 2 (2) |
Maintenance Responsibility MAINTRESP | string | 3 values: PUB (2,671), PRI (50), UNK (1) |
Notes NOTES | string | |
Installation Date INSTALLDATE | integer | 0 to 2,009 |
Inspection Year INSPYEAR | integer | 0 to 2,025 |
Condition Score (0-100) CONDITION | number | 0.00 to 60.00 |
| CREATOR | string | 2 values: PHELLER (19), SCURRY (15) |
| CREATEDATE | datetime | |
| EDITOR | string | 4 values: PMCCLENDON (2,703), SCURRY (16), SCurry@cfw.local (2)… |
| EDITDATE | datetime | |
STORM LINE ID ENTITYUID | string | |
LOCATION DESCRIPTION LOCATION | string | |
| STATUS | string | |
WARRANTY DATE WARRANTYDATE | datetime | |
| LEGACYID | string | |
CONDITION DATE CONDITIONDATE | datetime | |
DECOMISSION DATE DECOMDATE | datetime | |
EXPECTED USEFUL LIFE EXPLIFE | integer | |
REMAINING USEFUL LIFE REMAINLIFE | integer | |
PROBABIOLITY OF FAILURE PROBFAIL | integer | |
CONSEQUENCE OF FALIURE CONSFAIL | integer | |
BUSSINESS RISK OF FAILURE BUSRISKFAIL | integer | |
UNDER MAINTAINED SCORE UNDERMAINTSCORE | integer | |
| OVERMAINTSCORE | integer | |
| REACTMAINTSCORE | integer | |
| ASSETCALC | datetime |