Research Installations Government View

392 views (10 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Forest Improvement and Research Management
Licensed under Access Only

Identifies the physical locations for a research installations within the province of British Columbia. View is for Governement Staff

Data and Resources

Dataset Extent

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

Additional Information

Purpose

To identify where research installation are physically located within British Columbia to avoid resource conflicts. For use in land use planning, land statusing and Forest Stewardship Plans.

Data Quality
Lineage Statement

Spatial view built from WHSE_FOREST_VEGETATION.RESPROJ_RSRCH_INSTLTNS_SP

Contact Information

NameKeith Thomas (pointOfContact)
EmailKeith.Thomas@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationTree Improvement

Access & Security

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

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-02-11
Resource Status completed

Object Description

Object Name: WHSE_FOREST_VEGETATION.RESPROJ_RSRCH_INSTLTNS_GOV_SVW

Short Name: RINSTL_GOV

Column Name Short Name Data Type Data Precision Comments
STUDY_SITE STUDY_SITE VARCHAR2 50 STUDY SITE is a short name for the research installation.
LOCATION_NAME LOC_NAME VARCHAR2 50 LOCATION NAME of the nearest location (e.g. Walker Creek) to the research installation.
RESEARCH_INST_STATUS_CODE IN_STAT_CD VARCHAR2 10 RESEARCH INST STATUS CODE identifies the Installation Status as one of ACT (Active), DRM (Dormant), TRM (Terminated) or COM (Complete).
RESEARCH_INST_STATUS_DESC IN_STAT_DS VARCHAR2 20 RESEARCH INST STATUS DESC is a textual description of the Research Installation Status Code.
ORG_UNIT_NO ORG_NO NUMBER 10 ORG UNIT NO is a physical identifier for the storage of organizational unit codes for the Ministry of Forests offices. Values stored here are for the computers use only, and are not to be used by people as "ministry codes".
ORG_UNIT_NAME ORG_NAME VARCHAR2 100 ORG UNIT NAME or title of a ministry office or section; for example Kamloops Forest Region; Silviculture Branch; Kispiox Forest District P rotection program.
CLIENT_NUMBER CLNT_NUM VARCHAR2 8 CLIENT NUMBER is a sequentially assigned number to identify a ministry client.
CLIENT_NAME CLNT_NAME VARCHAR2 60 CLIENT NAME or title of a ministry client.
MAP_NOTATION_ID MAP_NOT_ID VARCHAR2 10 MAP NOTATION ID identifies a map notation that may be created under the forest act to protect this site if it is on crown land within a provincial forest. A null value means there is no map notation known.
PROJECT_KEY PROJ_KEY VARCHAR2 40 PROJECT KEY is a business key used to uniquely identify a project or sub-project which normally beings with EP followed by a number.
PROJECT_TITLE PROJ_TITLE VARCHAR2 255 PROJECT TITLE used to describe the project.
PROJECT_DESCRIPTION PROJ_DESC VARCHAR2 1000 PROJECT DESCRIPTION is a long textual description for the project.
RESEARCH_PROJECT_TYPE_CODE PR_TYPE_CD VARCHAR2 10 RESEARCH PROJECT TYPE CODE is a numeric identifier representing the Project Type; for example 1 (Research), 2(Nursery Experiment/Trial) and 3(Field Experiment/Trial).
RESEARCH_PROJECT_TYPE_DESC PR_TYPE_DS VARCHAR2 120 RESEARCH PROJECT STATUS DESC is a textual description of the Research Project Status Code.
RESEARCH_PROJECT_STATUS_CODE PR_STAT_CD VARCHAR2 10 RESEARCH PROJECT STATUS CODE identifies the Project Status as one of ACT (Active), DRM (Dormant), TRM (Terminated) or COM (Complete).
RESEARCH_PROJECT_STATUS_DESC PR_STAT_DS VARCHAR2 120 RESEARCH PROJECT STATUS DESC is a textual description of the Research Project Status Code.
RESOURCE_FEATURE_IND R_FEAT_IND VARCHAR2 1 RESOURCE FEATURE IND represents whether the installation been designated as a resource feature.
OTHER_ORGANISATION OTHER_ORG VARCHAR2 60 OTHER ORGANISATION identifies the organisation that is responsible for the installation where the ministry is not responsible for the installation.
ESTABLISHMENT_DATE ESTAB_DATE DATE 7 ESTABLISHMENT DATE the representing when installation was established and became an asset. To calculate the approximate current stand age, add establishment age to the duration in years between present time and the establishment date.
ESTABLISHMENT_AGE ESTAB_AGE NUMBER 3 ESTABLISHMENT AGE (years) of the stand at the time of establishment. To calculate the approximate current stand age, add establishment age to the duration in years between present time and the establishment date.
NOTES NOTES VARCHAR2 2000 NOTES or free form comments about the installation. This attribute is also used as an audit field for identifying the reasons behind the most recent modifications to an installation.
HAZARDS HAZARDS VARCHAR2 255 HAZARDS or hazardous conditions that may exist at the installation.
CONTACT_NAME CONT_NAME VARCHAR2 51 CONTACT NAME of the contact.
CONTACT_EMAIL CONT_EMAIL VARCHAR2 120 CONTACT EMAIL address of the contact.
CONTACT_PHONE_NUMBER CONT_PHN_N VARCHAR2 10 CONTACT PHONE NUMBER of the contact formated digits without spaces or country code; for example Vivid's phone number would be persisted as 2503856040.
CONTACT_PHONE_EXT CONT_PHN_E VARCHAR2 5 CONTACT PHONE EXT of the contact formatted as numeric digits without spaces; for example 228.
ACTUAL_START_DATE START_DATE DATE 7 ACTUAL START DATE represents the date the project started.
PLANNED_COMPLETION_DATE PLN_CMP_DT DATE 7 PLANNED COMPLETION DATE represents the planned completion date for the project.
ACTUAL_END_DATE END_DATE DATE 7 ACTUAL END DATE of when the project was deemed completed or terminated.
PRECISION PRECISION NUMBER 4 PRECISION is a length (in metres) to describe the accuracy of the geometry measurement. Zero is the most precise.
CONFIDENCE CONFIDENCE VARCHAR2 10 CONFIDENCE is a rating of the accuracy of the geometry. Current values are 1 - 5. With one being the least accurate.
BUFFER_DISTANCE BUFF_DIST NUMBER 4 BUFFER DISTANCE is a distance (in metres) around the geometry of the installation which may be considered reserved.
FEATURE_AREA_SQM NUMBER 19
FEATURE_LENGTH_M NUMBER 19
GEOMETRY GEOMETRY SDO_GEOMETRY 64 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

Comments

No comments have been posted yet.