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

GSI

GSI

Records
30
Formats
5
Last updated
Aug 12, 2020

Download & API

GSI (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
GSI (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
GSI (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
GSI (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
Facility Identifier
FACILITYID
string
Install Date
INSTALLDATE
datetime
Type
TYPE
string3 values: Bioswale (28), Porous Pavement (1), Rain Garden (1)
Diameter
DIAMETER
number
Length
LENGTH
number
Width
WIDTH
number
Depth
DEPTH
number
Slope
SIDESLOPE
number
Volume
VOLUME
number
Bed Material
BEDMATERIAL
string1 values: EAR (3)
Bank Material
BNKMATERIAL
string1 values: EAR (3)
Invert Elevation
INVERTELEV
number
Outflow Elevation
OUTFLWELEV
number
Location Description
LOCDESC
string
NOTESstring8 values: Joshua Green Corp (2), Coal Creek Parkway Phase II (1), Parking Lot Lake Boren (1)…
Development Name
DEVLPNAME
string10 values: OTHER (9), UNKNOWN (9), Shops at Newcastle (3)…
MaintNotes
MAINTNOTES
string
Maint_Need
MAINTNEED
string
Owned By
OWNEDBY
string3 values: Private (23), Public (6), Pubic (1)
Managed By
MAINTBY
string1 values: Private (3)
Owner Name
OWNERNAME
string
Asbuilt Link
ASBUILTLINK
string
Easement Link
EASEMENTLINK
string
Other Link
OTHERLINK
string
Creator
CREATOR
string1 values: Audrie Starsy (3)
CreationDate
CREATIONDATE
datetime
Active Flag
ACTIVEFLAG
integer
Last Update Date
LASTUPDATE
datetime
Last Editor
LASTEDITOR
string
Water Quality
WATERQUAL
string1 values: Yes (3)
CreationDate
CreationDate_1
datetime
Creator
Creator_1
string2 values: audrie.starsy (22), Audrie Starsy (8)
EditDatedatetime
Editorstring2 values: audrie.starsy (26), jeffbrauns (1)
Field Verification
FieldVerified
string1 values: Yes (3)
Ownership Verified
OwnershipVerified
datetime