Geographic area of protected designation of origin (PDO/AOC) and protected geographical indication (PGI) labels within Bordeaux MétropoleAire géographique des appellations d'origine contrôlée (AOC)/protégée (AOP) et IGP sur Bordeaux Métropole

Aire géographique des appellations d'origine contrôlée (AOC)/protégée (AOP) et IGP sur Bordeaux MétropoleGeographic area of protected designation of origin (PDO/AOC) and protected geographical indication (PGI) labels within Bordeaux Métropole

APIDiscovered1/7blocked by verifiedQuery nowOpen workbench Subscribe🇫🇷France

Website Docs

This dataset, published via the Bordeaux Métropole open data portal, lists for each municipality within the metropolitan area the geographic zones covered by controlled/protected designation of origin labels (AOC/AOP) and protected geographical indications (IGP). For each geographic zone, it also identifies the associated agricultural or food products. The data provides a municipality-by-municipality view of officially recognized origin and quality labels applying across Bordeaux Métropole, useful for identifying which local products benefit from protected designation status in specific communes.Ce fichier liste, pour chaque commune de la métropole de Bordeaux, les aires géographiques des appellations d'origine contrôlée (AOC)/protégée (AOP) et des indications géographiques protégées (IGP) et, pour chaque aire géographique, les produits qui lui sont rattachés.

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

poor

Weighted across five axes. Tap a ring for what it measures.

Data schema (16 fields)

Filterable via the API (15)

idaaire_geographiquesigne_frsigne_ueidproduitproduitreferencedate_majcidepartementcommuneartactualdep_codenom_reg

Click a field to see example values.

Fill	Field	Type	Description
100%	ida	text	Internal identifier of the geographic area.Internal identifier of the geographic area.
100%	aire_geographiqueAire geographique	text	Name of the geographic area for the AOC/AOP/IGP designation.Name of the geographic area for the AOC/AOP/IGP designation.
0%	signe_frSigne fr	text	French quality label or designation type.French quality label or designation type.
100%	signe_ueSigne ue	text	European Union quality designation type, such as IGP or AOP.European Union quality designation type, such as IGP or AOP.
100%	idproduit	text	Internal identifier of the product.Internal identifier of the product.
100%	produit	text	Name of the product linked to the geographic area.Name of the product linked to the geographic area.
39.3%	referenceRéférence	text	Official reference or legal text for the designation.Official reference or legal text for the designation.
91.3%	date_majDate maj	datetime	Date the record was last updated.Date the record was last updated.
100%	ci	text	INSEE code of the commune.INSEE code of the commune.
100%	departementDépartement	text	Name of the French department.Name of the French department.
—	communeCommune	text	Name of the commune.Name of the commune.
—	art	text	Article reference related to the designation's legal text.Article reference related to the designation's legal text.
—	actual	int	Indicator of whether the record is currently active.Indicator of whether the record is currently active.
—	dep_codeDep code	text	Numeric code of the French department.Numeric code of the French department.
—	geo_point_2dGeo Point	geo_point_2d	Geographic coordinates of the commune.Geographic coordinates of the commune.
—	nom_regNom Région	text	Name of the French administrative region.Name of the French administrative region.

Schema captured from opendatasoft 3 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1ci: 33065 · art: —

{
  "ci": "33065",
  "art": null,
  "ida": "1969",
  "actual": 1,
  "commune": "Bouliac",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Atlantique primeur ou nouveau rosé",
  "date_maj": "2015-11-09T10:09:15+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "10379",
  "reference": null,
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.816673008528966,
    "lon": -0.5042763414939322
  },
  "aire_geographique": "Atlantique"
}

Record 2ci: 33487 · art: —

{
  "ci": "33487",
  "art": null,
  "ida": "1969",
  "actual": 1,
  "commune": "Saint-Vincent-de-Paul",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Atlantique rosé",
  "date_maj": "2015-11-09T10:09:15+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "8845",
  "reference": null,
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.97392234250055,
    "lon": -0.4818570034027279
  },
  "aire_geographique": "Atlantique"
}

Record 3ci: 33312 · art: —

{
  "ci": "33312",
  "art": null,
  "ida": "1969",
  "actual": 1,
  "commune": "Parempuyre",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Atlantique primeur ou nouveau rouge",
  "date_maj": "2015-11-09T10:09:15+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "10380",
  "reference": null,
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.95386505553621,
    "lon": -0.5804234748438306
  },
  "aire_geographique": "Atlantique"
}

Record 4ci: 33312 · art: —

{
  "ci": "33312",
  "art": null,
  "ida": "1567",
  "actual": 1,
  "commune": "Parempuyre",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Volailles des Landes",
  "date_maj": "2012-07-12T11:14:54+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "3439",
  "reference": "IG/20/94",
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.95386505553621,
    "lon": -0.5804234748438306
  },
  "aire_geographique": "Volailles des Landes"
}

Record 5ci: 33065 · art: —

{
  "ci": "33065",
  "art": null,
  "ida": "1527",
  "actual": 1,
  "commune": "Bouliac",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Canard à foie gras du Sud-Ouest (Chalosse, Gascogne, Gers, Landes, Périgord, Quercy",
  "date_maj": "2017-03-01T07:41:39+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "12949",
  "reference": "IG/06/95",
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.816673008528966,
    "lon": -0.5042763414939322
  },
  "aire_geographique": "Canard à foie gras du Sud-Ouest"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/aire-geographique-des-appellations-d-origine-controlee-aoc-protegee-aop-sur-bm

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/aire-geographique-des-appellations-d-origine-controlee-aoc-protegee-aop-sur-bm/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

10 000 000 req/day

per ipmeasured

observed 3 days ago

Dataset

Volume & freshness

Records

323

Last upstream update

4 years ago

2022-08-10

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.