SELECT DISTINCT r.uid, r.foreign_id, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.difficulty')) AS metadata_string, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.route_length')) AS metadata_string FROM `tx_webxgsmap_domain_model_resource` `r` INNER JOIN `tx_webxgsmap_resource_category_mm` `mm_category` ON `r`.`uid` = `mm_category`.`uid_local` WHERE (`mm_category`.`uid_foreign` IN (:dcValue1)) AND (`r`.`object_type` <> :dcValue2) AND (`r`.`object_type` <> :dcValue3) AND (`r`.`object_type` <> :dcValue4) AND (`r`.`object_type` <> :dcValue5) AND (`r`.`object_type` <> :dcValue6) AND (`r`.`object_type` <> :dcValue7) AND (`r`.`object_type` <> :dcValue8) AND (`r`.`object_type` <> :dcValue9) AND (`r`.`object_type` <> :dcValue10) AND (`r`.`sys_language_uid` = :dcValue11) AND (((`r`.`deleted` = 0) AND (`r`.`hidden` = 0) AND (`r`.`starttime` <= 1780769700) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780769700))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(3 items)
      0 => '2' (1 chars)
      1 => '509' (3 chars)
      2 => '769' (3 chars)
   dcValue2 => 'sportclimbing_2018_route' (24 chars)
   dcValue3 => 'sportclimbing_2018_sector' (25 chars)
   dcValue4 => 'sportclimbing_2018' (18 chars)
   dcValue5 => 'gdi_piste' (9 chars)
   dcValue6 => 'gdi_lift' (8 chars)
   dcValue7 => 'climbing_route_2018_route' (25 chars)
   dcValue8 => 'climbing_route_2018_sector' (26 chars)
   dcValue9 => 'event' (5 chars)
   dcValue10 => 'event_phoenix' (13 chars)
   dcValue11 => 1 (integer)
Maurach - Buchau - Dalfazer Wasserfall - Dalfaz Alm - Maurach | Holiday Region Achensee

Maurach - Buchau - Dalfazer Wasserfall - Dalfaz Alm - Maurach

This tour starts from opposite the tennis court near the Atoll Achensee. Walk through the underpass of the Achensee main road and turn right in the direction of Buchau. Behind the Familienresort Buchau, follow the wide forest road through the high forest. After three switchbacks, you arrive at the junction of the waterfall trail. Turn left to the Dalfaz waterfall (viewing platform). The trail climbs gradually uphill by way of switchbacks past the Teisslalm (not serviced) to the Dalfaz Alm (1,693 metres). The return is via the same route.

more
less

Infrastructure on site

Atoll Achensee - WC
Dalfaz Alm
Atoll Achensee
Lagoon - Atoll Achensee
Difficulty
Medium
Route Length
9.2 km
Route Time Total
04:00 h
Elevation Gain
760 hm

Infrastructure on site

Atoll Achensee - WC
Dalfaz Alm
Atoll Achensee
Lagoon - Atoll Achensee
TVB Achensee KI Assist