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
· Weekly
· Monthly
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