CEDEN Logo  
HOW DO I?
contact us  |  site map    

There are several pathways to access CEDEN data, as described below.

CEDEN Query Tool – This query option has been used for many years by data consumers to access CEDEN data. It allows users to select the data category and the filter on a variety of fields. The dynamic picklists mean that selections alter the options of subsequent fields. For example, if a user selects a specific Program, the analytes listed in the analyte picklist will only be those that have associated results as part of that program. By default, only results with replicate and lab replicate of 1, results not flagged with a reject code, and results associated with stations with coordinate number of 1 are available through this query tool. QA sample results are available when the “include QA data” checkbox is marked.

The State’s Open Data Portal – This portal provides access to data from a variety of state agencies in a machine-readable format. Once on the site, users can search using the word “CEDEN” and data sets containing every CEDEN data category (chemistry, tissue, toxicity, etc.) will be returned. Each dataset contains one or more flat files that are similar to the exports from the query tool described above and also include two additional fields that convey a level of data quality. This pathway does not provide an interface for filtering; however, the site does provide APIs to deliver refreshed data, though larger datasets may have problems. A stations file is also available that can be linked to any of the data category files.

The toxicity data provided on the Open Data Portal may be easier for many users to use. While there is a file that is similar to what is exported from the query tool, there are also files that provide the summary results separated from the replicate results and are exported in a format that matches the data upload form.

The source of these data are the same datamarts that provide data to the Query tool so many of the same conditions apply (no rejected data, no replicates, and no results from stations with a coordinate number greater than 1).

Visualization – This dashboard provides users with filtering ability by Program, Parent Project, and by Project. It also has date sliders so users can target any time period within the last five years. It provides result counts for each analyte, by data type (Analysis Type on the dashboard).

Summary of the full data can be exported from the dashboard by clicking on a data element (either a dot within the map or a cell within the table), waiting for a menu to pop up and then clicking on the icon that looks like two columns of content. This will bring up a pop-up window that will allow the user to download the summary or the full data.

The source of these data are the same datamarts that provide data to the Query tool so many of the same conditions apply (no rejected data, no replicates, and no results from stations with a coordinate number greater than 1).

Questions or comments regarding these tools can be directed to ceden@waterboards.ca.gov.