Environment Canada Data Licence Agreement: http://climate.weather.gc.ca/prods_servs/attachment1_e.html Environment Canada Terms and Conditions: http://www.ec.gc.ca/default.asp?lang=En&xml=5830C36B-1773-4E3E-AF8C-B21F54633E0A Environment Canada Quality of Historic Weather Data Statement: http://climate.weather.gc.ca/climate_data/data_quality_e.html Please direct any inquiries directly to Environment Canada: http://climate.weather.gc.ca/contactus/contact_us_e.html
This dataset has the following 29 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Row ID | row_id | text | Unique identifier that combines the Station ID, the year, the month, the day, the hour, the minute and the second that the data was recorded. | 187020000102 187020000103 187020000104 187020000105 187020000106 view top 100 |
| Station ID | station_id | number | The unique identifier that Environment Canada has assigned to the weather monitoring station. | 1870 27492 27214 27793 30907 view top 100 |
| Station Name | station_name | text | The name and/or location description of the weather station. | EDMONTON STONY PLAIN EDMONTON STONY PLAIN CS EDMONTON BLATCHFORD EDMONTON INTERNATIONAL CS EDMONTON NAMAO AWOS A view top 100 |
| Station Province | station_province | text | The province where the weather station is located. | ALBERTA view top 100 |
| Station Latitude | station_latitude | number | The latitude of the weather station. | 53.55 53.67 53.57 53.31 53.65 view top 100 |
| Station Longitude | station_longitude | number | The longitude of the weather station. | -114.11 -113.47 -113.52 -113.61 -113.35 view top 100 |
| Location | location | location | The lat/long (geo coordinates) of the weather station. | view top 100 |
| Station Elevation (m) | station_elevation_m | number | The elevation in metres (m) refers to the elevation of the observing location above mean sea level. The elevation of each site is given to the nearest metre and is generally the height of ground on which the instruments are exposed. | 766.30 671.00 715 687.9 665 view top 100 |
| Station Climate Identifier | station_climate_identifier | text | Also referred to as station ID or station number, the climate ID is a 7 digit number assigned by the Meteorological Service of Canada to a site where official weather observations are taken, and serves as a permanent, unique identifier. The first digit assigned identifies the province where the second and third digits identify the climatological district within the province. When observations are discontinued at a site, the number is not used for subsequent stations (which may, or may not, differ in name) unless it is judged that the records from the earlier and subsequent stations may be combined for most climatological purposes. | 301222F 301A001 3012209 3012206 3012212 view top 100 |
| Station WMO Identifier | station_wmo_identifier | text | A 5-digit number permanently assigned to Canadian stations by the World Meteorological Organization to identify the station internationally. The WMO ID is an international identifier assigned by the Meteorological Service of Canada to standards of the World Meteorological Organization for stations that transmit observations in international meteorological formats in real time. | 71119 71127 71157 71155 71121 view top 100 |
| Station TC Identifier | station_tc_identifier | text | The TC ID is the identifier assigned by Transport Canada to identify meteorological reports from airport observing sites transmitted in real time in aviation formats. | WSE XPS XEC XEG YED view top 100 |
| Year | year | number | The year of the weather data record. | 2019 2020 2021 2017 2016 view top 100 |
| Month | month | number | The month of the weather data record. | 1 5 7 3 10 view top 100 |
| Day | day | number | The day of the month of the weather data record. | 18 10 1 16 2 view top 100 |
| Data Quality | data_quality | text | ^ = The value displayed is based on incomplete data † = Data for this day has undergone only preliminary quality checking ‡ = Partner data that is not subject to review by the National Climate Archives | † ‡ view top 100 |
| Date | date | calendar_date | The date of the weather data record. | 2020-05-29T00:00:00.000 2021-07-02T00:00:00.000 2019-08-15T00:00:00.000 2020-05-28T00:00:00.000 2021-03-13T00:00:00.000 view top 100 |
| Maximum Temperature (C) | maximum_temperature_c | number | The highest temperature in degrees Celsius (°C) observed at a location for a specified time interval. For this dataset, the time interval is day. | 21.0 21.5 22.0 19.0 20.0 view top 100 |
| Minimum Temperature (C) | minimum_temperature_c | number | The lowest temperature in degrees Celsius (°C) observed at a location for a specified time interval. For this dataset, the time interval is day. | 9.0 9.5 8.0 10.0 -2.0 view top 100 |
| Mean Temperature (C) | mean_temperature_c | number | The mean temperature in degrees Celsius (°C) is defined as the average of the maximum and minimum temperature at a location for a specified time interval. For this dataset, the time interval is day. | 14.5 14.3 15.0 13.5 15.3 view top 100 |
| Heating Degree Days (C) | heating_degree_days_c | number | Heating degree-days for a given day are the number of degrees Celsius that the mean temperature is below 18 °C. If the temperature is equal to or greater than 18 °C, then the number will be zero. For example, a day with a mean temperature of 15.5 °C has 2.5 heating degree-days; a day with a mean temperature of 20.5 °C has zero heating degree-days. Heating degree-days are used primarily to estimate the heating requirements of buildings. | 0.0 3.5 3.7 3.0 4.5 view top 100 |
| Cooling Degree Days (C) | cooling_degree_days_c | number | Cooling degree-days for a given day are the number of degrees Celsius that the mean temperature is above 18 °C. If the temperature is equal to or less than 18 °C, then the number will be zero. For example, a day with a mean temperature of 20.5 °C has 2.5 cooling degree-days; a day with a mean temperature of 15.5 °C has zero cooling degree-days. Cooling degree-days are used primarily to estimate the air-conditioning requirements of buildings. | 0.0 0.3 1.0 0.5 0.2 view top 100 |
| Total Rain (mm) | total_rain_mm | number | The total rainfall, or amount of all liquid precipitation in millimetres (mm) such as rain, drizzle, freezing rain, and hail, observed at the location during a specified time interval. In this dataset, the time interval is a day. | 0.0 0.2 0.4 0.6 1.0 view top 100 |
| Total Rain Flag | total_rain_flag | text | A = Accumulated C = Precipitation occurred, amount uncertain E = Estimated F = Accumulated and estimated L = Precipitation may or may not have occurred M = Missing S = More than one occurrence T = Trace | M T E view top 100 |
| Total Snow (cm) | total_snow_cm | number | The total snowfall, or amount of frozen (solid) precipitation in centimetres (cm), such as snow and ice pellets, observed at the location during a specified time interval. In this dataset, the time interval is a day. | 0.0 0.2 1.0 0.4 0.6 view top 100 |
| Total Snow Flag | total_snow_flag | text | A = Accumulated C = Precipitation occurred, amount uncertain E = Estimated F = Accumulated and estimated L = Precipitation may or may not have occurred M = Missing S = More than one occurrence T = Trace | M T E L C view top 100 |
| Total Precipitation (mm) | total_precipitation_mm | number | The sum of the total rainfall and the water equivalent of the total snowfall in millimetres (mm), observed at the location during a specified time interval. For this dataset, the time interval is day. | 0.0 0.4 0.5 0.2 1.0 view top 100 |
| Snow on Ground (cm) | snow_on_ground_cm | number | The depth of snow in centimetres (cm) on the ground. The total depth of snow on the ground at the time of the observation is determined in whole centimetres by making a series of measurements and taking the average. | 0 1 2 10 3 view top 100 |
| Speed of Maximum Wind Gust (km/h) | speed_of_maximum_wind_gust_km_h | text | The speed in kilometres per hour (km/h) of the maximum wind gust during the day. The gust is the maximum or peak instantaneous or single reading from the anemometer (the instrument used to observe wind speed) during the day. The duration of a gust typically corresponds to an elapsed time of 3 to 5 seconds. | <31 32 33 35 37 view top 100 |
| Direction of Maximum Wind Gust (10s Deg) | direction_of_maximum_wind_gust_10s_deg | number | The direction of the maximum gust (true or geographic, not magnetic) from which the wind blows. Expressed in tens of degrees (10's deg), 9 means 90 degrees true or an east wind, and 36 means 360 degrees true or a wind blowing from the geographic north pole. This value is only reported if the maximum gust speed for the day exceeds 29 km/h. | 32 33 29 30 28 view top 100 |