Clean Air Status and Trends Network (CASTNET) Dry Chemistry (DRYCHEM) - Weekly

Output file example (excerpt):

SiteCode|POC|FactDate|ParamCode|MethodID|Units|FactValue|Status|ValueFlag|QA_CODE|COMMENT_CODE_1|COMMENT_CODE_2|STD2LOCAL_CF
ABT147|1|2010-01-05|CAt|2303|ug/m^3|0.0395|V0||3|||0.9177
ABT147|1|2010-01-05|CHLt|2303|ug/m^3|0.1073|V0||3|||0.9177
ABT147|1|2010-01-05|FLOW_VOLUME|2303|L/min|13.6301|V0||3|||0.9177
ABT147|1|2010-01-05|HNO3|2303|ug/m^3|0.652|V0||3|||0.9177
ABT147|1|2010-01-05|Kt|2303|ug/m^3|0.063|V0||3|||0.9177
ABT147|1|2010-01-05|MGt|2303|ug/m^3|0.0281|V0||3|||0.9177
ABT147|1|2010-01-05|NAt|2303|ug/m^3|0.258|V0||3|||0.9177
ABT147|1|2010-01-05|NH4t|2303|ug/m^3|0.5936|V0||3|||0.9177
ABT147|1|2010-01-05|NO3_whatman|2303|ug/m^3|-999|I0|N|3|||0.9177
ABT147|1|2010-01-05|NO3sum|2303|ug/m^3|1.6594|V0||3|||0.9177
ABT147|1|2010-01-05|NO3t|2303|ug/m^3|1.0177|V0||3|||0.9177
ABT147|1|2010-01-05|SO2|2303|ug/m^3|2.1532|V0||3|||0.9177
ABT147|1|2010-01-05|SO2_whatman|2303|ug/m^3|1.5659|V0||3|||0.9177
ABT147|1|2010-01-05|SO4_nylon|2303|ug/m^3|0.8804|V0||3|||0.9177
ABT147|1|2010-01-05|SO4t|2303|ug/m^3|1.2781|V0||3|||0.9177

Schema description:

FieldDescription
SiteCodeXF_SiteCode
POCXF_POC
FactDateXF_FactDate
ParamCodeXF_ParamCode
MethodIDXF_MethodID
UnitsXF_Units
FactValueXF_FactValue
Status

XF_StatusCode

FlagDescription
I1Invalid value - known reason
M1Missing value because no value is available
M2Missing value because invalidated by data originator
M3Missing value due to clogged filter
NANot available from source data
V0Valid value
V1Valid value but comprised wholly or partially of below detection limit data
V2Valid estimated value
V4Valid value despite failing to meet some QC or statistical criteria
V5Valid value but qualified because of possible contamination
V6Valid value but qualified due to non-standard sampling conditions

ValueFlag

The data quality code for the associated observation

FlagDescriptionStart DateEnd DateRecords
---Valid1987-01-132022-11-301,901,813
!Valid: X and U apply2015-05-262015-06-166
#Valid: Both U and L flags apply1987-01-132022-11-221,320
$Valid: L and U apply2015-05-262016-01-0538
<Valid, Missing < 25% of hourly sampling period1987-01-131989-10-03556
AValid: Anomalous value resulting from local anthropogenic activity
LValid: Less than 90% but greater than or equal to 75% valid flow data1987-01-132022-11-2926,294
RValid: Re-run value used in calculation1999-01-262002-01-1561
SValid: Both L and R flags apply
UValid: Undetected - value listed is the reporting limit corrected by flow volume1987-02-102022-11-3072,278
XValid: Data suspect due to impregnation solution2015-05-262016-01-062,870
IInvalid: Invalid chemistry data and/or less than 75% valid flow data1987-01-132022-11-2938,435
MInvalid: Missing or completely invalid flow data1999-01-052022-11-081,888
NInvalid: Sample not analyzed1987-01-132022-11-30292,697

QA_CODE

Quality assurance level of the record

FlagDescription
0Level 0 validated data
1Level 1 validated data
1XLevel 1 data that are suspect based on manual screening. Data should be omitted from any statistical analyses.
2Level 2 validated data
3Level 3 validated data
GSGovernment shutdown period
XRecord not obtained via daily polling; placeholder used

COMMENT_CODE_1

Data comment code, primary

FlagDescription
01Unidentified debris/particles on filter
02Torn;hole;ripped filter noted during unpacking
03Excessively wet filter noted upon unpacking
04Excessively dirty filter noted upon unpacking
05Filter pack loose upon arrival, possible leakage during sample period
06Apparent solenoid problem
07Filter pack end caps cracked/missing upon receipt
08Outside of filter pack excessively dirty upon receipt
09Support screen raised up, noted during unpacking
10Insect inside filter pack; noted during unpacking
11Laboratory accident
12Filter pack on tower for less than 6 or greater than 8 days
13Filter pack not run in field
14Unusual odor noticed during unpacking
15Low extraction efficiency off filter
16On/off dates and times are assumed
17Filter given to EPA for analysis
18Field accident or error
19Field equipment problem
20Filter used for special study
21Forest fire/agricultural activity in area
22Site closed
23Sample report form not received with filter pack
24Chain of custody incomplete or incorrect
25Filter pack run out of sequence
26Suspect value, but reason not recorded
28SO2 concentration adjusted due to positive bias introduced by faulty cellulose filter impregnation solution
GPrefix indicating that the numeric code immediately following applies to all analyses of the sample.
NPrefix indicating that the numeric code immediately following applies to the Nylon filter analysis
TPrefix indicating that the numeric code immediately following applies to the Teflon filter analysis
WPrefix indicating that the numeric code immediately following applies to the Whatman filter analysis

COMMENT_CODE_2Data comment code, secondary (see flag defintions for COMMENT_CODE_1 above)
STD2LOCAL_CFFactor used to convert atmospheric concentrations from standard to local conditions