Map options
The map visualizations display results on a geographic map. The query result set must include the appropriate geographic data:
- Choropleth: Geographic localities, such as countries or states, are colored according to the aggregate values of each key column. The query must return geographic locations by name. For an example, see choropleth example.
- Marker: A marker is placed at a set of coordinates on the map. The query result must return latitude and longitude pairs. For an example, see marker example.
Choropleth options
This section covers the options for choropleth visualizations.
General
To configure general options, click General and configure each of the following required settings:
-
Map: Which geographic map to use. One of Countries, USA, or Japan/Prefectures. The results in the key column must appear in the map you choose.
-
Geographic column: The column containing the locations for the map.
-
Geographic type: The format of values in the key column. One of Abbreviated name, Short name, Full name, ISO code (2 letters), ISO code (3 letters), ISO code (3 digits):
Format Value Abbreviated name U.S.A, Brazil Short name United States, Brazil Full name United States, Brazil ISO code (2 letters) US, BR ISO code (3 letters) USA, BRA ISO code (numeric) 840, 076 If a geographic column value doesn’t match one of the target field formats, no data is shown for that locality.
For more information on supported map values and their corresponding abbreviated values, see Supported map values.
-
Value Column: Aggregates the result per key column.
Colors
- Clustering mode: How data is segmented into steps along the color gradient.
- Equidistant (default): Results are segmented into the number of segments you specify in the Steps field, and each segment’s range is the same size.
- Quantile: Results are segmented into a number of segments less than or equal to the value you specify in the Steps field, where each segment contains the same number of results, regardless of the segment’s numeric range.
- K-mean: Results are segmented into the number of segments you specify in the Steps field, and the results in each segment are clustered near a common mean.
- Steps: The number of colors to use inclusive of Min Color and Max Color in the map and the legend. If Clustering Mode is Quantile, there may be fewer steps than you specify here.
- Min Color: The color for the lowest value range.
- Max Color: The color for the highest value range.
- No Value Color: The color for locations with no result in the query. Often, this color is outside of the gradient range between Min Color and Max Color.
- Background Color: The color for the map background.
- Border Color: The color for borders between locations.
Format
- Value format: Optionally override the automatically detected format for the value column.
- Value placeholder: An optional value to display for locations with no results. Defaults to N/A.
- Show legend: Uncheck to disable the legend.
- Legend position: Where in the visualization to display the legend.
- Legend text alignment: How to align text in the legend.
- Show tooltip: Whether to display a tooltip when you hover your cursor over a location.
- Tooltip template: An optional value to override the template used for tooltips.
- Show popup: Whether to display a popup when you click a location.
- Popup template: An optional value to override the template used for popups.
Bounds
You can configure coordinates for the four corners of the area to show only a portion of the map. Set the coordinates manually, zoom in or out, or use the rectangular selector.
Marker options
This section covers marker visualization options.
General
- Latitude column: Latitude portion of the coordinate pair.
- Longitude column: Longitude portion of the coordinate pair.
- Group by The column to use for grouping, if different from the original query.
Format
- Show tooltip: If selected, a tooltip displays when you hover the mouse over a marker in the visualization.
- Tooltip template: Override the default tooltip template using a format you specify.
- Show popup: If selected, a popup displays when you click a marker in the visualization.
- Popup template: Override the default popup template using a format you specify.
Style
- Map tiles: Override the default map tiles with one of the included sets.
- Cluster markers: If selected, markers that are close to each other are clustered into a single marker that indicates the number of markers in the cluster.
- Override default style: If selected, you can override the marker shape, icon, color, background color, and border color.
To hide a series in a visualization, click the series in the legend. To show the series again, click it again in the legend.
To show only a single series, double-click the series in the legend. To show other series, click each one.
Supported map values
The following table lists supported map values and their corresponding abbreviated values.
| Abbreviated name | Short name | Full name | ISO code (2 letters) | ISO code (3 letters) | ISO code (numeric) |
|---|---|---|---|---|---|
| Belize | Belize | Belize | BZ | BLZ | 84 |
| Can. | Canada | Canada | CA | CAN | 124 |
| Bhs. | Bahamas | Bahamas | BS | BHS | 44 |
| C.R. | Costa Rica | Costa Rica | CR | CRI | 188 |
| Grlnd. | Greenland | Greenland | GL | GRL | 304 |
| Dom. Rep. | Dominican Rep. | Dominican Republic | DO | DOM | 214 |
| Cuba | Cuba | Cuba | CU | CUB | 192 |
| Hond. | Honduras | Honduras | HN | HND | 340 |
| Guat. | Guatemala | Guatemala | GT | GTM | 320 |
| Haiti | Haiti | Haiti | HT | HTI | 332 |
| Mex. | Mexico | Mexico | MX | MEX | 484 |
| Jam. | Jamaica | Jamaica | JM | JAM | 388 |
| P.R. | Puerto Rico | Puerto Rico | PR | PRI | 630 |
| Pan. | Panama | Panama | PA | PAN | 591 |
| Nic. | Nicaragua | Nicaragua | NI | NIC | 558 |
| El. S. | El Salvador | El Salvador | SV | SLV | 222 |
| Tr.T. | Trinidad and Tobago | Trinidad and Tobago | TT | TTO | 780 |
| U.S.A. | United States | United States | US | USA | 840 |
| Arg. | Argentina | Argentina | AR | ARG | 32 |
| Bolivia | Bolivia | Bolivia | BO | BOL | 68 |
| Brazil | Brazil | Brazil | BR | BRA | 76 |
| Chile | Chile | Chile | CL | CHL | 152 |
| Col. | Colombia | Colombia | CO | COL | 170 |
| Ecu. | Ecuador | Ecuador | EC | ECU | 218 |
| Flk. Is. | Falkland Is. | Falkland Islands | FK | FLK | 238 |
| Guy. | Guyana | Guyana | GY | GUY | 328 |
| Para. | Paraguay | Paraguay | PY | PRY | 600 |
| Sur. | Suriname | Suriname | SR | SUR | 740 |
| Ury. | Uruguay | Uruguay | UY | URY | 858 |
| Peru | Peru | Peru | PE | PER | 604 |
| Ven. | Venezuela | Venezuela | VE | VEN | 862 |
| Afg. | Afghanistan | Afghanistan | AF | AFG | 4 |
| U.A.E. | United Arab Emirates | United Arab Emirates | AE | ARE | 784 |
| Arm. | Armenia | Armenia | AM | ARM | 51 |
| Aze. | Azerbaijan | Azerbaijan | AZ | AZE | 31 |
| Brunei | Brunei | Brunei Darussalam | BN | BRN | 96 |
| Bang. | Bangladesh | Bangladesh | BD | BGD | 50 |
| China | China | China | CN | CHN | 156 |
| Bhutan | Bhutan | Bhutan | BT | BTN | 64 |
| N. Cy. | N. Cyprus | Northern Cyprus | |||
| Cyp. | Cyprus | Cyprus | CY | CYP | 196 |
| Geo. | Georgia | Georgia | GE | GEO | 268 |
| Indo. | Indonesia | Indonesia | ID | IDN | 360 |
| India | India | India | IN | IND | 356 |
| Iran | Iran | Iran | IR | IRN | 364 |
| Jord. | Jordan | Jordan | JO | JOR | 400 |
| Isr. | Israel | Israel | IL | ISR | 376 |
| Japan | Japan | Japan | JP | JPN | 392 |
| Iraq | Iraq | Iraq | IQ | IRQ | 368 |
| Kaz. | Kazakhstan | Kazakhstan | KZ | KAZ | 398 |
| Kgz. | Kyrgyzstan | Kyrgyzstan | KG | KGZ | 417 |
| S.K. | Korea | Republic of Korea | KR | KOR | 410 |
| Camb. | Cambodia | Cambodia | KH | KHM | 116 |
| Kwt. | Kuwait | Kuwait | KW | KWT | 414 |
| Laos | Lao PDR | Lao PDR | LA | LAO | 418 |
| Leb. | Lebanon | Lebanon | LB | LBN | 422 |
| Sri L. | Sri Lanka | Sri Lanka | LK | LKA | 144 |
| Myan. | Myanmar | Myanmar | MM | MMR | 104 |
| Mong. | Mongolia | Mongolia | MN | MNG | 496 |
| Malay. | Malaysia | Malaysia | MY | MYS | 458 |
| Nepal | Nepal | Nepal | NP | NPL | 524 |
| Oman | Oman | Oman | OM | OMN | 512 |
| Pak. | Pakistan | Pakistan | PK | PAK | 586 |
| Phil. | Philippines | Philippines | PH | PHL | 608 |
| N.K. | Dem. Rep. Korea | Dem. Rep. Korea | KP | PRK | 408 |
| Pal. | Palestine | Palestine | PS | PSE | 275 |
| Qatar | Qatar | Qatar | QA | QAT | 634 |
| Syria | Syria | Syria | SY | SYR | 760 |
| Saud. | Saudi Arabia | Saudi Arabia | SA | SAU | 682 |
| Thai. | Thailand | Thailand | TH | THA | 764 |
| Tjk. | Tajikistan | Tajikistan | TJ | TJK | 762 |
| Turkm. | Turkmenistan | Turkmenistan | TM | TKM | 795 |
| T.L. | Timor-Leste | Timor-Leste | TL | TLS | 626 |
| Tur. | Turkey | Turkey | TR | TUR | 792 |
| Taiwan | Taiwan | Taiwan | TW | TWN | 158 |
| Viet. | Vietnam | Vietnam | VN | VNM | 704 |
| Uzb. | Uzbekistan | Uzbekistan | UZ | UZB | 860 |
| Yem. | Yemen | Yemen | YE | YEM | 887 |
| Ang. | Angola | Angola | AO | AGO | 24 |
| Bur. | Burundi | Burundi | BI | BDI | 108 |
| B.F. | Burkina Faso | Burkina Faso | BF | BFA | 854 |
| Bwa. | Botswana | Botswana | BW | BWA | 72 |
| Benin | Benin | Benin | BJ | BEN | 204 |
| C.A.R. | Central African Rep. | Central African Republic | CF | CAF | 140 |
| I.C. | Côte d’Ivoire | Côte d’Ivoire | CI | CIV | 384 |
| Cam. | Cameroon | Cameroon | CM | CMR | 120 |
| D.R.C. | Dem. Rep. Congo | Democratic Republic of the Congo | CD | COD | 180 |
| Rep. Congo | Congo | Republic of Congo | CG | COG | 178 |
| Dji. | Djibouti | Djibouti | DJ | DJI | 262 |
| Alg. | Algeria | Algeria | DZ | DZA | 12 |
| Egypt | Egypt | Egypt | EG | EGY | 818 |
| Gabon | Gabon | Gabon | GA | GAB | 266 |
| Erit. | Eritrea | Eritrea | ER | ERI | 232 |
| Eth. | Ethiopia | Ethiopia | ET | ETH | 231 |
| Ghana | Ghana | Ghana | GH | GHA | 288 |
| Gin. | Guinea | Guinea | GN | GIN | 324 |
| Gambia | Gambia | The Gambia | GM | GMB | 270 |
| GnB. | Guinea-Bissau | Guinea-Bissau | GW | GNB | 624 |
| Ken. | Kenya | Kenya | KE | KEN | 404 |
| Eq. G. | Eq. Guinea | Equatorial Guinea | GQ | GNQ | 226 |
| Liberia | Liberia | Liberia | LR | LBR | 430 |
| Libya | Libya | Libya | LY | LBY | 434 |
| Mor. | Morocco | Morocco | MA | MAR | 504 |
| Les. | Lesotho | Lesotho | LS | LSO | 426 |
| Mad. | Madagascar | Madagascar | MG | MDG | 450 |
| Mali | Mali | Mali | ML | MLI | 466 |
| Moz. | Mozambique | Mozambique | MZ | MOZ | 508 |
| Nam. | Namibia | Namibia | NA | NAM | 516 |
| Niger | Niger | Niger | NE | NER | 562 |
| Mal. | Malawi | Malawi | MW | MWI | 454 |
| Mrt. | Mauritania | Mauritania | MR | MRT | 478 |
| Nigeria | Nigeria | Nigeria | NG | NGA | 566 |
| Rwa. | Rwanda | Rwanda | RW | RWA | 646 |
| W. Sah. | W. Sahara | Western Sahara | EH | ESH | 732 |
| S. Sud. | S. Sudan | South Sudan | SS | SSD | 728 |
| S.L. | Sierra Leone | Sierra Leone | SL | SLE | 694 |
| Sen. | Senegal | Senegal | SN | SEN | 686 |
| Solnd. | Somaliland | Somaliland | |||
| Sudan | Sudan | Sudan | SD | SDN | 729 |
| Som. | Somalia | Somalia | SO | SOM | 706 |
| Swz. | Swaziland | Swaziland | SZ | SWZ | 748 |
| Chad | Chad | Chad | TD | TCD | 148 |
| Togo | Togo | Togo | TG | TGO | 768 |
| Tun. | Tunisia | Tunisia | TN | TUN | 788 |
| Tanz. | Tanzania | Tanzania | TZ | TZA | 834 |
| Uga. | Uganda | Uganda | UG | UGA | 800 |
| S.Af. | South Africa | South Africa | ZA | ZAF | 710 |
| Zambia | Zambia | Zambia | ZM | ZMB | 894 |
| Zimb. | Zimbabwe | Zimbabwe | ZW | ZWE | 716 |
| Alb. | Albania | Albania | AL | ALB | 8 |
| Aust. | Austria | Austria | AT | AUT | 40 |
| Belg. | Belgium | Belgium | BE | BEL | 56 |
| Bulg. | Bulgaria | Bulgaria | BG | BGR | 100 |
| Bela. | Belarus | Belarus | BY | BLR | 112 |
| Switz. | Switzerland | Switzerland | CH | CHE | 756 |
| B.H. | Bosnia and Herz. | Bosnia and Herzegovina | BA | BIH | 70 |
| Cz. Rep. | Czech Rep. | Czech Republic | CZ | CZE | 203 |
| Ger. | Germany | Germany | DE | DEU | 276 |
| Den. | Denmark | Denmark | DK | DNK | 208 |
| Sp. | Spain | Spain | ES | ESP | 724 |
| Est. | Estonia | Estonia | EE | EST | 233 |
| Fin. | Finland | Finland | FI | FIN | 246 |
| Fr. | France | France | FR | FRA | 250 |
| U.K. | United Kingdom | United Kingdom | GB | GBR | 826 |
| Cro. | Croatia | Croatia | HR | HRV | 191 |
| Ire. | Ireland | Ireland | IE | IRL | 372 |
| Greece | Greece | Greece | GR | GRC | 300 |
| Iceland | Iceland | Iceland | IS | ISL | 352 |
| Hun. | Hungary | Hungary | HU | HUN | 348 |
| Italy | Italy | Italy | IT | ITA | 380 |
| Kos. | Kosovo | Kosovo | |||
| Lith. | Lithuania | Lithuania | LT | LTU | 440 |
| Lat. | Latvia | Latvia | LV | LVA | 428 |
| Lux. | Luxembourg | Luxembourg | LU | LUX | 442 |
| Mkd. | North Macedonia | the Republic of North Macedonia | MK | MKD | 807 |
| Mda. | Moldova | Moldova | MD | MDA | 498 |
| Mont. | Montenegro | Montenegro | ME | MNE | 499 |
| Nor. | Norway | Norway | NO | NOR | 578 |
| Neth. | Netherlands | Netherlands | NL | NLD | 528 |
| Pol. | Poland | Poland | PL | POL | 616 |
| Port. | Portugal | Portugal | PT | PRT | 620 |
| Rom. | Romania | Romania | RO | ROU | 642 |
| Rus. | Russia | Russian Federation | RU | RUS | 643 |
| Serb. | Serbia | Serbia | RS | SRB | 688 |
| Slo. | Slovenia | Slovenia | SI | SVN | 705 |
| Svk. | Slovakia | Slovakia | SK | SVK | 703 |
| Ukr. | Ukraine | Ukraine | UA | UKR | 804 |
| Swe. | Sweden | Sweden | SE | SWE | 752 |
| Auz. | Australia | Australia | AU | AUS | 36 |
| Fiji | Fiji | Fiji | FJ | FJI | 242 |
| New C. | New Caledonia | New Caledonia | NC | NCL | 540 |
| N.Z. | New Zealand | New Zealand | NZ | NZL | 554 |
| P.N.G. | Papua New Guinea | Papua New Guinea | PG | PNG | 598 |
| S. Is. | Solomon Is. | Solomon Islands | SB | SLB | 90 |
| Van. | Vanuatu | Vanuatu | VU | VUT | 548 |