Bugs following recent changes to the division of counties in Québec (Canada) [closed]

Question

We have 101 counties in Québec and this has not changed for several years.

But recently, changes have been made to the division of the counties of Québec on the Project-GC database.

Three counties of Québec were split in two, which means that we end up with six counties instead of three, which is an error in relation to the reality.

The three affected counties before the changes:
- Brome-Missisquoi
- La Haute-Yamaska
- Québec

The three (now six) affected counties after the changes:
- Brome-Missisquoi
- Brome-Missisquoi (Québec)
- La Haute-Yamaska
- La Haute-Yamaska (Québec)
- Québec
- Québec (Québec)

Consequently, the results of Challenge Checkers using Québec counties are inconsistent with reality.

Example for me: I have found 17 caches in "Brome-Missisquoi" county.

But following recent changes on the database, I end up with:
- 9 caches found in "Brome-Missisquoi" county;
- 8 caches found in "Brome-Missisquoi (Québec)" county.

Very frustrating for geocachers who were qualified for certain challenges but no longer are because of this erroneous division in the database.

Even Project-GC stats by county are wrong following these recent changes on the database. Example for Belougas who has found at least one cache in the 101 counties of Québec: Project-GC thinks Belougas has found at least one cache in 104 counties of Québec on 101 counties of Québec... :
https://forums.geocaching.com/GC/index.php?/topic/391358-bugs-following-recent-changes-to-the-division-of-counties-in-qu%C3%A9bec-canada/#comment-6086246

Please cancel these recent changes and return to the initial division of the 101 counties of Québec.

Regards!

Answer 1

It was a mistake in our end. Somehow we ended up importing test data onto the live servers. This was discovered earlier today and the restoration of data is in progress.

Comments

Thank you magma1447 for your prompt reply!

---

The problem seems to be fixed.

Congratulations and thank you to the whole Project-GC team!

I'm going to sleep better next night than last night...

Luc

---

For your information, we will be updating polygon data for Canada today. This will cause similar issues to what you have seen before. For British Columbia Power River will be renamed to qathet Regional District, while it's processing both names might exist at the same time.