The Data Consortium consists of Denver Regional Council of Governments members and regional partners with an interest in geospatial data and collaboration. The Data Consortium newsletter improves communication among local GIS professionals and features updates from all levels of government as they relate to data and geospatial initiatives in our region. This newsletter is published quarterly.
National Renewable Energy Laboratory Uses
DRCOG Building Roofprints to Estimate Energy Savings
Article submitted by Dan Macumber, NREL commercial buildings engineer. Dan can be reached at [email protected]. 

Photo credit: Kenny Gruchalla, NREL
Right: A NREL engineer views building data in 3D.

Researchers at the National Renewable Energy Laboratory in Golden have been generating city- and district-scale energy models based on public data sets including the new building roofprint data from DRCOG. 

NREL's system combines data from multiple public data sources to create individual OpenStudio energy models for specific buildings. For cities with energy data transparency laws, actual energy use of buildings reported through the SEED platform can be used to calibrate the energy models to historic data. Once researchers create an energy model for a particular building they are able to estimate the energy savings of common energy efficiency measures. Doing this at a city scale allows cities and utilities to study the potential effects of energy efficiency programs as they seek to meet aggressive goals for energy and carbon savings. DRCOG's data set allows researchers to customize each building model to a unique building footprint, further reducing uncertainty in the model and improving its predictive capabilities. 

Access to detailed public data, such as DRCOG's building roofprints, will enable NREL to provide more specific recommendations for cost effective energy efficiency upgrades. Public open data can provide a wealth of information and will help NREL improve energy use at a large scale. 

OpenColoradoOpenColorado Upgrades the Data Catalog
Article submitted by Scott Primeau, OpenColorado president. Scott can be reached at 303-877-0009 or [email protected]. 

OpenColorado recently upgraded its data catalog to CKAN version 2.5.2, with the help of Xentity Corporation.

The upgrade brings several functional and performance improvements, such as: 
  • More built-in dataset previews;
  • A more user-friendly look and feel;
  • API access to datasets; 
  • The option to mark datasets as private or public; 
  • Improved dataset authorization under organizations; and
  • Performance improvements.
OpenColorado is also planning more enhancements in the near future, including: 
  • Data catalog analytics;
  • Enhanced dataset views; and
  • Federating data with other data catalogs.
Scott Primeau, OpenColorado president, expressed appreciation to the catalog's data partners for their support and encouragement to continue to improve. Xentity Corporation provided pro bono development support for the upgrade, as well as several other improvements to the OpenColorado data platform. As OpenColorado works toward expanding the data catalog, it welcomes continued input and support from its data partners.
SignalTimingDRCOG Launches New Traffic Signal Timing Briefs Map
Article submitted by Jenny Todd, senior GIS specialist at DRCOG. Jenny can be reached at 303-480-6754 or [email protected]. 

DRCOG's has unveiled a new web map related to traffic signal timing. Through its Transportation Operations Program, DRCOG staff works with member governments to develop and implement capital and signal timing coordination improvements, increasing the ability of jurisdiction staff to maintain reliable operations while decreasing delays at signalized intersections across jurisdictions. The cooperative effort reduces traffic congestion, improves air quality, decreases fuel consumption and improves roadway operations efficiency.

Like DRCOG's other web maps, the Signal Timing Briefs map is built on an open-source stack. DRCOG uses a combination of JavaScript, Leaflet and Bootstrap to develop its maps. Recently, DRCOG has started using the D3 JavaScript library for additional flexibility and enhanced visualizations (the Signal Timing Briefs map uses D3 to draw and filter the GIS data).

The Signal Timing Briefs map shows the projects completed during the last ten years. Users can find summary statistics for each project and link to the project's official timing brief. If a corridor has had multiple projects, users can view the brief for each year the project was conducted. Lastly, when users filter by project year, they can access an annual summary in the lower right-hand corner.

DRCOG staff appreciates comments and feedback on the Signal Timing Briefs map.
BreweriesCentennial Offers a Virtual Tour of Local Breweries
Article submitted by Derek Stertz, GIS and data analytics supervisor at Centennial. Derek can be reached at 303-754-3445 or [email protected]. 

There are five breweries in Centennial --- with more to come --- and the City of Centennial wanted to create an easy, interactive way for residents to discover what's in their own backyard.

The Centennial Virtual Brewery Tour, resulting from collaboration among the city's communications, Geographic Information Systems and economic development departments, takes residents and non-residents on a web-based journey through the breweries and introduces them to the people and ideas behind the local craft-beer industry.

Using an online mapping tool from Esri, the tour pinpoints the exact location of each brewery while displaying (on the same screen) recorded interviews with the brewmasters, behind-the-scenes photos and detailed narratives that provide a glimpse inside the arduous-but-rewarding world of beer-making.

Go to, click on the "Things to Do" tab, then click on "Virtual Brewery Tour" under the "Places To Go" section. Cheers!

YourArticleYour Article Goes Here!

The Denver Regional Data Consortium newsletter is facilitated by DRCOG but written by GIS professionals like you. This quarterly newsletter reaches more than 200 people and has a higher-than-average open rate. It's the perfect place to show off your projects, highlight your great work and contribute ideas to the GIS community in the Denver region.

The next newsletter goes out in January. Please contact Ashley Summers at 303-480-6746 or [email protected] by December to contribute.
ResourcesNew/Updated Resources Available in DRCOG's Regional Data Catalog

Crash Data Points 2013
Open Space 2015
Open Space 2015 (map)
Employment Data 2005-2015
Municipal Boundaries 2016
Unincorporated Areas 2016
Regional Zoning 2015 ---   Check out our latest regional zoning data! It fills in previous gaps including Weld County, Frederick, Brighton, and Sheridan.  More than 3,700 acres of zoning information has been added.
Regional Zoning 2015 (map)
For more information on any of the topics mentioned in this newsletter or if you have an idea for an article, please contact DRCOG Information Systems Manager Ashley Summers at 303-480-6746 or [email protected]

Disclaimer: The information provided in this newsletter is compiled from multiple sources and is intended for informational purposes only.  DRCOG assumes no responsibility or legal liability for the accuracy, completeness or usefulness of any information in this newsletter.