💡 USDA LAMP Grant Application Data Package Generator

[github-actions[bot]]

Summary

Auto-aggregate market operational data (vendor attendance rates, product category diversity, community reach metrics, SNAP participation if available) into USDA Local Agriculture Market Program (LAMP) grant-compatible data packages. Reduces the administrative barrier that prevents eligible markets from applying for $26.8M+ in available federal funding announced March 2026.

Market Signal

USDA announced $26.8M in LAMP grant awards in March 2026 for local food enterprises including farmers markets, roadside stands, agritourism activities, CSA programs, and online sales. Separately, USDA FY 2026 allocated $4M for mobile SNAP payment solutions at farmers markets via cooperative agreements. The Farmers Market Coalition's Metrics program shows demand for structured market performance data, but collection remains manual and annual. Federal funding for market digital infrastructure is at historic highs — and most eligible markets don't apply due to administrative burden.

Sources: USDA LAMP Funding Announcement, FY 2026 Mobile Payments for SNAP, Farmers Market Coalition Metrics

User Signal

Market managers (Maria persona) are the critical enabler role. The app needs to provide direct, tangible value beyond coordination to justify manager adoption. Grant funding is the #1 economic concern for small independent markets. Existing ideas #450 (grant reporting dashboard) and #467 (post-market wrap-up reports) address ongoing compliance reporting — this addresses the upstream application preparation gap that prevents markets from accessing funding in the first place.

Technical Opportunity

The PostgreSQL audit log (append-only, 12-month retention per NFR21-25) already captures the operational data needed for grant metrics: vendor attendance patterns, check-in frequency, product category distributions. The data package generator is a read-only analytics query + PDF/CSV export — no new write paths or data collection required. The Go backend can expose a new GraphQL query for aggregated metrics with date range filtering, consumed by a manager-facing export screen.

Assessment

Dimension	Score	Rationale
Feasibility	med	Requires understanding USDA LAMP grant data requirements and formatting them. The data aggregation queries are straightforward, but the LAMP-specific template design requires domain research.
Impact	high	Directly unlocks federal funding for participating markets. A single successful grant application ($50K-$500K typical) would justify the feature's existence. Creates a powerful manager adoption incentive.
Urgency	high	LAMP grant cycles are annual. Markets that miss the current cycle wait another year. The sooner this feature exists, the sooner managers can leverage it for the next application window.

Adversarial Review

Strongest objection: In early stages, the app won't have enough operational data to generate meaningful grant metrics. Managers may not trust auto-generated reports for federal grant applications.

Rebuttal: The feature starts as a structured data aggregation + USDA-compatible template tool, not an auto-writer. Even with minimal app-generated data, it structures manually-entered data into LAMP-compatible formats. As the app matures, auto-populated metrics become the primary value. The template alone saves managers 10+ hours per grant application cycle. Critically, this is a data export — the manager reviews and submits, never the app directly.

Suggested Next Step

Map USDA LAMP grant application data requirements to the existing audit log schema. Design a manager-facing export flow that generates a pre-formatted data package as PDF + CSV. Validate with 2-3 market managers whether grant application support would influence their platform adoption decision.