ERA ontology queries

This folder contains 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).

List of general queries used to retrieve total number of elements and their length

Query 1

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

Query 2

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

Query 3

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

Query 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)

Query 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)

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

Queries for core parameters

Query 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)

Query 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)

Query 5

Auxiliary query: determine which of the core parameters are applicable to which types of ontology elements, according to the information contained in the knowledge graph. Query. Execute it (HTML). Execute it (CSV)

As a result of this query, 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 ** present in at least one country: era:loadCapability era:maximumPermittedSpeed era:hasSevereWeatherConditions era:gaugingProfile era:gradientProfile era:minimumHorizontalRadius era:wheelSetGauge era:railInclination era:minimumWheelDiameter era:maximumTrainDeceleration era:eddyCurrentBraking era:magneticBraking era:hasHotAxleBoxDetector era:protectionLegacySystem era:legacyRadioSystem era:maximumBrakingDistance era:hasAdditionalBrakingInformation ** absent from all countries: era:minimumTemperature era:maximumTemperature era:cantDefficiency
era:Tunnel: era:length era:rollingStockFireCategory era:tunnelIdentification
era:ContactLineSystem: era:energySupplySystem era:contactLineSystemType
era:TrainDetectionSystem: trainDetectionSystemType
era:OperationalPoint: geo:lat geo:long era:lineReference
era:Platform: era:platformId era:length era:platformHeight
era:Siding: era:length era:minimumHorizontalRadius
era:SectionOfLine: era:length

Queries 6 and 6.1. TRACKS

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

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

Queries 7 and 7.1. SECTIONS OF LINE

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

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

Queries 8 and 8.1. TUNNELS

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

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

Queries 9 and 9.1. SIDINGS

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

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

Queries 10 and 10.1. OPERATIONAL POINTS

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

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

Queries 11 and 11.1. PLATFORMS

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

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

Queries 12 and 12.1. CONTACT LINE SYSTEMS

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

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

Queries 13 and 13.1. TRAIN DETECTION SYSTEMS

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

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

Other queries that have been collected from ERA stakeholders

Query 14

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

Query 15

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

Query 16

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

Query 17

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

Query 18

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

Query 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)

Query TEN-T 15