Welcome to the Data Validator webpage. This tool allows you to validate data interactively by uploading a dataset and rules file. To get started, go to the validator tab on the left.

Join our team to build this tool!

Win Cowger

Moore Institute for Plastic Pollution Research

Shelly Moore

Moore Institute for Plastic Pollution Research

Hannah Hapich

Moore Institute for Plastic Pollution Research

Scott Coffin

State Water Resources Control Board

Tony Hale

San Francisco Estuary Institute

Diana Lin

San Francisco Estuary Institute

Rebecca Sutton

San Francisco Estuary Institute

Gabriel Daiess

Leah Thornton Hampton

Southern California Coastal Water Research Project

Richard Nelson

California State Water Resources Control Board

Haig Jack Minasian

CSU Long Beach

Holden Ford

CSU Long Beach

Anja Oca

CSU Long Beach

Libby Heeren

Moore Institute for Plastic Pollution Research

Hannah Sherrod

Moore Institute for Plastic Pollution Research

Nick Leong

Moore Institute for Plastic Pollution Research

Fabian Gomez

Moore Institute for Plastic Pollution Research

Gemma Shusterman

San Francisco Estuary Institute

Adam Wong

San Francisco Estuary Institute

Welcome to the Data Validator webpage. This tool allows you to validate data interactively by uploading a dataset and rules file. To get started, go to the validator tab on the left.

1. Both the data and rules files must be in .csv or .xlsx format. Examples for how to structure and query the data and rules can be found below:
Download Sample Rules Download Valid Sample Data Download Invalid Sample Data
2. Uploaded the data and rules file on the validator tab. NOTE: If using the examples you will need to first unzip them.

3. If your data is validated a popup will appear to input your credentials and then click ok. If this is a resubmission, upload a previous certificate to override the previous submission.

4. If your data is validated you may download a certificate. The certificate is proof of your submission and will allow you to update the submission. This should always be saved for any submitted data.

5. In the event of invalidated data, the box for the file with issues to be resolved will be red, there will be an indication of the number of rules that were successful, had warnings, or had errors. Only errors need to be resolved for the validation to be successful.

6. You can click on any of the descriptions in the 'Issues Raised' panel to display the rows where the issue was found in the 'Issues Selected' panel.

7. The 'Issues Raised' and 'Issue Selected' data sheets may be copied, or downloaded as CSV, Excel, or PDF.

Data will not be shared externally unless you specify the data can be shared by inputting the security key. If a key is input, the data will go to one or more of MongoDB, CKAN, and/or S3.

The validator app is https encrypted and the source code is available on GitHub for security review.

Have any additional questions or concerns? Email us using the link below:

Please include in your email:

(1) What do you think the app should be doing?

(2) What is the app doing instead?