petermr/CEVOpen

normalize country names for plant origins against Wikidata

petermr opened this issue · 4 comments

petermr commented

@ambarishK
Please collect all sections which mention where plants/oils originated (titles usually like "Origin of plant material").

Build a new TSV file which records

  • name of section containing plant or oil origin
  • country/countries mentioned in this section specifying where oil came from
  • look up country in Wikidata
ambarishK commented

OK sir.

ambarishK commented

Sir, please review the extraction sheet for plant material location - country20191222.tsv.

Most of locations are into sub-section of Materials and methods - Plant material.

There are records extracted from first 30 articles of oil186.

petermr commented
ambarishK commented

Sir, please review the complete extraction of plant material location extraction sheet - country20191222.tsv

There are 138 articles which mention plant material location.

Two articles which mentions multiple plant names.

PMC5674267
PMC5694587

Articles which mentions multiple plant locations are as following.

PMC5622398 | Essential Oil Extracted from Rosemary (R   EO) | England | Q21
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | France | Q142
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | Portugal | Q45
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | Russia | Q159
PMC5622398 | Essential Oil Extracted from Rosemary (R EO) | Spain | Q29


PMC5622403 | Chemical Composition of Essential oils of   Artemisia Species | Iran | Q794
PMC5622403 | Chemical Composition of Essential oils of Artemisia Species | India | Q668
PMC5622403 | Chemical Composition of Essential oils of Artemisia Species | China | Q29520


PMC5849928 | Preparation and analysis of AEO | Iran | Q794
PMC5852288 | Material | Cameroon | Q1009


PMC5970210 | Acaricidal activities and color deformation   effects of the essential oils of M. officinalis cultivated in the three   different countries | France | Q142
PMC5970210 | Acaricidal activities and color deformation effects of the essential oils   of M. officinalis cultivated in the three different countries | Ireland | Q27
PMC5970210 | Acaricidal activities and color deformation effects of the essential oils   of M. officinalis cultivated in the three different countries | Serbia | Q403

There are 48 articles which either does not mention plant material location or not related with plant EO.