MapInfo Products KnowledgeBase

Product: ExchangeInfo
Version: 5.0 Plus
Platform: Not Platform Related
Category: Product Info

Summary:
Geocoding/joining a database of phone numbers using central office points.

Question:

Below is a database of phone numbers opened in MapInfo Professional in the following format:



How is it possible to geocode/join these records by phone number using the new version of ExchangeInfo Plus?

If the phone number data is in a format such that the phone number values are stored in one column (e.g. 870-544-0234), it is necessary to set the data up according to this document-->MapInfo Products Knowledge Base.

Answer:

1. Open the ExchangeInfo_2 Plus tables Usnpanxx.TAB, USWcPt.TAB.

2. Choose Query>SQL Select. The SQL Select dialog displays.

3. Enter Customers, Usnpanxx, USWcPt in the from Tables field.

4. In the select columns field, select the desired columns of information to be returned in this query. In this example, the following columns will be selected:

Customers.Name, Customers.NPA, Customers.NXX, Customers.BLOCK, UsNpanxx.WC_Code, UsNpanxx.Exchange

5. Enter Customers.NPA = USNPANXX.NPA and Customers.NXX = USNPANXX.NXX and Customers.Block >= USNPANXX.StartRange and
Customers.Block <= USNPANXX.EndRange and USNPANXX.Wc_code = USWcPt.Wc_code in the where Condition field.

6. Enter Customers_Exchange_Query in the into Table named field.

7. Click OK. The results of the query display in a browser window.

**An optional way of running this is to use the MapBasic window with the following syntax:

Select Customers.Name, Customers.NPA, Customers.NXX, Customers.BLOCK, UsNpanxx.WC_Code, UsNpanxx.Exchange from Customers, UsNpanxx, UsWcPt where Customers.NPA = USNPANXX.NPA and Customers.NXX = USNPANXX.NXX and Customers.Block >= USNPANXX.StartRange and
Customers.Block <= USNPANXX.EndRange and USNPANXX.Wc_code = USWcPt.Wc_code into Customers_Exchange
Browse * From Customers_Exchange_Query

8. Save a copy of Customers_Exchange_Query using File>Save Copy As. Name the table something like Customers_Exchange.

The Customers_Exchange table has now been linked to the ExchangeInfo Plus data and is also a mappable point table.



Last Modified:
Document URL: http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/A4D4B96985EDE6DE85256C060054F57B

Geocoding/joining a database of phone numbers using central office points.^A4D4B96985EDE6DE85256C060054F57B^Y