Aire géographique des appellations d'origine contrôlée (AOC)/protégée (AOP) et IGP sur Bordeaux Métropole

Name: Aire géographique des appellations d'origine contrôlée (AOC)/protégée (AOP) et IGP sur Bordeaux Métropole
Creator: opendatasoft

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

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?

fair

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 7 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: 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 2ci: 33487 · art: —

{
  "ci": "33487",
  "art": null,
  "ida": "1602",
  "actual": 1,
  "commune": "Saint-Vincent-de-Paul",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Agneau de Pauillac",
  "date_maj": "2010-01-13T16:20:22+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "13421",
  "reference": "IG/16/97",
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.97392234250055,
    "lon": -0.4818570034027279
  },
  "aire_geographique": "Agneau de Pauillac"
}

Record 3ci: 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 4ci: 33065 · art: —

{
  "ci": "33065",
  "art": null,
  "ida": "1602",
  "actual": 1,
  "commune": "Bouliac",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Agneau de Pauillac",
  "date_maj": "2010-01-13T16:20:22+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "13421",
  "reference": "IG/16/97",
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.816673008528966,
    "lon": -0.5042763414939322
  },
  "aire_geographique": "Agneau de Pauillac"
}

Record 5ci: 33434 · art: —

{
  "ci": "33434",
  "art": null,
  "ida": "1969",
  "actual": 1,
  "commune": "Saint-Louis-de-Montferrand",
  "nom_reg": "Nouvelle-Aquitaine",
  "produit": "Atlantique rouge",
  "date_maj": "2015-11-09T10:09:15+00:00",
  "dep_code": "33",
  "signe_fr": null,
  "signe_ue": "IGP -",
  "idproduit": "8846",
  "reference": null,
  "departement": "GIRONDE",
  "geo_point_2d": {
    "lat": 44.9577537957606,
    "lon": -0.5330776110367813
  },
  "aire_geographique": "Atlantique"
}

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 7 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.