Visualize your data on a map

Maps are useful for quickly analyzing data spread over geographical areas. Luzmo features the following map types:

Geography data

When clicking on the data icon of the map, the different slots to add data to appear. One of them is the geography slot. Two types of data can be added here - coordinates or topography data.

You can find available datasets if you navigate to the public Luzmo library. For the countries of the world, you could use the "World Countries" public dataset which exposes both a Topography of the country, and the Coordinates of the capital of each country. In case you need a map on a certain European level, try to search for the datasets with the word ‘NUTS’. You can find all available datasets when toggling to "Public" on the Datasets page in Luzmo.

Coordinates

Coordinates display different points on the map. Marker, Hexbin, Heat, Route and Spike maps can use coordinate data

If you have the latitude and longitude in your dataset, you can change the datatype to Coordinates or you can make a derived column with coordinates using the 'spatial' formula. Learn how to do that by clicking here .

Afterwards, you can drag & drop this coordinates column to the Geography slot and a map will appear. Check out the video tutorial below!

Topography

Topography is used to display different areas on a map. Chloropleth maps require topography data. Marker, Hexbin, Heat, Route and Spike maps can use topography data - the geographic center of the topographic region will be used as coordinates for these map types.

You can use one of the datasets the Luzmo platform provides or you can add your own topography data.

If you use PostGIS (PostgreSQL's GIS extension, for geometry type) or SQL Server (for geometry/geography types) you can connect your datasets with topography data via our native connectors.

Alternatively, you can create and upload your own topography dataset by uploading a .geojson or .topojson file (Take a look at this Academy article for more info about how to upload data). A convenient tool for creating .topojson or .geojson files is geojson.io. Keep in mind that uploading geojson and topojson files is only possible through a manual local upload, not via the API or a data connection.

The final step is to connect your topography data with your dataset, which contains the actual information you want to display to do so you need to link your dataset to the topography dataset containing your measure data. This needs to be done to make sure you can add the data from your dataset to the map (e.g. as measure). A useful guide on linking is available here.

Once your topography is linked and ready, simply drag and drop the Topography column into the Geography slot. Your map will appear, ready to be used. Check out the video tutorial below!

Measure

After adding your geography data, and linking it to your measure dataset if needed, add your measure column to the Measure slot. The numbers will appear immediately on the map.

Topography label

For each dataset which contains geography data, whether that are coordinates or topography data, you can configure one column as the "topography label". You can do this by clicking on the settings (gear) icon next to the column when looking at the dataset in the databoard. Here you can select that that column should serve as the topography label. Now, whenever you have geographical data displayed in a map, the value of the column you indicated as topography label will be available in the tooltip.

Check out the video tutorial below!

Video tutorial

This video tutorial shows you how to:

1. Build a choropleth map with topography data using a dataset available in Luzmo
2. Configure a coordinates column from a latitude and longitude column available in your dataset
3. Build a symbol map based on the coordinates column created in step 2
4. Set up a topography label for the dataset and map of step 2 & 3