IMPROVE Aerosol RHR Metrics II (2003 Guidance), Annual Group Means

Output file example (excerpt):

SiteCode|POC|FactDate|ParamCode|MethodID|Units|FactValue|HGroup|Status|good_year|TypeCode|Number_obs|ss_rayleigh
ACAD1|1|2021-01-01|aerosol_bext|1010|1/Mm|6.79987|10|V0|1|ANN|23|12
ACAD1|1|2021-01-01|aerosol_bext|1010|1/Mm|10.74653|30|V0|1|ANN|23|12
ACAD1|1|2021-01-01|aerosol_bext|1010|1/Mm|13.6559|50|V0|1|ANN|25|12
ACAD1|1|2021-01-01|aerosol_bext|1010|1/Mm|19.87809|70|V0|1|ANN|23|12
ACAD1|1|2021-01-01|aerosol_bext|1010|1/Mm|40.45231|90|V0|1|ANN|24|12
ACAD1|1|2021-01-01|aerosol_bext|1010|1/Mm|18.41539|100|V0|1|ANN|118|12
ACAD1|1|2021-01-01|ammNO3f|1010|ug/m^3|0.06807|10|V0|1|ANN|23|12
ACAD1|1|2021-01-01|ammNO3f|1010|ug/m^3|0.10691|30|V0|1|ANN|23|12
ACAD1|1|2021-01-01|ammNO3f|1010|ug/m^3|0.16314|50|V0|1|ANN|25|12
ACAD1|1|2021-01-01|ammNO3f|1010|ug/m^3|0.32799|70|V0|1|ANN|23|12
ACAD1|1|2021-01-01|ammNO3f|1010|ug/m^3|0.44067|90|V0|1|ANN|24|12
ACAD1|1|2021-01-01|ammNO3f|1010|ug/m^3|0.22223|100|V0|1|ANN|118|12
ACAD1|1|2021-01-01|ammNO3f_bext|1010|1/Mm|0.62981|10|V0|1|ANN|23|12
ACAD1|1|2021-01-01|ammNO3f_bext|1010|1/Mm|0.97872|30|V0|1|ANN|23|12

Schema description:

FieldDescription
SiteCodeXF_SiteCode
POCXF_POC
FactDateXF_FactDate
ParamCodeXF_ParamCode
MethodIDXF_MethodID
UnitsXF_Units
FactValueXF_FactValue
HGroup

HGroup ("Haze Group") indicates the quintile (percentile) based on sorting the annual data values from lowest to highest Deciview (dv)

IMPROVE convention bins the data values into "groups" based on this algortihm (where the prefix "p" stands for "percentile"):

IF the year's data did not meet the RHR completeness criteria or dv could not be calculated for some reason, then HGroup = 0
IF dv <= p20 Then HGroup = 10
IF dv > p20 AND dv < p40 THEN HGroup = 30
IF dv >= p40 AND dv <= p60 THEN HGroup = 50
IF dv > p60 AND dv < p80 THEN HGroup = 70
IF dv >= p80 then HGroup = 90
Annual average of across all groups = 100

Status

XF_StatusCode

FlagDescriptionStart DateEnd DateRecords
V0Valid value1989-01-012021-01-01468,468

good_year Indicates whether or not the data meets RHR criteria for annual completeness
TypeCode

A code that indicates the type of data record. The possible values are:

FlagDescriptionStart DateEnd DateRecords
ANNIndicates an annual aggregated (e.g. average) value1989-01-012021-01-01468,468

Number_obsThe number of valid daily values in the annual mean
ss_rayleighRayleigh scattering value: the predominantly elastic scattering of light or other electromagnetic radiation by particles much smaller than the wavelength of the radiation

References: