search

jsoma / data-studio-projects

12 stars 18 forks source link

Examining pedestrian fatalities in New York. [Project] #8

Closed JulienAssouline closed 6 years ago

JulienAssouline commented 7 years ago

Please complete all of the following sections, or a robot will spookily dance around your issue! A completed version of this template can be found at https://github.com/jsoma/data-studio-projects/issues/1

Pitch

Summary

This is my first time living in New York, and I've found an unusually high amount of jaywalking in the city. At least more so than any other city I've lived or visited. Examining whether there is a lot of jaywalking can be extremely difficult, however, and simply looking at whether New York has a high rate of jaywalking tickets can be misleading. But, we can examine if New York is a safe place to jaywalk or cross the street in general, by examining accidents involving pedestrians.

Thus far, I've been able to find data on accidents involving pedestrians from NHTSA. From initial analysis, New York has the highest total pedestrian fatalities among cities in the dataset. The dataset also has the information broken down by gender, age, and US state. It also gives information on the driver and pedestrians alcohol levels.

I would also like to be able to map where these accidents are taking place within the city.

Details

**Possible headline(s): Crossing the street in New York City? Better look both ways.

**Data set(s): http://www.nyc.gov/html/dot/html/about/vz_datafeeds.shtml https://crashstats.nhtsa.dot.gov/Api/Public/ViewPublication/812124

**Code repository: https://github.com/JulienAssouline/data-studios-projects/blob/master/code/Project_2/Pedestrian%20fatalities.ipynb

**Possible problems/fears/questions: The two data sets involving geolocation data, and data by city seem to have different results.

Work so far

screen shot 2017-07-17 at 10 37 34 am

Checklist

This checklist must be completed before you submit your draft.

simon-pinkmartini commented 7 years ago

I am curious to see your actual map of the pedestrian accidents. If you manage to correlate this with any jaywalking data, even better. If you don't it's still going to be a good map. You can identify the most dangerous roads, etc.

demetriospogkas commented 7 years ago

Interesting project. Maybe you could compare with car accidents too, and see what is more dangerous? Driving a car or walking up the street? Have you thought about the map geometry, is it going to be points or polygons?

adaskalopoulou commented 7 years ago

Love the subject, I have thought about it when I jaywalk myself. Can you find information for security cameras statistics?

playfairbot commented 7 years ago

Hi! This is the Playfair Bot, checking in on your project.

Please post your project draft! It should be posted by Friday. More details available here. If you posted one but I'm not seeing it, make sure you followed the template.

JulienAssouline commented 7 years ago

Update

I've changed my story angle a little. Basically, yes, New York has the highest number of fatalities, but when you examine it per capita, New York has one of the lowest pedestrian fatalities with populations of 500, 000 or more. The number of pedestrian fatalities and pedestrian injuries has also been trending downward, so it seems as though New York is becoming a safer place for pedestrians.

The US, as a whole, though is not. Since 2009 there's been a sharp increase in the number of pedestrian fatalities. I still need to do some research here, because I'd like to find out why this is happening. What is interesting is that there is basically no correlation between the alcohol level and the number of fatalities. Also, there are way more men pedestrian fatalities than women.

Content

artboard 1 ny_injured_year ny_killed_year us_pedestrians_fatalities screen shot 2017-07-21 at 9 11 49 am

Any changes in direction or topic?

Yes, I've basically changed the angle on the story. I've also decided not to create a map because without having the exact traffic data for where there occurred pedestrian fatalities, it's impossible to get an accurate picture of where in New York it is most dangerous for pedestrians.

Problems/Questions

Why is there a sharp rise in pedestrian fatalities in the US since 2009? I'm going to examine the data per capita, but it would be highly unlikely that there still wouldn't be an upward trend. I also would like to try to find out why this is happening. Any ideas on how I can do this?

I also need to update some of my titles on my graphs. Especially the first one.

https://github.com/JulienAssouline/data-studios-projects/blob/master/code/Project_2/Pedestrian%20fatalities.ipynb

Checklist