-
Notifications
You must be signed in to change notification settings - Fork 2
7 Browser video tutorial
Sven edited this page Dec 30, 2015
·
1 revision
This browser can be used along with either the SenseCam or the Vicon Revue. For the May 2011 release, below are video clips showing the various features/functions of the browser, and how to carry them out:
Extracting more detailed information from the database. Using Microsoft SQL Server Management Studio Expresscom/fwlink/?linkid=65110]
Open Microsoft SQL Server Management Studio Express as detailed in Open MS SQL Server Management studio express and Open Oxford CLARITY SenseCam management database
-
- To retrieve event codings/annotations...
SELECT u.name, evnt.start_time, evnt.end_time, coding.annotation_name
FROM SC_Browser_User_Annotations AS coding
INNER JOIN Users AS u
ON coding.[user_id] = u.[user_id]
INNER JOIN All_Events AS evnt
ON coding.[user_id] = evnt.[user_id] AND coding.event_id = evnt.event_id
ORDER BY u.[user_id], evnt.start_time