stichting-crow/dd-zone-stats-aggregator

Counts the number of vehicles in every custom made zone.

README

dd-zone-stats-aggregator is an application that counts the number of vehicles in every zone.

How to deploy?

Build api with:

1. docker build -t ghcr.io/stichting-crow/dd-zone-stats-aggregator:<version_number> ..

2. docker push ghcr.io/stichting-crow/dd-zone-stats-aggregator:<version_number> (make sure you are logged in to gitlab registry)

ssh tunnels

ssh -L 5433:10.133.75.95:5432 [email protected]
ssh -L 5434:10.133.137.239:5432 timescaledb

dd-zone-stats-aggregator's Issues

Store aggregated zone stats in a hypertable

We want to make it possible to do data analysis on zone level.

To make this possible, we have to create a table with aggregated zone stats.

To make querying the table fast, we make it a TimescaleDB Hypertable.

Hypertables are PostgreSQL tables with special features that make it easy to handle time-series data. Anything you can do with regular PostgreSQL tables, you can do with hypertables. In addition, you get the benefits of improved performance and user experience for time-series data.

This issue can be closed if the following is done:

• We have a database table having aggregated zone stats