Pitney Bowes MapInfo Professional - Manual (Page 363)

During Geocoding, MapInfo Professional reads data such as street data, postal code data, and other
non-coordinate information from your database and matches it against street or postal code information
on a MapInfo data table.
During the Create Points process, MapInfo Professional reads X and Y coordinate data (such as longitude
and latitude data from a Global Positioning System) and plots data using those coordinates. Use the
appropriate process to the type of data you have collected.
For more specific instructions on creating points, see the following topics in the Help System:
• Geocoding - Assigning Coordinates to Records
• Putting Longitude/Latitude Coordinates on a Map
If your data is in non-MapInfo format before you geocode or create points, you must convert it
before using either of these processes. Note:
Displaying DBMS and Web Service Data
Displaying Your Remote DBMS Data
The process for displaying spatialized data from Oracle, SQL Server, or PostGIS is different from the
tables we have discussed so far. For more information about accessing remote data, see
Getting Started .
For database versions that MapInfo Professional supports, see the MapInfo Professional Install
Guide. Note:
Displaying and Importing Data from a Web Map Service
A Web Map Service (WMS) is a technology that gives you a source for data over your Intranet or over
the Internet. This innovation is based on a specification from the Open GIS Consortium (OGC) and allows
you to use raster map images from servers that also comply with the specification. You must specify the
coordinate system within your data request to ensure that the images you retrieve "sync up" or register
with your other map data.
This specification supports transparent pixel definition for image formats as well. This allows you to use
the images you retrieve as overlays and not solely as the bottom layer of your map.
WMS data may not exist for the geography you are looking for. Further, the data that is provided is
determined by the WMS server.
You must have a working Internet connection to retrieve or use WMS data. Note:
• For instructions on retrieving and displaying data from a Web Map Service, see Retrieving Map Data
from Web Map Services in the Help System.
Displaying your Excel (.XLS or .XLSX) Data
You can create a .tab file from an Excel file that is up to 64K in size.
To create a .tab file from your Excel (.XLS or .XLSX) data:
1. In MapInfo Professional on the File menu, click Open to display the Open dialog box.
2. In the Files of Type list select (.XLS or .XLSX), navigate to your data, and click Open.
3. Select the worksheet you want in your MapInfo data table. Make sure that this data includes either
postal codes or longitude/latitude coordinate values.
The default data range for an Excel file is the entire worksheet.
• If you select the Use Row Above Selected Range for Column Titles check box, the default data
range begins at A2 (row 2).
363 MapInfo Professional User Guide
Chapter 14: Putting Your Data on the Map