Rate Center to LATA map
Does anyone know where to get a list of rate centers and what lata they are in? I am trying to redo translations and it is quite difficult without this information! Thanks, Eric
On Tue, 28 Sep 2010, Eric Hiller wrote:
Does anyone know where to get a list of rate centers and what lata they are in?
I am trying to redo translations and it is quite difficult without this information!
You could iterate over every npanxx combo and query this interface: http://localcallingguide.com/xmlquery.php (xmlprefix) That gives you Ratecenter, Lata and some other info via XML. Easy to write something that does this overnight. --------------------------------------------------------------------------- Peter Beckman Internet Guy beckman at angryox.com http://www.angryox.com/ ---------------------------------------------------------------------------
On 09/28/2010 12:54 PM, Peter Beckman wrote:
On Tue, 28 Sep 2010, Eric Hiller wrote:
Does anyone know where to get a list of rate centers and what lata they are in?
I am trying to redo translations and it is quite difficult without this information!
You could iterate over every npanxx combo and query this interface:
http://localcallingguide.com/xmlquery.php (xmlprefix)
That gives you Ratecenter, Lata and some other info via XML. Easy to write something that does this overnight.
This is silly. As I've said many times on this list: - Step 1 - Get the NANPA block assignment sheet (all regions): http://www.nanpa.com/nanp1/allutlzd.zip Look, I've linked it for you! - Step 2 - Get the National Pooling block sheet (all regions - available, assigned and retained in one): http://www.nationalpooling.com/reports/region/AllBlocksReport.zip - Step 3 - Enjoy. I don't know what you people are doing or why you are doing it, but 90% of the information you consistently keep asking for is publicly available for free, in a trivial data representation format, at that. The little bit of information you want that is not publicly available is in the LERG. You don't have to go to LocalCallingGuide.com to get it. You don't have to go to Telcodata to get it. If you want to, you can; they do digest it for you, and in the latter case, they amalgamate and superimpose a lot of other useful information onto it that is not as straightforwardly available, like NPA-NXX -> ZIP maps, for example. But crawling LCG? Seriously? Just stop it. Please, you're making my soul hurt. -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/
On Tue, 28 Sep 2010, Alex Balashov wrote:
On 09/28/2010 12:54 PM, Peter Beckman wrote:
On Tue, 28 Sep 2010, Eric Hiller wrote:
Does anyone know where to get a list of rate centers and what lata they are in?
You could iterate over every npanxx combo and query this interface:
http://localcallingguide.com/xmlquery.php (xmlprefix)
That gives you Ratecenter, Lata and some other info via XML. Easy to write something that does this overnight.
This is silly.
True, but it's the first option I could think of. And it would work, though yeah, silly in the face of the info you provided. :-) --------------------------------------------------------------------------- Peter Beckman Internet Guy beckman at angryox.com http://www.angryox.com/ ---------------------------------------------------------------------------
On 09/28/2010 01:08 PM, Peter Beckman wrote:
This is silly.
True, but it's the first option I could think of. And it would work, though yeah, silly in the face of the info you provided. :-)
Fair enough. :-) -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/
On 09/28/2010 01:05 PM, Alex Balashov wrote:
You don't have to go to LocalCallingGuide.com to get it. You don't have to go to Telcodata to get it. If you want to, you can; they do digest it for you, and in the latter case, they amalgamate and superimpose a lot of other useful information onto it that is not as straightforwardly available, like NPA-NXX -> ZIP maps, for example.
And, of course, the "local calling" part of LocalCallingGuide.com is extremely useful; your alternative is to search ILEC tariffs exhaustively yourself (have fun with that), or purchase expensive commercial databases from the likes of CCMI or Telcordia that digest this information. I don't know where the LCG guy gets _that_ information, but it is extremely useful. Everything related to rate center identification, NPA-NXX to locale resolution, NPA-NXX to LATA mapping, rate center to LATA mapping, NPA-NXX to LEC resolution, NPA-NXX-Y to LEC resolution, etc. is just peanuts, though: the information is free and available. I just linked to it. -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/
I already had both those files, and I am using them in my quest, but neither one contains any information about LATAs. -Eric On Tue, September 28, 2010 12:05 pm, Alex Balashov wrote:
On 09/28/2010 12:54 PM, Peter Beckman wrote:
On Tue, 28 Sep 2010, Eric Hiller wrote:
Does anyone know where to get a list of rate centers and what lata they are in?
I am trying to redo translations and it is quite difficult without this information!
You could iterate over every npanxx combo and query this interface:
http://localcallingguide.com/xmlquery.php (xmlprefix)
That gives you Ratecenter, Lata and some other info via XML. Easy to write something that does this overnight.
This is silly.
As I've said many times on this list:
- Step 1 - Get the NANPA block assignment sheet (all regions):
http://www.nanpa.com/nanp1/allutlzd.zip
Look, I've linked it for you!
- Step 2 - Get the National Pooling block sheet (all regions - available, assigned and retained in one):
http://www.nationalpooling.com/reports/region/AllBlocksReport.zip
- Step 3 - Enjoy.
I don't know what you people are doing or why you are doing it, but 90% of the information you consistently keep asking for is publicly available for free, in a trivial data representation format, at that. The little bit of information you want that is not publicly available is in the LERG.
You don't have to go to LocalCallingGuide.com to get it. You don't have to go to Telcodata to get it. If you want to, you can; they do digest it for you, and in the latter case, they amalgamate and superimpose a lot of other useful information onto it that is not as straightforwardly available, like NPA-NXX -> ZIP maps, for example.
But crawling LCG? Seriously? Just stop it. Please, you're making my soul hurt.
-- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/ _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
On Tue, Sep 28, 2010 at 1:05 PM, Alex Balashov <abalashov at evaristesys.com> wrote:
On Tue, 28 Sep 2010, Eric Hiller wrote:
Does anyone know where to get a list of rate centers and what lata they are in?
I am trying to redo translations and it is quite difficult without this information!
- Step 1 - Get the NANPA block assignment sheet (all regions):
http://www.nanpa.com/nanp1/allutlzd.zip
- Step 2 - Get the National Pooling block sheet (all regions - available, assigned and retained in one):
- Step 3 - Enjoy.
No joy. Neither of those data files include LATA information. Alas. -jbn
On 09/28/2010 01:43 PM, Justin B Newman wrote:
No joy. Neither of those data files include LATA information. Alas.
You're right, they don't have that per se, but you can join on information that you do have, like OCN, to get the LATA from other public data sheets that they also offer. -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/
Well if anyone finds the data, I'll write a Perl script and put it up on github that takes all three files and pulls them together into some useful data. Or something. On Tue, 28 Sep 2010, Alex Balashov wrote:
On 09/28/2010 01:43 PM, Justin B Newman wrote:
No joy. Neither of those data files include LATA information. Alas.
You're right, they don't have that per se, but you can join on information that you do have, like OCN, to get the LATA from other public data sheets that they also offer.
-- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/ _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
--------------------------------------------------------------------------- Peter Beckman Internet Guy beckman at angryox.com http://www.angryox.com/ ---------------------------------------------------------------------------
I still am unsure of what the third file is, the critical one that converts from rate center to lata? On Tue, September 28, 2010 1:54 pm, Peter Beckman wrote:
Well if anyone finds the data, I'll write a Perl script and put it up on github that takes all three files and pulls them together into some useful data. Or something.
On Tue, 28 Sep 2010, Alex Balashov wrote:
On 09/28/2010 01:43 PM, Justin B Newman wrote:
No joy. Neither of those data files include LATA information. Alas.
You're right, they don't have that per se, but you can join on information that you do have, like OCN, to get the LATA from other public data sheets that they also offer.
-- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/ _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
--------------------------------------------------------------------------- Peter Beckman Internet Guy beckman at angryox.com http://www.angryox.com/ --------------------------------------------------------------------------- _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
On 09/28/2010 04:11 PM, Eric Hiller wrote:
I still am unsure of what the third file is, the critical one that converts from rate center to lata?
You guys do have a point. I shouldn't have been so sanctimonious. The old NANPA sheet I have had a LATA column in it; at some point, they must have stopped providing it. You can't resolve a rate center to a LATA per se, but you can resolve an NPA to a LATA pretty easily. However, that won't help you avoid edge cases like LATAs that flow across state borders into NPAs that are otherwise 99% in some other LATA -- those do happen. For that, you'd need the LERG and/or pooling data. -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/
On 09/28/2010 04:54 PM, Alex Balashov wrote:
On 09/28/2010 04:11 PM, Eric Hiller wrote:
I still am unsure of what the third file is, the critical one that converts from rate center to lata?
You guys do have a point. I shouldn't have been so sanctimonious.
The old NANPA sheet I have had a LATA column in it; at some point, they must have stopped providing it.
You can't resolve a rate center to a LATA per se, but you can resolve an NPA to a LATA pretty easily. However, that won't help you avoid edge cases like LATAs that flow across state borders into NPAs that are otherwise 99% in some other LATA -- those do happen. For that, you'd need the LERG and/or pooling data.
No, really, I'm not screwing with you guys. There used to be a LATA column in either the NANPA or the Pooling sheet. It has been removed. Part of me wonders if this is a conspiracy to screw little guys like us right as more and more Tier 1 & wholesale termination providers switch from NPA-NXX to LATA/OCN billing. -- Alex -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/
On 09/28/2010 05:11 PM, Alex Balashov wrote:
No, really, I'm not screwing with you guys. There used to be a LATA column in either the NANPA or the Pooling sheet. It has been removed.
Part of me wonders if this is a conspiracy to screw little guys like us right as more and more Tier 1 & wholesale termination providers switch from NPA-NXX to LATA/OCN billing.
Over time, Verizon and AT&T and Telcordia have been pushing agendas within the working groups behind NANPA (such as ATIS) that handle what information the NANPA is allowed to publish openly. In 2007 they removed the CLLI code field, ostensibly for antiterrorism reasons. Apparently knowing a 11 character identifier was a serious risk to public safety and so the logical conclusion was to remove it. It couldn't possibly be because I was taking that information, combining it with other information, and competing against Telcordia. Somewhere in my pile of crap I have all the legal threats they sent me when they first launched my website. It was good times. -Paul (Owner of telcodata.us)
On 09/28/2010 06:23 PM, Paul Timmins wrote:
On 09/28/2010 05:11 PM, Alex Balashov wrote:
No, really, I'm not screwing with you guys. There used to be a LATA column in either the NANPA or the Pooling sheet. It has been removed.
Part of me wonders if this is a conspiracy to screw little guys like us right as more and more Tier 1 & wholesale termination providers switch from NPA-NXX to LATA/OCN billing.
Over time, Verizon and AT&T and Telcordia have been pushing agendas within the working groups behind NANPA (such as ATIS) that handle what information the NANPA is allowed to publish openly. In 2007 they removed the CLLI code field, ostensibly for antiterrorism reasons.
Apparently knowing a 11 character identifier was a serious risk to public safety and so the logical conclusion was to remove it.
It couldn't possibly be because I was taking that information, combining it with other information, and competing against Telcordia.
Somewhere in my pile of crap I have all the legal threats they sent me when they first launched my website. It was good times.
I had a feeling it was something like that, not just a pseudo-random, organic result. It sounds like Paul's web site is probably the best value proposition here, insofar as you get the most comprehensive and flexible data sets for the best price. And it sounds like it will get even more valuable as NANPA and Neustar put out less and less useful data. -- Alex Balashov - Principal Evariste Systems LLC 1170 Peachtree Street 12th Floor, Suite 1200 Atlanta, GA 30309 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/
On 9/28/10 1:54 PM, Alex Balashov wrote:
You can't resolve a rate center to a LATA per se, but you can resolve an NPA to a LATA pretty easily. However, that won't help you avoid edge cases like LATAs that flow across state borders into NPAs that are otherwise 99% in some other LATA -- those do happen. For that, you'd need the LERG and/or pooling data.
I think it's more than a few edge cases, and often within the same state. NPA 805 for example is split between just about evenly between LATA 730 and 740 in California, with smidgen in LATA 734. -- Jay Hennigan - CCIE #7880 - Network Engineering - jay at impulse.net Impulse Internet Service - http://www.impulse.net/ Your local telephone and internet company - 805 884-6323 - WB6RDV
You can match up the LATA with the rate center if you look it up in LERG 8 (rate centers), but nowhere else. LERG 8 gives you the LATA, rate center abbreviation AND rate center full name, as well as the V & H coordinates for the rate center - not the CO. Mary Lou Carey BackUP Telecom Consulting 615-791-9969 -----Original Message----- From: voiceops-bounces at voiceops.org [mailto:voiceops-bounces at voiceops.org] On Behalf Of Jay Hennigan Sent: Wednesday, September 29, 2010 8:03 AM To: voiceops at voiceops.org Subject: Re: [VoiceOps] Rate Center to LATA map On 9/28/10 1:54 PM, Alex Balashov wrote:
You can't resolve a rate center to a LATA per se, but you can resolve an NPA to a LATA pretty easily. However, that won't help you avoid edge cases like LATAs that flow across state borders into NPAs that are otherwise 99% in some other LATA -- those do happen. For that, you'd need the LERG and/or pooling data.
I think it's more than a few edge cases, and often within the same state. NPA 805 for example is split between just about evenly between LATA 730 and 740 in California, with smidgen in LATA 734. -- Jay Hennigan - CCIE #7880 - Network Engineering - jay at impulse.net Impulse Internet Service - http://www.impulse.net/ Your local telephone and internet company - 805 884-6323 - WB6RDV _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
participants (7)
-
abalashov＠evaristesys.com -
beckman＠angryox.com -
clec＠cygnustel.com -
jay＠west.net -
justin＠ejtown.org -
marylou＠backuptelecom.com -
paul＠timmins.net