Laserfiche WebLink
2.0 Data Analysis <br />This section describes the general methodology and steps used to process the historic pumping <br />data so that a continuous record of pumping could be estimated for each entity. Filling the <br />data records was undertaken in Task 40.1. Data analysis and processing steps included <br />estimating pumping rates, determining the start of pumping, and filling missing records. A <br />detailed description of these processing steps for each pumping entity is provided in Appendix <br />A. <br />2.1 Pumping Rates <br />All data received was converted to acre -feet and monthly time steps. The appropriation <br />(pumping) rate listed on the decrees was in some cases (like Thornton) for individual wells in a <br />well field but in other cases was for the entire well field. The rates were given in cubic feet per <br />second (cfs) in most cases. For Thornton and Parker a rate (cfs) and a total annual volume was <br />provided. In these cases an adjustment factor was needed to account for the discrepancy <br />between the two values provided so that the cfs rates for individual wells equaled the <br />equivalent total annual volume. In cases where a single rate was provided for a well field the <br />rate was distributed evenly among the reported wells. For one entity, Parker Water and <br />SPDSS Phase 3 Task 41 TM -Final <br />02/08/2007 <br />7 <br />Pumping: <br />Period <br />Individual or <br />Pumpage <br />Data <br />of <br />Format of <br />Aggregate <br />Units <br />Source/Entity <br />Record <br />Data <br />Time Period <br />Wells <br />Provided <br />Yearly: <br />1990 -2003 <br />Monthly: <br />2004 -2005 <br />1990 to <br />Scanned <br />Missing: <br />Ovid <br />2005 <br />PDF <br />1995 -1997 <br />One well <br />Gallons <br />Scanned <br />Annual <br />Parker Water and <br />No <br />PDF <br />amount <br />Sanitation District <br />pumping <br />Well permit <br />from <br />(PWSD) <br />records <br />and decree <br />decree <br />One well <br />Acre -feet <br />Public <br />1995 to <br />Electronic <br />Service /Xcel <br />2005 <br />spreadsheet <br />Monthly <br />Individual <br />Acre -feet <br />South Adams <br />County Water and <br />Sanitation District <br />1981 to <br />Electronic <br />Individual and <br />(SACWSD) <br />2005 <br />spreadsheet <br />Monthly <br />aggregate <br />Acre -feet <br />2001 to <br />Electronic <br />Sterling <br />2005 <br />spreadsheet <br />Monthly <br />Individual <br />Acre -feet <br />2004 to <br />Electronic <br />Assume one <br />Swift & Co. <br />2005 <br />1 spreadsheetl <br />Weekly <br />well <br />Gallons <br />1980 to <br />Electronic <br />Aggregate -well <br />Thornton <br />1990 <br />spreadsheet <br />Monthly <br />field <br />Acre -feet <br />2.0 Data Analysis <br />This section describes the general methodology and steps used to process the historic pumping <br />data so that a continuous record of pumping could be estimated for each entity. Filling the <br />data records was undertaken in Task 40.1. Data analysis and processing steps included <br />estimating pumping rates, determining the start of pumping, and filling missing records. A <br />detailed description of these processing steps for each pumping entity is provided in Appendix <br />A. <br />2.1 Pumping Rates <br />All data received was converted to acre -feet and monthly time steps. The appropriation <br />(pumping) rate listed on the decrees was in some cases (like Thornton) for individual wells in a <br />well field but in other cases was for the entire well field. The rates were given in cubic feet per <br />second (cfs) in most cases. For Thornton and Parker a rate (cfs) and a total annual volume was <br />provided. In these cases an adjustment factor was needed to account for the discrepancy <br />between the two values provided so that the cfs rates for individual wells equaled the <br />equivalent total annual volume. In cases where a single rate was provided for a well field the <br />rate was distributed evenly among the reported wells. For one entity, Parker Water and <br />SPDSS Phase 3 Task 41 TM -Final <br />02/08/2007 <br />7 <br />