Difference between revisions of "Global countries taxonomy"

From Open Food Facts wiki
Jump to navigation Jump to search
(Added spanish translations)
(using wikidata to build the taxonomy)
Line 1: Line 1:
 +
 +
== Building a complete taxonomy of countries from Wikidata ==
 +
 +
Steps:
 +
* Get a list of all countries
 +
** query: find objects with property "is an instance of" (P31) "country" (Q6256)
 +
** http://208.80.153.172/wdq/?q=claim[31:6256] (using http://wikidataquery.eu/ )
 +
*** 124 results
 +
** use "Sovereign state" (Q3624078) instead?
 +
*** 202 results, 23 are historic or fictional
 +
** or any state with an Internet top level domain (P78)
 +
*** http://208.80.153.172/wdq/?q=claim[78]
 +
*** 270 results, includes territories like US Virgin Islands, French Polynesia etc.
 +
*** <nowiki>[16,17,20,22,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,51,55,77,79,96,114,115,117,142,145,148,155,
 +
159,183,184,189,191,211,212,213,214,215,217,218,219,221,222,223,224,225,227,228,229,230,232,233,235,236,237,238,241,242,
 +
244,252,258,262,265,298,327,334,347,398,399,403,408,414,419,423,424,458,574,657,664,668,672,678,683,685,686,691,695,697,
 +
702,709,710,711,712,717,730,733,734,736,739,750,754,757,760,763,766,769,774,778,781,783,784,785,786,790,792,794,796,800,
 +
801,804,805,810,811,813,817,819,822,826,833,836,837,842,843,846,851,854,858,863,865,869,874,878,881,884,889,902,912,916,
 +
917,921,924,928,929,945,948,953,954,958,962,963,965,967,970,971,974,977,983,986,1000,1005,1006,1007,1008,1009,1011,1013,
 +
1014,1016,1019,1020,1025,1027,1028,1029,1030,1032,1033,1036,1037,1039,1041,1042,1044,1045,1049,1050,1183,1410,3769,4628,
 +
5689,5785,6250,7184,8646,9648,9676,11196,11703,12130,13353,14056,14773,15180,16635,16641,16644,16645,16957,17012,17054,
 +
17063,17070,18221,21203,23408,23635,25228,25230,25279,25305,25362,25396,25528,26180,26273,26988,27561,30971,31057,31063,
 +
33788,34020,34617,35086,35555,35672,36004,36704,36823,43448,46197,126125,129003,131083,131198,179313,192184,205047,
 +
219060,407199,842829,927467,1555938,2552742]</nowiki>
 +
* Get countries
 +
** we need the aliases and the labels in all languages (or maybe just "main" languages with 2 letter codes)
 +
* Get the official language property (P37)
 +
** build a map of object to language code
 +
* Flags?
 +
** in SVG format in wikidata, shape varies (e.g. different rectangles, square for Switzerland)
 +
 +
== Taxonomy ==
 +
 
This is just a small taxonomy for testing purposes, a complete taxonomy (all countries translated to all languages) can be computed automatically from sources such as Wikidata.
 
This is just a small taxonomy for testing purposes, a complete taxonomy (all countries translated to all languages) can be computed automatically from sources such as Wikidata.
−
 
 
2 letters country codes are needed only as en: synonyms
 
2 letters country codes are needed only as en: synonyms
  

Revision as of 11:39, 12 December 2013

Building a complete taxonomy of countries from Wikidata

Steps:

  • Get a list of all countries
    • query: find objects with property "is an instance of" (P31) "country" (Q6256)
    • http://208.80.153.172/wdq/?q=claim[31:6256] (using http://wikidataquery.eu/ )
      • 124 results
    • use "Sovereign state" (Q3624078) instead?
      • 202 results, 23 are historic or fictional
    • or any state with an Internet top level domain (P78)
      • http://208.80.153.172/wdq/?q=claim[78]
      • 270 results, includes territories like US Virgin Islands, French Polynesia etc.
      • [16,17,20,22,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,51,55,77,79,96,114,115,117,142,145,148,155, 159,183,184,189,191,211,212,213,214,215,217,218,219,221,222,223,224,225,227,228,229,230,232,233,235,236,237,238,241,242, 244,252,258,262,265,298,327,334,347,398,399,403,408,414,419,423,424,458,574,657,664,668,672,678,683,685,686,691,695,697, 702,709,710,711,712,717,730,733,734,736,739,750,754,757,760,763,766,769,774,778,781,783,784,785,786,790,792,794,796,800, 801,804,805,810,811,813,817,819,822,826,833,836,837,842,843,846,851,854,858,863,865,869,874,878,881,884,889,902,912,916, 917,921,924,928,929,945,948,953,954,958,962,963,965,967,970,971,974,977,983,986,1000,1005,1006,1007,1008,1009,1011,1013, 1014,1016,1019,1020,1025,1027,1028,1029,1030,1032,1033,1036,1037,1039,1041,1042,1044,1045,1049,1050,1183,1410,3769,4628, 5689,5785,6250,7184,8646,9648,9676,11196,11703,12130,13353,14056,14773,15180,16635,16641,16644,16645,16957,17012,17054, 17063,17070,18221,21203,23408,23635,25228,25230,25279,25305,25362,25396,25528,26180,26273,26988,27561,30971,31057,31063, 33788,34020,34617,35086,35555,35672,36004,36704,36823,43448,46197,126125,129003,131083,131198,179313,192184,205047, 219060,407199,842829,927467,1555938,2552742]
  • Get countries
    • we need the aliases and the labels in all languages (or maybe just "main" languages with 2 letter codes)
  • Get the official language property (P37)
    • build a map of object to language code
  • Flags?
    • in SVG format in wikidata, shape varies (e.g. different rectangles, square for Switzerland)

Taxonomy

This is just a small taxonomy for testing purposes, a complete taxonomy (all countries translated to all languages) can be computed automatically from sources such as Wikidata. 2 letters country codes are needed only as en: synonyms 


en:Europe, EU
fr:Europe, EU
es:Europa

< en:Europe
en:Belgium, be
fr:Belgique
nl:Belgie
es:Bélgica

< en:Europe
en:France, fr
fr:France
es:Francia

< en:Europe
en:Germany, de
de:Deutschland
fr:Allemagne
es:Alemania

< en:Europe
en:Italy, it
fr:Italie
it:Italia
es:Italia

< en:Europe
en:Spain, es
es:España
fr:Espagne

< en:Europe
en:Switzerland, ch
de:Schweiz
fr:Suisse
es:Suiza

en:North America
fr:Amérique du Nord
es:América del Norte

< en:North America
en:Canada, ca
fr:Canada
es:Canadá

< en:North America
en:Mexico, mx
fr:Mexique
es:México, Méjico

< en:North America
en:United States, us, usa
fr:Etats-Unis
es:Estados Unidos
Retrieved from "https://wiki.openfoodfacts.org/index.php?title=Global_countries_taxonomy&oldid=154"