Pitney Bowes MapInfo Professional - Manual (Page 232)

For instance, by formulating queries with Select, you can ask MapInfo Professional to:
• Show only postal code regions where the average household income is above $65,000.
• Show only postal code regions where the median age is 42.
• Show only the postal code regions where the household income is above $65,000 and the median
age is 42.
• Show only records for all orders received in July or September.
• Show cities of over 100,000 people in Texas, California and Florida.
When you are working in a Browser, MapInfo Professional highlights the records meeting the criteria of
the query. When you are working in a Map window, the graphic objects of the chosen records are
highlighted. When you are working in both windows, the objects in both are highlighted. In all cases,
MapInfo Professional automatically creates a working table called Selection that contains the results of
the query. You can browse, map, or graph this table like any other table. The table can also be saved
as a separate table with Save Copy As.
Finding an Object or Street Address
To find an object or street address:
Your tables must be mappable and indexed. If you need to set up these components, on the File menu
point to New Table (Import) or on the Table menu point to Maintenance and select Table Structure.
1. On the Query menu, point to Find to open the Find dialog box.
2. Click the Search table drop-down list and choose a table from which to search.
3. Click the for objects in column drop-down list and choose the column containing the location information
of the objects you are looking for.
You now have the option of refining the search. Use this option when you are trying to find an object
or address whose name is not unique and is used for other objects or locations.
For example, when you are searching for the town of Ipswich in Great Britain, do you want Ipswich
in Suffolk county or Ipswich in Essex county. Refining the search by county allows you to specify the
county for each town, rather than just the town name.
• Optional - Click the Refine search with table drop-down list and choose a refining table (the table
must contain regions, such as states, counties, census tracts etc.).
• Optional - Click the using boundary name column drop-down list and choose your refining column,
the column containing the name of the boundary.
4. Check the Find in Front Window Only check box when you want the Find operation executed only
in the Front Window. When this check box is unchecked, the Find operation is executed in all windows.
When checked, if features are found, they will be marked with a symbol in a Map Window. If the
Browser window is the active window, it will be scrolled so the record appears in the Browser view.
When you have finished defining where to look for your search data and selecting between the front
most map and all maps then specify what data to look for.
5. Click OK to open the Find dialog box. This dialog box allows you to specify what data to look for.
The name of the column that you specified in the first Find dialog box is listed to the left of the list
box (for example, Street). When locating a street address, type in "# Name", such as "30 Elm St" or
"1045 Templar Blvd." What you type in depends on geocoding preferences specified on the Options
menu when you point to Preferences and select Address Matching.
MapInfo Professional comes with a text file called MAPINFOW.ABB [MapInfo Professional
Abbreviations], that contains a list of common street abbreviations, such as "St" for "Street" Note:
and "Blvd." for "Boulevard," and so forth. These help MapInfo Professional to obtain exact
matches. To familiarize yourself with the MAPINFOW.ABB file, you can take a look at its
contents in the Notepad Text Editor.
6. Type the name of the object or address you are searching for in this box. If you have used the Refine
option in the first dialog box, a second column name is listed (for example, ZIP).
MapInfo Professional 12.5 232
Querying Your Data in MapInfo Professional