########################################################################################## VEHPI-11: Design GPS log table ########################################################################################## Issue Type: Sub-task ----------------------------------------------------------------------------------------- Issue Information ==================== Priority: Major Status: Closed Resolution: Done (2013-12-28 05:38:51) Project: VehManPi (VEHPI) Reported By: btasker Assigned To: btasker Child of: VEHPI-8 - Set up Sqlite DB Components: - GPS - Database Targeted for fix in version: - 1.0 Time Estimate: 0 minutes Time Logged: 0 minutes ----------------------------------------------------------------------------------------- Issue Description ================== When recording a journey, the GPS subsytems will write location data to the SQLite db. This will then be extracted and converted to a GPX file just prior to submission ----------------------------------------------------------------------------------------- Activity ========== ----------------------------------------------------------------------------------------- 2013-12-21 20:02:57 btasker ----------------------------------------------------------------------------------------- Going to want 4 tables I think *Journeys* - ID - Start time - End time - In progress - Uploading - Uploaded time *Tracks* - Journey ID - Track ID - Start - End - In progress *Segments* - Track ID - Start - End - In progress *TrackPoints* - Segment ID - Lat - Lon - Time - Elevation - Speed ----------------------------------------------------------------------------------------- 2013-12-21 20:17:25 btasker ----------------------------------------------------------------------------------------- To save (potentially massive) selects, also need to record the last known position (incl timestamp). Will use the state table for that though ----------------------------------------------------------------------------------------- 2013-12-22 23:21:32 btasker ----------------------------------------------------------------------------------------- Need to add a field to Journeys to indicate whether the journey has been exported (as may have been exported but not uploaded). ----------------------------------------------------------------------------------------- 2013-12-22 23:23:00 ----------------------------------------------------------------------------------------- btasker changed status from 'Open' to 'In Progress' ----------------------------------------------------------------------------------------- 2013-12-28 05:38:51 ----------------------------------------------------------------------------------------- btasker changed status from 'In Progress' to 'Resolved' ----------------------------------------------------------------------------------------- 2013-12-28 05:38:51 ----------------------------------------------------------------------------------------- btasker added 'Done' to resolution ----------------------------------------------------------------------------------------- 2013-12-28 05:38:56 ----------------------------------------------------------------------------------------- btasker changed status from 'Resolved' to 'Closed'