Difference between revisions of "Main Page/Research/MSB/Scripts/log of SMS consistency within each subject"
From phurvitz
Phil Hurvitz (talk | contribs) |
Phil Hurvitz (talk | contribs) |
||
Line 7: | Line 7: | ||
*s11: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s11: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::11 2005-09-11 2005-09-13 2008-01-22 2008-01-23 2008-01-24 2008-01-25 2008-01-27 2008-01-28 | ||
*s12: Excellent, all records have good GPS timestamps. | *s12: Excellent, all records have good GPS timestamps. | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::12 2008-01-21 2008-01-22 2008-01-23 2008-01-24 2008-01-25 | ||
*s13: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s13: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::13 2005-09-11 2008-01-22 2008-01-23 2008-01-24 2005-09-16 2008-01-25 2008-01-27 2008-01-28 | ||
*s15: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s15: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::15 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2005-09-13 | ||
*s16: Excellent, all records have good GPS timestamps. | *s16: Excellent, all records have good GPS timestamps. | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::16 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2008-02-06 | ||
*s17: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s17: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
− | *s18: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | + | *::17 2005-09-11 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2008-02-26 2008-02-27*s18: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::18 2008-02-20 2005-09-11 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-26 2008-02-27 | ||
*s19: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s19: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::19 2005-09-11 2008-02-21 2005-09-15 2005-09-14 2005-09-16 2008-02-29 2008-03-01 2008-03-03 2008-03-04 2008-03-05 | ||
*s20: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s20: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::20 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2005-09-12 2005-09-13 2008-02-27 2008-02-28 2008-02-29 | ||
*s21: Excellent, all records have good GPS timestamps. | *s21: Excellent, all records have good GPS timestamps. | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::21 2008-03-03 2008-03-04 2008-03-05 2008-03-06 2008-03-10 | ||
*s22: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s22: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::22 2008-03-04 2005-09-11 2008-03-05 2008-03-06 | ||
*s23: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s23: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::23 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2005-09-16 2008-03-08 | ||
*s24: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s24: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::24 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10 | ||
*s25: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | *s25: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::25 2005-09-11 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10 | ||
*s26: Problems. | *s26: Problems. | ||
*: 2006-03-01 12:04:46 (row 16) ''bad'' | *: 2006-03-01 12:04:46 (row 16) ''bad'' | ||
*: row 22-33: phone time reset and GPS times are unfixed. Cannot use records | *: row 22-33: phone time reset and GPS times are unfixed. Cannot use records | ||
− | *s27: | + | *::26 2008-03-03 2008-03-04 2008-03-05 2005-09-11 2008-03-11 2008-03-12 2005-09-15 |
− | *s28: | + | *s27: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::27 2005-09-11 2008-03-04 2008-03-05 | ||
+ | *s28: Excellent, all records have good GPS timestamps. | ||
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
+ | *::28 2008-03-05 2008-03-06 | ||
*s29: | *s29: | ||
+ | *::29 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 | ||
*s30: | *s30: | ||
+ | |||
+ | *::30 2005-09-11 2008-03-14 2008-03-15 2005-09-17 2008-03-16 2008-03-17 2008-03-18 2008-03-20 | ||
*s31: | *s31: | ||
+ | *::31 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2005-09-15 2008-03-21 | ||
*s32: | *s32: | ||
+ | *::32 2008-03-19 2008-03-20 | ||
*s33: | *s33: | ||
+ | *::33 2008-03-19 2008-03-20 | ||
*s34: | *s34: | ||
+ | *::34 2005-09-11 2008-03-14 2008-03-15 2008-03-19 2008-03-20 | ||
*s35: | *s35: | ||
+ | *::35 2008-03-19 | ||
*s37: | *s37: | ||
+ | *::37 2008-03-18 2008-03-19 2005-09-11 2008-03-20 2005-09-13 | ||
*s38: | *s38: | ||
+ | *::38 2005-09-11 2008-03-21 2005-09-16 2008-03-22 2008-03-23 2008-03-24 2005-09-12 2008-03-25 2008-03-26 | ||
*s39: | *s39: | ||
+ | *::39 2008-04-08 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2005-09-11 2008-04-14 | ||
*s45: | *s45: | ||
+ | *::45 2008-04-09 2008-04-11 2005-09-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16 | ||
*s46: | *s46: | ||
+ | *::46 2005-09-11 2005-09-14 2005-09-15 2008-04-11 2008-04-12 2008-04-13 | ||
*s50: | *s50: | ||
+ | *::50 2005-09-16 | ||
*s51: | *s51: | ||
+ | *::51 2005-09-11 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 | ||
*s52: | *s52: | ||
+ | *::52 2005-09-11 2005-09-16 2005-09-17 2008-04-19 2005-09-18 2005-09-12 2008-04-21 2005-09-13 2008-04-22 2008-04-23 2008-04-24 | ||
*s54: | *s54: | ||
+ | *::54 2005-09-11 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24 | ||
*s55: | *s55: | ||
+ | *::55 2008-04-18 2008-04-19 2008-04-21 2008-04-22 2008-04-23 2008-04-24 | ||
*s56: | *s56: | ||
+ | *::56 2008-04-19 2008-04-20 2008-04-21 2005-09-12 2008-04-22 2008-04-23 2008-04-24 2008-04-25 | ||
*s58: | *s58: | ||
+ | *::58 2005-09-11 2008-04-19 2008-04-22 2008-04-23 2005-09-16 2008-04-25 2008-04-26 2008-04-27 2008-04-28 2008-04-29 | ||
*s61: | *s61: | ||
+ | *::61 2008-04-30 2005-09-11 2008-05-01 2008-05-02 2008-05-03 2008-05-04 2008-05-05 2008-05-06 | ||
*s62: | *s62: | ||
+ | *::62 2008-04-30 2008-05-01 2005-09-16 2008-05-03 2008-05-04 2008-05-05 2008-05-06 | ||
*s63: | *s63: | ||
+ | *::63 2008-04-30 2008-05-03 2008-05-04 2008-05-05 | ||
*s64: | *s64: | ||
+ | *::64 2008-04-30 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2008-05-06 | ||
*s66: | *s66: | ||
+ | *::66 2005-09-11 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2005-09-13 | ||
*s67: | *s67: | ||
+ | *::67 2008-05-08 2008-05-09 2005-09-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2005-09-15 | ||
*s68: | *s68: | ||
+ | *::68 2008-05-15 2008-05-16 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21 2008-05-22 | ||
*s69: | *s69: | ||
+ | *::69 2008-05-13 2008-05-14 2008-05-15 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21 | ||
*s70: | *s70: | ||
+ | *::70 2008-05-08 2008-05-09 2008-05-10 2008-05-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2008-05-16 |
Revision as of 01:01, 20 January 2009
This list summarizes how to deal with individual SMS files
- s01: cannot be conflated due to no timestamps on SMS
- s03: cannot be conflated due to no timestamps on SMS
- s06: cannot be conflated due to no timestamps on SMS
- s09: cannot be conflated due to no timestamps on SMS
- s10: cannot be conflated due to no timestamps on SMS
- s11: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 11 2005-09-11 2005-09-13 2008-01-22 2008-01-23 2008-01-24 2008-01-25 2008-01-27 2008-01-28
- Assume all MyExperience records with no SMS will have the same offsets applied
- s12: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 12 2008-01-21 2008-01-22 2008-01-23 2008-01-24 2008-01-25
- Assume all MyExperience records with no SMS will have the same offsets applied
- s13: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 13 2005-09-11 2008-01-22 2008-01-23 2008-01-24 2005-09-16 2008-01-25 2008-01-27 2008-01-28
- Assume all MyExperience records with no SMS will have the same offsets applied
- s15: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 15 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2005-09-13
- Assume all MyExperience records with no SMS will have the same offsets applied
- s16: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 16 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2008-02-06
- Assume all MyExperience records with no SMS will have the same offsets applied
- s17: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 17 2005-09-11 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2008-02-26 2008-02-27*s18: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 18 2008-02-20 2005-09-11 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-26 2008-02-27
- Assume all MyExperience records with no SMS will have the same offsets applied
- s19: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 19 2005-09-11 2008-02-21 2005-09-15 2005-09-14 2005-09-16 2008-02-29 2008-03-01 2008-03-03 2008-03-04 2008-03-05
- Assume all MyExperience records with no SMS will have the same offsets applied
- s20: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 20 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2005-09-12 2005-09-13 2008-02-27 2008-02-28 2008-02-29
- Assume all MyExperience records with no SMS will have the same offsets applied
- s21: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 21 2008-03-03 2008-03-04 2008-03-05 2008-03-06 2008-03-10
- Assume all MyExperience records with no SMS will have the same offsets applied
- s22: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 22 2008-03-04 2005-09-11 2008-03-05 2008-03-06
- Assume all MyExperience records with no SMS will have the same offsets applied
- s23: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 23 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2005-09-16 2008-03-08
- Assume all MyExperience records with no SMS will have the same offsets applied
- s24: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 24 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10
- Assume all MyExperience records with no SMS will have the same offsets applied
- s25: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 25 2005-09-11 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10
- Assume all MyExperience records with no SMS will have the same offsets applied
- s26: Problems.
- 2006-03-01 12:04:46 (row 16) bad
- row 22-33: phone time reset and GPS times are unfixed. Cannot use records
- 26 2008-03-03 2008-03-04 2008-03-05 2005-09-11 2008-03-11 2008-03-12 2005-09-15
- s27: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 27 2005-09-11 2008-03-04 2008-03-05
- Assume all MyExperience records with no SMS will have the same offsets applied
- s28: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 28 2008-03-05 2008-03-06
- Assume all MyExperience records with no SMS will have the same offsets applied
- s29:
- 29 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18
- s30:
- 30 2005-09-11 2008-03-14 2008-03-15 2005-09-17 2008-03-16 2008-03-17 2008-03-18 2008-03-20
- s31:
- 31 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2005-09-15 2008-03-21
- s32:
- 32 2008-03-19 2008-03-20
- s33:
- 33 2008-03-19 2008-03-20
- s34:
- 34 2005-09-11 2008-03-14 2008-03-15 2008-03-19 2008-03-20
- s35:
- 35 2008-03-19
- s37:
- 37 2008-03-18 2008-03-19 2005-09-11 2008-03-20 2005-09-13
- s38:
- 38 2005-09-11 2008-03-21 2005-09-16 2008-03-22 2008-03-23 2008-03-24 2005-09-12 2008-03-25 2008-03-26
- s39:
- 39 2008-04-08 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2005-09-11 2008-04-14
- s45:
- 45 2008-04-09 2008-04-11 2005-09-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16
- s46:
- 46 2005-09-11 2005-09-14 2005-09-15 2008-04-11 2008-04-12 2008-04-13
- s50:
- 50 2005-09-16
- s51:
- 51 2005-09-11 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23
- s52:
- 52 2005-09-11 2005-09-16 2005-09-17 2008-04-19 2005-09-18 2005-09-12 2008-04-21 2005-09-13 2008-04-22 2008-04-23 2008-04-24
- s54:
- 54 2005-09-11 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- s55:
- 55 2008-04-18 2008-04-19 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- s56:
- 56 2008-04-19 2008-04-20 2008-04-21 2005-09-12 2008-04-22 2008-04-23 2008-04-24 2008-04-25
- s58:
- 58 2005-09-11 2008-04-19 2008-04-22 2008-04-23 2005-09-16 2008-04-25 2008-04-26 2008-04-27 2008-04-28 2008-04-29
- s61:
- 61 2008-04-30 2005-09-11 2008-05-01 2008-05-02 2008-05-03 2008-05-04 2008-05-05 2008-05-06
- s62:
- 62 2008-04-30 2008-05-01 2005-09-16 2008-05-03 2008-05-04 2008-05-05 2008-05-06
- s63:
- 63 2008-04-30 2008-05-03 2008-05-04 2008-05-05
- s64:
- 64 2008-04-30 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2008-05-06
- s66:
- 66 2005-09-11 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2005-09-13
- s67:
- 67 2008-05-08 2008-05-09 2005-09-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2005-09-15
- s68:
- 68 2008-05-15 2008-05-16 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21 2008-05-22
- s69:
- 69 2008-05-13 2008-05-14 2008-05-15 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21
- s70:
- 70 2008-05-08 2008-05-09 2008-05-10 2008-05-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2008-05-16