Public Lighting: Streetlights in Bordeaux, 2019Eclairage public : Points lumineux en 2019 de Bordeaux

Eclairage public : Points lumineux en 2019 de BordeauxPublic Lighting: Streetlights in Bordeaux, 2019

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This API provides access to a dataset listing the geolocated public streetlights of the city of Bordeaux as recorded in 2019. It is published via the Bordeaux Métropole open data portal and offers free access without authentication. The dataset is useful for mapping and analysing the coverage and distribution of public lighting infrastructure across the city.Liste des points lumineux de l'éclairage public de la ville géolocalisés en 2019.

⬇ 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 (9)

partitionkeyrowkeytimestampentityidcode_pldomainecategoriex_longy_lat

Click a field to see example values.

Field	Type	Description
partitionkey	text	Partition key identifier for the record in table storage.Partition key identifier for the record in table storage.
rowkey	text	Unique row key identifier for the record.Unique row key identifier for the record.
timestamp	text	Date and time the record was last updated.Date and time the record was last updated.
entityid	text	Unique entity identifier for the light point.Unique entity identifier for the light point.
code_plCode pl	text	Code identifying the light point.code du point lumineux
domaine	text	Type of lighting installation, e.g. public, private, or temporary lighting.Domaine : Liste des valeurs possibles : EP : Eclairage Public EPM : Eclairage Public + Mises en lumière EPR : Eclairage privé EPT : Eclairage Public Temporaire ILL : Mises en lumière - Illumination Mar : Marches MU : Mobilier urbain Spo : Sports
categorie	text	Category of the light fixture or support, e.g. pole, bracket, bench.Catégorie : Liste des valeurs possibles : ABR : Abris Bus ASP : Projecteur ASPIMM : Projecteur immergeable ASR : Réglette BAN : Banc BB : Buse Béton BOR : Borne CAT : Catenaire CSL : Console ENS : Enseigne Lumineuse FIL : Filin GDL : Générateur de Lumière ILL : Illum sur elevation INC : Inconnu MAT : Mât PBA : PBA PBO : Poteau Bois POR : Portique SFA : Sous face SOL : Sol SUS : Suspendu
x_longX long	text	Longitude coordinate of the light point.Longitude coordinate of the light point.
y_latY lat	text	Latitude coordinate of the light point.Latitude coordinate of the light point.
geometrie	geo_point_2d	Geographic point location of the light point.Geographic point location of the light point.

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)

Record 1y_lat: 44.8377110902263 · rowkey: ada44926-06fe-4df9-8356-d7f53b194636

{
  "y_lat": "44.8377110902263",
  "rowkey": "ada44926-06fe-4df9-8356-d7f53b194636",
  "x_long": "-0.58734620937793",
  "code_pl": "2052",
  "domaine": "EP",
  "entityid": "c4c62fbb-7df0-415c-a2d2-4caf4731bc61",
  "categorie": "ASR",
  "geometrie": {
    "lat": 44.8377110902,
    "lon": -0.587346209378
  },
  "timestamp": "2019-01-06T07:32:04.2349551Z",
  "partitionkey": "c4c62fbb-7df0-415c-a2d2-4caf4731bc61"
}

Record 2y_lat: 44.8300064057664 · rowkey: ac1f546e-862f-4114-ac89-fa97d2fe2507

{
  "y_lat": "44.8300064057664",
  "rowkey": "ac1f546e-862f-4114-ac89-fa97d2fe2507",
  "x_long": "-0.575715200292312",
  "code_pl": "18722",
  "domaine": "EP",
  "entityid": "fbb724d7-fd38-4831-94cf-6f54f775e6c4",
  "categorie": "FIL",
  "geometrie": {
    "lat": 44.8300064058,
    "lon": -0.575715200292
  },
  "timestamp": "2019-01-06T07:31:51.1549303Z",
  "partitionkey": "fbb724d7-fd38-4831-94cf-6f54f775e6c4"
}

Record 3y_lat: 44.8359311120828 · rowkey: 57c37da2-13ae-49fe-ae6e-fe6eac6fbb98

{
  "y_lat": "44.8359311120828",
  "rowkey": "57c37da2-13ae-49fe-ae6e-fe6eac6fbb98",
  "x_long": "-0.56739079571381",
  "code_pl": "52054",
  "domaine": "EP",
  "entityid": "97b7ab91-efe6-4c79-b309-b3ad9a9f2c0a",
  "categorie": "MAT",
  "geometrie": {
    "lat": 44.8359311121,
    "lon": -0.567390795714
  },
  "timestamp": "2019-01-06T07:32:26.4022868Z",
  "partitionkey": "97b7ab91-efe6-4c79-b309-b3ad9a9f2c0a"
}

Record 4y_lat: 44.8504321225435 · rowkey: 94f6e0a1-4eca-496f-b326-25626d49c25c

{
  "y_lat": "44.8504321225435",
  "rowkey": "94f6e0a1-4eca-496f-b326-25626d49c25c",
  "x_long": "-0.582869870173568",
  "code_pl": "39964",
  "domaine": "EP",
  "entityid": "578674de-edb0-4e56-b9c4-a0395793db15",
  "categorie": "CSL",
  "geometrie": {
    "lat": 44.8504321225,
    "lon": -0.582869870174
  },
  "timestamp": "2019-01-06T07:31:36.2120292Z",
  "partitionkey": "578674de-edb0-4e56-b9c4-a0395793db15"
}

Record 5y_lat: 44.8473107769544 · rowkey: e764d234-fb9d-40a4-b16f-3e3f0a869313

{
  "y_lat": "44.8473107769544",
  "rowkey": "e764d234-fb9d-40a4-b16f-3e3f0a869313",
  "x_long": "-0.539126515232534",
  "code_pl": "29056",
  "domaine": "EP",
  "entityid": "907318e5-fe4a-4698-b5f0-d3766689cebb",
  "categorie": "INC",
  "geometrie": {
    "lat": 44.847310777,
    "lon": -0.539126515233
  },
  "timestamp": "2019-01-06T07:32:25.6904989Z",
  "partitionkey": "907318e5-fe4a-4698-b5f0-d3766689cebb"
}

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

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/bor_ptlum/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 3 days ago

Dataset

Volume & freshness

Records

30k

30301

Update cadence

Quarterly

declared upstream

Last upstream update

6 years ago

2020-07-24

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.