Fire Hydrants
This map is the starting point for creating maps and projects for the City of El Paso de Robles .
- Records
- 2,210
- Formats
- 5
- Last updated
- Jan 23, 2024
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 |
|---|---|---|
| ActivityID | string | |
| LastActivity | string | 7 values: UPDT (1,524), INST (33), ABAN (28)… |
| OpDate | datetime | |
| OpTime | string | |
| OperatedBy | string | |
| ComputerName | string | |
| Owner | string | 3 values: CITY (1,762), PRIVATE (424), COUNTY (24) |
| LifeCycleStatus | string | 3 values: ACT (400), RMVD (20), ABAN (1) |
| HydrantID | string | |
| OperationalStatus | string | 4 values: OK (137), INOP (3), ABAN (1)… |
| BarrelType | string | 4 values: D (1,387), W (131), DD (2)… |
| Manufacturer | string | 12 values: MUEL (1,021), WATR (291), CLOW (128)… |
| IsolationValve | string | 2 values: Y (1,491), N (14) |
| Model | string | |
| ModelYear | integer | 0 to 19,886 |
| Ports | integer | 0 to 4 |
| FlowGPM | integer | 0 to 1,894 |
| FlowBaseline | integer | 0 to 2,461 |
| StaticPSI | integer | 0 to 129 |
| ResidualPSI | integer | 0 to 114 |
| Pitot | integer | 0 to 70 |
| OutletSize | number | 2.50 to 4.50 |
| FlowDuration | integer | 0 to 1,519 |
| GallonsUsed | integer | 0 to 5,682 |
| OperationComments | string | |
| LocationDetails | string | |
| BarrelSize | number | 0.00 to 6.00 |
| HYD_TYPE | string | 6 values: STANDARD (1,135), OUTSIDE (21), PRIVATE (11)… |
| NOTES | string | |
| DirtyWater | string | 2 values: N (59), Y (1) |
| Frequency | string | 2 values: 12Mo (51), 6Mo (2) |
| FlushDate | datetime | |
| RawWater | string | 3 values: No (1,854), N (54), Y (1) |
| Lat | number | 0.00 to 35.68 |
| Long | number | -120.70 to 0.00 |
| Coefficent | number | 0.71 to 1.00 |