Build a Disaster Declaration County Portfolio Tracker

Cross-reference municipal commercial building inventories against historical OpenFEMA disaster declarations to track portfolio inclusion in county-level disaster events. Generate administrative asset dossiers highlighting declared hazard history.

Municipal Climate Resilience Officer

Fetch county disaster history using OpenFEMA DisasterDeclarationsSummaries endpoint filters.

Ingest municipal commercial asset locations and map to corresponding county administrative boundaries.

Tally historical county-level flood declarations during the lifespan of each asset.

Synthesize structured portfolio inclusion profiles and export administrative review dossiers.

CLI tool that ingests asset CSVs and outputs a Markdown administrative dossier.

Download public DisasterDeclarationsSummaries from OpenFEMA API endpoint https://www.fema.gov/api/open/v2/DisasterDeclarationsSummaries with $filter=state eq 'VA' and local synthetic municipal asset county mappings. Starter examples below are synthetic. They are not downloaded records.

FEMA OpenFEMA Queries the OpenFEMA API endpoint v2/DisasterDeclarationsSummaries using $filter with state and incidentType parameters.

pydantic-ai, requests, pandas. Pydantic AI enforces type-safe parsing of FEMA records and structured administrative portfolio exports. Fast hosted model or local small model with reliable structured JSON output support.

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.

Filters OpenFEMA records for matching state, county, and disaster type correctly.

Calculates county declaration inclusion count strictly from matched historical records.

Outputs valid structured JSON containing asset identifier and county declaration tally.

```json [ { "input": { "county": "Fairfax (County)", "state": "VA", "asset_id": "COMM-001", "fema_records": [ { "disasterNumber": 4042, "incidentType": "Flood", "designatedArea": "Fairfax (County)" } ] }, "expected_output": { "asset_id": "COMM-001", "county_exposure_count": 1, "record_type": "simplified synthetic app record" } }, { "input": { "county": "UnknownCounty", "state": "VA", "asset_id": "COMM-002", "fema_records": [] }, "expected_output": { "asset_id": "COMM-002", "county_exposure_count": 0, "record_type": "simplified synthetic app record" } } ] ```

Simulates administrative hazard inclusion scores; produces no real property underwriting or legally binding coverage assessments. Use mock external writes. Require human review before any real deployment.