zazuko/ld-didok

Values

Opened this issue · 11 comments

timetable2014 commented 
PREFIX schema: <http://schema.org/>
PREFIX xml: <http://www.w3.org/XML/1998/namespace/>
prefix SBBOnto: <http://lod.opentransportdata.swiss/vocab/>
prefix geoW3C: <http://www.w3.org/2003/01/geo/wgs84_pos#> 
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix purl: <http://www.purl.org/>
prefix xmls: <http://www.w3.org/2001/XMLSchema#>

select DISTINCT ?stationwkt ?dailyTrainTrip ?betriebstag ?trainComposition ?departureStation ?depTime ?Kompo ?Rolling ?haltestelle ?arrivalStation ?Ankunftshaltestelle ?lat ?long
FROM <https://linked.opendata.swiss/graph/SBB/dailytraintrips>
FROM <https://linked.opendata.swiss/graph/SBB/rollingstock>
FROM <https://linked.opendata.swiss/graph/FOT/didok>
{
  ?dailyTrainTrip a SBBOnto:DailyTrainTrip; 
  SBBOnto:dayUnixTimeStamp ?betriebstag ;
# SBBOnto:dayUnixTimeStamp 1505858400000 ;
  SBBOnto:dailyTrainComposition ?trainComposition .
  
  ?trainComposition schema:departureStation ?departureStation .
  ?trainComposition SBBOnto:departureStationDepartureTime ?depTime.
  ?trainComposition SBBOnto:dailyTrainCompositionRollingStock ?Kompo.
  ?Kompo SBBOnto:rollingStock ?Rolling.
  ?rolling SBBOnto:rollingStockIdentifier ?Rollingstock.
   Values  ?Rollingstock {"50 85 2633086-7" "91 85 4420222-2"}  
  ?departureStation rdfs:label ?haltestelle.
  ?trainComposition schema:arrivalStation ?arrivalStation.
  ?arrivalStation rdfs:label ?Ankunftshaltestelle.
  ?arrivalStation <http://www.w3.org/2003/01/geo/wgs84_pos#lat> ?long.
  ?arrivalStation <http://www.w3.org/2003/01/geo/wgs84_pos#long> ?lat.
    BIND(STRDT(CONCAT("POINT(", STR(?lat), " ", STR(?long), ")"), geo:wktLiteral) AS ?stationwkt).
}
order by desc(?depTime)
ktk commented

That query delivers too much data for Yasgui it seems, with a limit it works in Yasgui and it does execute properly in general. See version with limit: https://goo.gl/wPNhYk

Full query:

PREFIX schema: <http://schema.org/>
PREFIX xml: <http://www.w3.org/XML/1998/namespace/>
PREFIX SBBOnto: <http://lod.opentransportdata.swiss/vocab/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX purl: <http://www.purl.org/>
PREFIX xmls: <http://www.w3.org/2001/XMLSchema#>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>

SELECT DISTINCT ?stationwkt ?dailyTrainTrip ?betriebstag ?trainComposition ?departureStation ?depTime ?Kompo ?Rolling ?haltestelle ?arrivalStation ?Ankunftshaltestelle ?lat ?long
FROM <https://linked.opendata.swiss/graph/SBB/dailytraintrips>
FROM <https://linked.opendata.swiss/graph/SBB/rollingstock>
FROM <https://linked.opendata.swiss/graph/FOT/didok>
{
  ?dailyTrainTrip a SBBOnto:DailyTrainTrip ;
    SBBOnto:dayUnixTimeStamp ?betriebstag ;
    # SBBOnto:dayUnixTimeStamp 1505858400000 ;
    SBBOnto:dailyTrainComposition ?trainComposition .
  
  ?trainComposition schema:departureStation ?departureStation ;
    SBBOnto:departureStationDepartureTime ?depTime ;
    SBBOnto:dailyTrainCompositionRollingStock ?Kompo .

  ?Kompo SBBOnto:rollingStock ?Rolling .

  ?rolling SBBOnto:rollingStockIdentifier ?Rollingstock .
  VALUES  ?Rollingstock {"50 85 2633086-7" "91 85 4420222-2"}  

  ?departureStation rdfs:label ?haltestelle .
  ?trainComposition schema:arrivalStation ?arrivalStation .
  ?arrivalStation rdfs:label ?Ankunftshaltestelle ;
    geo:hasGeometry/geo:asWKT ?stationwkt
}
ORDER BY desc(?depTime)
ktk commented

Quickly checked via curl, returns 119'233 lines

timetable2014 commented

these are to many rows

ktk commented

Then we have a look at the query tomorrow in screenshare

timetable2014 commented

something went wrong with the join. I get also records back, which are not in the query

ktk commented

Curl:

curl https://test.lindas-data.ch/sparql\?query\=PREFIX+schema%3A+%3Chttp%3A%2F%2Fschema.org%2F%3E%0APREFIX+xml%3A+%3Chttp%3A%2F%2Fwww.w3.org%2FXML%2F1998%2Fnamespace%2F%3E%0APREFIX+SBBOnto%3A+%3Chttp%3A%2F%2Flod.opentransportdata.swiss%2Fvocab%2F%3E%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+purl%3A+%3Chttp%3A%2F%2Fwww.purl.org%2F%3E%0APREFIX+xmls%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0APREFIX+geo%3A+%3Chttp%3A%2F%2Fwww.opengis.net%2Font%2Fgeosparql%23%3E%0A%0ASELECT+DISTINCT+%3Fstationwkt+%3FRollingstock+%3FdailyTrainTrip+%3Fbetriebstag+%3FtrainComposition+%3FdepartureStation+%3FdepTime+%3FKompo+%3Frolling+%3Fhaltestelle+%3FarrivalStation+%3FAnkunftshaltestelle%0AFROM+%3Chttps%3A%2F%2Flinked.opendata.swiss%2Fgraph%2FSBB%2Fdailytraintrips%3E%0AFROM+%3Chttps%3A%2F%2Flinked.opendata.swiss%2Fgraph%2FSBB%2Frollingstock%3E%0AFROM+%3Chttps%3A%2F%2Flinked.opendata.swiss%2Fgraph%2FFOT%2Fdidok%3E%0A%7B%0A++%3FdailyTrainTrip+a+SBBOnto%3ADailyTrainTrip+%3B%0A++++SBBOnto%3AdayUnixTimeStamp+%3Fbetriebstag+%3B%0A++++%23+SBBOnto%3AdayUnixTimeStamp+1505858400000+%3B%0A++++SBBOnto%3AdailyTrainComposition+%3FtrainComposition+.%0A++%0A++%3FtrainComposition+schema%3AdepartureStation+%3FdepartureStation+%3B%0A++++SBBOnto%3AdepartureStationDepartureTime+%3FdepTime+%3B%0A++++SBBOnto%3AdailyTrainCompositionRollingStock+%3FKompo+.%0A%0A++%3FKompo+SBBOnto%3ArollingStock+%3Frolling+.%0A%0A++%3Frolling+SBBOnto%3ArollingStockIdentifier+%3FRollingstock+.%0A++VALUES++%3FRollingstock+%7B%2250+85+2633086-7%22+%2291+85+4420222-2%22%7D++%0A%0A++%3FdepartureStation+rdfs%3Alabel+%3Fhaltestelle+.%0A++%3FtrainComposition+schema%3AarrivalStation+%3FarrivalStation+.%0A++%3FarrivalStation+rdfs%3Alabel+%3FAnkunftshaltestelle+%3B%0A++++geo%3AhasGeometry%2Fgeo%3AasWKT+%3Fstationwkt%0A%7D%0AORDER+BY+desc\(%3FdepTime\) -H "Accept: text/csv"
timetable2014 commented

PREFIX schema: http://schema.org/
PREFIX xml: http://www.w3.org/XML/1998/namespace/
PREFIX SBBOnto: http://lod.opentransportdata.swiss/vocab/
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
PREFIX purl: http://www.purl.org/
PREFIX xmls: http://www.w3.org/2001/XMLSchema#
PREFIX geo: http://www.opengis.net/ont/geosparql#

SELECT DISTINCT ?stationwkt ?Rollingstock ?dailyTrainTrip ?betriebstag ?trainComposition ?departureStation ?depTime ?Kompo ?rolling ?haltestelle ?arrivalStation ?Ankunftshaltestelle
FROM https://linked.opendata.swiss/graph/SBB/dailytraintrips
FROM https://linked.opendata.swiss/graph/SBB/rollingstock
FROM https://linked.opendata.swiss/graph/FOT/didok
{
?dailyTrainTrip a SBBOnto:DailyTrainTrip ;
SBBOnto:dayUnixTimeStamp ?betriebstag ;
# SBBOnto:dayUnixTimeStamp 1505858400000 ;
SBBOnto:dailyTrainComposition ?trainComposition .

?trainComposition schema:departureStation ?departureStation ;
SBBOnto:departureStationDepartureTime ?depTime ;
SBBOnto:dailyTrainCompositionRollingStock ?Kompo .

?Kompo SBBOnto:rollingStock ?rolling .

?rolling SBBOnto:rollingStockIdentifier ?Rollingstock .
VALUES ?Rollingstock {"50 85 2633086-7" "94 85 1502402-4" "94 85 2502402-2" "94 85 3502402-0" "94 85 4502402-2" "94 85 1502203-6" "94 85 1502204-4" "94 85 1502205-1" "94 85 1502206-9" "94 85 1502207-7" "94 85 1502208-5" "94 85 1502402-4" "94 85 1502403-2" "94 85 1502404-0" "94 85 1502405-7" "94 85 2502203-4" "94 85 2502204-2" "94 85 2502205-9" "94 85 2502206-7" "94 85 2502207-5" "94 85 2502208-3" "94 85 2502402-2" "94 85 2502403-0" "94 85 2502404-8" "94 85 2502405-5" "94 85 3502203-2" "94 85 3502205-7" "94 85 3502206-5" "94 85 3502207-3" "94 85 3502208-1" "94 85 3502402-0" "94 85 3502403-8" "94 85 3502404-6" "94 85 3502405-3" "94 85 4502203-0" "94 85 4502205-5" "94 85 4502206-3" "94 85 4502207-1" "94 85 4502208-9" "94 85 4502402-8" "94 85 4502403-6" "94 85 4502404-4" "94 85 4502405-1" "94 85 5502203-7" "94 85 5502205-2" "94 85 5502206-0" "94 85 5502207-8" "94 85 5502208-6" "94 85 6502203-5" "94 85 6502205-0" "94 85 6502206-8" "94 85 6502207-6" "94 85 6502208-4" "94 85 7502203-3" "94 85 7502205-8" "94 85 7502206-6" "94 85 7502207-4" "94 85 7502208-2" "94 85 8502203-1" "94 85 8502205-6" "94 85 8502206-4" "94 85 8502207-2" "94 85 8502208-0"}

?departureStation rdfs:label ?haltestelle .
?trainComposition schema:arrivalStation ?arrivalStation .
?arrivalStation rdfs:label ?Ankunftshaltestelle ;
geo:hasGeometry/geo:asWKT ?stationwkt
}
ORDER BY desc(?depTime)

ktk commented

VALUES durch FILTER ersetzen:

    FILTER(?Rollingstock IN ("50 85 2633086-7", "91 85 4420222-2",  "94 85 8502208-0"))
timetable2014 commented

funktioniert auf Lindas test

PREFIX schema: http://schema.org/
PREFIX xml: http://www.w3.org/XML/1998/namespace/
PREFIX SBBOnto: http://lod.opentransportdata.swiss/vocab/
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
PREFIX purl: http://www.purl.org/
PREFIX xmls: http://www.w3.org/2001/XMLSchema#
PREFIX geo: http://www.opengis.net/ont/geosparql#

SELECT DISTINCT ?stationwkt ?Rollingstock ?dailyTrainTrip ?betriebstag ?trainComposition ?departureStation ?depTime ?Kompo ?rolling ?haltestelle ?arrivalStation ?Ankunftshaltestelle
FROM https://linked.opendata.swiss/graph/SBB/dailytraintrips
FROM https://linked.opendata.swiss/graph/SBB/rollingstock
FROM https://linked.opendata.swiss/graph/FOT/didok
{
?dailyTrainTrip a SBBOnto:DailyTrainTrip ;
SBBOnto:dayUnixTimeStamp ?betriebstag ;
# SBBOnto:dayUnixTimeStamp 1505858400000 ;
SBBOnto:dailyTrainComposition ?trainComposition .

?trainComposition schema:departureStation ?departureStation ;
SBBOnto:departureStationDepartureTime ?depTime ;
SBBOnto:dailyTrainCompositionRollingStock ?Kompo .

?Kompo SBBOnto:rollingStock ?rolling .

?rolling SBBOnto:rollingStockIdentifier ?Rollingstock .
Filter (?Rollingstock IN ("94 85 1502205-1","94 85 1502207-7","94 85 1502402-4","94 85 1502405-7"))
?departureStation rdfs:label ?haltestelle .
?trainComposition schema:arrivalStation ?arrivalStation .
?arrivalStation rdfs:label ?Ankunftshaltestelle ;
geo:hasGeometry/geo:asWKT ?stationwkt
}
ORDER BY desc(?depTime)