Water Quality of San Francisco Bay
Help on using this form to extract the data you want
Click the checkboxes to choose what data types you want to see from the database.
Refining the search
You can choose here to limit your search based on criteria from within the dataset. For instance, if you only want to see data from station 36, on cruises occurring after 1997200, then you could select those options here.
Note: The "> <" symbol means "Between". The text entry for this selection should be two numbers seperated by "and". For example: Julian Dates between 1997050 and 1997100. Note also that this is inclusive (both 1997050 and 1997100 would be included in the results).
Note 2: The "IN" field allows you to specify a comma-separated list of allowable values. For example: To only view cruises from December, January and February, select Month IN 12, 1, 2.
Note 3: To test to see if a value exists (For example: You only want to see data from instances where Discrete Chlorophyll was collected) select the value, then specify that it needs to be >= 0.
Note 4: Maximum Depths at each station can be queried by specifying Depth = max.
Sorting the data
It is possible to sort the data by up to 3 fields. The default is for no sorting, and data will be returned in a pseudo-random order.
Data can be output in one of 2 formats; either as an HTML table which is easily viewable in browsers, or as a comma-delimited textfile, for ease in inputting into other database, spreadsheets, or other similar programs.