Jump to main content.

About Exporting Report Data

What is exporting?

AirData reports can create a text file containing all the data displayed in a report. Other software, such as spreadsheets and databases, can read a data file created by AirData. This gives you the opportunity to use your own software to analyze or rearrange the data in ways that AirData does not. Exporting data is the term we use for creating a file of AirData report data.

What does an export file contain?

Export files contain plain text. There are no "binary" values.

The first dozen or so lines of a file describe what it contains. Each of these lines begins with an asterisk (*). The remaining lines of a file contain the data displayed in an AirData report. The file has one line of data for each row of the report. The data file has the same order of columns and rows as the report.

Within a line of data, values (columns) are separated from each other with either a comma or a tab character, depending on which type of export file you chose. There is no delimiter character after the last value in a line. When the delimiter is comma, character values are enclosed in double-quotes (") and numeric values are not. When the delimiter is tab, neither character nor numeric values are enclosed in quotes.

Here is an example of an export file:

* US EPA - AIRData NET Count Report
* Wednesday, 7-Mar-2001 at 10:19:29 AM (USA Eastern time zone) 
* Delaware NET Air Pollution Point Sources - Carbon Monoxide
* Pollutant Emissions In Tons Per Year
* File Size  : 3 Rows
* File Format: CSV - Comma Separated Values
* Field  1: Region
* Field  2: State
* Field  3: County
* Field  4: Number of Facilities
* Field  5: Percent of Total Facilities
* Field  6: Pollutant Emissions
* Field  7: Percent of Total Emissions
"3","DE","Sussex Co",6,12.50,417,2.64
"3","DE","Kent Co",8,16.67,110,0.70
"3","DE","New Castle Co",34,70.83,15299,96.67

How do I create an export file?

At the bottom of every report page, AirData displays two buttons that allow you to create an export file containing the same data included in the report. The buttons look like this:

Click on the button labeled with the delimiter you wish to have in the data file. It does not matter which page of a report you are viewing. The export file will include all rows and columns of the entire report.

How do I save an export file on my PC?

What happens after you click on one of the export buttons depends on which browser you use.

Netscape Navigator
Displays an Unknown File Type window. Click the Save File... button. Next, a Save As... window displays. Choose folder and filename, choose Plain Text for the Save file as type option, and click the Save button.

Internet Explorer
Displays a File Download window. Click the Save button. Next, a Save As window displays. Choose folder and file name, choose Text Document for the Save as type option, and click the Save button.

Other browsers use similar procedures. See the Help file or documentation for your browser to determine the exact procedure for saving a text file.

The default export file name is html_page_name.txt, where html_page_name is the name of the criteria selection page for the AirData report. For example, the HTML page for NET Count Report is netcount.html, and netcount.txt is the default export file name.

 

Local Navigation

Jump to main content.