Metadata

Below are the available data types and quality-control flags for the Weatherlogics Climate Database (WCD). Also described below is the metadata associated with locations.

Locations

When you search for data at a location, your query will return metadata about the location, in addition to the data itself. The location metadata indicates how the data for the location was assembled. The process for joining, merging, and quality-controlling data is described on the methods page.

However, there is additional information included in the metadata for each search that is specific to that search. One thing you will notice is that multiple stations are listed in the "stations_used" and "stations_ids_merged" section. These are the stations used to create the dataset you received. The list of "stations_merged" shows the ec ids of all stations used to create that location. Not all these stations may actually be used to produce the dataset, but they were all available when the dataset was created. In some cases, there may not have been any missing data and the merging program would have only used one station and didn't need to fill missing values with other stations. You can tell which station was used for each datapoint by looking at each data point's ec id. The ec id is the unique identifier for that station, which is also listed in the metadata. Some stations may have a "blacklist" beside them. The blacklist is a list of variables from that station that were excluded from merging. This is usually done to prevent bad data from, that is known to exist for a certain variable at a certain station, from entering the database. If no blacklist is shown, that means all variables were available in the merging process. The other data in the location section refers to the currently active station which represents that location. For metadata about other historical stations used to create the location, see the details associated with each respective station. For more information about locations, please review the methods page (under the help menu) or contact us.

Table of data types

Time type Query name Full name
Hourly air_temp Air temperature at the top of the hour.
Hourly dwpt_temp Dewpoint temperature at the top of the hour.
Hourly rel_hum Relative humidity at the top of the hour.
Hourly avg_wnd_spd_10m_mt58_60 Average wind speed at 10 m above ground between minutes 58 and 60 of the preceeding hour.
Hourly avg_wnd_dir_10m_mt58_60 Average wind direction at 10 m above ground between minutes 58 and 60 of the preceeding hour.
Hourly stn_pres Station pressure at the top of the hour.
Hourly vis Visibility at the top of the hour.
Hourly prsnt_wx_{1/2/3/4/5/6/7}_ec Present weather condition(s) observed at the top of the hour. The conditions are unordered with prsnt_wx_1_ec not necessarily being more prevalent than prsnt_wx_2_ec, etc.
Daily max_temp Daily maximum temperature recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter. Some volunteer observing stations may still use 12Z to 12Z as the climate day. Contact us for more information.
Daily min_temp Daily minimum temperature recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter. Some volunteer observing stations may still use 12Z to 12Z as the climate day. Contact us for more information.
Daily mean_temp Daily mean temperature recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter. Some volunteer observing stations may still use 12Z to 12Z as the climate day. Contact us for more information.
Daily total_rain Daily total rainfall recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter. Some volunteer observing stations may still use 12Z to 12Z as the climate day. Contact us for more information.
Daily total_snow Daily total snowfall recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter. Some volunteer observing stations may still use 12Z to 12Z as the climate day. Contact us for more information.
Daily total_precip Daily total precipitation (total of all rain and melted snow or other precipitation types) recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter. Some volunteer observing stations may still use 12Z to 12Z as the climate day. Contact us for more information.
Daily snow_on_ground Total snow on ground at the start of the day (measured at 12Z).
Daily total_rain_trace Whether a trace of rain was recorded, 0 for no, 1 for yes. Based on the same climate day as total_rain.
Daily total_snow_trace Whether a trace of snow was recorded, 0 for no, 1 for yes. Based on the same climate day as total_snow.
Daily total_precip_trace Whether a trace of precipitation was recorded, 0 for no, 1 for yes. Based on the same climate day as total_precip.
Daily snow_on_ground_trace Whether a trace of snow on ground was recorded, 0 for no, 1 for yes. Based on the same climate day as snow_on_ground.
Daily spd_max_gust The daily maximum wind gust speed recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter.
Daily dir_max_gust The direction of the daily maximum wind gust recorded within the climate day. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter.
Daily ts_day Whether or not a thunderstorm occurred within the climate day, 0 for no or 1 for yes. The climate day was 12Z to 12Z before July 1, 1961 and 06Z to 06Z thereafter.
Monthly mean_max_temp Average monthly maximum temperature.
Monthly mean_min_temp Average monthly minimum temperature.
Monthly mean_temp Average monthly temperature.
Monthly total_rain Total monthly rainfall.
Monthly total_snow Total monthly snowfall.
Monthly total_precip Total monthly precipitation.

QC Flags

All data points in the WCD have a flag. This flag indicates what QC, was performed on the value. The first character of the flag indicates what type of QC occurred and the second value provides additional detail. Most values have the flag ‘OK’ indicating that all QC tests passed. It is very important to always check the QC flags before using data values to ensure you understand any potential issues.

Category Flag Description
BM B - A backup station was used in a calculation. One or more stations were used in the monthly value calculation.
CC C - Calculated Calculated from other columns.
CD C - Calculated Recalculated from dailies.
EA E - An original ECCC flag was kept. ECCC estimate accepted.
EE E - An original ECCC flag was kept. Raw estimate flag from ECCC was kept because it could not be verified.
EG E - An original ECCC flag was kept. Precipitation occurred but amount uncertain.
EP E - An original ECCC flag was kept. Accumulated precipitation was estimated.
ER E - An original ECCC flag was kept. Recalculated based on estimated data.
HM H - Hourly data was used. Filled missing with hourlies.
LT L - These flags describe values that are less than given threshold. Maximum wind gust was less than 31 km/h.
MA M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled manually.
MB M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with backup station.
MD M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with calculated daily value.
ME M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with extrapolated surrounding observations.
MF M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with extrapolated hourly data (ME).
MH M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with hourly.
MI M - These flags describe cases where there is no data. The reason is given by the second character. The value is missing.
ML M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with logic.
MM M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with metar.
MN M - These flags describe cases where there is no data. The reason is given by the second character. Data value was missing and could not be filled.
MS M - These flags describe cases where there is no data. The reason is given by the second character. Missing value filled with synops.
MX M - These flags describe cases where there is no data. The reason is given by the second character. Less than 90% of hourlies available so could not fill with hourlies.
OK O - these flags describe cases where the data point was good. The data point was deemed valid.
QC Q - Quality control found a suspect value and that value was corrected to a different value. Value calculated after requisite values were filled in.
QD Q - Quality control found a suspect value and that value was corrected to a different value. Erroneous value replaced with backup daily value.
QG Q - Quality control found a suspect value and that value was corrected to a different value. Erroneous wind gust replaced.
QF Q - Quality control found a suspect value and that value was corrected to a different value. Erroneous value filled with estimated equivalent.
QH Q - Quality control found a suspect value and that value was corrected to a different value. Erroneous value replaced with backup hourly value.
QM Q - Quality control found a suspect value and that value was corrected to a different value. Erroneous value removed entirely.
QO Q - Quality control found a suspect value and that value was corrected to a different value. Value changed to 0.
QR Q - Quality control found a suspect value and that value was corrected to a different value. Mean value recalculated due to rounding error.
QS Q - Quality control found a suspect value and that value was corrected to a different value. Erroneous value replaced with synop.
TR T - These flags describe something to do with trace values. Trace amount of rain/snow/precip (depending on column).
ZB Z - Quality control found a suspect value, but the value was not changed. Suspect value used from synops.
ZC Z - Quality control found a suspect value, but the value was not changed. Recalculated and suspect.
ZD Z - Quality control found a suspect value, but the value was not changed. Suspect dewpoint-temperature association.
ZE Z - Quality control found a suspect value, but the value was not changed. Suspect due to extreme value.
ZF Z - Quality control found a suspect value, but the value was not changed. Suspect value fluctuation.
ZG Z - Quality control found a suspect value, but the value was not changed. Suspect wind gust.
ZH Z - Quality control found a suspect value, but the value was not changed. Suspect compared to hourly data on same day.
ZM Z - Quality control found a suspect value, but the value was not changed. Suspected misinterpretation of weather.
ZN Z - Quality control found a suspect value, but the value was not changed. Suspect due to metar values on same day.
ZR Z - Quality control found a suspect value, but the value was not changed. Suspect ratio with other ZR values in row.
ZS Z - Quality control found a suspect value, but the value was not changed. Suspect dates were swapped.
ZT Z - Quality control found a suspect value, but the value was not changed. Suspect temperature association.
ZW Z - Quality control found a suspect value, but the value was not changed. Suspect wind association.
ZZ Z - Quality control found a suspect value, but the value was not changed. Manually marked suspect.