# Presentation: 739292

##  AQS Development and Enhancement Plans

- AQS CONFERENCE
- Jake Summers
- August 20, 2008

## AQS Development/ Enhancement Plans 

- System Status
- Development Plan
- Data Improvements
- Software Implemented
- Active Development

## System Status

- Operational for over 6 years
- Average of 7.9 million values per month
- For July 2008
- 1724 Files loaded with 11 million values
- 148 users from 119 agencies
- 1 to 1,100,538 records
- 1300 files with 1 to 3 months data
- 1186 with no errors (69 %)
- 963 Post jobs

## System Status

- Agencies reporting data (screening groups)
- State – 55 (no change)
- Local – 44 (increase of 4)
- Tribe – 74  (increase of 5)
- Other -8 (no change)
- About 4,859 retrievals (30 different reports) by 268 users in July 2008
- Usage order AMP350, 501, 450,  430 – 70 %
- 631 Active registered users
- 121 new users in last year

## System Status

- Raw Data
- Archive - 1957 to 1992
- Production - 1993 to 2008 (years updatable?)
- Production - 1.04 billion rows in raw data table
- 10 % increase from last year
- Mature System
- AQS Disaster Recovery operational
- Tested this month
- AQS Data Mart operational

## Development Plan

- Funded
- Operation and Maintenance
- Software bug resolution
- Disaster recovery
- PM2.5 NAAQS Changes
- Combine collocated monitors
- Revised standard value
- Implement new CBSA Definitions
- Site Level Design Value Report
- Ozone, PM2.5

## Development Plan

- Funded
- Modify AMP255 for regulation changes
- Exceptional Event Rule
- Data flags redefined
- Report for flagged data
- Revised summary processing
- AQI for PM2.5

## Development Plan 

- 2009 Budget Request
- Funding Expected
- Operation and Maintenance
- Implement revised NAAQS for lead
- Risk Assessment
- Funding Uncertain
- Exchange Network Load Change
- Calculate PM10  (STP) from PM10 (LC)

## Data Improvements

- IMPROVE Data – Years 2005 to 2006
- Update WEB files quarterly by year for criteria parameters and speciation, added continuous PM2.5 data
- PM2.5 parameter changes
- Continuous & speciation
- All changed including P & A Data
- Continuous Monitors Closed

## Software Implemented

- AQS Geospatial Processing - 08/2007
- Standard coordinates & datum – WGS84
- Derive data elements based on coordinates
- Goal to convert all existing site coordinates
- User assistance provided
- Discoverer query documented to assist
- Offered to perform update

## Software Implemented

- AQS Geospatial Processing
- Current database status
- All sites - 7,064 of 19,218 (37%) converted
- Active sites – 1,343 of 4,842 (28%) converted
- Other users - 1,392  of 7,064 (20%) converted
- States converted– MA, VT, NJ, PA, WV, AL, NC, SC, TN, IL, MI, MN, TX, CO, AZ

## Software Implemented

- Part 58 Appendix A revisions – 08/2007
- Applicable January 1, 2007
- Precision/Bias Calculations
- PQAO  - Primary Quality Assurance Org. required for _all_ monitors by OAQPS QA team– derived from current reporting organization (RO) or RO consolidation  (57 not resolved)
- RO consolidation – reduces  collocation monitors required

## Software Implemented

- Data Completeness report option – 12/2007
- Use PQAO or Reporting Organization (default)
- New Report – BenMAP Raw Data File
- Standard retrieval
- Delimited record with year of data – long
- Standard units, no qualifiers included
- Implement new ozone NAAQS – 05/2008
- Averages all recomputed
- AQI values updated

## Active Development

- Combining collocated PM2.5 data values
- Near completion
- Primary monitor -new user input – Maintain Site
- Initial primary monitor designation
- Lowest POC and lowest required sampling frequency
- Will require QA when available
- New report – AMP355
- Lists combined values
- Standard report process

## Maintain Site

*Maintain Site*

## New Report - AMP355

## Active Development

- Implement new CBSA/CSA Definitions
- Near Completion
- Combined Statistical Area replaces CMSA
- Core Based Statistical Area replaces MSA
- Metropolitan Statistical Area
- Micropolitan Statistical Area
- Derived because  follow county boundaries

## Active Development

- Implement new CBSA/CSA Definitions
- Input process for monitoring objective
- Retrieval process will use new codes
- Reports will use new codes
- Report header
- Work files

## Monitoring Objective

## Retrieval Process	

## Active Development

- PM2.5 Summary Re-compute
- Ready to begin development
- New short term standard
- Individual monitors
- Uses combined monitor records
- Revised definitions

## Active Development	

- Finalizing Design Specifications
- Exceptional Event Rule Implementation – to be discussed Thursday
- Design Value Report – to be discussed next
- AMP255 Revisions – to be discussed Friday