[Asterisk-biz] global numbering plans

[John Todd]

At 8:11 AM -0800 11/27/05, trixter aka Bret McDanel wrote:
>
>On Sun, 2005-11-27 at 15:42 +0000, Are wrote:
>>  Thanks to Bret McDanel and his effort to compile this data.
>>
>>  I have now put up a web interface for the data at:
>>
>>  http://astbill.com/numberingplan
>
>If you need mirrors I can provide one.  I was talknig with someone else
>about doing this but you beat us to it (we were discussing exactly what
>format needed to exist to allow people to better use this since we
>wanted to make it as useful as possible, we never got out of the
>discussion phase - that other person has the option to come forward and
>offer a mirror as well.
>
>I wont name them incase they dont want solitications for other mirroring
>stuff but they should be able to read this and decide for themselves if
>they want to come forward.
>
>I would like to see selectors for geographic only, mobile only
>whatever..  but that becomes really unless you do a select distinct
>type ...   to generate a list of all the types.  And the extra select
>(depending on database usage) may cause other problems for the site
>hosting it - but it shouldnt be that great of an impact overall).
>
>At any rate, thanks for putting that up.  And it looks nice, making it
>really easy :)
>
>The other aspect we were looking at was to make this editable by the
>community, do you have plans to add that feature?  I would like to be
>able to update that list with what I currently know is broke (of which
>there are a few things known and many unknwon I am sure).  I know I have
>more than you becuase you only have 580,067 entries and I have about
>another 15,000 or so (at least).  I am just lazy :P
>--
>  Trixter http://www.0xdecafbad.com     Bret McDanel


This information can be purchased from companies like CCMI.  Here's their link:

http://www.ccmi.com/interdata.html

If I recall correctly, they have a one-time fee of something like 
$3500 for the planet (330k route descriptors) in easily-digestable 
CSV format, and they have a separate list (at a much lower cost) for 
North America.  I've found that "hand-generated" lists tend to 
degrade quickly over time.  Of course, each carrier you work with 
gives you a slightly different list of destinations, and so you'll 
find that your list gets bigger and uglier with every interconnect 
you make, and standardizing the data is almost impossible given the 
volume of changes that each carrier seems to think they should make. 
Formatting of city names, character sets, geographic vs. 
non-geographic, mobile vs. terrestrial: it is very hard to capture 
and display everything correctly, though of course it is possible.

The biggest task is deleting "bad" information.  That almost never 
happens.  I think an open-source model would be useful to reduce bad 
information, but this data is very touchy - you should have strict 
accountability logs to roll back changes made by "untrustworthy" 
participants.

I had asked for this a while back (7/2004) and here are some links 
which may or may not be useful (or even still valid):

http://www.nanpa.com/nanp1/cnutlzd.zip
http://www.nanpa.com/reports/reports_cocodes_assign.html
http://www.rtr.at/web.nsf/lookuid/9E1F1CA5EB271387C1256E9E004E5978/$file/Austrian%20Numbering%20Plan%202004-05-12.xls
http://www.opta.nl/download/registers/numreg.zip
http://www.itu.int/ITU-T/inr/nnp/index.html
Duane at e164.org has a list... proprietary?

JT