Wells Without Measurements in GGMN Data

[EliVolsch]

Hello,
While reviewing the GGMN data, we discovered many wells without measurements. Could you provide a list of the countries with wells without measurements (and the number of wells with missing data) and investigate the possible reasons? For instance, could this issue be due to an API error or an incorrect upload? This will help us determine whether we need to delete these wells or take other corrective actions.
Thank you.

[meomancer]

We can add this filter on the admin site

[EliVolsch]

@Elie114 is it possible to list and example of the wells?

[Elie114]

I have attached a screenshot;

you can see that the first sheet is linked to wells from France, the other sheets have data from the United States which both are connected through API;

I also have a specific well ID from Norway: 12.345.1. This well has no data. Could you clarify the reason for this? For example, was the data deleted, or was it never added in the first place? Could you check if there was data previously that was later removed? Because I have other wells without measurements and they are not connected to API; Please Check in Germany; many wells have 0 measurements.

[meomancer]

Hi @Elie114
1. France
Some of wells already being fetched, but the current wells that has 0 measurements, basically does not have measurement from API
Example: 00182X0063/P
https://hubeau.eaufrance.fr/api/v1/niveaux_nappes/chroniques?fields=date_mesure,niveau_nappe_eau&code_bss=00182X0063/P&sort=asc&page=1&size=500

2. United State
Same with France, they don't have measurements.
Please check the records below how to check it

3. Norway
Those empty wells is not from API, as i checked from API, they don't have that stations. Those wells are being uploaded manually,
so i'm not sure it was being added without measurements or maybe deleted.

4. Germany
For germany, i checked, the wells are created from 2020, which is i think it is the migrations from old GGMN, which we are just pulling the data. Maybe it was being empty at first place as i don't control (check it regularly).

Could you check if there was data previously that was later removed?

Unfortunately, no way to check this as we don't have any logs for this.

[Elie114]

Okay, Irwan !! Thank you this is valuable information!

Please @clau1313 check this