Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Zip code database?

 > On Jan 1, 2008 2:42 PM, Mark Woodward <[hidden email]> wrote: 
>> Yea, the ZCTA database is more or less the one that I already have it 
>> comes from TIGER 2000. It is missing something like ~400 zip codes and 
>> lacks "alias" information like Dorchester instead of Boston. 
>> Your store finder is cool, we did something like it for a project a few 
>> years back, but if you use the raw ZCTA names, you won't be able to look 
>> for streets by canonical city names like Dorchester, Hyde Park, 
>> Manhattan, etc. 
>> What database do you use? I wrote a number of geographical/spherical 
>> routines for PostgreSQL. 
> Heh, yeah, we wrote it back in 2002 or 2003, iirc.  I used to date the 
> daughter of the site owner while in college and we did the job for 
> cheap.  I remember that we found it was easiest to limit the domain of 
> input to just zip codes (we were writing this all from scratch in 
> PHP/SQL).  The Aronies wanted everything done cheaply, so we couldn't 
> afford a commercial database. 

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /