Editing Talk:Mika/Temp/WikiFCD

From WikiDotMako

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 77: Line 77:
* [https://foodsystems.org/ meta data on nutrition databases] by ISLI/Agriculture and Food Systems Institute.
* [https://foodsystems.org/ meta data on nutrition databases] by ISLI/Agriculture and Food Systems Institute.
* [http://www.langual.org/Default.asp Framework for food description].
* [http://www.langual.org/Default.asp Framework for food description].
* [https://soilandhealth.org/wp-content/uploads/06clipfile/RCE/rceALL.html Bibliography related to variation in mineral composition of vegetables]
* [https://soilandhealth.org/wp-content/uploads/06clipfile/Nutritional%20Quality%20of%20Organically-Grown%20Food.html Bibliography related to Nutritional Quality of Organically Grown Food]
* [https://soilandhealth.org/wp-content/uploads/06clipfile/Organically%20Produced%20Foods%20Nutritive%20Content.htm Bibliography related to Organically Produced Foods: Nutritive Content]


=response to the committee=
=response to the committee=
Line 156: Line 153:


* Finally, we will '''complete this project with diverse communities from around the world''' as these FCD can be translated into/from many languages. The design of Wikibase will allow us to more easily support additional languages in the data itself, as well as in user interfaces.
* Finally, we will '''complete this project with diverse communities from around the world''' as these FCD can be translated into/from many languages. The design of Wikibase will allow us to more easily support additional languages in the data itself, as well as in user interfaces.
= Brown Bag Seminar =
Some ideas for things to present:
* slides on the project idea, our vision for the overall process
* slides on the process of "automated" reading of databases - maybe USDA API example or SMILING excel sheet example
* slides on connecting to other Wikibase instances - wikidata example
* demo on how a contributor can easily identify which language is missing the food item in wikidata, which makes it easier for contributors to see where they can make contributions in terms of translation. (I forgot the name of this tool...)
* demo on making a query based on research questions (e.g. nutrient content differences across databases; comparison of numbers of nutrients included in different databases; Wikipedia articles mentioning a particular food item etc etc)
* demo on how to convert data to csv or other formats that can be used in R, STATA etc.
* slides on our plans for the community expansion and engagement (what we will do initially ourselves; what peer contributors will do once the system is ready)
==Kat flag==
*Bots: We wrote a series of bots using the WikidataIntegrator python module [https://github.com/SuLab/WikidataIntegrator]. These bots can be used to read in data from a source and then create statements in the Wikibase according to our data models. As of November, 2020 we have written bots to:
# add countries to the Wikibase (sourced from Wikidata)
# add taxon names that have a GRIN id (sourced from Wikidata)
# add human languages (sourced from Wikidata)
# add USDA Food Data Central (sourced from FDC's API)
==Properties used by FCT==
{| class="wikitable"
|-
! 😊 Vietnam !! link !! 😊 Indonesia !! FDC !! link
|-
| water (P5) || [http://wikifcd.wiki.opencura.com/prop/P5] || water (P5)|| water (P5)|| [http://wikifcd.wiki.opencura.com/prop/P5]
|-
| energy (P6) || [http://wikifcd.wiki.opencura.com/prop/P6] || energy (P6) ||energy (P6) || [http://wikifcd.wiki.opencura.com/prop/P6]
|-
| Protein (P7)|| [http://wikifcd.wiki.opencura.com/prop/P7] || Protein (P7)||  Protein (P7)|| [http://wikifcd.wiki.opencura.com/prop/P7]
|-
| total lipid (P8) || [http://wikifcd.wiki.opencura.com/prop/P8] || total lipid (P8)|| total lipid (P8)|| [http://wikifcd.wiki.opencura.com/prop/P8]
|-
| Ash (P9) || [http://wikifcd.wiki.opencura.com/prop/P9] ||Ash (P9)||Ash (P9) || [http://wikifcd.wiki.opencura.com/prop/P9]
|-
| carbohydrate (P10)||[http://wikifcd.wiki.opencura.com/prop/P10] || carbohydrate (P10) || dietary fiber (P11) || [http://wikifcd.wiki.opencura.com/prop/P11]
|-
| dietary fiber (P11) ||[http://wikifcd.wiki.opencura.com/prop/P11] || dietary fiber (P11) || Iron (P14)|| [http://wikifcd.wiki.opencura.com/prop/P14]
|-
| Calcium (P13)|| [http://wikifcd.wiki.opencura.com/prop/P13] || Calcium (P13) || Magnesium (P15) || [http://wikifcd.wiki.opencura.com/prop/P15]
|-
| Iron (P14)|| [http://wikifcd.wiki.opencura.com/prop/P14] || Iron (P14) || Phosphorus (P16) || [http://wikifcd.wiki.opencura.com/prop/P16]
|-
| Zinc (P19) || [http://wikifcd.wiki.opencura.com/prop/P19] || Zinc (P19) || Potassium (P17) || [http://wikifcd.wiki.opencura.com/prop/P17]
|-
| Vitamin C (P24) || [http://wikifcd.wiki.opencura.com/prop/P24] || Vitamin C (P24) || Sodium (P18) || [http://wikifcd.wiki.opencura.com/prop/P18]
|-
| Thiamin (P25) ||[http://wikifcd.wiki.opencura.com/prop/P25] ||  Thiamin (P25) || Zinc (P19) || [http://wikifcd.wiki.opencura.com/prop/P19]
|-
| Riboflavin (P26)|| [http://wikifcd.wiki.opencura.com/prop/P26] || Riboflavin (P26) || Copper (P20) || [http://wikifcd.wiki.opencura.com/prop/P20]
|-
| Niacin (P27) || [http://wikifcd.wiki.opencura.com/prop/P27] || Niacin (P27) || Manganese (P21) || [http://wikifcd.wiki.opencura.com/prop/P21]
|-
| Vitamin B-6 (P29) || [http://wikifcd.wiki.opencura.com/prop/P29] || Vitamin B-6 (P29) || Selenium (P23) || [http://wikifcd.wiki.opencura.com/prop/P23]
|-
| Folate, total (P39) || [http://wikifcd.wiki.opencura.com/prop/P39] || Folate, total (P39) || Vitamin C (P24) || [http://wikifcd.wiki.opencura.com/prop/P24]
|-
| Folate, DFE (P42) || [http://wikifcd.wiki.opencura.com/prop/P42] || Folate, DFE (P42) || Thiamin (P25) || [http://wikifcd.wiki.opencura.com/prop/P25]
|-
| Vitamin A, RAE (P45)|| [http://wikifcd.wiki.opencura.com/prop/P45] || Vitamin A, RAE (P45) || Riboflavin (P26) || [http://wikifcd.wiki.opencura.com/prop/P26]
|-
| Vitamin A, IU (P49) || [http://wikifcd.wiki.opencura.com/prop/P49] || Carotene, beta (P46) || Niacin (P27) || [http://wikifcd.wiki.opencura.com/prop/P27]
|-
| Retinol (P75) ||[http://wikifcd.wiki.opencura.com/prop/P75] ||  Retinol (P75) || Pantothenic acid (P28) || [http://wikifcd.wiki.opencura.com/prop/P28]
|-
| common name (P76) || [http://wikifcd.wiki.opencura.com/prop/P76] || common name (P76) || Vitamin B-6 (P29) || [http://wikifcd.wiki.opencura.com/prop/P29]
|-
| SMILING Vietnam food code (P77)|| [http://wikifcd.wiki.opencura.com/prop/P77] || SMILING Indonesia food code (P78) || Sucrose (P32) || [http://wikifcd.wiki.opencura.com/prop/P32]
|-
||| || || Glucose (P33) || [http://wikifcd.wiki.opencura.com/prop/P33]
|-
||| || || Fructose (P34) || [http://wikifcd.wiki.opencura.com/prop/P34]
|-
||| || || Lactose (P35) || [http://wikifcd.wiki.opencura.com/prop/P35]
|-
||| || || Maltose (P36) || [http://wikifcd.wiki.opencura.com/prop/P36]
|-
||| || || Galactose (P37) || [http://wikifcd.wiki.opencura.com/prop/P37]
|-
||| || || Folate, total (P39) || [http://wikifcd.wiki.opencura.com/prop/P39]
|-
||| || || Folic acid (P40) || [http://wikifcd.wiki.opencura.com/prop/P40]
|-
||| || || Folate, food (P41) || [http://wikifcd.wiki.opencura.com/prop/P41]
|-
||| || || Folate, DFE (P42) || [http://wikifcd.wiki.opencura.com/prop/P42]
|-
||| || || Vitamin A, RAE (P45) || [http://wikifcd.wiki.opencura.com/prop/P45]
|-
||| || || Vitamin A, IU (P49) || [http://wikifcd.wiki.opencura.com/prop/P49]
|-
||| || || Vitamin K (phylloquinone) (P52) || [http://wikifcd.wiki.opencura.com/prop/P52]
|-
||| || || Vitamin K (Dihydrophylloquinone) (P53) || [http://wikifcd.wiki.opencura.com/prop/P53]
|-
||| || || Retinol (P75) || [http://wikifcd.wiki.opencura.com/prop/P75]
|-
||| || || USDA Food Data Central fcdid (P80) || [http://wikifcd.wiki.opencura.com/prop/P80]
|-
||| || || Fatty acids, total saturated (P86) || [http://wikifcd.wiki.opencura.com/prop/P86]
|-
||| || || Fatty acids, total polyunsaturated (P88) || [http://wikifcd.wiki.opencura.com/prop/P88]
|-
||| || || Carbohydrate, by difference (P89) || [http://wikifcd.wiki.opencura.com/prop/P89]
|-
||| || || Vitamin B-12 (P90) || [http://wikifcd.wiki.opencura.com/prop/P90]
|-
||| || || Cholesterol (P99) || [http://wikifcd.wiki.opencura.com/prop/P99]
|-
||| || || Tocopherol, delta (P100) || [http://wikifcd.wiki.opencura.com/prop/P100]
|-
||| || || Tocotrienol, gamma (P101) || [http://wikifcd.wiki.opencura.com/prop/P101]
|-
||| || || Tocotrienol, delta (P102) || [http://wikifcd.wiki.opencura.com/prop/P102]
|-
||| || || Sugars, total including NLEA (P104) || [http://wikifcd.wiki.opencura.com/prop/P104]
|-
||| || || Vitamin E (alpha-tocopherol) (P105) || [http://wikifcd.wiki.opencura.com/prop/P105]
|-
||| || || Tocopherol, beta (P106) || [http://wikifcd.wiki.opencura.com/prop/P106]
|-
||| || || Tocopherol, gamma (P107) || [http://wikifcd.wiki.opencura.com/prop/P107]
|-
||| || || Tocotrienol, alpha (P108) || [http://wikifcd.wiki.opencura.com/prop/P108]
|-
||| || || Tocotrienol, beta (P109) || [http://wikifcd.wiki.opencura.com/prop/P109]
|-
||| || || Fatty acids, total monounsaturated (P119) || [http://wikifcd.wiki.opencura.com/prop/P119]
|-
||| || || 8:0 (P124) || [http://wikifcd.wiki.opencura.com/prop/P124]
|-
||| || || 10:0 (P125) || [http://wikifcd.wiki.opencura.com/prop/P125]
|-
||| || || 12:0 (P126) || [http://wikifcd.wiki.opencura.com/prop/P126]
|-
||| || || 14:0 (P127) || [http://wikifcd.wiki.opencura.com/prop/P127]
|-
||| || || 16:0 (P128) || [http://wikifcd.wiki.opencura.com/prop/P128]
|-
||| || || 18:0 (P129) || [http://wikifcd.wiki.opencura.com/prop/P129]
|-
||| || || 20:0 (P130) ||[http://wikifcd.wiki.opencura.com/prop/P130]
|-
||| || || 18:1 (P131) || [http://wikifcd.wiki.opencura.com/prop/P131]
|-
||| || || 18:2 (P132) || [http://wikifcd.wiki.opencura.com/prop/P132]
|-
||| || || 18:3 (P133) || [http://wikifcd.wiki.opencura.com/prop/P133]
|-
||| || || 20:4 (P134) || [http://wikifcd.wiki.opencura.com/prop/P134]
|-
||| || || 22:0 (P136) || [http://wikifcd.wiki.opencura.com/prop/P136]
|-
||| || || 14:1 (P137) || [http://wikifcd.wiki.opencura.com/prop/P137]
|-
||| || || 16:1 (P138) || [http://wikifcd.wiki.opencura.com/prop/P138]
|-
||| || || 20:1 (P140) || [http://wikifcd.wiki.opencura.com/prop/P140]
|-
||| || || 15:0 (P154) || [http://wikifcd.wiki.opencura.com/prop/P154]
|-
||| || || 17:0 (P155) || [http://wikifcd.wiki.opencura.com/prop/P155]
|-
||| || || 20:2 n-6 c,c (P165) || [http://wikifcd.wiki.opencura.com/prop/P165]
|-
||| || || 18:3 n-6 c,c,c (P170) || [http://wikifcd.wiki.opencura.com/prop/P170]
|-
||| || || 17:1 (P171) || [http://wikifcd.wiki.opencura.com/prop/P171]
|-
||| || || 20:3 (P172) || [http://wikifcd.wiki.opencura.com/prop/P172]
|-
||| || || 15:1 (P177) || [http://wikifcd.wiki.opencura.com/prop/P177]
|-
||| || || Starch (P218) || [http://wikifcd.wiki.opencura.com/prop/P218]
|-
||| || || Fatty acids, total trans (P271) || [http://wikifcd.wiki.opencura.com/prop/P271]
|}


= Questions =
= Questions =


* Some databases are published in multiple languages. How should we deal with any discrepancies between the translation by the organizations and by Wikidata? (e.g Japanese databases are available in English and Japanese)
* Some databases are published in multiple languages. How should we deal with any discrepancies between the translation by the organizations and by Wikidata? (e.g Japanese databases are available in English and Japanese)
** I think we will be able to present multiple aliases/ multiple values for names. Some of these may conflict, but each will have a reference back to the source. If our group can determine something is incorrect, we can deprecate it.
* Some databases state that they borrow data from other databases but do not specify exactly which items were borrowed. How should we deal with this? (e.g. Bangladesh FCT 2013)
* Some databases state that they borrow data from other databases but do not specify exactly which items were borrowed. How should we deal with this? (e.g. Bangladesh FCT 2013)
** This is my current working model [https://wikifcd.wiki.opencura.com/wiki/Item:Q135079]. I am using stated in for the FCT where we found the value and based on for the source they note. How does this seem to you? It is very tricky because sometimes we don't have enough information to decide what to do here.
* In Wikidata, we can add values without adding references but is it possible to make it a requirement to have at least one reference on WikiFCD?
* In Wikidata, we can add values without adding references but is it possible to make it a requirement to have at least one reference on WikiFCD?
** Yes, this is possible.
* We discussed this before but I forgot the conclusion - do we create different items for the same fruits from different databases (e.g. Apple)?
* We discussed this before but I forgot the conclusion - do we create different items for the same fruits from different databases (e.g. Apple)?
** We create a single item for a food item and then statements from all different databases are placed on that item.
* Is it easy to have Recoin on WikiFCD?
** Not sure about this. I haven't seen it available for wikibases yet. I'll keep looking.
* Perhaps we can add some of the identifier properties from [https://www.wikidata.org/wiki/Wikidata:WikiProject_Medicine/Properties WikiProject_Medicine]?
** My current plan is get this data via federated SPARQL queries with Wikidata.
Please note that all contributions to WikiDotMako are considered to be released under the Attribution-Share Alike 3.0 Unported (see WikiDotMako:Copyrights for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:

Cancel Editing help (opens in new window)