After the release of the google maps api, I began working on custom applications. Because google doesn't allow address lookups in its api, you have to generate a latitude and longitude yourself for a given address. The immediate problem was the need for geocoding, preferably geocoding within php. This is where the US Census comes in. The easiest solution is to download a mysql dump of all the zips with there corresponding lat/longs. That mysql dump can be found here Well, this is great, but it's not detailed enough. I needed to geocode to the street level. geocoder.us offers a free web service for doing this but you can only make one request every 15 seconds. I have a database of 3500 addresses, so that wasn't going to work. geocoder.us uses the US census's Tiger Data, and the perl Geo::Coder::US module. The problem with this solution is the amount of time it would take compile. You have to download every zip file from every state, and than compile it. I'm not patient enough. Thats when I found Dan Egnor. Dan won the 2002 Google Programing contest with a program that does just what I needed it to. Read on to do it yourself. Ok, so the biggest issue is skipping out of the compile process. Dan offers a free download of a bz2'ed version (~300mb) of the compiled address location data (by the way, the README on his site is good reading material). Dans program does more than I needed it to, so I simplified his source code (Thanks Dan) to do simply what needs to be down. It can be downloaded here. Simply download my source, `bunzip2` the map data from Dans site (assuming Linux here), and tar -jxvf the source, run make on the source and issue a command like `./geo-coder (location of the map data ex. ../../all-map) '(the address you want to find)'`. This returns either SUCCESS or FAILURE. Some simple php code will execute and return the address within your web app:

1 2 3 4 5 6 7 8 9 10

$progress = array(); exec("./geo-coder ../all-map '$address'", $progress); if(substr($progress[0],0,7) == "SUCCESS"){ //The below returns an array with, $ll[0] = longitude and $ll[1] = latitude from Dan's program $ll = explode(", ",trim(substr(strstr($progress[3], '@'),1))); }else{ //use a zipcode (from the query or DB table in my case) to find the lat/long in the mysql zip database $zips =& $db->query('SELECT latitude, longitude FROM zipcodes WHERE zip = '.$row['zip']); }

So there it is. A geocoder in no time at all. The geocoder is about 80% effective (according to Dan). If enough interest is created with this post, I will create a torrent of the most up to date Tiger address information, which should improve the accuracy. Don't hesitate to email me at vanpelt@gmail.com if you have questions or requests.

I was browsing around today, and I found an interesting article on slashdot. It had to do with third party uses of google maps, and google cutting down on them. There turns out to be some amazing stuff being done google maps and third party software. As mentioned earlier, there was the gps in the car use but these applications are just too cool. My favorite was a tool that took craigslist rental listings and displayed them in your area dependent upon price. There is also a site that points out sites to see from the satellite imagery.

In order of coolnees:

• Housing Maps
• Google Siteseeing
• Chicago Crime
• Cheap Gas

Who knows what will pop up next???

Google maps released it's new mapping program a few months ago. Last week they added satellite imagery. I thought this would be a great opportunity to share the unbelievable beauty that is Southern California. Click on the thumb for a detailed look. Life is good out here, but it's no Iowa. Try google maps and check out Southern California. Click on the map and drag, you can scroll wherever you like. It's amazing. Getting directions on the site is also very cool. Google bought Keyhole a couple weeks ago. I look forward to seeing what they do with the technology. Currently only urban areas have high resolution. It's like being in an airplane, and all using relatively simple built in technology. For more about Google Maps and all of Googles cool new features check this out. I'm sure they'll be getting a hold of me soon to create the next big thing :).