I have compiled the last of the info that I had and I now have a 43MB CSV file (3.5MB compressed) containing about 579,887 entries. The information includes each country, whether its geographic (and where), mobile, premium, etc. Even have short codes (like 911/999 for emergency etc) for each country where available. I didnt do a dialplan format yet, and am not sure that I will, the original list was 5500 and that wasnt that bad to edit out the parts you wanted, but this is different, people would spend more time editing I think. If anyone wants it and cant figure out how to write a script to parse the CSV lemme know and I will do something. I make no warantees about the accuracy of this data, it most likely does have errors, use at your own risk. If you do spot an error, omission or other issue with the file let me know and I will see about fixing it. http://www.0xdecafbad.com/uploads/bigcountry.csv.gz Note: winzip can deal with .gz files This list also should correct some problems people had with incorrectly matching entries by using wildcards, it pads with X's to ensure proper number length. I also removed the generic country code entries as those would match anything in the country and largely are not good for anything - if you dont know about a specific call's cost you prolly dont want to route it :) -- Trixter http://www.0xdecafbad.com Bret McDanel UK +44 870 340 4605 Germany +49 801 777 555 3402 US +1 360 207 0479 or +1 516 687 5200 FreeWorldDialup: 635378 http://www.sacaug.org/ Sacramento Asterisk Users Group -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20051125/ffdc034f/attachment.pgp
Thanks Bret. How difficult was it to compile this list? I'm assuming it's a compilation of pubically available data? I'd be interested in how much work it would be to keep this up to date? Chris
On Sat, 2005-11-26 at 01:39 +0100, Michiel van Baak wrote:> On 16:25, Fri 25 Nov 05, trixter aka Bret McDanel wrote: > > Due to a very poorly written webapp, it took about 3 days. I got it > > from numberingplans.com and the way they get the database info is poorly > > done. For each country there are 1-N pages, as the page number > > increases so does the time it takes to get a single webpage. A direct > > 1:1 relationship. This lets me know they arent doing a limit in the > > database because that should return at a much more constant rate, but > > instead their ASP script is doing the processing. Unless they arent > > using a database and instead are using flat files, then they really need > > to think about indexes :P > > Lets give them a call to do the database optimalization for > say $200/hour ;)ha! I would gladly accept $200/hr to make my program run faster :) oh and if they get uppity about me having this (effectively specialized search engine content :) I can just publish the perl script that processes the resulting files (I fetched with lynx, its largely automated) and everyone can hammer on their webserver instead of just one person. Personally I think its far nicer for just one person to spider their site like any other search engine (the perl script is after the spidering) do this than 1000... but that is just me. -- Trixter http://www.0xdecafbad.com Bret McDanel UK +44 870 340 4605 Germany +49 801 777 555 3402 US +1 360 207 0479 or +1 516 687 5200 FreeWorldDialup: 635378 http://www.sacaug.org/ Sacramento Asterisk Users Group -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20051125/36b5634c/attachment.pgp
This should be posted to the Asterisk-Biz list. This list for Non-Commercial Discussion of Asterisk. -- Cheers, Matt Riddell _______________________________________________ http://www.sineapps.com/news.php (Daily Asterisk News - html) http://freevoip.gedameurope.com (Free Asterisk Voip Community) http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss)