Quality Control of California Data Exchange Center Hydrosystem Data for use in SacPAS

Appropriate data visualizations and modeling efforts in the Sacramento Basin depend on observational inputs of hydrosystem parameters. In order to properly inform, these parameter values must be constrained to real-world values. As a secondary data site, the California Data Exchange Center (CDEC) passes data unchanged from the original sources. Data errors can enter the system by a number of ways including sensor failure, transcription errors and recording errors. In order for data visualization and modeling projects to provide useful information, these errors must be identified and removed.

SacPAS imports 6 hydrosystem parameters from 60 CDEC sites for use in data visualizations and modeling:

1. Water Temperature
2. Flows
3. Reservoir Storage
4. Stage
5. Reservoir Elevation
6. Turbidity

The first step in error correction is to remove the -9997, -9998 & -9999 values representing identified errors. Histograms of value distribution are then examined visually to identify outlier and spurious values. Each set of parameter values is limited on a site-by-site basis as outlined below

Temperature limitations (F)

1. Water temperatures at all sites are limited to the range 26-90
2. NFH temperatures constrained between 31 and 85
3. LWS temperatures constrained between 31 and 85
4. OBB temperatures constrained above 35
5. AHZ temperatures constrained below 75
6. AWP temperatures constrained between 39 and 84
7. SHD temperatures constrained above 34
8. AWB temperatures constrained between 34 and 84
9. KWK temperatures constrained between 34 and 80
10. AND temperatures constrained between 34 and 84
11. BSF temperatures constrained above 33
12. RDB temperatures constrained above 33
13. JLF temperatures constrained between 35 and 70
14. CCR temperatures constrained above 35

Elevation Limitations (ft)

1. WHI between 1100 and 1225
2. SHA above 800
3. ORO between 630 and 905
4. NML between 700 and 1100
5. NAT between 100 and 150
6. KES between 550 and 600
7. FOL between 340 and 470

Flow Limitations (ft)

1. FRE , NAT above 0
2. ORO, OBB above -10
3. COL, ORD, HMC, VON above -100
4. VIN between -260 and 200000
5. FPT above -600000 (HOURLY) or above 2000 (DAILY)

Storage Limitations (AF)

1. WHI between 1000 and 260000
2. SHA between 600000 and 5000000
3. NAT between 1900 and 10000
4. KES between 12000 and 25000
5. FOL above 1000

Turbidity Limitations (NTU)

1. Turbidities below 0 or above 1000 are removed

River Stage Limitations (ft)

1. All stages below -350 are removed
2. COL between -40 and 700
3. Delta region sites with stage values 40 feet below average or 90 feet above average.