
Air Quality Data Analysis & Regulatory Reporting
Process air quality monitoring data and generate EPA-compliant regulatory reports
What You Can Do
You can process raw hourly or daily air quality monitoring data from multiple pollutants (PM2.5, PM10, O3, NO2, SO2, CO), apply EPA-compliant statistical methods, calculate AQI values, identify NAAQS exceedances, and generate regulatory-grade reports ready for state environmental agency submission and EPA archival systems. The skill ensures adherence to Reference and Equivalent Methods (REM), Quality Assurance/Quality Control (QA/QC) protocols, and flags data quality issues automatically.
Features
process PM2.5, PM10, O3, NO2, SO2, CO datasets with appropriate statistical methods for each parameter
compute air quality index values for public dissemination and identify seasonal or annual trends
automatically flag violations of National Ambient Air Quality Standards with supporting documentation
assess data completeness, identify outliers, validate missing data protocols, and document quality flags
detect significant events with statistical confidence and prepare for source attribution analysis
generate submission-ready documentation for CASTNET, AirNow, and state regulatory agency requirements
quantify effectiveness of control measures through comparative concentration analysis
benchmark monitored data against predictive model outputs with statistical concordance testing
Example Output
Example 1: AQI Report Output
- Daily AQI Summary (PM2.5 focus): 145 (Unhealthy for Sensitive Groups)
- Exceedance Alert: 2024-03-15 PM2.5 = 42 µg/m³ (NAAQS = 35 µg/m³)
- Contributing pollutant breakdown with confidence intervals
- QA/QC notes: 3 missing hours, interpolated using EPA Method 5
Example 2: Regulatory Report Section
- Statistical Summary Table (mean, median, 98th percentile, max)
- Compliance Status: 1 exceedance in quarter (0.3% non-compliance)
- Data Completeness: 98.7% (exceeds 90% EPA minimum)
- Reference Method validation passed; quality flags documented
Example 3: Pollution Episode Analysis
- Episode Duration: 48-hour event 2024-02-18 to 2024-02-20
- Peak concentration: 89 µg/m³ O3 (standard = 70 ppb 8-hour)
- Meteorological conditions summary (wind speed, temperature inversion)
- Preliminary source sector analysis with uncertainty bounds
What's Included
- SKILL.md: Complete instruction file with EPA compliance frameworks and statistical protocols
- EPA NAAQS Reference Standards Template: Current federal ambient air quality standards for all criteria pollutants
- AQI Calculation Worksheet: Step-by-step methodology with breakpoint tables and index conversion formula
- QA/QC Validation Checklist: Data completeness assessment, outlier detection protocols, and EPA Method 5 missing data procedures
- Regulatory Report Template: EPA-compliant section structure with required statistical summaries and compliance determinations
Who It's For
- Air Quality Scientists — analyzing monitoring data and identifying compliance issues
- Environmental Compliance Officers — preparing regulatory submissions and documentation for EPA/state reviews
- State Environmental Agency Staff — managing network data, calculating AQI, and publishing public air quality reports
- Environmental Consultants — evaluating emissions control effectiveness and air quality trends for clients
- Air Quality Modelers — validating model predictions against observed monitoring data with statistical rigor
Best For
- Processing raw hourly/daily monitoring data from fixed or mobile stations
- Calculating AQI values for public dissemination and health advisories
- Identifying NAAQS exceedances and flagging compliance violations
- Preparing quarterly and annual EPA regulatory submissions
- Analyzing pollution episodes for source attribution and control measure evaluation
- Conducting QA/QC validation and missing data assessment







