MainBreaksBClear2013-Present.csv
Water main break information from 2013 to current.
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Timestamp | timestamp | ||
| Email Address | text | ||
| What happened? | text | ||
| If strike, who is responsible? | text | ||
| Date Reported | timestamp | ||
| Date Repaired | timestamp | ||
| Time Repair Started | text | ||
| Time Repair Completed | text | ||
| Address | text | ||
| Pressure Zone | text | ||
| Direction of Flow | text | ||
| Surface Above Pipe | text | ||
| Other Lines in Trench | text | ||
| Existing Bedding | text | ||
| Depth of Pipe | text | ||
| Size of pipe in INCHES (not from GIS) | numeric | ||
| Estimated Water Loss from Break (gallons) | text | ||
| Estimated Water Loss from Flushing (gallons) | numeric | ||
| Total Water Loss (gallons) | text | ||
| Pipe material (not from GIS) | text | ||
| Condition of Main | text | ||
| Type of Joint | text | ||
| Damaged Part | text | ||
| Type of Failure | text | ||
| Number of visible repair clamps present | text | ||
| Method of repair | text | ||
| Pumps utilized in the trench: [2 in] | numeric | ||
| Pumps utilized in the trench: [4in] | numeric | ||
| Pumps utilized in the trench: [6in] | numeric | ||
| Pumps utilized in the trench: [8in] | text | ||
| Which valves were turned or closed? | text | ||
| Were repairs made under full pressure? | text | ||
| Total Chlorine Residual (UPstream from break) | text | ||
| Total Chlorine Residual (DOWNstream from break) | numeric | ||
| Total Chlorine Residual (at break) | text | ||
| Name of Superintendent Supervising break/leak/repair | text | ||
| Any corresponding work order #s | numeric | ||
| Comments | text | ||
| [Document Studio] File Link | text | ||
| [Document Studio] File Status | text | ||
| [Document Studio] Email Status | text | ||
| Lat | numeric | ||
| Long | numeric |
Additional Information
| Field | Value |
|---|---|
| Data last updated | February 26, 2021 |
| Metadata last updated | May 21, 2019 |
| Created | May 21, 2019 |
| Format | text/csv |
| License | Creative Commons Attribution |
| created | over 1 year ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | dab4d37b-24f9-419f-ba6f-567039dd30da |
| last modified | 9 days ago |
| mimetype | text/csv |
| on same domain | True |
| package id | 32d0afd0-a5ed-410f-8fec-4f108647aa4f |
| revision id | f0c4e56e-d938-4295-b0bf-6cf3cdba14bf |
| size | 125 KiB |
| state | active |
| url type | upload |