Challenge 1: Getting in gear
Introduction
Formula E races are extensively covered with a network of broadcast cameras capturing the on-track action and drama, supplemented by CCTV cameras providing additional views for safety and race control. In this gHack we’ll use CCTV footage to detect any incidents.
Note
A circuit will have multiple CCTV cameras covering different parts of the track, for the sake of simplicity we’ll use the feed from a single camera.
This first step is all about getting started with the source data, which is a collection of 2-minute segments from a CCTV camera.
Description
Create a new bucket, and copy the sample videos from the bucket gs://ghacks-genai-fe/cctv/ to the newly created bucket.
Note
You should navigate to your Cloud Storage bucket and preview the videos to familiarize yourself with the content.
Once the data is in the bucket, create an Object table in BigQuery on that data in a new BigQuery dataset.
Success Criteria
- There is a new Cloud Storage Bucket with the sample video files.
- There is an Object table that makes the sample video files available in BigQuery.
- There are 14 rows in the newly created Object table.