Dataset: Rain And Snow Canadian Historical Precipitations

About this Dataset

Rain And Snow Canadian Historical Precipitations

This data was extracted from Government of Canada's open dataset containing the Adjusted and Homogenized Canadian Climate Data

Naming convention and file format
Within each row, the dataset contains the station characteristics (identification number, name, province, station joined or not, element, unit, last update). The data appear daily with their flags. The precision of the elements is two digits (to avoid rounding errors). Each precipitation value is followed by its respective flags, which is reserved from the original archive file.

Understanding Flags
'M' Missing data identified as “-9999.9”
'T' Trace event; precipitation occurred but less than measurable amount. Original archive value is 0.
'E' Estimated
'F' Accumulated and estimated
'A' Accumulated amount; previous value must be flagged C or L (i.e. period of accumulation) (not any more: distributed over the effected days)
'C' Precipitation occurred, amount uncertain; (the original zero value modified)
'L' Precipitation may or may not have occurred; amount uncertain; (the original zero value modified)
'X' Joined station, earlier record was adjusted to match the later record using standardized ratios based on annual values
'Y' Joined station, earlier record was adjusted to match the later record using standardized ratios based on long series
'Z' Joined station, earlier record was adjusted to match the later record using standardized ratios based on monthly values

Tables

Ca Rain Snow

@kaggle.tomasmayer73_rain_and_snow_canadian_historical_precipitations.ca_rain_snow

26.21 MB
13864638 rows
14 columns


CREATE TABLE ca_rain_snow (
  "station" VARCHAR,
  "province" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "value_snow" DOUBLE,
  "flag_snow" VARCHAR,
  "value_rain" DOUBLE,
  "flag_rain" VARCHAR,
  "value_total" DOUBLE,
  "flag_total" VARCHAR,
  "elev_m" DOUBLE,
  "lat_deg" DOUBLE,
  "long_deg" DOUBLE
);