I've been cooking down this list of Trench airstrips and coordinates from a flyer you would find at Watson Lake or Mackenzie. @piperpainter sent me a photo of it. I ran some OCR software on it and converted a photograph into text. I cleaned it up a little and imported to Excel.

The problem is, many of the coordinates were expressed as 60123N 128123W. I converted those to 60.123,-128123 format. When verifying them on Google maps, many are off by several miles from the actual waypoint airport.

I added the list of strips to the "6 Legs to Alaska" section in the article. Scroll down to Leg 3 Option 2 and expand the list.

Here's the source data to download for editing:

http://backcountrypilot.org/images/kb/destinations/flying-to-alaska/trenchguide.data.xlsx

Anyone feel like correcting these coordinates and updating the XLSX?

The format is degrees minutes seconds, not decimal degrees.

So the Watson Lake location is 60 06 59, -128 49 21

And Pelly Lake Lodge is 56 53, -125 23, which is obviously rounded off, it marks 1000 feet west of the strip.

If you search this way and find the proper strip, Google gives the decimal degree location beneath the degree minute second format in case people want decimal degrees.

I don't have time today to go through and sort the entire list out. I could try to get to it later this week if nobody else has time.

Troy Hamon wrote:The format is degrees minutes seconds, not decimal degrees.

So the Watson Lake location is 60 06 59, -128 49 21

And Pelly Lake Lodge is 56 53, -125 23, which is obviously rounded off, it marks 1000 feet west of the strip.

If you search this way and find the proper strip, Google gives the decimal degree location beneath the degree minute second format in case people want decimal degrees.

I don't have time today to go through and sort the entire list out. I could try to get to it later this week if nobody else has time.

Ahhhh! That makes more sense. I'll revert the data to the original format. Then convert to decimal degrees.