IMPROVE Aerosol RHR Metrics III (2018 Guidance), Annual Group Means
Output file example (excerpt):
SiteCode|POC|FactDate|ParamCode|MethodID|Units|FactValue|IGroup|Status|good_year|TypeCode
ACAD1|1|2021-01-01|aerosol_bext|1006|1/Mm|12.24376|70|V0|1|REG
ACAD1|1|2021-01-01|ammNO3f|1006|ug/m^3|0.1117|70|V0|1|REG
ACAD1|1|2021-01-01|ammNO3f_bext|1006|1/Mm|1.02711|70|V0|1|REG
ACAD1|1|2021-01-01|ammNO3f_Large|1006|ug/m^3|0.00062|70|V0|1|REG
ACAD1|1|2021-01-01|ammNO3f_Small|1006|ug/m^3|0.11108|70|V0|1|REG
ACAD1|1|2021-01-01|ammSO4f|1006|ug/m^3|0.71016|70|V0|1|REG
ACAD1|1|2021-01-01|ammSO4f_bext|1006|1/Mm|6.08912|70|V0|1|REG
ACAD1|1|2021-01-01|ammSO4f_Large|1006|ug/m^3|0.02522|70|V0|1|REG
ACAD1|1|2021-01-01|ammSO4f_Small|1006|ug/m^3|0.68494|70|V0|1|REG
ACAD1|1|2021-01-01|AnthBext|1006|1/Mm|5.99525|70|V0|1|REG
ACAD1|1|2021-01-01|AnthEammNO3|1006|1/Mm|0.55862|70|V0|1|REG
ACAD1|1|2021-01-01|AnthEammSO4|1006|1/Mm|4.24425|70|V0|1|REG
ACAD1|1|2021-01-01|AnthECM|1006|1/Mm|0.01113|70|V0|1|REG
ACAD1|1|2021-01-01|AnthELAC|1006|1/Mm|1.18125|70|V0|1|REG
Schema description:
| Field | Description |
|---|
| SiteCode | XF_SiteCode |
| POC | XF_POC |
| FactDate | XF_FactDate |
| ParamCode | XF_ParamCode |
| MethodID | XF_MethodID |
| Units | XF_Units |
| FactValue | XF_FactValue |
| IGroup |
IGroup ("Impairment Group") indicates the quintile (percentile) based on sorting the annual data values from lowest to highest Impairment
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 IGroup = 0
IF dv <= p20 Then IGroup = 10
IF dv > p20 AND dv < p40 THEN IGroup = 30
IF dv >= p40 AND dv <= p60 THEN IGroup = 50
IF dv > p60 AND dv < p80 THEN IGroup = 70
IF dv >= p80 then IGroup = 90
Annual average of across all groups = 100
|
| Status |
XF_StatusCode
| Flag | Description | Start Date | End Date | Records |
|---|
| V0 | Valid value | 1989-01-01 | 2021-01-01 | 740,010 |
|
| 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:
| Flag | Description | Start Date | End Date | Records |
|---|
| ANN | | 1989-01-01 | 2021-01-01 | 740,010 |
|
References: