Avalanche and Weather Programs - Weather and Frost Probe Station Network

745 views (3 recent)

Published by the Ministry of Transportation and Infrastructure - Construction and Maintenance
Licensed under Open Government Licence - British Columbia

Locations of active electronic weather and frost probe stations maintained by the Ministry of Transportation to support Avalanche and Winter Road maintenance operations.

Data and Resources

Dataset Extent

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

Additional Information


To delineate weather and frost probe station locations as points

Lineage Statement

This data has been developed for regional and district operations

More Information

Contact Information

NameSimon Walker (businessExpert)
OrganizationMinistry of Transportation and Infrastructure
Sub-OrganizationConstruction and Maintenance
NameAWP Systems Support (pointOfContact)
OrganizationMinistry of Transportation and Infrastructure
Sub-OrganizationConstruction and Maintenance

Access & Security

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

Metadata Information

Record Published 2014-12-11
Record Last Modified 2017-11-03
Resource Status completed

Object Description


Short Name: T_W_F_STN

Column Name Short Name Data Type Data Precision Comments
OBSERVATION_LOCATION_ID OBS_ID NUMBER 5 OBSERVATION LOCATION ID is the Observation Location Unique Identifier (to relate to oracle table SAW_OBSERVATION_LOCATION).
STATION_CODE CODE VARCHAR2 6 STATION CODE is the Station Number - Business attribute for weather station.
STATION_NAME STN_NAME VARCHAR2 30 STATION NAME is the business name for the station.
CONTRACT_AREA_ID CONT_ID NUMBER 3 CONTRACT AREA ID is the business attribute for Ministry Contract Service Area.
OBSERVATION_LOCATION_TYPE OBS_TYPE VARCHAR2 30 OBSERVATION LOCATION TYPE is the Observation Location Type. Examples are RAWS: Remote Automated Weather Station - primarily used for Avalanche operation, RWS: Road Weather Station - primarily used for winter road maintenance operationsGEOTCH: Frost Probe Station - used for Seasonal Strength Loss Programs at District Offices.TECHWX: Stations where manual data is collected by Ministry Personnel to supplement the RAWS Observations.AVALWX: Stations where manual data is collected and submitted to the Ministry to supplement local knowledge for avalanche forecasting.
LATITUDE LATITUDE_ NUMBER 18 LATITUDE is the geographic latitude of a point.
LONGITUDE LONGITUDE NUMBER 18 LONGITUDE is the geographic longitude of a point.
FEATURE_CODE F_CODE VARCHAR2 10 FEATURE CODE is a standard alphanumeric code to identify the type of feature represented by the spatial data. A feature code is most importantly a means of linking a feature to its name and definition. For example, the code GB15300120 on a digital geographic feature links it to the name "Lake - Dry" with the definition "A lake bed from which all water has drained or evaporated." The feature code does NOT mark when it was digitized, what dataset it belongs to, how accurate it is, what it should look like when plotted, or who is responsible for updating it. It only says what it represents in the real world. It also doesn't even matter how the lake is represented. If it is a very small lake, it may be stored as a point feature. If it is large enough to have a shape at the scale of data capture, it may be stored as an outline, or a closed polygon. The same feature code still links it to the same definition. The feature code of this dataset is CF29200000.
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.