Go Back  Bike Forums > Bike Forums > Road Cycling
Reload this Page >

Want to create a cue sheet for your 200 mile ride in <3 minutes?

Search
Notices
Road Cycling “It is by riding a bicycle that you learn the contours of a country best, since you have to sweat up the hills and coast down them. Thus you remember them as they actually are, while in a motor car only a high hill impresses you, and you have no such accurate remembrance of country you have driven through as you gain by riding a bicycle.” -- Ernest Hemingway

Want to create a cue sheet for your 200 mile ride in <3 minutes?

Thread Tools
 
Search this Thread
 
Old 10-16-07, 02:16 PM
  #1  
Junior Member
Thread Starter
 
Join Date: Sep 2007
Posts: 16
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Want to create a cue sheet for your 200 mile ride in <3 minutes?

Most people by now know that Google Maps allows you to customize a route by dragging the blue line around to select the roads you want to take instead of the roads it has chosen. This makes creating a bike route very fast and easy. Problem is, it's in Google Maps and you want to get this route out in a printable cue sheet, or into your Garmin, or into bikely or mapmyride so an elevation profile is generated.

Well, here you go.

Step 0 (only done once). Create a favorite/bookmark with the URL exactly as below:
javascript: (function(){var%20script=document.createElement('script');script.src='https://mysite.verizon.net/kyleyost/googlemap_cuesheet.js';document.getElementsByTagName('head')[0].appendChild(script);})()

Step 1. Go to Google Maps and make your route. Drag the blue line around to get the roads you want and rt-click to use "Add A Destination here". Very intuitive and easy.

Step 2. Click your favorite created in Step 0

Step 3. There's your cue sheet. Copy/Paste it into a text editor and save it. If you want GPX so you can import into bikely or MapMyRide, complete with cue sheet and elevation profile, select Bikely GPX. If you want to load the route into your Garmin, complete with Right, Left, Straight, U-Turn coursepoints for each turn, select Garmin CRS.

Easy, fast, brainless. Enjoy.
letour2007 is offline  
Old 10-16-07, 02:21 PM
  #2  
Senior Member
 
Join Date: Jun 2007
Location: Salem, MA
Posts: 110
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I got a big red square.
rhennigan is offline  
Old 10-16-07, 02:31 PM
  #3  
Junior Member
Thread Starter
 
Join Date: Sep 2007
Posts: 16
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
No way. Can't be.

PM me with details (OS, browser, and the "Link to this page" URL from your Google Maps route)
letour2007 is offline  
Old 10-16-07, 02:32 PM
  #4  
Senior Member
 
Join Date: Aug 2006
Posts: 277
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
very nice..... I like it a lot. worked perfectly for me.
NameGoesHere is offline  
Old 10-16-07, 03:44 PM
  #5  
Senior Member
 
akatsuki's Avatar
 
Join Date: Aug 2006
Location: San Francisco
Posts: 411

Bikes: Lynskey R210, Miyata 610, Anchor PCD3

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Damn that is cool. What license is the code? Can I modify it and/or distribute it?
akatsuki is offline  
Old 10-16-07, 04:07 PM
  #6  
**** that
 
mattm's Avatar
 
Join Date: Dec 2006
Location: CALI
Posts: 15,402
Mentioned: 151 Post(s)
Tagged: 0 Thread(s)
Quoted: 1099 Post(s)
Liked 104 Times in 30 Posts
Pretty cool idea/script!

Another option is to use veloroutes.org - it has auto-routing AND auto-magic cue-sheets, although the cues are definitely less accurate than Google's.

Happy mappin'!

(p.s. i run veloroutes.org, so if you have any suggestions shoot 'em my way!)
__________________
cat 1.

my race videos
mattm is offline  
Old 10-16-07, 05:31 PM
  #7  
Junior Member
Thread Starter
 
Join Date: Sep 2007
Posts: 16
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
The code that parses the Google page is based on code from GMapToGPX at www.elsewhere.org by Josh. Without this code to interpret the proprietary (and frequently changing) Google page, it would be impossible to create the cue sheet, GPX, CRS outputs. So, before you modify or distribute this code, be certain to contact Josh. All the code that takes the track info from the parsed Google page and converts it into the various formats is mine, and you are free to do what you please with that.

Personally, I would recommend against playing with this code. It does not use the supported Google API, but rather parses the page sent by Google to your browser and Google changes this often, breaking scriplets like this, and it is undocumented.
letour2007 is offline  
Old 10-16-07, 05:35 PM
  #8  
Senior Member
 
akatsuki's Avatar
 
Join Date: Aug 2006
Location: San Francisco
Posts: 411

Bikes: Lynskey R210, Miyata 610, Anchor PCD3

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Okay. Mostly I just want to change the output a bit to be a bit prettier and easier to read (e.g. alternating row colors, I like arrows and symbols instead of words like Right and Left, and so on...).

I will take a look, and if I end up modifying your code, I will let you know and I will ask Josh if I intend to distribute any modification of his code.
akatsuki is offline  
Old 10-16-07, 05:40 PM
  #9  
Guadzilla
 
JayC's Avatar
 
Join Date: Jun 2006
Location: Dialing it up to 400W
Posts: 3,697

Bikes: Pinarello F4:13 W/Campy Reecord & Blue RC6 W/SRAM Force

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 3 Times in 2 Posts
Where is the autorouting for Velomaps? I played with it when it was in early development but i dont see the option anywhere on the page.
JayC is offline  
Old 10-16-07, 05:51 PM
  #10  
**** that
 
mattm's Avatar
 
Join Date: Dec 2006
Location: CALI
Posts: 15,402
Mentioned: 151 Post(s)
Tagged: 0 Thread(s)
Quoted: 1099 Post(s)
Liked 104 Times in 30 Posts
@JayC: see the "Try the auto-routing beta" link on the left-nav.

Or just go directly: https://beta.veloroutes.org/bikemaps/ (Even thought it says 'beta' it will still save your route to the main DB of routes)
__________________
cat 1.

my race videos
mattm is offline  
Old 10-16-07, 06:29 PM
  #11  
Guadzilla
 
JayC's Avatar
 
Join Date: Jun 2006
Location: Dialing it up to 400W
Posts: 3,697

Bikes: Pinarello F4:13 W/Campy Reecord & Blue RC6 W/SRAM Force

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 3 Times in 2 Posts
Nice progress on the autorouting. I like how it doesnt bog down as the route gets longer. Now if it only added turn points in......
JayC is offline  
Old 10-16-07, 06:48 PM
  #12  
Lovin' my Fixie
 
bikeman's Avatar
 
Join Date: Sep 2000
Location: Euclid, Ohio, USA (Near the Great Lake Erie)
Posts: 303

Bikes: Litespeed Classic, C-Dale MT1000, 80's Trek 770, 2005 Raleigh Rush Hour Pro, Fixed

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
You can go to https://www.mapmyride.com too. You have to join but it free. It gives you elevations, routes and cue sheets.
bikeman is offline  
Old 10-16-07, 06:49 PM
  #13  
J E R S E Y S B E S T
 
Jerseysbest's Avatar
 
Join Date: Apr 2005
Location: DC
Posts: 1,849
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Awesome! I just ran it with a bunch of rides I had bookmarked on Google Maps. Very very cool!
Jerseysbest is offline  
Old 10-16-07, 06:53 PM
  #14  
Guadzilla
 
JayC's Avatar
 
Join Date: Jun 2006
Location: Dialing it up to 400W
Posts: 3,697

Bikes: Pinarello F4:13 W/Campy Reecord & Blue RC6 W/SRAM Force

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 3 Times in 2 Posts
Originally Posted by bikeman
You can go to https://www.mapmyride.com too. You have to join but it free. It gives you elevations, routes and cue sheets.
MapMyRide gets REALLY slow when your route gets much longer than about 45 miles. In fact, every site except Veloroutes does that. BikeRouteToaster has been revised again but its all kinds of broken. Maybe it will be fixed in a few months.
JayC is offline  
Old 10-17-07, 05:32 AM
  #15  
Senior Member
 
Join Date: Aug 2006
Posts: 277
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by akatsuki
Okay. Mostly I just want to change the output a bit to be a bit prettier and easier to read (e.g. alternating row colors, I like arrows and symbols instead of words like Right and Left, and so on...).
If you do that, I'd like to see the result. I would like to modify the output a little too, but it's not really important to me (not enough to spend much time on).
NameGoesHere is offline  
Old 10-17-07, 07:41 AM
  #16  
Junior Member
Thread Starter
 
Join Date: Sep 2007
Posts: 16
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Bikely gives you elevations and cue sheets and doesn't bog down with large numbers of points.

Nothing beats Google Maps for a fast and easy way to "draw" a route though. As long as your route is on roads that you could drive on, by far the easiest way to get a route into bikely or mapmyride is to draw it in Google Maps, use my script to convert it into GPX or Garmin CRS, and then upload GPX into bikely or mapmyride.

The days of click, click, clicking to draw points are behind us. Even with autorouting in veloroutes or mapmyride, it's much easier to do in Google Maps and the resulting cue sheet better and more accurate.
letour2007 is offline  
Old 10-17-07, 08:12 AM
  #17  
Senior Member
 
Join Date: Mar 2006
Location: Saint Louis, MO
Posts: 549

Bikes: Motobecane fixed conversion, Faggin fixed conversion, '86 Raleigh Grand Prix

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Very cool. Thanks.
littledjahn is offline  
Old 10-17-07, 08:35 AM
  #18  
Guadzilla
 
JayC's Avatar
 
Join Date: Jun 2006
Location: Dialing it up to 400W
Posts: 3,697

Bikes: Pinarello F4:13 W/Campy Reecord & Blue RC6 W/SRAM Force

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 3 Times in 2 Posts
I must be stupid. I cant get the blue line to autoroute and dont get the "Add a destination" option, all I get is "Add a point". What am I doing wrong?
JayC is offline  
Old 10-17-07, 08:45 AM
  #19  
Senior Member
 
hos13's Avatar
 
Join Date: Mar 2007
Location: 552 LATA
Posts: 781

Bikes: 2007 Mercier Sperns (I'm a shill) and a 99 Diamondback Invert

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Cool, thanks for sharing.
hos13 is offline  
Old 10-17-07, 08:46 AM
  #20  
Guadzilla
 
JayC's Avatar
 
Join Date: Jun 2006
Location: Dialing it up to 400W
Posts: 3,697

Bikes: Pinarello F4:13 W/Campy Reecord & Blue RC6 W/SRAM Force

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 3 Times in 2 Posts
I got it working, I think. Seems like the other autorouting sites, tho.. about 40 miles it, it starts to get really sluggish. Add a destination and it takes forever for it to update.

Maybe I need to try it in Firefox. I cant create a route longer than 38 miles before it chokes up.

Last edited by JayC; 10-17-07 at 09:09 AM.
JayC is offline  
Old 10-17-07, 08:50 AM
  #21  
Senior Member
 
Join Date: Jul 2003
Location: Boulder, CO
Posts: 8,546
Mentioned: 83 Post(s)
Tagged: 0 Thread(s)
Quoted: 163 Post(s)
Likes: 0
Liked 2 Times in 2 Posts
Uber-cool. Thank you.
valygrl is offline  
Old 10-17-07, 09:19 AM
  #22  
Senior Member
 
akatsuki's Avatar
 
Join Date: Aug 2006
Location: San Francisco
Posts: 411

Bikes: Lynskey R210, Miyata 610, Anchor PCD3

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Well, I have begun my hacks to the cue sheets. My mods are ugly, really ugly, and it is still a work in progress, but here is an alternate bookmark to use. I will be changing stuff out for a while still while I tweak it, but I think it is in okay enough shape to share:

Bookmarklet-
javascript:
(function(){var%20script=document.createElement('script');script.src='https://akatsuki.co.uk/cycling/googlemap_cuesheet.js';document.getElementsByTagName('head')[0].appendChild(script);})()
What will change:
1. I will be shrinking the text down for a smaller print out, the larger size is just while I work on it.
2. Will add some credits for everyone who actually came up with the real code.
3. More cosmetic changes and better icons.

I would love to get a small version of the map with numbered points to go along with the cue sheet, but that would be substantive programming, which I am not all that great at...

UPDATE: I gave up on this because I just didn't have time.

Last edited by akatsuki; 04-03-08 at 11:07 AM.
akatsuki is offline  
Old 10-17-07, 11:31 AM
  #23  
Junior Member
Thread Starter
 
Join Date: Sep 2007
Posts: 16
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by JayC
I got it working, I think. Seems like the other autorouting sites, tho.. about 40 miles it, it starts to get really sluggish. Add a destination and it takes forever for it to update.

Maybe I need to try it in Firefox. I cant create a route longer than 38 miles before it chokes up.
Don't know what to tell you JayC. I have created 150 mile routes in maps.google.com with no problem whatsoever. It's fast and responsive for me. It's fastest and easiest to tell Google to drive from start to point furthest away and then drag blue line around to get it to follow roads you want. Then "Add a Destination" back home again and again drag line around.
letour2007 is offline  
Old 10-17-07, 12:28 PM
  #24  
Guadzilla
 
JayC's Avatar
 
Join Date: Jun 2006
Location: Dialing it up to 400W
Posts: 3,697

Bikes: Pinarello F4:13 W/Campy Reecord & Blue RC6 W/SRAM Force

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 3 Times in 2 Posts
Originally Posted by letour2007
Don't know what to tell you JayC. I have created 150 mile routes in maps.google.com with no problem whatsoever. It's fast and responsive for me. It's fastest and easiest to tell Google to drive from start to point furthest away and then drag blue line around to get it to follow roads you want. Then "Add a Destination" back home again and again drag line around.
That makes sense since it seems to be the addition of additional desitinations that bogs it down. Ill have to give it a try like that.
JayC is offline  
Old 10-17-07, 12:34 PM
  #25  
Peloton Shelter Dog
 
patentcad's Avatar
 
Join Date: Nov 2005
Location: Chester, NY
Posts: 90,508

Bikes: 2017 Scott Foil, 2016 Scott Addict SL, 2018 Santa Cruz Blur CC MTB

Mentioned: 74 Post(s)
Tagged: 2 Thread(s)
Quoted: 1142 Post(s)
Liked 28 Times in 22 Posts
Cue sheets are for wussy.

Cue Sheets? There's no Cue Sheets in bike racing!

patentcad is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.