Hello Ivan, NeuStar offers two databases that will provide the answer you need. The first one is the SIP-IX product which is the North American number portability database which can be queried on a call by call basis or downloaded in bulk. This database include a data field which indicates the whether the called number is wireless or wireline. The number portability database includes all ported numbers and probably over 50% of non-ported numbers. So you will still need a database that covers all un-ported number and includes a data filed indicating if the number is wireless or wireline. The second NeuStar database you will need is the CC1 database which can be downloaded on a daily basis. So to get a 100% solution you would first query the North American number portability database (NPAC) to determine if the destination is wireless or wireline. If you do not get a answer, the second step would be to query the CC1 database. As you noted you could create the same solution by querying the NPAC first and then a Telcordia database such as the LERG or NNACL. As an alternative you could also try http://www.telcodata.us/ which offers basically the same information found in the LERG. In addition to NeuStar and Telcordia, you can also subscribe to NPAC data from TNSI and Syniverse. So if you dig around you will find you have a few options. Jim Dalton TransNexus From: voiceops-bounces at voiceops.org [mailto:voiceops-bounces at voiceops.org] On Behalf Of Ivan Kovacevic Sent: Tuesday, November 08, 2011 8:05 AM To: 'Alex Balashov' Cc: voiceops at voiceops.org Subject: Re: [VoiceOps] Mobile vs. Landline Lookup Hi Alex, Thanks for your reply. Obviously my initial post lacked clarity, so let me try to fix that. The client is looking for a way to determine whether a phone number is mobile or landline. What is best way to determine that? Are Telcordia DBs the only game in town or are there easier, cheaper, better solutions? Is the method different for Canadian and US numbers? Thanks again for your reply and sorry about the lack of clarity in the initial post. Best Regards, Ivan From: Alex Balashov [mailto:abalashov at evaristesys.com] Sent: November-07-11 8:56 PM To: Ivan Kovacevic Cc: <voiceops at voiceops.org> Subject: Re: [VoiceOps] Mobile vs. Landline Lookup LNP dips work the same way for fixed and wireless. -- This message was painstakingly thumbed out on my mobile, so apologies for brevity, errors, and general sloppiness. Alex Balashov - Principal Evariste Systems LLC 260 Peachtree Street NW Suite 2200 Atlanta, GA 30303 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/ On Nov 7, 2011, at 5:53 PM, "Ivan Kovacevic" <ivank at rogers.com> wrote: Hi, Does anyone have any experience doing mobile vs. landline lookups for US and Canada? What would be the best way to do this? A client has asked us whether this can be done and to be frank, I am not sure how we would go about it with LNP implemented in both countries. So we are looking for some pointers? Any help is appreciated. Thanks in advance, Ivan _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

As far as getting the information you want, it really depends on whether you are trying to figure this out prior to someone making a call, while the call is being set up or after the call was delivered. You can do a dip if you are setting up the call, but if you want to get it before hand you would need to look it up in the NPAC database, which you would have if you chose to sign up for the NPAC LTI service. If you have already received the call and are just trying to determine whether it came from a local or wireless carrier, then you can look at the JIP aka LRN that is associated with the TN. There can only be one LRN company per NPA-NXX so the routing for the LRN will always match what the routing is for the NPA-NXX-X that the LRN is created from. For example, if my LRN is 205-234-5000, I could look up 205-234-5 in the LERG or TelcoData or Local Calling Guide to find out the OCN and company name for that provider. Mary Lou Carey BackUP Telecom Consulting CLEC Consultant OFF: 615-791-9969 From: voiceops-bounces at voiceops.org [mailto:voiceops-bounces at voiceops.org] On Behalf Of Paul Timmins Sent: Tuesday, November 08, 2011 11:44 AM To: Ivan Kovacevic Cc: voiceops at voiceops.org Subject: Re: [VoiceOps] Mobile vs. Landline Lookup The only way to know for sure is real time LNP dips. What was a landline an hour ago could become a cell phone in a matter of seconds. The LNP dips will still need a database to look up the returned LRN in, which is where telcordia's databases (or mine, (shameless plug) http://www.telcodata.us/) come in. You can use telcordia's or mine to do some basic pre-scrubbing of numbers for basic validity, exclude known wireless ranges (which COULD be landlines, as you can port wireless numbers to wired as well! I don't know your application but I thought I'd mention that) etc. -Paul On 11/08/2011 08:04 AM, Ivan Kovacevic wrote: Hi Alex, Thanks for your reply. Obviously my initial post lacked clarity, so let me try to fix that. The client is looking for a way to determine whether a phone number is mobile or landline. What is best way to determine that? Are Telcordia DBs the only game in town or are there easier, cheaper, better solutions? Is the method different for Canadian and US numbers? Thanks again for your reply and sorry about the lack of clarity in the initial post. Best Regards, Ivan From: Alex Balashov [mailto:abalashov at evaristesys.com] Sent: November-07-11 8:56 PM To: Ivan Kovacevic Cc: <mailto:voiceops at voiceops.org> <voiceops at voiceops.org> Subject: Re: [VoiceOps] Mobile vs. Landline Lookup LNP dips work the same way for fixed and wireless. -- This message was painstakingly thumbed out on my mobile, so apologies for brevity, errors, and general sloppiness. Alex Balashov - Principal Evariste Systems LLC 260 Peachtree Street NW Suite 2200 Atlanta, GA 30303 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/ On Nov 7, 2011, at 5:53 PM, "Ivan Kovacevic" <ivank at rogers.com> wrote: Hi, Does anyone have any experience doing mobile vs. landline lookups for US and Canada? What would be the best way to do this? A client has asked us whether this can be done and to be frank, I am not sure how we would go about it with LNP implemented in both countries. So we are looking for some pointers? Any help is appreciated. Thanks in advance, Ivan _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops