Laserfiche WebLink
level measurements were converted to elevation above mean sea level and then included in the <br />SPDSS database. The well location and hydrograph of the water level elevation data are <br />reported in the Task 39.4 TM. In Phase 3, four additional bedrock monitoring wells near Castle <br />Rock were instrumented with data loggers. These wells are completed in the Lower Dawson, <br />Denver, Arapahoe and Laramie-Fox Hills Aquifers and water level data will be downloaded <br />from these loggers in future Phases of the SPDSS. <br />Under Task 39.1, autumn water levels were measured during 2005 at 90 wells in the DWR's <br />spring water level monitoring network. The locations of the wells, discussion of water level <br />measurement techniques and results, and hydrographs of the water level elevation data from <br />these SPDSS field data collection efforts are reported in the Task 36.2 and Task 39.4 TM. <br />1.2 Data Analysis and Processing <br />Several processing steps were required to convert the data into a format suitable for input into <br />HydroBase and for subsequent analysis and mapping. These steps are described below. In some <br />of the discussion, there is reference to specific tables and fields contained in HydroBase; these <br />are described in Section 2 of this TM. <br />Aquifer Assi n <br />All measurements were assigned to an aquifer, using the DWR aquifer definitions summarized <br />in the Introduction section above. In all cases, except for the wells installed under Task 36.1 or <br />measured under Task 39.1, there was no attempt to verify the aquifer designation for a well <br />provided by an outside entity. <br />Data obtained from the USGS general database contained a 7-character alphanumeric USGS <br />aquifer code classification, such as '125DNVR'. This USGS aquifer code was correlated to the <br />DWR Denver Basin and alluvial aquifer classifications using an aquifer formation or soil type <br />key provided by the USGS. <br />For the Dawson and Arapahoe Aquifers divided into Upper and Lower designations, additional <br />spatial analysis in ArcGIS had to be performed to determine if a measured well was located in a <br />divided or undivided portion of the aquifer. Wells located outside the divided portions of the <br />aquifers were classified as simply Arapahoe or Dawson. Wells located in the divided portions of <br />the Arapahoe and Dawson Aquifers required further analysis. If enough information was <br />available the well was classified in the upper or lower aquifer respectively but if no information <br />was available the well was classified as being completed in both aquifers and was not included <br />in water level contouring. <br />Of the wells located in the divided portions of the Dawson and Arapahoe Aquifers, a total of 24 <br />wells located in the Dawson and 32 wells located in the Arapahoe could not be distinguished <br />between their upper and lower units. In addition, seven other wells are coded as being screened <br />in multiple aquifers for the selected time periods. The wells completed in multiple aquifers are <br />indicated by coding the Aquiferl and Aquifer2 fields with the appropriate DWR aquifer codes in <br />the WELLS table of HydroBase. None of these 63 multi-aquifer completed wells were used in <br />the contouring. <br />SPDSS Phase 3 Task 44.2 TM -Final <br />11/28/2006 <br />