Samples are taken daily at locations throughout the distribution system. Temperature, pH, and Total Chlorine Residual are collected by city personnel. Samples are taken to a lab to be analyzed for Total Coliform and E. Coli indicators. Results are returned to the city the following business day.
This dataset has the following 9 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| DATE | date | calendar_date | Date test was conducted. | 2023-05-22T00:00:00.000 2024-05-29T00:00:00.000 2023-11-28T00:00:00.000 2021-11-18T00:00:00.000 2021-11-10T00:00:00.000 view top 100 |
| SITE # | site | text | Unique identifier for the bacteria sample site. | 108 15 104 64 38 view top 100 |
| Street | street | text | Street name for where water sample was collected. | Louis Dr Ridgehaven Dr Hunters Creek Dr Whitehaven Dr Chadbourne Dr view top 100 |
| Total Chlorine Residual | total_chlorine_residual | number | The level of chlorine disinfectant by measuring chloramines (minimum requirement is .5 mg/L). Instruments have an accuracy of plus or minus 0.1 mg/L. | 2.6 2.8 2.5 2.7 3 view top 100 |
| Free Chlorine | free_chlorine | number | The amount of free chlorine as measured in mg/L. This number increases in Feb/Mar during the chlorine maintenance period. Instruments have an accuracy of plus or minus 0.1 mg/L. | 0 2.5 2.4 2.6 2.3 view top 100 |
| Sample Type | replacement_sample | text | Bacteria Samples are routine and collected every 30 days. If a sample has an error, is rejected, or has bacteria present, a replacement sample is taken. This column indicates if the sample is a replacement. Special Samples are locations that are not normally sampled. Refer to the notes section to determine why sample was taken. | Routine Bacteria Sample Special Sample Replacement Sample Repeat Sample view top 100 |
| RESULTS | results | text | Provides results from the laboratory to indicate pass, fail, or if sample was rejected. | PASSED HEAVY BACTERIA TOTAL COLIFORM REJECTED CRACKED BOTTLE view top 100 |
| Replacement Address/Notes | replacement_address_or_notes | text | Indicates the location of replacement samples, special samples, or any notes associated with the sample. | Error in free chlorine test. LAB Â ERROR INCUBATOR OUTAGE 4813 Nocona SPECIAL- 6405 DODGE CT Special Sample - 3399 P Avenue view top 100 |
| Number of Samples Taken | number_of_samples_taken | number | Number of samples taken at the location. | 1 view top 100 |