Main Page: Difference between revisions

Jump to navigation Jump to search
Line 60: Line 60:


=== Eenvoudige zoekvragen ===
=== Eenvoudige zoekvragen ===
* [https://kbtestwikibase.wikibase.cloud/query/#PREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fkbtestwikibase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Fkbtestwikibase.wikibase.cloud%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0A%0ASELECT%20%3Fp%20%3FpLabel%20%3FpDescription%20%3FpAltLabel%20%3Fw%20WHERE%20%7B%0A%20%20%3Fp%20rdf%3Atype%20wikibase%3AProperty.%0A%20%20OPTIONAL%7B%3Fp%20wdt%3AP1%20%3Fw.%7D%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20ASC%28xsd%3Ainteger%28STRAFTER%28STR%28%3Fp%29%2C%20%27P%27%29%29%29 Wikidata-equivalenten van properties in deze Wikibase] (= property mapping van deze Wikibase naar Wikidata) - WERKT NOG NIET!! --> bug in de SPARQL-indexer? https://phabricator.wikimedia.org/T311040
* [https://kbtestwikibase.wikibase.cloud/query/#%23%20Overview%20of%20properties%20in%20this%20Wikibase%2C%20%0A%23%20with%20their%20Labels%2C%20Descriptions%20and%20Aliases%2C%20%0A%23%20both%20in%20NL%20and%20in%20EN%2C%20%0A%23%20as%20well%20their%20equivalent%20properties%20in%20Wikidata%20%28if%20applicable%29%20%0A%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20schema%3A%20%3Chttp%3A%2F%2Fschema.org%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fkbtestwikibase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fp%20%3FpType%20%0A%3FpLabelNL%20%3FpLabelEN%20%0A%3FpDescriptionNL%20%3FpDescriptionEN%20%0A%28GROUP_CONCAT%28DISTINCT%20%3FpAliasNL%20%3B%20separator%20%3D%20%22%20%7C%20%22%29%20as%20%3FpAliasesNL%20%29%0A%28GROUP_CONCAT%28DISTINCT%20%3FpAliasEN%20%3B%20separator%20%3D%20%22%20%7C%20%22%29%20as%20%3FpAliasesEN%20%29%0A%3FwikidataEquivalentProperty%0A%0AWHERE%20%7B%0A%0A%20%20%3Fp%20wikibase%3ApropertyType%20%3FpType%20.%0A%20%20OPTIONAL%7B%3Fp%20wdt%3AP1%20%3FwikidataEquivalentProperty.%7D%20%0A%0A%20%20OPTIONAL%7B%3Fp%20rdfs%3Alabel%20%3FpLabelNL%20FILTER%28LANG%28%3FpLabelNL%29%3D%27nl%27%29.%7D%0A%20%20OPTIONAL%7B%3Fp%20rdfs%3Alabel%20%3FpLabelEN%20FILTER%28LANG%28%3FpLabelEN%29%3D%27en%27%29.%7D%0A%20%20%0A%20%20OPTIONAL%7B%3Fp%20schema%3Adescription%20%3FpDescriptionNL%20FILTER%28LANG%28%3FpDescriptionNL%29%20%3D%20%22nl%22%29.%20%7D%20%20%0A%20%20OPTIONAL%7B%3Fp%20schema%3Adescription%20%3FpDescriptionEN%20FILTER%28LANG%28%3FpDescriptionEN%29%20%3D%20%22en%22%29.%20%7D%0A%20%20%0A%20%20OPTIONAL%7B%3Fp%20skos%3AaltLabel%20%3FpAliasNL%20FILTER%28LANG%28%3FpAliasNL%29%20%3D%20%22nl%22%29.%20%7D%20%20%0A%20%20OPTIONAL%7B%3Fp%20skos%3AaltLabel%20%3FpAliasEN%20FILTER%28LANG%28%3FpAliasEN%29%20%3D%20%22en%22%29.%20%7D%20%20%20%20%20%0A%20%20%20%20%0A%7D%0AGROUP%20BY%20%3Fp%20%3FpType%20%3FpLabelNL%20%3FpLabelEN%20%3FpDescriptionNL%20%3FpDescriptionEN%20%3FwikidataEquivalentProperty%0AORDER%20BY%20ASC%28xsd%3Ainteger%28STRAFTER%28STR%28%3Fp%29%2C%20%27P%27%29%29%29 Overview of properties in this Wikibase, with their Labels, Descriptions and Aliases, both in NL and in EN, as well their equivalent properties in Wikidata (if applicable)]


<sparql tryit="1">
<sparql tryit="1">
PREFIX bd: <http://www.bigdata.com/rdf#>
# Overview of properties in this Wikibase,
# with their Labels, Descriptions and Aliases,
# both in NL and in EN,
# as well their equivalent properties in Wikidata (if applicable)
 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <https://kbtestwikibase.wikibase.cloud/prop/direct/>
PREFIX wdt: <https://kbtestwikibase.wikibase.cloud/prop/direct/>
PREFIX p: <https://kbtestwikibase.wikibase.cloud/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>


SELECT ?p ?pLabel ?pDescription ?pAltLabel ?w WHERE {
SELECT ?p ?pType
   ?p rdf:type wikibase:Property.
?pLabelNL ?pLabelEN
   OPTIONAL{?p wdt:P1 ?w.}  
?pDescriptionNL ?pDescriptionEN
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
(GROUP_CONCAT(DISTINCT ?pAliasNL ; separator = " | ") as ?pAliasesNL )
(GROUP_CONCAT(DISTINCT ?pAliasEN ; separator = " | ") as ?pAliasesEN )
?wikidataEquivalentProperty
 
WHERE {
 
   ?p wikibase:propertyType ?pType .
   OPTIONAL{?p wdt:P1 ?wikidataEquivalentProperty.}  
 
   OPTIONAL{?p rdfs:label ?pLabelNL FILTER(LANG(?pLabelNL)='nl').}
  OPTIONAL{?p rdfs:label ?pLabelEN FILTER(LANG(?pLabelEN)='en').}
 
  OPTIONAL{?p schema:description ?pDescriptionNL FILTER(LANG(?pDescriptionNL) = "nl"). } 
  OPTIONAL{?p schema:description ?pDescriptionEN FILTER(LANG(?pDescriptionEN) = "en"). }
 
  OPTIONAL{?p skos:altLabel ?pAliasNL FILTER(LANG(?pAliasNL) = "nl"). } 
  OPTIONAL{?p skos:altLabel ?pAliasEN FILTER(LANG(?pAliasEN) = "en"). }    
   
}
}
GROUP BY ?p ?pType ?pLabelNL ?pLabelEN ?pDescriptionNL ?pDescriptionEN ?wikidataEquivalentProperty
ORDER BY ASC(xsd:integer(STRAFTER(STR(?p), 'P')))
ORDER BY ASC(xsd:integer(STRAFTER(STR(?p), 'P')))
</sparql>
</sparql>
Line 90: Line 112:
}
}
</sparql>
</sparql>
=== Zie ook ===
=== Zie ook ===
* [[Project:SPARQL/examples]] - de queries op deze pagina worden in de Voorbeelden-dropdown op https://kbtestwikibase.wikibase.cloud/query/ weergegeven.
* [[Project:SPARQL/examples]] - de queries op deze pagina worden in de Voorbeelden-dropdown op https://kbtestwikibase.wikibase.cloud/query/ weergegeven.
emailconfirmed
952

edits

Navigation menu