Composition of materials associated with Bordeaux Métropole utility structuresComposition du matériel associé à l’ouvrage métier de Bordeaux Métropole
Composition du matériel associé à l’ouvrage métier de Bordeaux MétropoleComposition of materials associated with Bordeaux Métropole utility structures
This API provides data on the material composition of infrastructure structures ("ouvrages") managed by Bordeaux Métropole, the metropolitan authority for the Bordeaux area in France. It details the components making up each structure and can be cross-referenced with datasets representing network objects, enabling users to identify what materials specific network elements are built from. The dataset is freely accessible without authentication and forms part of the public data dictionary published by Bordeaux Métropole's open data portal, supporting technical and infrastructure-related analysis of the local network.Dictionnaire Public Ce jeu de données détaille la composition des ouvrages . Il permet de connaitre la composition du matériel. Ce jeu de donnée peut être mis en relation avec les éléments représentant un objet du réseau de Bordeaux Métropole
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (13 fields)
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| gid | int | Primary key identifier of the record.Clé primaire |
| ident | text | Business identifier of the element.Identifiant métier de l'élément |
| rs_re_ouvrage_aRs re ouvrage a | int | Foreign key linking to the RE_OUVRAGE_A structure.Clé étrangère. Relation simple vers RE_OUVRAGE_A |
| cdate | datetime | Date the record was created.Date de création |
| mdate | datetime | Date the record was last modified.Date de modification |
| libelletypemateriel | text | Label of the equipment type.Libellé du type de matériel |
| libellemateriel | text | Label of the equipment.Libellé du matériel |
| hierarchiemateriel | int | Hierarchy level of the equipment within the composition.Hiérarchie du matériel dans la composition |
| ordremateriel | int | Order of the equipment within the composition.Ordre du matériel dans la composition |
| hauteurmateriel | double | Height of the equipment within the composition.Hauteur du matériel dans la composition |
| cletypemateriel | text | Muse key of the equipment type.Clé Muse du type matériel |
| clemateriel | text | Muse key of the equipment.Clé Muse du matériel |
| dateinstall | datetime | Installation date of the equipment within the composition.Date d'installation du matériel dans la composition |
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.
Sample data (5 records)
Record 1gid: 292641 · cdate: 2013-03-09T23:00:00+00:00
{
"gid": 292641,
"cdate": "2013-03-09T23:00:00+00:00",
"ident": "063-ECP-EL-033604",
"mdate": "2013-03-09T23:00:00+00:00",
"clemateriel": "ECP-LUMLED-498",
"dateinstall": "2013-03-09T23:00:00+00:00",
"ordremateriel": 2,
"cletypemateriel": "AAM",
"hauteurmateriel": null,
"libellemateriel": "LANT ECOSTREETLINE PARK LED NR",
"rs_re_ouvrage_a": 113786,
"hierarchiemateriel": 2,
"libelletypemateriel": "Luminaire LED ECP"
}Record 2gid: 392466 · cdate: 2009-04-30T22:00:00+00:00
{
"gid": 392466,
"cdate": "2009-04-30T22:00:00+00:00",
"ident": "063-ECP-EL-068206",
"mdate": "2009-04-30T22:00:00+00:00",
"clemateriel": "ECP-ACC-I29",
"dateinstall": "2009-04-30T22:00:00+00:00",
"ordremateriel": 57,
"cletypemateriel": "ADG",
"hauteurmateriel": null,
"libellemateriel": "Filtre BOROVER jaune B379M",
"rs_re_ouvrage_a": 105647,
"hierarchiemateriel": 2,
"libelletypemateriel": "Accessoires ECP"
}Record 3gid: 536372 · cdate: 2022-05-12T13:44:04+00:00
{
"gid": 536372,
"cdate": "2022-05-12T13:44:04+00:00",
"ident": "039-ECP-EL-002483",
"mdate": "2022-05-12T13:44:04+00:00",
"clemateriel": "ECP-SOD-143",
"dateinstall": "2021-12-01T14:44:04+00:00",
"ordremateriel": 5,
"cletypemateriel": "AAD",
"hauteurmateriel": null,
"libellemateriel": "SHP 150W 2000K 17700lm E40 TUB",
"rs_re_ouvrage_a": 3252,
"hierarchiemateriel": 5,
"libelletypemateriel": "Source SODIUM ECP"
}Record 4gid: 330607 · cdate: 1899-12-31T23:50:39+00:00
{
"gid": 330607,
"cdate": "1899-12-31T23:50:39+00:00",
"ident": "063-ECP-EL-045136",
"mdate": "1899-12-31T23:50:39+00:00",
"clemateriel": "ECP-ACC-B00",
"dateinstall": null,
"ordremateriel": 6,
"cletypemateriel": "ADG",
"hauteurmateriel": null,
"libellemateriel": "Coffret de protection - à préc",
"rs_re_ouvrage_a": 98761,
"hierarchiemateriel": 2,
"libelletypemateriel": "Accessoires ECP"
}Record 5gid: 497109 · cdate: 2020-05-26T22:00:00+00:00
{
"gid": 497109,
"cdate": "2020-05-26T22:00:00+00:00",
"ident": "318-ECP-EL-002287",
"mdate": "2020-05-26T22:00:00+00:00",
"clemateriel": "ECP-SUP-999",
"dateinstall": null,
"ordremateriel": 1,
"cletypemateriel": "AAA",
"hauteurmateriel": 10,
"libellemateriel": "Support INCONNU",
"rs_re_ouvrage_a": 285626,
"hierarchiemateriel": 1,
"libelletypemateriel": "Support Mât ECP"
}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/re_ouvragecomposition_a
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/re_ouvragecomposition_a/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.
Rate limits
Dataset
Volume & freshness
License
No license declared upstream.
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.