Data Stories


Here's a catalogue of SPARQL queries (together with their correspondance in natural language) that can be useful for different purposes. Queries will be provided as independent files inside this folder, to facilitate their maintenance and the generation of references to them from other parts of the ERA ecosystem (e.g., ontology documentation, demo sites, etc.), especially in case of ontology changes. And some of these queries will be also grouped together in SPARQL notebooks, for convenience, providing a unified view over a specific need (e.g., parameter completeness reports per member state).

1. Provide the number of operational points loaded in the Knowledge Graph, grouped by member state. Query. Execute it (HTML). Execute it (CSV)

2. Provide the number of sections of line loaded in the Knowledge Graph, grouped by member state. Query. Execute it (HTML). Execute it (CSV)

3. Provide the total length of lines loaded in the Knowledge Graph, grouped by member state. Query. Execute it (HTML). Execute it (CSV)

3.1. Provide the total length of lines (grouped by member state and type of line - currently section of line or tunnel). Query. Execute it (HTML). Execute it (CSV)

3.2. Provide the total length of lines (understood as sections of line) loaded in the Knowledge Graph, grouped by member state. Query. Execute it (HTML). Execute it (CSV)

4. Provide a summary of the presence of the core parameter load capability (1.1.1.1.2.4) across all tracks per member state. Query. Execute it (HTML). Execute it (CSV)

4.1. Provide a summary of the sections of lines and tracks where the core parameter load capability (1.1.1.1.2.4) does not appear (example with Spain).Query. Execute it (HTML). Execute it (CSV)

5. Auxiliary query: determine which core parameters are applicable to which types of ontology elements. Query. Execute it (HTML). Execute it (CSV)

List of queries focused on the presence of different types of parameters


As a result of these previous queries, the following relationships exist between core parameters and these types of elements, according to the current knowledge graph (this will be validated against the ontology):

  • era:Track: era:wheelSetGauge, era:gaugingProfile, era:railInclination, era:eddyCurrentBraking, era:magneticBraking, era:minimumWheelDiameter, era:minimumHorizontalRadius, era:protectionLegacySystem, era:legacyRadioSystem, era:maximumTrainDeceleration, era:gradientProfile, era:hasHotAxleBoxDetector, era:hasSevereWeatherConditions, era:loadCapability, era:maximumBrakingDistance, era:maximumPermittedSpeed, era:hasAdditionalBrakingInformation
  • era:SectionOfLine: era:length
  • era:Tunnel: era:length, era:rollingStockFireCategory
  • era:Siding: era:length, era:minimumHorizontalRadius
  • era:OperationalPoint: era:lineReference
  • era:NetElement: era:length
  • era:Platform: era:length, era:platformHeight
  • era:TrainDetectionSystem: era:trainDetectionSystem
  • era:ContactLineSystem: era:energySupplySystem, era:contactLineSystemType
  • era:VehicleType: era:wheelSetGauge, era:gaugingProfile, era:railInclination, era:eddyCurrentBraking, era:magneticBraking, era:length, era:minimumWheelDiameter, era:minimumHorizontalRadius, era:energySupplySystem, era:protectionLegacySystem, era:legacyRadioSystem, era:trainDetectionSystemType

6. Summary of the presence of core parameters applicale to tracks per member stateQuery. Execute it (HTML). Execute it (CSV)

6.1. Provide a summary of the presence of the core parameter load capability (1.1.1.1.2.4) across all tracks per member state. Query. Execute itQuery. Execute it (HTML). Execute it (CSV)

7. Summary of the presence of core parameters applicale to sections of line per member stateQuery. Execute it (HTML). Execute it (CSV)

7.1. Provide all the sections of line where core parameters do not appear (example with Spain).Query. Execute it (HTML). Execute it (CSV)

8. Summary of the presence of core parameters applicable to tunnels per member state. Query. Execute it (HTML). Execute it (CSV)

8.1 Provide all the tunnels where core parameters do not appear (example with Spain).Query. Execute it (HTML). Execute it (CSV)

9. Summary of the presence of core parameters applicable to sidings per member state.Query. Execute it (HTML). Execute it (CSV)

9.1. Provide all the sidings where core parameters do not appear (example with Spain).Query. Execute it (HTML). Execute it (CSV)

10. Summary of the presence of core parameters applicable to operational points per member state.Query. Execute it (HTML). Execute it (CSV)

10.1. Provide all the operational points where core parameters do not appear (example with Spain).Query. Execute it (HTML). Execute it (CSV)

11. Summary of the presence of core parameters applicable to platforms per member state.Query. Execute it (HTML). Execute it (CSV)

11.1. Provide all the platforms where core parameters do not appear (example with Spain).Query. Execute it (HTML). Execute it (CSV)

12. Summary of the presence of core parameters applicable to tracks' contact line systems per member state.

12.1. Provide all the tracks and contact line systems where core parameters do not appear (example with Spain):

13. Summary of the presence of core parameters applicable to tracks' train detection systems per member state Query. Execute it (HTML). Execute it (CSV)

13.1. Provide all the tracks and train detection systems where core parameters do not appear (example with Spain).Query. Execute it (HTML). Execute it (CSV)

14. Number of tracks, per country, that are not TSI compliant.Query. Execute it (HTML). Execute it (CSV)

15. Number of tracks, per country, whose associated train detection systems are not TSI compliant.Query. Execute it (HTML). Execute it (CSV)

16. Types of gauging profiles of tracks in neighbouring countries to Ukraine.Query. Execute it (HTML). Execute it (CSV)

17. Query for identifying unreachable Operational Points. Query. Execute it (HTML). Execute it (CSV)

18. Query for identifying sink Operational Points. Query. Execute it (HTML). Execute it (CSV)

19. Query that allows generating INSPIRE-related data according to the INSPIRE ontologies at . Query. Execute it (HTML). Execute it (TTL)

Most of these queries are restricted to the section of line (and its related tracks) that starts in an operational point named Dendermonde and finishes in an operational point named Baasrode-Zuid. Changing the names of the operational points or knowing their URIs or those of the section of line to be requested would allow evaluating these queries in other parts of the knowledge graph.

Query TEN-T 1 - Determine the compliance of tracks with the High Speed Load Model (HSLM) - era:highSpeedLoadModelCompliance, RINF index 1.1.1.1.2.4.2. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 2 - Classification of a line according to the INF TSI - era:lineCategory, RINF index 1.2.1.0.2.2. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 3 - Number of tracks for a sectin of line. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 4 - Type of contact line systems of the tracks in a section of line. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 5 - Wheel set gauge of the tracks of a section of line. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 6 - Energy supply system associated to the tracks of a section of line. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 7 - ERTMS / ETCS application level of a track, which expresses the possible operating relationships between track and train. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 8 - ETCS baseline installed in the track. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 9 - Location of particular points requiring specific checks due to deviations from gauging. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 10 - Combined transport profile for semi-trailers. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 11 - If ETCS in operation, fill in parameters ETCS Baseline and ETCS Level for tracks. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 12 - GSM-R version installed in the tracks of a section of line. Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 13 - Maximum Axle Load (note that this parameter does not exist and we use minAxleLoad instead, which returns currently no values). Query. Execute it (HTML). Execute it (CSV)

Query TEN-T 14 - Nominal maximum operational speed on the line as a result of INF, ENE and CCS subsystem characteristics expressed in kilometres/hour. Query. Execute it (HTML). Execute it (CSV)

SPARQL Notebooks


  1. Notebook aggregating queries for checking the completeness of parameters per country. Notebook
  2. Notebook aggregating other queries. Notebook
  3. Notebook aggregating queries related to the TEN-T data space. Notebook

See also


SPARQL query interface for the ERA Knowledge Graph.