International Numbering Plan Database

Patrickz 2.0

International Numbering Plan Database
numbering plans คืออะไร? อ่านได้ที่นี



ข้อมูลที่ Download ได้ฟรี
astbill.com รวบรวมเอาไว้ download ได้ที่หน้าเวบเพจ numbering plans มีทั้งหมด 580,067 records
numberplan.org - International, National & Mobile numbering plans
รวมไว้เยอะเหมือนกัน
ITU รวบรวมข้อมูลของ ICC(ITU Carrier Codes), International Country Codes, ข้อกำหนดเกี่ยวกับ ENUM, และที่สำคัญ National Numbering Plans ผู้ให้ข้อมูลคือ National Telecommunications Commission (NTC)
ประกาศคณะกรรมการกิจการโทรคมนาคมแห่งชาติ เรื่อง แผนเลขหมายโทรคมนาคม


ข้อมูลที่หาได้ฟรีนั้น ส่วนใหญ่มักจะมีแค่
CC : Country Code เช่น รหัสประเทศไทย 66
NDC : National Destination Code คือ 6681
NSN : National (Significant) Number คือ 81
Type : จะบอกประเทศของเบอร์ ซึ่งมักจะมีแค่ MOB - Mobile, FIX - Fixed/Geographic/Land line (จริงๆ ยังมี XTF – Free phone, COU – proper, SAC – short code อีก)

ในทางการคิด Billing นั้น ข้อมูลเพียงเท่านี้ก็เพียงพอแล้ว เพียงแค่แยกได้ว่าเบอร์ไหนเป็นมือถือ(MOB) เบอร์ไหนเป็นเบอร์บ้าน(FIX)
อันที่จริง ข้อมูลเหล่านี้ ก็มีผู้ให้บริการรวบรวม และขายข้อมูลเหล่านี้ให้ ลองอ่านดูรายละเอียดด้านล่างครับ พร้อมทั้งตัวอย่าง Fields ด้วย




ข้อมูลที่มีค่าใช้จ่าย

ส่วนใหญ่มักจะคิดค่าบริการเป็นรายเดือน หรือรายปี ปกติข้อมูลพวกนี้จะ update เดือนล่ะครั้ง

bsmilano.it คิดค่าบริการ 500 Euro ต่อปี

numberingplans.com มีไม่ต่ำกว่า 800,000 records update เกือบทุกวัน แต่ละ published ทุกๆ วันจันทร์แรกของเดือน หรือเมื่อมีการเปลี่ยนแปลงจำนวนมาก ส่วนค่าใช้จ่ายผมลืมไปแล้ว




ตัวอย่าง E.164 Numbering Plans Database records lay-out

CNS
Length: upto 15 digits

The CNS is the subscriber number. The CNS consists of three parts: Country code (CC), National destination code (NDC) and Subscriber number (SN). NDC and SN together are also referred to as National significant number (NSN). CNS is therefore the entire international prefix which allows you to determine the type of number you’re dealing with.

country_code
Length: 1, 2 or 3 digits
This refers to the country code or global destination code as assigned by the International Telecommunications Union in Recommendation E.164.

national_significant_number
Length: 0 to 14 digits
This refers to the number range within a country or global service. NSN stands for “national significant number”, which means that these numbers are the least numbers necessary to identify the number type (and registrar). The length of the NSN depends on the numbering plan, but may also depend on the length of the country code (CC). The total digit length of any number in international format (excluding trunk digits and international access codes) may not exceed 15.

ISO-3166-alpha-2
Length: 2 (fixed)

This field refers to the country by usings the two-letter abbreviation as defined by International Organization for Standardization (ISO).

ISO-3166-alpha-3
Length: 3 (fixed)

This field refers to the country by usings the three-letter abbreviation as defined by International Organization for Standardization (ISO).

UTC_min
Format: (-)x(,x)
This field reflects the minimum time difference between the country and Universal Coordinated Time (UTC). If the country covers only one time zone, the UTC_min field will be the same as the UTC_max field. The date for possible Daylight Savings Time (DST) is not yet available. This information is also not guaranteed to be error free. The 99% SLA does not apply.

UTC_max
Format: (-)x(,x)
This field reflects the maximum time difference between the country and Universal Coordinated Time (UTC). If the country covers only one time zone, the UTC_min field will be the same as the UTC_max field. The date for possible Daylight Savings Time (DST) is not yet available. This information is also not guaranteed to be error free. The 99% SLA does not apply.

Destination
Length: upto 255 (variable)

This field refers to the official full country name in the English language.

typeID
Length: 3 (fixed)

This field refers to the three letter identifier of the number type (FIX, MOB, XPR, etc.). These codes have no internationally standardised significance, but have merely been introduced by Numberingplans.com in order for clients to normalise the database internally.

number_type
Length: upto 50 (variable)

This field refers to the number type in the English language.



Location
Length: upto 255 (variable)

This field refers to the city and/or province the number range was assigned to. Depending on the information, this may mean the actual location of the telephone connections or the location of the exchange or switch all numbers within the range are connected to.

Registrar
Length: upto 255 (variable)

This field refers to the company that has registered the entire number range. All numbers within the number range belong to the same company. However, we must note that we do not compensate for the possibility of number portability.

area_code_length
Length: 0, 1

This field states the length of the national destination code (NDC). The national destination usually is the same as the area code or mobile range code. This information is not available for all destination types and countries. This value is always zero when the NDC always has to be dialled nationally, even within the same network. This information is also not guaranteed to be error free. The 99% SLA does not apply.

min_subscr_nr_length
Length: 0, 1 or 2

This field states the minimum length of the subscriber number (SN) within the specified number range. The subscriber number can be dialled within a country to connect to other users without dialling the area code. This is only true for countries with a so-called “open” numbering plan. This information is not available for all destination types and countries. This information is also not guaranteed to be error free. The 99% SLA does not apply.

max_subscr_nr_length
Length: 0, 1 or 2

This field states the minimum length of the subscriber number (SN) within the specified number range. The subscriber number can be dialled within a country to connect to other users without dialling the area code. This is only true for countries with a so-called “open” numbering plan. This information is not available for all destination types and countries. This information is also not guaranteed to be error free. The 99% SLA does not apply.

range_activation
Format: dd-mm-yyyy

This field states the date of activation of the specific number range. The date is in European format: 01-01-2002 (numerical, seperated by hyphens). This information is not available for all destination types and countries.

range_deactivation
Format: dd-mm-yyyy

This field states the date of deactivation of the specific number range. The date is in European format: 01-01-2002 (numerical, seperated by hyphens). This information is not available for all destination types and countries.

range_status
Length: upto 10

This field states the status of the specific number range. Currently in use:
- (nothing) = range is currently active
- reserved = range is reserved for future use

mobile_country_code
Length: 3

This field states the Mobile Country Code (MCC) of the number range. This field is only available if the number range is “mobile” and if the country or destination has been assigned an MCC.



mobile_network_code
Length: upto 3

This field states the the Mobile Network Code (MNC) of the specific registrar (= mobile network), which consists of two or three digits. This field is only available if the network is known to be a GSM or UMTS network, of if the MNC has come to our attention in any other way. This information is not available countries. This information is also not guaranteed to be error free. The 99% SLA does not apply.

operation_company_number
Length: 4

This field states the Operation Company Number (OCN). This number is a four digit number to uniquely identify any registered company. The OCN is only used is some of the major countries within the North American Numbering Plan Area (NANPA).

 

ผมได้แนบตัวอย่างเป็น CSV format ให้ดูด้วย ลอง download ได้ข้างล่างครับ 

http://files-upload.com/421997/E164_sample_Thailand.zip.html
http://www.meefile.com/download.php?id=67c6a1e7ce56d3d6fa748ab6d9af3fd7

บันทึกนี้เขียนที่ GotoKnow โดย  ใน Patrickz - just a developer

คำสำคัญ (Tags)#database#telecom#numbering plans

หมายเลขบันทึก: 117973, เขียน: 08 Aug 2007 @ 13:47 (), แก้ไข: 16 May 2012 @ 00:19 (), สัญญาอนุญาต: สงวนสิทธิ์ทุกประการ, อ่าน: คลิก


ความเห็น (0)