Issue with Adding Specific Wells to GGMN (New Zealand Case)

[EliVolsch]

Hi,
I have attached a screenshot for a report that I got when uploading data to the GGMN. as you can see the problem is 'get() returned more than one Well -- it returned 2!'
However, the red rows highlighted in red have ID: 5005 5006 5007, and 5023; and there is no duplicates in the column.
Can you fix this so these 4 wells are also added?
Thank you

[meomancer]

Hi @clau1313 @Elie114
The problem is because There is actually 2 wells with ID 5005
https://ggis.un-igrac.org/groundwater/record/410267/ : WWD32
https://ggis.un-igrac.org/groundwater/record/82333/ : Well..5005 Waipukurau Depot

We can check by ID and name

But the problem will be on the monitoring data, which is currently we check the data based on just the ID column

What do you suggest?
Should we:

• Remove one of it?
• Also add name on the monitoring data excel to prevent this?

[clau1313]

hi @meomancer, thanks. It would be good to add the name on the monitoring data excel to prevent this issue.

But then, what happens if a well has only ID but no name?

[meomancer]

Hi @clau1313
The name is just used for checking the well if it returns 2 or more well
If it return more well, it will check also the name

If it is provide no name, if the ID also in multiple wells, it still error

[clau1313]

Hi @meomancer, thanks for the clarification. Then let's use the name for cheking the wells if the system returns 2 or more wells with only ID.

In the case that the ID and name are the same, can the system also check the coordinates? (this scenario is unlikely, but just in case?)

[meomancer]

Ok @clau1313
I think instead adding the name, we can put latitude and longitude on the files

[Elie114]

Hi @meomancer
Let's go ahead and stick with the ID and Name for now as @clau1313 mentioned.

[Elie114]

how do we follow up from here ? Can you add these 4 wells that we had an issue with ?

[meomancer]

Hi @Elie114 @clau1313
This is quite a big changes as we need to create new column to

• the uploader excel
• to the download file
• update code

It will take time for me to update (about 1 day) as well as re-cache the download file
I will work on it next week

Meanwhile, i have other solution
I think we just need to upload the monitoring data?
We can change the duplicated original_id for now, and after monitoring_data has been uploaded, we can revert it
What do you think?

[Elie114]

Okay, let's do this for now.

Can you please just explain why it is a big change I thought we are just checking in case of duplicated IDS, the code will check the name too; why do we need to change the format of the uploader and download file? Because we don't want to make things more complicated.

Ok @clau1313 I think instead adding the name, we can put latitude and longitude on the files

Does this make it easier or same steps too ?

[meomancer]

Can you please just explain why it is a big change I thought we are just checking in case of duplicated IDS, the code will check the name too; why do we need to change the format of the uploader and download file? Because we don't want to make things more complicated.

Hi @Elie114
It is not for the "Well uploader" excel, but for the monitoring data
As monitoring data does not have name column on it

So to make use of name, we need to:

1. Add name column for all excel for upload (now it is just on well upload)
2. Adding it also for the download file (the cache), to make it consistence

[meomancer]

Hi @Elie114
I have changed the duplicated original id for now, could you retry upload the data?
After that, please ping me so i can rechange the id

[Elie114]

Can you please just explain why it is a big change I thought we are just checking in case of duplicated IDS, the code will check the name too; why do we need to change the format of the uploader and download file? Because we don't want to make things more complicated.

Hi @Elie114 It is not for the "Well uploader" excel, but for the monitoring data As monitoring data does not have name column on it

So to make use of name, we need to:

1. Add name column for all excel for upload (now it is just on well upload)
2. Adding it also for the download file (the cache), to make it consistence

@clau1313 Please check this

[Elie114]

Hi @Elie114 I have changed the duplicated original id for now, could you retry upload the data? After that, please ping me so i can rechange the id

This is Done !

[Elie114]

Hi Irwan, I have re-uploaded the data so that you can update the ID accordingly for issue #758. Regarding issue #756 (the one related to France), I just wanted to follow up with you. It’s great that the fetching process is completed. However, it looks like the water level elevations were mistakenly considered as water depths, and vice versa. Could you please swap them accordingly? For now, I have hidden France from the GGMN due to the incorrect data. Please let me know once this has been corrected, as it is quite urgent. Thanks in advance for your help! Best regards, Elie

…

________________________________ From: Irwan Fathurrahman ***@***.***> Sent: Friday, February 21, 2025 6:50 AM To: kartoza/IGRAC-GGIS ***@***.***> Cc: Elie Gerges ***@***.***>; Mention ***@***.***> Subject: Re: [kartoza/IGRAC-GGIS] Issue with Adding Specific Wells to GGMN (New Zealand Case) (Issue #758) Hi @Elie114<https://github.com/Elie114> I have changed the duplicated original id for now, could you retry upload the data? After that, please ping me so i can rechange the id — Reply to this email directly, view it on GitHub<#758 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BEKUPQNF2CGCGQBG27GYGH32Q25DLAVCNFSM6AAAAABVEKMKTGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNZTGUZTAMBTGM>. You are receiving this because you were mentioned.Message ID: ***@***.***> [meomancer]meomancer left a comment (kartoza/IGRAC-GGIS#758)<#758 (comment)> Hi @Elie114<https://github.com/Elie114> I have changed the duplicated original id for now, could you retry upload the data? After that, please ping me so i can rechange the id — Reply to this email directly, view it on GitHub<#758 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BEKUPQNF2CGCGQBG27GYGH32Q25DLAVCNFSM6AAAAABVEKMKTGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNZTGUZTAMBTGM>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[Elie114]

Hi Elie I have reverted the ids to original one. Regarding issue #756 (the one related to France), I just wanted to follow

up with you. It’s great that the fetching process is completed. However, it looks like the water level elevations were mistakenly considered as water depths, and vice versa. Could you please swap them accordingly?

Could you explain more? Maybe a good example so i can understand the context? Thank you Best regards Irwan Fathurrahman *Senior Software Developer* *T *: +27(0) 87 809 2702 *E *: ***@***.*** *W* : kartoza.com *This email and any attachments are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you * *have received this email in error, please notify the sender immediately and delete it from your system. Unauthorised use, disclosure, or copying* *of the contents is prohibited.*

…

On Fri, 21 Feb 2025 at 17:37, Elie Gerges ***@***.***> wrote: Hi Irwan, I have re-uploaded the data so that you can update the ID accordingly for issue #758. Regarding issue #756 (the one related to France), I just wanted to follow up with you. It’s great that the fetching process is completed. However, it looks like the water level elevations were mistakenly considered as water depths, and vice versa. Could you please swap them accordingly? For now, I have hidden France from the GGMN due to the incorrect data. Please let me know once this has been corrected, as it is quite urgent. Thanks in advance for your help! Best regards, Elie ------------------------------ *From:* Irwan Fathurrahman ***@***.***> *Sent:* Friday, February 21, 2025 6:50 AM *To:* kartoza/IGRAC-GGIS ***@***.***> *Cc:* Elie Gerges ***@***.***>; Mention < ***@***.***> *Subject:* Re: [kartoza/IGRAC-GGIS] Issue with Adding Specific Wells to GGMN (New Zealand Case) (Issue #758) Hi @Elie114 <https://github.com/Elie114> I have changed the duplicated original id for now, could you retry upload the data? After that, please ping me so i can rechange the id — Reply to this email directly, view it on GitHub <#758 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BEKUPQNF2CGCGQBG27GYGH32Q25DLAVCNFSM6AAAAABVEKMKTGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNZTGUZTAMBTGM> . You are receiving this because you were mentioned.Message ID: ***@***.***> [image: meomancer]*meomancer* left a comment (kartoza/IGRAC-GGIS#758) <#758 (comment)> Hi @Elie114 <https://github.com/Elie114> I have changed the duplicated original id for now, could you retry upload the data? After that, please ping me so i can rechange the id — Reply to this email directly, view it on GitHub <#758 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BEKUPQNF2CGCGQBG27GYGH32Q25DLAVCNFSM6AAAAABVEKMKTGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNZTGUZTAMBTGM> . You are receiving this because you were mentioned.Message ID: ***@***.***>