Non-TRIM Hydrography

476 views (5 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Water Management
Licensed under Open Government Licence - British Columbia

Province-wide SDE layer showing licensed water sources (streams and lakes), under the Water Act, (current and historical), not captured (displayed) on TRIM base mapping (or Freshwater Atlas base mapping). Includes an attribute for the internal Source Code number, which is associated with the (E-Licensing) stream name.

Data and Resources

Dataset Extent

Latitude: 47.8° to 60.2°
Longitude: -135.2° to -111.1°

Additional Information


Layer intended to keep track of licensed sources not on TRIM.

Contact Information

NameAnn Matteson (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationWater Management
NameWater Business Mailbox (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationWater Management

Access & Security

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

Metadata Information

Record Published 2014-08-07
Record Last Modified 2021-05-14
Resource Status onGoing

Object Description


Short Name: NTRM_HL_SP
Comments: A Non TRIM Hydrography Line ( NON TRIM HYDGRPH LINE SP ) is a linear hydrographical feature, digitized whenever the source doesn't show up on TRIM (or not in the same location as TRIM). This is not a multipart feature class.

Column Name Short Name Data Type Data Precision Comments
NON_TRIM_HYDRGRPH_LINE_ID NTRIM_LNID NUMBER 10 Primary unique numeric identifier for a feature.
FEATURE_CODE FEAT_CODE VARCHAR2 10 A standard numeric code to identify the type of feature represented by the spatial data. A feature code is most importantly a means of linking a feature to its name and definition. For example, the code GB15300120 on a digital geographic feature links it to the name "Lake - Dry" with the definition "A lake bed from which all water has drained or evaporated." The feature code does NOT mark when it was digitized, what dataset it belongs to, how accurate it is, what it should look like when plotted, or who is responsible for updating it. It only says what it represents in the real world. It also doesn't even matter how the lake is represented. If it is a very small lake, it may be stored as a point feature. If it is large enough to have a shape at the scale of data capture, it may be stored as an outline, or a closed polygon. The same feature code still links it to the same definition.
SOURCE_CODE SRCE_CODE VARCHAR2 10 Beginning with "SO�" - This is the source code and links to the WLIS database, for the stream name. (There are additional attributes available).
STREAM_NAME STREAM_NAM VARCHAR2 30 This field descibes the name of the stream
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_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters