Using Select to Create Queries - MapInfo_Pro - 2023

In general the process for selecting objects using Select is:

1. On the MAP tab, click on the Launcher button in the lower right corner of the Selection group to open the Select dialog box.
   
   

   

   
   
   • Select Records from Table - Select the table from which to select records.
   • that Satisfy - Create the expression to select records.
   • Store Results in Table - Choose a storage place for results.
   • Store Results in Column - Choose column for sorting.
2. To see a list of the records you have selected, select the Browse Results check box. MapInfo Pro creates a Browser of the new selection table.
3. To display the query results in the currently active Map window, select Find Results in Current Map Window. If there are no open Map windows, this check box is disabled. You cannot save this check box setting to a template. This option is cleared by default.
4. Click OK to begin the query.

MapInfo Pro names the table Query1. It will name the next temporary selection table Query2. You can override MapInfo Pro's default name and give the selection a descriptive name. Type the new name into the Store Results in Table box. The table can also be saved as a separate table with Save Copy As.

Example: Selecting

MapInfo Pro makes finding information and locations easy. You can use the Select feature to create subset databases. As an example, we use the WORLD table to select countries with a literacy rate greater than 90%.

1. Open the WORLD.TAB table.
2. On the MAP tab, click on the Launcher button in the lower right corner of the Selection group to open the Select dialog box.
3. Complete the Select dialog box:
   • Select Records from Table - From the Select records from table drop-down list, choose World.
   • Assist - Click the Assist button to display the Expression dialog box.
4. Complete the Expression dialog box as shown in the figure:

   From the Columns drop-down list, choose Literacy.

   From the Operators drop-down list, choose > (the greater than sign).

   Type 90.

   Click Verify to confirm the syntax of your expression. Click OK to close the Verify dialog box.

5. Click OK to close the Expression dialog box. The Select dialog box redisplays.
6. Select the Browse Results check box.
7. Click OK. MapInfo Pro creates a Browser that contains the selections. Notice that the selections display in both the World map and Browser.
   
   

   

   
   

Making a New Table Using a Subset of a File

Many of the data sets that are used with MapInfo Pro include more objects and information than necessary for some projects. In many cases it is easier to work with a subset of the complete data product. For example, if you were tracking crime statistics for a county by census tract, you would not need the census tracts for the entire state.

There are two ways to create a new table that will contain a subset of the records from an existing file. You can interactively select the objects representing the records you would like to put in the new table using one of the select commands. Or, you can use the SQL Select command to choose a subset of objects based on an SQL function. For an example using the SQL Select command, see Example 1 - Computing Population Density Using Area. Saving the resulting table is the same procedure, whether you choose the objects interactively or use an SQL Select statement.