Contact Information

Ministry of Forests, Lands, Natural Resource Operations and Rural Development

Sub-Organization

GeoBC

Access & Security

Who can view this dataset?

Public

Who can download this dataset?

Public

Metadata Information

Record Published

2018-05-01

Record Last Modified

2019-12-17

Resource Status

onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_FERRY_TERMINALS_SV

Short Name: FERRY_TERMComments: GSR_FERRY_TERMINALS_SV is a spatially enabled layer comprising Ferry Terminals. Ferry Terminals is a point dataset identifying vehicle and passenger ferry terminals in British Columbia.

Column Name

Short Name

Data Type

Data Precision

Comments

TERMINAL_NAME

TRMNL_NM

VARCHAR2

500

TERMINAL_NAME is the name of the ferry terminal, e.g., Swartz Bay.

KEYWORDS

KEYWORDS

VARCHAR2

1000

KEYWORDS contains text strings supplied by the Custodian, to be used for search/query purposes. Keywords are separated by the ; delimiter.

STREET_ADDRESS

ST_ADDRESS

VARCHAR2

200

STREET_ADDRESS is a free form expression of the site descriptor (e.g., unit) and the civic building number / street / street indicator portion of an address, e.g., Unit 1, 123 Main Street East.

LOCALITY

LOCALITY

VARCHAR2

100

LOCALITY is the name of the municipality, community, Federal Indian Reserve (IR), subdivision, regional district, indigenous land or natural feature the occupant site is located in, e.g., Victoria, Saanich IR 1, Capital Regional District.

MAILING_ADDRESS contains an address string, not a parsed address. It is the address that will be displayed for presentation purposes, e.g., 32900 Marshall Road, Abbotsford, BC

WEBSITE_URL

WEBSITE

VARCHAR2

500

WEBSITE_URL contains the link to the Home page of the Occupant's Website

IMAGE_URL

IMAGE_URL

VARCHAR2

500

IMAGE_URL contains a full URL link to a picture of the Occupant's Location.

LATITUDE

LATITUDE

NUMBER

9

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

LONGITUDE

LONGITUDE

NUMBER

10

LONGITUDE is the geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544

PHYSICAL_ADDRESS

ADDRESS

VARCHAR2

1000

PHYSICAL_ADDRESS contains the civic or non-civic address as a single string, structured according to the specification of the Physical Address and Geocoding Standard, e.g., 420 GORGE RD E, VICTORIA, BC.

DATE_UPDATED

DT_UPDATE

DATE

7

DATE_UPDATED contains the date that the Occupant data was updated in the Occupant structure (system-generated)

SITE_GEOCODED_IND

GEOCD_IND

VARCHAR2

1

SITE_GEOCODED_IND contains a Flag/indicator (Y/N) that the Occupant Physical Address has been geo-coded by the DataBC Address Geocoder and the results provide a valid site address, e.g., Y, N

SOURCE_DATA_ID

SRCDATA_ID

VARCHAR2

20

SOURCE_DATA_ID is a unique occupant id either supplied by the source data system or produced by GSR, depending on the value of SUPPLIED_SOURCE_ID_IND

CUSTODIAN_ORG_DESCRIPTION

CUST_ORG

VARCHAR2

200

CUSTODIAN_ORG_DESCRIPTION contains the name or description of the custodial organization (usually Ministry and Branch)

BUSINESS_CATEGORY_DESCRIPTION describes the category of business, i.e., Water Transportation Ferries

OCCUPANT_TYPE_DESCRIPTION

OCCPNT_TYP

VARCHAR2

500

OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, e.g. Hospital

SHAPE

SHAPE

SDO_GEOMETRY

64

SHAPE is the column used to reference the spatial coordinates defining the feature.

SEQUENCE_ID

SEQ_ID

NUMBER

10

SEQUENCE_ID contains a value to distinguish occupant instances. Where a single occupant can have multiple instances (representing different services, for example), this field distinguishes this occupant instance from other instances of the same or different occupants.

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.

About Tracking

Google Analytics uses "cookies," which are text files stored on your computer that enable an analysis of your use of the website. Some of the information generated by the cookie about your use of this website may be transmitted to and stored on Google servers outside of Canada. You may refuse the use of cookies by selecting the appropriate settings in your browser; however, please note that if you do so, you may not be able to use the full functionality of this website. Furthermore, you can prevent Google’s collection and use of data generated by the cookie and related to your use of the website by downloading and installing the browser plug-in available at (http://tools.google.com/dlpage/gaoptout?hl=en).