Re: Zip code database?

["markw-4" <user=5@nabble.blu.org>]

 > 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.