Re: [asterisk-users] Zip code, city and area codes

2006-07-26 Thread Joe Greco
> If you need something more than that, it will be difficult.  A zip code can 
> serve multiple NPA-NXX's
> and an NPA-NXX can be in multiple zip codes.

Don't forget that number portability significantly muddied the waters, and
VoIP has created an environment where there's no longer any need for a
physical relationship.  For example, ipKall offers Washington state phone
numbers for free.  Probably unusual to find your average end user having 
such a number, but some people on this list will.

Number portability probably means that you either need a bit of fuzzy logic
to determine if the ZIP and the NPA-NXX are in the same region, or you need
to be clever about the implementation and how you handle negative matches.

... JG
-- 
Joe Greco - sol.net Network Services - Milwaukee, WI - http://www.sol.net
"We call it the 'one bite at the apple' rule. Give me one chance [and] then I
won't contact you again." - Direct Marketing Ass'n position on e-mail spam(CNN)
With 24 million small businesses in the US alone, that's way too many apples.
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] Zip code, city and area codes

2006-07-26 Thread Shane Young
Quoting Ronald Wiplinger <[EMAIL PROTECTED]>:

> Is there a table available, which tells me if a zip code, city and area
> code matches?
> For now I did it with google, type each info in and found out if it
> matches, but it would be easier if there is a table available.

If you subscribe to the LERG, you can build a table which might fit your needs.

If you simply want to find a zip code for a NPA-NXX, you can lookup the switch 
for that NPA-NXX in
table LERG6 then lookup the zipcode for the switch in table LERG& (I think).

This works good for finding a nearby zipcode to match a callers ANI.

If you need something more than that, it will be difficult.  A zip code can 
serve multiple NPA-NXX's
and an NPA-NXX can be in multiple zip codes.

--Shane


This message was sent using IMP, the Internet Messaging Program.
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] Zip code, city and area codes

2006-07-26 Thread Roger Schreiter

Ronald Wiplinger schrieb:
Is there a table available, which tells me if a zip code, city and area 
code matches?





I doubt, that such a table does exist.

Imho you will have to look for individual tables for each country.

For Germany, look at:
http://w3logistics.com


Roger.

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users


RE: [asterisk-users] Zip code, city and area codes

2006-07-26 Thread Chris HARIGA
Hi,

We purchase the database with zip codes, latitude, longitude, are codes and
all for our zip lookup AGI.
If you need something simple take a look at
http://www.census.gov/geo/www/gazetteer/places2k.html

Best regards,

Chris HARIGA


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ronald
Wiplinger
Sent: Wednesday, July 26, 2006 7:29 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [asterisk-users] Zip code, city and area codes

Is there a table available, which tells me if a zip code, city and area 
code matches?
For now I did it with google, type each info in and found out if it 
matches, but it would be easier if there is a table available.

bye

Ronald
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[asterisk-users] Zip code, city and area codes

2006-07-26 Thread Ronald Wiplinger
Is there a table available, which tells me if a zip code, city and area 
code matches?
For now I did it with google, type each info in and found out if it 
matches, but it would be easier if there is a table available.


bye

Ronald
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users