Welcome to the California Regional Water Quality Control Board, Central Valley Region Welcome to the California Environmental Protection Agency
Irrigated Lands - Electronic Water Quality Monitoring Data Submission Resources

Irrigated Lands Regulatory Program - Electronic Water Quality Monitoring Data Submission Resources

This webpage serves to provide resources and tools for electronic surface water quality data submission under the Irrigated Lands Regulatory Program.

The templates and guidance documents provided below have been developed by the California Environmental Data Exchange Network (CEDEN). The informational graphics and checklists were developed in partnership by the Central Valley Regional Data Center (CV-RDC) and the ILRP Data Management Team (ILRP DMT).

To submit data to the ILRP, begin with the data templates (CVRDC or CEDEN) below. The accompanying checklists, supporting documents and online data checker tool will assist in ensuring the data is correctly formatted and the required checks are completed prior to submission.

Data submitted to ILRP are reviewed by the ILRP Data Management Team (DMT) before becoming publicly available through CEDEN. An overview of the processing steps carried out by the ILRP Data Management Team is shown in the following flowcharts (click to view).

Flowcharts
Overview of Data Processing Steps

Overview
Detailed
(with resources used)

ILRP Data Processing Flowchart Overview
ILRP Data Processing Flow Chart Detailed


Announcements

On 27 March 2014, Stakeholders were informed that by 3 June 2016, ILRP electronic data deliverables were required to be submitted using the CEDEN template format, thus replacing the older CVRDC template format. Currently, the online CEDEN template Data Checker tool is not fully reporting errors. As a result, ILRP staff is rescinding the 3 June deadline, and ILRP data submissions will be accepted in either CVRDC or CEDEN format until further notice. Staff will be collaborating with the CEDEN team to improve the data checker.

Additionally, the ILRP DMT developed informational graphics that compare the currently used CVRDC Excel templates to the new CEDEN Excel templates. These are provided below:

  • Infographic - Differences between the Old CVRDC Chemistry Data Template and the New CEDEN Chemistry Template.

  • Infographics - Differences between the Old CVRDC Toxicity Data Templates and the New CEDEN Toxicity Templates.
    • Summary Tab, 43 KB, PDF (PDF Info), Compares the CV RDC toxicity template, summary tab, to the CEDEN template.
    • Results and Batch Tab, 21 KB, PDF (PDF Info), Compares the CV RDC toxicity template, Results and Batch tab, to the CEDEN template.

If you would like to be added to our email list please contact Chris Jimmerson at cjimmerson@waterboards.ca.gov.


CEDEN Electronic Data Templates and Guidance Documents

CEDEN guidance documents are frequently updated - usually for clarity. Check back often for the most recent document.

  • Field Measurements and Observations

  • Chemistry
    • Chemistry Data Template, 592 KB, MS Excel
      A Microsoft Excel file that contains multiple worksheets, including ChemResults and LabBatch, with the appropriate fields required to load chemistry data into the database, including; nutrients, metals, organics and bacteria data. A data submission example is included in the Excel file.

    • Chemistry Data Submission Guidance Document (6/7/17), 683 KB, PDF (PDF Info)
      This document provides detailed guidance to assist data providers in preparing and submitting data using the CEDEN chemistry data template.

  • Toxicity
    • Toxicity Data Template, 255 KB, MS Excel
      A Microsoft Excel file that contains three worksheets, including ToxSummaryResults, ToxReplicateResults, and ToxBatch. A data submission example is included in the Excel file.

    • Toxicity Data Submission Guidance Document (6/6/17), 677 KB, PDF (PDF Info)
      This document provides detailed guidance to assist data providers in preparing and submitting data using the CEDEN Toxicity data template.

Data Management Tools

  • ILRP CEDEN Template Checklists, 44 KB, MS Excel
    An Excel workbook used to review the formatting, quality control review and completeness. This workbook is utilized by the ILRP as part of the processing of data prior to its loading to the database structure. The checklists are provided to the third-party as part of the feedback package.

  • ILRP CEDEN Template Checklist Instructions with example Pivot Tables, 133 KB, PDF (PDF Info)
    Provides instructions and example pivot tables based on the new CEDEN templates for reviewing the format and business rule requirements for ILRP EDD submission.

  • CEDEN Data Checker
    An online automated tool that checks CEDEN data templates for formatting LookUp list values and busines rules.

  • CV RDC Data Checker
    An online automated tool that checks data templates for formatting LookUp list values and CV RDC business rules.

  • CVRDC Data Checker Trouble Shooting Table

  • Lookup List Request Forms
    Submit new analyte, method, protocol and station codes through a form or excel template to the CV RDC.

  • File Batch and Naming Convention (08/02/2011), 190 KB, PDF (PDF Info)
    A PDF document that describes the CV RDC naming conventions for files and batches.

CVRDC Templates and Manuals

  • Field Sheet Templates
  • Water Quality Electronic Data Templates
    • CVRDC Chemistry Data Template, 66 KB, MS Excel
    • Microsoft Excel file that contains two worksheets including Results and LabBatch as well as a data submission example. 
      • Chemistry Template Entry Manual (10/20/2016), 655 KB, MS Excel
        A PDF document that describes the process for filling out the CV RDC Excel chemistry template and reporting analytical chemistry data to the CV RDC.
    • CVRDC Toxicity Data Template, 112 KB, MS Excel
    • Microsoft Excel file that contains three worksheets including Results, Summary, and ToxBatch as well as a data submission example.
      • Toxicity Template Entry Manual (10/20/2016), 646 KB, PDF (PDF Info)
        A PDF document that describes the process for filling out theCV RDC Excel toxcity template and reporting toxicity data to the CV RDC.
    • CVRDC Field Data Template, 103 KB, MS Excel
    • Microsoft Excel file that contains 7 worksheets including Stations, Locations, FieldResults, HabitatResults, GroupCode, FundingCode, and Personnel.
      • Field Form Template Entry Manual (10/20/2016), 527 KB, PDF (PDF Info)
        A PDF document that describes 1) the process for entering water quality field data into the CV RDC database through data entry forms and 2) entering water quality field data into the CV RDC templates.

Workshop Presentations


*Downloading Large Files
Please allow sufficient time for the file to download completely. Depending on your Internet connection service, browser version and computer speed, downloading may take 15 minutes or more for files that are larger than 1 MB. Some browsers, such as certain versions of Internet Explorer, do not show the progress of the download, making it appear that nothing is happening.

--Web page updated 06/07/2017