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 |