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

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.