Logout
Home
Dynamic Actions
Plug-ins
Charts
Maps
RESTful Web Service
Interactive Report
Tabular Form
Item Type
Sub Regions
Trees
Home
US State Populations - By Region
Map Tabs
US State Map
US Regions Map
Information
This page contains a Map representing 3 different regions of the USA, using the 'usa/country/states.amap' source map file. Three map series queries have been used to identify the regions to be represented on the map. Each series of the map will have one color associated with it, Region 1 in blue, Region 2 in red, and Region 3 in green.
To associate data with each state on the map, the information contained in the REGION_ID column of the AnyChart Map Reference Information for this source map has been used. The REGION_ID column contains the abbreviated name for each of the US States, so the map query must reference this information. Region 1 query is:
select null link, STATE_CODE label, POPULATION value from APA$NF_POPULATION WHERE REGION = 1
The LABEL column of the query,'STATE_CODE',holds the abbreviated name for each State in the USA.