Recreation Sites, Reserves, and Interpretive Forests Details and Closures - Fully Attributed

238 views (3 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Recreation Sites and Trails BC
Licensed under Access Only

The data contained within this spatial layer is an amalgamation of information for trails, Sites, Reserves, and Interpretive Forests derived from Forest Tenure Administration (FTA). The point is derived from the coordinates linked to each recreation number example ( REC1567 ). That coordinate will identify either the trail head or the camping location or access point to the area. Larger areas will be a central point to the polygon.

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. Primary Purpose of this point data is to monitor Closures of specific recreational Trails and Areas

Data Quality

This Data updated frequently

Lineage Statement

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

More Information

Contact Information

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

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2018-08-03
Record Last Modified 2021-06-12
Resource Status onGoing

Object Description


Short Name: REC_CLS_FA
Comments: Recreation Project Fully Attributed Details and Closures

Column Name Short Name Data Type Data Precision Comments
FTEN_RPD_SYSID FTN_RPD_SD NUMBER 10 Is a system generated unique identification number.
FOREST_FILE_ID F_FILE_ID VARCHAR2 10 File identification assigned to Provincial Forest Use files. Assigned file number. Usually the Licence, Tenure or Private Mark number.
PROJECT_NAME PROJECT_NM VARCHAR2 100 A common name given to a recreation site or trail, e.g. CAMPBELL LAKE, GRAY CREEK TRAILS.
PROJECT_TYPE_CODE PRJ_TYP_CD VARCHAR2 120 The project type code, eg inventory
PROJECT_TYPE PRJ_TYPE VARCHAR2 10 A combination of the project type code and the project type text, e.g. SIT - Recreation Site.
PROJECT_ESTABLISHED_DATE PRJ_EST_DT DATE 7 Date on which the project was legally established.
CLOSURE_IND CLOSR_IND CHAR 1 Indicates if the location is closed or not, i.e., Y, N.
CLOSURE_DATE CLOSR_DT DATE 7 The user-entered date on which the Closure comment was entered.
CLOSURE_TYPE CLOSR_TYPE VARCHAR2 20 Indicates the reason for the closure, e.g., Floods, Wildfire, Wind Damage, Wild Life, No Access, Slide Land/Snow, Industrial Work, Environmental, Other.
RECREATION_VIEW_IND REC_VW_IND VARCHAR2 1 Indicates whether a Recreation project must be shown in the Recreation View web mapping toole, i.e., Y and N.
FILE_STATUS_ST FL_STAT_ST VARCHAR2 9 The current status of the forest land use, e.g., Pending - Planned, Harvesting - Suspended, Active. This is a subset of Timber_Status_Code.
STATUS_DESCRIPTION STAT_DESC VARCHAR2 126 The status of the forest land use code and description, e.g., HI - Issued.
SITE_LOCATION SITE_LOC VARCHAR2 500 Is the location name e.g. North side of Bentick Arm between Mohan and Campbell Lake.
DEFINED_CAMPSITES DEFND_CAMP NUMBER 38 Is a count of the total number of campsites in the recreation site.
ARCH_IMPACT_ASSESS_IND ARCH_IMPCT VARCHAR2 1 Indicates if an archaelogical impact assessment has been performed for the given project.
REC_FEATURE_CODE REC_FEAT_C VARCHAR2 10 A code that describes a significant land or environmental condition of the area, e.g., A2 (Aquatic Habitat), B2 (Sand Beach).
REC_FEATURE_DESCRIPTION REC_FEAT_D VARCHAR2 126 A combination of the Feature code and a textual description of the code, e.g., B2 - Sand Beach.
RECREATION_DISTRICT_CODE RECDIST_CD VARCHAR2 30 Administrative recreation district code for the Recreation site, e.g., RDPG.
RECREATION_DISTRICT_NAME RECDIST_NM VARCHAR2 100 Administrative recreation district name for the Recreation site, e.g., Prince George-Mackenzie.
ORG_UNIT_CODE ORG_UNT_CD VARCHAR2 6 Identifies any office within the ministry. First character identifies Exec, HQ branch, Region, or District. Next two chars identify the office name; next two the section (HQ Branch) or program (Region or District); last char identifies the subsection.
ORG_UNIT_NAME ORG_UNT_NM VARCHAR2 100 Is the title of a ministry office or section; for example Kamloops Forest Region; Silviculture Branch; Kispiox Forest District P rotection program.
SITE_DESCRIPTION_BRIEF SIT_DESC_B VARCHAR2 500 A text description generally describing the location of a recreation site. e.g. North side of Bentick Arm between Mohan and Campbell Lake.
TENURE_APP_TOTAL_AREA TOTAL_AREA NUMBER 15 Is the total area of a polygonal feature of a Tenure Applicaton in Hectares.
TENURE_APP_TOTAL_LENGTH TOTAL_LEN NUMBER 15 Is the total length for a linear feature of a Tenure Application in KM.
CLOSURE_COMMENT CLOSR_COM VARCHAR2 4000 Comment about closures information about a recreation site or trail.
SITE_DESCRIPTION ST_DESC VARCHAR2 4000 Comment about descriptive information about a recreation site or trail.
SITE_DESCRIPTION_DATE ST_DESC_DT DATE 7 The user-entered date on which the Site Description comment was entered.
DRIVING_DIRECTIONS DRV_DIRCTN VARCHAR2 4000 Comment about driving directions information about a recreation site or trail.
DRIVING_DIRECTIONS_DATE DRV_DIR_DT DATE 7 The user-entered date on which the Driving Directions comment was entered.
UTM_ZONE UTM_ZONE NUMBER 2 Is a segment of the Earth's surface 6 degrees of longitude in width. The zones are numbered eastward starting at the meridian 180 degrees from the prime meridian at Greenwich. There are five zones in BC (7 to 11), e.g., 10.
UTM_EASTING UTM_EAST NUMBER 9 Is the distance in meters eastward to or from the central meridian of a UTM zone with a false easting of 500000 meters.
UTM_NORTHING UTM_NORTH NUMBER 7 Is the distance in meters northward from the equator.
LATITUDE LATITUDE NUMBER 8 Is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653.
LONGITUDE LONGITUDE NUMBER 9 Is the geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544.
SHAPE SHAPE SDO_GEOMETRY 64 Is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 Is 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 Is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.