CCMI's QTEL product is the real answer: https://www.ccmi.com/solutions/network-planning/ If you truly want local calling areas from tariffs. You will be charged according to the size of your dreams and the altitude of your aspirations. -- Alex

On May 9, 2023, at 3:46 PM, Peter Beckman via VoiceOps <voiceops at voiceops.org> wrote:

I use Alcazar Networks LRN product.

https://www.alcazarnetworks.com/data_services_lnp_lrn.php

$0.00025 per query, or $199/month for up to 50 queries per second (that's like 130 million queries a month!).

They return the LRN for a DID, as well as the LEC, and some other stuff. If you include the CallerID of the caller, they will tell you if the call is interstate or intrastate.

While intrastate rating of a call does not determine if it is local, it is likely better than nothing. We use it to determine our LCR rate deck rate for a call.

Alcazar Reply:

{ "LRN": "12673009559", "SPID": "063E", "OCN": "967E", "LATA": "228", "CITY": "LANGHORNE", "STATE": "PA", "JURISDICTION": "INTERSTATE", "LEC": "PEERLESS NETWORK OF PENNSYLVAN", "LINETYPE": "LANDLINE", "DNC": null }

I know that LocalCallingGuide offers information on which NPANXXs are local calls to what other NPANXXs. However, they do not offer AFAIK a premium or commercial option to get this data.

https://telcodata.us/ has a lot of great LERG-adjacent data, plus a paid option, but I'm not sure if they have the data to determine if a call is local or not.

You mention "coordinates/distance" between callers. Are you having the callers use an app with GPS location? Or are you operating on what information is in the LERG, where you know the switch location of an NPANXX, and whether or not the Caller and Callee NPANXX are considered "local?"

Beckman

On Tue, 9 May 2023, Jeff Anderson via VoiceOps wrote:

...

Does anyone know of any commercial products that can determine if a call is local?

The product would look at what is defined in the Tariff documents, not just make the decision based on coordinates/distance between callers.

I am aware of iConnectiv's solution.

Thanks

--------------------------------------------------------------------------- Peter Beckman Internet Guy beckman at angryox.com https://www.angryox.com/ ---------------------------------------------------------------------------_______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

-- Alex Balashov Principal Consultant Evariste Systems LLC Web: https://evaristesys.com Tel: +1-706-510-6800

By the way.....local calling areas don't usually change. Only when they do a rate center consolidation or break one apart which is quite rare. Once an NXX is assigned to a rate center, the rate center the NXX is assigned to also doesn't change. So once you have the rate centers documented for each local calling area, you really only need to add the new NXXs assigned to each rate center. Just saying this in case someone wants to create their own resource. MARY LOU CAREY BackUP Telecom Consulting Office: 615-791-9969 Cell: 615-796-1111 On 2023-05-09 03:13 PM, Mary Lou Carey wrote:

I believe CCMI sells a product that offers local calling area information. https://www.ccmi.com/solutions/

If you're on a strict budget or just want to do it yourself, I can tell you how I've done it on a manual basis in the past. You just have to marry the local calling area for each rate center from (NECA 4 tariff) with the NXXs associated with each rate center from Local Calling Guide. NECA 4 is a free public resource that documents which rate centers are in the local or extended calling area of each rate center. Local Calling Guide is a free resource that lists all the NXXs associated with each rate center. Local Calling Guide allows you to do XML queries, but I'm not sure if there are downloads you can get from NECA 4. If there are I'm sure you'd have to pay for it.

NECA 4 https://apps.fcc.gov/etfs/public/tariff.action?idTariff=99

Local Calling Guide https://localcallingguide.com/

MARY LOU CAREY BackUP Telecom Consulting Office: 615-791-9969 Cell: 615-796-1111

On 2023-05-09 01:57 PM, Jeff Anderson via VoiceOps wrote:

...

Does anyone know of any commercial products that can determine if a call is local?

The product would look at what is defined in the Tariff documents, not just make the decision based on coordinates/distance between callers.

I am aware of iConnectiv's solution.

Thanks _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

An HTML attachment was scrubbed... URL: <https://puck.nether.net/pipermail/voiceops/attachments/20230510/9394bb7a/att...>