SGMA Technical Support Services and Prop 1 Stressed Basin Grant Project
Location:Glenn and Colusa Counties, CA
Date:2017 - 2018
Davids Engineering has served as an information system specialist in support of Colusa County’s SGMA compliance efforts to date. The focus has been on development of a Data Management System (DMS) with integrated quality control and assurance routines for various data types including: stream flow, diversions, water quality, subsidence, well logs, and groundwater levels. The DMS is developed as an Access database. Automation of the data importation process is implemented utilizing Visual Basic code. The DMS provides input files to support groundwater modeling efforts and formatted data tables to support GSP development and implementation. In addition, a semi-automated water budget database for Glenn County was developed. The database links directly to output from an IDC model to complete the water budgets for agricultural, urban, and native lands. Completed water budgets are exported from the database to Excel spreadsheets for graphical review and tabular summaries.