River damming/staging rate targets - SAGE Loire EstuaryObjectifs du taux d'étagement des cours d'eau du SAGE Estuaire de la Loire

Objectifs du taux d'étagement des cours d'eau du SAGE Estuaire de la LoireRiver damming/staging rate targets - SAGE Loire Estuary

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This dataset provides target values for the river damming rate ("taux d'étagement") within the SAGE Loire Estuary water management area in western France. The indicator is calculated as the ratio between the total fall height of structures that create a hydraulic impoundment (weirs, dams, spillways, etc.) and the total natural elevation drop of the watercourse, expressed as a percentage. It serves as a measure of hydromorphological alteration of rivers. The data is published on the Pays de la Loire regional open data portal and supports water management and ecological status monitoring under the SAGE framework.Le taux d’étagement est égal au rapport de la somme des hauteurs de chute des ouvrages qui créent une retenue hydraulique (seuils, barrages, déversoirs, etc.) sur la hauteur totale du dénivelé naturel du cours d’eau (en %). Il constitue ainsi un indicateur de la modification de l’hydromorphologie...

environment

⬇ 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 (15 fields)

Filterable via the API (13)

id_grd_trnom_hyaxe_colocomm_te_code_me_nom_meval_tecom_ftecom_diagtedia_tegtprio_etaobj_etagobj_libel

Click a field to see example values.

Fill	Field	Type	Description
—	geo_point_2dGeo Point	geo_point_2d	Geographic centroid coordinates of the river segment.Geographic centroid coordinates of the river segment.
—	geo_shapeShape	geo_shape	Geometric shape of the river segment.Geometric shape of the river segment.
—	id_grd_tridentifiant du tronçon	double	Identifier of the river reach (tronçon).Identifier of the river reach (tronçon).
—	nom_hynom du cours d'eau	text	Name of the watercourse.Name of the watercourse.
—	axe_coloaxe de colonisation migrateurs	text	Indicates whether the reach is a migratory fish colonization axis.Indicates whether the reach is a migratory fish colonization axis.
—	comm_tecommentaire taux étagement	text	Comment on the reliability of the étagement rate value.Comment on the reliability of the étagement rate value.
—	_code_meCode de la masse d'eau concernée	text	Code of the associated water body.Code of the associated water body.
—	_nom_menom de la masse d'eau concernée	text	Name of the associated water body.Name of the associated water body.
—	val_tevaleur taux étagement	double	Measured étagement rate value, as a percentage.Measured étagement rate value, as a percentage.
—	com_ftefiabilité taux étagement	text	Reliability assessment of the étagement rate.Reliability assessment of the étagement rate.
91.2%	com_diagtecommentaire diagnostic étagement	text	Comment on the étagement diagnostic method or scope.Comment on the étagement diagnostic method or scope.
100%	dia_tegtrésultat diagnostic étagement	text	Result of the étagement diagnostic assessment.Result of the étagement diagnostic assessment.
100%	prio_etapriorité étagement	text	Priority level assigned for addressing étagement.Priority level assigned for addressing étagement.
56.7%	obj_etagniveau objectif étagement	double	Target étagement rate objective, as a percentage.Target étagement rate objective, as a percentage.
100%	obj_libelObjectif	text	Label describing the étagement reduction objective.Label describing the étagement reduction objective.

Schema captured from opendatasoft 4 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)

These rows are ODbL-1.0: share-alike. Reusing them obliges you to license any derived database on the same terms.

Record 1nom_hy: Le Tenu amont · val_te: 9999

{
  "nom_hy": "Le Tenu amont",
  "val_te": 9999,
  "_nom_me": "LE TENU ET SES AFFLUENTS DEPUIS LA SOURCE JUSQU'A SAINT-ETIENNE-DE-MER-MORTE",
  "com_fte": "Diagnostic trop partiel : manque nombreuses infos sur hchute.",
  "comm_te": "calcul partiel  : manque nombreuses infos sur hchute",
  "_code_me": "FRGR1542",
  "axe_colo": "oui",
  "dia_tegt": "données trop partielles ou absentes",
  "obj_etag": 0.4,
  "prio_eta": "1",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 100,
  "obj_libel": "objectif de réduction à 40%",
  "com_diagte": "Diagnosic complémentaire en cours.",
  "geo_point_2d": {
    "lat": 46.96554593068286,
    "lon": -1.680558896563394
  }
}

Record 2nom_hy: L'Etier de Cordemais · val_te: 0

{
  "nom_hy": "L'Etier de Cordemais",
  "val_te": 0,
  "_nom_me": "L'ETIER DE CORDEMAIS ET SES AFFLUENTS DEPUIS LA SOURCE JUSQU'A L'ESTUAIRE DE LA LOIRE",
  "com_fte": "valeur fiable",
  "comm_te": "valeur fiable",
  "_code_me": "FRGR1608",
  "axe_colo": "oui",
  "dia_tegt": "Absence d'étagement",
  "obj_etag": null,
  "prio_eta": "0",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 2700,
  "obj_libel": "absence d'étagement",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.323443648912175,
    "lon": -1.8871425523465437
  }
}

Record 3nom_hy: La Loire · val_te: 0

{
  "nom_hy": "La Loire",
  "val_te": 0,
  "_nom_me": "La Loire",
  "com_fte": "valeur fiable",
  "comm_te": "valeur fiable",
  "_code_me": "FRGT28",
  "axe_colo": "oui",
  "dia_tegt": "Absence d'étagement",
  "obj_etag": null,
  "prio_eta": "0",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 4500,
  "obj_libel": "absence d'étagement",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.27142104369616,
    "lon": -1.6496916376234836
  }
}

Record 4nom_hy: ruisseau de l'étang de Chavagne · val_te: 0.21

{
  "nom_hy": "ruisseau de l'étang de Chavagne",
  "val_te": 0.21,
  "_nom_me": "L'ERDRE DEPUIS LE PLAN D'EAU DE L'ERDRE JUSQU'A L'ESTUAIRE DE LA LOIRE",
  "com_fte": "valeur fiable",
  "comm_te": "valeur fiable",
  "_code_me": "FRGR0539b",
  "axe_colo": "oui",
  "dia_tegt": "Etagement moyen",
  "obj_etag": 0.2,
  "prio_eta": "2",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 9000,
  "obj_libel": "objectif de réduction à 20%",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.36507190857111,
    "lon": -1.5252751932757262
  }
}

Record 5nom_hy: ruisseau du pas Denion · val_te: 0

{
  "nom_hy": "ruisseau du pas Denion",
  "val_te": 0,
  "_nom_me": "LE HOCMARD ET SES AFFLUENTS DEPUIS LA SOURCE JUSQU'A SA CONFLUENCE AVEC L'ERDRE",
  "com_fte": "valeur fiable",
  "comm_te": "valeur fiable",
  "_code_me": "FRGR0540",
  "axe_colo": "oui",
  "dia_tegt": "Absence d'étagement",
  "obj_etag": null,
  "prio_eta": "0",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 8900,
  "obj_libel": "absence d'étagement",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.35714465532612,
    "lon": -1.5722845666277263
  }
}

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

Verification Status

Using the API

Configuration

Base URL: https://data.paysdelaloire.fr/api/explore/v2.1/catalog/datasets/200055127_objectif_tx_etagement_sageel_2024

License

Open Data Commons Open Database License 1.0Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://data.paysdelaloire.fr/api/explore/v2.1/catalog/datasets/200055127_objectif_tx_etagement_sageel_2024/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

5 000 req/day

per ipmeasured

observed 4 days ago

Dataset

Volume & freshness

Records

171

Last upstream update

1 year ago

2025-09-12

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.