I built The Repair Line: turning small repairs into shared relief

说明与用途

Repair Line 平台聚合小型社区维修，利用 AI 进行评估，Snowflake 存储数据，使居民能够查看并支持当地需求。

问题

Small shared community repairs often lack visibility and coordinated funding, making it hard for residents to identify and support local repair needs.

结果

The Repair Line successfully centralizes small repair requests, provides AI‑generated severity and cost estimates, and tracks community pledges, fostering transparent and efficient local generosity.

工作流

• Choose a city from the location selector
• Browse local repair needs or click "Show all repairs"
• Upload a clear photo of a broken shared item in "Assess a repair"
• Receive AI assessment of severity, plausibility, cost range, and reasoning
• Add the assessed repair to the line and track pledges

证据

The repair assessor accepts a photo and sends it to a server‑side Gemini route. Gemini is asked to return structured JSON with severity, cost, plausibility, and reasoning.

来源

Repair records include the repair title, location, severity, estimated cost, people helped, reason, image, and pledged amount. The Snowflake schema and query layer support feed filters for city, severity, and sorting.

来源