Streets
STREETS IN THE CITY OF FEDERAL WAY
- Records
- 8,973
- Formats
- 5
- Last updated
- Feb 9, 2023
Download & API
streets (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
streets (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
streets (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
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 |
|---|---|---|
| STREETS_ID | integer | 0 to 50,670 |
| STREETID | number | 1 to 50,670 |
| STNAME | string | |
| CLASS_OLD | string | 5 values: MINOR (205), PRINCIPAL (150), COLLECTOR (122)… |
| SMALL | integer | 0 to 2,465 |
| STN | integer | 0 to 9,999 |
| SGN | integer | 0 to 380 |
| CLASS_NEW | string | 6 values: LOCAL (6,221), MINOR COLLECTOR (1,280), MINOR ARTERIAL (457)… |
| DIR | string | 8 values: SW (2,175), S (1,612), N (67)… |
| RIGHTADDFR | integer | 0 to 227,601 |
| RIGHTADDTO | integer | 0 to 51,098 |
| LEFTADDFR | integer | 0 to 57,010 |
| LEFTADDTO | integer | 0 to 50,298 |
| JR | string | |
| SOURCE | string | 6 values: P (3,811), D (2,542), K (265)… |
| OWNERSHIP | string | 2 values: PUB (7,916), PRI (678) |
| SOURCECOV | string | 4 values: S (4,037), R (1,663), D (15)… |
| CLOSED | integer | |
| STTYPE | string | 6 values: LOCAL (5,409), MAJOR (737), FREEWAY (193)… |
| DIRT | integer | 0 to 1 |
| FLAG | integer | 0 to 9 |
| EXISTS_ | integer | 0 to 1 |
| HWYID | integer | 0 to 516 |
| CONTROL | integer | 0 to 41,352 |
| PREFIX | string | 6 values: S (1,940), SW (1,075), E (65)… |
| STREETNAME | string | |
| STREETTYPE | string | |
| SUFFIX | string | 8 values: S (2,346), SW (1,130), NE (761)… |
| PMSID2 | integer | 0 to 999,900,000 |
| MODIFIED | string | 10 values: Z (516), SC (492), Y (488)… |
| SPEEDLIM | integer | 0 to 60 |
| CITYLEFT | string | |
| CITYRIGHT | string | |
| ZIPLEFT | string | |
| ZIPRIGHT | string | |
| CLASSCODE | string | 4 values: C (191), P (138), M (101)… |
| JR2 | string | |
| CONTRACT | string | 7 values: RESIDENT (2,309), COLLECT (609), MAJORART (203)… |
| PAA_CLASS | string | 7 values: MINOR COLLECTOR (146), MINOR ARTERIAL (107), PRINCIPAL COLLECTOR (85)… |
| STTYPE2 | string | 5 values: LOCAL (7,228), ARTERIAL (977), COLLECTOR (383)… |
| MOWED | string | 3 values: Y (512), N (32), 0 (25) |
| PMSID | integer | 0 to 999,900,000 |
| pmsidt | string | |
| ALPHANAME | string | |
| FIRSTLET | string | |
| CODEX | string | |
| CODEX2 | string | |
| SIMPNAME | string | |
| PLAT_LENGTH | number | 0 to 5,135 |
| c2 | integer | 0 to 8,782 |
| clen | number | 0 to 11,913 |
| c_code | string | |
| EXEMPT | string | 3 values: N (3,147), Y (1,629), 0 (1) |
| LUD_CLASS | integer | 0 to 5 |
PMS Classifications PMS_CLASS | integer | 0 to 5 |
| Shape.len | number | 0 to 12,669 |
STREET SEGMENT ID ENTITYUID | string | |
A textual description of the location of the feature or address of the asset 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 | |
Average Daily Traffic ADT | string |