Dashboard for mapping and visualization of bail bond data
SaaS // GIS // Maps & Cartograph // Data Visualization  //  Web Development // 0 to 1
Role:
Researcher/ UX Designer responsible for Research, Analysis, Interface Design, Prototyping
Timeline:
Sep. 2023- May 2024
Team:
Center for Spatial Research
Tool:
Figma
QGIS
D3.js
Mapbox.GLJS
Project Overview
This project is a collaboration between Center for Spatial Research and  Columbia Law School- Cities of Bail. Our work is to design and build a interactive data visualization website for showing bail bonds over 20 years in 5 American cities. The visualization is to investigate how bail bonds affect the make up of American communities, and find which communities are targeted by bail companies.
problem statement
How to cross reference two datasets and visualize 20 years trend and generate insights?
Target audiences
This dashboard serves researchers, advocacy groups, and community boards, helping non-technical users spot patterns and identify areas with severe bail bond issues.
Researchers
Advocacy groups
Community boards
User Flow
I interviewed target users and mapped their workflows: comparing bail bond and socio-economic data by census tract, identifying high-need areas, and creating reports to support legal reform advocacy.
Dissect DATA STRACUTURE
Before designing, I analyzed the two main datasets: (1) bail bond data at the individual case level with attributes like amount, duration, and status; (2) socio-economic data at the census tract level with race and income. This highlighted the need for data wrangling to unify them and thoughtful visualization of both numerical and categorical attributes.
DESIGN PRINCIPLES
After auditing other data visualization dashboards, I developed these three design principles to guide the work.
All in One
All features and charts are integrated into a single page, reducing the need to navigate across multiple interfaces.
Interconnected
The control panels, maps, and charts are interconnected—interacting with one element updates the others seamlessly.
Customizable
Users can tailor data visualizations to fit their specific needs, enabling a flexible and personalized experience.
Design challenge #1
How to compare two datasets, find their relationships, and identify key data points for deeper analysis?
Compare in maps
I explored different ways to compare the two datasets to help users identify areas with severe financial burden and bail bond issues—such as overlaying visualizations, placing two maps side by side, or integrating them into a bivariate map for clearer insights.
I used Mapbox Studio to test colors, text contrast, and transparency, ensuring clear layouts and accessible visualizations.
To improve accessibility, I optimized map colors for contrast and tested them against four types of color blindness: Protanopia, Deuteranopia, Tritanopia, and Achromatopsia, ensuring  critical elements stayed readable.
Compare in charts
Beyond mapping the datasets at the geolocation level, I designed and tested chart-based visualizations—using common comparison practices like grouped bar charts and scatter plots.
To address overplotting with 406 data points and labels, I tested reducing label size, highlighting key labels, and hiding all labels to show on hover.
Design solution showcase #1
Users can toggle the socio-economic background layer, click ‘Compare’ to switch the map to a bivariate view with a comparison panel showing a scatter plot. They can quickly spot high-need areas, click for details, and download a templated report or data.
Design challenge #2
How to compare two types of attributes (categorical and numerical) in a dataset?
Another challenge was visualizing both numerical attributes (e.g., amount) and a key categorical attribute (bond status: released, foreclosed, pending). Users often want to focus on foreclosed bonds, so I explored solutions like filter toggle (hide/show) and adding a dimension using different icon shapes.
Design solution showcase #2
Users can hover over the pie chart to explore different bond statuses, with the map dynamically updating to show their locations and counts.
Design challenge #3
How to visualize the trend of data across 20 years?
To show trends in bond data over the past 20 years, I explored different visualizations, including grouped bar charts and Sankey diagrams.
Design solution showcase #3
Users can toggle between overview and detail directly within the timeline chart panel on the same dashboard page. In the detail view, a Sankey diagram shows data flows and trends without navigating to other pages.