1 / 9

Central California Air Quality Studies Data Management System

Central California Air Quality Studies Data Management System. Status Report to the Study Agency Policy Committee Sept. 12, 2003. Current Status. Database Contents CCOS Records CRPAQS Records CCOS 97 % of data available SIP Support CRPAQS 90 % of data available Data Analysis Support

abia
Download Presentation

Central California Air Quality Studies Data Management System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Central California Air Quality Studies Data Management System Status Report to the Study Agency Policy Committee Sept. 12, 2003 CCAQS Data Management System

  2. Current Status • Database Contents • CCOS Records • CRPAQS Records • CCOS • 97 % of data available • SIP Support • CRPAQS • 90 % of data available • Data Analysis Support • Outstanding Issues CCAQS Data Management System

  3. Design Based on Past Experience • Remote Data Access Very Important • Most Frequently Missing Data… • e.g. Documentation & “Supporting Information” • Consequences: • Supporting data become unavailable • Results in questionable data points • Post Field Study Documentation Difficult • Associated Loss of Value • $ 0.30-40/ Record CCAQS Data Management System

  4. “Value-Based Design” • System to Store All Valuable Info: • “Place” for Everything Collected • e.g. Instruments & Methods (Field or Lab) • Rigid Data Submittal Standards • Collect Info Up Front in Field Data Submittals • Screen Incoming Files • Automate Quality Assurance • Automate Data Validation from Analysts • Address User Needs Up Front • Bring User Input Into Design Phase • Limit Standard Output Formats • Allow Ad-Hoc Requests via Web Interface CCAQS Data Management System

  5. “Methods & Instruments” Example of Relational Database CCAQS Data Management System

  6. Data Processing File Structures & Internal Processing Data Input Data Output CCAQS Data Management System

  7. CCAQS vs. SARMAP Challenges CCAQS Data Management System

  8. Challenges • Standards • Development Required Iterative Process • Input – • Data Submittal From Contractors • Data Processing • Output – • Data Delivery to Clients • More Time and Effort Than Anticipated • Benefit - Sponsors Will Realize Maximum Value for Data Analysis and Modeling Purposes CCAQS Data Management System

  9. www.arb.ca.gov/airways/ccaqs.htm CCAQS Data Management System

More Related