NAME columbus3 -- manage Columbus V900 and V990 tracks from the command line SYNOPSYS columbus3 [-h|-v] columbus3 command [options] [args] DESCRIPTION columbus3 manages Columbus V900 and V990 tracks from the command line, allowing a user to associate a sidecar file with the main information about a track, searching tracks (through sidecar files), displaying tracks on a map. EXAMPLES columbus3 -h # get syntax of each command columbus3 process 11010101.CSV # generate a sidecar file columbus3 search 'location ~ "USA"' # get tracks in the USA columbus3 show 11010101.CSV 11010201.CSV # show tracks on a map (_show.html) columbus3 graph 11010101.CSV # show info about a track (_graph.html) if you do not want to type columbus3 each type, you can invoke a console: columbus3 console columbus3:000> process 11010101.CSV columbus3:001> show 11010101.CSV columbus3:002> columbus3 also has a function to convert a GPX into a bunch of CSV files (which you can then process with the other commands), with some limitations (see below). The command is useful if you are using different loggers for generating your tracks: columbus3 convert file.gpx will generate file-1.csv file-2.csv ... one per track in the GPX file. **CSV export limitations** The Columbus V900 format has fields with fixed width, and uses ^@ as a filler. The CSV file generated by the convert command generates fields of variable width (standard CSV files, I dare say). The heading field is not computed and the field is filled with -1. Piping commands. You can pipe the output of a search command to show, using the following syntax: columbus3 search 'location ~ "USA"' --fields path | columbus3 show --sidecar The option --fields shows only the pathname of the files found; the option --sidecar removes the .yaml extension from the list of files found. SEARCH SYNTAX >>> DON'T FORGET TO EMBED YOUR QUERY IN SINGLE QUOTES <<< Terms you can search for: location, start_location, end_location date, start_date, end_date year duration max_speed min_height max_height Numerical operators: <, <=, ==, >=, > String operators (locations): ~ (contains), == (is exactly) Complex Terms: Use "and" and "or" to build complex queries Examples of simple searches 'location ~ "USA"' any track whose start or end location contains USA 'date > 2015-02-14' any track whose start or end date is after Feb 14, 2015 'year == 2015' any track whose start or end date is in 2015 'duration <= 01:02:03' any track with a duration of less than 1h, 2min, and 3secs 'max_speed > 120' any track with a max speed greater than 120 km/h 'min_height == 10' any track with a min height lower than 10 meters Examples of complex searches 'location ~ "USA" and start_date >= 2015-01-01' tracks in the USA after or on Jan 1, 2015 'start_location ~ "Trenton" and end_location ~ "New York"' trips from Trenton to New York List of supported fields in output path -> relative path of the CSV file filename -> basename of the CSV file start_location -> start location end_location -> end location start_date -> start date (and time) end_date -> end date (and time) duration -> duration in seconds min_speed -> minimum speed in km/h max_speed -> maximum speed in km/h min_height -> minimum height in meters max_height -> maximum height in meters VERSION This is version 0.5.0 LICENSE MIT Columbus3 uses leaflet, leafleft-providers, flot, and jquery. They are distributed under a different license: see their websites for more details (or have a look at the license file shipped with the Gem) SEE ALSO If you are looking for a full graphical client, you might want to download Columbus from http://www.minimalbit.com https://github.com/avillafiorita/columbus3