meteorology-eurac: Should we combine monthly and daily stations, or just take one of them?

[Piiit]

Eurac provides API links for monthly station data and also daily station data. Do I need to sync both of them or just daily station data is enough?

We need to find out if the data is really different, if we need to take both, and or merge them accordingly.

@SaimonasFOS Could you please elaborate on this issue a bit? Which calls are used exactly and what is the difference of response?

Do we have any documentation? website or document?

[Piiit]

@sseppi @rcavaliere FYI

[rcavaliere]

@Piiit we need some data sample to take a decision. Can you get this from the API and share it with us?

[Piiit]

@rcavaliere I do not have any documentation yet, so lets wait for that to proceed...

@sseppi @SaimonasFOS Who could provide some documentation?

[sseppi]

Hi all, here a share the link to the documentation that sent me Eurac https://postgrest.org/en/stable/ Shall we ask them for more infromation/documentation abouth their data?

[Piiit]

OK, the endpoint is this: https://edp-portal.eurac.edu/envdb

So the swagger could be seen like this: https://swagger.opendatahub.bz.it/?url=https://edp-portal.eurac.edu/envdb/

[Piiit]

Example that shows all stations inside climatologies:

https://edp-portal.eurac.edu/envdb/climatologies?select=station

Unfortunately postgrest does not support duplicate elimination or grouping, so we would need to ask to have a special view or function for that inside the Eurac DB or eliminate duplicates on our side

[Piiit]

Some more information:

• DB description
• DB tables and access
• Data policy

[Piiit]

WRONG ISSUE, see https://github.com/noi-techpark/bdp-commons/issues/548 instead

First analysis done: I wanted to know if stati..........

[Piiit]

WRONG ISSUE, see https://github.com/noi-techpark/bdp-commons/issues/548 instead

The whole list of stations inside climatologies is this:

Ala: Found
....

[SaimonasFOS]

@Piiit @rcavaliere To elaborate, I was asking this question because I thought that having monthly data could be redundant since we have daily data. You can see the example of this data here: https://edp-portal.eurac.edu/envdb/climatologies But looking at it again, it's not really "monthly" data, but rather climatology (averages from all years in every month). So I assume this is not redundant and could be needed. But if we save this data as measurements, how would timestamps look like? There is no association with any date or time. Some advice is needed from you.

[rcavaliere]

@SaimonasFOS you are perfectly right. We will come up with you with a specification document in which we are going to make a proposal on how the data integration will need to take place