FeaturedDataStories
Analyzing pedestrian crash data in the City of Albany, NY and making pedestrian crash data available state-wide
This featured data story is a two-for. We analyzed the City of Albany's pedestrian crash data using a state-wide dataset FOILed from New York's Department of Transportation covering 2020-2025. We were astounded at what we found; over 600 pedestrian crashes since 2020, 14 pedestrian crash deaths, 111 pedestrian crashes with serious injuries. Where are these crashes taking place? Is the rate of pedestrian crashes going down or up? Do most crashes & deaths happen during the day or night, and on which day of the week? These are questions that we dig into with the data.
Secondly, while our initial story was focused on Albany, we ran all of the same enrichment and data prep processes on the state-wide data. We have posted the all of this state-wide data in GIS and Excel formats. Anyone can use these state-wide datasets for their analysis or for their own data storytelling. These datasets - as with all Tyche Insights content - are available using a Creative Commons license that allows anyone to freely use, share and build upon the data without restrictions.
Our first Finance Decoders from the Hudson Finance Decoder Project
We started the Hudson Finance Decoder Project to help anyone, anywhere create a Finance Decoder. We posted an article describing the first Finance Decoders that have been created and posted. We now have stories that examine local government finances for cities such as Gainesville, FL and Pueblo, CO, and counties like Washoe County, NV.
These stories extend the basic Finance Decoder template to provide additional analysis (e.g. on local government debt), comparisons against neighboring cities, and more.
Wichita, Kansas LandValuePerAcre
One way to examine the utilization and value of the land use in your community is to create a Total Value Per Acre (TVPA) analysis for your town. The idea is that various areas of your city, town or county contribute to the property tax roll at different rates. See this new article on TVPA analysis for Wichita, Kansas.
Sometimes this contribution is obvious; an undeveloped one-acre parcel of land contributes less tax than a one-acre parcel of developed land. Sometimes the contributions are counterintuitive. A 2-acre property with a two million dollar home might contribute less to the property tax roll than if there were 10 0.2 acre houses on the same property.
We like this story for a number of reasons. First, it builds on Strong Towns and their championing of TVPA analysis. Secondly, we laid out a process that explains how anyone can perform similar analysis for their community.
Lastly, TVPA analysis doesn't necessarily get you to an outcome of "this area is good, this area is bad", rather it shows you how land has been built up and used, and what the impact is from an improved value perspective. We want this analysis to inform future decisions that support the next generation of housing development.
Analyzing Albany NY's Crime
Our community member, Adam, analyzed Albany, NY's crime and where it happens as a two-part exploration into the types, trends and locations of crime.
We like this data story for a number of reasons. Crime mapping highlights both where crime happens and, just as importantly, where crime is low - the mapping teased out some areas of high and low crime that weren't intuitive. Adam also built the crime mapping analysis never having done any geospatial work prior. We wrote a short how-to on creating heat maps that supported this analysis.
Lastly, a Criminology professor from our local university read the article and brought us into their classroom to talk to students about our work. While this was an unexpected outcome, it's just what we want to have happen - a data story informs and is used by others.