Stormwater Facilities
Stormwater sewer facilities (ponds, tanks, vaults, etc) in Federal Way and nearby areas.
- Records
- 2,325
- Formats
- 5
- Last updated
- Nov 13, 2024
Download & API
Stormwater Facilities (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Stormwater Facilities (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Stormwater Facilities (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Stormwater Facilities (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 | |
Type POLYTYPE | string | |
Retention RET | string | 2 values: N (2,236), Y (87) |
Detention DET | string | 2 values: N (1,723), Y (602) |
Water Quality WATQ | string | 2 values: N (1,887), Y (438) |
Maintenance Responsibility MAINTRESP | string | 2 values: PRI (1,803), PUB (522) |
Notes NOTES | string | |
Installation Date INSTALLDATE | integer | 0 to 2,025 |
Condition Score (0-100) CONDITION | integer | 0 to 100 |
Inspection Year INSPYEAR | integer | 0 to 2,028 |
Needs Cleaning NEEDCLEAN | string | 2 values: N (1,175), Y (22) |
Last Cleaned LASTCLEAN | integer | 2,014 to 2,026 |
| CREATOR | string | 3 values: PHELLER (111), SCURRY (21), MLomeliGomez@cfw.local (1) |
| CREATEDATE | datetime | |
| EDITOR | string | 7 values: SCURRY (2,214), LLomeli@cfw.local (43), ErnestF@cfw.local (40)… |
| EDITDATE | datetime | |
| ENTIYUID | string | |
| LOCATION | string | |
| STATUS | string | |
WARRANTY DATE WARRANTYDATE | datetime | |
LEGACY ID LEGACYID | string | |
DECOMMISSIONED DATE DECOMMISSIONEDDATE | datetime | |
EXPECTED LIFE EXPECTEDLIFE | integer | |
REMAINING LIFE REMAININGLIFE | integer | |
PROBABILITY OF FAILURE PROBFAIL | integer | |
CONSEQUENCE OF FAILURE CONFAIL | integer | |
BUDGET RISK BUDRISK | integer | |
UNDER MAINTAINED UNDERMAINTAINED | integer | |
OVER MAINTAINED OVERMAINTAINED | integer | |
REACTIVE MAINTENANCE SCORE REACTMAINTSCORE | integer | |
ASSET CALCULATION DATE ASSETCALCDATE | datetime |