There are two ways of visualizing data in the map:
Using geospatial coordinates - latitude and longitude
Linking the data to a polygon, (usually an administrative unit) using an id of that polygon
Let's have a look at an example. We have a table with a number of orders. Each order has an id and an amount.
The order has been placed on a certain location on Earth. By adding a latitude and longitude of that location, we can visualize the orders in a map.
The order has also happened in some administrative unit of a state, e.g. a district. These districts have ids, by adding the id column to our orders table, and specifying the foreignKey attribute of the district_id property, we can visualize the orders in a map.
Please note that the districts have their polygon geometries also stored somewhere. This can be a separate table which is linked, to the district table.
How to determine the geographical coordinates or the administrative unit ids?
If your data does not contain latitude and longitude or administrative unit ids, they have to be geocoded. To do that, you need at least an address. The process is following:
1) Geocode the address to determine its latitude and longitude (using an external service, like OpenCage Geocoder)
Please note that the heatmap's primary use is for visualization of a larger number of aggregated points.
What specification do point datasets must meet?
Datasets which contain points must have 2 columns named exactly "lat" and "lng" which contain the latitude and longitude.
How are areas represented in CleverMaps?
In CleverMaps, areas are represented by polygons. Unlike traditional geographic information systems, they are not represented directly by GeoJSON, or Shapefile. We use vector tiles served by an online service (Mapbox).
The polygon layer is represented by a vector tile dataset, and a dwh dataset of geometryPolygon type.
Can I upload my own polygons?
You can use our CleverMaps MapboxUtils utility to convert your geospatial data to Mapbox Vector Tiles and upload them to Mapbox.
If you have your geometries, but you don't want to prepare your own vector tiles, we can do it for you. Contact us at firstname.lastname@example.org.
Can I change the color of polygons?
There is a number of scales, which you can set your indicator to. Please note that this setting is indicator specific - you have to set the coloring of each indicator separately.
Custom polygon coloring is not available.
Can I change the color of dots?
There is a number of scales, which you can set your indicator to, just like polygons.
How do I use the heatmap visualization?
A heatmap is a visualisation of a number of points. Your data have to be represented by a geometryPoint dwh dataset. Then you have to enable the heatmap visualisation, in a visualizations attribute of a respective indicator.
How do I use the polygon visualization?
All geometryPolygondwh datasets are visualised as polygons. This option does not have to be explicitly enabled in an indicator.
How do I use the point visualization?
All geometryPointdwh datasets are visualised as points. This option does not have to be explicitly enabled in an indicator.
Filters are defined in the view object. You can specify various kinds of filters in its content.filterGroup object.
What data file types do you support?
We support only CSV files.
I have a specific CSV with custom separators, how can I upload it?
You can specify custom CSV settings in the respective parameters of loadCsv command.
I've just uploaded the data, why aren't they visible in the application?
CleverMaps is different than traditional geographic information systems. After you create a dataset and upload the data, you will still need to define how to visualize them, and define what metrics you will perform on the data. To be exact: you have to create a metric, an indicator, corresponding indicator drill, a dashboard and a view. This is covered in the first tutorial.
Can CleverMaps determine the data types of my tables?
Yes, using the createMetadata command and generating a dataset from a csv file.
You can find the list of avaialable data types here.
Where are my project dumps stored?
By default, the dump directories for each project are created in the directory from which you run the Shell .jar file.
However, you can specify your own directory in the config file.