emailconfirmed
952
edits
OlafJanssen (talk | contribs) (→SPARQL) |
OlafJanssen (talk | contribs) |
||
Line 60: | Line 60: | ||
=== Eenvoudige zoekvragen === | === Eenvoudige zoekvragen === | ||
* [https://kbtestwikibase.wikibase.cloud/query/# | * [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 | # 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/> | ||
SELECT ?p ? | SELECT ?p ?pType | ||
?p | ?pLabelNL ?pLabelEN | ||
OPTIONAL{?p wdt:P1 ? | ?pDescriptionNL ?pDescriptionEN | ||
(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. |