Eclairage public : Points lumineux en 2019 de Bordeaux

Name: Eclairage public : Points lumineux en 2019 de Bordeaux
Creator: opendatasoft

APIQuery nowOpen workbench Subscribe🇫🇷France

Website Docs

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	—
rowkey	text	—
timestamp	text	—
entityid	text	—
code_plCode pl	text	code du point lumineux
domaine	text	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	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	—
y_latY lat	text	—
geometrie	geo_point_2d	—

Schema captured from opendatasoft 1 hour 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.8204908468218 · rowkey: a3566800-a2d4-4154-8c39-aec85e698300

{
  "y_lat": "44.8204908468218",
  "rowkey": "a3566800-a2d4-4154-8c39-aec85e698300",
  "x_long": "-0.580119593500188",
  "code_pl": "17916",
  "domaine": "EP",
  "entityid": "0002a2fd-0525-4f3f-b727-0ce2143af1a2",
  "categorie": "PBA",
  "geometrie": {
    "lat": 44.8204908468,
    "lon": -0.5801195935
  },
  "timestamp": "2019-01-06T07:31:49.8146937Z",
  "partitionkey": "0002a2fd-0525-4f3f-b727-0ce2143af1a2"
}

Record 2y_lat: 44.8488345339781 · rowkey: 1b7b9fde-fdcf-4719-803d-30b92c0356b6

{
  "y_lat": "44.8488345339781",
  "rowkey": "1b7b9fde-fdcf-4719-803d-30b92c0356b6",
  "x_long": "-0.583365120825616",
  "code_pl": "3258",
  "domaine": "EP",
  "entityid": "001ac4b2-3766-4ea1-88ab-9f61e58376d0",
  "categorie": "CSL",
  "geometrie": {
    "lat": 44.848834534,
    "lon": -0.583365120826
  },
  "timestamp": "2019-01-06T07:31:56.0910631Z",
  "partitionkey": "001ac4b2-3766-4ea1-88ab-9f61e58376d0"
}

Record 3y_lat: 44.8575067345311 · rowkey: da6341f5-6aff-48c6-9188-73c178123751

{
  "y_lat": "44.8575067345311",
  "rowkey": "da6341f5-6aff-48c6-9188-73c178123751",
  "x_long": "-0.57825048339357",
  "code_pl": "40688",
  "domaine": "EP",
  "entityid": "00247409-db1b-48c1-a5e8-da52f766e94d",
  "categorie": "MAT",
  "geometrie": {
    "lat": 44.8575067345,
    "lon": -0.578250483394
  },
  "timestamp": "2019-01-06T07:31:49.6034847Z",
  "partitionkey": "00247409-db1b-48c1-a5e8-da52f766e94d"
}

Record 4y_lat: 44.85337893127 · rowkey: 0ce80fb4-8fcd-4aa2-99d0-7446094c7c5a

{
  "y_lat": "44.85337893127",
  "rowkey": "0ce80fb4-8fcd-4aa2-99d0-7446094c7c5a",
  "x_long": "-0.56995812539565",
  "code_pl": "40668",
  "domaine": "EP",
  "entityid": "0057af2c-8716-4139-b798-a947ebefb2dc",
  "categorie": "CSL",
  "geometrie": {
    "lat": 44.8533789313,
    "lon": -0.569958125396
  },
  "timestamp": "2019-01-06T07:31:49.4653858Z",
  "partitionkey": "0057af2c-8716-4139-b798-a947ebefb2dc"
}

Record 5y_lat: 44.826250269285 · rowkey: e59b0b69-958c-4e28-92da-071eb58c9a73

{
  "y_lat": "44.826250269285",
  "rowkey": "e59b0b69-958c-4e28-92da-071eb58c9a73",
  "x_long": "-0.564072763762207",
  "code_pl": "27346",
  "domaine": "EP",
  "entityid": "0087d6ef-d8bf-47b6-ba97-0b0248644fc8",
  "categorie": "INC",
  "geometrie": {
    "lat": 44.8262502693,
    "lon": -0.564072763762
  },
  "timestamp": "2019-01-06T07:32:27.3799712Z",
  "partitionkey": "0087d6ef-d8bf-47b6-ba97-0b0248644fc8"
}

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 1 hour 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.