Video Flightline Points

58 views (6 recent)

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

VIDEO FLIGHT POINTS are a specific GPS spatial point recorded during the video taping of the shoreline. They are represented by a specific latitude and longitude taken at a specific date and time. They are associated with a specific VIDEO SEGMENT and link to online Youtube video of the recorded flight.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Video Flightline Points are a specific GPS spatial point recorded at one-second intervals during the video taping of the shoreline.

Data Quality

The British Columbia Coastal Resource Information System (CRIMS) is an internet based interactive map for viewing coastal and marine data. A wide variety of coast and marine resources are included, such as aquaculture, shoreline classification, selected fisheries information, and offshore oil and gas information. The development of the Coastal Resource Information System is ongoing. The application provides access to data currently held in the BC Geographic Warehouse. As additional layers are added to the BCGW, subsequent releases of the application will include these additional layers and further enhancements.

Lineage Statement

Contact Information

NameCarol Ogborne (pointOfContact)
EmailCarol.Ogborne@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 2018-06-06
Record Last Modified 2018-07-06
Resource Status onGoing

Object Description

Object Name: WHSE_ENVIRONMENTAL_MONITORING.SHZN_VIDEO_FLIGHTLINE_POINTS

Short Name: SHZNVDFLGH
Comments: VIDEO FLIGHT POINTS are a specific GPS spatial point recorded during the video taping of the shoreline. They are represented by a specific latitude and longitude taken at a specific date and time. They are associated with a specific VIDEO SEGMENT.

Column Name Short Name Data Type Data Precision Comments
VIDEO_FLIGHTLINE_POINT_ID VD_FLGH_ID NUMBER 10 The VIDEO FLIGHTLINE POINT ID is the system-generated unique identifier assigned to the individual VIDEO FLIGHTLINE POINT. It is assigned by SDE.
VIDEO_SEGMENT_ID VD_SGMN_ID VARCHAR2 200 The VIDEO SEGMENT ID is a textual filename that uniquely identifies the VIDEO SEGMENT by PROJECT CODE, DVD year, number, description and file extension. It is also the name of the file that is stored in the image warehouse and forms part of the IMAGE WAREHOUSE URL i.e. sgi_04_14_08_bold_bluff_pt_musgrave_pt_cape_keppel.wmv
TIME_UTC TIME_UTC NUMBER 6 TIME UTC is the exact time the VIDEO FLIGHT POINT was recorded. The TIME UTC is documented using the universal standard Universal Time code (UTC) i.e. the time 2:31:57 PM in UTC is 143157. Thus, all TIME UTC entries are a maximum of 6 digits long.
DATE_UTC DATE_UTC NUMBER 8 DATE UTC is the exact date the VIDEO FLIGHT POINT was recorded. The DATE UTC is documented using the universal standard Universal Time code (UTC) i.e. the date 2009 March 31 in UTC is 20090331.Thus, all DATE UTC entries are a maximum of 8 digits long.
LATITUDE LATITUDE NUMBER 38 LATITUDE is the exact latitudinal position on the surface of the Earth of the VIDEO VEHICLE at the DATE_UTC and TIME_UTC that the VIDEO_FLIGHTLINE_POINT was recorded. The standard used is Decimal Degrees i.e. 48.69734 represents 48.69734 degrees above the equator (the equator is always at 0 degrees latitude)
LONGITUDE LONGITUDE NUMBER 38 LONGITUDE is the exact longitudinal position on the surface of the Earth of the VIDEO VEHICLE at the DATE_UTC and TIME_UTC that the VIDEO_FLIGHTLINE_POINT was recorded. The standard used is Decimal Degrees i.e. -123.480959 represents -123.480959 degrees from the Prime Meridian (the Prime Meridian is always 0 degrees longitude and, for historical reasons, runs through the old Royal Astronomical Observatory in Greenwich, England)
YOUTUBE_URL YTUBE_URL VARCHAR2 254 The YOUTUBE URL is a Youtube.com-generated URL that uniquely identifies both the VIDEO SEGMENTas posted on the YouTube.com free video-posting website as well as an offset in seconds from the start of the video that is used to approximately place this particular point in the timeline of the video.
GEOMETRY GEOMETRY SDO_GEOMETRY 1 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA ANNO_CAD 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.

Comments

No comments have been posted yet.