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.
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.
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.
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.
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.
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.
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.