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.


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. 

The beta-test period for this redesigned AWQMS is from May to July, 2015. Updated user guides and documentation is currently in progress. CDSN Project Coordinators are working on updates of all our AWQMS documentation, fact sheets, templates, etc. During the interim period of May - June, you might find that the documentation shows screen shots and refers to previous versions of AWQMS.
Also during the beta-test period the programmers will be deploying tweaks. If you have comments, questions, concerns, or think you have a found a bug please let the CDSN Project Coordinators know so we can communicate with the programming team.
The 2 latest CDSN AWQMS guides are:
(CDSN) AWQMS 4.0 CDSN Fact Sheet: Getting Started Uploading & Analyzing Data (June 15, 2015) (PDF)
(CDSN) CDSN Minimum Data Elements Fact Sheet -- 7/1/2015 (PDF)


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.


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 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



Click HERE to Suggest An Event to add to our Calendar

Upcoming Events --

(Click on an event title for more information)


Recent Presentations --

June 15, 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)




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




© 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