Schedules applicable to an SAEIV stopHoraires applicables à un arrêt SAEIV

Horaires applicables à un arrêt SAEIVSchedules applicable to an SAEIV stop

APIExecutable4/7Query nowOpen workbench Subscribe🇫🇷France

This non-spatial dataset comes from Bordeaux Métropole's SAEIV (public transport operations and passenger information system) and provides theoretical, scheduled and real-time estimated timetables for each stop and trip on the network. Data is updated in real time, allowing tracking of actual versus planned service times for public transport lines. It is published as open data by Bordeaux Métropole and is intended for use in transit information applications, journey planners, and analysis of public transport punctuality and service reliability within the metropolitan area.Dictionnaire Public Ce jeu de données non graphique issu du Systèmes d'Aide à l'Exploitation et d'Information des Voyageurs (SAEIV) représente les horaires théoriques, programmés et estimés en temps réel pour chaque arrêt et desserte de course. Les informations sont mises à jour en temps réel en...

transport

⬇ 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 (13 fields)

Filterable via the API (13)

gidhor_theohor_apphor_estimehor_realsourceetattypers_sv_arret_prs_sv_cours_acdatemdatetempsarret

Click a field to see example values.

Field	Type	Description
gid	int	Primary key identifier.Clé primaire
hor_theoHor theo	datetime	Scheduled theoretical arrival time of the vehicle.Horaire théorique d'arrivée du véhicule
hor_appHor app	datetime	Applicable/commanded arrival time after regulation adjustments.Horaire applicable / commandé d'arrivée (suite à la régulation)
hor_estimeHor estime	datetime	Real-time arrival time estimated by the operations system.Horaire estimé par le SAE
hor_realHor real	datetime	Actual arrival time recorded for the vehicle.Horaire de passage réalisé par le véhicule
source	text	Data source system: real-time bus or tram operations system.Source de la donnée : Liste des valeurs possibles : SAEIV_BUS : Objet issu du SAEIV Bus temps réel SAEIV_TRAM : Objet issu du SAEIV Tram temps réel
etat	text	Current status of the stop time: not done, done, cancelled, diverted, or unspecified.État actuel de l'horaire : Liste des valeurs possibles : NON_REALISE : Passage à l'arrêt non effectué REALISE : Passage à l'arrêt effectué ANNULE : Passage à l'arrêt annulé DEVIE : Passage à l'arrêt dévié NON_RENSEIGNE : Non renseigné
type	text	Schedule type: regular real-time managed or diversion-estimated.Type d'horaire : Liste des valeurs possibles : REGULIER : Horaire normal géré par le temps réel DEVIATION : Horaire de déviation estimé par l'OpenData
rs_sv_arret_pRs sv arret p	int	Foreign key referencing the stop point table.Clé étrangère. Relation simple vers SV_ARRET_P
rs_sv_cours_aRs sv cours a	int	Foreign key referencing the trip/run table.Clé étrangère. Relation simple vers SV_COURS_A
cdate	datetime	Date and time the record was created.Date de création
mdate	datetime	Date and time the record was last modified.Date de modification
tempsarret	int	Time in seconds between arrival and departure at the stop.Temps en secondes entre l'arrivée et le départ de l'arrêt

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: 268553748 · etat: NON_REALISE

{
  "gid": 268553748,
  "etat": "NON_REALISE",
  "type": "REGULIER",
  "cdate": "2026-10-21T22:00:00+00:00",
  "mdate": "2026-10-22T01:53:21+00:00",
  "source": "SAEIV_BUS",
  "hor_app": "2026-10-22T19:01:19+00:00",
  "hor_real": null,
  "hor_theo": "2026-10-22T19:01:19+00:00",
  "hor_estime": "2026-10-22T19:01:20+00:00",
  "tempsarret": null,
  "rs_sv_arret_p": 2687,
  "rs_sv_cours_a": 5526792
}

Record 2gid: 268544196 · etat: REALISE

{
  "gid": 268544196,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-10-21T22:00:00+00:00",
  "mdate": "2026-10-22T10:15:24+00:00",
  "source": "SAEIV_BUS",
  "hor_app": "2026-10-22T10:13:28+00:00",
  "hor_real": "2026-10-22T10:15:19+00:00",
  "hor_theo": "2026-10-22T10:13:28+00:00",
  "hor_estime": null,
  "tempsarret": 0,
  "rs_sv_arret_p": 1018,
  "rs_sv_cours_a": 5525108
}

Record 3gid: 268474050 · etat: REALISE

{
  "gid": 268474050,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-10-21T22:00:00+00:00",
  "mdate": "2026-10-22T13:38:44+00:00",
  "source": "SAEIV_BUS",
  "hor_app": "2026-10-22T13:39:00+00:00",
  "hor_real": "2026-10-22T13:37:51+00:00",
  "hor_theo": "2026-10-22T13:39:00+00:00",
  "hor_estime": null,
  "tempsarret": 25,
  "rs_sv_arret_p": 1326,
  "rs_sv_cours_a": 5526776
}

Record 4gid: 268526408 · etat: ANNULE

{
  "gid": 268526408,
  "etat": "ANNULE",
  "type": "REGULIER",
  "cdate": "2026-10-21T22:00:00+00:00",
  "mdate": "2026-10-22T03:31:31+00:00",
  "source": "SAEIV_BUS",
  "hor_app": "2026-10-22T15:57:19+00:00",
  "hor_real": null,
  "hor_theo": "2026-10-22T15:57:19+00:00",
  "hor_estime": "2026-10-22T15:57:19+00:00",
  "tempsarret": null,
  "rs_sv_arret_p": 1368,
  "rs_sv_cours_a": 5529734
}

Record 5gid: 268639914 · etat: REALISE

{
  "gid": 268639914,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-10-21T22:00:00+00:00",
  "mdate": "2026-10-22T12:28:56+00:00",
  "source": "SAEIV_BUS",
  "hor_app": "2026-10-22T12:27:41+00:00",
  "hor_real": "2026-10-22T12:28:31+00:00",
  "hor_theo": "2026-10-22T12:27:41+00:00",
  "hor_estime": null,
  "tempsarret": 22,
  "rs_sv_arret_p": 1394,
  "rs_sv_cours_a": 5529385
}

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

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/sv_horai_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.

Full API documentation ↗

Rate limits

50 000 req/day

per ipmeasured

observed 2 days ago

Dataset

Volume & freshness

Records

275k

275367

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.