We were inspired by a featured challenge which had the goal of improving public transportation. So, we wanted to create a way for bus stops, and transit stops in general, could be split in an area such as a county. We created a front end website in html and created the actual back end algorithm in python. The algorithm reads a spreadsheet of population census tract data from 2017 which contains the population for every tract of every county of every state in the US. Then, based off user input which specified a state, county, and number of intended bus stops, we allocated a certain number of bus stops to each tract by using ratios of population per tract/total population in the county, which we rounded down. These are the stops that we deemed "necessary." Then, after rounding down, there could be some stops leftover, which we deemed "excess." With those excess, based off the difference between the tract population/county population ratio and the necessary stops/total stops, we gave an extra stop to the tracts with the biggest difference. Then, we output all these values. The biggest challenges we faced were not being able to connect the front end and back end. This alone took hours to resolve. However, with some help from the mentors, we were able to figure it out.

Built With

Share this project:

Updates