Recreation Polygons

1504 views (16 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

The spatial representation of a recreation feature. This can be either a recreation reserve, recreation site, or an interpretative forest

Data and Resources

Dataset Extent

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

Additional Information

Purpose

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)
EmailBill.Dowedoff@gov.bc.ca
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-06-09
Resource Status onGoing

Object Description

Object Name: WHSE_FOREST_TENURE.FTEN_RECREATION_POLY_SVW

Short Name: FTN_REC_PL
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., REC230971.
SECTION_ID SECTION_ID VARCHAR2 10 An identifier assigned to a section of a recreation feature, and is not used for polygon features.
RECREATION_MAP_FEATURE_CODE REC_MF_CD VARCHAR2 3 Code that identifies the type of recreation feature, i.e., IF (interpretive forest), RR (recreation reserve), SIT (recreation site).
PROJECT_TYPE PROJECT_TP VARCHAR2 120 Description of the type of recreation feature, i.e., Interpretative Forest, Recreation Reserve.
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 only of the FOREST FILE ID, e.g., REC230971.
PROJECT_NAME PROJECT_NM VARCHAR2 100 The name of the recreation project, e.g., KASLO INTERPRETIVE FOREST.
RECREATION_FEATURE_CODE REC_FT_CD VARCHAR2 3 Code describing the type of natural or man made recreation feature, e.g., E5 (mixed forest), F1 (site specific waterfall), H3 (historic site), W4 (marine mammals).
RESOURCE_FEATURE_IND RES_FT_IND VARCHAR2 1 Indicates whether this is a resource feature established under the Government Action Regulation.
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_VIEW_IND REC_VW_IND VARCHAR2 1 Indicates whether the site is displayed to the public on the Recreation Sites and Trails BC web site, i.e., Y, N.
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., RDCC,RDCS,RDMH,RDVA.
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).
GEOGRAPHIC_DISTRICT_CODE GEO_DST_CD VARCHAR2 6 The code of the natural resource district associated with this feature.
GEOGRAPHIC_DISTRICT_NAME GEO_DST_NM VARCHAR2 100 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_AREA FEAT_AREA NUMBER 11 Spatial feature area in square metres. This value is calculated in the source system.
FEATURE_PERIMETER FEAT_PERIM NUMBER 11 Spatial perimeter length in metres. This value is calculated in the source system.
FEATURE_AREA_SQM AREA_SQM VARCHAR2 19 The system calculated area of a two-dimensional polygon in square meters.
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.