Estimated reading time: 2 minutes

Certain attribute columns that contain location data can be used to create GeoMaps. ThoughtSpot supports Latitude, Longitude, Zip Code, US States, US Counties, Countries, and select international sub-nation regions.

You can designate a column as Geo by editing the GEO CONFIG column in the table Columns page. You cannot edit the geo configuration column information in the model.xls file.

Guidelines for geographic columns

Columns that can be designated as Geo columns need to contain text (VARCHAR) data unless they contain latitude/longitude data. Latitude and longitude columns can contain numeric data (DOUBLE) or text.

If you are using a column with the data type DOUBLE for latitude and longitude, you will also need to change the following settings for those columns:

  • set Column Type to ATTRIBUTE
  • set Additive to NO
  • set Aggregation Type to NONE

For information these settings, see Set ADDITIVE or AGGREGATION.

How to edit geographic columns

  1. Find the GEO CONFIG for the column that contains the geographical data.
  2. Select the column to display the Specify Geographic Configuration dialog.

  3. Change the value to the appropriate GEO CONFIG, depending on the kind of geo data the column contains.

    If your data includes latitude and/or longitude columns that are stored as a numeric data type (DOUBLE), make these changes for those columns:

    1. Change the Type to ATTRIBUTE.
    2. Change ADDITIVE to NO/FALSE.
  4. Save your changes.

List of geotypes

GeoType Description Type: Example
  • name: United States
  • long name: United States
  • name_sort: United States of America
  • abbreviation: U.S.A.
  • adm0_a3: USA
  • adm0_a3_is: USA
  • adm0_a3_us: USA
  • admin: United States of America
  • brk_a3: USA
  • brk_name: United States
  • formal_en: United States of America
  • iso_a2: US
  • iso_a3: USA
  • iso_n3: 840
COUNTY Counties in the United States
  • santa clara county
  • pike county, ohio
  • pike county, OH
STATE_PROVINCE States in the United States
  • name: California
  • US Postal Service abbreviation: CA
LATITUDE Must be used with LONGITUDE
  • 37.421023
  • 1.282911
LONGITUDE Must be used with LATITUDE
  • −122.142103
  • 103.848865
ZIP_CODE Zip codes and zip codes +4 in the United States
  • po_name: MT MEADOWS AREA
  • ZIP: "00012"
  • zip2: 12
Other Sub-nation Regions Administrative regions found in countries other than the United States
  • bremen
  • normandy
  • west midlands

Model the data for searching