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

WQ Detention

WQ Detention

Records
167
Formats
5
Last updated
Aug 12, 2020

Download & API

WQ Detention (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
WQ Detention (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
WQ Detention (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
WQ Detention (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
string5 values: Pond (52), Vault (51), Tank (50)…
Subtype
SUBTYPE
string
Location Description
LOCDESC
string
NGPEstring3 values: yes (8), no (5), False (3)
SURF_AREAnumber0 to 35,837
VOLUMEnumber0 to 398,100
Length
LENGTH
number0 to 190
Width
WIDTH
number0.00 to 96.00
Depth
DEPTH
number0.00 to 58.00
Slope
SIDESLOPE
number
Bed Material
BEDMATERIAL
string3 values: CMP (6), EAR (3), EARGEO (1)
Bank Material
BNKMATERIAL
string1 values: EAR (4)
Invert Elevation
INVERTELEV
number0 to 396
Outflow Elevation
OUTFLWELEV
number0 to 488
STREET_ADDstring
Development Name
DEVLPNAME
string
Maint_Need
MAINTNEED
string2 values: Private (36), Public (6)
Owned By
OWNEDBY
string4 values: Public (72), Private (44), Unknown (44)…
Asbuilt Link
ASBUILTLINK
string
Easement Link
EASEMENTLINK
string
Other Link
OTHERLINK
string
Water Quality
WATERQUAL
string1 values: Yes (5)
Creator
CREATOR
string
CreationDate
CREATIONDATE
datetime
Active Flag
ACTIVEFLAG
integer
Last Update Date
LASTUPDATE
datetime
Last Editor
LASTEDITOR
string2 values: GIS Synchronizer (147), ZachT (2)
DISCHARGEstring
CreationDate
CreationDate_1
datetime
Creator
Creator_1
string4 values: audrie.starsy (151), Audrie Starsy (12), FLO Analytics (2)…
EditDatedatetime
Editorstring4 values: jeffbrauns (149), FLO Analytics (2), audrie.starsy (2)…
Field Verification
FieldVerified
string1 values: Yes (12)
Ownership Verified
OwnershipVerified
datetime