Blast Documentation Using the Techbase Database Management System at the Eastside Reservoir Project

The Metropolitan Water District of Southern California (MWD) is undertaking one of the nations largest water management projects. The Eastside Reservoir Project is being built to insure a supply of water to Southern California in the event of earthquake damage to the aqueducts supplying the region. An 800,000-acre-ft lake will result from the three dams, closing off the valley between two parallel ridges. The single largest contract of the project, the West Dam, was awarded to the joint venture of Atkinson Construction Co., Washington Construction Co. (Morrison Knudsen Co.), and HB Zachry Co. Over 50 million bank cubic yards of rock must be drilled and shot on this contract alone. AWZ relies on the TechBASE database management system for documenting drilling and blasting. The database format of TechBASE allows all production parameters to be linked to the location of the activity. This allows parameters such as drill penetration or boulder production to be analyzed for geologic trends that can either be exploited or dealt with. Shot locations are stored as 3D polygons in a polygon table. Production and cost data are stored in flat tables. Shot names are unique and link the polygon table to the flat table. This allows typical database queries to be made by date, location, cost or any production parameter. The output from these queries can be presented in table, graph and as map formats. The map output is particularly helpful in quantifying geologic conditions and blast performance. The ability to transform the data into information has been very helpful. The ability to present this information graphically has been invaluable.