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

Name: Schedules applicable to an SAEIV stop
Creator: opendatasoft

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

APIDiscovered1/7blocked by verifiedQuery 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...

⬇ 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 (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	Clé primaire
hor_theoHor theo	datetime	Horaire théorique d'arrivée du véhicule
hor_appHor app	datetime	Horaire applicable / commandé d'arrivée (suite à la régulation)
hor_estimeHor estime	datetime	Horaire estimé par le SAE
hor_realHor real	datetime	Horaire de passage réalisé par le véhicule
source	text	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	É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	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	Clé étrangère. Relation simple vers SV_ARRET_P
rs_sv_cours_aRs sv cours a	int	Clé étrangère. Relation simple vers SV_COURS_A
cdate	datetime	Date de création
mdate	datetime	Date de modification
tempsarret	int	Temps en secondes entre l'arrivée et le départ de l'arrêt

Schema captured from opendatasoft 6 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: 168489758 · etat: REALISE

{
  "gid": 168489758,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-09-02T22:00:00+00:00",
  "mdate": "2026-09-03T03:03:13+00:00",
  "source": "SAEIV_TRAM",
  "hor_app": "2026-09-03T02:52:26+00:00",
  "hor_real": "2026-09-03T02:52:26+00:00",
  "hor_theo": "2026-09-03T02:52:26+00:00",
  "hor_estime": null,
  "tempsarret": 0,
  "rs_sv_arret_p": 3814,
  "rs_sv_cours_a": 5180670
}

Record 2gid: 168489759 · etat: REALISE

{
  "gid": 168489759,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-09-02T22:00:00+00:00",
  "mdate": "2026-09-03T03:04:18+00:00",
  "source": "SAEIV_TRAM",
  "hor_app": "2026-09-03T02:53:55+00:00",
  "hor_real": "2026-09-03T03:03:44+00:00",
  "hor_theo": "2026-09-03T02:53:55+00:00",
  "hor_estime": null,
  "tempsarret": 17,
  "rs_sv_arret_p": 3816,
  "rs_sv_cours_a": 5180670
}

Record 3gid: 168489760 · etat: REALISE

{
  "gid": 168489760,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-09-02T22:00:00+00:00",
  "mdate": "2026-09-03T03:06:13+00:00",
  "source": "SAEIV_TRAM",
  "hor_app": "2026-09-03T02:55:25+00:00",
  "hor_real": "2026-09-03T03:05:13+00:00",
  "hor_theo": "2026-09-03T02:55:25+00:00",
  "hor_estime": null,
  "tempsarret": 40,
  "rs_sv_arret_p": 3818,
  "rs_sv_cours_a": 5180670
}

Record 4gid: 168489761 · etat: REALISE

{
  "gid": 168489761,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-09-02T22:00:00+00:00",
  "mdate": "2026-09-03T03:08:48+00:00",
  "source": "SAEIV_TRAM",
  "hor_app": "2026-09-03T02:58:05+00:00",
  "hor_real": "2026-09-03T03:08:15+00:00",
  "hor_theo": "2026-09-03T02:58:05+00:00",
  "hor_estime": null,
  "tempsarret": 19,
  "rs_sv_arret_p": 3820,
  "rs_sv_cours_a": 5180670
}

Record 5gid: 168489762 · etat: REALISE

{
  "gid": 168489762,
  "etat": "REALISE",
  "type": "REGULIER",
  "cdate": "2026-09-02T22:00:00+00:00",
  "mdate": "2026-09-03T03:10:23+00:00",
  "source": "SAEIV_TRAM",
  "hor_app": "2026-09-03T02:59:35+00:00",
  "hor_real": "2026-09-03T03:09:50+00:00",
  "hor_theo": "2026-09-03T02:59:35+00:00",
  "hor_estime": null,
  "tempsarret": 22,
  "rs_sv_arret_p": 3822,
  "rs_sv_cours_a": 5180670
}

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 6 days ago

Dataset

Volume & freshness

Records

273k

273409

Last upstream update

6 days ago

2026-09-03

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.