query-fbc5d61390aef5b4da6d6b0df03437f0

rq turtle/ttl

Norske skip bygget i 1990 eller senere PREFIX sdir: https://www.sdir.no/skipssok/#/?q= PREFIX martr: https://www.marinetraffic.com/en/ais/details/ships/imo: PREFIX nais: https://nais.kystverket.no/aisstream/

SELECT DISTINCT ?itemLabel (YEAR(?start_) AS ?start) (YEAR(?end_) AS ?end) ?imo ?mmsi ?item (URI(CONCAT(STR(martr:), ?imo)) AS ?martr) (URI(CONCAT(STR(sdir:), ?imo)) AS ?sdir) (URI(CONCAT(STR(nais:), ?mmsi)) AS ?nais) WHERE { ?item wdt:P31/wdt:P279* wd:Q11446; wdt:P8047 wd:Q20. OPTIONAL { ?item wdt:P729 ?start_. } OPTIONAL { ?item wdt:P730 ?end_. } OPTIONAL { ?item wdt:P176 ?manufacturer. } OPTIONAL { ?item wdt:P458 ?imo. } OPTIONAL { ?item wdt:P587 ?mmsi. } FILTER (?start_ >= "1990-01-01"^^xsd:dateTime) FILTER NOT EXISTS { ?item rdfs:label ?nbLabel. FILTER(LANG(?nbLabel) = "nb") } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?start_)

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Norske skip bygget i 1990 eller senere
PREFIX sdir: <https://www.sdir.no/skipssok/#/?q=>
PREFIX martr: <https://www.marinetraffic.com/en/ais/details/ships/imo:>
PREFIX nais: <https://nais.kystverket.no/aisstream/>

SELECT DISTINCT
  ?itemLabel (YEAR(?start_) AS ?start) (YEAR(?end_) AS ?end) ?imo ?mmsi ?item 
  (URI(CONCAT(STR(martr:), ?imo)) AS ?martr)
  (URI(CONCAT(STR(sdir:), ?imo)) AS ?sdir)
  (URI(CONCAT(STR(nais:), ?mmsi)) AS ?nais)
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q11446;
    wdt:P8047 wd:Q20.
  OPTIONAL { ?item wdt:P729 ?start_. }
  OPTIONAL { ?item wdt:P730 ?end_. }
  OPTIONAL { ?item wdt:P176 ?manufacturer. }
  OPTIONAL { ?item wdt:P458 ?imo. }
  OPTIONAL { ?item wdt:P587 ?mmsi. }
  FILTER (?start_ >= "1990-01-01"^^xsd:dat)
  FILTER NOT EXISTS { ?item rdfs:label ?nbLabel. FILTER(LANG(?nbLabel) = "nb") }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?start_)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v9("?end") v4("?end_"):::projected v6("?imo"):::projected v3("?item"):::projected v5("?manufacturer") v10("?martr") v7("?mmsi"):::projected v12("?nais") v2("?nbLabel") v11("?sdir") v8("?start") v1("?start_"):::projected a1((" ")) c8(["wd:Q20"]):::iri c15(["bd:serviceParam"]):::iri c17(["#91;AUTO_LANGUAGE#93;,en"]):::literal c6(["wd:Q11446"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["?nbLabel = 'nb'"]] e0f0 --> e0v1 e0v2 --"rdfs:label"--> e0v1 e0v2("?item"):::projected e0v1("?nbLabel"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> v3 f0 --> c2 f1[["?nbLabel = 'nb'"]] f1 --> v2 v3 --"rdfs:label"--> v2 f2[["?start_ >= s1990-01-01^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f2 --> v1 v3 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c6 v3 --"wdt:P8047"--> c8 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P729".-> v1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P730".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P176".-> v5 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P458".-> v6 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P587".-> v7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end bind3[/"year-from-dateTime(?start_)"/] v1 --o bind3 bind3 --as--o v8 bind4[/"year-from-dateTime(?end_)"/] v4 --o bind4 bind4 --as--o v9 bind5[/"concat(str(https://www.marinetraffic.com/en/ais/details/ships/imo:),?imo)"/] v6 --o bind5 bind5 --as--o v10 bind6[/"concat(str(https://www.sdir.no/skipssok/#/?q=),?imo)"/] v6 --o bind6 bind6 --as--o v11 bind7[/"concat(str(https://nais.kystverket.no/aisstream/),?mmsi)"/] v7 --o bind7 bind7 --as--o v12