Creating semantic models for GIS maps

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos supports Geographic Information System (GIS) maps, also known as GIS bubbles or GIS heat maps, by providing geographic data that you can link to create semantic models. This allows you to visualize information using maps or location data to reveal patterns and relationships. For example, you can integrate geographic data with your sales data so that you can see sales performance mapped using GIS bubble or GIS heat map charts.

You can use location data with tools from Google or from an open source. See GIS data to learn more about supported open-source tools.

Dimension

To design a GIS map, you need to set the Dimension in the semantic models to Location Type and then map the Role for each GIS level, in the Kyvos UI. The selected role is mapped to the respective CSV file containing GIS coordinates, such as latitude and longitude, for the respective level.

Kyvos maintains a separate CSV file for each role, which includes:

Continent
Country
Province
State
County
City
Postal Code

To generate a GIS map using Kyvos, you need to provide a valid location, which can be a country name or a 2-3 letter ISO code. The CSV lookup file used for mapping the data in the cube contains multiple codes for each country. For instance, if you provide 'USA' as the location, the file will contain three codes: United States, USA, and US. Any of these three codes processed within the semantic model will be considered a valid location, and Kyvos will plot a GIS map accordingly.

Note

When creating a GIS map in Kyvos, you must specify the correct role for the field. If you forget to select a role or choose the blank option, Kyvos will map the data at the field level based on the field name and plot the map. However, if you provide an invalid value that cannot be mapped, the GIS map will not be generated, and an error message will be displayed. This error message will list all the values that cannot be plotted due to the undefined role.
The supported data type for plotting a GIS map in Kyvos is a Character type. Therefore, it is essential to ensure that the field selected for the role is of character type.
Kyvos recommends that you use the same names as those given in the source data and then build the semantic model.
Geographical levels are defined by the hierarchy you define for the Location type dimension.
The CSV files are located at kyvos/olapengine/data/Reference/GIS

Types of Visualizations for GIS Map

Once you have set the location dimensions, you can select the appropriate GIS visualization for your data, such as GIS Bubble or GIS Heat Map.

GIS Heat Map: The visualization can be plotted for roles such as Continent, Country, Province, State, and County. In contrast, roles like City and Postal Code contain more granular information, and they are represented as a point or dot on the map.
GIS Bubble Map: The visualization can be plotted on all seven levels listed under Roles. Therefore, when using a GIS Bubble Map, you have the flexibility to visualize your data at any level, providing a more comprehensive and detailed view of your data on the map.

Note

The key distinction between the GIS Bubble Map and the GIS Heat Map in Kyvos lies in their data representation methods.

The GIS Bubble Map represents the data for a particular City and Postal Code level as individual points/dot. On the other hand, the GIS Heat Map represents the data as an area on the map, with the area size determined by the measured value provided in the CSV file for that role.

Related Topics

Working with GIS charts