Video Flightline Points
111 views (2 recent)Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Open Government Licence - British Columbia
Data and Resources
BC Physical Shore-Zone Mapping Systempdf
A manual that provides information on the standards for the Physical...
Coastal Resource Information Management Systemhtml
An on-line mapping system that allows users to view, create, query and print...
Coastal Resource PDF Map Viewerhtml
The Coastal Resource Map Viewer provides maps with Coastal Resource...
WMS getCapabilities requestwms
For use in viewers such as ESRI tools Click here for information on how to...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how...
BC Geographic Warehouse Custom Downloadother
Video Flightline Points are a specific GPS spatial point recorded at one-second intervals during the video taping of the shoreline.
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.
|Name||GeoBC Inquiries (pointOfContact)|
|Organization||Ministry of Forests, Lands, Natural Resource Operations and Rural Development|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2020-11-03|
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||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.|