Skip to main content
Loading navigation

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

What you are building

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

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.

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

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

How submissions are scored

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

  • 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

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

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

Shows the first task, up to three tools, and up to three evidence 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