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

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


Going to want 4 tables I think

- ID
- Start time
- End time
- In progress
- Uploading
- Uploaded time

- Journey ID
- Track ID
- Start
- End
- In progress

- Track ID
- Start
- End
- In progress

- Segment ID
- Lat
- Lon
- Time
- Elevation
- Speed
To save (potentially massive) selects, also need to record the last known position (incl timestamp). Will use the state table for that though
Need to add a field to Journeys to indicate whether the journey has been exported (as may have been exported but not uploaded).
btasker changed status from 'Open' to 'In Progress'
btasker changed status from 'In Progress' to 'Resolved'
btasker added 'Done' to resolution
btasker changed status from 'Resolved' to 'Closed'