Street Overlay (Repaving) History
History of street overlay projects in Federal Way.
- Records
- 2,146
- Formats
- 5
- Last updated
- Apr 27, 2023
Download & API
Overlay History of Federal Way Streets (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Overlay History of Federal Way Streets (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Overlay History of Federal Way Streets (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Overlay History of Federal Way Streets (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 |
|---|---|---|
| FNODE_ | integer | 0 to 6,931 |
| TNODE_ | integer | 0 to 6,930 |
| LPOLY_ | integer | |
| RPOLY_ | integer | |
| LENGTH | number | 4 to 2,871 |
| OVLYHIST_ | integer | 1 to 1,140 |
| OVLYHIST_ID | integer | 1 to 6,891 |
| STREETID | number | 0 to 8,464 |
| STNAME | string | |
| CLASS_OLD | string | 3 values: MINOR (129), COLLECTOR (68), PRINCIPAL (68) |
| SMALL | integer | 0 to 9 |
| STN | integer | 0 to 9,995 |
| SGN | integer | 0 to 380 |
| CLASS_NEW | string | 5 values: MINOR COLLECTOR (293), PRINCIPAL ARTERIAL (128), MINOR ARTERIAL (119)… |
| DIR | string | 2 values: SW (593), S (121) |
| RIGHTADDFR | integer | 0 to 37,501 |
| RIGHTADDTO | integer | -2 to 37,599 |
| LEFTADDFR | integer | 0 to 37,500 |
| LEFTADDTO | integer | -1 to 39,998 |
| JR | string | 2 values: FW (1,934), KC (1) |
| SOURCE | string | 2 values: P (1,905), D (30) |
| OWNERSHIP | string | 2 values: PUB (1,917), PRI (17) |
| SOURCECOV | string | 2 values: S (1,907), R (8) |
| CLOSED | integer | |
| STTYPE | string | 3 values: LOCAL (645), MAJOR (387), COLLECTOR (1) |
| CONTROL | integer | 0 to 7,539 |
| PREFIX | string | 2 values: SW (530), S (390) |
| STREETNAME | string | |
| STREETTYPE | string | 10 values: AVE (782), ST (717), PL (358)… |
| SUFFIX | string | 2 values: SW (607), S (422) |
| PMSID2 | integer | 0 to 166,500,020 |
| MODIFIED | string | 5 values: Y (227), Z (43), EE (15)… |
| SPEEDLIM | integer | 0 to 40 |
| CLASSCODE | string | 3 values: C (37), M (32), P (16) |
| JR2 | string | 1 values: FW (1,024) |
| ONSTR__ | number | 0 to 5,410 |
| SQ_NUM_ | number | 0 to 180 |
| STREET | string | |
| FROM_ | string | |
| TO_ | string | |
| YEAR_ | integer | 1,995 to 2,022 |
| PMSID | integer | 0 to 166,500,020 |