Alcohol/Wine: Difference between revisions

From Open Food Facts wiki
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:
All things wine related
<< 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.


* https://world.openfoodfacts.org/category/wines
=== 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


===French Labelling ===
== 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:




=== Spanish labelling ===
=== 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


=== Useful wine queries on Open Food Facts ===
== Help categorize wines using Hunger Games ==
*Products that are named wines but don’t have a wine category
{| class="wikitable"
**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
! style="vertical-align:bottom;" | en:wine-based-drinks
**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
! style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wine-based-drinks
*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
| style="vertical-align:bottom;" | en:wines
*Products that have a year but don’t have a wine category
| style="text-align:center; text-decoration:underline; color:#00E;" | https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines
**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
| style="vertical-align:bottom;" | en:sparkling-wines
**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
| 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
|}


=== Useful wine queries on Wikidata ===
== 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.
Wines category on Open Food Facts world
Join the discussion on the #Wine slack channel
đŸ· wine label on the Open Food Facts server repository

Crash course on French wines

Tube map of French wines

Useful wine queries on Open Food 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

en:wine-based-drinks https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wine-based-drinks
en:wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines
en:sparkling-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:sparkling-wines
en:red-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:red-wines
en:organic-red-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:organic-red-wines
en:10-red-wine https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:10-red-wine
en:12-red-wine https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:12-red-wine
en:13-red-wine https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:13-red-wine
en:white-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:white-wines
en:dessert-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:dessert-wines
en:flavoured-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:flavoured-wines
en:wines-from-france https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-france
en:burgundy-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:burgundy-wines
en:medoc-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:medoc-wines
en:wines-from-australia https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-australia
en:wines-from-chile https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-chile
en:wines-from-germany https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-germany
en:wines-from-italy https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-italy
en:wines-from-portugal https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-portugal
en:wines-from-spain https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wines-from-spain
en:fortified-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:fortified-wines
en:sweet-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:sweet-wines
en:11-white-wine https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:11-white-wine
en:11-dry-white-wine https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:11-dry-white-wine
en:fortified-wines-such-as-natural-sweet-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:fortified-wines-such-as-natural-sweet-wines
en:rose-wines https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:rose-wines
en:cockerel-in-red-wine-sauce https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:cockerel-in-red-wine-sauce
en:mackerel-fillets-in-white-wine-and-herbs https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:mackerel-fillets-in-white-wine-and-herbs
en:wine-vinegars https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:wine-vinegars
en:red-wine-vinegars https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:red-wine-vinegars
en:white-wine-vinegars https://hunger.openfoodfacts.org/questions?type=category&value_tag=en:white-wine-vinegars

References

  1. ↑ 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).