LocalGreens - USDA Farmers Market Locator Web App
Sydney Grignon
Local Greens – USDA Farmers Market Locator
A nationwide farmers market map built with Replit, Supabase, and Mapbox, powered by a custom database I built from raw USDA data.
Local Greens is a web tool that helps people locate USDA verified farmers markets across the United States. The USDA provides raw, messy CSV files, so I cleaned, structured, and rebuilt the entire dataset myself to create a reliable database for the app. The frontend uses an interactive Mapbox interface so users can search by city, state, or zip code and instantly see markets nearby. I designed and built Local Greens to make clean, local food easier to find, with features like favorites, user accounts, and community-submitted updates.
Explore local markets, view details, and save favorites from any device using a simple, intuitive UI.
Features
Custom database built from raw USDA CSV exports
Nationwide map of USDA-verified farmers markets
Search by city, state, or zip code
Save favorite markets
User profiles with Supabase auth
Community “Submit Info” form for corrections
Market detail cards with filters + labeling
Mobile responsive design
Mobile responsive and built for real-world use.
Tech Stack
Local Greens was built on Replit, with Supabase powering authentication, user profiles, and favorites storage. I cleaned and transformed the USDA’s raw CSV data into a structured Supabase database, which the app queries in real time. Mapbox handles geolocation and map rendering, and the frontend is optimized as a lightweight React app for fast performance across devices.
Core features: favorites, search, profiles, and community-submitted info.
Like this project
Posted Dec 9, 2025
Built with React on Replit, using Supabase for auth and data. I converted raw USDA CSVs into a usable database, and Mapbox powers fast, interactive maps.
