The Tooleshed

Well today was my first solo flight out of the Troutdale traffic pattern down to Mulino. Before heading down I did six take-off/landings in the pattern with my instructor watching from the ground. I started with a short-field take-off followed by a no-flaps landing then just regular to/landings. After my sixth I headed down to Mulino at about 1100 ft staying under Portland airspace then climbed to 2000 after coming out of the south end of Happy Valley. Flew over Mulino and chose runnway 14 right - no traffic this morning. Did a full stop then headed back to TTD via Happy Valley.

I’ve been slowly working on updating my Hood to Coast Maps website (www.htcmaps.com) and have spent quite a bit of that time on a Google Earth flyover of the entire course.

I’ve added four aerial photograph overlays that cover the ground over legs 2 through 5 (light rectangles). The Google Earth resolution in this section is very low compared to the rest of the course so I’ve added the overlays which have better resolution. Note that each overlay is about 300K so they may take a while to download.

Have a look at the flyover here: www.htcmaps.com/index/flyover. Be sure and leave any comments you may have about the flyover here on the blog.

-J

I’ve just completed the first part of my Google Maps / Hood to Coast run mashup here: www.htcmaps.com.

For those who don’t know Hood to Coast is a 200 mile relay race from Mt. Hood to Seaside in Oregon. Each member of the 12-person teams runs three of the 36 legs of the race. htcmaps is currently a very simple mapping application that allows you to view each of the legs on the course.

In the near future I hope to add mile markers, points of interest, and possibly a way for registered users to add their own markers (public and/or private) to the map as well as manage their team and runners. We’ll see about that though. Currently I’m just waiting for the 2006 course maps to come out so I can update the leg routes. Hopefully the new route maps will be better (more accurate and detailed) than the 2005 maps, but I doubt it.

www.htcmaps.com

I had originally started to write an article about how to do geocoding with PostgreSQL and the PostGIS extensions that come with it. But after messing around with it for quite awhile I found that for basic geocoding, you don’t need GIS extensions. So I’ve decided to start over with a new article about how to geocode starting with just the Tiger/Line data files and using MySQL and PHP.

A few things before we get started: you need to have a MySQL database already installed. Also I use the ADODB library for database access in these examples, I highly recommend using it.
Read the rest of this entry »

I’ve seen many posts about problems people have debugging ASP.NET applications, specifically with the error:

Unable to start debugging on web server…
Read the rest of this entry »

This unfinished article has been replaced by a new one covering Geocoding with MySQL and PHP.

Read the rest of this entry »

Here is the first version of my stylesheet (XSL) that converts DB Designer 4 XML into Propel Schema XML. This allows you to design your database model using DB Designer 4 (models are saved in XML format) and then easily create the Propel database schema file.
Read the rest of this entry »

BrewML v0.1

BrewML is an XML format specification for storing home brew beer recipes. It will allow for storing basic characteristics such as name, style, contact, details (color, bitterness, og, fg, alcohol), ingredients (extract, grains, hops, yeast), and directions.

Here are the latests documents relating to BrewML v0.1:

BrewML XML Schema
Example BrewML

Copyright (c) 2005 Jonathan Graham and is available for use under the GNU GPL.