03 / web app
A nationwide farmers market map built from raw USDA data, designed to make local food easier to find.
Local Greens began as an exploration of how public datasets can become useful tools.
The USDA publishes a national farmers market directory, but the raw data is difficult to navigate and inconsistent in structure. The goal was to transform that dataset into a clean, searchable experience that helps people locate verified farmers markets nearby.
The project began by cleaning and restructuring the USDA's raw CSV files into a reliable database.
Once the data was normalized, the interface was designed around a simple interaction: search by location and immediately see nearby markets.
The experience centers on clarity and accessibility, allowing people to quickly understand what markets exist near them.
The application was built as a lightweight web app with a Mapbox interface for geolocation and map rendering.
Supabase powers authentication, user profiles, and favorites storage. The cleaned USDA dataset was transformed into a structured Supabase database that the app queries in real time.
A simple, practical tool that transforms a messy public dataset into an intuitive way to discover local food.