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
Open Drains (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Open Drains (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Open Drains (map tiles)pmtiles
Vector tiles — embed in a map
Live ArcGIS layer (source)arcgis
Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works
Schema
| Field | Type | Values |
|---|---|---|
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 | |
| SYSTEM | number | 0.00 to 84.00 |
| DISCHARGE | string | |
| NOTES | string | 5 values: N/A (143), SECONDARY DISCHARGE (5), 15LF DISPERSAL TRENCH (1)… |
MaintNotes MAINTNOTES | string | |
Maint_Need MAINTNEED | string | 2 values: Private (29), Public (7) |
Owned By OWNEDBY | string | |
Managed By MAINTBY | string | 2 values: Private (29), Public (7) |
Owner Name OWNERNAME | string | |
Asbuilt Link ASBUILTLINK | string | |
Easement Link EASEMENTLINK | string | |
Other Link OTHERLINK | string | |
Creator CREATOR | string | 1 values: angela.gallardo (195) |
CreationDate CREATIONDATE | datetime | |
Active Flag ACTIVEFLAG | integer | |
Last Update Date LASTUPDATE | datetime | |
Last Editor LASTEDITOR | string | 2 values: GIS Synchronizer (193), angela.gallardo (2) |
Water Quality WATERQUAL | string | |
CreationDate CreationDate_1 | datetime | |
Creator Creator_1 | string | 1 values: audrie.starsy (195) |
| EditDate | datetime | |
| Editor | string | 2 values: jeffbrauns (193), audrie.starsy (2) |
| FieldVerified | string | |
| OwnershipVerified | datetime |
