A Home for Windsor's Tech Community

Winter Hackathon 2017


The University of Windsor’s Computer Science Department and Windsor Hackforge have teamed up for Winter Hackathon. This weekend hackathon will test your skills with creative challenges using data from the community and industry.

The Winter Hackathon is supported by EPICentre, WEtech Alliance, Ontario Centres of Excellence, Ontario Trillium Foundation, Ontario Network of Entrepreneurs, AM Fredericks, CCD, and Microsoft.


  • Each team must send in their presentations before 7:00 AM on Sunday, January 29th or the team will be ineligible to present and win awards. (info@hackf.org)
  • Each team has 5 minutes to present and explain their project
  • Each project must make use of open data
  • Must include a readme file citing which libraries were used
  • All code must be written by a person on your team (no external help!)
  • Each team can have a max of 4 people.

You can use:

  1. Any publically available third party code
  2. Any open data that fits your challenge
  3. Open source boiler plate code


CITY Of Windsor - ApI

City of Windsor – API
Many of the data sets on the City’s Open Data page are simple files to download. In many instances, it may be more useful for someone to be able to make a query and get a subset of the data.
For example, rather than downloading the entire waste collection calendar to see if your recycling is getting picked up this week, it might be easier for an app to call a service with a start date, end date, and the zone your house is in.

Create an API
Take one (or more) of the files that are available on http://www.citywindsor.ca/opendata and create an API for it. For example, download the Service Requests for 2016, and create a web service that allows someone to send a request asking for service requests that have occurred on a certain date or on a certain road.

What the judges are looking for:
Creation of an API that might be used by someone else interested in a subset of the data.
Bonus: create a simple website that uses the API.


Building a web API with Visual Studio 2015

Entity Framework


Visual Studio 2015 https://www.visualstudio.com/downloads/


CITY Of Windsor - Census

City of Windsor – Exploring Census Data
The City of Windsor has recently published open data sets using Statistics Canada census data from 2001, 2006, and 2011 partitioned using the City’s ten electoral ward boundaries and twenty planning districts.
Frequent requests come in to the City of Windsor’s Planning Department by business who want this data when determining things like finding a good location to open a new store based on client demographics.

Explore Census Data
Combine Census Data with any other data set to find a correlation that might be interesting for an organization.
An organization could be a fictitious business, or a non-profit.
Examples might be:

  • For each ward, find the average distance from a residence to the nearest bus stop; or
  • Is there a correlation between average income and voter turnout in each ward?

What the judges are looking for:
Any interesting combination of census data with another data set, along with description of why you found it interesting, and how an organization (real or fictitious) would find this information useful.

Trial version of ArcGIS Pro: www.esri.com



BWE - Paint a picture with data


Bike Windsor Essex (Paint a Picture with Data)
Bike Windsor Essex is a member-based advocacy group working to help make our region safer and more bike friendly. We recently published a community survey with 25 questions about cycling and received over 500 responses.
Now we want to take this data and use it to make decisions, find out what the respondents want/need, influence public policy, answer questions behind the data and tell visual stories that everyone can understand.

The Challenge:
Data visualization should make the complex simple and the abstract tangible. We want you to understand the data then use it to craft the story you want to tell. Your job is to determine the best visual models and details to use for that story. Choose the best graphs, charts and graphics to create a visual representation that your audience can connect to.

What the Judges are Looking For:

  • Large percentage of data used
  • Tell numerous different stories with the data
  • Thinking outside the box, beyond simple line graphs and pie charts…Infographics?
  • Find patterns oer insights may go unnoticed in a data spreadsheet
  • Make the data graphical, colourful and accessible to everyone
  • Choose the right visual for your purpose

Resources & Data Sets Provided For Challenge:
1. Community survey questions asked of survey participants
2. Spreadsheet of answers to community survey



AMF - Risk


AM Fredericks Underwriting Management Ltd. – (Subjectivity of Risk Locations)
“Providing high-risk coverage for over 20 years!”
AMFUM Ltd. was founded by Anthony Fredericks in February of 1993 in Toronto, Ontario.
With over 40 years of Insurance industry experience, Tony has sought to create a skillful underwriting agency, by providing capacity on all classes of Commercial risks, particularly substandard and hard to place accounts.

In this case, Insurance Subjectivity is the physical location of one Risk within a specified distance of another Risk.
For Example: Building A is 20m from Building C. If we provide insurance to Buildings A & C, then the two locations are “Subject” to each other. Building B, which we do not provide insurance for, does not enter into the equation. We have geographic limitations of how much insurance we can provide. Based on a Sample Set of n addresses the task is to create an API that can identify if a net new address is subject to any of the addresses already in the dataset.

  • Existing Addresses need to be geocoded (Adjust database to suit)
  • Subjectivity radius should be variable but default to 30m
  • Collisions will be defined as:
  • Subject to: New Address falls within the 30m radius of existing risks
  • Potential Subjectivity: 30m bubble intersects 30m bubble of existing risk(s)
  • (potentially 60m apart)
  • Not Subject: No collisions of 30m radius circles with any existing risks.

Potential issues:
Invalid addresses (Some in sample set could not be mapped)
Note: Postal Code should be the last resort in mapping as it will override street addresses.
– Address is not well formed: 123 – 125 – 127 Main St., 123 to 127 Main St, etc.
– Postal Code does not match address
– Postal Code is invalid

Building Issues:
– Same Address – Different Risks
– Different Addresses – Same Building
– Large Buildings – Larger than default radius would incorrectly
show no subjectivity

What the judges are looking for:

  • The API should be REST
  • Lookup address should be validated on entry
  • Results should be returned as a Google Map showing searched address and all “subject to” locations.
  • Results should be quantified in a table below the map.
  • A collision of two risks at the same address (1st floor/2nd floor) must be highlighted because the “bubble” for both risks will be exactly the same
  • Speed should always be a consideration. Steps should be taken to reduce the result set should the Database contain Hundreds of Thousands addresses.

Resources, Libraries, & Data Sets For Challenge:

Windsor Addresses

Mapped Version

Addresses that would be subject to sample data
245 or 255 Ouellete Ave | 59 Pitt St E | 1 Maiden Ln W | 1840 Wyandotte St E




Open StreetMaps Locations (AccessLocator)
AccessLocator is a project that involves gathering and sharing accessibility information on locations. We started building a web application and seeded it with a few hundred locations from the Windsor area but we’re hoping to expand that to many 1000’s with the help of some of you this weekend.

The Challenge: Open Data Location Downloader
Develop programs that can download information on as many locations as possible and store them in a simple format such as CSV.

For each location, we want:

  • Minimum:
  • Name
  • Longitude
  • Latitude

Optional Fields:

  • Address
  • Phone Number
  • Associated URL
  • Primary Email Address
  • Categories (Restaurant, Education..)

What We’re Looking for:
We want as much information on each location as possible with priority given to the listed fields.
We want information on many locations. The more records of data, the better chances of winning.

Resources, Libraries, & Data Sets For Challenge
You are free to use any programming languages or libraries you’re comfortable with. Python, Java, and browserless JavaScript should be suitable.
OpenStreetMap is the data source we’re recommending for this challenge.






Open StreetMaps Locations (AccessLocator)
How can residents of the City of Windsor know that something or someplace that they care about is on the upcoming Agenda of City Council?
If that item isn’t reported ahead of time by a news organization, it is usualy only after the matter has been debated and decided that the many residents find out that something that they cared about has already been taken care of.
How can we help the residents of the City of Windsor know what’s coming up at Windsor City Council?

The Challenge:

  • Set up a set of program that will acquire the current agenda of the City of Windsor’s City Council (currently in PDF form) on a weekly basis
  • Create a tweetbot that will tweet out all instances of the word Ojibway that can found in the copy of the City of Windsor Council Agenda with a link to the full agenda

A successful project will

  • Download the pdf or scrape the text in another manner
  • Will search the text for the term Ojibway and will generate text exercpts for context
  • These text exercepts will be then tweeted to a public Twitter account with a link to the original
  • The code of the project will be made available on github or other repository so concerned citizens can set up their own City Council notifications


Inspiration for this challenge:

You can steal Sara Simon’s sewage bot…and everything else she makes



Judges’ Criteria
Problem Solving – How well did they answer the problem or challenge presented? Did they listen to what the organization was looking for? (see below)
Creativity – Did the team “think outside the box?” Is their answer to the challenge something you would not expect?
Use of Data – Did the team make good use of the data? Did they use multiple data sets? Did they only present the data, or is there interpretation as well?
Execution – How well did the team achieve their goals? Is their final product well-polished? Is it functional? How complete is it? What is the degree of difficulty?
X-Factor – Is there something special about how this team worked together? Is their project or presentation “charming?”

Powered by WordPress and Hackforge theme by William Comartin