VERIFIED SOLUTION i
X

Create a Thematic Map using data from two different tables in MapInfo Pro

UPDATED: March 30, 2017


Creating a Thematic Map on one table using data contained in a different table can be accomplished in several ways.  The method to join the two tables will depend on whether there are columns of data in common between the tables, or if both tables contain map objects that can be used to link them.
Use the method that works best depending on what is common between the data or if both tables contain map objects of some type.

Process to use when both tables contain Map Objects such as Regions Objects (Polygons) in one table and Symbol Objects (Points) in the second table.

1. Select from the Map tab>Content>Add Theme
2. Select the Type.  For this example, Ranges will be chosen and the table containing the Region objects will be shaded.
3. For this example, select a Template Name that starts with the word “Region Ranges….” since those are the types of objects being shaded.
4. Click Next
5. In the Create Thematic Map – step 2 of 3 choose the correct table from dropdown next to “Table:”.  For this example, that will be RegionTableName
6. From the "Field:" dropdown, click the dropdown and select the word “Join…” from the list.
7. In the Update Column for Thematic dialog, select the SymbolTableName from the “Get Value From Table:” dropdown. This will be the table that provides the data that will shade the RegionTablename.
8. Click the "Join…" button and set up the join choosing the option next to  “where object from table SymbolTableName”…
9. Make sure the dropdown has the words “is within” selected.  
The dialog should read: “where object from table SymbolTablename is within object from table RegionTablename”
If the Region table is listed first, and the Symbol table is second, choose the word “contains” from the dropdown so that the Region table’s objects “contains” the Symbol table’s objects.
10. Click OK
11. Once back in the Update Column for Thematic dialog, select “Calculate: Value” (or other item from the dropdown) and select the correct column from the SymbolTablename holding the range value data to be used for the theme.  Only fields that are formatted with a numeric data type such as float, decimal, or integer can be selected for use with a Range thematic.
12. Click OK
13. Back in Step 2 of 3, click Next to move to step 3 of 3.  In this dialog, click the Ranges, Styles, or Legend button to customize any of the default settings.
14. Click OK

The RegionTableName should be thematically shaded based on the column of data chosen from the SymbolTableName.  Click on the Help button on any of the dialogs presented for detailed information.

Process to use when only one table has Map Objects, but both tables contain common columns of information.

Some examples of common data information that can be used to link tables would be a unique matching ID of some type such as a number or code that is common between the two.  Other examples could include something like a state or province abbreviation, territory name, a postal code, etc.

For this example, the common field will be “State” which holds a state abbreviation value.
The table to be thematically shaded will be a region table using the same example name of RegionTableName.  The table that holds the data for the thematic will come from a column in the NonMappableTableName for this example.

Repeat steps 1 through 6 from the first process example.

7. In the Update Column for Thematic dialog, select the NonMappableTableName from the “Get Value From Table:” dropdown. This will be the table that provides the data that will shade the RegionTablename.
8. Click the “Join…” button to set up the join.  Choose the option at the top of the dialog to select the common columns from each of the two tables.  
Example:  
where: CommonColumnName from table RegionTableName
matches CommonColumnName from table NonMappableTableName
9. Click OK
10. Once back in the Update Column for Thematic dialog, select “Calculate: Value” (or other item from the dropdown) and select the correct column from the NonMappableTableName holding the range value data to be used for the theme.  Only fields that are formatted with a numeric data type such as float, decimal, or integer can be selected for use with a Range thematic.
11. Click OK
12. Back in Step 2 of 3, click Next to move to step 3 of 3.  In this dialog, click the Ranges, Styles, or Legend button to customize any of the default settings.
13. Click OK

The RegionTableName should be thematically shaded based on the column of data chosen from the NonMappableTableName.  Click on the Help button on any of the dialogs presented for detailed information.


 

Environment Details


 

Downloads

  • No Downloads