USGS - science for a changing world
Water Quality of San Francisco Bay
Home | Overview | Data Visualization | Data Query | *Data Citation* | Access | Project Team

There are two different ways to query this database:

Easy Query Button or Expert Query Button
Click on the Easy button if you would like help and guidance to create a meaningful query. All parameters are defined and process is split into 3 simple steps.
Use the Expert button to go to a single page containing all of the query options, without guidance.

If you intend to use any data for any publication (journal, thesis, report, etc), please review the citation page and let us know via email. Your publication helps us keep this database going.


In order to use the database properly and understand the limits of the data, please review:

DATA AVAILABILITY

  • CTD and discrete measurements are added to the database monthly and available from 1969 through the most recent cruise.
  • Nutrient data (NO2, NO3+2, NH3, PO4 and dissolved Si) are added to the database quarterly and are available for 1969 through June 22, 2017

    Some known data exceptions:

  • As of May 2017, dissolved Si is not available for 2011-Feb 2014
  • NO2 is not available for 2005 - 2011.
  • Light attenuation is not available for 2002-2006.
  • Time of day values for cruise data sampled 1981 through 1987 are estimates and accurate to within +/- 30 minutes.
  • Nutrient data are not collected all stations or depths,see STRUCTURE below

    STRUCTURE
    Tables
    The database is divided into 2 tables containing the CTD and nutrient data respectively (note the CTD data table contains Discrete data). In general, the CTD and nutrient tables may be considered one source of information. If your query contains both CTD and nutrient data, your results will include all of the CTD data and any nutrient data collected at the same time/location as CTD data.
    Nutrient data were usually collected at a small subset stations of the CTD data collection on any particular date. On rare occasions, nutrient data were collected at times/locations when CTD data were not collected. If you wish to view these data, only choose nutrient parameters, do not include CTD data in your query. If you wish to include CTD data only where nutrient data were collected, refine your query to select your nutrient ">0".

    Discrete data
    Discrete data/water grab samples (chlorophyll a, dissolved oxygen, and SPM) occur at a subset of CTD stations on any particular cruise. Since 1988, these data are listed at the 2m and bottom depth bins where collected. Light extinction coefficient is listed on the 1m line. Prior to 1988 when CTD use began, light attenuation is on the 0.5m line and other discrete parameters were collected at variable depths (commonly 0.5m, 1m, and 2m).

    To best inform your query, view the data table for your respective cruise to determine where data were collected. You can start at Data Visualization, choose the year of interest year, then choose the cruise to view. For each cruise date's data plot page there is a button in the upper right hand corner that links to the data table. Review the data table to understand the data from that date.

    HELP
    Please review this page and the query help page, if you are unable to complete the data query you requre, contact Tara Schraga

    Please let us know if you are using our data in ANY publication (email tschraga@usgs.gov). It helps us keep this database going!

  • Hooking up CTD Image

    Accessibility FOIA Privacy Policies and Notices

    Take Pride in America logo USA.gov logo U.S. Department of the Interior | U.S. Geological Survey
    Page Contact Information:tschraga@usgs.gov