Getting your data on the map


Geometries are geometric properties in data that allow data to be visualized on a map. Akuko provides a number of different ways to generate geometries from a data source so it can be visualized. Geometries can be represented as points (circles), lines and polygons.

Adding a Geometry

Go to the Geometries tab in your data source and click Add Geometry. You will be given two options to create a geometry. Latitude / Longitude or Join.

Latitude / Longitude

One of the most common way to represent the locations of places is with GPS coordinates latitude and longitude. The use of GPS coordinates is convenient as latitude and longitude can be represented in a text format and included in tabular data.
At add a geometry using GPS points, ensure the data you have uploaded has at least one set of latitude and longitude columns in it.
First, give your geometry a name. Pick a name that is descriptive enough in case your data source has multiple geometries. Then select the Latitude / Longitude type and pick the fields that correspond go the latitude and longitude column.
X and Y Coordinates
Many times your GPS data will come in X and Y format. In this case, it is helpful to think of a chart with an X and Y axis where Y is North/South and X is East/West. A GPS point with a higher Y value will be farther north on your map than a point with a lower Y value. Or in simple terms:
  • Latitude - Y
  • Longitude - X

Adding properties to a geometry

In Akuko, want to make your maps as fast and bandwidth efficient as possible. To do this requires helping optimize the amount of data your data source's geometry sends to the map. To determine which data will be available to visualize in the map, select the properties from the data source you want and add them as properties. You can come back and add new properties at any time so try an avoid adding any properties not needed for your visualizations. This will keep your maps loading fast and will make the process of selecting properties when building map layers a lot easier.
Note: Since the latitude and longitude is included in the geometry you do not need to include them again in your properties unless you want to say display the GPS coordinates in a pop-up.
When you are ready click Create.
After a few seconds, your geometry should update and you should see a unique ID and green check mark indicating your geometry was successfully created. If your data has changed or you would which to add a new property you will need to click Update to update your geometry. Note: This needs to be done manually now but options to automate will be provided in the future.
Once this is complete you can now create a map, add a map layer from this data source and visualize it.

Geojson Data Sources

If you upload a geojson file to create a data source, Akuko will automatically extract the geospatial properties and create a geometry with name GeoJSON which you can rename at any point. Uploaded data in geojson can correspond to points, lines or polygons. As an added bonus, Akuko also automatically extracts all the non-spatial attributes and makes it them available as regular measures and dimensions to be visualized in tables, maps, charts, etc.


When visualizing data in maps, one of the most common things you will want to visualize a dimension or measure from your tabular data to corresponding locations on a map. For example, you may want to visualize happiness by country as rated by the World Happiness Report.
Akuko makes this easy to do by providing support to allow you to join data from one data source to the geometry of another data source. To join data, select the data source that contains data you want to visualize. Go to the geometries click add geometry and select the Join type. Enter in a name for your geometry and then select the GeoJSON/geometry from any other data source in your account. Then select the name of the field in your data you want to join against the target (geometry). In the example below, the country_or_region field from the World Happiness Report dataset is being joined against the admin field from the Natural Earth country admin boundary file.
Similar to create a geometry with GPS coordinates, select the properties you want from the data source and click generate.
Once generated, the data source can now be added to a map and used to visualize happiness by country.
Currently, you can only add data properties from the data source and not data source with the geometry you are joining against. This will be addressed in the near future when Akuko supports data source joins.

Advanced Options: Time Series and Group by Support

There will be cases when you will want to visualize your data in a time series or with a group by period. In this example, there is a row per county for each day of estimates cases.
Estimated Covid-19 cases in Chittenden County by date
To be able to visualize this data as a time series in the map, you need to use the group by feature available in Advanced options in the geometry management component.
Pick the value you want to group by in this case date and the values you want to visualize in the time series estimated_cases. The group by feature can be applied to any other use case where you have multiple rows of data for the object you want to visualize against.
Last modified 9mo ago