======================= 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 ---------- .. code-block:: # 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 ------------------------ .. code-block:: # 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 --------------------------------- .. code-block:: 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. .. code-block:: # 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 ---------- .. code-block:: # 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 ------------------------ .. code-block:: # 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 --------------------------------- .. code-block:: 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. .. code-block:: # 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 --------------- .. code-block:: *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