Flood Protection Works - Structural Works

664 views (9 recent)

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

Global Positioning Survey (in 2004) of Existing Flood Protection Works (dike crests and bank protection) in British Columbia, with some updates on an irregular basis.

For more information on dike management and safety, please see: http://www.env.gov.bc.ca/wsd/public_safety/flood/fhm-2012/safety_index.html

For contact names regarding regional diking issues, please see: http://www.env.gov.bc.ca/wsd/public_safety/flood/pdfs_word/dike_safety_contacts_may-2015.pdf

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Spatial display of Flood Protection Works linear data (dike crests and erosion protection).

Data Quality
Lineage Statement

Contact Information

NameMitchell Hahn (businessExpert)
EmailMitchell.Hahn@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationWater Management
NameDavid Tesch (pointOfContact)
EmailDavid.Tesch@gov.bc.ca
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 2011-03-09
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_WATER_MANAGEMENT.FPW_FLOOD_PROTECTION_WRK_LINE

Short Name: FPW_FPWKLN
Comments: A standard engineered or designed structure constructed to prevent flooding of land. Dikes include many forms of flood protection works. The term "dike" usually refers to an embankment fill.

Column Name Short Name Data Type Data Precision Comments
FLOOD_PROTECTION_WORKS_ID FLDPRTCTNW NUMBER 7 Surrogate primary key
FLOOD_PROTECTION_SYSTEM_ID FLDPRTCTNS NUMBER 5 Surrogate primary key
WORKS_TYPE WORKS_TYPE VARCHAR2 10 Defines the sub-type
COMMENTS COMMENTS VARCHAR2 100 Miscellaneous comments about the works
MAX_POSITNL_DILUTION_OF_PRECSN MXPSTNLDLT NUMBER 5 The maximum Positional Dilution Of Precision during the GPS data collection.
MAX_HORZNTL_DILUTION_OF_PRECSN MXHRZNTLDL NUMBER 5 The maximum Horizontal Dilution Of Precision during the GPS data collection.
SURVEY_DATE SRVDT DATE 7 The date and time the feature was surveyed with GPS
GPS_POSITION_FIX_COUNT GPSPSTNFXC NUMBER 4 The number of individual GPS position fixes accepted to create the averaged point feature location, or the number of individual GPS fixes in a linear feature.
AVG_HORZNTL_PRECSN VGHRZNTLPR NUMBER 16 The average horizontal precision estimate, in metres, of the feature location
FEATURE_CODE FTRCD VARCHAR2 10 A means of linking a feature to its real world name and definition.
DIKE_CREST_MATERIAL DKCRSTMTRL VARCHAR2 8 The material from which the dike crest is made, like "earth", "gravel", or "concrete"
DIKE_CREST_WIDTH DKCRSTWDTH NUMBER 4 The width in meters of the dike crest
DIKE_CREST_FENCE DKCRSTFNC VARCHAR2 10 Indicates the location of fence(s) parallel to the dike crest
DIKE_CREST_DRIVEABLE_IND DKCRSTDRVB VARCHAR2 3 Indicates whether or not ("yes" or "no") the crest can be driven upon
EROSION_PROTECTION_TYPE RSNPRTCTNT VARCHAR2 15 The type of erosion protection, like "riprap", "concrete wall", or "lock block wall"
EROSION_PROTECTION_SIDE RSNPRTCTNS VARCHAR2 5 The side of the waterway on which the protection is located ("left" or "right")
NULL1 NULL1 VARCHAR2 100
NULL2 NULL2 VARCHAR2 100
NULL3 NULL3 VARCHAR2 2
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 NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters

Comments

No comments have been posted yet.