Laserfiche WebLink
Appendix A: Instructions to Query Picks from HydroBase for Contouring the Denver Basin <br />Bedrock Aquifer Surfaces <br />iii. Query 3 <br />1. KAUS > 0 or KALS>0 (1453 records) <br />2. Remove where KAUB > 0 and KALB >0 and KAUB <> KALB (914 <br />Records) (These picks would represent divided sand picks) <br />3. Use KAUS and KALS picks <br />C. Dawson Picks <br />1. In Access database, Wells and Geophlogs tables were linked up in a query. Selected fields were <br />chosen from the Wells table (location information) and all fields were chosen from the Geophlogs <br />table. The table was exported to Excel. <br />e. TDWB <br />i. TDWB= Picks were filtered in Excel where "Aquifer'' _ 'LTDW' or 'TDW' and <br />"Glogbase° > 0. If TDWLB disagreed with TDWB then both picks were <br />excluded. (It is assumed that all picks stored as TDWUB representing the TDWB <br />surface are duplicated in TDWLB) <br />2. In Access the Geophlogs table was pivoted from a many record per Well ID to a one record per <br />Well ID table format by using update queries. X, Y values were added to the pivot table from the <br />Wells table. This allowed all picks for a single log to be evaluated in the same row. The pivoted <br />table was imported into ArcGIS and converted to a shapefile to filter picks. <br />f. TDWT: <br />i. Query 1 <br />1. Select TDWLT >0 <br />2. Remove all picks outside of northern Lower Dawson region <br />3. Remove where TDWUB > 0 (These picks indicate aquifer still divided) <br />4. Use remaining TDWLT picks (12 records) <br />ii. Query 2 <br />1. Select TDWT >0 or TDWUT >0 (53 records) <br />2. Exclude if both not null and not equal <br />g. TDWUB: <br />i. Select TDWUB > 0 and located within and up to 3 miles outside of the Divided <br />Dawson boundary <br />ii. Remove picks where TDWUB =TDWLB (277 records) (These picks would <br />represent TDWB) <br />iii. Use remaining TDWUB picks <br />h. TDWLT <br />i. Select TDWLT >0 and located within and up to 3 miles outside of the Divided <br />Dawson boundary (347 records) <br />ii. Use remaining TDWLT picks <br />i. TDWUS <br />i. Select TDWUS >0 and located within and up to 3 miles outside of the Divided <br />Dawson boundary (137 records) <br />SPDSS Phase 2 Task 42.2 TM -Final A-3 <br />2/13/06 <br />