Blake Hall 

A side project I've been working on: A map of bike and pedestrian collisions in Lexington, KY in 2025: https://projects.blakeshall.com/bike-ped/index.html

Still needs some polish, but it's mostly done. I'm not a designer by any means. Once I have the design pinned down I plan on expanding it to cover more years.

#visionzero #completestreets #urbanism

Lexington Bike/Ped Collisions 2025

An interactive map of all reported 2025 bike and pedestrian collisions in Lexington, KY

Feb 22 at 4:22pmWeb
Show threadFelipe VogelFeb 23

@blakeshall Very cool. How did you get the data? I see the source on the About tab, but I don't see a way to download the data for a county.

The closest I've gotten is http://crashinformationky.org/LocationSearch which shows a table of results, but no download, and results are hidden if the set is too large.

Show threadBlake Hall Feb 23
@fpsvogel You've got to use their Analyze Collision Data section, then in the results you can download as a CSV or just snag the json from the request. It's a pain because it's a clunky search and will sometimes limit how much it returns in one request. But I essentially use County == Fayette, Date in between Jan 1 25...Dec 31 25, and DirAnalysisCode in list of the 2 bike and 2 pedestrian codes.
Show threadBlake Hall Feb 23
@fpsvogel Like this. No idea why 180 was fine this time. The last time I did something like this was for 2023 and I had to break it into multiple queries and stitch the csvs together.
Show threadFelipe VogelFeb 24
@blakeshall Thanks, I'd missed that somehow.
Show threadLexington StreetsweeperFeb 25
@blakeshall This was well received at the Strong Towns Lexington meeting last night.
Show threadBlake Hall Feb 25
@Streetsweeper Any immediate feedback? Someone suggested a 'hide' button for the filters on mobile which I'm working on.
Show threadInform8nFeb 25
@blakeshall we should probably hang out and talk traffic data
https://youtu.be/xexQrZSWCfk?si=0MMPMW9BtYxKFH2E
Lexington KY Collision Data Nerd Nite Lexington 1-10-24

YouTube
Show threadBlake Hall Feb 26
@Inform8n Haha I already watched that! Always up to talk traffic and more specifically traffic calming