Home | About CDSN | Get Involved | Contact | Calendar | SWAPs | Data Calls | Forum

AWQMS.wqx Portals (Database) | CDSN Google-Map |CDSN Web GIS

 

Colorado Data Sharing Network (CDSN)

is helping to enhance Colorado's watersheds and water quality by providing

CDSN's data partners and Colorado's citizens with an accessible and affordable tool kit

for data management, data analysis, and data sharing.

 
 

 

Get CWQMC & CDSN News about trainings, webinars, new features with our E-Newsletters.

(We try not to email more than once a month.)


 

CDSN News --

CDSN is currently helping 66 (and climbing) different data organizations manage 3.3 million water quality results for over 11,000 monitoring locations in Colorado, while saving our data partners over $1 Million in fees if they were individually managing their data vs. using the collaborative CDSN data management system and tool kit. Since January 2012 we have tripled the data in CDSN and quadrupled the number of data providers participating. The public and data organizations can access, analyze and download this data, all in a single format, anytime they desire. To join CDSN, please contact the Project Coordinator at cdsn@coloradowaterdata.org or 970-258.0836. Please consider a contribution to our important project which benefits all Coloradoans.
 
 

2015 WQCD - CDSN REG 93 (303(d) LIST OF IMPAIRED WATERS) DATA CALL INFORMATION

WQCD & CDSN 2015 Data Call Announcements and Deadlines for WQCC Regulation 85 (Nutrients) - and - WQCC Regulation No. 93 Section 303(d) List Water-Quality-Limited Segments Requiring TMDLS and subsequent rulemaking

Colorado Data Sharing Network (CDSN) provides data to WQCD for their water quality rulemaking process and Regulation 85 data calls each year.

 

There is no reason to double submit your data and an added benefit of using CDSN is that your data will be available, along with all other participating entities’ data, for other uses including CDSN mapping and analytical tools." If you are using the CDSN, please notify the CDSN by FEBRUARY 1, 2015 that you are doing so.

 

For detailed information including the WQCD Request letter and details for using CDSN, please go to http://www.coloradowaterdata.org/datacalls_cdsn.html.

***

WQCD REG 85 2015 Deadline & Updates --

Colorado Department of Public Health & Environment (CDPHE) Water Quality Control Division (WQCD) posts Reg85 updated information and important news about Reg85 Stakeholder meetings and the Nutrients 2015 Triennial Review <here> and also <here>. We recommend checking both of these links frequently. The next WQCD Reg85 Stakeholder meeting is Monday, January 26, 2015 at CDPHE, Bldg A, Sabin-Cleere, from 1:30-4:30 pm. WQCD's Reg85 contact information is 303-692-6412  or cdphe.nutrients@state.co.us.

 

The WQCD announcement, from 1/16/2014 reads, "Wastewater discharger data submission -- The annual nutrient monitoring data report for 2014 is due to the division by April 15, 2015. The division has developed a new, user-friendly data submission form in order to streamline data submission and review. This form has been pre-populated when possible and has been emailed to each facility. The division will also introduce the form at the January 26, 2015 stakeholder meeting. Additional training or question and answer webinars may be scheduled in the future, depending upon need. The division strongly encourages facilities to use the new data submission form but will accept the "old" report template (used for 2013 data submission) as well for this data call. Data may also be submitted via the Colorado Data Sharing Network; please notify the division if your facility will use this option."

 

However, for CDSN data partners using CDSN to submit their Regulation 85 data, you can use our CDSN upload template <AWQMS Portals & Resources page >> Upload Templates Tab>, and all data must be uploaded into CDSN before April 1. Data to be submitted MUST have the additional Project ID of "WQCD_REG85" associated with the required results (see template).

 

The WQCD announcement also provides important guidance on detection limits: "The division has created a Regulation 85 guidance document for detection limits. Please consult the guidance document (link below) if you have any questions about reporting limit definitions or how detection limits are calculated. The document also includes the required reporting levels and method detection limits for reporting Regulation 85 results. https://www.colorado.gov/pacific/sites/default/files/Detection%20Limits-Reg%2085.pdf"

 

Important Note: At WQCD's determination, Regulation 85 data stored in the CDSN should NEVER be "Exported to WQX" (i.e. sent to the National Data Warehouse). WQCD is uploading their official final Reg85 dataset for each year into the National Data Warehouse themselves, under the Organization ID COLO021.

***

CDSN AWQMS UPLOAD LATEST TEMPLATE UPATES --

The last major updates of the waterquality template for groundwater and surface water was made in October 2015. The companion import configuration files were re-updated in January 2015, due to a compatibility issue with a new version of AWQMS deployed on 12/31/2014.
 
The Physical-Chemical Data Upload Template, Minimum Data Element Fact Sheet, and companion Import Configuration Files are on our AWQMS Portal Page. The Template was updated in October to include hundreds of new WQX-valid values for several minimum data elements including Analytical Method, Characteristic Name, Method Speciation, Result Detection Quantitation Limit Type and more. The Activity/Results tab has a new optional column (matched with an updated import configuration file available for download and import into AWQMS) recommended by labs as good data management -- LabSampleID. Many lab output EDDs include the Lab Sample ID. You can cut/paste this easily into the upload template. The updated template, minimum data elements fact sheet and companion import configuration files are available for download on our AWQMS Portals & Resources page >> Upload Templates Tab.

December 31, 2014 -- New version of AWQMS released and deployed!

The version of AWQMS deployed on New Year's Eve fixes a bug identified by CDSN Project Coordinators that prevented activity/results getting a benign warning upon upload from being able to be migrated (permanently saved) in AWQMS if desired. This is now fixed.
 
Technical notes are available from our programmers <here>. A webinar created by the programmers highlighting the latest new features is <here>.

EXCEEDANCE/MONITORING LOCATION MAPPER guide updated January 2015 --

The CDSN Google-Mapper allows a user to see monitoring location metadata quickly when the mouse is rolled-over an Ambient Water Quality Monitoring System (AWQMS), USGS National Water Information System (NWIS), or EPA National Data Warehouse monitoring location at an appropriate zoom level. A summary of water quality data results can be viewed or downloaded for AWQMS and EPA monitoring locations from the mapper simply by clicking on the monitoring location, again at the appropriate zoom level. Clicking on a USGS monitoring location will take you to a USGS data download page where you can download the USGS water quality results data.
 
The user can turn on the Exceedance filter and specify a characteristic and a threshold value to the AWQMS monitoring locations (EPA & USGS monitoring locations will continue to display but do not get filtered by the exceedance function). AWQMS Monitoring locations having "hits" or exceedances will then turn red. With the Exceedance filter active, only data that exceeds the threshold specified for the characteristics specified will be provided for viewing/download upon clicking on a "red" AWQMS monitoring location. Again, the exceedance filter only works on AWQMS monitoring locations and for the specific characteristic.
The CDSN "Google-map" was first deployed in the fall of 2011 and allowed for displaying AWQMS monitoring locations, as well as USGS NWIS/NAWQA monitoring locations and EPA National Data Warehouse monitoring locations.  The ability to view monitoring locations that have data in AWQMS which exceeds a user specified value for a user specified characteristic (analyte) was added in January 2013. 
 
In June, 2013 we upgraded the exceedance utility of the map, so that you could see both the monitoring locations where there are exceedances at the same time you could see those that don't exceed your thresholds for your analytes. Also, by streamlining the Monitoring Location map and the Exceedance query feature into one legend, the user interface of the map changed a bit. Whether you are a veteran or a new CDSN Google-map user, please take a minute to skim through this updated quick-start guide. For 2015, we have added more detail about the different results table options to this guide:
CDSN Google-Map quick start guide (January, 2015).

ON-LINE & DESKTOP GIS UTILITY, Deployed July 2013 --

The Web GIS Application lets anyone perform basic geo-spatial queries from the on-line utility. More advanced functions, including using the application in your own desktop GIS environment are available--just see the quick start guides. There are two, one for those WITH an ESRI ArcGIS On-line user account and one for those WITHOUT one. See the GIS page for a link to instructions on how to make your own account.
Basic Public Quick Start Guide for using the CDSN WebGIS application with OUT an ArcGIS On-line User Account
Public Quick Start Guide for using the CDSN WebGIS application WITH an ArcGIS On-line User Account

CDSN PROJECT COORDINATOR HAS A NEW EMAIL ADDRESS (October 2014) -- cdsn@ColoradoWaterData.org.

 
Click HERE to Suggest An Event to add to our Calendar

Upcoming Events --

(Click on an event title for more information)

 

Recent Presentations --

 
October 2014 - Sustaining Colorado Watersheds Conference, pre-conference workshop - Presentation & Live Demo
Presentation PowerPoint (25mb)
November 2014 - DRAFT BUDGET
Presentation PowerPoint

 

 
 
 

 

© Colorado Data Sharing Network/ Colorado Water Quality Monitoring Council 2009-2014; cdsn@coloradowaterdata.org
Colorado Data Sharing Network, PO Box 2058 Ridgway, CO 81432
380 W. Sherman Street, Suite 2; in the Lupita's Building next to the ice cream shop :)
 
Site Search Engine