database zip codes with area code

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
paragonconcept
Forum Newbie
Posts: 4
Joined: Thu May 24, 2007 8:24 pm

database zip codes with area code

Post by paragonconcept »

Hello,
Working on a VoiceXML application, and i'm trying to keep most of my functions internal without having to use whitepage type services. I've been looking all over the net for a database of all the US zip codes, with corresponding area codes. I have the NANPA database at the moment, but thats only 1/2 the solution, it provides the area code, and the state.


I have a seperate database of all the US zip codes, and their city names w/ long & lat quordinates, but it doesn't apply the area code to it.

Any idea where i can get this information?

Thanks

~Paragonc
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

It can't be guaranteed that a single area code corresponds to a single zip code. In fact they don't relate at all beyond covering geographic regions.
paragonconcept
Forum Newbie
Posts: 4
Joined: Thu May 24, 2007 8:24 pm

Post by paragonconcept »

feyd wrote:It can't be guaranteed that a single area code corresponds to a single zip code. In fact they don't relate at all beyond covering geographic regions.
Understood - but it can list which ones are included.

Example: 619 (san diego) would include 91941, 91945. 92101 -etc.......

i'd like to use the area codes to get a list of the possible zip codes, that way i can start establishing some search radius's
Post Reply