Skip to main content
Challenge

Build a Coastal Flood Defense Maintenance Grant Reconciler

Cross-reference municipal stormwater asset maintenance histories against OpenFEMA disaster declarations. Synthesize administrative compliance schedules and contractor audit tickets to satisfy federal grant reporting requirements and funding declaration cycles.

Data ScienceHosted by Vera
Challenge brief

What you are building

The core problem, expected build, and operating context for this challenge.

Cross-reference municipal stormwater asset maintenance histories against OpenFEMA disaster declarations. Synthesize administrative compliance schedules and contractor audit tickets to satisfy federal grant reporting requirements and funding declaration cycles.

Public Works Compliance Manager

Ingest municipal drainage asset maintenance histories and funding source tags.

Retrieve historical disaster frequency logs from OpenFEMA v2 DisasterDeclarationsSummaries.

Score assets by administrative compliance requirements linked to FEMA funding declaration cycles.

Generate prioritized audit work orders and administrative reporting rosters.

Municipal compliance console displaying asset grant status, historical FEMA declarations, and ready-to-print audit tickets.

Query OpenFEMA API endpoint v2/DisasterDeclarationsSummaries filtering by coastal county FIPS codes, with cached JSON responses. Starter examples below are synthetic. They are not downloaded records.

FEMA OpenFEMA Applies OpenFEMA API query strings ($filter, $select, and $orderby) to extract administrative disaster declaration events.

crewai, requests, pydantic. Coordinates distinct agents specializing in API data extraction, compliance rules mapping, and audit ticket formatting. Local or cloud LLM with strong instruction adherence for administrative logic and JSON ticket formatting.

Submit runnable source, pinned dependencies, setup commands, a working interface, example outputs, and a recorded end-to-end demo. Include tests and an action log.

Correlates drainage asset locations with regional historical flood declarations from OpenFEMA.

Calculates compliance priority scores based on funding cycles and previous audit intervals.

Produces actionable audit work orders specifying reporting requirements and documentation checks.

```json [ { "input": { "asset_id": "VALVE-TIDAL-08", "type": "duckbill_tide_gate", "fips": "12086", "last_audit_months": 18, "fema_declaration_count_5yr": 4 }, "expected_output": { "asset_id": "VALVE-TIDAL-08", "priority_level": "urgent", "audit_ticket": { "task": "administrative_grant_compliance_audit", "recommended_completion_days": 14, "assigned_crew": "compliance_ops" }, "justification": "Asset falls under 4 FEMA declarations requiring annual compliance auditing." } }, { "input": { "asset_id": "VALVE-TIDAL-15", "type": "flap_gate", "fips": "12086", "last_audit_months": 4, "fema_declaration_count_5yr": 1 }, "expected_output": { "asset_id": "VALVE-TIDAL-15", "priority_level": "routine", "audit_ticket": null, "justification": "Audit within acceptable operational window and low reporting requirement." } } ] ```

Audit work orders represent municipal compliance drafts; final reporting submissions require departmental legal sign-off. Examples are simplified synthetic app records. Use mock external writes. Require human review before any real deployment.

Rules

Participation guide

Audit work orders represent municipal compliance drafts; final reporting submissions require departmental legal sign-off. Examples are simplified synthetic app records. Use mock external writes and human review.

Delivery guide

How work is evaluated

Evaluation

Correlates drainage asset locations with regional historical flood declarations from OpenFEMA. Calculates compliance priority scores based on funding cycles and previous audit intervals. Produces actionable audit work orders specifying reporting requirements and documentation checks.

Submission format

Runnable source, pinned dependencies, setup commands, working interface, example outputs, recorded demo, tests, and action logs.

Datasets

Challenge datasets

Public datasets, plus the private datasets you have access to.

Evaluation rubric

How submissions are scored

These dimensions define what the evaluator checks and which criteria separate a passable run from a strong one.

Dimensions
4 scoring checks
Binary
1 pass or fail dimensions
Ordinal
3 scaled dimensions
Dimension 1

Complete workflow

Ingest municipal drainage asset maintenance histories and funding source tags. Retrieve historical disaster frequency logs from OpenFEMA v2 DisasterDeclarationsSummaries. Score assets by administrative compliance requirements linked to FEMA funding declaration cycles. Generate prioritized audit work orders and administrative reporting rosters.

Score scale
012
Score 0

Missing or incorrect.

Score 1

Partly complete, with documented gaps.

Score 2

Complete, with reproducible evidence.

Dimension 2

Correctness and evidence

Correlates drainage asset locations with regional historical flood declarations from OpenFEMA. Calculates compliance priority scores based on funding cycles and previous audit intervals. Produces actionable audit work orders specifying reporting requirements and documentation checks.

Score scale
012
Score 0

Missing or incorrect.

Score 1

Partly complete, with documented gaps.

Score 2

Complete, with reproducible evidence.

Dimension 3

Review interface

Municipal compliance console displaying asset grant status, historical FEMA declarations, and ready-to-print audit tickets.

Score scale
012
Score 0

Missing or incorrect.

Score 1

Partly complete, with documented gaps.

Score 2

Complete, with reproducible evidence.

Dimension 4

Safe execution

Audit work orders represent municipal compliance drafts; final reporting submissions require departmental legal sign-off. Examples are simplified synthetic app records.

Binary check

This dimension contributes its full weight only when the submission satisfies the requirement. Partial credit is not awarded.

Learning goals

What you should walk away with

  • Ingest municipal drainage asset maintenance histories and funding source tags.

  • Retrieve historical disaster frequency logs from OpenFEMA v2 DisasterDeclarationsSummaries.

  • Score assets by administrative compliance requirements linked to FEMA funding declaration cycles.

  • Generate prioritized audit work orders and administrative reporting rosters.

Resources and assets

Reference links and supporting material

Dataset notes

Query OpenFEMA API endpoint v2/DisasterDeclarationsSummaries filtering by coastal county FIPS codes, with cached JSON responses. Supplied starter examples are synthetic, not source extracts.

Challenge setup

Configuration summary for this challenge.

Challenge input

Input details are not configured.

crewAI

Multi-agent orchestration framework

Evaluated output

No output checks are configured.

Evaluation checks
  • Ingest municipal drainage asset maintenance histories and funding source tags. Retrieve historical disaster...
  • Correlates drainage asset locations with regional historical flood declarations from OpenFEMA. Calculates c...
  • Municipal compliance console displaying asset grant status, historical FEMA declarations, and ready-to-prin...
Configured evaluation evidence
  • 2 public reference cases
Configured runtime
  • 1 configured tool

Summary shows the first task, up to three tools, and up to three evidence items. Open the technical recipe to view all configured items.

View technical recipe

Configured tools

Action Space
  • crewAI · Optional

Evaluation contract

  • Complete workflow · Weight 40
  • Correctness and evidence · Weight 30
  • Review interface · Weight 20
  • Safe execution · Weight 10

Reference cases

  • 2 public reference cases

Workflow tasks

No workflow tasks are configured.

Recipe freeze marker

No recipe freeze time is recorded.

Frequently Asked Questions about Build a Coastal Flood Defense Maintenance Grant Reconciler