Project at a Glance
Title: Development of a pilot air quality and meteorological information system for the greater San Joaquin Valley.
Principal Investigator / Author(s): Fisk, Len
Contractor: California State University, Chico
Contract Number: 93-328
Research Program Area: Atmospheric Processes
Topic Areas: Monitoring
This project was undertaken to address problems in sharing current meteorological and air quality data for the San Joaquin Valley Air Basin. The project assessed the information needs of various agencies and groups in the San Joaquin Valley, including the San Joaquin Valley Unified Air Pollution Control District, the Air Resources Board, the U.S. Forest Service, and others. The project also assessed the availability of various sources of real-time meteorological and air quality data. The needs defined by the study were then used to guide the development of a pilot Air Quality and Meteorological Information System (AQMIS) for the region. The pilot system developed for this project consists of two Internet-connected PCs, both running Windows NT and a body of software developed to acquire and disseminate hourly, real-time, meteorological and air quality data. The project team used Microsoft SQL Server NT, Microsoft Visual C++ and PERL for NT to develop the software necessary to achieve its objectives. The software products include: (1) a scheduler and "data grabber" which acquires real-time meteorological and air quality data on an automated schedule via both "FTP" on the Internet and via modem telephone connections to data loggers and other data sources; (2) translation scripts, written in PERL, that convert the many different data formats that exist at the multiple data sources to the standard, "normalized" data format of the SQL Server relational database and (3) a "run time" meteorological and air quality map builder, written in C and translated to Visual C++, that operates in concert with Microsoft's web server for Windows NT to build both color maps and data tables in response to queries that can be posed via any Internet web browser that is HTML 3 compatible. The pilot AQMIS provides an engine that permits ARB to collect real-time data from a great many disparate data sources and disseminate those data in either graphic or tabular form to any person or organization that has a "web browser." The system, as designed, can be expanded to include a much larger territory.
For questions regarding research reports, contact: Heather Choi at (916) 322-3893
Stay involved, sign up with ARB's Research Email Listserver