Time series Data in Postgres Postgis

738 views Asked by At

I have a time series data that I want to store in a Postgresql-PostGIS db.

the data structure is like this

ID t_1  t_2   t_3,  ... t_n
1  33.4 444.4 555.4 ... 644.5
2  36.4 344.4 255.4 ... 744.5
3  45.4 845.4 455.4 ... 844.5
4  66.4 784.4 655.4 ... 344.5
5  44.4 644.4 755.4 ... 544.5

I have multiple rows that expres a building ID and multiple columns for the time stamp. I need to store this data in DB in order to elaborate them and provide the values trough a WFS service in a web-gis.

Which is the most efficent way to do so?

0

There are 0 answers