Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Bencarneiro
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
4 ms
·
1.
▲
by
Bencarneiro
2y ago
Done
2.
▲
by
Bencarneiro
2y ago
Yes and no- check the new map at roadway.report and toggle the pedestrian view
3.
▲
by
Bencarneiro
2y ago
Y'all said to tippefy it. Thanks to hotgarbo for sending an example of how to do this.
4.
▲
I mapped almost every USA traffic death in the 21st century (UPDATED MAP)
(roadway.report)
3 points
by
Bencarneiro
2y ago
|
3 comments
5.
▲
by
Bencarneiro
2y ago
NYC is no longer called flushing in the DB <3 thank you for flagging this
6.
▲
by
Bencarneiro
2y ago
Data included is specifically 2001/01/01-2023-01-01 if that makes a difference.
7.
▲
by
Bencarneiro
2y ago
This is very helpful
8.
▲
by
Bencarneiro
2y ago
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 consolidat
9.
▲
by
Bencarneiro
2y ago
I need to look into something called NEMSIS, but no not to my knowledge. Most states have injury records though.
10.
▲
by
Bencarneiro
2y ago
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....
11.
▲
by
Bencarneiro
2y ago
Lol ok I'm trying to get home and figure out why it's server error city (yikes)
12.
▲
by
Bencarneiro
2y ago
It's all from the FARS database
13.
▲
by
Bencarneiro
2y ago
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
14.
▲
by
Bencarneiro
2y ago
Ok I doubled it again wow
15.
▲
by
Bencarneiro
2y ago
Nhtsa FARS
16.
▲
by
Bencarneiro
2y ago
Ok y'all I upgraded my linode to twice the RAM. I hope that helps a little with loading
17.
▲
I mapped almost every USA traffic death in the 21st century
(roadway.report)
734 points
by
Bencarneiro
2y ago
|
442 comments