ReliefTrace — Aid You Can Actually Verify

Description and use

ReliefTrace delivers a verifiable disaster relief dashboard using real need data, Solana blockchain records, and AI insights.

Problem

During disaster relief, it is hard to trust where need is unmet and whether a donation actually happened.

Outcome

ReliefTrace provides a trustworthy, verifiable dashboard for disaster relief contributions, combining real need data, immutable blockchain records, and AI‑driven insights.

Workflow

• Collect real population data for affected districts
• Apply Sphere Handbook standards to compute water and food needs
• Store need estimates in Snowflake and cache queries in Redis
• When a user logs a contribution, trigger a Solana devnet Memo‑program transaction encoding district, resource, quantity, and donor
• Store the transaction signature in Snowflake and link it as "Verify on‑chain"
• Use Google Gemini to generate a prioritized situation briefing from live data
• Allow users to ask plain‑English questions; Gemini function‑calls the appropriate Snowflake query and returns real numbers
• Provide live SSE updates to the React front‑end
• Export dashboards as PDF and send email confirmations

Evidence

Every contribution fires a Memo-program transaction encoding district, resource, quantity, and donor. The signature is stored back in Snowflake and linked as "Verify on-chain" — a public, tamper-proof record instead of an editable spreadsheet number.

Source

Google AI (Gemini) — Two core integrations, both grounded in live data: (1) an AI Situation Briefing that ranks districts by urgency with confidence scores and specific actions, and (2) "Ask ReliefTrace" — Gemini uses function-calling to decide which live Snowflake query answers your question, then responds with real numbers, not guesses.

Source