paddle_activities_view (view)
1 row
This data as json, CSV (advanced)
Suggested facets: start_time (date), stop_time (date)
| activity_id | name | description | sport | sub_sport | start_time | stop_time | elapsed_time | distance | strokes | avg_stroke_distance | avg_cadence | max_cadence | avg_hr | max_hr | calories | avg_temperature | avg_speed | max_speed | training_effect | anaerobic_training_effect | start_loc | stop_loc |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22111079566 | stand_up_paddleboarding | generic | 2026-03-09 13:00:16.000000 | 2026-03-09 13:00:16.000000 | 00:23:40.116000 | 1.5 | 638 | 2.4 | 27 | 45 | 97 | 131 | 108.0 | 127.0 | 3.9 | 15.5 | 0.3 | 0.0 | http://maps.google.com/?ie=UTF8&q=9.5630144979804754,100.0241573061794&z=13 | http://maps.google.com/?ie=UTF8&q=9.5629799645394087,100.02413735724986&z=13 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paddle_activities_view AS SELECT activities.activity_id AS activity_id, activities.name AS name, activities.description AS description, activities.sport AS sport, activities.sub_sport AS sub_sport, activities.start_time AS start_time, activities.stop_time AS stop_time, activities.elapsed_time AS elapsed_time, ROUND(activities.distance, 1) AS distance , paddle_activities.strokes AS strokes, ROUND(paddle_activities.avg_stroke_distance, 1) AS avg_stroke_distance , activities.avg_cadence AS avg_cadence, activities.max_cadence AS max_cadence, activities.avg_hr AS avg_hr, activities.max_hr AS max_hr, ROUND(activities.calories, 1) AS calories , ROUND(activities.avg_temperature, 1) AS avg_temperature , ROUND(activities.avg_speed, 1) AS avg_speed , ROUND(activities.max_speed, 1) AS max_speed , activities.training_effect AS training_effect, activities.anaerobic_training_effect AS anaerobic_training_effect, "http://maps.google.com/?ie=UTF8&q=" || activities.start_lat || "," || activities.start_long || "&z=13" AS start_loc, "http://maps.google.com/?ie=UTF8&q=" || activities.stop_lat || "," || activities.stop_long || "&z=13" AS stop_loc FROM paddle_activities JOIN activities ON activities.activity_id = paddle_activities.activity_id ORDER BY activities.start_time DESC;