Line 1:
Line 1:
−
All things wine related
+
<< Back to [[Alcohol]]<br><br>
+
=== Introduction ===
* https://world.openfoodfacts.org/category/wines
* https://world.openfoodfacts.org/category/wines
+
* 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 ===
=== Crash course on French wines ===
−
http://www.agrotic.org/blog/wp-content/uploads/2013/01/carte-des-vins-de-france.jpg
+
[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 ===
+
=== 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 11:
Line 33:
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 59:
Line 82:
−
=== 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 ===
−
*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 ===
=== References ===
=== References ===
<references/>
<references/>
[[Category:Alcohol]]
[[Category:Alcohol]]