[Asterisk-Users] Local Calling Area database?

[Scott Laird]

On Apr 8, 2004, at 12:54 PM, Steven Sokol wrote:

>> http://users.dandy.net/~czg/search.html
>>
>> http://www.telcodata.us/
>>
>> Those are the closest places I've found that have the data you're
>> looking for.  There may be some gaps in what they cover and there may 
>> be
>> some errors.
>
> Close, but no cigar.  What I want is the ability to query by providing:
>
> 1) My NPA
> 2) My NXX
> 3) My Local Carrier's ID Code (CIC)
> 4) My Intra-State Carrier's ID Code (CIC)
> 5) My LD Carrier's ID Code (CIC)
> 6) Destination Country Code
> 7) Destination NPA
> 8) Destination NXX
>
> What I would like to get back is a value indicating the 
> cost-per-minute for
> the call (and if possible, the rating period - per second, per 1/10 
> minute,
> round-up to next minute, etc.)
>
> Apparently there's no regulation that requires the phone company to 
> provide
> you with any indication that a call is LD, local-LD, intra-LATTA LD, 
> etc.

Your needs are a bit bigger then mine.  I only have two choices for 
call handling, POTS or NuFone.  For US calls, the pricing decision is 
easy: the POTS call is either free or too expensive, while NuFone is 
always $0.029 (er, ignore Alaska and Hawaii).  So, if I can identify my 
local calling area, then I can map all of those NPA/NXX sets onto the 
POTS line, and let everything else go via NuFone, without having to 
make the user dial a '1' for toll calls.

My big motivation for this?  I'm generating a dialing directory for my 
Cisco 7940 from the address book on my Mac.  This way, I have the same 
set of numbers available on my cell phone, palm, and VoIP phone.  I can 
edit them in one place, and they're updated everywhere.  I'm even using 
them for caller-ID rewriting and distinctive ring.  I'll release the 
code I'm using for this soon, if anyone's interested.

The big problem that I'm having is that the directory gives me a 
10-digit number, and without knowing my local calling area, my only 
real choice is to send everything to NuFone, because there's no simple 
heuristic that will tell me which exchanges in 425 are local.  Now that 
I have information on my local calling area, I can handle any 10-digit 
number, with or without the leading '1', and do the cheapest thing.


Scott