JSFiddle - React, Tailwind, and code Playground

by ffleandro

JavaScript

var statement1 = "http://visualmobility.cartodb.com/api/v2/sql/?q=SELECT transport_mode, SUM(ST_Length(paths.the_geom_webmercator)) AS distance FROM paths WHERE paths.user_id=1 GROUP BY transport_mode ORDER BY distance";

var statement2 = "http://visualmobility.cartodb.com/api/v2/sql/?q=WITH segments AS (SELECT ST_Makeline(points.the_geom_webmercator) as the_geom, paths.transport_mode, paths.cartodb_id AS id FROM points JOIN paths ON points.path_id=paths.cartodb_id WHERE paths.user_id=1 GROUP BY points.path_id, paths.cartodb_id, paths.transport_mode) SELECT SUM(ST_Length(segments.the_geom)) AS distance, segments.transport_mode FROM segments GROUP BY segments.transport_mode ORDER BY distance";

$.get(statement1, function(data){
    console.log("---- Data 1 ----");
    console.log(data);
});

$.get(statement2, function(data){
    console.log("---- Data 2 ----");
    console.log(data);
});