Further Analysis

Delving deeper into this analysis I decided to overlay the farmers market locations on top of the bike stations. From there I narrowed my focus by analyzing which bike stations were in close proximity to the Pittsburgh markets.

Of the 23 Farmer's Markets in Pittsburgh, 9 of them are located near a bike station; and of the 52 bike stations, only 15 of them have the potential to serve a local farmer's Market. Personally, I like to use the Healthy Ride Bike station in Shadyside as a means to get to the Bloomfield Farmer's Market on Saturdays. This farmer's market is 9am- 2pm. So I chose to review bikes that traveled too and from this station during that time period. 

In order to gain a better understanding on the possibility and see patterns I took a deeper dive into the analysis of the data pertaining specifically to Bloomfield. I used SQL codes to query the data specific to the Bloomfield bike station (Liberty Ave & S Millvale Ave). Below are a screenshot of the interactive map that shows bikes traveling To the market and those traveling from the market on Saturday. 

I was unable to create a query that narrowed the selection to only those within the time frame of the market, but the data set was relatively small so it was easy to manually do this. 

There are only two days where there is no travel to or from this station- April 1 and May 6. On May 6th the weather dropped from 75 degrees the day before to 47 degrees! We can assume it was a very gloomy day and not one worth biking in, this case is similar on April 1st.