🏁 Codegen Speed Trials - Challenge Repo

🚰 What's in our public drinking water? Turn Georgia's cryptic water quality data into something the public, operators, and regulators can actually use.

American's top environmental concern is pollution in their drinking water. The EPA publishes national drinking water data, but it's difficult to interpret, especially for the public or under-resourced rural water systems.

To give you a feel for existing solutions, here's the state of Georgia's official drinker water viewer:

✨ The good news: the Georgia Environmental Protection Division knows the public deserves better! Three weeks ago, they published a Request for Information to overhaul the whole thing.

✅ Your task: Set the water data free. Build a product that ingests real-world raw water quality data and empowers the public and water systems operators to interpret and act on it.

🗂️ What We're Giving You

In the data directory, you'll find a raw export of the public Georgia water system data from SDWIS along with a README packed with helpful context and links. Feel free to augment!

The Georgia RFP wants solutions for three primary stakeholders:

1. The Public: Make it easier for Georgia residents to understand the safety of their drinking water. You could help them better understand what violations mean, the health implications of different contaminants, or take action to stay up-to-date on their local water system.
2. The Operators: Help water system operators view information on their system, track notices from regulators, and take action on compliance tasks.
3. The Regulators: A field kit allowing them to quickly understand the live status of a water system on-the-go on site visits or in meetings. They'll need to drill down into specifics, but high level summaries are helpful too!

Getting Started

1. Fork
   • Fork this repository, you'll include a link to your fork in your submission.
2. Explore:
   • Look through the data directory to understand structure and patterns.
   • Ingest the raw data into a clean, queryable database.
   • Feel free to augment with any additional data you need (e.g. geographic data for mapping)
3. Create:
   • Take Georgia's current offering out of the 2000s.
   • You can build for the Public, the Operators, the Regulators (or all three!).
4. Submit: Instructions below.

Implementation Requirements

• Don't sweat hosting: You can build the whole thing locally and share a live link via ngrok tunnel (or similar) to your localhost:

  brew install ngrok
  # If you don't have one, sign up for a free ngrok account at https://ngrok.com
  ngrok config add-authtoken <your-ngrok-auth-token>
  ngrok http http://localhost:<your-local-server-port>

• BYO stack: As long as you follow the submission instructions, you can take any approach you want — any libraries, any DB, any interface. We will be rewarding bold swings!

⚖️ Judging

Unlike traditional hackathons, the Codegen Speed Trials aren't just about what you build, they're about how you build it. We'll reward participants who take the challenge the furthest, but we're equally excited to celebrate innovative collaborations with AI.

​Projects will be scored across four categories:

1. Core Delivery: Does your submission preserve and accurately represent the data provided?
2. Impact and Relevance: Does your submission improve on Georgia's exising solution for the public, water system operators, regulators (or multiple)?
3. Ambition and Scope: Did you take a big, creative swing at the problem? How far beyond the baseline did you dare to go?
4. Iron Man Score: Did you make creative use of AI tools and agents to get the challenge done?

We have $1000s in cash and credit prizes to award for winning submissions, and are excited to see what you build!

📤 Submission Instructions

Submissions are due by 5 PM. Use this link to submit.

Include the following with your submission:

1. A public link to your forked Github repo

2. 3. A link to a short (< 2 min) video explaining your submission and the tools + approaches you used to build it. We want to hear details on how you accelerated your work using AI!

3. A link via ngrok tunnel (or similar) to your localhost:

   Important: your tunnel will need to remain accessible throughout the entire judging period, which runs from 5-7P PT.

---

Good luck!