Converts a CartoDB table generated from YB Tracking YML into a linestring

yb-to-linestring.sql

-- Generate the timestamp from the supplied data
UPDATE yb
SET timestamp=to_timestamp(SUBSTRING(name, 7, 20), 'DD-MM-YYYY HH24:MI:SS');

-- Generate the linestring as a new table
CREATE TABLE yb_linestring AS (
  SELECT
    ST_MakeLine(the_geom ORDER BY timestamp) AS the_geom
  FROM yb);

-- Necessary to make the table appear on your CartoDB dashboard
-- (see: https://github.com/CartoDB/cartodb/wiki/creating-tables-though-the-SQL-API)
SELECT cdb_cartodbfytable('yb_linestring');