The Raw Data Work File report essentially contains the same content in flat file format as the Raw Data Report (AMP350) and the Raw Data Report for NAAQS Durations W, X, Y and Z (AMP350NW). Its purpose is to facilitate the export of information from AQS to some other application or analysis tool.
The output is always a "flat" ASCII file with each record being a single line with a "pipe" character as a delimiter between fields. The following data is a sample of a single Site/Monitor record line.
1|23|MAINE|009|HANCOCK|9992|45201|BENZENE|1|02830|BAR HARBOR|TOP OF CADILLAC MOUNTAIN|109|DOWN EAST|0000|NOT IN AN MSA|||01|POPULATION EXPOSURE|||1120|BOSTON, MA|MOBILE|RURAL|44.351667|-68.227222|19|4911000|561583|018|INTERPOLATION-MAP|NAD27|182.18|24000|466|000|UNKNOWN|UNKNOWN|0
The work file includes four (4) types of data record. Although each type has a different layout, they have the same first field, which is the Transaction Type field. The Transaction Type values are:
|
Value |
Description |
|
1 |
|
|
2 |
|
|
3 |
|
|
4 |
(Use the above links to see the format specifications for each type.)
Each of the four types of data are sorted separately. This means that all of the Site/Monitor descriptions appear, sorted, at the top of the file, followed by sorted Raw Data Records, then the NAAQS Average Records, and finally the Composite Data Records.
Within each type, the data is sorted by state, county (or equivalent unit), site, pollutant type, POC and date, where appropriate.