Hofoen
Joined 9 March 2013
Common
editCoordinates
edit- Swiss Timber Bridges LV03(CH1903) / EPSG 21781: https://podcast.paravan.ch/gc-tools/in-schweizer-koordinaten-umrechnen/
User Scripting
editIntegration
editDevelopment
editSources and Citations
editSPARQL
edit- https://en.wikibooks.org/wiki/SPARQL/Expressions_and_Functions
- https://heardlibrary.github.io/digital-scholarship/lod/wikibase/
- https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format/Proposal
Working with Properties
editThe following query uses these:
- Properties: connecting line (P81) , crosses (P177) , carries (P2505)
SELECT ?subject ?subjectLabel ?pedicateLabel ?p ?pLabel ?pedicate WHERE { ?subject ?p wd:Q819045. # if you need wd + wdt # VALUES ?p { wdt:P81 wdt:P177 wdt:P2505 }. # ?pedicate wikibase:directClaim ?p. # if you need wds + ps VALUES ?p { ps:P81 ps:P177 ps:P2505 }. ?pedicate wikibase:statementProperty ?p. SERVICE wikibase:label { bd:serviceParam wikibase:language "de". } } ORDER BY ?subject
Working with Qualifiers
editThe following query uses these:
- Items: Twin Peaks (Q2085) , Dale Cooper (Q2629231)
SELECT * WHERE { ?property1 wikibase:claim ?p1 . ?property1 wikibase:statementProperty ?ps1 . ?property1 wikibase:qualifier ?pq1 . ?property1 a wikibase:Property . # ?property2 wikibase:claim ?p2 . ?property2 wikibase:qualifier ?pq2 . ?property2 a wikibase:Property . # #wd:Q2085 ?p1 ?_p1 . #?_p1 ?ps1 ?_ps1 . #?_p1 ?pq2 ?_pq2 . # ?subject ?p1 ?_p1 . ?_p1 ?ps1 ?_ps1 . ?_p1 ?pq2 wd:Q2629231 . }
Images in Qualifiers
editqualifers "image" (or user P180 "depicts")
The following query uses these:
- Items: taxon (Q16521) , species (Q7432)
- Properties: instance of (P31) , taxon rank (P105) , image (P18)
SELECT ?item ?itemLabel ?typeLabel ?property1Label ?property2Label ?_pq2 WHERE { ?item wdt:P31 wd:Q16521 . #?item wdt:P105 wd:Q7432 . ?property1 wikibase:claim ?p1 . #?property1 wikibase:statementProperty ?ps1 . #?property1 wikibase:qualifier ?pq1 . ?property1 a wikibase:Property . #?property2 wikibase:claim ?p2 . ?property2 wikibase:qualifier ?pq2 . ?property2 a wikibase:Property . ?item wdt:P31 ?type . ?item ?p1 ?_p1 . #?_p1 ?ps1 ?_ps1 . ?_p1 ?pq2 ?_pq2 . ?_p1 pq:P18 ?_pq2 . SERVICE wikibase:label {bd:serviceParam wikibase:language "en".} } LIMIT 100