Top 10 Ridden US Biking Destinations in July

Aug 10, 2017
by Trevor May  
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!

Ridelogs in the USA for July 2017



1. Park City, Utah
Park City mountain biking trails


Top 10 Ridden US Biking Destinations in July
Chasing Epic Season Wrap- In Pictures

Top 10 Ridden US Biking Destinations in July
Top 10 Ridden US Biking Destinations in July




3. Bellingham, Washington
Bellingham mountain biking trails


Cruising through the forest aboard the Chromag Aperture
Top 10 Ridden US Biking Destinations in July




4. Issaquah, Washington
Issaquah mountain biking trails


images from - The Story of Predator- An interview with Bryan Connolly
Top 10 Ridden US Biking Destinations in July

Top 10 Ridden US Biking Destinations in July
I d been wanting to shoot here for a long time. Finally I motivated enough to get ahold of Ben and make it happen.




6. Lyndonville, Vermont
Lyndonville mountain biking trails


Kingdom Trails
French Connection

Top 10 Ridden US Biking Destinations in July
Top 10 Ridden US Biking Destinations in July




8. 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


Having a ball at Mt. Bachelor. We totally scored and hit it the day after a long-overdue rain and conditions were awesome. What a gorgeous place and so much fun to ride. Must return
Photos from episode 3 of the TrailLove series presented by BMC Pinkbike Trailforks.com and in association with Pearl Izumi.




9. Cedar Mountain, North Carolina
Cedar Mountain biking trails


Edge of the cliff at sunset Big Rock Trail DuPont State Forest. Cedar Mountain North Carolina.
dec.28th 2014




10. Colorado Springs, Colorado
Colorado Springs mountain biking trails


Kirt Voreis launches the Niner RIP 9 RDO during a visit with the SRAM guys in Colorado Springs.
Top 10 Ridden US Biking Destinations in July



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
LIMIT 10