Delta LTMS Sediment Quality Database Scope of Work

 

The goal of this task is to develop and document a database on sediment quality and populate it with data from the San Francisco Bay Delta. The database will be used for characterizing sediments in areas planned for dredging to assess quality and aid in selecting appropriate management approaches. Example management approaches include selection of potential material suitable for wetland creation, rehabilitation, and restoration; levee maintenance; and other dredge material beneficial re-use schemes. That database should also have the potential to support other possible purposes as well, including, but not limited to applied research.

 

Database preparation will make use of: (1) data from the Corps which contains information prior to 2001 from Sacramento District which has already been compiled; (2) data the contractor is in possession of for related projects; and (3) other sources. Efforts should be focused on quality assurance of the existing pre-2001 data as well as compiling post-2001 data not already in the database. The work will incorporate the Delta Dredging and Reuse (DDRS) database compiled by California Department of Fish and Game (CDFG) in 2002. The work will also be coordinated with the State's Sediment Quality Objectives (SQO) project conducted by the State Water Resources Control Board (SWRCB) to the extent possible, and related efforts conducted by the Central Valley Regional Water Quality Control Board (CVRWQCB), and other possible partners to be identified at a later time, to optimize these efforts and provide cost sharing efficiencies.

 

Data from the various sources may be in a variety of digital and hard copy formats. The type of data used should include sediment contamination, toxicity, benthic fauna, fish and tissue data as well as other incidentally collected water quality (dissolved oxygen, temperature at the time of data collections) or other data that may aid in understanding sediment quality and toxicity issues. The database documentation will include a description of the elements in the database and an evaluation of its contents will also be provided.

 

Documentation should answer questions such as:

 

 

While the format of the database is dependent in large part on the discretion of the contractor, it should be easily transferable to other database types and formats, including those that can be used across a web interface and easily convertible to GIS format with measurements as attributes. Further, the database should be structured such that new data may be added in a relatively straightforward manner. The database should be easily usable by a broad range of stakeholders, including the Corps, other Federal, State, and local agencies as well as non-governmental concerns. It is anticipated that in the future, data should be available in a web-based format requiring no specialized programs and/or cost for the typical end-user. Determining such structure will be an important part of the task and should be accomplished in part with input from the Corps.

 

Because the quantity and quality of data available are not clearly known, a first priority will involve documenting data sources. It is realized that the product to be produced is one which will be complete and usable as delivered, but may of necessity document steps required to incorporate data which could not be completely addressed due to logistic difficulties.

 

The contractor retained for completing this task is Peggy Myre of Exa Data and Mapping Services, located in Washington.  Peggy’s contact info is:

 

Peggy L. Myre

Exa Data & Mapping Services, Incorporated

P.O. Box 232

Port Townsend, WA 98368

(360) 379-9003 (ph); (360) 379-9330 (fax)

peggy@exadata.net

www.exadata.net