Line 14: |
Line 14: |
| === Labels === | | === Labels === |
| * Adding the Wikidata item number (QXXXXXX) on the Open Food Facts taxonomy | | * Adding the Wikidata item number (QXXXXXX) on the Open Food Facts taxonomy |
| + | * https://www.wikidata.org/wiki/Wikidata:Property_proposal/Open_Food_Facts_label |
| === Additives === | | === Additives === |
| * Marking additives as "instance of" food additives, or better yet, in the sub category | | * Marking additives as "instance of" food additives, or better yet, in the sub category |
| * Adding the Wikidata item number (QXXXXXX) on the Open Food Facts taxonomy | | * Adding the Wikidata item number (QXXXXXX) on the Open Food Facts taxonomy |
| + | * https://query.wikidata.org/embed.html#%23Cats%0ASELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP2093%20%22Cosmetic%20Ingredient%20Review%20Expert%20Panel%22.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D |
| === Ingredients === | | === Ingredients === |
| + | |
| + | === Diets === |
| + | Diets on Wikidata: https://tools.wmflabs.org/wikidata-todo/tree.html?q=474191&rp=279,31 |
| | | |
| === Stores === | | === Stores === |
| * https://bmericskay.github.io/portfolio/Disgressions.html | | * https://bmericskay.github.io/portfolio/Disgressions.html |
| * https://twitter.com/BorisMericskay/status/1315213965333495808?s=09 | | * https://twitter.com/BorisMericskay/status/1315213965333495808?s=09 |
| + | |
| + | == Getting information into Wikidata == |
| + | |
| + | * Mix and Match for food and eating catalogs: https://mix-n-match.toolforge.org/#/group/ig_wikidata_property_related_to_food_and_eating |
| + | * <nowiki>https://www.wikidata.org/wiki/Wikidata:WikiProject_Spain/Alimentos_de_Espa%C3%B1a</nowiki> |
| + | * https://www.wikidata.org/wiki/Wikidata:Property_proposal/GLN |
| + | * Discussions about country/place adjectives |
| + | ** https://openfoodfacts.slack.com/archives/C081BENER/p1587568951002800 |
| + | ** <nowiki>https://tools.wmflabs.org/lexeme-forms/</nowiki> |
| + | ** <nowiki>https://www.wikidata.org/wiki/Wikidata:Wikidata_Lexeme_Forms</nowiki> |
| + | ** Exemple d'utilisation avec <nowiki>https://tools.wmflabs.org/lexeme-forms/template/french-adjective/</nowiki> |
| + | ** See SPARQL queries for current data |
| + | * <nowiki>https://www.wikidata.org/wiki/Wikidata:Property_proposal/GS1_GPC_brick_code</nowiki> |
| + | * <nowiki>https://www.wikidata.org/wiki/Wikidata:Property_proposal/note</nowiki> |
| + | * <nowiki>https://www.wikidata.org/wiki/Wikidata:Property_proposal/Common_procurement_vocabulary#Discussion</nowiki> |
| + | * add images to food on Wikidata: <nowiki>https://tools.wmflabs.org/fist/wdfist/?sparql=SELECT%20?item%20WHERE%20{%20?item%20wdt:P31%20wd:Q5%20.%20?item%20wdt:P27%20wd:Q889%20}#top</nowiki> |
| + | |
| == Getting information from Wikidata == | | == Getting information from Wikidata == |
| | | |
Line 29: |
Line 51: |
| * brands : http://tools.wmflabs.org/wikidata-todo/tree.html?q=167270&rp=31 | | * brands : http://tools.wmflabs.org/wikidata-todo/tree.html?q=167270&rp=31 |
| * dishes: http://tools.wmflabs.org/wikidata-todo/tree.html?q=746549&rp=279 | | * dishes: http://tools.wmflabs.org/wikidata-todo/tree.html?q=746549&rp=279 |
| + | * https://www.wikidata.org/w/index.php?search=&search=%22as+used+in+cosmetics%22&title=Special:Search&go=Go&ns0=1&ns1=1&ns4=1&ns120=1 |
| + | * |
| + | |
| + | == Food properties == |
| + | |
| + | * barcode property: <nowiki>https://www.wikidata.org/wiki/Property:P3962</nowiki> |
| + | * PLU Code property: <nowiki>https://www.wikidata.org/wiki/Property:P4030</nowiki> |
| + | * INAO: <nowiki>https://www.wikidata.org/wiki/Property:P3895</nowiki> |
| + | |
| + | * https://www.wikidata.org/wiki/Wikidata:Property_proposal/AGROVOC_ID |
| + | * https://www.wikidata.org/wiki/Wikidata:Property_proposal/Forest_Stewardship_Council_Certificate_Code |
| + | * https://www.wikidata.org/wiki/Wikidata:Property_proposal/Forest_Stewardship_Council_License_Code |
| + | |
| + | == Tools == |
| + | Getting a wikidata taxonomy in JSON |
| + | npm install -g wikidata-taxonomy |
| + | wdtaxonomy -d -i -f json 2095 |
| + | <nowiki>https://www.npmjs.com/package/wikidata-taxonomy</nowiki> |
| + | |
| + | == SPARQL == |
| + | For SPARQL queries: <nowiki>https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries#Understanding_SPARQL</nowiki> - |
| + | |
| + | * All cheses made with cow milk: <nowiki>https://query.wikidata.org/#%23Cheeses%0ASELECT%20%3Fitem%20%3FitemLabel%0AWHERE%0A%7B%0A%09%3Fitem%20wdt%3AP279%20wd%3AQ3088299%20.%0A%09SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D</nowiki> |
| + | * EFSA opinions: https://query.wikidata.org/#SELECT%20%3Fitem%20%28SUBSTR%28%3Fpublished1%2C%201%2C%2010%29%20as%20%3Fpublished%20%29%3Fvolume%20%3Fissue%20%3Fpages%20%3Fdoi%20%3Ftitle%20WHERE%20%7B%20%20%0A%20%20%3Fitem%20wdt%3AP1433%20wd%3AQ45098548%20.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP577%20%3Fpublished1%7D%20.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP478%20%3Fvolume%7D%20.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP433%20%3Fissue%7D%20.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP304%20%3Fpages0%7D%20.%20%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP356%20%3Fdoi%7D%20.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP1476%20%3Ftitle%7D%20.%20%0A%20%20BIND%28REPLACE%28%3Fpages0%2C%20%22-%22%2C%20%22%E2%80%93%22%29%20AS%20%3Fpages%29%0A%20%20BIND%28if%28contains%28%3Fpages%2C%20%20%22%E2%80%93%22%29%2C%20strbefore%28%3Fpages%2C%20%22%E2%80%93%22%29%2C%20%3Fpages%29%20as%20%3Fstartpage%29%0A%20%20BIND%28if%28contains%28%3Fpages%2C%20%20%22%E2%80%93%22%29%2C%20strafter%28%3Fpages%2C%20%22%E2%80%93%22%29%2C%20%3Fpages%29%20as%20%3Fendpage%29%0A%7D%0AORDER%20BY%20ASC%28%3Fpublished%29%20ASC%28xsd%3Ainteger%28%3Fissue%29%29%20ASC%28xsd%3Ainteger%28%3Fstartpage%29%29 |
| + | * Country adjectives (for the ingredients parser): https://query.wikidata.org/embed.html#%23Noms%20des%20pays%20d%E2%80%99Afrique%20dans%20leurs%20langues%20officielles%20ainsi%20qu%E2%80%99en%20anglais%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel_ol%20%3Fadjectives%20%3FitemLabel_en%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ6256%20%3B%0A%20%20%20%20%20%20%20%20wdt%3AP1549%20%3Fadjectives.%0A%7D%0AORDER%20BY%20%3Fitem%20%3FitemLabel_lol%20%3Fadjectives |
| | | |
| == Models on the French Wikipedia == | | == Models on the French Wikipedia == |
Line 43: |
Line 90: |
| == Open Products Facts == | | == Open Products Facts == |
| == Open Pet Food Facts == | | == Open Pet Food Facts == |
| + | |
| + | == Other/To investigate == |
| + | https://wikirate.org/The_Coca_Cola_Company |
| [[Category:Structured Data]] | | [[Category:Structured Data]] |