Alan Palazzolo is an open-source coder trying to make the world a little better using technology to tell compelling, visual, and data-driven stories.
Big gaps in 911 response
An analysis of more than 70,000 calls shows disparities in response times across the Twin Cities.
Disappearing forests in Minnesota
Exploration and visualization of prediction models of biomes changing in Minesota.
Housing markets in the Twin Cities
Analysis of a decade of housing data across the Twin Cities metro area giving readers a complete picture and ranking of each market in the area.
How high school hockey in Minnesota has changed
Analysis of hundreds of thousands of penalties over almost a decade to show how the game has changed in Minnesota high school hockey.
Live midterm election results
2018 live midterm election results powered by Associated Press and Minnesota Secretary of State via civix.
Denied Justice was a powerful, multi-part series about sexual assult in Minnesota; I was tasked with building the front-end of the interactive video installment.
Minnesota campaign finance in key races
An updating look at how money is flowing to candidates in key races in Minnesota.
Summer camp guide
An interactive, searchable database to help readers find summer camps for their kids and families.
Twin Cities election guide
Address-based lookup to figure out what is on the ballot in the Twin Cities.
Super Bowl guide
A progressive wbe app mini-site showcasing things to do and see in the Twin Cities for visitors that were in town for Super Bowl LII.
Minnesota elections API
A command-line tool that turns data from the Minnesota Secretary of State into JSON files for use as a static API.
Beating the odds
Updating our predictive analysis of how schools may doing better than what is modeled based on free or reduced-price lunch in the school.
A visual explanation of how the 2017 Minneapolis mayoral ranked-choice race was counted and how the winner was determined.
How land use has changed in the Twin Cities
During the 2017 congressional recess, we tracked which representatives were having town hall meetings.
Where they stand
Working with reporters and devs at WNYC and NPR, we quickly surveyed all members of Congress on their stance concerning the travel ban, and created a simple interface to look up your representatives.
For Electionland 2016, I created a small, lightweight interface to explore the firehose of multiple data sources that ElectionLand was gathering information from; this helped the volunteers and reports to triage quickly and get to the most relevant data they needed more efficiently.
tables is a command-line utility aimed at making it easy to get tabular data, large or small, in multiple file formats into a database quickly, while still supporing edge cases and flexibility.
A command line utility, catalog-it provides functions to archive data catalogs. By using something like cron, catalog-it can watch and download and archive every dataset in a data-catalog when it changes, such as New York City's data portal. Currently only works with Socrata data portals.
A browser-based locator map image creator, Locator use browser mapping technologies to allow a user to create custom locator maps, and allows organizations to deploy Locator in a way that is consistent with their organization.
Tik Tok is a front-end library for creating, simple but elegant vertical timelines; designed to be easy but customizable to fit different needs.
Working with reporters we analyzed and presented data that showed how those with housing choice vouchers were more likely to live in high poverty areas as well as mapping to show the growth and concentration of vouhcers.
As part of Infomagical, an engagement project around information overload, I built a back-end SMS system that interacted with 20k users and sent over 100k messages and images, all on a very tight deadline.
NJ toxic sites
As part of the 2016 Art Shanty project, I led a team that built a northern-lights-inspired, solar-powered LED display inside a small shanty on a frozen lake for a month in the Minnesota winter.
In 2016, we updated the popular SchoolBook website that provided an interface to easily search and compare schools in NYC.
Citi Bike deserts
After tracking data from the hundreds of Citi Bike stations, we were able to determine when and where there was consistent empty or full areas around the city.
Working with young artists at Juxstaposition Arts, we created and installed a display near a downtown bus stop in Minneapolis, that showed custom, animated visualizations of buses arriving in real-time.
In 2015, Pope Francis visited New York City, so we turned the word-heavy advisory that the City provided into a map of what and when roads were closed during the visit to help commuters better plan.
Bike lane blockers
Asking listeners to submit their experiences and pictures, we created a map showing where cars, trucks, people, and may other things ended up blocking the bike lanes.
Manually piecing together multiple datasets, we analyzed the schools that had metal detectors and what kind of students ended up going through them.
We did geospatial analysis of AirBnB listings and inpsections of "illegal hotels" in NYC.
We analyzed parks and park access across NYC and found that though the numbers in aggregate are good, access could vary greatly across the city.
NYC stock photos
Our team went out into the city and acted out typical situations one comes across in NYC; we then released the photos under a Creative Commons license on Flickr.
To help determine just how late trains were running across the MTA system, we regulary took snapshots of real-time train data to create the simplified, emoji-based "Subway Agony index".
In the wake of the George Washington Bridge lane closure, a.k.a. Bridgegate, we created an audio and visual walk through of the people involved and their relation to Governor Chris Christie.
After analyzing ticket locations across the city, our team could pinpoint where speeding cameras were and what kind of impact they had.
Working with our state political reporter, we visualized how money flowed through PACs on the Minnesota state level.
MN competitive House districts
Analysis and presentation of political leanings for all state House races in Minnesota.
Lacu is a project we made for Northern Spark 2014 which visualizes 13,817 lakes in Minnesota, two at a time. Lacu ran from sun up to sun down, the span of the event. The plan was to project it on the front of the Northrup Auditorium, but due to weather, we projected it inside the building.
who lives on the green line
After the Green line opened, we visualized the demographics along the new transit line.
Journalism in code
Regularly collecting information from all the journalism organizations on Github, "journalism in code" shows what code is being written across these organizations.
An interactive questionnaire for helping readers narrow their selection for the Hennepin County Commissioner primary.
An hourly-updated look at how the temperatute today, the past week, the past month, and the current season in the Twin Cities compares to the 30-year normal.
Snow emergency locator
A mobile-friendly way to look up if you are parking on the right side of the road during a Snow Emergency in Minneapolis using browser-based location.
Lumière is a personal project where anyone can change the colors of the holiday lights on our house. Designed to be reusable and extended, its architecture is flexible and well-documented.
Visualizing hazardous materials
A visual breakdown of all the hazmat incidents that occurred in Minnesota from 2000 to 2012.
Live elections results
Live election results dashboard utilizing data from the Minnesota Secretary of State.
What did they pass?
A visual look at what the Minnesota State Legislature passed in the 2013 session.
An interactive utilizing Open States to show how key bills are progressing through the Minnesota State Legislature.
An exploration of how the Minnesota State Legislature might turn out after the election.
A Day in the Life of Nice Ride
An animated map showing bike-share trips across the city of Minneapolis.
A personal project showcasing the places I have lived to the tune of an Astronautalis song.
Change by Us (Philly)
Change by Us is civic tool to gather and aggreagte feedback about community concerns.
Explore historical sites in San Diego on this map.