Objectifs du taux d'étagement des cours d'eau du SAGE Estuaire de la Loire

Name: Objectifs du taux d'étagement des cours d'eau du SAGE Estuaire de la Loire
Creator: opendatasoft

APIQuery nowOpen workbench🇫🇷France

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

⬇ Export CSV List records Select & filter API base URL Read the docs

Trust score

How is this computed?

poor

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	—
—	geo_shapeShape	geo_shape	—
—	id_grd_tridentifiant du tronçon	double	—
—	nom_hynom du cours d'eau	text	—
—	axe_coloaxe de colonisation migrateurs	text	—
—	comm_tecommentaire taux étagement	text	—
—	_code_meCode de la masse d'eau concernée	text	—
—	_nom_menom de la masse d'eau concernée	text	—
—	val_tevaleur taux étagement	double	—
—	com_ftefiabilité taux étagement	text	—
91.2%	com_diagtecommentaire diagnostic étagement	text	—
100%	dia_tegtrésultat diagnostic étagement	text	—
100%	prio_etapriorité étagement	text	—
56.7%	obj_etagniveau objectif étagement	double	—
100%	obj_libelObjectif	text	—

Schema captured from opendatasoft 1 hour 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 1nom_hy: ruisseau du Mont Tieber · val_te: 0

{
  "nom_hy": "ruisseau du Mont Tieber",
  "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": 6200,
  "obj_libel": "absence d'étagement",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.31830602432289,
    "lon": -1.8420841846483078
  }
}

Record 2nom_hy: ruisseau du gué aux Biches (canal de la · val_te: 0.38

{
  "nom_hy": "ruisseau du gué aux Biches (canal de la Fleur)",
  "val_te": 0.38,
  "_nom_me": "LE BRIVET ET SES AFFLUENTS DEPUIS LA SOURCE JUSQU'A DREFFEAC",
  "com_fte": "valeur fiable",
  "comm_te": "valeur fiable",
  "_code_me": "FRGR1563",
  "axe_colo": "oui",
  "dia_tegt": "Etagement moyen",
  "obj_etag": 0.2,
  "prio_eta": "2",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 3100,
  "obj_libel": "objectif de réduction à 20%",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.50871307587267,
    "lon": -2.081992840478322
  }
}

Record 3nom_hy: ruisseau de la la Chapellerie · val_te: 0

{
  "nom_hy": "ruisseau de la la Chapellerie",
  "val_te": 0,
  "_nom_me": "LE HAVRE ET SES AFFLUENTS DEPUIS LA SOURCE JUSQU'A L'ESTUAIRE DE LA LOIRE",
  "com_fte": "valeur fiable",
  "comm_te": "valeur fiable",
  "_code_me": "FRGR0537",
  "axe_colo": "oui",
  "dia_tegt": "Absence d'étagement",
  "obj_etag": null,
  "prio_eta": "0",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 47000,
  "obj_libel": "absence d'étagement",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.39330053221464,
    "lon": -1.2662413199545515
  }
}

Record 4nom_hy: Ruisseau de l'étang de Sandun (canal de · val_te: 0.59

{
  "nom_hy": "Ruisseau de l'étang de Sandun (canal de Breca)",
  "val_te": 0.59,
  "_nom_me": "LA GRANDE DOUE ET SES AFFLUENTS DEPUIS LA SOURCE JUSQU'A SA CONFLUENCE AVEC LE BRIVET",
  "com_fte": "valeur fiable",
  "comm_te": "valeur fiable",
  "_code_me": "FRGR1610",
  "axe_colo": "oui",
  "dia_tegt": "Etagement fort",
  "obj_etag": 0.4,
  "prio_eta": "1",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 7600,
  "obj_libel": "objectif de réduction à 40%",
  "com_diagte": "diagnostic exhaustif",
  "geo_point_2d": {
    "lat": 47.34343343976787,
    "lon": -2.3555670016527475
  }
}

Record 5nom_hy: le Cens · val_te: 9999

{
  "nom_hy": "le Cens",
  "val_te": 9999,
  "_nom_me": "FRGR0542",
  "com_fte": "diagnostic trop partiel : manque nombreuses infos sur hchute, calcul impossible",
  "comm_te": "report des val drain principal : diag trop partiel",
  "_code_me": "FRGR0542",
  "axe_colo": "oui",
  "dia_tegt": "données trop partielles ou absentes",
  "obj_etag": 0,
  "prio_eta": "0",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            -1.571788516965073,
            47.24690539696396
          ],
          [
            -1.571550928303193,
            47.246983071029156
          ],
          [
            -1.571477854126226,
            47.246998940566435
          ],
          [
            -1.570672167455383,
            47.247084062874414
          ],
          [
            -1.57052357478403,
            47.24708397457614
          ],
          [
            -1.570065418341907,
            47.24705646215748
          ],
          [
            -1.569992096072373,
            47.2470476320546
          ],
          [
            -1.569526772328779,
            47.24696117060843
          ],
          [
            -1.569426470766446,
            47.24693563964992
          ],
          [
            -1.56882393984393,
            47.246718365001584
          ],
          [
            -1.568735974080981,
            47.246675934712925
          ],
          [
            -1.568109374485706,
            47.24624999189314
          ],
          [
            -1.568023016272259,
            47.24616727885547
          ],
          [
            -1.567743309444387,
            47.2458262540088
          ],
          [
            -1.567672900139865,
            47.24571306326878
          ],
          [
            -1.567517386521939,
            47.245372487848584
          ],
          [
            -1.56749143807534,
            47.245286318445324
          ],
          [
            -1.567452528757859,
            47.2452293320901
          ],
          [
            -1.567352627627291,
            47.24467012829097
          ],
          [
            -1.567511373352345,
            47.2441172712632
          ],
          [
            -1.567913219596005,
            47.243624877529236
          ],
          [
            -1.568518826744484,
            47.243241143819255
          ],
          [
            -1.569268914309873,
            47.24300363007944
          ],
          [
            -1.57009006350352,
            47.24293558382933
          ],
          [
            -1.570901902065627,
            47.24304366528896
          ],
          [
            -1.571624968780537,
            47.24331729566726
          ],
          [
            -1.571784285138968,
            47.24343388786426
          ],
          [
            -1.571922136097674,
            47.24344829072758
          ],
          [
            -1.572661002321646,
            47.2437015998414
          ],
          [
            -1.573248768974118,
            47.24409799326512
          ],
          [
            -1.573627901435507,
            47.2445986718382
          ],
          [
            -1.573761283072214,
            47.245154627763206
          ],
          [
            -1.573635850192456,
            47.24571144102481
          ],
          [
            -1.573263873625576,
            47.24621460608507
          ],
          [
            -1.572681760400123,
            47.246614867561824
          ],
          [
            -1.57194649173884,
            47.24687304248316
          ],
          [
            -1.571833183345556,
            47.2468985260979
          ],
          [
            -1.571788516965073,
            47.24690539696396
          ]
        ]
      ]
    },
    "properties": {}
  },
  "id_grd_tr": 8402,
  "obj_libel": "étagement déjà en dessous de 20%",
  "com_diagte": null,
  "geo_point_2d": {
    "lat": 47.24503081830767,
    "lon": -1.570494449029478
  }
}

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

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 1 hour ago

Dataset

Volume & freshness

Records

171

Last upstream update

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