Laserfiche WebLink
3.2 Database Quality Control <br />A series of quality control steps were undertaken to check the accuracy of the data analysis and <br />processing. <br />Numerical data from each of the sources external to HydroBase were initially entered into a <br />Microsoft Excel® spreadsheet. Hand - entered data were then checked for accuracy by comparing <br />100 percent of the entered data to the original hard -copy data. If errors in the data entry were <br />found, the errors were corrected in the spreadsheet. The spreadsheet was then uploaded into a <br />HydroBase- compatible database. <br />4.0 Results <br />The estimated pumping rates for municipal and industrial entities for the period 1950 through <br />2005 are presented in graphical format in Attachment A. Although some entities have more <br />detailed data available, the total annual pumping is shown in these graphs in order to provide a <br />generalized presentation and comparison of the M &I pumping for each entity. The estimated <br />and actual annual pumping rates are depicted by different symbols on each of these graphs. <br />The estimated rates are based on the techniques and methods discussed in Section 2. For <br />entities for which the pumping began partway into the year, the pumping rate is prorated to an <br />equivalent annual rate and appears as a lower rate on the graphs. <br />The annual pumping rates presented in Attachment A show a range of trends over time. Many <br />entities have an increase in pumping over time but other entities show either a downward trend <br />or no trend. Towns on the eastern plains such as Julesburg and Ovid show a decrease in <br />pumping that is directly related to declines in population. Other entities show an increase in <br />pumping over time due to increases in population. These entities include Brighton, Fort <br />Lupton, Morgan County Quality Water Company, Northern Colorado Water Association, South <br />Adams County Water and Sanitation, and Sterling. Declining trends can be observed in <br />Julesburg and in Aurora; the analysis for Aurora indicates that it has relied less heavily on <br />alluvial groundwater with time as surface water sources became more available. Thornton and <br />Englewood exhibit a stair -step pattern with time on their pumping graphs in Attachment A. <br />This pattern is due to the different times that the wells came on -line. <br />No trends were apparent for the other entities. <br />A HydroBase- compatible electronic database of monthly pumping results for each well for each <br />entity will be provided to the State. The database has the contents and format as described in <br />Section 3. <br />5.0 Summary and Conclusions <br />CDM has completed SPDSS Tasks 30 and 41, the collection of historic pumping data and the <br />filling of missing records from M &I entities that pump more than 1000 gpm from the alluvial <br />aquifer system of the South Platte Alluvium Region. This report describes the process used to <br />SPDSS Phase 3 Task 41 TM -Final <br />02/08/2007 <br />13 <br />