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

swGravityMain

Gravity Main

Records
4,429
Formats
5
Last updated
Aug 12, 2020

Download & API

swGravityMain (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
swGravityMain (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
swGravityMain (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
swGravityMain (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
Pipe Type
PIPETYPE
string12 values: Storm Pipe (4,000), Outfall (162), Culvert (81)…
Diameter
DIAMETER
number-1.00 to 72.00
Main Shape
MAINSHAPE
string1 values: Circular (23)
Upstream Elevation
UPELEV
number0 to 8,370
Downstream Elevation
DOWNELEV
number0 to 955
From Manhole
FROMMH
string
To Manhole
TOMH
string
Slope
SLOPE
number-2 to 246
LENGTH_LFnumber0 to 728
SYSTEMnumber0.00 to 84.00
DISCHARGEstring
FlowDirection
FLOWDIRECTION
string10 values: <Null> (2,267), South (412), West (374)…
Year Lined
LINEDYEAR
string
Liner Type
LINERTYPE
string
Owned By
OWNEDBY
string4 values: City of Newcastle (2,846), Private (1,254), UNKNOWN (165)…
Managed By
MAINTBY
string3 values: City of Newcastle (2,846), Private (1,245), UNKNOWN (165)
Creator
CREATOR
string3 values: angela.gallardo (3,476), FLO Analytics (157), Audrie Starsy (11)
CreationDate
CREATIONDATE
datetime
Active Flag
ACTIVEFLAG
integer0 to 1
Last Update Date
LASTUPDATE
datetime
Last Editor
LASTEDITOR
string8 values: audries (2,214), GIS Synchronizer (1,868), FLO Analytics (157)…
VDATUMstring2 values: UNKNOWN (2,058), NAVD88 (1,412)
Materialstring
Field Verification
FieldVerified
string1 values: Yes (8)
OwnershipVerifieddatetime
Development_Namestring