Automatically generate ICS 209 Incident Status Summary reports by aggregating live data from DuckDB. Resource counts, fire perimeter acreage and containment, flood alerts, and situation narrative are all populated without manual data entry — reducing report preparation time from hours to seconds.
The ICS 209 is a mandatory report filed for all significant incidents managed under ICS. Tactical AI DuckDB automates ICS 209 population by pulling live data from all active public safety services — resource status, fire perimeters, flood gauges, and proactive alerts — and aggregating them into a structured report stored in the ics_situation_reports DuckDB table.
The SITL prepares operational period reports twice daily. Rather than manually querying each section for resource counts and copying fire perimeter data from a separate GIS system, the SITL tells the AI agent: “Generate an ICS 209 for Incident Cedar Creek Complex.” Seconds later, a complete 209 with auto-populated resource counts, acreage, and containment is ready for IC review.
The ICS 209 generator draws from all live DuckDB tables populated by the other public safety services, creating a cross-system snapshot at the time of report generation.
| Report Field | Data Source | DuckDB Table |
|---|---|---|
| Total Resources | Resource Status Board | ics_resource_status |
| Assigned / Available / OOS | Resource Status Board | ics_resource_status |
| Fire Perimeter Acreage | NIFC IRWIN | nifc_fire_perimeters |
| Containment Percentage | NIFC IRWIN | nifc_fire_perimeters |
| Flood Alert Count | USGS NWIS | usgs_gauge_readings |
| Situation Narrative | AI-generated or manual | Auto-composed from aggregated data |
When no manual narrative is provided, the situation report service auto-composes a plain-English narrative summarizing the current incident state, resource utilization, fire perimeter status, and active flood alerts. The narrative follows ICS 209 format conventions and is stored with the report for review and editing.
Generated reports can be exported as a formatted ICS 209-style text document using the export action of the agent tool. The formatted output is suitable for digital transmission to the Operations Section or inclusion in the NIEM IEPD export package.
situation_report