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

  1. Cy.

  1. 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

  1. Sah.

  1. Sahara

Western Sahara

EH

ESH

732

  1. Sud.

  1. 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

  1. Is.

Solomon Is.

Solomon Islands

SB

SLB

90

Van.

Vanuatu

Vanuatu

VU

VUT

548