Coastal BC Marinas

429 views (8 recent)

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

The location of coastal British Columbia marinas

Data and Resources

Dataset Extent

Latitude: 48.2° to 55.5°
Longitude: -132.6° to -122.4°

Additional Information

Purpose

To show the locations of marinas along coastal British Columbia that will aid in the planning and support for emergency response along the coast

Lineage Statement

Resource information is collected using peer-reviewed provincial Resource Information Standards Committee (RISC) which include standards for data management and analysis.

Contact Information

NameGeoBC Inquiries (pointOfContact)
EmailGeoBCInfo@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC

Access & Security

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

Metadata Information

Record Published 2011-10-12
Record Last Modified 2019-09-05
Resource Status completed

Object Description

Object Name: WHSE_ENVIRONMENTAL_MONITORING.CHRA_MARINAS_POINT

Short Name: MARINA_PNT
Comments: MARINA POINT represents the location of coastal British Columbia marinas.

Column Name Short Name Data Type Data Precision Comments
MARINA_ID MARINA_ID NUMBER 8 A unique numeric identifier assigned to this grid line.
FEATURE_CODE F_CODE VARCHAR2 10 An alphanumeric code used to identify a feature component. All CCSM feature codes are generated according to the Canadian Council on Survey and Mapping (CCSM) Draft Standard on feature code classification.
RELATIVE_IMPORTANCE REL_IMPORT NUMBER 1 Relative Importance of this feature. Rated from 1 (lowest) to 5 (highest).
NAME NAME VARCHAR2 60 NAME is the name of marina.
DESCRIPTION DESCRIPT VARCHAR2 100 DESCRIPTION is a description of the marina.
CONTACT CONTACT VARCHAR2 40 CONTACT is the marina contact person.
STREET_ADDRESS STR_ADDRES VARCHAR2 35 STREET ADDRESS is the street portion of the marina mailing address.
LOCATION LOCATION VARCHAR2 35 LOCATION is a description of the location of the marina (if different from STREET ADDRESS).
CITY CITY VARCHAR2 25 CITY is the city portion of the marina mailing address.
PROVINCE PROVINCE VARCHAR2 11 PROVINCE is the province portion of the marina mailing address.
POSTAL_CODE POSTAL_COD VARCHAR2 9 POSTAL CODE is the postal code portion of the marina mailing address.
PRIMARY_PHONE_NUMBER PRI_PHNE_N VARCHAR2 15 PRIMARY PHONE NUMBER is the primary phone number of the marina.
SECONDARY_PHONE_NUMBER SEC_PHNE_N VARCHAR2 15 SECONDARY PHONE NUMBER is an alternate phone number for the marina.
FAX_NUMBER FAX_NUMBER VARCHAR2 15 FAX NUMBER is the fax number for the marina.
EMAIL_ADDRESS EMAIL_ADDR VARCHAR2 30 EMAIL ADDRESS is the email address of the marina.
ACCOMODATION_TYPE ACCOM_TYPE VARCHAR2 5 ACCOMMODATION TYPE is a 5-letter code describing the type of accomodations offered by the marina. Most are self-explanatory and include:Backc = Back Country campingBed = Bed and BreakfastCabinCampCampg = CampgroundCondoFloatHotelLodgeMotelPriva = Private accommodationPubli = Public accommodation
UNIT_TOTAL UNIT_TOTAL NUMBER 38 UNIT TOTAL is the total number of units of all types at the marina. A Unit, typically, is a vacant place in the marina in which boats of different types can be moored.
CAMPSITE_TOTAL CAMPSITE_T NUMBER 38 CAMPSITE TOTAL is the total number of campsites at the marina.
MOORAGE_AVAILABLE MOORAGE_AV CHAR 1 MOORAGE AVAILABLE indicates whether moorage is available at the marina (Y/N/U).
MAX_BOATS MAX_BOATS NUMBER 38 MAX BOATS is the total number of boats the marina could hold.
AVG_DEPTH AVG_DEPTH NUMBER 38 AVG DEPTH describes the marina's average water depth in metres.
AVG_OCCUPATION AVG_OCCUP NUMBER 38 AVG OCCUPATION provides an indication of the average number of units that have boats moored at any given time during the year. A comparison of the AVG OCCUPATION to the UNIT TOTAL would give a percentage average occupancy for this marina.
PEAK_PERIOD PEAK_PERID VARCHAR2 6 PEAK PERIOD indicates the time of year that the marina tends to be most used. i.e. JN-SEPT or SUMMER or ALL YEAR for those marinas that constantly have a high occupancy rate.
FUELING_AVAILABLE FUEL_AVL CHAR 1 FUELING AVAILABLE indicates whether fueling is available at the marina (Y/N/U).
GAS_AVAILABLE GAS_AVL CHAR 1 GAS AVAILABLE indicates whether gas is available at the marina (Y/N/U).
DIESEL_AVAILABLE DIESEL_AV CHAR 1 DIESEL AVAILABLE indicates whether diesel is available at the marina (Y/N/U).
LUBRICANTS_AVAILABLE LUB_AVL CHAR 1 LUBRICANTS AVAILABLE indicates whether oil/lubricants are available at the marina (Y/N/U).
MARINE_SUPPLIES_AVAILABLE MARINA_SUP CHAR 1 MARINE SUPPLIES AVAILABLE indicates whether marine supplies are available at the marina (Y/N/U).
POWER_AVAILABLE PWR_AVL VARCHAR2 15 POWER AVAILABLE indicates what power amperages are available at the marina (15 / 20 / 30 / 50).
WATER_AVAILABLE WATER_AVL CHAR 1 WATER AVAILABLE indicates whether fresh water is available at the marina (Y/N/U).
DISPOSAL_AVAILABLE DISPSL_AVL CHAR 1 DISPOSAL AVAILABLE indicates whether garbage disposal is available at the marina (Y/N/U).
WASHROOMS_AVAILABLE WSHRM_AVL CHAR 1 WASHROOMS AVAILABLE indicates whether washrooms are available at the marina (Y/N/U).
SHOWERS_AVAILABLE SHOW_AVL CHAR 1 SHOWERS AVAILABLE indicates whether showers are available at the marina (Y/N/U).
LAUNDRY_AVAILABLE LNDRY_AVL CHAR 1 LAUNDRY AVAILABLE indicates whether laundry service is available at the marina (Y/N/U).
RV_SITE_TOTAL RV_SITE_TO NUMBER 38 RV SITE TOTAL is the total number of recreational vehicle sites at the marina.
LIVE_ABOARDS_TOTAL LIVE_ABOAR NUMBER 38 LIVE ABOARDS TOTAL is the total number of people who reside onboard their boats while moored at the marina.
HOLDING_TANKS_TOTAL HOLD_TANKS NUMBER 38 HOLDING TANKS TOTAL is the total number of boats that have onboard holding tanks. Holding tanks typically contain liquids such as fresh water or bilge waste.
TREATMENT_TYPE TREAT_AVL VARCHAR2 6 TREATMENT TYPE is the type of system used by the marina to treat the moored boat's holding tank contents if the holding tanks contain bilge. i.e Sewer, Septic, Dischg
RESTAURANT_AVAILABLE RSTRT_AVL CHAR 1 RESTAURANT AVAILABLE indicates whether a restaurant or bar is available at the marina (Y/N/U).
TOURS_AVAILABLE TRSVLBL CHAR 1 TOURS AVAILABLE indicates whether guided tours are available at the marina (Y/N).
SEASON SEASON VARCHAR2 24 SEASON indicates the range of months that the marina is in operation. i.e. MAY-SEPT
COMMENTS COMMENTS VARCHAR2 250 COMMENTS are comments specific to feature.
DATA_SOURCE DATA_SRC VARCHAR2 250 DATA SOURCE describes the source from which the feature was derived. DATA SOURCE can be CHS Charts and other maps, mapbooks, streetmaps, private industry publications, focus groups, various published commonly-used directories or BC Ministry's or Municipality's published works.
SOURCE_PROJECT SOURCE_PRJ VARCHAR2 10 SOURCE PROJECT is the coastal mapping region or project from which this feature was derived.
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.