Laserfiche WebLink
Water Supply Reserve Account – Grant Application Form <br />Form Revised May 2007 <br />_______________________________________ <br /> <br /> <br />The Proposed Scope of Work <br />I. <br /> <br />Task 1 – Creation of a web accessible Common Data Repository: $121,000 <br />This task includes a thorough search of available water quality information in the basin. This will include <br />surface and ground water data from local, State and Federal agencies, consulting firms, water and sanitation <br />districts water conservancy districts, and other industrial users as available. <br /> <br />? <br />Creation of a water-quality database <br /> Description of task: Two primary components to this task: and then <br />development of the publicly-accessible interactive website that will provide query and retrieval access <br />to the database <br />. Contact water-quality data sources to obtain electronically available water-quality data for <br />compilation and incorporation into the planned relational database and interactive website. At least 15 <br />public, private, and non-profit entities are expected to be contacted for submittal of data for the project. After <br />the relational water-quality database is constructed and quality assured, a website interface will be developed <br />using existing methods that have been successful for other watersheds. (for an example of the web site <br />interface that will be copied see http://co.water.usgs.gov/cf/eaglecf/dataretriever.cfm) <br /> <br />? <br /> Methods: USGS personnel will complete the task following systematic methods developed for similar <br />projects. Methods include a variety of data manipulation tasks to reformat provided data into a common <br />format. Data will be screened and merged from widely variable formats into a single reporting format. <br />Routines to streamline future data updates will be developed and shared with the various data sources to <br />simplify updates to the common data repository on a semi-annual or annual basis as needed. Monitoring sites <br />and water-quality parameters will be redefined and recomputed to reduce the database content to the <br />minimum required number of sampling locations and water-quality parameters, minimize duplication. This <br />reduction will yield a concise database that will provide users with data that is immediately useable with a <br />minimum of required data synthesis tasks. <br /> <br />? <br /> Major deliverable: A web-accessible water-quality data repository. Users will be able to view and select and <br />download monitoring locations and historical water-quality monitoring data through interactive selection and <br />filtering criteria that are fully customizable by individual users. (for an example of the website interface that <br />will be used as the template for this deliverable please see <br />http://co.water.usgs.gov/cf/eaglecf/dataretriever.cfm) <br /> <br /> <br /> <br /> <br /> <br />8 <br /> <br />