Proof of concept.This is an unofficial demo built by Datopian from the City of Newcastle, Washington's public data. The official portal is data-newcastlewa.opendata.arcgis.com. Questions or feedback: hello@datopian.com

Streetlights PSE

GIS data for the City of Newcastle

Records
178
Formats
5
Last updated
Mar 26, 2019

Download & API

Streetlights PSE (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Streetlights PSE (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Streetlights PSE (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Streetlights PSE (map tiles)pmtiles
Vector tiles — embed in a map
Download
Live ArcGIS layer (source)arcgis
Download

Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works

Schema

FieldTypeValues
OBJECTID_1integer1 to 178
Equipment_number10,792,381 to 14,298,662
Account_Nunumber
Account_Nastring1 values: CITY OF NEWCASTLE (178)
Citystring2 values: NEWCASTLE (177), NEW CASTLE (1)
Locationstring
Grid_Numbestring
Tag_IDstring
Luminairestring8 values: CF - Cobra-Flat (97), CD - Cobra-Drop (25), LED (12)…
Schedulestring4 values: 52E-HPS (77), 53E-HPS (65), 53E-LED (19)…
Wattagenumber0 to 400
Ownerstring2 values: P (157), C (9)
Install_Dadatetime
Longitudenumber-122 to -122
Latitudenumber47.52 to 47.55
Umapstring