Advanced

Re: HQ updating regions

HQ updating regions
April 12, 2018 09:29AM
I have received some head's up that HQ will be updating country names and region names. I don't have a complete list yet, but this will definitely affect challenge checkers for some countries.

Sounds like Czech Republic, Switzerland and France will be affected, not sure yet if there are more. If I understood it correctly, they will even rename the country Czech Republic.

I will update this thread with more details when I get them.
Re: HQ updating regions
April 13, 2018 01:09AM
I've been looking through countries lately (to check continent definitions) and noticed a couple that are already different between PGC and Geocaching.com:

Moldova / Moldovia
Serbia / SCG
Re: HQ updating regions
April 13, 2018 07:55AM
sumbloke Wrote:
-------------------------------------------------------
> I've been looking through countries lately (to
> check continent definitions) and noticed a couple
> that are already different between PGC and
> Geocaching.com:
>
> Moldova / Moldovia
> Serbia / SCG

In which case (links for example) does they differ? Project-GC never changes the name of countries, they should be shown with the data we get from the API.

I am a bit extra curious since HQ is supposed to have been updating some of their names by now, but I can't see it in the API yet. For example Czech Republic will be renamed to Czechia. On the other hand, the API that Project-GC uses got broken tonight, so we currently can't update any cache data at all.
Re: HQ updating regions
April 13, 2018 08:11AM
The way I found these is using the Top Finders function ( https://project-gc.com/Statistics/Top ) and looking at the country lists (which I'm looking at to see which continents they get placed in) on both the Geocaching.com profile and PGC ProfileStats. Moldova/Moldovia was easy to figure out the discrepancy but I had to check a couple of users and compare find counts per country to figure out that SCG was Serbia...

Incidentally, since I've been looking at continents, it seems that PGC is missing a few countries from Africa. The three I've come across so far are Central African Republic, Guinea and Guinea-Bissau.
Re: HQ updating regions
April 13, 2018 08:22PM
These where the countries of Africa in the database last november
AFRICA ["Algeria", "Angola", "Benin", "Botswana", "British Indian Ocean Territories", "Burkina Faso", "Burundi", "Cameroon", "Cape Verde", "Central African Republic", "Chad", "Comoros", "Congo", "Democratic Republiek of the Congo", "Djibouti", "Egypt", "Equatorial Guinea", "Eritrea", "Ethiopia", "Gabon", "Gambia", "Ghana", "Guinea", "Guinea-Bissau", "Ivory Coast", "Kenya", "Lesotho", "Liberia", "Libya", "Madagascar", "Malawi", "Mali", "Mauritania", "Mauritius", "Mayotte", "Morocco", "Mozambique", "Namibia", "Niger", "Nigeria", "Reunion", "Rwanda", "Saint Helena", "Sao Tome and Principe", "Senegal", "Seychelles", "Sierra Leone", "Somalia", "South Africa", "South Sudan", "Sudan", "Swaziland", "Tanzania", "Togo", "Tunisia", "Uganda", "Western Sahara", "Zambia", "Zimbabwe"]
Re: HQ updating regions
April 14, 2018 04:24AM
Strange that the maps aren't showing them then...
https://project-gc.com/ProfileStats/losgeocachas45#Maps has finds in Guinea and Guinea-Bissau, but neither country shows on their Africa map.
https://project-gc.com/ProfileStats/mploc#Maps has a find in CAR, but it doesn't show on their Africa map.
Re: HQ updating regions
April 19, 2018 07:24AM
I've finished my list. Also found the following don't seem to show up on PGC continents, but do in Geocaching.com:
Liberia
Northern Mariana Islands
Pitcairn Islands
Somalia
Tonga
Wallis And Futuna Islands (not sure, the only finder there doesn't have enough Oceania countries for the map to show)
Western Sahara


And these countries have different names in addition to the two I mentioned before (PGC/GC):
Cape Verde/Cabo Verde
Ivory Coast/Côte d'Ivoire
Pitcairn Islands/Pitcairn
Reunion/Réunion
South Georgia and Sandwich Islands/South Georgia and the South Sandwich Islands
South Korea/Korea
St Pierre Miquelon/Saint Pierre and Miquelon
St Vince Grenadines/Saint Vincent and the Grenadines
Re: HQ updating regions
April 19, 2018 10:51AM
sumbloke Wrote:
-------------------------------------------------------
> The way I found these is using the Top Finders
> function ( https://project-gc.com/Statistics/Top )
> and looking at the country lists (which I'm
> looking at to see which continents they get placed
> in) on both the Geocaching.com profile and PGC
> ProfileStats. Moldova/Moldovia was easy to figure
> out the discrepancy but I had to check a couple of
> users and compare find counts per country to
> figure out that SCG was Serbia...
>
> Incidentally, since I've been looking at
> continents, it seems that PGC is missing a few
> countries from Africa. The three I've come across
> so far are Central African Republic, Guinea and
> Guinea-Bissau.

After reviewing some of the changes HQ has made recently, for example renamed Czech Republic to Czechia and all its regions I now understand that they have one name set in the database and the API, and another name set for the web. I guess they are translated somewhere.

Project-GC uses the names from the API and does not support to translate them on the way.

That's probably why you have found a lot of inconsistencies. They might have renamed countries before, without me noticing, since I still get the older names via the API.
Re: HQ updating regions
April 19, 2018 10:54AM
Ah, that makes sense
Re: HQ updating regions
April 20, 2018 06:39PM
Hi there,
we are having problems with method: PGC.GetOldestCaches
for regions that have changed names.

Country was changed (e.g. 'Czechia') but region names have to be in old notation (e.g. 'Jihomoravsky kraj').
Unfortunatelly all tags were updated and currently doesn't work.

You can see mixed old and new notation in this checker:
https://project-gc.com/Challenges/GC7890C/34332

Same checker with currently used region names is here:
https://project-gc.com/Challenges/GC7G5NX/30807

Thanks in advance
Re: HQ updating regions
April 19, 2018 10:55AM
HQ will update the names over two phases. Phase 1 is done, and from what I can see, it's only affecting their web interface, and not any API using applications.

I have asked how phase two will work. It's extra interesting since they will be throwing away all regions in Switzerland and have completely new names. I wonder if they will solve that with some translation table as well.

As long as they don't update the API it will be quite cumbersome to adjust to their names, and I probably won't do it. It's a quite big project to adjust the names in Project-GC and many different places that might be affected of it. I am glad if I can skip it.
Re: HQ updating regions
April 20, 2018 11:15AM
I was wrong. Project-GC receives the data both as IDs and names. Project-GC used the IDs and then resolved that in an outdated table. I will go ahead and fix the code and actually add the new names. I'll get back to you with what's updated.
Re: HQ updating regions
April 20, 2018 01:36PM
I have now updated PGC's data. Some might lag a bit behind and fix itself, some I might have missed.

Below I am listing change I have made according to the information from HQ. There might also be some country renaming due to older changes (like those listed in this thread, I will take a look at those names). Updating country names will now happen automatically.

	'British Indian Ocean Territories' => 'British Indian Ocean Territory',
	'Quebec' => 'Québec',
	'Cape Verde' => 'Cabo Verde',
	'Hlavni mesto Praha' => 'Hlavní město Praha',
	'Jihocesky kraj' => 'Jihočeský kraj',
	'Jihomoravsky kraj' => 'Jihomoravský kraj',
	'Karlovarsky kraj' => 'Karlovarský kraj',
	'Kraj Vysocina' => 'Kraj Vysočina',
	'Kralovehradecky kraj' => 'Královéhradecký kraj',
	'Liberecky kraj' => 'Liberecký kraj',
	'Moravskoslezsky kraj' => 'Moravskoslezský kraj',
	'Olomoucky kraj' => 'Olomoucký kraj',
	'Pardubicky kraj' => 'Pardubický kraj',
	'Plzensky kraj' => 'Plzeňský kraj',
	'Stredocesky kraj' => 'Středočeský kraj',
	'Ustecky kraj' => 'Ústecký kraj',
	'Zlinsky kraj' => 'Zlínský kraj',
	'Czech Republic' => 'Czechia',
	'East Timor' => 'Timor-Leste',
	'French Southern Territories' => 'French Southern and Antarctic Territories',
	'Heard Island And Mcdonald Islands' => 'Heard Island and McDonald Islands',
	'Ivory Coast' => 'Côte d\'Ivoire',
	'Macau' => 'Macao',
	'Pitcairn Islands' => 'Pitcairn',
	'Reunion' => 'Réunion',
	'South Georgia and Sandwich Islands' => 'South Georgia and the South Sandwich Islands',
	'St Barthelemy' => 'Saint Barthélemy',
	'St Pierre Miquelon' => 'Saint Pierre and Miquelon',
	'St Vince Grenadines' => 'Saint Vincent and the Grenadines',
	'Svalbard and Jan Mayen' => 'Svalbard and Jan Mayen Islands',	// Can match multiple times
	'Northeast England' => 'North East England',
	'Northwest England' => 'North West England',
	'Wallis And Futuna Islands' => 'Wallis and Futuna Islands',

	'Svalbard and Jan Mayen Islands Islands' => 'Svalbard and Jan Mayen Islands',	// Fixes my double update

All challenge checker scripts and tag configs has been updated with a simple search and replace, hopefully I didn't break anything.
Re: HQ updating regions
April 20, 2018 06:45PM
I wrote 'bug report' about PGC.GetOldestCaches method.. see above..
Re: HQ updating regions
April 20, 2018 07:06PM
I am quite sure that will fix itself within a few hours (probably less than 4). Seems like we are still waiting for all the data to replicate over the systems and data caches to expire.

Caches per region in Czechia in main DB cluster:
| Hlavní město Praha      |  6532 |
| Jihomoravský kraj       |  9421 |
| Jihočeský kraj          |  7309 |
| Karlovarský kraj        |  3568 |
| Kraj Vysočina           |  4172 |
| Královéhradecký kraj    |  5459 |
| Liberecký kraj          |  5471 |
| Moravskoslezský kraj    |  7878 |
| Olomoucký kraj          |  5741 |
| Pardubický kraj         |  4175 |
| Plzeňský kraj           |  5860 |
| Středočeský kraj        | 13693 |
| Zlínský kraj            |  5056 |
| Ústecký kraj            |  7044 |

Another DB Cluster:
| Hlavni mesto Praha    |  6532 |
| Hlavní město Praha    |     1 |
| Jihocesky kraj        |  7309 |
| Jihomoravsky kraj     |  9421 |
| Karlovarsky kraj      |  3568 |
| Kraj Vysocina         |  4172 |
| Kralovehradecky kraj  |  5459 |
| Liberecky kraj        |  5471 |
| Moravskoslezský kraj  |     1 |
| Moravskoslezsky kraj  |  7877 |
| Olomoucký kraj        |     3 |
| Olomoucky kraj        |  5737 |
| Pardubicky kraj       |  4175 |
| Plzensky kraj         |  5860 |
| Stredocesky kraj      | 13694 |
| Ustecky kraj          |  7044 |
| Zlinsky kraj          |  5056 |
Re: HQ updating regions
April 20, 2018 07:08PM
ok, perfect
thanks for response
Sorry, you do not have permission to post/reply in this forum.