Stormwater Pipes
Federal Way Storm Pipe Layer
- Records
- 26,159
- Formats
- 4
- Last updated
- Feb 21, 2023
Download & API
STRMPIPE (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
STRMPIPE (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
STRMPIPE (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 | |
Trunk TRUNK | string | 2 values: N (24,726), Y (1,433) |
Geometry GEOMETRY | string | |
Material PMATERIAL | string | 8 values: CONC (19,316), CMP (3,302), CPEP (1,904)… |
Size PSIZE | number | 0 to 240 |
Length (As Built) LENGTH | number | 0.00 to 79.00 |
Upstream Measure Down UPS_MD | number | 0 to 922 |
Downstream Measure Down DWNS_MD | number | 0 to 37,993 |
Maintenance Responsibility MAINTRESP | string | 4 values: PUB (15,146), PRI (11,009), UNK (3)… |
Notes NOTES | string | |
Installation Date INSTALLDATE | integer | 0 to 2,019 |
Special Mods MODS | string | 3 values: NONE (26,057), ABANDON (89), 2WAYFLOW (13) |
Condition Score (0-100) CONDITION | integer | |
Roadway Classification ROADCLASS | string | 5 values: LOCAL (18,348), Collector (4,089), Arterial (3,714)… |
Steep Slope SLOPE | string | 3 values: N (19,697), NO (4,469), Y (1,961) |
Inspection Year INSPYEAR | integer | 0 to 2,113 |
Needs Cleaning NEEDCLEAN | string | 2 values: N (2,668), Y (87) |
Last Cleaned LASTCLEAN | integer | 2,011 to 2,026 |
| CREATOR | string | 3 values: PHELLER (1,012), SCURRY (114), JLarson@cfw.local (13) |
| CREATEDATE | datetime | |
| EDITOR | string | 9 values: PMCCLENDON (26,075), MLomeliGomez@cfw.local (39), SCURRY (14)… |
| EDITDATE | datetime | |
STORM PIPE ID ENTITYUID | string | |
LOCATION DESCRIPTION LOCATION | string | |
| STATUS | string | |
WARRANTY DATE WARRANTYDATE | datetime | |
LEGACY ID LEGACYID | string | |
CONDITION DATE CONDITIONDATE | datetime | |
INSTALLDATE INSTALLDATE2 | datetime | |
DECOMISSION DATE DECOMDATE | datetime | |
EXPECTED LIFE EXPLIFE | integer | |
REMAINING LIFE REMAINLIFE | integer | |
PROBAILITY OF FALIURE PROBABILITYFAIL | integer | |
CONSEQUENCE OF FALIURE CONSQUENCEFAIL | integer | |
BUSINESS RISK OF EXPOSURE BUISRISKEXPOSURE | integer | |
UNDER MAINTAINED RISK UNDERMAINT | integer | |
OVERMAINTAINED OVERMAINT | integer | |
REACTIVE MAINTENANCE SCORE REACTIVEMAINT | integer | |
ASSETTCALUATION DATE ASSETCALCDATE | datetime |