« June 2006 | Main | August 2006 »
The data has been updated through 7/16/2006.
It was a little later than usual because we were out camping this weekend at Sonoma Lake. Its pretty fun and you can camp where it's boat in only camping. Though, it doesn't prevent the loud, obnoxious types from camping near you.
Hopefully soon I’ll finish getting the weekly process all automated so it won’t matter where I am on the weekends.
Sadly, last night the server that my mySQL databases sit on was down. It appeared to be fixed at some point in the middle of last night. It’s pretty unfortunate.
Everything appears okay now.
I fixed the sorting algorithm on the table of results data for the site. Sometimes it would sort 800 sq ft as a greater number than 1,200 sq ft. I found a couple problems with the regular expressions I was using. Now everything sorts correctly, and I dare say a little faster too!
Also, today is Sunday, and as such the homes sold data for the past week has been posted. Data has been updated for the website. You can now search through 7/9/2006 on your quest for information.
That’s right there’s 42,250 properties listed than there were mere minutes ago.
When I started this project I didn’t have adequate time to invest in the processes that were creating the data for this project. As a result, there wasn’t the best error handling and some of the other code was lacking.
Well, not anymore. The ‘second pass’ has been completed and with it there’s now 14% more sold properties listed and mapped. How cool is that!
That being said I still have 35,991 properties that I haven’t been able to geocode. Even with Yahoo’s geocoder. The addresses are too new, most likely new developments. It’s possible that there are some with erroneous addresses also.