Northern Sonoma County Air Pollution Control District 150

Northern Sonoma County Air Pollution Control District 150 Matheson Street Healdsburg, California 95448 (707) 433 -5911 George Erdman Sr. Air Quality Specialist III Jessica De. Primo Air Quality Specialist III gerdman@sonoma-county. org jdeprimo@sonoma-county. org

Data Acquisition & Management Systems: A Small District’s Perspective (or how I became a kid again at 60)

NSCAPCD Monitoring Network • 3 PM 10 Aerometric Sites w/ Met. One BAM 1020 -965’s and Agilaire ESC 8832’s • 1 Ozone Aerometric Site w/ Redundant Teledyne API 400 E Ozone Analyzers and Agilaire ESC 8832’s • 3 DSL Lines w/ CISCO VPN Firewalls • 1 Satellite Link w/ CISCO VPN Firewall • Agilaire Air. Vision© Software on a Virtual Server w/ Separate SQL Database

Agilaire Air. Vision Data Acquisition and Mgt Software Air. Vision Suite (Version 2. 4. 161) with: – BAM Direct Poll Option (Digital) – File Import Configuration Option – ADVP (Advanced Data Validation Program) Option – Parameter Equation Math Pack Option – Precision & Accuracy Reports Option

Why Sample Digitally? • Avoid DAC/ADC Conversion Errors • Data Reliability • Enhanced Instrument Diagnostic Information

Available Digital Parameters for API 400 E Ozone Analyzer

Analog vs. Digital

Use of DMS Data in Instrument Diagnostics API 400 E Daily Zero-Span Drift and O 3 Gen Table Cal Points

Daily Ozone Calibration Email

Graphic Representation of May 7 Zero-Span Note lack of feedback response on ozone concentration

Normal Daily Zero-Span Note beginning concentration level and end concentration level

Real Time Analyzer Manipulation Minute Time Series Graph of O 3 Gen Drive (m. V), O 3 [ppb], and O 3 Gen Ref(m. V) from API 400 E O 3 Gen Cal Data Showing APICOM connected to analyzer for control & Hyperterm open on Real-time Data Display

O 3 Gen Cal Graph from May 8 Note O 3 Gen internal calibration points relative to ambient levels required for precision checks

Digital Data String for BAM 1020 >4 - Display CSV Data Station, 3 Time, Conc(ug/m 3), Qtot(m 3), WS(MPH), WD(DEG), BP(mm. Hg), RH(%), RH( %), AT(C), E, U, M, I, L, R, N, F, P, D, C, T, 05/09/12 08: 00, 16, 0. 834, 3. 17, 136. 48, 753. 5, 19, 56, 19. 5, 0, 0, 0, x Data Column Number 0. 834 , I See Comment L See Comment R See Comment , 753. 5 CHAN 4 User Edit* RH(i) (%) , 19 CHAN 5 User Edit RH(a) (%) , 56 8 9 CHAN 6 User Edit AT (C) , 19. 5 16 17 18 19 20 21 Nozzle Stuck/ Delta-T Over Flow Error Pressure Drop Deviant Membrane Density Count Error Tape Break N F P D C Delimeter # M See Comment Reference Membrane 136. 48 (BP) (mm. Hg) 7 Delimeter # Power Failure 15 Error Flags (WD) (Deg) CHAN 3 User Edit Delimeter # Internal CPU , 6 Delimeter # Maintenance CHAN 2 User Edit Delimeter # 14 3. 17 Delimeter # 13 Delimeter # 12 (WS) (mph) 5 Delimeter # , CHAN 1 User Edit Qtot (m 3) Delimeter # 16 Delimeter # U , Delimeter # E Delimeter # Telemetry Fault Delimeter # External Reset Conc (mg/m 3) I 2 (Fixed) Delimeter # 5/9/2012 8: 00 Data Column Number 10 11 I 1 (Fixed) 4 Parameters Delimeter # Date. Time 3 Delimiter # FIXED Delimiter # , 2 Delimiter # 1 Delimiter # STATION# Delimiter # FIXED 1 T

BAM Data File Import Template: Error Code Parsing

Advanced Data Validation Processor Task: Poll Raw Data from Sites ↓ AV Database Task: Apply ADVP Rules→ Raw Data Flags Null Codes Email Notifications

ADVP Editor

BAM Email Error Messages • • • From: Air. Vision@sonoma-county. org To: George Erdman; Jessica De. Primo; Randall Woodward; Alex Saschin Subject: BAM Error Flag "D" - BAMFLAG_D 5/1/2012 12: 00 - 5/1/2012 13: 00 1 h Date: Tuesday, May 01, 2012 2: 04: 37 PM Importance: High Message: The BAM Station below has recorded an Error Flag "D" The error indicates that the reference membrane span check measurement (m) for that hour was out of agreement with the expected value (ABS) by more than ± 5%. Applying Actions on reading: Healdsburg: BAM 01_PM 10: 001 h at 5/1/2012 12: 00 with value 8 ------ > Annotation Added "Ref Membrane BAM CAL Error; does NOT invalidate hourly data" ------ > Add Flag ? • • • From: Air. Vision@sonoma-county. org To: George Erdman; Jessica De. Primo; Randall Woodward; Alex Saschin Subject: BAM Error Flag "L" - BAMFLAG_L 5/1/2012 13: 00 - 5/1/2012 14: 00 1 h Date: Tuesday, May 01, 2012 3: 04: 33 PM Importance: High Message: The BAM Station below has recorded an Error Flag "L" The error occurs any time power is cycled or lost, even momentarily. See manual Section 6. 5. Applying Actions on reading: Healdsburg: BAM 01_PM 10: 001 h at 5/1/2012 13: 00 with value 985 ------ > Annotation Added "Power Failure Error" ------ > Apply Null Code AV ------ > Add Flag P

Daily Parameter Report

Benefits of Enhanced DAS/DMS • 50% Reduction in Trips to Sites • Estimated 60% Reduction in Data Review and Submittal • Shortened discovery time equipment failures • Reduced data loss from failures • Enhanced Diagnostic Abilities • Remote Operation of Equipment