VEHPI-11: Design GPS log table

Issue Information

Issue Type: Sub-task
 
Priority: Major
Status: Closed

Reported By:
Ben Tasker
Assigned To:
Ben Tasker
Project: VehManPi (VEHPI)
Resolution: Done (2013-12-28 05:38:51)
Target version: 1.0,
Components: GPS , Database ,

Created: 2013-12-12 19:19:37
Time Spent Working
Child of: VEHPI-8: Set up Sqlite DB


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


Toggle State Changes

Activity


2013-12-21 20:02:57
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
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
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'