Fish Data Collected Lakes SIR

97 views (2 recent)

Published by the Ministry of Environment and Climate Change Strategy - Ecosystems
Licensed under Access Only

Lakes for which fish data has been collected

Data and Resources

Dataset Extent

Latitude: 49.3° to 53.1°
Longitude: -123.9° to -117.8°

Additional Information

Purpose

To show the spatial locations of fish data collected lakes

Lineage Statement

This data has been developed for regional operations

Contact Information

NameDave Tesch (pointOfContact)
EmailDavid.Tesch@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEcosystems

Access & Security

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

Metadata Information

Record Published 2014-12-15
Record Last Modified 2019-08-28
Resource Status completed

Object Description

Object Name: REG_LAND_AND_NATURAL_RESOURCE.FISH_DATA_COLL_LAKES_SIR_POLY

Short Name: FSHDTCLLLK

Column Name Short Name Data Type Data Precision Comments
WB_KEY WB_KEY NUMBER 10
WS_CODE WS_CODE VARCHAR2 45
GAZE_NAME GAZE_NAME VARCHAR2 30
LWSL_R8_ LWSL_R8_ NUMBER 18
ORAKEY ORAKEY VARCHAR2 54
XREF_WS_CO XREF_WS_CO VARCHAR2 37
WS_KEY WS_KEY NUMBER 10
BL_KEY BL_KEY NUMBER 10
LWSL_R8_ID LWSL_R8_ID NUMBER 18
LAKE_CODE LAKE_CODE VARCHAR2 3
ALIAS_1 ALIAS_1 VARCHAR2 30
WLKCOL_SIR_TYPE WLKCLSRTP VARCHAR2 1
WSD_ID WSD_ID VARCHAR2 15
ALIAS_2 ALIAS_2 VARCHAR2 30
SEG_NO SEG_NO NUMBER 10
ALIAS_3 ALIAS_3 VARCHAR2 30
OLD_WS_COD OLD_WS_COD VARCHAR2 37
WB_KEY_WG WB_KEY_WG VARCHAR2 9
GIS_TAG GIS_TAG VARCHAR2 15
SEG_PROP SEG_PROP VARCHAR2 5
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.
FEATURE_AREA_SQM FEAT_AREA NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters