Laserfiche WebLink
Appendix A: Instructions to Query Water Levels from HydroBase for Contouring the <br />Denver Basin Bedrock Aquifer Water Level Surfaces <br />a. DSSAquiferl= "UTDW" OR DSSAquiferl= "LTDW" AND DSSAquifer2 = Is Null AND <br />SPDSS_REG = "SPDSS" AND Year(meas_date) =1968 and Month(meas_date) = 2 OR <br />Month(meas_date) = 3 OR Month(meas_date) = 4 <br />Denver Aquifer <br />a. DSSAquiferl = "TKIY' AND DSSAquifer2 = Is Null AND SPDSS_REG = "SPDSS" AND <br />Year(meas_date) = 1968 and Month(meas_date) = 2 OR Month(meas_date) = 3 OR <br />Month(meas_date) = 4 <br />Upper Arapahoe Aquifer <br />a. DSSAquiferl = "UKA" AND DSSAquifer2 = Is Null AND SPDSS_REG = "SPDSS" AND <br />Year(meas_date) = 1968 and Month(meas_date) = 2 OR Month(meas_date) = 3 OR <br />Month(meas_date) = 4 <br />Arapahoe Aquifer <br />a. DSSAquiferl= "KA" OR DSSAquiferl= "LKA" AND DSSAquifer2 = Is Null AND <br />SPDSS_REG = "SPDSS" AND Year(meas_date) =1968 and Month(meas_date) = 2 OR <br />Month(meas_date) = 3 OR Month(meas_date) = 4 <br />Laramie-Fox Hills Aquifer <br />a. DSSAquiferl = "KLF" AND DSSAquifer2 = Is Null AND SPDSS_REG = "SPDSS" AND <br />Year(meas_date) = 1968 and Month(meas_date) = 2 OR Month(meas_date) = 3 OR <br />Month(meas_date) = 4 <br />The query results were exported to Excel. <br />5) In Excel, the first spring water level measurement in a given year was identified and included in the <br />dataset used for contouring. <br />6) Steps 4 and 5 were repeated for all time periods (1968,1978,1990, 2001, 2003 and 2005). For year 2005, <br />the Month(meas_date) was allowed to also include 5 because the DWR conducted their spring <br />measurements in May of 2005. <br />SPDSS Phase 3 Task 44.2 TM -Final A-2 <br />11/28/06 <br />