GPS and Gradients…


Bellevue is a hilly place. It’s perched (roughly) between two large bodies of fresh
water. Lake Washington, to the west, is something around 10 or 15′ above sea level,
and Lake Sammamish, to the east, is about 40′ about sea level.

What that means for me is that if I’m going riding, I’m going to be riding up and
down some hills. Some are steep hills, of the “I’d really like to stop now, but if
I do I fear I will merely fall across the road and lie there until some vehicle approaches”
variety. Others are less steep. As I was suffering going up one of these hills, I
thought it might be fun to know exactly how steep it is (cyclists have weird senses
of humor, and love/hate relationships with hills). A few web searches led me to this inclinometer,
but being the techie that I am, it didn’t seem cool enough, so I did a bit more research.

Hills are measured in terms of gradient, which is merely the rise of the hill over
the run. If you’re going up 2 feet for every 100 feet you travel, you’re on a 2% hill.
As an aside, it turns out that humans are great at overestimating the steepness of
hills. It’s easy to think that some streets are nearly 45 degrees (100% gradient),
but it turns out that the steepest streets around Seattle (and we have some steep
ones) are a 21% gradient, a mere 11 degrees. Take out a piece of graph paper,
and draw a triangle that’s 10 units long and 2 units high. Take a look at that, and
then try to reconcile it with the streets you’ve been on. Doesn’t make much sense.

Anyway, what I was looking for was a way to measure the gradient of the streets I
was on. To do that, I needed a way to set a reference point, move forward, and then
figure out the delta in distance and altitude. If you’re thinking GPS, you’re right
on the button. This finally gave me an excuse to order a data cable for my Garmin
Etrex, and yesterday afternoon I did a little drive on some hills with the GPS on,
came home, and used a gps utility program to download the data, extracted it to a
text file, imported to excel, it did some graphing.

The result was fairly good, actually, except for the fact that the Etrex only saves
data every once in a while (to save memory space), so in a car, the samples are too
far apart to get a good reading. This wouldn’t be a problem climbing on the bike,
but might be when descending. I can get around that by taking the laptop with me
and saving the location every second, which should give me more than enough resolution
to get some good data. GPS isn’t great on absolute position, and is even less good
on absolute altitude, but it’s quite good on relative measurements of both of those.

I’ll have to write a C# utility to run on the laptop, of course, so that I don’t have
to do all the ugly massaging and export. I might eventually buy a GPS for my pocket
PC, as there are some small ones that fit in the compact
flash
slot.

 

 

 

Comments (7)

  1. Bliz says:

    When I first moved to temp housing in Redmond 4 years ago I hopped on my mountain bike for a ride. Headed out Avondale road and turned onto 104th (headed west). Man. That hill definitely seemed like it was straight up (easily a 75 degree angle — how could a car climb this thing?) and about 2 miles long. It was definitely at 100% on the exhaust-o-meter. 🙂

  2. Mike Dimmick says:

    Socket do a quite nice Bluetooth GPS receiver which might be useful to you: http://www.socketcom.com/product/gps.asp

  3. Jack Bond says:

    Teletype has a bluetooth gps receiver that’s worked really well for me. I’ve never needed to plug it’s external antenna in to get a signal. Runs off its own battery and is smaller than a pager.

  4. Steve Butler says:

    I can definitely attest that the ride up NE 40th to campus is a soul destroying personal Everest 🙂 . At least it’s downhill on the way home. 23mins to get to work – around 7mins to get home.

  5. Don’t buy a GPS for your Pocket PC. You allready have your eTrex! Instead buy a eTrex<->PocketPC cable. This works great with my iPAQ.

    I have a small free GPS library for Pocket PC, that is fully threaded and eventbased. You can read more about it here:

    http://www.iter.dk/software/#PpcGps

    The application you wan’t to create can’t take more than an hour or so to make, since all the "hard stuff" allready is in my library. All you have to do is react on the "new position event" and output it to a textfile.

  6. Dan says:

    Get a Ciclo bike computer. It does everything you want regarding gradient. You can download it to your PC and print a graph and all the stats of your hill.