Home Intro Tutorials Articles Rest API Contact
Sign in Demo

Available parts

In this part you will learn how to create a new data set that directly connects to a PostgreSQL database.

Step 1.1: Open the Dataset Creation Dialog

  • In the platform, go to Data sets

  • Click + CREATE NEW DATA SET

  • Choose CREATE FROM DATABASE

Step 1.2: Fill in Dataset Details

  • Enter a Name for your dataset.

  • Select Time Series Data as the type.

  • Optionally, provide a Description and specify what the shapes in your data represent (assets) (e.g., neighborhoods, sensors, devices,…​.).

Step 1.3: Configure the Database Connection

  • Choose PostgreSQL (PostGIS) as the source type.

  • Fill in the following fields:

  • URL, e.g., jdbc:postgresql://hostname:port/database

  • User, your database username

  • Password, your database password

  • Geometry Table, the name of the table containing spatial features

  • Time Series Table, the name of the table with time-stamped values

Additional constraints on the tables

  • Ensure that the geometry table includes a primary key column that uniquely identifies each spatial feature and a geometry column using a PostGIS-supported geometry type.

  • The time series table must include a time column with time zone information and a foreign key column that references the primary key of the geometry table to associate each measurement with a spatial feature.

Step 1.4: Validate the Connection

After filling in the connection details, the platform will automatically test the database connectivity.

If the connection is successful, you’ll see a blue confirmation, otherwise it turns red and provides info on why the connection failed.

Step 1.5: Create the Dataset

  • Click CREATE DATA SET.

  • Once created, you’ll be directed to the second step, which allows you to further configure the geometry and time series properties.

Next part

Go to the next part: Configuring which table columns to expose