Tootfinder

Opt-in global Mastodon full text search. Join the index!

@awinkler@openbiblio.social
2025-08-22 20:02:52

#SPARQL -Spielerei: Die Gemälde der Berliner Gemäldegalerie nach Fläche geordnet: qlever.cs.uni-freiburg.de/wiki (Ausführungszeit 166ms, im WDQS landet die Anfrage im …

@awinkler@openbiblio.social
2025-08-22 12:21:50

I had never used (or heard of) the 'DESCRIBE' form in #SPARQL. Sounds useful, though, if you don't know your data model well. So "DESCRIBE wd:Q42" provides a list of all triples where Q42 appears in any position (w.wiki/F6jK

@awinkler@openbiblio.social
2025-09-22 07:09:52
Content warning:

It took me some time to make sense of the paragraph on how to remove statements using #quickstatements here: wikidata.org/wiki/Help:QuickSt

SPARQL Code Snippet from Wikidata Query Service SELECT ?prefix ?qsStatementID WHERE { ?item p:PXXX ?s . # add more constraints here to get statements you want to remove BIND ( ("-STATEMENT") AS ?prefix ) BIND ( REPLACE(STR(?s), "http://www.wikidata.org/entity/statement/", "") AS ?statementID ) BIND ( REPLACE(STR(?item), "http://www.wikidata.org/entity/", "") AS ?qid) BIND ( REPLACE(?statementID, CONCAT(?qid, "-"), "") AS ?strippedStatementID ) BIND ( CONCAT(?qid, "$", ?strippedS…