Go Code Colorado is a state-wide event to innovate on top of Colorado open data. Android Atelier went to Challenge Weekend in Fort Collins.
We look like a team who might have a business plan. #gocodeco @chiuki @KellyShuster @kenodoggy pic.twitter.com/yZyu4bLFrP
— Sepideh (@sepzilla) April 2, 2016
Preparation
We wanted to use CartoDB to visualize the geo data on the map, so we went to Maptime Boulder to learn about it.
Learning CartoDB from @geobill1 at @MaptimeBoulder in preparation for @GoCodeColorado pic.twitter.com/ed57nubWsG
— Chiu-Ki Chan (@chiuki) April 1, 2016
Also, I baked cookies.
I baked cookies for #GoCodeFoCo pic.twitter.com/jV8szGuvy5
— Chiu-Ki Chan (@chiuki) April 2, 2016
Data
How are we going to create value? By showing multiple sets of data on the same map.
The different layers made it very easy to parallelize the work. We looked at different data sets and scrubbed the geo data to put it on the map.
Forgot to post this yesterday: We were working intensely! #gocodefoco pic.twitter.com/hXNLUaJGZe
— Chiu-Ki Chan (@chiuki) April 3, 2016
Here is our working demo:
Presentation
Go Code Colorado 2016 centers around the problem statement:
Create an app and business concept that helps businesses build a competitive strategy.
Our app shows agricultural, demographics and logistics data allowing businesses decide where to set up shop. Here is our presentation:
Winners
Two teams advances per location to the final round.
SWO
Celebrating with my awesome team mates on SWO! We're going to the finals in Denver in May. #gocodefoco https://t.co/iojoS5baCE
— Gretchen Kastetter (@gretchenlynd) April 4, 2016
SWO, or Shop Women Owned, crosses the Colorado business entities with the Social Security Number gender data to showcase women-owned businesses in Colorado. They had a great pitch, and made us realize that we were taking the problem statement too literally.
At the end of the day, this is a business pitch competition. Helping businesses build a competitive strategy (Where will I play? How will I win? Is it worth it?) was not a hard requirement. As long as public data is used, any business plan is fine. In this case, SWO promotes women-owned businesses in bulk, without necessarily helping them build a competitive strategy individually.
Colorado Well Spot
Colorado Well Spot aggregates public data to help oil and gas companies figure out where they should operate. You would think that they would check and make sure not to drill too close to a school, or right of top of a pipeline. Turns out the data is scattered all over the place, and there is not really a good way to do a comprehensive check.
Emily Hueni, the leader of the team, is a GIS specialist with oil and gas experience, and really understands the problem. Once she started talking about the app, we knew they were going to win!
CartoDB
CartoDB is really nice. I like how I can extrapolate from my existing knowledge of SQL and CSS to customize my map. Even though we did not win, we had lots of fun exploring and visualizing the data.