Is there any good free / accurate online resources with detailed country numbering plans? Failing that let's get something running ourselves. I was also thinking maybe people present could contribute some information on this list for now. The countries I am after are below. To start this off I will provide the information for Australia +61 and New Zealand +64. NZ Cellular: area code 21 and 29 followed by 6, 7 or 8 digits - Vodafone GSM area code 27 followed by 6 or 7 digits - NZ Telecom CDMA note that there is number portability so the above is a guide. NZ Landline: area code 3, 4, 6, 7 and 9 followed by 7 digits (first digit will be in the range of 2-9) NZ toll free: area code 508 and 800 followed by 6 digits NZ premium: area code 900 - though I doubt any of you will be routing these calls AU cellular: area code 4 followed by a 2 digit network code, and then a 6 digit number Networks include: Optus, Telstra, 3, Vodafone, Virgin and others. All use GSM and there is number portability. AU landline: area code 2, 3, 7 and 8 followed by 8 digits (first digit will be in the range of 2-9) AU toll free: area code 1300 or 1800 followed by 6 digits OR area code 13 followed by 4 digits. AU premium: I'm not sure though someone present may fill us in. Following is the list of countries I need information on: ; ANDORRA ; ARGENTINA ; AUSTRIA ; BAHAMAS ; BELGIUM ; BRAZIL ; BULGARIA ; CANADA ; CHILE ; CHINA ; COLOMBIA ; CROATIA ; CYPRUS SOUTH ; CZECH REPUBLIC ; DENMARK ; ESTONIA ; FRANCE ; GERMANY ; GREECE ; GUADELOUPE ; GUAM ; HONG KONG ; HUNGARY ; ICELAND ; INDONESIA ; IRELAND ; ISRAEL ; ITALY ; JAPAN ; JORDAN ; SOUTH KOREA ; LUXEMBOURG ; MALAYSIA ; MARIANA ISLANDS ; MEXICO ; MONACO ; NETHERLANDS ; NORWAY ; PANAMA ; PERU ; PERU LIMA ; POLAND ; PORTUGAL ; PUERTO RICO ; ROMANIA ; RUSSIA ; SAN MARINO ; SINGAPORE ; SLOVAKIA ; SLOVENIA ; SPAIN ; SWEDEN ; SWITZERLAND ; TAIWAN ; THAILAND ; TURKEY ; UNITED KINGDOM ; UNITED STATES ; VENEZUELA
One of the problems you'll run into is that in larger countries like the US, and/or countries with greater amounts of telecom interconnection, competition and deregulation, this information cannot be reduced simply to a convenient algorithm. The North American Numbering Plan (www.nanpa.com) does provide some basic standards for valid numbers, but aside from that, there exists no special numerological distinction between incumbent and competitive, fixed-line and mobile, or VoIP, and extensive number portability throws even more complexity into the mix. I'm not saying it can't be done - just be aware that the undertaking you're proposing is very complicated, and the information would come from innumerable data sources (a great deal of them commercial and expensive) and a bewilderingly overlapping array of standards bodies. For instance, something like this:> NZ Cellular: > area code 21 and 29 followed by 6, 7 or 8 digits - Vodafone GSM > area code 27 followed by 6 or 7 digits - NZ Telecom CDMA > note that there is number portability so the above is a guide.... sounds like a laughably, impossibly simplistic formula to a North American reader. And I can't imagine the situation in many other countries is much simpler. -- Alex Balashov Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671 Mobile : (+1) (706) 338-8599
You forgot Uruguay I can give you the info if you want :) Enviado desde mi iPhone El 13/12/2008, a las 01:10 a.m., Michael <michael at networkstuff.co.nz> escribi?:> Is there any good free / accurate online resources with detailed > country > numbering plans? Failing that let's get something running ourselves. > > I was also thinking maybe people present could contribute some > information on > this list for now. The countries I am after are below. > > To start this off I will provide the information for Australia +61 > and New > Zealand +64. > > NZ Cellular: > area code 21 and 29 followed by 6, 7 or 8 digits - Vodafone GSM > area code 27 followed by 6 or 7 digits - NZ Telecom CDMA > note that there is number portability so the above is a guide. > > NZ Landline: > area code 3, 4, 6, 7 and 9 followed by 7 digits (first digit will be > in the > range of 2-9) > > NZ toll free: > area code 508 and 800 followed by 6 digits > > NZ premium: > area code 900 - though I doubt any of you will be routing these calls > > AU cellular: > area code 4 followed by a 2 digit network code, and then a 6 digit > number > Networks include: Optus, Telstra, 3, Vodafone, Virgin and others. > All use GSM > and there is number portability. > > AU landline: > area code 2, 3, 7 and 8 followed by 8 digits (first digit will be in > the range > of 2-9) > > AU toll free: > area code 1300 or 1800 followed by 6 digits OR area code 13 followed > by 4 > digits. > > AU premium: > I'm not sure though someone present may fill us in. > > Following is the list of countries I need information on: > > ; ANDORRA > ; ARGENTINA > ; AUSTRIA > ; BAHAMAS > ; BELGIUM > ; BRAZIL > ; BULGARIA > ; CANADA > ; CHILE > ; CHINA > ; COLOMBIA > ; CROATIA > ; CYPRUS SOUTH > ; CZECH REPUBLIC > ; DENMARK > ; ESTONIA > ; FRANCE > ; GERMANY > ; GREECE > ; GUADELOUPE > ; GUAM > ; HONG KONG > ; HUNGARY > ; ICELAND > ; INDONESIA > ; IRELAND > ; ISRAEL > ; ITALY > ; JAPAN > ; JORDAN > ; SOUTH KOREA > ; LUXEMBOURG > ; MALAYSIA > ; MARIANA ISLANDS > ; MEXICO > ; MONACO > ; NETHERLANDS > ; NORWAY > ; PANAMA > ; PERU > ; PERU LIMA > ; POLAND > ; PORTUGAL > ; PUERTO RICO > ; ROMANIA > ; RUSSIA > ; SAN MARINO > ; SINGAPORE > ; SLOVAKIA > ; SLOVENIA > ; SPAIN > ; SWEDEN > ; SWITZERLAND > ; TAIWAN > ; THAILAND > ; TURKEY > ; UNITED KINGDOM > ; UNITED STATES > ; VENEZUELA > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
Michael wrote:> On Sat, 13 Dec 2008 19:29:23 you wrote: >> Alex Balashov wrote: >>> You'd be cutting into the revenue stream of folks like Telcordia, CCMI, >>> etc. >> ... which, of course, there's nothing wrong with. Just be prepared to >> witness the awesome power of their fully operational legal battlestation. > > This is OTTP (Over the top paranoia) > > I am talking about information gained from people resident in the various > countries.I understand. The problem is that such information is useless and an almost entirely pointless waste of time because in all but the simplest of scenarios (like the kind you mention in Australia and NZ) ordinary people do not have this information, or the information is applicable to them only and not of much intersubjective value. It is exceptionally rare to find a country with just a handful of prefixes, especially outside of the Third World. So, the information would have to come from official sources to be comprehensive. That's problem one. Problem two was summarised by the poster "SIP": "I'm not sure I can see the value of a community-driven effort to keep track of things which, by nature, are not applicable to everyone in the community, as we all have our own contracts with our own providers and our own set of rates based on our own conditions of traffic." In other words, whereas the distinction between a fixed and mobile call may be of importance in *your* particular pricing arrangements with your suppliers, other people have all sorts of different arrangements. There are blended rates for everything, blended rates for some things, decked rates for some things and blended for others, decked rates by LATA, decked rates by carrier, etc, etc, etc. I'm sure there are rate decks by hemisphere, rate decks by how many goats you are prepared to ritually sacrifice as tribute to ITSP, etc. So, the distinction useful to you in your rating process is not necessarily useful to others, or even a critical mass of others. -- Alex Balashov Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671 Mobile : (+1) (706) 338-8599
Michael wrote:> There IS life outside of the USA (shock, horror!)I am not making the metaphysical error of assuming otherwise. I'm just pointing out that routing complexity introduces exponentially with competition.> Anyone can download NZ's entire numbering plan down to suburb/town level from > the NZ Telecom wholesale website. I doubt they would be alone in this.Sure, I just gave you the link to NANPA's equivalent of that. What good is it going to do you, whether with regard to the US or in any other country that has more carriers than thou hast fingers?> Because LOTS of countries differenciate between landline and cellular calls. > From my list here I would say over 80% do.What do you mean by "countries differentiate?" Countries don't differentiate anything - carriers differentiate. And the nature of those differences is inextricably bound up in their interconnection agreements. Many international backbone carriers privately interconnect with mobile carriers and bypass the incumbent telco (if the country's laws allow this), allowing them to achieve lower termination rates. The point is that this landline vs. mobile distinction is not particularly universal, not particularly uniform, and therefore, not particularly useful. It's rather specious. -- Alex Balashov Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671 Mobile : (+1) (706) 338-8599
On Sat, Dec 13, 2008 at 04:10:47PM +1300, Michael wrote:> Is there any good free / accurate online resources with detailed country > numbering plans? Failing that let's get something running ourselves.Here is some info for the UK :- http://www.ofcom.org.uk/telecoms/ioi/numbers/numbers_administered/ I've spotted a small number of errors in the data, and I can give you the details if you want. Cheers Ben
On Dec 12, 2008, at 7:10 PM, Michael wrote:> Is there any good free / accurate online resources with detailed > country > numbering plans? Failing that let's get something running ourselves.[snip] I'll avoid the good discussion on this thread that has been made already to date. The answer is: "It's not simple." I wish it was, but that data is typically in the hands of companies who do NOT want to share it, because errors on your part make money on their part, and those companies don't really want to see you exist at all in the first place. It would be great if this could be a shared resource of some sort, but I don't expect that we'll ever see that with E.164 numbering - the entrenched interests in that number space have zero interest in making the data available for many political, technical, and fiscal reasons. In the past, I've received a full breakdown of rates from my carriers for North America, as I have typically purchased directly from North American carriers who give me a 5, 6, or 7 tier model of prices across the country. LNP has confused the issue a bit, but not enough to warrant dips into the LNP database to determine if mobile numbers are being delivered on landline, or vice versa. For most of the world not in country code 1, I typically get just two rates: landline and mobile. In some very large nations, mobile may be broken down into a few carriers, but not often. Carriers almost always will NOT give out number ranges for what is mobile versus what is landline. They just say "Mobile: $V.WXYZ Landline: $A.BCDE" and leave it to me to figure out what is what. This, of course, is disingenuous - obviously they know what is mobile and what is landline, since they need it for their own billing purposes. But they would NEVER try to help out a customer like that, since it makes the customer more informed and less likely to just swallow an incorrect billing. So in a recent job (not Digium) I had to get the Telcordia GDDS database. Cost varies depending on what kind of use you have, but I seem to recall ranging from $20k per year to $Absurd per year. It was useful - recall that mobile rates can be 10x or even 20x what landline rates are, so billing your customers in the same bracket as you are billed by your vendors becomes startlingly important when you hit the millions of minutes per month mark in international termination. http://www.telcordia.com/products_services/trainfo/catalog_details.html http://www.trainfo.com/products_services/tra/downloads/gdds.pdf Then, you'll need to create a database that tracks what each one of your vendors gives you for mappings, create a linkage between their terminology or number formats to the GDDS database, and extract to create a routing table. Non-trivial, but not super-difficult. Get a big machine with gobs of RAM and store all of your databases in cache. The US I seem to recall had (for each carrier) something like 420,000 rows in one configuration. Multiply by the number of carriers you are using, add in the 60,000 or so rows for international per carrier... it gets to be a pretty plump routing table. "You must be _this_ tall to ride this wholesale ride." We created an external Java app that would take the origin number out of our Asterisk arrays and then do a database lookup. Total delay between receipt of the INVITE and the INVITE being out to the "best" vendor was around .3 seconds, so not bad. But there is a reason that there are whole companies doing routing and rating engines. JT --- John Todd email:jtodd at digium.com Digium, Inc. | Asterisk Open Source Community Director 445 Jan Davis Drive NW - Huntsville AL 35806 - USA direct: +1-256-428-6083 http://www.digium.com/