Products & Modules

Durable, robust, high-performance – and combinable

Each component carries out a clearly defined task and runs in the browser or as a Linux-service. Together they form an end-to-end architecture from raw reading to report – individually they also complement existing system environments.

Data Storage

The data core

The foundation of every toposoft solution: the time series database at the centre, flanked by the master data and geo databases.

Centre

TopoDB

Time series database

High-performance storage of time-related mass data – hundreds of thousands of readings per second
Fine-grained attribution: origin, unit, measuring method and more per time series
Raw data is retained permanently, editing levels in parallel
Faster than InfluxDB in our benchmarks, on par with QuestDB
Flanked by a master data database (stations etc.) and a geo database (maps & layers)

TopoRast & grid data

Grid time series database

Managing and analysing radar data and other grids
Derive time series directly from areal precipitation
Multi-parameter grids (e.g. ensemble data)

Screenshot: radar data analysis with TopoRast

Access

Open to your tools

SQL, JSON, Line Protocol or browser – you decide how to access your data.

New

TopoFlix

The flexible interface: SQL · JSON · Line Protocol

SQL queries across the time series, master data and geo databases
JSON/Line Protocol for data ingestion from your own systems
Command-line interface for scripting and automation
Connect your own applications, Python and other scripts without proprietary clients or APIs

Example: finding time series

SELECT tsid,location,channel FROM ser_catalog WHERE location="3001005"

+--------------------------------+----------+-------------+
| TSID                           | LOCATION | CHANNEL     |
+--------------------------------+----------+-------------+
| ser_tvrb7d6hoyx6yhtorng372jfkq | 3001005  | discharge   |
| ser_f6stmzqzc6ouwl7n5mlg4v7ffe | 3001005  | water level |
+--------------------------------+----------+-------------+

Same call via REST – result as JSON, ASCII or HTML table

wget -qO- 'http://host:8090/api_tbl/token/SELECT … FROM ser_catalog …'

More examples in the FAQ →

New

TopoCast

Web server for browser applications

Run current and future toposoft applications in the browser
No software rollout to individual workstations
Works with all databases of the architecture
In development: TopoWeb, our application construction kit for the browser
See it live: TopoDesk demo at topodesk.de

Scripting language

Azur

Flexible customisation on the customer side

Optimised scripting/programming language for time series, master data, geo data and grids
Implement your own analyses, customisations and extensions yourself – no vendor dependency
Large set of built-in functions, extends every module with your own logic

Data Logistics

Automated inflow, validated, automated outflow

Services that run around the clock: acquisition, quality assurance and distribution of your measurement data – no manual work.

Inflow

TopoRello

Retrieving measurement data (import)

Scheduled retrieval from (S)FTP and HTTP(S) servers, process control systems, modems, TCP/IP
Automatic, configurable data validation
Scales from 1 to 100,000+ retrievals per day, parallel processes
Mail alerts on threshold violations, error logs per station
Continuously extended with new retrieval techniques and formats since 2000

Outflow

Pulsaro

Distributing measurement data (export)

Automated exports of time series and standard reports
Formats such as Delft-PI, UVF, NearRealTime; delivery via mail, (S)FTP, file folders
Optional prior conversion (e.g. 1-minute sums) and compression

Screenshot: Pulsaro export target configuration

Proven Applications

Measurement data management with a graphical interface

Complete working environments for daily data maintenance, validation and analysis – proven for decades in water management and hydrography, on the same data core.

TopoDesk

Modular measurement data management system

Managing and visualising time series, stations, boreholes, pumps and land parcels
Interactive map, statistics, calculations, reports
Multi-user operation with role-based access rights