Alcohol/Wine: Difference between revisions
No edit summary |
No edit summary Tags: Mobile edit Mobile web edit  |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<< Back to [[Alcohol]]<br><br> | |||
 | |||
=== Introduction === | |||
* We try to collect as many bottles as possibles. | |||
* We try to collaborate with OpenWines (more focused on wine data, beyond merely packaging) and Wikidata (focused on AOC, and labelled wines) to improve wine support. | |||
 | |||
{{Box | |||
| 1Â Â =Â ''Wines'' category on Open Food Facts world | |||
| 2Â Â =Â [https://world.openfoodfacts.org/category/wines "Wines"] | |||
}} | |||
 | |||
{{Box | |||
| 1Â Â =Â Join the discussion on the #Wine slack channel | |||
| 2Â Â =Â [https://openfoodfacts.slack.com/messages/wine/ #wine] | |||
}} | |||
 | |||
{{Box | |||
| 1Â Â =Â ''đ· wine'' label on the Open Food Facts server repository | |||
| 2Â Â =Â [https://github.com/openfoodfacts/openfoodfacts-server/labels/%F0%9F%8D%B7%20wine đ· wine] | |||
}} | |||
 | |||
=== Crash course on French wines === | |||
[http://www.agrotic.org/blog/wp-content/uploads/2013/01/carte-des-vins-de-france.jpg Tube map of French wines] | |||
 | |||
=== Useful wine queries on Open Food Facts === | |||
*Products that are named wines but donât have a wine category | |||
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | |||
*Products that contain alcohol but have no categories | |||
**http://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&nutriment_0=alcohol&nutriment_compare_0=gt&nutriment_value_0=0&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&page=1 | |||
*Products that are named chateau but donât have a wine category | |||
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=chateau&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | |||
*Products that have a year but donât have a wine category | |||
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=2012&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | |||
* Wine products needing a category for Open Wine Facts | |||
**http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | |||
 | |||
=== Useful wine queries on Wikidata === | |||
* http://tools.wmflabs.org/wikidata-todo/tree.html?q=40050&rp=279 | |||
 | |||
=== OpenWines === | |||
OpenWines has done some bottle scanning of their own. We need to collaborate more, offer our data and collect theirs. | |||
=== Linking Wine categories with Open Street Maps wine regions === | === Linking Wine categories with Open Street Maps wine regions === | ||
http://world.openfoodfacts.org/category/fr:fitou | http://world.openfoodfacts.org/category/fr:fitou | ||
| Line 9: | Line 48: | ||
https://www.openstreetmap.org/relation/2727716 | https://www.openstreetmap.org/relation/2727716 | ||
=== | == Labelling == | ||
===France === | |||
http://www.economie.gouv.fr/dgccrf/Publications/Vie-pratique/Fiches-pratiques/Etiquetage-des-vins | http://www.economie.gouv.fr/dgccrf/Publications/Vie-pratique/Fiches-pratiques/Etiquetage-des-vins | ||
| Line 57: | Line 97: | ||
=== | === Spain === | ||
Found that on a Spanish organic wine bottle | Found that on a Spanish organic wine bottle | ||
The QR code is nice. http://1cha.org:8012/OS.aspx?C=127878747 | The QR code is nice. http://1cha.org:8012/OS.aspx?C=127878747 | ||
They seem to have a database here http://ogasearch.food.cnca.cn/oga/query/index.jsp | They seem to have a database here http://ogasearch.food.cnca.cn/oga/query/index.jsp | ||
=== | == Help categorize wines using Hunger Games == | ||
{| class="wikitable" | |||
|- | |||
! style="vertical-align:bottom;" | en:wine-based-drinks | |||
! style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wine-based-drinks | |||
|- | |||
| style="vertical-align:bottom;" | en:wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines | |||
|- | |||
| style="vertical-align:bottom;" | en:sparkling-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:sparkling-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:red-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:red-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:organic-red-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:organic-red-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:10-red-wine | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:10-red-wine | |||
|- | |||
| style="vertical-align:bottom;" | en:12-red-wine | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:12-red-wine | |||
|- | |||
| style="vertical-align:bottom;" | en:13-red-wine | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:13-red-wine | |||
|- | |||
| style="vertical-align:bottom;" | en:white-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:white-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:dessert-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:dessert-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:flavoured-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:flavoured-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:wines-from-france | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-france | |||
|- | |||
| style="vertical-align:bottom;" | en:burgundy-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:burgundy-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:medoc-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:medoc-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:wines-from-australia | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-australia | |||
|- | |||
| style="vertical-align:bottom;" | en:wines-from-chile | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-chile | |||
|- | |||
| style="vertical-align:bottom;" | en:wines-from-germany | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-germany | |||
|- | |||
| style="vertical-align:bottom;" | en:wines-from-italy | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-italy | |||
|- | |||
| style="vertical-align:bottom;" | en:wines-from-portugal | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-portugal | |||
|- | |||
| style="vertical-align:bottom;" | en:wines-from-spain | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-spain | |||
|- | |||
| style="vertical-align:bottom;" | en:fortified-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:fortified-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:sweet-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:sweet-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:11-white-wine | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:11-white-wine | |||
|- | |||
| style="vertical-align:bottom;" | en:11-dry-white-wine | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:11-dry-white-wine | |||
|- | |||
| style="vertical-align:bottom;" | en:fortified-wines-such-as-natural-sweet-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:fortified-wines-such-as-natural-sweet-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:rose-wines | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:rose-wines | |||
|- | |||
| style="vertical-align:bottom;" | en:cockerel-in-red-wine-sauce | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:cockerel-in-red-wine-sauce | |||
|- | |||
| style="vertical-align:bottom;" | en:mackerel-fillets-in-white-wine-and-herbs | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:mackerel-fillets-in-white-wine-and-herbs | |||
|- | |||
| style="vertical-align:bottom;" | en:wine-vinegars | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wine-vinegars | |||
|- | |||
| style="vertical-align:bottom;" | en:red-wine-vinegars | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:red-wine-vinegars | |||
|- | |||
| style="vertical-align:bottom;" | en:white-wine-vinegars | |||
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:white-wine-vinegars | |||
|} | |||
== | == References == | ||
 <references/> |  <references/> | ||
[[Category:Alcohol]] | [[Category:Alcohol]] | ||
[[Category:Category analysis]] | |||
Latest revision as of 14:32, 13 August 2024
<< Back to Alcohol
Introduction
- We try to collect as many bottles as possibles.
- We try to collaborate with OpenWines (more focused on wine data, beyond merely packaging) and Wikidata (focused on AOC, and labelled wines) to improve wine support.
|
|---|
|
|---|
|
|---|
Crash course on French wines
Useful wine queries on Open Food Facts
- Products that are named wines but donât have a wine category
- Products that contain alcohol but have no categories
- Products that are named chateau but donât have a wine category
- Products that have a year but donât have a wine category
- Wine products needing a category for Open Wine Facts
Useful wine queries on Wikidata
OpenWines
OpenWines has done some bottle scanning of their own. We need to collaborate more, offer our data and collect theirs.
Linking Wine categories with Open Street Maps wine regions
http://world.openfoodfacts.org/category/fr:fitou >>> https://www.wikidata.org/wiki/Q470974 >> https://www.openstreetmap.org/relation/2727716
Labelling
France
http://www.economie.gouv.fr/dgccrf/Publications/Vie-pratique/Fiches-pratiques/Etiquetage-des-vins
CRD cap colors
La couleur de la capsule CRD permet de distinguer le niveau d'appellation d'un vin.
| Verte | Vins tranquilles ou mousseux répondant à la définition des vins de qualité produits dans des régions déterminées (VQPRD) qui comprennent, notamment, les appellations d'origine contrÎlée (AOC) et les vins délimités de qualité supérieure (VDQS). |
| Bleue | Les autres vins y compris les boissons fiscalement assimilées au vin (Vin de pays et Vins de table). |
| Rouge lie-de-vin | Permet de remplacer pour le vin (depuis l'ArrĂȘtĂ© du 5 juillet 2011) les capsules verte et bleue, mais exclut les vins mousseux Ă appellation dâorigine contrĂŽlĂ©e « Champagne », les vins doux naturels Ă appellation dâorigine contrĂŽlĂ©e, et les boissons fiscalement assimilĂ©es au vin. |
| Orange | Alcools intermĂ©diaires bĂ©nĂ©ficiant dâune appellation dâorigine contrĂŽlĂ©e (Vins spĂ©ciaux et Vins de liqueur). |
| Jaune | Le cognac et lâarmagnac. |
| Grise | Autres produits intermédiaires (ratafia...). |
| Rouge | Le rhum traditionnel des DOM . |
| Blanche | Autres alcools. |
Data
Sur la couronne apparait une référence type "83 R 036". Elle donne plusieurs informations.
- Le premier numéro à deux chiffres fait référence au département du siÚge de l'embouteilleur ou du répartiteur de capsules (pour les capsules collectives). Il s'agit souvent, mais pas toujours, du département de production.
- La lettre fait référence à la qualification de l'embouteilleur (parfois écrite en toutes lettres). On peut trouver trois lettres différentes :
- R ou « Récoltant » en toutes lettres
- N (pour « Non-récoltant ») ou « Négociant » en toutes lettres
- E pour « Entrepositaire agrĂ©Ă© » (et non pas « Ăleveur »)
Jusqu'en 2001, on ne trouvait que les mentions R ou N ; depuis, la mention E est possible comme synonyme de N[1]. Certains récoltants mentionnent le nom de leur domaine.
- le second numéro est le numéro administratif d'agrément de l'embouteilleur ou du répartiteur de capsules collectives (dans ce dernier cas il s'agit la plupart du temps des nombres "01" ou "02").
Autour de Marianne, on trouvera une information sur la contenance de la bouteille ainsi que les mentions République Française et D.G.D.D.I.
Spain
Found that on a Spanish organic wine bottle The QR code is nice. http://1cha.org:8012/OS.aspx?C=127878747 They seem to have a database here http://ogasearch.food.cnca.cn/oga/query/index.jsp
Help categorize wines using Hunger Games
References
- â Le code des douanes dispose que « Pour les rĂ©coltants, le numĂ©ro dâagrĂ©ment comporte la lettre R. Pour les non-rĂ©coltants, le numĂ©ro dâagrĂ©ment comporte la lettre N ou E, Ă la convenance de lâopĂ©rateur. » (texte Template:N°01-138, section IV « Capsules reprĂ©sentatives de droits », paragraphe 118).