Climate indicators for BC Census Subdivisions

305 views (2 recent)

Published by the Ministry of Jobs, Trade and Technology - International Marketing
Licensed under Access Only

IEDC Climate indicators for BC Census Subdivisions or CLAB_INDIAN_RESERVES - temperature and precipitation. Temperature and precipitation values pertain to a specific reference point located within each Census Subdivision or CLAB_INDIAN_RESERVE. Data are taken from ClimateBC (http://cfcg.forestry.ubc.ca/projects/climate-data/climatebcwna/#ClimateBC) for the reference normal period 1981-2010.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

Application-specific for the Trade and Invest British Columbia website (https://www.britishcolumbia.ca/)

More Information

Contact Information

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2016-06-17
Record Last Modified 2019-08-01
Resource Status completed

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.ECON_CLIMATE_INDICATORS

Short Name: CLIMAT_IND
Comments: IEDC Climate indicators for BC Census Subdivisions or CLAB_INDIAN_RESERVES - temperature and precipitation. Temperature and precipitation values pertain to a specific reference point located within each Census Subdivision or CLAB_INDIAN_RESERVE. Data are taken from ClimateBC (http://cfcg.forestry.ubc.ca/projects/climate-data/climatebcwna/#ClimateBC) for the reference normal period 1981-2010.

Column Name Short Name Data Type Data Precision Comments
CLIMATE_INDICATOR_ID CLMT_ND_ID NUMBER 10 CLIMATE_INDICATOR_ID: is a system generated unique identification number. This is the primary key of this table. e.g., 1
CENSUS_YEAR CNSS_YR NUMBER 4 CENSUS_YEAR: is the census year to which the CENSUS_SUBDIVISION_ID pertains. e.g., 2006, 2011. With CENSUS_SUBDIVISION_ID, this forms a foreign key linking to CENSUS_YEAR + CENSUS_SUBDIVISION_ID in CEN_CENSUS_SUBDIVISIONS_SP
CENSUS_SUBDIVISION_ID CNSS_SB_ID VARCHAR2 7 CENSUS_SUBDIVISION_ID: With CENSUS_YEAR, this forms a foreign Key, linking to CENSUS_YEAR + CENSUS_SUBDIVISION_ID in CEN_CENSUS_SUBDIVISIONS_SP, e.g., 5901022
CLAB_ID CLAB_ID VARCHAR2 14 CLAB_ID: is a Canada Lands Administrative Boundary (CLAB) unique identifier. e.g., 00009. This is a foreign key to WHSE_ADMIN_BOUNDARIES.CLAB_INDIAN_RESERVES.
REFERENCE_POINT_LATITUDE REF_LAT NUMBER 8 REFERENCE_POINT_LATITUDE: the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the census subdivision or CLAB INDIAN RESERVE as measured from the equator, e.g., 55.323653
REFERENCE_POINT_LONGITUDE REF_LONG NUMBER 9 REFERENCE_POINT_LONGITUDE: the geographic coordinate, in decimal degrees (ddd.dddddd), of the location of the census subdivision or CLAB INDIAN RESERVE as measured from the prime meridian, e.g., -123.093544
AVERAGE_HIGH_TEMPERATURE_JAN AVRG_HGH_N NUMBER 5 AVERAGE_HIGH_TEMPERATURE_JAN: Mean of daily high temperatures (°C) in January. e.g., -3.9
AVERAGE_HIGH_TEMPERATURE_JUL AVRG_HGH_L NUMBER 5 AVERAGE_HIGH_TEMPERATURE_JUL: Mean of daily high temperatures (°C) in July. e.g., 21.5
AVERAGE_LOW_TEMPERATURE_JAN AVRG_LW_TN NUMBER 5 AVERAGE_LOW_TEMPERATURE_JAN: Mean of daily low temperatures (°C) in January. e.g., -12.2
AVERAGE_LOW_TEMPERATURE_JUL AVRG_LW_TL NUMBER 5 AVERAGE_LOW_TEMPERATURE_JUL: Mean of daily low temperatures (°C) in July. e.g., 6.8
AVERAGE_TEMPERATURE_JAN AVRG_TMPRN NUMBER 5 AVERAGE_TEMPERATURE_JAN: Mean temperature (°C) in January. e.g., -8.1
AVERAGE_TEMPERATURE_JUL AVRG_TMPRL NUMBER 5 AVERAGE_TEMPERATURE_JUL: Mean temperature (°C) in July. e.g., 14.2
AVERAGE_ANNUAL_PRECIPITATION AVRG_NNL_N NUMBER 5 AVERAGE_ANNUAL_PRECIPITATION: Mean annual precipitation (mm). e.g., 599
PRECIPITATION_AS_SNOW PRCPTTN_SW NUMBER 5 PRECIPITATION_AS_SNOW: Precipitation as snow (mm) between August in previous year and July in current year. Note that this corresponds roughly to snowfall in cm. e.g., 251
AVERAGE_ANNUAL_RAINFALL AVRG_NNL_L NUMBER 5 AVERAGE_ANNUAL_RAINFALL: Mean annual rainfall (mm) (AVERAGE_ANNUAL_PRECIPITATION - PRECIPITATION_AS_SNOW). e.g., 348