hiking_activities_view (view)

9 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: distance, avg_pace, avg_steps_per_min, max_steps_per_min, max_hr, avg_speed, max_speed, training_effect, anaerobic_training_effect, heart_rate_zone_three_time, heart_rate_zone_four_time, start_time (date), stop_time (date)

activity_id name description start_time stop_time elapsed_time distance steps avg_pace avg_moving_pace max_pace avg_steps_per_min max_steps_per_min avg_hr max_hr calories avg_temperature avg_speed max_speed avg_step_length vo2_max training_effect anaerobic_training_effect heart_rate_zone_one_time heart_rate_zone_two_time heart_rate_zone_three_time heart_rate_zone_four_time heart_rate_zone_five_time start_loc stop_loc
20162320151 Frederikshavn Hiking   2025-08-24 13:50:25.000000 2025-08-24 13:50:25.000000 01:25:25.566000 3.1 4924 00:43:36.819813 00:28:30.895287 00:08:12.756949 38.0 242.0 67 87 121 127.0 2.2 11.8     0.0 0.0 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=57.420912226662,10.5092517379671&z=13 http://maps.google.com/?ie=UTF8&q=57.4205257371068,10.5072923004627&z=13
19872466540 Highlands Hiking   2025-07-28 10:03:32.000000 2025-07-28 10:03:32.000000 00:56:47.020000 3.8 5760 00:23:47.989571 00:21:25.248646 00:13:25.880935 92.0 232.0 90 117 187 127.0 4.1 7.2     0.3 0.0 00:15:05.999000 00:00:38.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=58.5762005858123,-4.76778024807572&z=13 http://maps.google.com/?ie=UTF8&q=58.5760612785816,-4.76783950813115&z=13
19854044089 Western Isles Hiking   2025-07-26 12:23:07.000000 2025-07-26 12:23:07.000000 01:33:20.976000 5.6 8456 00:26:36.571611 00:23:21.465393 00:13:22.265292 78.0 244.0 84 115 256 127.0 3.6 7.2     0.2 0.0 00:06:38.006000 00:00:21.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=57.6054455246776,-7.51839187927544&z=13 http://maps.google.com/?ie=UTF8&q=57.6054577622563,-7.51839439384639&z=13
19657897584 Trøllanes Hiking   2025-07-07 11:05:21.000000 2025-07-07 11:05:21.000000 01:56:39.772000 4.5 7334 00:32:18.968967 00:23:28.739794 00:10:36.355944 68.0 230.0 91 144 305 127.0 3.0 9.1     1.9 0.0 00:09:55.000000 00:14:25.999000 00:03:42.002000 00:00:00.000000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=62.361739045009,-6.79050472564995&z=13 http://maps.google.com/?ie=UTF8&q=62.3615854885429,-6.7895317543298&z=13
19651766914 Gjógv Hiking   2025-07-06 15:45:49.000000 2025-07-06 15:45:49.000000 01:00:21.407000 2.6 5238 00:36:56.727529 00:26:59.414288 00:12:04.603441 70.0 244.0 98 144 239 127.0 2.6 8.0     1.9 0.3 00:09:47.430000 00:11:40.998000 00:05:21.000000 00:00:00.000000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=62.3259942512959,-6.94469226524234&z=13 http://maps.google.com/?ie=UTF8&q=62.3246735986322,-6.94741713814437&z=13
19651765716 Funningur Hiking   2025-07-06 13:54:23.000000 2025-07-06 13:54:23.000000 01:28:25.868000 4.0 8496 00:35:40.085459 00:29:54.875086 00:06:29.388882 66.0 250.0 115 156 436 127.0 2.7 14.9     3.1 0.8 00:28:08.994000 00:13:58.006000 00:19:47.994000 00:06:47.001000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=62.2857569251209,-7.00692948885262&z=13 http://maps.google.com/?ie=UTF8&q=62.2857557516545,-7.00672639533877&z=13
19648496135 Viðareiði Hiking   2025-07-06 09:26:47.000000 2025-07-06 09:26:47.000000 02:48:51.913000 5.6 13286 00:48:14.504005 00:31:24.180030 00:06:43.951863 46.0 246.0 106 154 749 127.0 2.0 14.3     3.3 0.2 00:11:19.006000 00:15:06.005000 00:47:34.989000 00:03:15.006000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=62.3644787538797,-6.54171902686357&z=13 http://maps.google.com/?ie=UTF8&q=62.3642649315298,-6.54166303575039&z=13
19631086378 Tjørnuvík Hiking   2025-07-04 09:35:56.000000 2025-07-04 09:35:56.000000 05:06:33.179000 15.3 28376 00:32:18.968967 00:26:33.164885 00:10:15.899067 68.0 242.0 105 151 1239 127.0 3.0 9.4     2.8 1.1 01:22:48.013000 00:46:48.983000 00:55:47.002000 00:00:06.001000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=62.2889619134367,-7.14687793515623&z=13 http://maps.google.com/?ie=UTF8&q=62.2889185789973,-7.14637870900333&z=13
19622409554 Miðvágur Hiking   2025-07-03 14:53:27.000000 2025-07-03 14:53:27.000000 01:46:09.756000 6.8 10226 00:24:57.064315 00:20:53.537484 00:14:05.687973 84.0 250.0 92 136 345 127.0 3.9 6.9     0.8 0.0 00:33:59.998000 00:07:36.002000 00:00:20.000000 00:00:00.000000 00:00:00.000000 http://maps.google.com/?ie=UTF8&q=62.0418520085514,-7.19948627986014&z=13 http://maps.google.com/?ie=UTF8&q=62.0417525153607,-7.19967386685312&z=13

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW hiking_activities_view AS SELECT activities.activity_id AS activity_id, activities.name AS name, activities.description AS description, activities.start_time AS start_time, activities.stop_time AS stop_time, activities.elapsed_time AS elapsed_time, ROUND(activities.distance, 1) AS distance , steps_activities.steps AS steps, steps_activities.avg_pace AS avg_pace, steps_activities.avg_moving_pace AS avg_moving_pace, steps_activities.max_pace AS max_pace, ROUND(steps_activities.avg_steps_per_min, 1) AS avg_steps_per_min , ROUND(steps_activities.max_steps_per_min, 1) AS max_steps_per_min , activities.avg_hr AS avg_hr, activities.max_hr AS max_hr, activities.calories 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 , ROUND(steps_activities.avg_step_length, 1) AS avg_step_length , steps_activities.vo2_max AS vo2_max, activities.training_effect AS training_effect, activities.anaerobic_training_effect AS anaerobic_training_effect, activities.hrz_1_time AS heart_rate_zone_one_time, activities.hrz_2_time AS heart_rate_zone_two_time, activities.hrz_3_time AS heart_rate_zone_three_time, activities.hrz_4_time AS heart_rate_zone_four_time, activities.hrz_5_time AS heart_rate_zone_five_time, "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 steps_activities JOIN activities ON activities.activity_id = steps_activities.activity_id 
WHERE Activities.sport == "hiking" ORDER BY activities.start_time DESC;