Soil PermeabilityPerméabilité des sols

Perméabilité des solsSoil Permeability

APIDiscovered1/7blocked by verifiedQuery nowOpen workbench Subscribe🇫🇷France

This dataset from Bordeaux Métropole's open data portal provides point-based data on soil permeability test results across the metropolitan area. It aggregates information from various sources that record underground structures and related surveys within the territory. The dataset is published under a public dictionary and can be used for urban planning, hydrology, and infrastructure studies requiring knowledge of local soil drainage characteristics. It is freely accessible without authentication and covers the national French context at the metropolitan (Bordeaux) level.Dictionnaire Public Ce jeu de données représente, sous la forme d'objets ponctuels, le résultat des essais de perméabilité des sols sur le territoire de Bordeaux Métropole. Ce jeu de données résulte de l'agrégat de différentes sources qui répertorient les ouvrages souterrains sur le territoire de...

water

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

poor

Weighted across five axes. Tap a ring for what it measures.

Data schema (14 fields)

Filterable via the API (12)

gidpermeabilite_retenuetype_essailitho_completeprofondeur_essaidate_essaiprofondeur_nappesourcecdatemdategeom_ogeom_err

Click a field to see example values.

Fill	Field	Type	Description
—	geo_point_2dGeo Point	geo_point_2d	Geographic coordinates (latitude, longitude) of the test point.Geographic coordinates (latitude, longitude) of the test point.
—	geo_shapeShape	geo_shape	Geometric shape of the test point in GeoJSON format.Geometric shape of the test point in GeoJSON format.
—	gid	int	Primary key identifier for the record.Clé primaire
—	permeabilite_retenuePermeabilite retenue	double	Measured soil permeability value in metres per second.Perméabilité mesurée retenue en mètre par seconde
—	type_essaiType essai	text	Type of permeability test performed.Type d'essai de perméabilité
—	litho_completeLitho complete	text	Full description of the tested soil layers.Description complète des terrains testés
—	profondeur_essaiProfondeur essai	double	Depth at which the permeability test was conducted.Profondeur de l'essai de perméabilité
—	date_essaiDate essai	date	Date the permeability test was carried out.Date de l'essai de perméabilité
—	profondeur_nappeProfondeur nappe	double	Measured depth of the groundwater table, in metres.Profondeur mesurée de la nappe en mètres
—	source	text	Origin or producer of the data.Origine de la donnée / producteur
100%	cdate	datetime	Date and time the record was created.Date de création
100%	mdate	datetime	Date and time the record was last modified.Date de modification
100%	geom_oGeom o	text	Orientation code of the point geometry.Orientation du point
0%	geom_errGeom err	text	Error code indicating a geometry issue, if any.Code d'erreur géométrique : Liste des valeurs possibles : 9999 : Polygone compose et / ou à sections multiples 9998 : Linéaire compose et / ou à sections multiples 9996 : La géométrie contient des informations LRS 9995 : Nombre de dimensions différent de 2 ou 3 9994 : Présence d'un arc de cercle 9000 : Erreur autre 13343 : Polygone de moins de 4 points 13349 : Polygone papillon 13350 : Deux éléments d'un polygone archipel se touchent 13351 : Deux éléments d'un polygone archipel se touchent 13356 : Point double 13366 : Combinaison invalide d'intérieur / extérieur d'un polygone 13367 : Orientation invalide d'intérieur / extérieur d'un polygone

Schema captured from opendatasoft 2 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 1gid: 69715 · cdate: 2025-02-10T09:49:37+00:00

{
  "gid": 69715,
  "cdate": "2025-02-10T09:49:37+00:00",
  "mdate": "2025-02-10T09:49:37+00:00",
  "geom_o": "0",
  "source": "GEOTECH",
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.7016764,
        44.815909
      ]
    },
    "properties": {}
  },
  "date_essai": "2020-10-06",
  "type_essai": "PORCHET",
  "geo_point_2d": {
    "lat": 44.815909,
    "lon": -0.7016764
  },
  "litho_complete": "Sables",
  "profondeur_essai": 1,
  "profondeur_nappe": 0,
  "permeabilite_retenue": 0.000003
}

Record 2gid: 70552 · cdate: 2025-02-10T09:49:38+00:00

{
  "gid": 70552,
  "cdate": "2025-02-10T09:49:38+00:00",
  "mdate": "2025-02-10T09:49:38+00:00",
  "geom_o": "0",
  "source": null,
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.5295365,
        44.9421034
      ]
    },
    "properties": {}
  },
  "date_essai": null,
  "type_essai": null,
  "geo_point_2d": {
    "lat": 44.9421034,
    "lon": -0.5295365
  },
  "litho_complete": "Argileux",
  "profondeur_essai": 0,
  "profondeur_nappe": 0.7,
  "permeabilite_retenue": 0.00000972222
}

Record 3gid: 69427 · cdate: 2025-02-10T09:49:37+00:00

{
  "gid": 69427,
  "cdate": "2025-02-10T09:49:37+00:00",
  "mdate": "2025-02-10T09:49:37+00:00",
  "geom_o": "0",
  "source": "CERAG",
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.639231,
        44.9118476
      ]
    },
    "properties": {}
  },
  "date_essai": "2018-12-11",
  "type_essai": "PORCHET",
  "geo_point_2d": {
    "lat": 44.9118476,
    "lon": -0.639231
  },
  "litho_complete": "Calcaire dans matrice argileuse",
  "profondeur_essai": 1,
  "profondeur_nappe": 2.55,
  "permeabilite_retenue": 0.000004
}

Record 4gid: 70350 · cdate: 2025-02-10T09:49:38+00:00

{
  "gid": 70350,
  "cdate": "2025-02-10T09:49:38+00:00",
  "mdate": "2025-02-10T09:49:38+00:00",
  "geom_o": "0",
  "source": null,
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.4979008,
        44.807109
      ]
    },
    "properties": {}
  },
  "date_essai": null,
  "type_essai": null,
  "geo_point_2d": {
    "lat": 44.807109,
    "lon": -0.4979008
  },
  "litho_complete": "Argileux",
  "profondeur_essai": 0,
  "profondeur_nappe": 0,
  "permeabilite_retenue": 0.00000333333
}

Record 5gid: 70202 · cdate: 2025-02-10T09:49:37+00:00

{
  "gid": 70202,
  "cdate": "2025-02-10T09:49:37+00:00",
  "mdate": "2025-02-10T09:49:37+00:00",
  "geom_o": "0",
  "source": "SOLTECHNIC",
  "geom_err": null,
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -0.6082399,
        44.7766463
      ]
    },
    "properties": {}
  },
  "date_essai": "2021-05-17",
  "type_essai": "PORCHET",
  "geo_point_2d": {
    "lat": 44.7766463,
    "lon": -0.6082399
  },
  "litho_complete": "Sable argilo-graveleux beige",
  "profondeur_essai": 0.5,
  "profondeur_nappe": 3.2,
  "permeabilite_retenue": 0.000014
}

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/en_permeabilite_p

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/en_permeabilite_p/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

50 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

1.3k

1294

Last upstream update

2 days ago

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