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

NEW - CEDEN Query Tool – This is a new version of the CEDEN query tool has been used for many years by data consumers to access CEDEN data. It allows users to select the data category and filter on a variety of fields. The dynamic filters mean that selections alter the options of subsequent fields. For example, if a user selects a specific Program, the analytes listed in the analyte filter 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.

The State’s Open Data Portal

• General Data From CEDEN – The Open Data 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).


• NEW - CEDEN Augmentation Data – This dataset on the State’s Open Data Portal is comprised of field and chemistry data submitted to CEDEN but that has not yet been loaded to CEDEN so is not available through the query tool. Many of the conditions applied to the other CEDEN data on this portal and the CEDEN query tool are also applied to this dataset for consistency (no rejected data, no replicates, etc.).

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 is the CEDEN Augmentation Data, which, as described above, are data that have been submitted to CEDEN but have not yet been loaded to the database so are not available through the CEDEN Query Tool.

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