Recreation Line

1533 views (19 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Recreation Sites and Trails BC
Licensed under Open Government Licence - British Columbia

This is a spatial layer showing Ministry of Forests Recreation Lines. These are the linear spatial representation for features such as recreation trails

Data and Resources

Dataset Extent

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

Additional Information


To support the harvesting approval process, monitor forest tenures and support Integrated Land and Resource Registry applications.

Lineage Statement

Base information originates from 1:20,000 and TRIM and 1:20,000 Cadastral.

Contact Information

NameBill Dowedoff (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationRecreation Sites and Trails BC
NameJohn Crooks (custodian)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationRecreation Sites and Trails BC

Access & Security

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

Metadata Information

Record Published 2011-03-09
Record Last Modified 2021-05-14
Resource Status onGoing

Object Description


Short Name: FTN_REC_LN
Comments: The spatial representation of a recreation feature. This can be either a recreation reserve, recreation site, or an interpretative forest.

Column Name Short Name Data Type Data Precision Comments
RMF_SKEY RMF_SKEY NUMBER 10 The unique identifier (called an SKEY) for the Recreation Map Feature.
FOREST_FILE_ID FFID VARCHAR2 10 An identifier assigned to the recreation file, e.g., REC16098.
SECTION_ID SECTION_ID VARCHAR2 10 An identifier assigned to a section of a recreation trail, e.g., 1, 10, A, B, EATON LAKE.
RECREATION_MAP_FEATURE_CODE REC_MF_CD VARCHAR2 3 Code that identifies the type of recreation feature, i.e., IF (interpretive forest trail), RTR (recreation trail).
PROJECT_TYPE PROJECT_TP VARCHAR2 120 Description of the type of recreation feature, i.e., Interpretative Forest, Recreation Trail.
RETIREMENT_DATE RETIRE_DT DATE 7 For a retired recreation feature, this is the date and time the recreation feature was retired.
AMENDMENT_ID AMEND_ID NUMBER 10 The number of times a feature has been amended over its lifetime.
MAP_LABEL MAP_LABEL VARCHAR2 21 The default label often used when displaying the feature on a map, and consists of the FOREST FILE ID and SECTION ID separated by a space, e.g., REC4531 15, REC3069 EATON LAKE.
PROJECT_NAME PROJECT_NM VARCHAR2 100 The name of the area or trail network, usually a geographic name, e.g., OKEOVER TRAILS.
RECREATION_FEATURE_CODE REC_FT_CD VARCHAR2 3 Code describing the type of natural or man made recreation feature, e.g., H3 (Historic Route).
RESOURCE_FEATURE_IND RES_FT_IND VARCHAR2 1 Indicates whether this is a resource feature established under the Government Action Regulation.
RIGHT_OF_WAY RT_OF_WAY NUMBER 7 The entire width of the Right of Way for the linear feature.
ARCH_IMPACT_ASSESS_IND ARCH_IND VARCHAR2 1 Indicates if an archaeological impact assessment has been performed for the given project.
SITE_LOCATION SITE_LOC VARCHAR2 500 The closest town or city to the recreation feature, e.g. KELOWNA, BELLA COOLA.
PROJECT_ESTABLISHED_DATE PROJ_DATE DATE 7 This is the date on which the recreation project was legally established.
RECREATION_DISTRICT_CODE RECDIST_CD VARCHAR2 200 A comma-separated list of codes relating to the recreation districts that the recreation feature is within, e.g., RDCO,RDKB,RDOS.
DEFINED_CAMPSITES DEF_CAMPS NUMBER 5 The total number of campsites.
LIFE_CYCLE_STATUS_CODE LIFE_ST_CD VARCHAR2 7 The life cycle state of the feature, e.g., PENDING, ACTIVE, RETIRED.
FILE_STATUS_CODE FILE_ST_CD VARCHAR2 3 The current status of the recreation tenure, eg. AR (archived), HI (issued), PI (pending issuance).
DISTRICT_CODE DIST_CD VARCHAR2 6 The code of the natural resource district associated with this feature.
DISTRICT_NAME DIST_NM VARCHAR2 6 The name of the natural resource district associated with this feature.
FEATURE_CLASS_SKEY FEAT_CLASS NUMBER 10 Unique identifier for the spatial feature class.
FEATURE_LENGTH FEAT_LNGTH NUMBER 11 Spatial perimeter length in metres. This value is calculated in the source system.
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 The system calculated length or perimeter of a geometry in meters.
GEOMETRY GEOMETRY SDO_GEOMETRY 64 The column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 A column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA BLOB 4000 A binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.