Flood Protection Works - Appurtenant Structures.

376 views (14 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 (appurtenant structures on or near dikes) in British Columbia with occasional updates since then.

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 appurtenant structures point locations, along with url links to images at photo point locations.

Data Quality
Lineage Statement

Spatial view is a join of the base tables FPW_APPURTENANT_STRCTRE_POINT and FPW_FLOOD_PROTECTION_PHOTOS.

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_APPURTENANT_STRUCTURE_SVW

Short Name: FPW_AS_SVW

Column Name Short Name Data Type Data Precision Comments
APPURTENANT_STRUCTURE_ID PPRTNNTSTR NUMBER 9
FLOOD_PROTECTION_SYSTEM_ID FLDPRTCTNS NUMBER 5
POINT_TYPE POINT_TYPE VARCHAR2 10
COMMENTS COMMENTS VARCHAR2 100
MAX_POSITNL_DILUTION_OF_PRECSN MXPSTNLDLT NUMBER 5
MAX_HORZNTL_DILUTION_OF_PRECSN MXHRZNTLDL NUMBER 5
SURVEY_DATE SRVDT DATE 7
GPS_POSITION_FIX_COUNT GPSPSTNFXC NUMBER 4
HORIZONTAL_PRECISION HRZNTLPRCS NUMBER 16
STANDARD_DEVIATION STNDRDDVTN NUMBER 16
FOOT_BRIDGE_SIDE FTBRDGSD VARCHAR2 10
FOOT_BRIDGE_MATERIAL FTBRDGMTRL VARCHAR2 10
PROTECTION_POINT_END PRTCTNPNTN VARCHAR2 10
PROTECTION_POINT_TYPE PRTCTNPNTT VARCHAR2 10
PROTECTION_POINT_CONDITION PRTCTNPNTC VARCHAR2 5
CULVERT_MATERIAL CLVRTMTRL VARCHAR2 10
CULVERT_END CLVRTND VARCHAR2 10
CULVERT_SIZE CLVRTSZ NUMBER 5
MONUMENT_MARKINGS MNMNTMRKNG VARCHAR2 100
MONUMENT_TYPE MNMNTTP VARCHAR2 20
ACCESS_POINT_TYPE CCSSPNTTP VARCHAR2 20
ACCESS_POINT_SIDE CCSSPNTSD VARCHAR2 10
ACCESS_POINT_NAME CCSSPNTNM VARCHAR2 100
WEIR_SIDE WEIR_SIDE VARCHAR2 5
WEIR_MATERIAL WRMTRL VARCHAR2 10
PLATFORM_OBSTRUCTION_IND PLTFRMBSTR VARCHAR2 3
STAIRS_MATERIAL STRSMTRL VARCHAR2 10
STAIRS_OBSTRUCTION_IND STRSBSTRCT VARCHAR2 3
FENCE_GATE_POINT_TYPE FNCGTPNTTP VARCHAR2 20
LOCK_IDENTIFICATION_FEATURE LCKDNTFCTN VARCHAR2 30
CROSS_SECTION_IDENTIFIER CRSSSCTNDN VARCHAR2 30
GAUGE_TYPE GAUGE_TYPE VARCHAR2 10
GAUGE_READABILITY GGRDBLT VARCHAR2 20
PUMP_HOUSE_BUILDING_MATERIAL PMPHSBLDNG VARCHAR2 10
PUMP_HOUSE_CORNER PMPHSCRNR VARCHAR2 2
PUMP_HOUSE_DIMENSIONS PMPHSDMNSN VARCHAR2 100
VEHICLE_BRIDGE_SIDE VHCLBRDGSD VARCHAR2 10
VEHICLE_BRIDGE_END VHCLBRDGND VARCHAR2 10
VEHICLE_BRIDGE_MATERIAL VHCLBRDGMT VARCHAR2 10
VEHICLE_BRIDGE_USAGE VHCLBRDGSG VARCHAR2 10
VEHICLE_BRIDGE_NAME VHCLBRDGNM VARCHAR2 100
DROP_STRUCTURE_SIDE DRPSTRCTRS VARCHAR2 5
STRUCTURE_MATERIAL STRCTRMTRL VARCHAR2 10
FLOOD_BOX_CONCRETE_INLET_IND FLDBXCNCRT VARCHAR2 3
FLOOD_BOX_CONCRETE_OUTLET_IND FLDBXCNCR1 VARCHAR2 3
FLOOD_BOX_TRASH_RACK_IND FLDBXTRSHR VARCHAR2 3
FLOOD_BOX_GATE_TYPE FLDBXGTTP VARCHAR2 15
FLOOD_BOX_FUNCTIONAL_IND FLDBXFNCTN VARCHAR2 5
FLOOD_BOX_NUMBER_OF_PIPES FLDBXNMBRF NUMBER 2
MANHOLE_TYPE MNHLTP VARCHAR2 10
GROYNE_END GROYNE_END VARCHAR2 5
GROYNE_MATERIAL GRNMTRL VARCHAR2 10
GROYNE_WIDTH GRNWDTH NUMBER 4
ALIGNMENT_POINT_TYPE LGNMNTPNTT VARCHAR2 20
SIGN_MATERIAL SGNMTRL VARCHAR2 10
SIGN_TEXT SIGN_TEXT VARCHAR2 100
OUTLET_POINT_CONCRETE_IND TLTPNTCNCR VARCHAR2 3
OUTLET_POINT_GATE_TYPE TLTPNTGTTP VARCHAR2 20
OUTLET_POINT_NUMBER_OF_PIPES TLTPNTNMBR NUMBER 2
NULL1 NULL1 VARCHAR2 100
NULL2 NULL2 VARCHAR2 100
NULL3 NULL3 VARCHAR2 2
NULL4 NULL4 VARCHAR2 500
NULL5 NULL5 VARCHAR2 100
NULL6 NULL6 VARCHAR2 1000
FLOOD_PROTECTION_PHOTO_ID FLDPRTCTNP NUMBER 10
PHOTO_APPURTENANT_STRUCTURE_ID PHTPPRTNNT NUMBER 9
PHOTO_URL PHOTO_URL VARCHAR2 200
PHOTO_FILENAME PHTFLNM VARCHAR2 30
AZIMUTH AZIMUTH NUMBER 3
PHOTO_COMMENTS PHTCMMNTS VARCHAR2 100
FEATURE_CODE FTRCD VARCHAR2 10
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.