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

Open Drains

Stormwater open drains, ditches

Records
195
Formats
5
Last updated
Aug 12, 2020

Download & API

Open Drains (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Open Drains (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Open Drains (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Open Drains (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 ID
FACILITYID
string
Install Date
INSTALLDATE
datetime
Top Width
TOPWIDTH
number
Bottom Width
BOTWIDTH
number
Depth
DEPTH
number
Bed Material
BEDMATERIAL
string
Side Material
SIDEMATERIAL
string
Left Slope
LEFTSLOPE
number
Right Slope
RIGHTSLOPE
number
Uptop
UPTOP
number
Down Top
DWNTOP
number
SYSTEMnumber0.00 to 84.00
DISCHARGEstring
NOTESstring5 values: N/A (143), SECONDARY DISCHARGE (5), 15LF DISPERSAL TRENCH (1)…
MaintNotes
MAINTNOTES
string
Maint_Need
MAINTNEED
string2 values: Private (29), Public (7)
Owned By
OWNEDBY
string
Managed By
MAINTBY
string2 values: Private (29), Public (7)
Owner Name
OWNERNAME
string
Asbuilt Link
ASBUILTLINK
string
Easement Link
EASEMENTLINK
string
Other Link
OTHERLINK
string
Creator
CREATOR
string1 values: angela.gallardo (195)
CreationDate
CREATIONDATE
datetime
Active Flag
ACTIVEFLAG
integer
Last Update Date
LASTUPDATE
datetime
Last Editor
LASTEDITOR
string2 values: GIS Synchronizer (193), angela.gallardo (2)
Water Quality
WATERQUAL
string
CreationDate
CreationDate_1
datetime
Creator
Creator_1
string1 values: audrie.starsy (195)
EditDatedatetime
Editorstring2 values: jeffbrauns (193), audrie.starsy (2)
FieldVerifiedstring
OwnershipVerifieddatetime