Using the Trailforks ridelog feature we are able to see what trails and regions are being ridden the most and when. We've queried the database to find the top ridden biking cities for the month of July 2017. You'll notice some big name destinations like Moab are not on the list, probably too hot for riding, less visitors in the middle of summer I guess?
You can make sure your rides are counted by either connecting your Strava account with Trailforks, or by recording your rides using the new tracking feature in the Trailforks app! The more people logging their rides to Trailforks the more accurate this data becomes for these fun lists, but more importantly for trail association advocacy use.
If people find these sort of blog posts interesting we can do much more, we can even seperate out locals riding their local network, to better gauge top travel destinations. If you have idea for other ridelog related lists we could do, let us know!
1. Park City, Utah
Park City mountain biking trails
9. Bend, Oregon
The place to go for some amazing mountain biking and other outdoor activities. Trails for the whole family, from Downhill at Mt. Bachelor to easy & hard XCountry trails at Phil's.
Bend mountain biking trails
The query for you geeks!
SELECT region.rid, region.title, region.alias, p.title AS prov_title, tr.description, COUNT(*) AS totalFROM wostrailforks.ridelog_trails rtJOIN wostrailforks.trail t ON rt.trailid=t.trailidJOIN wostrailforks.ridelog r ON rt.ridelogid=r.idJOIN wostrailforks.trail_index i ON t.trailid=i.nidJOIN wostrailforks.region ON i.city=region.ridJOIN wostrailforks.region p ON i.prov=p.ridJOIN wostrailforks.region_text tr ON region.rid=tr.ridWHERE YEAR(FROM_UNIXTIME(r.created)) = '2017' AND MONTH(FROM_UNIXTIME(r.created)) = '7' AND t.difficulty NOT IN (1,7) AND i.country='3001' AND i.city>0GROUP BY i.cityORDER BY total DESCLIMIT 10