Data NY

About a year ago I stopped taking the subway for work.  I did this because I couldn't get motivated to get to the gym, and it was the " Summer of Hell " of 2017.  I was totally disgusted with the 30 to 90 minute transit delays turning my crowded-yet-mercifully-short subway commute into the world's worst carnival ride. When I turned in my Metrocard for a Citi-bike membership, I was stunned by the cost savings.  Bike share membership was much cheaper, more efficient, and often more pleasant than taking the subway.  Even after I enrolled in a gym near work just to use the shower (getting over the bridge can be strenuous), my monthly costs were less than $50. Biking, jogging and walking was often faster, healthier, and more pleasant way to get to work. However, my nerve was shaken when I saw a bad bicycle accident.  I had seen a bikers take spills before.  Once I was riding to Queens from Manhattan after work on a summer day, and one biker coming towards me...

One thing I noticed in LIC is there is so much illegal parking.  Almost every time I go for a walk there are trucks parked on the sidewalk loading and unloading, cars parked on the sidewalk, or cars blocking driveways. If it's especially egregious, I will report the situation via 311.  Most times I get a response saying that by the time the police got to the scene the person was gone, but I keep thinking that if I persist the situation will get better. I noticed that 311 publishes their data onto Google BigQuery, so I decided to put together a report to illustrate the problem. As of this October 2018, there were 2500 reports of illegal parking in the neighborhood!  In 1700 of these cases, the parking violation was no longer occurring by the time police arrived or the police took no action.  Only about 500 times did the police resolve the situation or issue a summons to the offending party. On average, there are between 6 and 12 reports of illegal parking each...