Case Description

Query the distribution of provinces with population exceeding 30 million and GDP over 30,000 in 2014.

Data Description

Sample data is located in ...\SampleMap\ThematicMap\PopulationAndEconomic folder.

The dataset Province_R contains population and GDP data of provinces for 2014.

Notes:

• Sample data contains the above data information, but requires downloading a separate installation package. For details, please refer to Obtain Sample Data Package.

Main Steps

1. Open PopulationAndEconomic.smwu workspace and add Province_R dataset to the map.
2. Click Spatial Analysis tab -> Query group -> SQL Query dropdown menu -> SQL Query item.
3. In the SQL Query dialog, confirm the query data is PopulationAndEconomic datasource and Province_R dataset.
4. In the first default expression of SQL Query input box, change the default "SmID" field to "Pop_2014" field, then enter "3000" in the value input box.
5. Click Add clause button. In the second expression, change the default "SmID" field to "GDP_2014" field, then enter "30000" in the value input box.
6. Check Highlight in Map checkbox.
7. Check Save Results and set result data's datasource to PopulationAndEconomic, dataset to QueryResult.

   

8. Click Query button. Search results will be automatically displayed in Linked Views mode as shown below.

Related Topics

Build SQL Query

Construct SQL Expression Query

Common Expressions for SQL Query

Function Specifications for SQL Query

Association Query Example

Group Statistics Example