Irrigated Lands Regulatory Program -
Electronic Data Submission Resources

Electronic Data Submission Resources

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

If you would like to be added to the Regional Board DMT email list please contact Chris Jimmerson at Chris.Jimmerson@waterboards.ca.gov.

  Announcements

  • The Regional Board DMT has changed the EDD loading protocol.
    Consequently, data providers may notice that some of the EDD's field names and column order in the Feed Back packages have changed in the CEDEN template. This is an internal consequence of changes to our loading process. Please continue to submit the EDDs in CEDEN format.

Overview

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 by the Irrigaged Lands Regulatory Program (ILRP) Data Management Team (DMT).

To submit data to the ILRP, begin with the CEDEN data templates 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.

The ILRP DMT reviews the data before CEDEN makes it publicly available. An overview of the processing steps carried out by the ILRP DMT is shown in the following flowchart (click to view). As part of the CEDEN loading process, the DMT submits the reviewed data to the Surface Water Ambient Monitoring Program, who then submits the data to CEDEN.

Data Processing Steps

ILRP Data Management Team (DMT) EDD Processing Flowchart

Click image to view flowchart

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
    • Field Collection and Results Template, MS Excel
      A Microsoft Excel file that contains multiple worksheets, including FieldResults and HabitatResults, with the appropriate fields required to load historic and current field and habitat data into the database. A data submission example also is available.
    • Field Collection and Result Data Submission Guidance Document (06/06/17)
      This document provides detailed guidance to assist data providers in preparing and submitting data using the CEDEN Field Collection and Results data template.
  • Chemistry
    • Chemistry Data Template, 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 (06/07/17)
      This document provides detailed guidance to assist data providers in preparing and submitting data using the CEDEN chemistry data template.
  • Toxicity
    • Toxicity Data Template, 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 (07/11/17)
      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, 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
    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.

Central Valley Regional Data Center (CV RDC) Templates and Manuals

*If you are a data provider coordinating with MLJ Environmental, please continue to the following link. MLJ Environmental and CV RDC. If you are submitting data directly to the Central Valley Water Board, please ignore references to CV RDC on this web page.
  • Field Sheet Templates
  • Water Quality Electronic Data Templates
    • CV RDC Chemistry Data Template
    • 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), 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.
    • CV RDC Toxicity Data Template, 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)
        A PDF document that describes the process for filling out the CV RDC Excel toxcity template and reporting toxicity data to the CV RDC.
    • CV RDC Field Data Template
    • Microsoft Excel file that contains 7 worksheets including Stations, Locations, FieldResults, HabitatResults, GroupCode, FundingCode, and Personnel.
      • Field Form Template Entry Manual (10/20/2016)
        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

Subscribe to our Irrigated Lands Regulatory Program email list to receive notifications and the latest updates. After subscribing, you will need to check your email host for a confirmation email to complete the subscription.

Email Address: (required)
Your Full Name: (required)
(e.g. John Smith)

  Subscribe to our other email lists.

Contact Us

Central Valley
Regional Water Quality Control Board
Irrigated Lands Regulatory Program