Fragmentation rate targets for watercourses under the Loire Estuary SAGE water management planObjectifs du taux de fractionnement des cours d'eau du SAGE Estuaire de la Loire

Objectifs du taux de fractionnement des cours d'eau du SAGE Estuaire de la LoireFragmentation rate targets for watercourses under the Loire Estuary SAGE water management plan

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This French dataset, published via the Pays de la Loire regional open-data portal, provides fragmentation rate targets for watercourses within the Loire Estuary SAGE (Schéma d'Aménagement et de Gestion des Eaux) water management area, set for 2024. The fragmentation rate measures the ratio between the cumulative artificial drop height created by structures (such as weirs or dams) along a watercourse and its total length, expressed in per mille (‰). For example, a rate of 40‰ means a fish must on average overcome 40 cm of artificial drop per kilometre of river. The data supports monitoring of river continuity and fish passage for ecological management purposes.Le taux de fractionnement est le rapport entre le cumul de la hauteur de chute artificielle créée par les ouvrages et la longueur du cours d’eau. Il s’exprime en ‰. Un taux de fractionnement de 40 ‰ signifie qu’un poisson devra en moyenne franchir 40 cm de hauteur de chute artificielle créée par...

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 (10 fields)

Filterable via the API (8)

id_grd_trnom_hy_com_ftf_dia_tfgt_com_dtf_obj_frac_prio_fraobj2_prio

Click a field to see example values.

Field	Type	Description
geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude/longitude) of the river section centroid.Geographic coordinates (latitude/longitude) of the river section centroid.
geo_shapeShape	geo_shape	Geometric shape representing the river section's path.Geometric shape representing the river section's path.
id_grd_tridentifiant du tronçon	double	Unique identifier of the river section.Unique identifier of the river section.
nom_hynom du cours d'eau	text	Name of the watercourse.Name of the watercourse.
_com_ftffiabilité taux fractionnement	text	Reliability assessment of the fragmentation rate calculation.Reliability assessment of the fragmentation rate calculation.
_dia_tfgtNiveau taux fractionnement	text	Diagnosed level of fragmentation rate for the section.Diagnosed level of fragmentation rate for the section.
_com_dtfcommentaire diagnostic fractionnement	text	Comment on the fragmentation diagnosis for the section.Comment on the fragmentation diagnosis for the section.
_obj_fracObjectif fractionnement	text	Target fragmentation rate objective for the section.Target fragmentation rate objective for the section.
_prio_frapriorité fractionnement	text	Priority level assigned for fragmentation reduction.Priority level assigned for fragmentation reduction.
obj2_prioObjectif / priorité	text	Combined fragmentation objective and priority label.Combined fragmentation objective and priority label.

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)

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

Record 1nom_hy: ruisseau de la Gasnerie · _com_dtf: diagnostic exhaustif

{
  "nom_hy": "ruisseau de la Gasnerie",
  "_com_dtf": "diagnostic exhaustif",
  "_com_ftf": "valeur fiable",
  "_dia_tfgt": "Fractionnement très fort",
  "_obj_frac": "0.4",
  "_prio_fra": "3",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 45000,
  "obj2_prio": "Objectif 40%0 - Priorité 3",
  "geo_point_2d": {
    "lat": 47.45182708552522,
    "lon": -1.0898519493398424
  }
}

Record 2nom_hy: Le Gesvres · _com_dtf: Diagnostic en cours

{
  "nom_hy": "Le Gesvres",
  "_com_dtf": "Diagnostic en cours",
  "_com_ftf": "calcul partiel : manque nombreuses infos sur hchute",
  "_dia_tfgt": "données trop partielles ou absentes",
  "_obj_frac": "0",
  "_prio_fra": "1",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 3903,
  "obj2_prio": "Objectif 0%0 (Liste 2) - Priorité 1",
  "geo_point_2d": {
    "lat": 47.32046678534147,
    "lon": -1.6278293261037131
  }
}

Record 3nom_hy: L'Aubinière · _com_dtf: pas de diagnostic programmé

{
  "nom_hy": "L'Aubinière",
  "_com_dtf": "pas de diagnostic programmé",
  "_com_ftf": "absence de diagnostic : calcul impossible",
  "_dia_tfgt": "données trop partielles ou absentes",
  "_obj_frac": "0.4",
  "_prio_fra": "3",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 3000,
  "obj2_prio": "Objectif 40%0 - Priorité 3",
  "geo_point_2d": {
    "lat": 47.23523377620946,
    "lon": -1.4840344803508905
  }
}

Record 4nom_hy: ruisseau du Refou · _com_dtf: diagnostic exhaustif

{
  "nom_hy": "ruisseau du Refou",
  "_com_dtf": "diagnostic exhaustif",
  "_com_ftf": "valeur fiable",
  "_dia_tfgt": "Fractionnement fort",
  "_obj_frac": "0.4",
  "_prio_fra": "3",
  "geo_shape": "[large value omitted]",
  "id_grd_tr": 56000,
  "obj2_prio": "Objectif 40%0 - Priorité 3",
  "geo_point_2d": {
    "lat": 47.334031005540254,
    "lon": -1.32572331024139
  }
}

Record 5nom_hy: l'Erdre amont · _com_dtf: —

{
  "nom_hy": "l'Erdre amont",
  "_com_dtf": null,
  "_com_ftf": null,
  "_dia_tfgt": null,
  "_obj_frac": "0",
  "_prio_fra": "1",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            -1.481196936992396,
            47.466460412920455
          ],
          [
            -1.481049926157131,
            47.46636574316286
          ],
          [
            -1.480544497813993,
            47.465918742955836
          ],
          [
            -1.480267513410922,
            47.46538770851314
          ],
          [
            -1.480246080017465,
            47.464824622814966
          ],
          [
            -1.480482287857842,
            47.4642846047464
          ],
          [
            -1.480953008694404,
            47.46382051362595
          ],
          [
            -1.481612162289387,
            47.46347777550671
          ],
          [
            -1.482395228129849,
            47.463289937481875
          ],
          [
            -1.483225560368171,
            47.46327538481711
          ],
          [
            -1.484021888124556,
            47.46343554189482
          ],
          [
            -1.484706267858419,
            47.46375473283678
          ],
          [
            -1.485183839876671,
            47.464062257193255
          ],
          [
            -1.485611981297683,
            47.464418959506716
          ],
          [
            -1.485793494683277,
            47.46461744079196
          ],
          [
            -1.486117116858525,
            47.46514129848865
          ],
          [
            -1.486183979614425,
            47.46570745385906
          ],
          [
            -1.485987420473925,
            47.46625956040678
          ],
          [
            -1.485963666761868,
            47.466298164562005
          ],
          [
            -1.485527814555624,
            47.46677766950323
          ],
          [
            -1.484894771521392,
            47.4671423720475
          ],
          [
            -1.484126505588077,
            47.46735657001196
          ],
          [
            -1.483298225548315,
            47.46739929438499
          ],
          [
            -1.482491016970082,
            47.467266362615376
          ],
          [
            -1.481783902017071,
            47.4669707881793
          ],
          [
            -1.481246101548535,
            47.466541506276535
          ],
          [
            -1.481196936992396,
            47.466460412920455
          ]
        ]
      ]
    },
    "properties": {}
  },
  "id_grd_tr": 9704,
  "obj2_prio": "Objectif 0%0 (Liste 2) - Priorité 1",
  "geo_point_2d": {
    "lat": 47.46532697101054,
    "lon": -1.4832133160339367
  }
}

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_fractionnement_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_fractionnement_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 3 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

$Objectifs du taux de fractionnement des cours d'eau du SAGE Estuaire de la Loire — live verification badge$

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