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, UtahPark City mountain biking trails2. Draper, UtahDraper mountain biking trails3. Bellingham, WashingtonBellingham mountain biking trails4. Issaquah, WashingtonIssaquah mountain biking trails5. Hood River, OregonHood River mountain biking trails6. Lyndonville, VermontLyndonville mountain biking trails7. Phoenix, ArizonaPhoenix mountain biking trails8. 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 trails9. Cedar Mountain, North CarolinaCedar Mountain biking trails10. Colorado Springs, ColoradoColorado Springs mountain biking trails
The query for you geeks!
SELECT region.rid, region.title, region.alias, p.title AS prov_title, tr.description, COUNT(*) AS total
FROM wostrailforks.ridelog_trails rt
JOIN wostrailforks.trail t ON rt.trailid=t.trailid
JOIN wostrailforks.ridelog r ON rt.ridelogid=r.id
JOIN wostrailforks.trail_index i ON t.trailid=i.nid
JOIN wostrailforks.region ON i.city=region.rid
JOIN wostrailforks.region p ON i.prov=p.rid
JOIN wostrailforks.region_text tr ON region.rid=tr.rid
WHERE 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>0
GROUP BY i.city
ORDER BY total DESC