Database: California Air Quality Data - Selected Data Available for Download

This page last reviewed July 18, 2011  revised 

The California Air Resources Board has released a new DVD-ROM in May 2011 entitled "2011 Air Quality Data DVD" with 30 years of air quality data (1980-2009). For a description of the DVD, go to "California Air Quality Data Available on DVD-ROM". We are providing files in various formats for hourly, daily, and annual data from 1980 to 2009 listed in the file documentation: file11dvd.pdf (pdf - 81k). If you would like to download these ASCII, Dbf, Comma-delimited, ACCESS 2003, or EXCEL files, proceed to the table below. The daily monitor-based PM10 and PM2.5 data are available in both comma-delimited and EXCEL format, and the hourly monitor-based PM10 and PM2.5 data are available in comma-delimited format except for PM10 local conditions (BAM10) which is also available in EXCEL format. Most of the hourly PM10 and PM2.5 files had more records in a year than EXCEL could display, so these EXCEL files were not provided. The product names listed on this page may be registered trademarks.

New: The 1982-2009 NO2 Federal 1-hour Design Values with validity are available for all sites and all years in the downloadable file in the table below.

Errata: There are three executable files for hourly methane (CH4) on the 2011 Air Quality Data DVD which are mislabeled in \Fix_Form\Hourly\, although the data files after extraction are correct. The file "ch419801984.exe" was labeled "ch41980194.exe", "ch419901994.exe" was labeled "ch19901994.exe", and "ch419951999.exe" was labeled "ch19951999.exe." The data files are labeled correctly within the zipped executable files.

Errata posted July 18, 2011: The 2008 NO2 hourly data at Grass Valley-Litton Building (site 3126) had five hours that were less than 0.0005 ppm and slightly negative on the 2011 Air Quality Data DVD. These five hours of 2008 NO2 data were set to 0.000ppm (3/14/2008 start hour 8, 3/14/2008 start hour 9, 4/3/2008 start hour 8, 4/8/2008 start hour 14, and 4/11/2008 start hour 9). The NO2 hourly data on this web site match the 2011 Air Quality Data DVD.

After downloading each data file, double-click on the zipped executable file. The window for the WinZip Self-Extractor will appear: click on the "Browse" button to select the location for storing the file on your hard drive, then click on the "Unzip" button.

For questions about these data, please contact Bob Weller at (916) 322-6158 or Annie Bellinder at (916) 324-6749 or Larry Larsen at (916) 322-3988 or by email at mailto:aqdcd@arb.ca.gov.

CALIFORNIA AIR QUALITY DATA FOR THE YEARS 1980-2009

(Download each zip compressed file separately)

Data Years File Description including: Data

1980-09

2011 Air Quality Data DVD Readme

69K

1980-09

What's New? (2011 Air Quality Data DVD)

9K

1980-09

File Documentation

81K

1980-09

Ambient Air Quality Standard Settings

49K

1980-09

Ambient Air Quality Exceedance Calculations

29K

1980-09

Dbf Documentation

17K

1980-09

Glossary

39K

1994-09

NMOC Data Documentation

9K

1994-09

NMOC Limits of Detection

10K

1990-09

ARB Toxics Documentation

16K

1990-09

ARB Toxics Limits of Detection

42K

2000-09

PM2.5 Speciation Description

15K

2000-09

PM2.5 Chemical Species

6K

1980-09

Useful Internet Hyperlinks

8K

1980-09

BASINS.XLS (Basin Information, Including Basin Letter)

99K

1980-09

PA8.XLS (8-hr Ozone Planning Area Information)

99K

1980-09

LOCATION.XLS (Sites, Air Basins, 8-hr Ozone Planning Areas)

0.25M

80-84 Hrly

Ozone (O3)

14M

85-89 Hrly

Ozone (O3)

17M

90-94 Hrly

Ozone (O3)

22M

95-99 Hrly

Ozone (O3)

26M

00-04 Hrly

Ozone (O3)

26M

05-09 Hrly

Ozone (O3)

25M

80-84 Hrly

Carbon Monoxide (CO)

8.2M

85-89 Hrly

Carbon Monoxide (CO)

8.7M

90-94 Hrly

Carbon Monoxide (CO)

11M

95-99 Hrly

Carbon Monoxide (CO)

12M

00-04 Hrly

Carbon Monoxide (CO)

12M

05-09 Hrly

Carbon Monoxide (CO)

9.3M

80-84 Hrly

Nitric Oxide (NO)

8.0M

85-89 Hrly

Nitric Oxide (NO)

11M

90-94 Hrly

Nitric Oxide (NO)

13M

95-99 Hrly

Nitric Oxide (NO)

15M

00-04 Hrly

Nitric Oxide (NO)

15M

05-09 Hrly

Nitric Oxide (NO)

14M

80-84 Hrly

Nitrogen Dioxide (NO2)

8.0M

85-89 Hrly

Nitrogen Dioxide (NO2)

10M

90-94 Hrly

Nitrogen Dioxide (NO2)

13M

95-99 Hrly

Nitrogen Dioxide (NO2)

16M

00-04 Hrly

Nitrogen Dioxide (NO2)

15M

05-09 Hrly

Nitrogen Dioxide (NO2)

14M

82-09

Nitrogen Dioxide (NO2) Federal 1-hour Design Values  new button 

179K

80-84 Hrly

Oxides of Nitrogen (NOx)

8.6M

85-89 Hrly

Oxides of Nitrogen (NOx)

11M

90-94 Hrly

Oxides of Nitrogen (NOx)

14M

95-99 Hrly

Oxides of Nitrogen (NOx)

17M

00-04 Hrly

Oxides of Nitrogen (NOx)

16M

05-09 Hrly

Oxides of Nitrogen (NOx)

21M

80-84 Hrly

Non-Methane Hydrocarbons (NMHC)

1.4M

85-89 Hrly

Non-Methane Hydrocarbons (NMHC)

0.9M

90-94 Hrly

Non-Methane Hydrocarbons (NMHC)

0.6M

95-99 Hrly

Non-Methane Hydrocarbons (NMHC)

1.5M

00-04 Hrly

Non-Methane Hydrocarbons (NMHC)

1.7M

05-09 Hrly

Non-Methane Hydrocarbons (NMHC)

2.1M

80-84 Hrly

Total Hydrocarbons (THC)

5.3M

85-89 Hrly

Total Hydrocarbons (THC)

5.5M

90-94 Hrly

Total Hydrocarbons (THC)

5.0M

95-99 Hrly

Total Hydrocarbons (THC)

3.6M

00-04 Hrly

Total Hydrocarbons (THC)

1.6M

05-09 Hrly

Total Hydrocarbons (THC)

1.0M

80-84 Hrly

Methane (CH4)

3.0M

85-89 Hrly

Methane (CH4)

3.3M

90-94 Hrly

Methane (CH4)

3.5M

95-99 Hrly

Methane (CH4)

2.5M

00-04 Hrly

Methane (CH4)

1.0M

05-09 Hrly

Methane (CH4)

1.0M

80-84 Hrly

Hydrogen Sulfide (H2S)

0.4M

85-89 Hrly

Hydrogen Sulfide (H2S)

1.0M

90-94 Hrly

Hydrogen Sulfide (H2S)

1.4M

95-99 Hrly

Hydrogen Sulfide (H2S)

1.4M

00-04 Hrly

Hydrogen Sulfide (H2S)

1.5M

05-09 Hrly

Hydrogen Sulfide (H2S)

1.5M

80-84 Hrly

Sulfur Dioxide (SO2)

6.7M

85-89 Hrly

Sulfur Dioxide (SO2)

7.4M

90-94 Hrly

Sulfur Dioxide (SO2)

6.7M

95-99 Hrly

Sulfur Dioxide (SO2)

5.7M

00-04 Hrly

Sulfur Dioxide (SO2)

4.8M

05-09 Hrly

Sulfur Dioxide (SO2)

4.1M

94-09 Hrly

Non-methane Organic Compound (NMOC)

6.3M

94-09 Hrly

Non-methane Organic Compound (NMOC) Access 2003 database

13.1M

80-84 Hrly

Light Scatter (LTSC)

1.7M

85-89 Hrly

Light Scatter (LTSC)

2.3M

90-94 Hrly

Light Scatter (LTSC)

2.3M

95-99 Hrly

Light Scatter (LTSC)

2.1M

00-04 Hrly

Light Scatter (LTSC)

1.0M

05-09 Hrly

Light Scatter (LTSC)

0.4M

80-84 Hrly

Coefficient of Haze (COH)

3.0M

85-89 Hrly

Coefficient of Haze (COH)

2.8M

90-94 Hrly

Coefficient of Haze (COH)

2.8M

95-99 Hrly

Coefficient of Haze (COH)

2.3M

00-04 Hrly

Coefficient of Haze (COH)

1.3M

05-09 Hrly

Coefficient of Haze (COH)

0.2M

1980-09

PM Mass Comma-delimited (daily, hourly)

23M

1980-09

PM Mass (daily, hourly) Access 2003

24M

1983-09

PM Mass in Excel files

17.5M

2000-09 Dly

PM2.5 Speciation Database downloaded from the U.S. EPA Air Qualtiy System

3.5M

1980-09 Dly

Daily Gas Comma-delimited (DLYGAS)

52M

1994-09 Dly

Non-methane Organic Compound 24-hour (NMOC)

2.5M

1980-09 Dly

Daily 8-hr ozone planning area Comma-delimited

22M

1980-09 Dly

Daliy PM Comma Delimited (No PM10 or PM2.5mass data)

6.7M

1980-89 Dly

DLYPM (No PM10 or PM2.5mass data)

3.2M

1990-99 Dly

DLYPM (No PM10 or PM2.5mass data)

3.3M

2000-09 Dly

DLYPM (No PM10 or PM2.5mass data)

2.1M

1988-01 Dly

DLYDICHOT.DBF (Std. Conditions: constituents and mass data)

1.8M

1988-01 Dly

DLYDICHOT (Std. Conditions: constituents and mass data)

1.63M

1990-09 Dly

Daily Toxics from ARB Network (DLYTOXIC.DBF)

1.4M

1990-09 Dly

Daily Toxics from ARB Network (DLYTOXIC ACCESS 2003 DATABASE)

13M

1980-09 Mth

YMONTHLY.DBF (Monthly criteria values - no PM available)

2.0M

1980-09 Mth

YMONTHP8.DBF (Monthly ozone values for site and 8-hr ozone planning areas)

0.4M

1980-09 Mth

Monthly average TSP lead values by site in Excel

0.4M

1980-09 Yrly

YSMULTIC.XLS (Annual criteria for site, county, and basin)

1.9M

1980-09 Yrly

YSMULTP8.DBF (Annual ozone for site and 8-hr ozone planning areas)

0.38M

1980-09 Yrly

TOP4VALU.DBF (Top 4 criteria values)

1.5M

1980-09 Yrly

T4VALPA8.DBF (Top 4 ozone values for site and 8-hr ozone planning areas)

0.51M

1990-09 Yrly

YTOXICS.XLS (Annual toxics from the ARB toxics network) 

1.3M

1980-09

VARIABLE.XLS (Table of variables)

0.2M

1990-09

COMPOUND.XLS (List of toxics compounds)

0.1M

1980-09

YRLYACC2.MDB (Annual and Monthly Access 2003 Database)

16M

California Air Quality Data Available on DVD-ROM

preload