Priority hydraulic structures in the Loire Estuary Water Management Plan (SAGE)Ouvrages hydrauliques prioritaires dans le SAGE Estuaire de la Loire

Ouvrages hydrauliques prioritaires dans le SAGE Estuaire de la LoirePriority hydraulic structures in the Loire Estuary Water Management Plan (SAGE)

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

This dataset lists hydraulic structures identified as priorities under the Loire Estuary SAGE (Schéma d'Aménagement et de Gestion des Eaux), a French local water management plan. It focuses on structures that can significantly affect ecological continuity of watercourses, a concept introduced by the 2000 EU Water Framework Directive, referring to the free movement of aquatic organisms and their access to habitats necessary for reproduction and development. Published via the Pays de la Loire regional open-data portal, the dataset supports water management authorities, environmental agencies, and researchers working on river restoration and compliance with ecological continuity requirements in the Loire estuary basin.Les ouvrages hydrauliques peuvent avoir un impact fort sur la continuité écologique. Notion introduite en 2000 par la directive cadre sur l’eau, la continuité écologique d’un cours d’eau est définie comme la libre circulation des organismes vivants et leur accès aux zones indispensables à leur re...

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

Filterable via the API (15)

id_geolibell_geoouv_typeid_roedate_obsouv_comce_majusti_sagejust_sa_etnom_ceprio_maangtf_prio1te_objoh_prios19oh_lprio19

Click a field to see example values.

Fill	Field	Type	Description
—	geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude/longitude) of the structure.Geographic coordinates (latitude/longitude) of the structure.
—	geo_shapeShape	geo_shape	Geometric shape of the structure in GeoJSON format.Geometric shape of the structure in GeoJSON format.
—	id_geoidentifiant SAGE	text	Original identifier from preliminary studies used in the SAGE plan.Identifiants initiaux des études préalables repris dans le PAGD du SAGE
—	libell_geonom de l'ouvrage	text	Name of the hydraulic structure.Name of the hydraulic structure.
—	ouv_typetype d'ouvrage	text	Type of hydraulic structure (e.g. weir, sill).Type of hydraulic structure (e.g. weir, sill).
—	id_roeidentifiant de l'ouvrage dans le DOE	text	Identifier of the structure in the national obstacles database (ROE).Identifier of the structure in the national obstacles database (ROE).
—	date_obsdate de validité des informations	text	Date the information was last validated.Date the information was last validated.
—	ouv_comcommentaires sur l'ouvrage	text	Comments or observations about the structure.Reprise des champs d'observation
—	ce_macours d'eau (1) ou marais (0) ?	int	Indicates whether the structure is on a watercourse (1) or a marsh (0).cours d'eau (1), marais (0)
—	justi_sagejustifications d'inscription dans le SAGE (fractionnement)	text	Justification for inclusion in the SAGE regarding flow fragmentation.Justification for inclusion in the SAGE regarding flow fragmentation.
53.2%	just_sa_etjustifications d'inscription dans le SAGE (étagement)	text	Justification for inclusion in the SAGE regarding water level staging.Justification for inclusion in the SAGE regarding water level staging.
98.9%	nom_cenom du cours d'eau impacté	text	Name of the watercourse affected by the structure.Name of the watercourse affected by the structure.
100%	prio_maangobjectif accéssibilité des marais par l'anguille	int	Indicates if eel access to marshes is a priority objective (1=yes, 0=no).oui (1), non (0)
100%	tf_prio1objectif réduction du taux de fractionnement	int	Indicates if reducing the fragmentation rate is a priority objective (1=yes, 0=no).oui (1), non(0)
100%	te_objobjectif réduction du taux d'étagement	int	Indicates if reducing the staging rate is a priority objective (1=yes, 0=no).oui (1), non(0)
100%	oh_prios19code type de priorité	text	Code identifying the type of priority assigned.Code identifying the type of priority assigned.
100%	oh_lprio19type de priorité dans le SAGE	text	Description of the priority type defined in the SAGE plan.Priorité reprises de la carte 57 du PAGD du SAGE Estuaire de la Loire

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 1ce_ma: 1 · id_geo: erav133

{
  "ce_ma": 1,
  "id_geo": "erav133",
  "id_roe": "ROE41991",
  "nom_ce": "l'Erdre amont",
  "te_obj": 1,
  "ouv_com": "Fissure / Déformation",
  "date_obs": "2017-10-16 00:00:00",
  "ouv_type": "seuil artificiel",
  "tf_prio1": 1,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -1.127015477323887,
        47.550322380782774
      ]
    },
    "properties": {}
  },
  "just_sa_et": "réduction de l'étagement sous le seuil de 40%",
  "justi_sage": "réduction du fractionnement sous le seuil de 40%0 (priorité 2 : cours d'eau liste1)",
  "libell_geo": "Seuil du  plan d'eau de Freigné",
  "oh_lprio19": "objectif de réduction des taux d'étagement et de fractionnement",
  "oh_prios19": "011",
  "prio_maang": 0,
  "geo_point_2d": {
    "lat": 47.550322380782774,
    "lon": -1.1270154773238867
  }
}

Record 2ce_ma: 1 · id_geo: OUV_734

{
  "ce_ma": 1,
  "id_geo": "OUV_734",
  "id_roe": "ROE84687",
  "nom_ce": "le Havre",
  "te_obj": 1,
  "ouv_com": "passerelle réalisation échancrure",
  "date_obs": "2017-10-30 00:00:00",
  "ouv_type": "seuil station jaugeage",
  "tf_prio1": 1,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -1.297793447324359,
        47.419930672116685
      ]
    },
    "properties": {}
  },
  "just_sa_et": "réduction de l'étagement sous le seuil de 20%",
  "justi_sage": null,
  "libell_geo": "r. du donneau à Mouzeil",
  "oh_lprio19": "objectif de réduction des taux d'étagement et de fractionnement",
  "oh_prios19": "011",
  "prio_maang": 0,
  "geo_point_2d": {
    "lat": 47.419930672116685,
    "lon": -1.2977934473243586
  }
}

Record 3ce_ma: 0 · id_geo: SHY03910

{
  "ce_ma": 0,
  "id_geo": "SHY03910",
  "id_roe": "ROE17002",
  "nom_ce": "Canal de la Taillèe-Ardivais",
  "te_obj": 0,
  "ouv_com": "Ecluse de la D100",
  "date_obs": "2017-09-14 00:00:00",
  "ouv_type": "ecluse portes busquees",
  "tf_prio1": 0,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -2.010894495484487,
        47.34419660611918
      ]
    },
    "properties": {}
  },
  "just_sa_et": null,
  "justi_sage": "ouvrage sur canal liste 2 : objectif classe d'accessibilité Anguille : bonne (prio 1)",
  "libell_geo": "portes de vieux- pont",
  "oh_lprio19": "objectif d'amélioration de l'accéssibilité des marais par l'anguille",
  "oh_prios19": "100",
  "prio_maang": 1,
  "geo_point_2d": {
    "lat": 47.34419660611918,
    "lon": -2.0108944954844867
  }
}

Record 4ce_ma: 0 · id_geo: OHY50002

{
  "ce_ma": 0,
  "id_geo": "OHY50002",
  "id_roe": "ROE39389",
  "nom_ce": "canal de ceinture du marais endigué (affluent ruisseau de la Déchausserie- douve  Bonnes Fillles)",
  "te_obj": 0,
  "ouv_com": "permet une gestion différenciée des niveaux d'eau entre l'Erdre et le marais endigué",
  "date_obs": "2017-09-25 00:00:00",
  "ouv_type": "écluse",
  "tf_prio1": 0,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -1.484029491893424,
        47.39417007200673
      ]
    },
    "properties": {}
  },
  "just_sa_et": null,
  "justi_sage": "ouvrage sur canal non classé : objectif classe d'accessibilité Anguille : moyenne à bonne (prio 2)",
  "libell_geo": "ecluse du marais endigué de mazerolles",
  "oh_lprio19": "objectif d'amélioration de l'accéssibilité des marais par l'anguille",
  "oh_prios19": "100",
  "prio_maang": 1,
  "geo_point_2d": {
    "lat": 47.39417007200673,
    "lon": -1.4840294918934236
  }
}

Record 5ce_ma: 1 · id_geo: erav135

{
  "ce_ma": 1,
  "id_geo": "erav135",
  "id_roe": "ROE41999",
  "nom_ce": "l'Erdre amont",
  "te_obj": 1,
  "ouv_com": "Bon état",
  "date_obs": "2017-10-16 00:00:00",
  "ouv_type": "seuil artificiel",
  "tf_prio1": 1,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -1.142766914884507,
        47.544755707371024
      ]
    },
    "properties": {}
  },
  "just_sa_et": "réduction de l'étagement sous le seuil de 40%",
  "justi_sage": "réduction du fractionnement sous le seuil de 40%0 (priorité 2 : cours d'eau liste1)",
  "libell_geo": "Seuil artificiel sur l'erdre aval",
  "oh_lprio19": "objectif de réduction des taux d'étagement et de fractionnement",
  "oh_prios19": "011",
  "prio_maang": 0,
  "geo_point_2d": {
    "lat": 47.544755707371024,
    "lon": -1.142766914884507
  }
}

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

Last upstream update

1 year ago

2025-10-22

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.