Shipwreck Point Locations

356 views (3 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Access Only

The locations of coastal shipwrecks in British Columbia.

Data and Resources

Dataset Extent

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

Additional Information


To show the locations of all shipwrecks in coastal British Columbia waters.

Contact Information

NameGeoBC Inquiries (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development

Access & Security

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

Metadata Information

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

Object Description


Comments: A SHIPWRECK SP is a marine vessel that is incapable of floating and whose structure has been abandoned.

Column Name Short Name Data Type Data Precision Comments
SHIPWRECK_ID SHPWRCK_ID NUMBER 10 SHIPWRECK ID is the unique Identifier for a particular shipwreck. This is a primary key, e.g., 1,2,3
ASSOCIATED_PHYIDENT PHYIDENT VARCHAR2 13 ASSOCIATED PHYIDENT is a 13-character slash-delimited identifier used in the Biophysical Shorezone system that identifies the section of shoreline that has the shipwreck on it, e.g., 15/08/0238/00
PROJECT_CODE PRJCT_CODE VARCHAR2 6 The PROJECT CODE is a unique 6-character code of capitalised letters assigned to a project area in the BioPhysical Shorezone project. E.g., MIDC, SGI
CAPTURE_YEAR CAPTURE_YR VARCHAR2 4 CAPTURE YEAR is the year that the xshore information about the ASSOCIATED PHYIDENT was recorded in the Biophysical Shorezone system that identified that the PHYIDENT had a SHIPWRECK on it, e.g, 2004
DATA_SOURCE DATA_SRC VARCHAR2 50 DATA SOURCE is an indication of the source of the information that identified that a SHIPWRECK was present, e.g., SHZN XSHORE CODINGS table
LONGITUDE LONGITUDE NUMBER 10 LONGITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544
LATITUDE LATITUDE NUMBER 10 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653
MARGIN_OF_ERROR MARGIN_ERR NUMBER 4 MARGIN OF ERROR is a calculated measurement, in metres, of how close the actual shipwreck is to the recorded LONGITUDE and LATITUDE. Because the location of the SHIPWRECK POINT was placed using the midpoint of the ASSOCIATED PHYIDENT line, the MARGIN OF ERROR is calculated as the length of the ASSOCIATED PHYIDENT line divided by 2 and the result rounded to the nearest whole number, e.g., 34
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.