ne_10m_admin_1_states_provinces: some ISO 3166 confusion between cities that are subdivisions and subdivisions with same name

[MLWorley]

In ne_10m_admin_1_states_provinces there are several instances where a city that is a national subdivision in its own right has the same name (sort of) as a surrounding subdivision, and the iso_3166_2 values are sometimes confused in ne_10m_admin_1_states_provinces. They get the right geometry, and sometimes the right names, but they get identical iso_3166_2 values although they should be different.

If you look for cases where the same iso_3166_2 value got used more than once, it can flush some of these out.

This happens for the following:

• Lima Province and the capital city of Lima in Peru You can see that the smaller inset of the two is the one that should have the city's ISO code and the other is the surrounding province, but they're both coded as PE-LIM rather than having the correct iso_3166_2 values.

• all (ok, many) of the Latvia (iso_A2='LV') subdivisions where the iso_3166_2 code consists entirely of letters are like this. The type value clarifies which is the city and which is the surrounding subdivision (the names are usually just duplicates).

[MLWorley]

You might want to sort out the Latvian subdivisions before putting in the last set of Latvian subdivision changes from 2021, due to the potential confusion between what subdivisions were retained and which were merged with others to form larger subdivisions.

• adm1_code = LVA-1081 currently has name = 'Daugavpils' and incorrect iso_3166_2='LV-DGV' The iso_3166_2 for this entry should have been LV-025.

  In 2021, this subdivision was merged with the subdivision having adm1_code='LVA-5749' and iso_3166_2 value 'LV-036' to form a new subdivision (the result looks like a doughnut with the city of LV-DGV as the hole of the doughnut), with iso_3166_2 = 'LV-111' and name = 'Augšdaugava'.

• adm1_code = 'LVA-1084' currently has name = 'Jelgava' and incorrect iso_3166_2='LV-JEL' The iso_3166_2 for this entry should be 'LV-041'.

• adm1_code = 'LVA-5725' currently has name = 'Jekabpils' and incorrect iso_3166_2='LV-JKB' The iso_3166_2 for this entry should be 'LV-042'.

  In 2021, the entry with 'LVA-1085' was merged with the entry in LVA-5725 and the result got the iso_3166_2 'LV-042' and kept the name 'Jekabpils'. (Essentially the Jekabpils state city was abolished and merged into the surrounding subdivision.)

• adm1_code = 'LVA-1066' currently has name = 'Rezeknes' and incorrect iso_3166_2='LV-REZ' The iso_3166_2 for this entry should be 'LV-077'.

• adm1_code='LVA-934' currently has name = 'Ventspils' and incorrect iso_3166_2='LV-VEN' The iso_3166_2 for this entry should be 'LV-106'.