Street Lights
Street lights in Federal Way.
- Records
- 4,525
- Formats
- 5
- Last updated
- Feb 21, 2023
Download & API
street lights (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
street lights (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
street lights (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
street lights (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 |
|---|---|---|
AREA FW_Land.DBO.street_lights.AREA | number | |
| PERIMETER | number | |
| STRLIGHT_ | integer | 0 to 6,430 |
| STRLIGHT_ID | integer | 0 to 3,054 |
| POLEID | string | |
| TWNRNG | integer | 0 to 2,204 |
| ORDINAL | string | 2 values: E (3,011), 0 (23) |
| MAPNUM | integer | 0 to 136 |
| GRIDN | integer | 0 to 313,678 |
| GRIDE | integer | 0 to 165,457 |
| ACCOUNTNUM | number | 0 to 90,037,663,001 |
| ACCOUNTNAM | string | 2 values: FEDERAL WAY (2,262), LAKEHAVEN (2,243) |
| OWNER | string | 2 values: P (2,764), C (1,741) |
| LAMP_TYPE | string | 3 values: SV (2,937), HP (87), LE (30) |
| LAMP_SIZE | integer | 0 to 400 |
| POLE_TYPE | string | 8 values: W (1,090), CO (1,009), AL (675)… |
| ENERGIZED | integer | 0 to 122,283 |
| POLYGONID | integer | |
| SCALE | number | 0.00 to 1.00 |
| ANGLE | number | |
Date Updated UPDATE_ | datetime | |
Updated By USER_ | string | 3 values: EEE (643), EE (75), SC (32) |
YEAR POLE_YEAR | integer | 1,977 to 2,016 |
| Stlight_ID | string | |
| Schedule | string | 3 values: 53E (2,559), 54E (74), 0 (3) |
| AttTransfer | string | 2 values: YES (31), 0 (3) |
| CHK | string | 2 values: YES (4), 0 (3) |