Hacker News Reader

Bencarneiroon I mapped almost every USA traffic death in the 21st century (UPDATED MAP)

Done

Bencarneiroon I mapped almost every USA traffic death in the 21st century

Yes and no- check the new map at roadway.report and toggle the pedestrian view

Bencarneiroon I mapped almost every USA traffic death in the 21st century (UPDATED MAP)

Y'all said to tippefy it. Thanks to hotgarbo for sending an example of how to do this.

Bencarneiroon I mapped almost every USA traffic death in the 21st century

NYC is no longer called flushing in the DB <3 thank you for flagging this

Bencarneiroon I mapped almost every USA traffic death in the 21st century

Data included is specifically 2001/01/01-2023-01-01 if that makes a difference.

Bencarneiroon I mapped almost every USA traffic death in the 21st century

This is very helpful

Bencarneiroon I mapped almost every USA traffic death in the 21st century

The data here is processed from NHTSA's FARS database. When someone dies in an accident, it gets input into a STATE reporting system, and FARS is manufactured by analyzing each state's individual record system. The feds consolidate all this data and publish a unified dataset annually. They say it's "a lot cheaper and just as good as collecting it themselves"

Additional errors are potentially produced from my own processing of the federal data, but those will be rooted out over time. Project being OS will hopefully help with that.

Bencarneiroon I mapped almost every USA traffic death in the 21st century

I need to look into something called NEMSIS, but no not to my knowledge. Most states have injury records though.

Bencarneiroon I mapped almost every USA traffic death in the 21st century

OK holy jeez I think I got the server back up. We now have 8X the ram and I'm not sure how, but we broke postgres....

Bencarneiroon I mapped almost every USA traffic death in the 21st century

Lol ok I'm trying to get home and figure out why it's server error city (yikes)

Bencarneiroon I mapped almost every USA traffic death in the 21st century

It's all from the FARS database

Bencarneiroon I mapped almost every USA traffic death in the 21st century

The best I have right now is place and time to find a specific incident, but yes I should be able to get some basic filters up soon

Bencarneiroon I mapped almost every USA traffic death in the 21st century

Ok I doubled it again wow

Bencarneiroon I mapped almost every USA traffic death in the 21st century

Nhtsa FARS

Bencarneiroon I mapped almost every USA traffic death in the 21st century

Ok y'all I upgraded my linode to twice the RAM. I hope that helps a little with loading