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 70 (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.

January 2016 -- Data Call Preparation Begins!

2016 COLORADO DATA SHARING NETWORK (CDSN) CALL FOR DATA FOR WQCC REGULATION 34 & 35: Use CDSN to submit your requested Water Quality Data for the San Juan, Dolores, Lower Dolores and Gunnison River Basins Triennial Review

The Colorado Data Sharing Network is excited to announce that for the fifth consecutive year, the CDPHE Environmental Data Unit which collects data for the Water Quality Control Division (WQCD), is partnering with CDSN so that those entities already uploading data meeting the WQCD guidelines will not have to individually reformat and resubmit their data to WQCD via the Environmental Data Unit in order to supply data for the WQCC Colorado Regulation 34 & 35 data call. 


In the preceding years , this joint effort between CDSN and WQCD was found to be very efficient for the data providers and certainly resulted in more data being submitted to WQCD for the data call.


For more information on using CDSN to submit data for the Reg 34 & 35 WQCC data call, please see the "2016 Data Call" web page.



If your organization is required to collect and submit data for Regulation 85, you can use CDSN to manage your data in AWQMS and have CDSN submit your Regulation data for you to WQCD without additional re-formatting. CDSN also can assist you in getting your raw lab data into upload templates and uploading your data. Using CDSN has been beneficial to organizations who have small and large data sets, who also want to manage, access, and analyze their data independently from Regulation 85.


For more information on Regulation 85 please see the "Regulation 85 Data Upload & Submittal Info" tab on this web page.



The CDSN Database and Data Management System has a new dashboard and new features!

This AWQMS upgrade includes a completely redesigned user interface (including three color schemes to choose from), mapping enhancements (including automatic positioning and zooming), support for importing and exporting of native Excel spreadsheets, and the ability to perform batch updates on result parameters and result status. 


User guides and documentation updates are available with more updates in progress. CDSN Project Coordinators are working on updates of all our AWQMS documentation, fact sheets, templates, etc. You might find that some of the documentation shows screen shots and refers to previous versions of AWQMS.



CDSN now has connected Restful Webservices to the CDSN data management system AWQMS. We are developing guidance materials and sample scripts to help you use this exciting feature to highlight your data stored in AWQMS, real-time, using charts, graphs, and gages on your own website.


The last major updates of the waterquality template for groundwater and surface water was made in October 2014. The companion import configuration files were re-updated for the upgraded versions of AWQMS deployed in January 2015 and May 2015. Import configurations are not always backwards compatible. You can download files that match our templates from our AWQMS portal > Templates tab. Due to a compatibility issue with the newest version of AWQMS deployed in May 2015, you may need to use the newest import configuration files. If you need any assistance, contact the CDSN Project Coordinator. The CDSN Minimum Data Elements Fact Sheet (July 1, 2015) and CDSN AWQMS Upload Guide (June 15, 2015) were updated following the deployment of AWQMS 4.0.
The Physical-Chemical Data Upload Template, Minimum Data Element Fact Sheet, and companion Import Configuration Files are on our AWQMS Portal Page. The Template is constantly being updated in 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.


EXCEEDANCE/MONITORING LOCATION MAPPER (Quick Start 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).



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





WQCD REG 85 2015-2016 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. 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.

WQCD REG 85 Data Reporting Requirements & 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. WQCD's Reg85 contact information is 303-692-6412 or cdphe.nutrients@state.co.us.


Click HERE to Suggest An Event to add to our Calendar

Upcoming Events --

(Click on an event title for more information)


Recent Presentations --

June 2015 - CDSN Overview and AWQMS Data Upload Training for Animas and San Juan Basin Groups
Presentation PowerPoint (24mb)
October 2014 - Sustaining Colorado Watersheds Conference, pre-conference workshop - Presentation & Live Demo
Presentation PowerPoint (25mb)
October 2014 - 2014 Upper Colorado River Basin Water Forum “Seeking a Resilient Future” [Panelist presentation]
Presentation PowerPoint (12mb)


© Colorado Data Sharing Network/ Colorado Water Quality Monitoring Council 2009-2014; cdsn@coloradowaterdata.org
Colorado Data Sharing Network, PO Box 2058 Ridgway, CO 81432
160 S. Amelia Street, Downstairs/Alley, Suite 1 (Basement of Ridgway Integrative Medicine Bldg.)
Site Search Engine