Data Used By Tracktable¶
Tracktable operates on CSV (comma-separated values), TSV (tab-separated values) and TRAJ (comma-separated trajectory values) files. The data contained in the CSV and TSV files can be either for points or trajectories and both file types abide by the same formatting and rules for comments and skippable headers. The TRAJ files are a specialized file type specific to tracktable that contains assembled trajectories that can be used directly without the need to re-assemble them as after they have been loaded. This has advantages over reading in point data from a CSV file and then assembling the points into trajectories.
Support for storing and loading trajectories using GeoJSON files is slated for release no later than Tracktable 1.7.
Note
The only difference in the examples for CSV and TSV files is the delimiter. The data sets are identical.
CSV Data¶
Point Data¶
# object_id timestamp latitude longitude altitude heading speed
KKK011,2004-12-07 11:36:18,-81.9731,26.995,2700,108,349,0
KKK011,2004-12-07 11:37:56,-81.9844,27.0447,4200,108,349,-27
KKK011,2004-12-07 11:39:18,-82.0458,27.1136,6700,225,322,-22
KKK011,2004-12-07 11:40:18,-82.0961,27.1389,7900,180,300,5
KKK011,2004-12-07 11:41:18,-82.1442,27.1683,9200,181,305,-2
KKK011,2004-12-07 11:42:18,-82.1967,27.1978,10300,193,303,-1
KKK011,2004-12-07 11:43:18,-82.2469,27.2253,11300,183,302,0
KKK011,2004-12-07 11:44:18,-82.2997,27.2544,12500,193,302,1
KKK011,2004-12-07 11:45:18,-82.3525,27.2839,13500,194,303,6
KKK011,2004-12-07 11:46:18,-82.4008,27.3175,14400,190,309,-8
Point Data With Comments¶
# object_id timestamp latitude longitude altitude heading speed
KKK011,2004-12-07 11:36:18,-81.9731,26.995,2700,108,349,0
#KKK011,2004-12-07 11:37:56,-81.9844,27.0447,4200,108,349,-27
# KKK011,2004-12-07 11:39:18,-82.0458,27.1136,6700,225,322,-22
KKK011,2004-12-07 11:40:18,-82.0961,27.1389,7900,180,300,5
KKK011#,2004-12-07 11:41:18,-82.1442,27.1683,9200,181,305,-2
#
#
KKK011,2004-12-07 11:42:18,-82.1967,27.1978,10300,193,303,-1
KKK011,2004-12-07 11:43:18,-82.2469,27.2253,11300,183,302,0
KKK011,2004-12-07 11:44:18,-82.2997,27.2544,12500,193,302,1
Point Data With Skippable Headers¶
Undelimited line header with additional and maybe irrelevant information
This part of the file is not intended to be processed
# object_id timestamp latitude longitude altitude heading speed
KKK011,2004-12-07 11:36:18,-81.9731,26.995,2700,108,349,0
#KKK011,2004-12-07 11:37:56,-81.9844,27.0447,4200,108,349,-27
# KKK011,2004-12-07 11:39:18,-82.0458,27.1136,6700,225,322,-22
KKK011,2004-12-07 11:40:18,-82.0961,27.1389,7900,180,300,5
KKK011#,2004-12-07 11:41:18,-82.1442,27.1683,9200,181,305,-2
#
#
KKK011,2004-12-07 11:42:18,-82.1967,27.1978,10300,193,303,-1
Note
Headers are not skipped by default. Comment delimiters and hard values for number of lines to skip are passed in as parameters when configuring your point and trajectory readers.
Trajectory Data¶
Tip
Trajectory data also allows for comments and skippable headers.
# object_id timestamp longitude latitude
TSTISTPHX0,2014-07-01 15:45:43-0000,28.814605999999998,40.976922
TSTORDDEL0,2014-07-01 15:45:43-0000,-87.904842,41.97860299999999
TSTYYZDEN0,2014-07-01 15:45:43-0000,-79.63055600000001,43.677223
TSTSEACGK0,2014-07-01 15:45:43-0000,-122.309306,47.449
TSTORDMCO0,2014-07-01 15:45:43-0000,-87.90484200000002,41.978602999999985
TSTSZXAMS0,2014-07-01 15:45:43-0000,113.81066399999999,22.639257999999995
TSTMSPATL0,2014-07-01 15:45:43-0000,-93.22176699999999,44.881955999999995
TSTPEKKUL0,2014-07-01 15:45:43-0000,116.58455599999999,40.080111
TSTFCOATL0,2014-07-01 15:45:43-0000,12.250797000000004,41.804475
TSTPHXPVG0,2014-07-01 15:45:43-0000,-112.01158300000002,33.43427799999999
TSV Data¶
Point Data¶
# object_id timestamp longitude latitude
ANON 2014-01-01 00:00:00 132.3653180042665 37.83452922520744
ANON 2014-01-01 00:00:00 140.1555350524732 37.00319417805791
ANON 2014-01-01 00:00:00 138.8552751176905 33.91442753969869
ANON 2014-01-01 00:00:00 139.54339149007725 34.37733184602518
ANON 2014-01-01 00:00:00 138.6712734537105 36.79593017895808
ANON 2014-01-01 00:00:00 142.1620084423819 35.09865794853191
ANON 2014-01-01 00:00:00 145.53358077966556 41.534209724603194
ANON 2014-01-01 00:00:00 139.7960001774872 35.78134081160728
ANON 2014-01-01 00:00:00 140.82555476137813 35.69316848225954
ANON 2014-01-01 00:00:00 145.63477153712424 37.974929548163544
Point Data With Comments¶
# object_id timestamp latitude longitude altitude heading speed
KKK011 2004-12-07 11:36:18 -81.9731 26.995 2700 108 349 0
#KKK011 2004-12-07 11:37:56 -81.9844 27.0447 4200 108 349 -27
# KKK011 2004-12-07 11:39:18 -82.0458 27.1136 6700 225 322 -22
KKK011 2004-12-07 11:40:18 -82.0961 27.1389 7900 180 300 5
KKK011# 2004-12-07 11:41:18 -82.1442 27.1683 9200 181 305 -2
#
#
KKK011 2004-12-07 11:42:18 -82.1967 27.1978 10300 193 303 -1
KKK011 2004-12-07 11:43:18 -82.2469 27.2253 11300 183 302 0
KKK011 2004-12-07 11:44:18 -82.2997 27.2544 12500 193 302 1
Point Data With Skippable Headers¶
Undelimited line header with additional and maybe irrelevant information
This part of the file is not intended to be processed
# object_id timestamp latitude longitude altitude heading speed
KKK011 2004-12-07 11:36:18 -81.9731 26.995 2700 108 349 0
#KKK011 2004-12-07 11:37:56 -81.9844 27.0447 4200 108 349 -27
# KKK011 2004-12-07 11:39:18 -82.0458 27.1136 6700 225 322 -22
KKK011 2004-12-07 11:40:18 -82.0961 27.1389 7900 180 300 5
KKK011# 2004-12-07 11:41:18 -82.1442 27.1683 9200 181 305 -2
#
#
KKK011 2004-12-07 11:42:18 -82.1967 27.1978 10300 193 303 -1
Note
Headers are not skipped by default. Comment delimeters and hard values for number of lines to skip are passed in as parameters when configuring your point and trajectory readers.
Trajectory Data¶
Tip
Trajectory data also allows for comments and skippable headers.
# object_id timestamp longitude latitude
TSTISTPHX0 2014-07-01 15:45:43-0000 28.814605999999998 40.976922
TSTORDDEL0 2014-07-01 15:45:43-0000 -87.904842 41.97860299999999
TSTYYZDEN0 2014-07-01 15:45:43-0000 -79.63055600000001 43.677223
TSTSEACGK0 2014-07-01 15:45:43-0000 -122.309306 47.449
TSTORDMCO0 2014-07-01 15:45:43-0000 -87.90484200000002 41.978602999999985
TSTSZXAMS0 2014-07-01 15:45:43-0000 113.81066399999999 22.639257999999995
TSTMSPATL0 2014-07-01 15:45:43-0000 -93.22176699999999 44.881955999999995
TSTPEKKUL0 2014-07-01 15:45:43-0000 116.58455599999999 40.080111
TSTFCOATL0 2014-07-01 15:45:43-0000 12.250797000000004 41.804475
TSTPHXPVG0 2014-07-01 15:45:43-0000 -112.01158300000002 33.43427799999999
TRAJ Data¶
Note
Tracktable can also use input from .traj files. As this format is specific
to Tracktable, it is still best and most convenient to use the methods above
when getting started.
Trajectory Data¶
*T*,generic,19,0,*P*,generic,2,1,1,0,TSTBOSEWR1,2014-07-01 15:45:43,-71.005181,42.364347,TSTBOSEWR1,2014-07-01 15:46:48,-71.185258,42.273778,TSTBOSEWR1,2014-07-01 15:47:52,-71.364817,42.182929,TSTBOSEWR1,2014-07-01 15:48:57,-71.54386,42.0918,TSTBOSEWR1,2014-07-01 15:50:01,-71.722388,42.000394,TSTBOSEWR1,2014-07-01 15:51:05,-71.900403,41.908712,TSTBOSEWR1,2014-07-01 15:52:10,-72.077908,41.816756,TSTBOSEWR1,2014-07-01 15:53:14,-72.254902,41.724528,TSTBOSEWR1,2014-07-01 15:54:19,-72.431388,41.632028,TSTBOSEWR1,2014-07-01 15:55:23,-72.607368,41.53926,TSTBOSEWR1,2014-07-01 15:56:28,-72.782843,41.446224,TSTBOSEWR1,2014-07-01 15:57:32,-72.957814,41.352922,TSTBOSEWR1,2014-07-01 15:58:36,-73.132284,41.259356,TSTBOSEWR1,2014-07-01 15:59:41,-73.306255,41.165527,TSTBOSEWR1,2014-07-01 16:00:45,-73.479727,41.071437,TSTBOSEWR1,2014-07-01 16:01:50,-73.652702,40.977088,TSTBOSEWR1,2014-07-01 16:02:54,-73.825183,40.882481,TSTBOSEWR1,2014-07-01 16:03:59,-73.997171,40.787618,TSTBOSEWR1,2014-07-01 16:05:03,-74.168667,40.6925
*T*,generic,19,0,*P*,generic,2,1,1,0,TSTEWRBOS0,2014-07-01 15:45:43,-74.168667,40.6925,TSTEWRBOS0,2014-07-01 15:46:48,-73.997171,40.787618,TSTEWRBOS0,2014-07-01 15:47:52,-73.825183,40.882481,TSTEWRBOS0,2014-07-01 15:48:57,-73.652702,40.977088,TSTEWRBOS0,2014-07-01 15:50:01,-73.479727,41.071437,TSTEWRBOS0,2014-07-01 15:51:05,-73.306255,41.165527,TSTEWRBOS0,2014-07-01 15:52:10,-73.132284,41.259356,TSTEWRBOS0,2014-07-01 15:53:14,-72.957814,41.352922,TSTEWRBOS0,2014-07-01 15:54:19,-72.782843,41.446224,TSTEWRBOS0,2014-07-01 15:55:23,-72.607368,41.53926,TSTEWRBOS0,2014-07-01 15:56:28,-72.431388,41.632028,TSTEWRBOS0,2014-07-01 15:57:32,-72.254902,41.724528,TSTEWRBOS0,2014-07-01 15:58:36,-72.077908,41.816756,TSTEWRBOS0,2014-07-01 15:59:41,-71.900403,41.908712,TSTEWRBOS0,2014-07-01 16:00:45,-71.722388,42.000394,TSTEWRBOS0,2014-07-01 16:01:50,-71.54386,42.0918,TSTEWRBOS0,2014-07-01 16:02:54,-71.364817,42.182929,TSTEWRBOS0,2014-07-01 16:03:59,-71.185258,42.273778,TSTEWRBOS0,2014-07-01 16:05:03,-71.005181,42.364347
*T*,generic,22,0,*P*,generic,2,1,1,0,TSTAMSLHR0,2014-07-01 15:45:43,4.763889,52.308613,TSTAMSLHR0,2014-07-01 15:46:47,4.5108253,52.274336,TSTAMSLHR0,2014-07-01 15:47:50,4.2581558,52.239519,TSTAMSLHR0,2014-07-01 15:48:54,4.0058855,52.204163,TSTAMSLHR0,2014-07-01 15:49:57,3.7540193,52.16827,TSTAMSLHR0,2014-07-01 15:51:00,3.5025622,52.131842,TSTAMSLHR0,2014-07-01 15:52:04,3.251519,52.09488,TSTAMSLHR0,2014-07-01 15:53:07,3.0008944,52.057385,TSTAMSLHR0,2014-07-01 15:54:11,2.7506931,52.01936,TSTAMSLHR0,2014-07-01 15:55:14,2.5009198,51.980806,TSTAMSLHR0,2014-07-01 15:56:18,2.2515791,51.941724,TSTAMSLHR0,2014-07-01 15:57:21,2.0026753,51.902117,TSTAMSLHR0,2014-07-01 15:58:24,1.7542129,51.861985,TSTAMSLHR0,2014-07-01 15:59:28,1.5061963,51.821331,TSTAMSLHR0,2014-07-01 16:00:31,1.2586298,51.780156,TSTAMSLHR0,2014-07-01 16:01:35,1.0115175,51.738463,TSTAMSLHR0,2014-07-01 16:02:38,0.7648637,51.696252,TSTAMSLHR0,2014-07-01 16:03:42,0.51867235,51.653525,TSTAMSLHR0,2014-07-01 16:04:45,0.27294751,51.610285,TSTAMSLHR0,2014-07-01 16:05:49,0.027693103,51.566533,TSTAMSLHR0,2014-07-01 16:06:52,-0.217087,51.522271,TSTAMSLHR0,2014-07-01 16:07:55,-0.461389,51.4775
*T*,generic,18,0,*P*,generic,2,1,1,0,TSTLGWCDG0,2014-07-01 15:45:43,-0.190278,51.148056,TSTLGWCDG0,2014-07-01 15:46:48,-0.022190327,51.02428,TSTLGWCDG0,2014-07-01 15:47:53,0.14500127,50.900265,TSTLGWCDG0,2014-07-01 15:48:59,0.31130378,50.776012,TSTLGWCDG0,2014-07-01 15:50:04,0.47672415,50.651524,TSTLGWCDG0,2014-07-01 15:51:09,0.64126931,50.526803,TSTLGWCDG0,2014-07-01 15:52:14,0.80494612,50.401851,TSTLGWCDG0,2014-07-01 15:53:19,0.9677614,50.276671,TSTLGWCDG0,2014-07-01 15:54:24,1.1297219,50.151264,TSTLGWCDG0,2014-07-01 15:55:29,1.2908344,50.025634,TSTLGWCDG0,2014-07-01 15:56:34,1.4511056,49.899781,TSTLGWCDG0,2014-07-01 15:57:39,1.6105422,49.773709,TSTLGWCDG0,2014-07-01 15:58:44,1.7691506,49.647419,TSTLGWCDG0,2014-07-01 15:59:50,1.9269376,49.520914,TSTLGWCDG0,2014-07-01 16:00:55,2.0839096,49.394195,TSTLGWCDG0,2014-07-01 16:02:00,2.240073,49.267265,TSTLGWCDG0,2014-07-01 16:03:05,2.3954344,49.140126,TSTLGWCDG0,2014-07-01 16:04:10,2.55,49.012779
*T*,generic,20,0,*P*,generic,2,1,1,0,TSTLHRCDG0,2014-07-01 15:45:43,-0.461389,51.4775,TSTLHRCDG0,2014-07-01 15:46:49,-0.29493924,51.349773,TSTLHRCDG0,2014-07-01 15:47:55,-0.12941572,51.221812,TSTLHRCDG0,2014-07-01 15:49:01,0.03518925,51.093618,TSTLHRCDG0,2014-07-01 15:50:07,0.19888329,50.965195,TSTLHRCDG0,2014-07-01 15:51:13,0.36167397,50.836544,TSTLHRCDG0,2014-07-01 15:52:18,0.52356881,50.707668,TSTLHRCDG0,2014-07-01 15:53:24,0.68457527,50.578569,TSTLHRCDG0,2014-07-01 15:54:30,0.84470075,50.449249,TSTLHRCDG0,2014-07-01 15:55:36,1.0039526,50.319711,TSTLHRCDG0,2014-07-01 15:56:42,1.1623381,50.189956,TSTLHRCDG0,2014-07-01 15:57:48,1.3198646,50.059988,TSTLHRCDG0,2014-07-01 15:58:54,1.4765391,49.929807,TSTLHRCDG0,2014-07-01 15:59:59,1.6323689,49.799416,TSTLHRCDG0,2014-07-01 16:01:05,1.787361,49.668817,TSTLHRCDG0,2014-07-01 16:02:11,1.9415224,49.538013,TSTLHRCDG0,2014-07-01 16:03:17,2.0948601,49.407005,TSTLHRCDG0,2014-07-01 16:04:23,2.2473811,49.275795,TSTLHRCDG0,2014-07-01 16:05:29,2.3990921,49.144386,TSTLHRCDG0,2014-07-01 16:06:35,2.55,49.012779