Fire Hydrants
Fire Hydrants, City of Newton, Massachusetts
- Records
- 2,711
- Formats
- 5
- Last updated
- Jun 13, 2025
Download & API
Fire Hydrants (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Fire Hydrants (GeoJSON)geojson
GeoJSON — for web maps and GIS tools
Fire Hydrants (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Fire Hydrants (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 |
|---|---|---|
| facilityid | string | |
| hyd_type | string | 4 values: 5.5 (1,506), 6.0 (31), 6.0 MJ (3)… |
| locdesc | string | |
| ownedby | string | 2 values: Town (2,140), Private (39) |
| legacy_id | string | |
| manufactur | string | |
| model_no | string | |
| year | string | |
| hyd_sect | string | 5 values: 3 (58), 4 (40), 0 (3)… |
| press_zone | string | 5 values: UNK (1,189), Northern (41), Chestnut Hill (3)… |
| staticpres | string | |
| mainsize | string | |
| bury | string | 4 values: Unknown (1,349), 5 (468), 5.5 (273)… |
| vo_size | string | 5 values: 5.25 (2,038), 5 (50), Unknown (38)… |
| extension | string | 4 values: None (1,494), 12 (52), 6 (47)… |
| dist_main | string | |
| cap_color | string | 2 values: Red (1,878), Other (786) |
| body_color | string | 2 values: Red (2,612), Other (52) |
| val_offset | string | |
| installdat | datetime | |
| maintby | string | 2 values: Town (2,082), Private (24) |
| plans | string | |
| comments | string | |
| lastupdate | datetime | |
| lasteditor | string | |
| elevation | string | 2 values: 0 (10), 14.008582887437342 (1) |
| map_date | datetime | |
| mapped_by | string | 3 values: Town (832), Other (150), Consultant (60) |
| map_by_ot | string | |
| map_method | string | 5 values: Aerial Photo (374), QA Tablet (123), Tablet (101)… |
| map_met_ot | string | |
| map_status | string | 2 values: Draft (958), Final (51) |
| rotation | string | |
| flow | string | |
| activeflag | string | 2 values: 0 (1,852), 1 (377) |
| enabled | string | 2 values: 1 (143), 0 (40) |
| operable | string | 2 values: 1 (2,042), 0 (185) |
| anclryrole | string | 1 values: 0 (141) |
| is_hyd | string | 2 values: 1 (1,685), 0 (542) |
| hyd_f_stat | string | 4 values: Not Flushing (35), Flushing (6), Skipped (2)… |
| flushlabel | string | |
| division | string | 1 values: WATER (2,711) |
| asset | string | 1 values: Water (2,711) |