RAW DATA REPORTS (AMP350)

The Raw Data Report is a report that displays raw data values, calculates arithmetic and geometric means and maxima for pollutants extracted from the Air Quality Raw Data files. The Raw Data Reports use the standard Selection Report Criteria interface to restrict raw data by monitor/duration combinations and date ranges. In addition, the Raw Data Listing requires that report-specific criteria be assigned to each request. Those items are:

· Units for raw data: reported or standard

· Exceptional data: Included or excluded

· Show Daily Mean or Daily Maximum Value (Hourly Reported formats only)

· Summary Pages (Daily Maxima) Only: Yes or No

 (only allowed when standard units is selected)

· Alternative Standards

(only allowed for those parameter-duration combinations for which there is an existing EPA standard)

 (only allowed when standard units is selected)

· Show Null Value Code: Yes or No

There are two basic reports, The Raw Data Work File report (AMP350WF) and the Raw Data Report (AMP350).

The Raw Data Work File report produces an ASCII flat file suitable for loading data into other databases or spreadsheets

The Raw Data Report produces pages with varied formats depending on the nature of the data selected. This single variable format report replaces multiple earlier reports that were unique to each format.

· Hourly

· Hourly Exceptional

· Daily Reported

· Weekly

· Monthly

· Composite Reported

· Daily Standard

· Composite Standard

The header information is the virtually the same for all formats. The elements in the header that are common to all formats are:

· Standard EPA AQS Legend

· Execution Date & Time

· Page Number

· Report Code

· Report Title

· Report Subtitle (Daily Values, 8-Hour Running Average, 1-Hour Maximums, etc.)

· State Code & Name

· Parameter Code & Description

· CAS Number

· Site ID

· POC

· County Code & Description

· City Code & Description

· Site Address

· Supporting Agency Code & Name

· Site Comments

· Monitor Comments

· Reporting Org Agency Code & Name

· Monitor Type Count

· Methodology Code & Collection/Analysis Descriptions

· AQCR Code & Description

· Urbanized Area Code & Description

· Land Use Type

· Location Setting

· Monitor Objective Code & Description

· Site Latitude & Longitude

· Site UTM Zone Number, Easting, & Northing

· Site Elevation above MSL (LDP Vertical Distance)

· Units Code & Description

· Probe Height

· Interval

· Minimum Detectable Limit

The minimum detectable limit associated with the methodology is displayed unless there is an alternate minimum detectable limit, in which case the alternate is displayed. If there is more than one methodology for the matrix being displayed, or if there is both an alternate and standard minimum detectable limit, then nothing is displayed for minimum detectable limit.

If the report is in reported units, then the standard minimum detectable limit should be converted to reported units for display.

Report subtitles are determined based on duration, unit, whether the parameter is a criteria pollutant, and data source. The report subtitles are:

Duration

Unit

Data Source

Format

Subtitle

1-6,B

Reported

Raw_Data

Hourly, Hourly Exc.

Raw Data Listing - Hourly Reported Values

1-6,B

Standard

Raw_Data

Hourly, Hourly Exc.

Raw Data Listing - Hourly Standard Values

1-6,B

Standard

Daily_Summaries

Daily Standard

Raw Data Listing - Hourly Maximums

W

Standard

NAAQS_Averages

Hourly

Raw Data Listing - 8-Hour (Begin Hour) Running Averages

W

Standard

Daily_Summaries

Daily Standard

Raw Data Listing - 8-Hour (Begin Hour) Running Average

 

Maximums

 

 

 

X

Standard

NAAQS_Averages

Daily Standard

Raw Data Listing - 24-Hour Block Averages

Y

Standard

NAAQS_Averages

Hourly

Raw Data Listing - 3-Hour Block Averages

Y

Standard

Daily_Summaries

Daily Standard

Raw Data Listing - 3-Hour Block Average Maximums

Z

Standard

NAAQS_Averages

Hourly

Raw Data Listing - 8-Hour (End Hour) Running Averages

Z

Standard

Daily_Summaries

Daily Standard

Raw Data Listing - 8-Hour (End Hour) Running Average Maximums

7

Reported

Raw_Data

Daily Reported

Raw Data Listing - Daily Reported Values

7

Standard

Raw_Data

Daily Standard

Raw Data Listing - Daily Standard Values

A

Reported

Raw_Data

Weekly

Raw Data Listing - Weekly Reported Values

A

Standard

Raw_Data

Weekly

Raw Data Listing - Weekly Standard Values

8,9,D

Reported

Raw_Data

Monthly

Raw Data Listing - Monthly Reported Values

8,9,D

Standard

Raw_Data

Monthly

Raw Data Listing - Monthly Standard Values

C

Reported

Raw_Data

Composite Reported

Raw Data Listing - Composite Reported Values

C

Standard

Raw_Data

Composite Standard

Raw Data Listing - Composite Standard Values

On the report, if a sample value to be displayed is too large to fit in the space allocated, the value will be divided by an appropriate factor of 10 to make it fit. In these cases, a flag is displayed in the column immediately after the last column allocated for the value. The flags and their corresponding factors are:

Flag

Divisor

$

10

&

100

%

1000

#

10000

?

100000

On any page where such a scaled substitution has been made, the following legend appears as part of the report trailer:

<Multiply values marked with "$" by 10, "&" by 100, "%" by 1000, "#" by 10000, and "?" by 100000>

If a sample value to be displayed is too small to fit in the space allocated, the value is truncated at 3 digits to the right of the decimal point, regardless of the scale associated with the value. In effect, when the value is too small, the report will display '.000'.

When a report is being generated in standard units, sample values are compared against any Pollutant Standards defined for the parameter-duration combination, or alternative standards defined at the time of request. When a sample value exceeds either standard, a flag is displayed in the column immediately after the last column allocated for the value. (This makes the flag appear to have been appended to the displayed value.) The flags are '*' for exceeding the primary standard and '+' for exceeding the secondary standard. When a value exceeds both standards, the exceedance of the primary standard takes precedence for display on the report.

When there is a conflict between displaying a scaling flag and an exceedance flag, the scaling flag takes precedence for display on the report.

The count of each type of exceedance is maintained and displayed as part of the footer.

If a sample value is null and the user selects to show null value codes, then the null value Qualifier Code should be displayed in the space allocated for the sample value; otherwise nothing is displayed in that space.

Data qualifiers with EPA regulation concurrence are displayed twice, concatenated.

If any raw data in a display matrix are qualified with QA qualifiers a key is displayed in the report with an explanation of the qualifiers.

Page breaks occur when units, durations, sites or monitors change