In this tutorial, you will learn how you can upload your own time series data into the xyzt.ai platform so that you can start analyzing it.

The platform supports multiple types of data sets.

This tutorial covers uploading time series data, which is data obtained by measuring at fixed locations how a value changes over time. For example a data set containing temperature measurements at fixed locations, or historical census data for all countries.

Time-series data consists out of 2 parts:

  • One or more GeoJSON files (.geojson) defining the geometry and location of the areas/shapes for which measurements are taken. Next to the geometry, the GeoJSON file also defines an identifier for each area or shape, and optionally additional properties about that shape.

  • One or more CSV files (.csv) with the measurement data. Each row in the CSV files contains an id to specify to which area or shape the measurement belongs, as well as a timestamp and the actual measurement(s).

Figure 1. Illustration of the relation between the .geojson and .csv files in a time-series data set

Uploading time series data files is a multi-step process:

  1. You need to tell the platform which property in the GeoJSON file(s) defines the id of the shape

  2. In case the GeoJSON file contains additional properties, you need to tell the platform which ones you are interested in.

  3. You need to tell the platform how your .csv files are structured, and which columns contain the data you are interested in, as well as which column contains the area id.

  4. Once the platform has that information, you can start uploading the .geojson and .csv files and the platform will process them.

This tutorial will guide you through these steps using a set of example .geojson and .csv files, so you can follow along even if you don’t possess any location data yet.

Free trial accounts don’t support uploading your own data

This tutorial uses functionality that is not included in the free trial version of the platform.

Get in touch if you want to start uploading your own data.

Next part

Go to the next part: Step 0: Obtain data