This project is an attempt to utilize open source data to create a web app and simple visualization using Ruby on Rails and Javascript. The web app includes a live visualization of the dataset using the jquery-datatables-rails gem as well as bar charts using the chartkick gem. The home page data table includes funcitonality such as pagination, sorting, and fuzzy search.
The datasets used can be found at the links below. The second dataset is used to create a join table so that each bus stop has a list of route names associated with it rather than only route numbers.
After analyzing the data, I realized that there was a bit of cleanup involved to get it to a point where it would be useful. I came up with the schema below and utilized excel's VBA to create a join table csv between the bus stop and routes data. Final datasets can be found in the csv_data directory.
The web app is currently deployed on Heroku. Feel free to take a look!