Skip to content

Issue #1 - Normalize countries' names

joubu requested to merge joubu/hea-ws:issue_1 into master 
> The following queries have also been executed on the server:
> UPDATE installation SET country="Brazil"  WHERE country="Brasil";
> UPDATE installation SET country="Canada" WHERE country="CANADA";
> UPDATE installation SET country="Cape Verde"  WHERE country="Cabo Verde";
> UPDATE installation SET country="Czech Republic" WHERE country="CZ" OR country="Česká republika" OR country="Czechia" OR country="CZE";
> UPDATE installation SET country=""  WHERE country="country";
> UPDATE installation SET country="India" WHERE country="Navi Mumbai, India";
> UPDATE installation SET country="Ireland" WHERE country="Irelanbd";
> UPDATE installation SET country="Spain"  WHERE country="España";
> UPDATE installation SET country="Spain"  WHERE country="Espanya";
> UPDATE installation SET country="Spain"  WHERE country="spain";
> UPDATE installation SET country="Japan"  WHERE country="Japon";
> UPDATE installation SET country="Saudi Arabia"  WHERE country="KINGDOM OF SAUDI ARABIA";
> UPDATE installation SET country="Japan"  WHERE country="Kobe, Japan";
> UPDATE installation SET country="Laos"  WHERE country="Lao PDR";
> UPDATE installation SET country="Macau"  WHERE country="Macau SAR";
> UPDATE installation SET country="Mexico" WHERE country="México" OR country="MX";
> UPDATE installation SET country="Netherlands"  WHERE country="Nederland" OR country="NETHERLANDS";
> UPDATE installation SET country="Austria"  WHERE country="Österreich";
> UPDATE installation SET country="Peru" WHERE country="Perú";
> UPDATE installation SET country="Portugal"  WHERE country="Portugual";
> UPDATE installation SET country="Portugal" WHERE country="PT";
> UPDATE installation SET country="Dominican Rep."  WHERE country="República Dominicana";
> UPDATE installation SET country="Dominican Rep."  WHERE country="República Dominicana.";
> UPDATE installation SET country="Russia Fed."  WHERE country="Russian";
> UPDATE installation SET country="Rwanda"  WHERE country="Rwanda.";
> UPDATE installation SET country="Slovakia"  WHERE country="Slovensko";
> UPDATE installation SET country="Sri Lanka"  WHERE country="Srilanka";
> UPDATE installation SET country="Switzerland"  WHERE country="Suisse";
> UPDATE installation SET country="Tunisia"  WHERE country="Tunisie";
> UPDATE installation SET country="Turkey"  WHERE country="Türkiye";
> UPDATE installation SET country="United Kingdom" WHERE country="England" OR country="UK";
> UPDATE installation SET country="USA" WHERE country="United States" OR country="United States of America" OR country="US";
> UPDATE installation SET country="Venezuela"  WHERE country=" Venezuela";
> UPDATE installation SET country="Portugal"  WHERE country="Vila de São Sebastião";
> UPDATE installation SET country="Trinidad & Tob." WHERE country="Trinidad";
> UPDATE installation SET country="Zimbabwe" WHERE country="Zimbabbwe";
> UPDATE installation SET country="Greece"  WHERE country="ΕΛΛΑΔΑ" OR country="GR";
> UPDATE installation SET country="Russia Fed."  WHERE country="Россия";
> UPDATE installation SET country="Ukraine"  WHERE country="Україна";
> UPDATE installation SET country="Armenia" WHERE country="ՀՀ";
> 
> UPDATE library SET country="Brazil"  WHERE country="Brasil";
> UPDATE library SET country="Canada" WHERE country="CANADA";
> UPDATE library SET country="Cape Verde"  WHERE country="Cabo Verde";
> UPDATE library SET country="Czech Republic" WHERE country="CZ" OR country="Česká republika" OR country="Czechia" OR country="CZE";
> UPDATE library SET country=""  WHERE country="country";
> UPDATE library SET country="India" WHERE country="Navi Mumbai, India";
> UPDATE library SET country="Ireland" WHERE country="Irelanbd";
> UPDATE library SET country="Spain"  WHERE country="España";
> UPDATE library SET country="Spain"  WHERE country="Espanya";
> UPDATE library SET country="Spain"  WHERE country="spain";
> UPDATE library SET country="Japan"  WHERE country="Japon";
> UPDATE library SET country="Saudi Arabia"  WHERE country="KINGDOM OF SAUDI ARABIA";
> UPDATE library SET country="Japan"  WHERE country="Kobe, Japan";
> UPDATE library SET country="Laos"  WHERE country="Lao PDR";
> UPDATE library SET country="Macau"  WHERE country="Macau SAR";
> UPDATE library SET country="Mexico" WHERE country="México" OR country="MX";
> UPDATE library SET country="Netherlands"  WHERE country="Nederland" OR country="NETHERLANDS";
> UPDATE library SET country="Austria"  WHERE country="Österreich";
> UPDATE library SET country="Peru" WHERE country="Perú";
> UPDATE library SET country="Portugal"  WHERE country="Portugual";
> UPDATE library SET country="Portugal" WHERE country="PT";
> UPDATE library SET country="Dominican Rep."  WHERE country="República Dominicana";
> UPDATE library SET country="Dominican Rep."  WHERE country="República Dominicana.";
> UPDATE library SET country="Russia Fed."  WHERE country="Russian";
> UPDATE library SET country="Rwanda"  WHERE country="Rwanda.";
> UPDATE library SET country="Slovakia"  WHERE country="Slovensko";
> UPDATE library SET country="Sri Lanka"  WHERE country="Srilanka";
> UPDATE library SET country="Switzerland"  WHERE country="Suisse";
> UPDATE library SET country="Tunisia"  WHERE country="Tunisie";
> UPDATE library SET country="Turkey"  WHERE country="Türkiye";
> UPDATE library SET country="United Kingdom" WHERE country="England" OR country="UK";
> UPDATE library SET country="USA" WHERE country="United States" OR country="United States of America" OR country="US";
> UPDATE library SET country="Venezuela"  WHERE country=" Venezuela";
> UPDATE library SET country="Portugal"  WHERE country="Vila de São Sebastião";
> UPDATE library SET country="Trinidad & Tob." WHERE country="Trinidad";
> UPDATE library SET country="Zimbabwe" WHERE country="Zimbabbwe";
> UPDATE library SET country="Greece"  WHERE country="ΕΛΛΑΔΑ" OR country="GR";
> UPDATE library SET country="Russia Fed."  WHERE country="Россия";
> UPDATE library SET country="Ukraine"  WHERE country="Україна";
> UPDATE library SET country="Armenia" WHERE country="ՀՀ";
> 
> Then a deletion of "old" installation (ie. not updated last year):
> delete from installation where YEAR(modification_time)<2019;

Merge request reports