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

Manholes

Manholes

Records
94
Formats
5
Last updated
Aug 12, 2020

Download & API

Manholes (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Manholes (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Download
Manholes (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
Manholes (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
Manhole Type
MHTYPE
string6 values: SDMH (39), Flow Restrictor (14), Overflow Structure (7)…
Rim Elevation
RIMELEV
number0 to 770
OVERFLOWnumber0 to 767
SYSTEMnumber0.00 to 84.00
DISCHARGEstring
SIZEinteger-1 to 72
Owned By
OWNEDBY
string1 values: <Null> (94)
Owner Name
OWNERNAME
string
Asbuilt Link
ASBUILTLINK
string
Easement Link
EASEMENTLINK
string
Other Link
OTHERLINK
string
Creator
CREATOR
string1 values: angela.gallardo (69)
CreationDate
CREATIONDATE
datetime
Active Flag
ACTIVEFLAG
integer
Last Update Date
LASTUPDATE
datetime
Last Editor
LASTEDITOR
string3 values: audries (68), GIS Synchronizer (25), angela.gallardo (1)
Water Quality
WATERQUAL
string
VDATUMstring2 values: NAVD88 (56), UNKNOWN (13)
CreationDate
CreationDate_1
datetime
Creator
Creator_1
string1 values: audrie.starsy (94)
EditDatedatetime
Editorstring2 values: jeffbrauns (93), audrie.starsy (1)
FieldVerifiedstring
OwnershipVerifieddatetime