Data Consortium Newsletter     

April 15, 2014 

In this Issue
DRCOG Begins Development of Data Portal
The Town of Superior's Virtual Review Process
GeCo in the Rockies
Resilient Colorado and Technical Assistance for the Town of Lyons Flood Recovery
DRAPP 2014 Update
Bike to Work Day
The Latest Census American Community Survey Data
Articles of Interest
Meetings
Contact Us
The Data Consortium consists of DRCOG members and regional partners with an interest in geospatial data and collaboration. The Data Consortium Newsletter is designed to improve 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.
DRCOG Begins Development of Data Portal
Article provided by Ashley Summers, GIS Manager, DRCOG. Ashley can be reached at 303-480-6746 or asummers@drcog.org

In January, DRCOG made a request to members for data. It was our largest such request to date, consolidating requests from across the agency. We asked for all types of data, from jurisdictional boundaries to parcels to land use to bike facilities, among others. During this effort, we noted many areas where improvements could be made, such as 

  • Duplicate requests to jurisdictions due to the size of our contact list;
  • Submission process complicated by varied methods (e.g. email, FTP, snail mail);
  • Manual submission tracking, leaving lots of room for error.

To address these issues, DRCOG recently began developing the Data Portal - an online application for data exchange between DRCOG and its members that makes data collection and distribution easier for everyone. The site is planned to: 

  • Be a "one-stop shop" for uploading and downloading data from DRCOG;
  • Be a secure site that allows transfer of non-public data;
  • Provide one profile per member with multiple, individual logins;
  • Track all transactions of data and supporting files;
  • Track all data agreements/restrictions so you can verify what we have on file.

DRCOG uses this data collected from its members to create regional datasets for planning, forecasting, and modeling regional transportation and development. For example, local data feeds UrbanSim (a land use model) and FOCUS (a transportation model) to create more accurate predictions for the future. We also use local data during Metro Vision scenario planning and DRAPP planning.


We are planning a beta launch this spring/summer. If you would like to be a beta tester, please email asummers@drcog.org.

 

The Town of Superior's Virtual Review Process

Article provided by Lisa Ritchie, Management Analyst, Town of Superior. Lisa can be reached at 303-499-3675, extension 131, or lisar@superiorcolorado.gov.

The Town of Superior has engaged MIG/Winston Associates (MIG) of Boulder, Colorado as a consultant to create and maintain a virtual 3D model of the town. The model is to be used to facilitate conceptual understanding and visualization of proposed development within the context of the Superior Town Center and surrounding area by the Board of Trustees and the public during development review and approval.
 
MIG has designed custom software for real-time simulation that allows users to move freely through the extensive model and view proposed development from any angle. Additionally, it includes tools to help verify accuracy and prove the validity of the model should it be questioned as well as determine the proposed development's visual impacts (including view planes) and measure compliance with regulations.  The Virtual Model was created using LiDAR data obtained from DRCOG, the Town's GIS data, and aerial photography from the DRAPP program.
 
The Virtual Review Process will be used for development approval in the Superior Town Center.  The applicant has the option to prepare a virtual model, with specific requirements, of the proposed building(s), or retain MIG, through the Town, to perform the work. Once MIG has inserted the proposed building(s) into the model, it will be shown in context with the surrounding buildings at public presentations. Trustees, staff, and the public will be able to look at it from various vantage points, drive-by at specific speeds, fly-around, etc.
 
This Virtual Review Process is intended to be a win-win for both the Town and developer. While this additional step is required, it may be equal to or less expensive than developing a separate physical or 3D model. This process will be utilized in upcoming Final Development Plan reviews this coming Spring and Summer 2014.  Over time, the model will build out as the Superior Town Center builds out, to accurately reflect grading, views, structures and landscaping amenities.  For questions on the Virtual Model or the process, please contact Lisa Ritchie with the Town of Superior at 303-499-3675 or lisar@superiorcolorado.gov.

   

GeCo in the Rockies 

Are you looking to showcase your great work, a cool new process, tool, or application? 

 

GeCo in the Rockies can help!

 

GeCo in the Rockies, a collaborative conference between GIS in the Rockies and GeCo West will be held September 22-26, 2014, in beautiful Grand Junction, Colorado.  GeCo in the Rockies will be the premier geospatial technology and information event of 2014.  You have an opportunity to be a part of this event.  Join us as a presenter! 
 
You are invited to share your professional geospatial knowledge, experience, and accomplishments at a technical session or with a poster display.  Abstracts are being accepted now. Details can be found at http://www.gecointherockies.org/abstractsubmissionThe abstract deadline is May 2. 
 
The GeCo in the Rockies Planning Committee looks forward to seeing you in Grand Junction! 

 

Resilient Colorado and Technical Assistance for the City of Lyons Flood Recovery
Resilient Colorado and Technical Assistance for the Town of Lyons Flood Recovery is an initiative of the University of Colorado Denver College of Architecture and Planning to assist Colorado communities recovering from the September 2013 floods.  The initiative connects faculty and staff experience, student passion, and communities to facilitate recovery and contribute to a more resilient Colorado.
  
The departments of Planning and Design, and Geography and Environmental Sciences at University of Colorado Denver (UCD) have begun work with the Town of Lyons to provide technical assistance during its flood recovery planning process. Over the past 12 weeks, the Town of Lyons has been conducting weekly meetings with recovery working groups.  At the end of this process, the town will have a recovery action plan, and UCD will have contributed maps and analysis for the planning process, with a polished 30-40 page planning document expected by May.  Engagement will continue in the summer with a field studio on housing development in Lyons, and Resilient Colorado will be a multi-year engagement with Lyons.
  
Several instructors in both the Planning and Design, and Geography & Environmental Sciences departments agreed to help provide assistance when possible, including the production of the draft recovery plan, data, and GIS-driven maps.  The objective is to provide students with the opportunity to work with a real-world client on a current relevant project, while simultaneously providing the Town of Lyons with professional and technical resources not normally accessible.
  
Data sources for this collaboration are being provided by Digital Globe , FEMA, DOLA, Boulder County, DRCOG, RTD, and USDA, among others.  Digital Globe, in particular, generously provided a package of high-resolution panchromatic and multispectral satellite imagery covering the recovery area for before, during, and after the flood for our analyses. 
  
In addition, students and faculty have participated in volunteer recovery efforts in the Town of Lyons, working alongside residents and meeting with the Town Administrator for a tour of the town and discussion of the challenges the recovery process in Lyons faces over the next few years.
DRAPP 2014 Update
Article provided by Ashley Summers, GIS Manager, DRCOG. Ashley can be reached at 303-480-6746 or asummers@drcog.org

Today marks the end of the spring flight window! Kucera International, Inc. successfully completed flights in Denver Metro, the eastern plains, and Weld County. The interim data is currently being reviewed and delivered to our data acceptance testing (DAT) and web map service (WMS) vendor, IntraSearch. Partners are expected to receive WMS access to the interim imagery in May.

 

The last deadline for participation is fast approaching. If you are interested in being a DRAPP 2014 partner but have not yet received a quote or submitted all your paperwork, contact the Project Manager Ashley Summers ASAP!

 

Save the Date! The next DRAPP meeting will occur on April 24th at 10 a.m. at DRCOG. For more information, contact Ashley Summers at 303-480-6746 or asummers@drcog.org.

Bike to Work Day

Article provided by Christine Connally, GIS Analyst, DRCOG and Catherine Sanders, Regional TDM Program Sales Specialist, DRCOG. Christine can be reached at 303-480-6717 or cconnally@drcog.org. Catherine can be reached at 303-480-6757 or csanders@drcog.org.

Bike to Work Day is held each year in Colorado on the fourth Wednesday in June: this year's event is June 25.  Bike to Work Day is an extraordinary community event because of the 150+ stations throughout the region, which serve free food and beverage to cyclists on Bike to Work Day. Bike to Work Day stations are organized by volunteers - companies, non-profits, and partnerships.  DRCOG's Way to Go program, which organizes Bike to Work Day, is always looking for new stations, especially in under-served areas.  If you would be interested in organizing a breakfast station or afternoon water aid station, please visit http://waytogo.org/biketowork for more information, or contact btwd@drcog.org.

 

The latest Census American Community Survey data
Article provided by Josh Pendleton, GIS Specialist, DRCOG. Josh can be reached at 303-480-6784 or jpendleton@drcog.org
The latest Census American Community Survey data has been released recently, and DRCOG has added selected tables to our Regional Data Catalog. Listed below are the tables available in .csv format, at the Block Group, Place, and Tract levels. 

2012 ACS 5 Year Survey - Block Group Level Data, Colorado

Assorted ACS Data from tables at the Census Block Group Level
B01001 - SEX BY AGE
B01003 - TOTAL POPULATION
B11005 - HOUSEHOLDS BY PRESENCE OF PEOPLE UNDER 18 YEARS BY HOUSEHOLD TYPE
B11016 - HOUSEHOLD TYPE BY HOUSEHOLD SIZE
B19101 - FAMILY INCOME IN THE PAST 12 MONTHS (IN 2010 INFLATION-ADJUSTED DOLLARS)
B25001 - HOUSING UNITS
B25003 - TENURE
B25024 - UNITS IN STRUCTURE
Download - http://gis.drcog.org/datacatalog/node/305

2012 ACS 5 Year Survey - Place Level Data, Colorado

Assorted ACS Data from tables at the Census Designated Place Level
B08013 - AGGREGATE TRAVEL TIME TO WORK (IN MINUTES) OF WORKERS BY SEX
B08101 - MEANS OF TRANSPORTATION TO WORK BY AGE
Download - http://gis.drcog.org/datacatalog/node/304
 
2012 ACS 5 Year Survey - Tract Level Data, Colorado (Table 1)

Assorted ACS Data from tables at the Census Tract Level - Table 1
B08013 - AGGREGATE TRAVEL TIME TO WORK (IN MINUTES) OF WORKERS BY SEX
B08101 - MEANS OF TRANSPORTATION TO WORK BY AGE
B08201 - HOUSEHOLD SIZE BY VEHICLES AVAILABLE
B08202 - HOUSEHOLD SIZE BY NUMBER OF WORKERS IN HOUSEHOLD
B17001 - POVERTY STATUS IN THE PAST 12 MONTHS BY SEX BY AGE
B19080 - HOUSEHOLD INCOME QUINTILE UPPER LIMITS
B19081 - MEAN HOUSEHOLD INCOME OF QUINTILES
B19082 - SHARES OF AGGREGATE HOUSEHOLD INCOME BY QUINTILE
B19101 - FAMILY INCOME IN THE PAST 12 MONTHS (IN 2010 INFLATION-ADJUSTED DOLLARS)
Download - http://gis.drcog.org/datacatalog/node/306
 
2012 ACS 5 Year Survey - Tract Level Data, Colorado (Table 2)

Assorted ACS Data from tables at the Census Tract Level- Table 2
B04001 - FIRST ANCESTRY REPORTED
B07001 - GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY AGE FOR CURRENT RESIDENCE IN THE UNITED STATES
Download - http://gis.drcog.org/datacatalog/node/307
 
2012 ACS 5 Year Survey Metadata

A description of each census ACS table included in the above 4 tables, and each column within those census acs tables.  For example, column B01001_1 in one of the above 4 tables is Table B01001, Line 1, in the metadata; and so on.  
Download - http://gis.drcog.org/datacatalog/node/303
 
With each of these tables, the GEOID10 field is the linkable geographic unique id that links to the GEOID10 field in the Census 2010 Tract, Block Group, and Designated Place geographic datasets already available in the Regional Data Catalog.  
Tracts (Census 2010) - Download - http://gis.drcog.org/datacatalog/content/tracts-census-2010
Block Groups (Census 2010) - Download -  http://gis.drcog.org/datacatalog/content/block-groups-census-2010
Census Designated Places (Census 2010) - Download -  http://gis.drcog.org/datacatalog/content/census-designated-places-census-2010
 
Articles of Interest
  
Meetings
Upcoming DRAPP meeting - 4/24
Upcoming DRDC meeting - 6/26
Contact Us
For more information on any of the topics mentioned in this newsletter or if you have an idea for an article, please contact DRCOG GIS Manager Ashley Summers at 303-480-6746 or asummers@drcog.org
  
  
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.