Welcome to the California Water Quality Assessment Database (CalWQA)

CalWQA is a new online database that enables the State of California to accurately report and interpret water quality conditions and provide a clear picture of existing water quality in the State. Note to Users: Modern browsers such as Firefox and Internet Explorer 7 and greater allow for internet pages to be loaded into tabs of the browser. NEVER use more than one tab in your browser to open editing pages in the system. This can lead to unpredictable behavior including crashing pages and leaving the data with corrupted values.

Click here for the Testing/Training System. Start here first.

Training System

Click here for the Production System

Production Database

Version 2.1.4 of the system has been released with functional upgrades to assist with finalizing the 2010 Integrated Report. The next planned release will be version 3.0.0 around February 2012. There may be additional releases in the CalWQA 2 series that implement minor fixes or additional functions until version 3 is released. Watch this page for more information

Version 2.1.4 of the system has been moved to a new set of servers. The changes should not have cuased any noticeable changes. Please notify SWRCB if you find any new issues.

January 27, 2012

Broken Production System Link

- The Thursday release of this page accidentally included a hyperlink to the old, now defunct Production CalWQA System. This has now been corrected. We're sorry for any inconvenience that may have caused.

January 23, 2012

Version 2.1.4 of the system has been migrated to a new hosting platform:

- The production CalWQA system has been moved to a new, more reliable platform. There are no known issues at this time. Development on version 3.0.0 continues and may result in a incremental 2.1.5 release in the coming weeks.

December 16, 2011

Version 2.1.4 of the system has been released with the following changes:

- Made reference management accessible from the home page;
- Implemented the decision revision code functionality;
- Implemented two admin bulk operation function to assist the finalization of the 2010 Integrated Report;
 --- Mark all Decisions and Associated LOEs of the current listing year as State Board Approved
 --- Mark all "Region LOE Data Assessment Complete (Not State Reviewed)" LOEs of the current listing year as State Reviewed
Added various functions to support submitting assessment results to USEPA
 --- Implemented admin function to generate assessment data in ATTAINS XML format;
 --- Implemented admin function to export ATTAINS assessment data in PIPE delimited text file for review.

June 2, 2010

Version 2.1.3 of the system has been released with the following changes:

-[3082] Enhanced the performance of Statewide Comprehensive Report. able to generate formatted reports for whole state with increased number of records.
-[2986] Added option to turn off the live links on Comprehensive Report and Category Report;
-[3103] Changed hard-coded filters to prevent water bodies associated with Region ID 10 from appearing on the following reports:
--- Comprehensive Report by Region and Status
--- LOEs not Associated with Decisions Report by Listing Cycle
--- Integrated Report Category Lists
--- Miscellaneous Changes Report
-[2943] Finalized changes for this issue (many cosmetic changes)

April 23, 2010

• Version 2.1.2 of the system has been released with the following changes:

-Minor changes to the report outputs

March 19, 2010

• Version 2.1.1 of the system has been released with the following changes:

- [2984] Updated comprehensive and category reports with text and cosmetic changes
- [2984] Added a “Listing Year Overwrite” field to overwrite the listing year displayed on comprehensive and category reports
- Fixed a bug of displaying Core Beneficial Uses on category reports
- [2293] Added a “State Board Notes” field on decision detail screen

January 8, 2010

• Version 2.1.0 of the system has been released with the following changes:
- [2688, 2641] Category reports now link to both an SWRCB web map for each waterbody (with a lot of information for each waterbody) and to the detailed comprehensive report (fact sheet) for that waterbody by pollutant. Links provide explanatory hover tips.

December 4, 2009

• Version 2.0.19 of the system has been released with the following changes:
- [2845] Revisions to the category determination logic better handle waters with a category 4c determination, and provides a correction to the ERR5 logic and on-screen error note.

November 19, 2009

• Version 2.0.18 of the system has been released with the following changes:
- [2592] Administrator option to bulk approve decisions for State review
- [1359] Provide paging controls (jump to page x) on the top and *bottom* of list tables on Decision List and LOE list screens for each waterbody

April 17, 2009

• Version 2.0.17 of the system has been released with the following changes:
- [2000] Category 2 and Misc Changes reports now properly filter out all retired records (e.g. waterbodies, decisions, LOEs)
-[1980] Expected Attainment Date for all Decisions is no longer required to place waterbodies into category 4b
-[0020] If the value for *Last Listing Cycle's Final Listing Decision* is "List on 303(d) list (being addressed by action other than TMDL)" or "List on 303(d) list (being addressed by USEPA approved TMDL)" then "List on 303(d)list(TMDL required list)" is now available as an option for *Final Listing Decision:* field.

February 2, 2009

• Version 2.0.17 of the system has been released with the following changes:
- [1787] Users may not create "Multiple Pollutant" decisions and record only a single distinct pollutant. These decisions must now be recorded as the Single Pollutant type.
-[1780] Decisions may now be edited and saved for the same pollutant without causing a duplicate pollutant error against themselves. This fix addresses the "within-decision collisions."

January 15, 2009

• The system has been updated with the following changes:
- [1679] Improved output in filtering for the PIPE tabular comprehensive report.
- [1692] Line of evidence (LOE) information displayed on the Category screen now properly blocks retired LOEs.
- [1780] The check that prevents two decisions from being created with the same pollutant now only considers Decision/Pollutant combinations within the current listing cycle.

December 19, 2008

• Version 2.0.16 of the system has been released into new servers with the following changes:
  - [1679] Misaligned fields in PIPE tabular comprehensive report. Carriage returns are now filtered out before presenting the output.
  - [1684] Category reports 4a, 4b and 5 that are driven by decisions to include a waterbody in the 303(d) list and do not have valid previous listing values will display the present listing year.
  - [1686] Users are prevented from selecting pollutants that have been used in decisions (single pollutant and multiple) for the same waterbody
  - [1692] User will be able to view the information of all the LOEs that are associated with the beneficially use from the category screen.
  - [1699] When adding LOEs in the “add new decision” screen, the application pre-populates the single pollutant depending on those assigned to the LEO-s. Users may also change the pollutant manually through the pick pollutant button.
  

November 25, 2008

• Version 2.0.15 of the system has been released with the following changes:
  - [1685] Uses with rating of "insufficient information" are now blocked from displaying on Category 1 report and Category 2 report. Only uses with a rating of “Fully Supporting" will be displayed on those two reports.

October 21, 2008

• A minor update of the system has been released with the following changes:
  - [1524] Values for decision attribute fields are now kept even after changes to Listing Decision are made.
  

October 7, 2008

• Version 2.0.14 of the system has been released with the following changes:
  - [1361] Added 'Last Listing Cycle's Final Listing Decision:', and 'Describe Implementation Action Other than TMDL' to Decision Quick Reports
  - [1591] Added "Ungroup" button next to "View Group" button to allow 'bulk' ungrouping of LOEs
• [1026] The "Copy LOEs" function now copies References as long as the LOE is copied to a water body from the same region or itself. Otherwise, the validation message "Warning: References have not been copied for this Line of Evidence. Please see warning messages." is displayed on the LOE screen.
• [1524] Changing between "List on 303(d) list (being addressed by USEPA approved TMDL)" and "Do Not Delist from 303(d) list (being addressed with USEPA approved TMDL)" now preserves the "TMDL Project code and Date (TMDL Approved by USEPA)" In addition, the sources selection is preserved when you switch between final listing decisions that share the sources selection.
• [1501] Unchecking of "Retired waterbodies" persists under all conditions.
• [1091] Additional modifications to the reports formats were made to support SWRCB posting to the Web.

August 29, 2008

• Version 2.0.13 of the system has been released with the following changes:
  - Addressed recently identified category report issues
  - Water body subtype issue was addressed in the water body edit screen
  

August 27, 2008

• The next Integrated Report meeting is on September 17 at 1:30 P.M.
  

August 26, 2008

• Version 2.0.12 of the system has been released with the following changes:
  - Reports for public viewing reflect the latest SWRCB web standards [Completes issue 1091]
  - Miscellaneous Changes and Reference reports now allow the entry of titles that will appear in the generated output
  - An error preventing "split" waterbodies from being saved was addressed