query-8b75558387208fc2620963065164d4fc

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
# Map of files authored by a Wikimedia Commons user
#TEMPLATE={"template":"Map of files authored by ?username","variables":{"?username":{"query":" SELECT DISTINCT ?username WHERE { [] p:P170/pq:P4174 ?username .} LIMIT 100"} } }
#defaultView:Map
SELECT ?file ?image ?coordinates (?date AS ?layer)  (wikibase:decodeUri(CONCAT("File:", substr(str(?url),53))) AS ?filename)
WHERE {
BIND("Lutzto" AS ?username)
?file (p:P170/pq:P4174) ?username;
OPTIONAL {?file  wdt:P625|wdt:P1259 ?coordinates. }
OPTIONAL { ?file wdt:P571 ?date. }
# convert file into image
?file schema:contentUrl ?url .
bind(iri(concat("http://commons.wikimedia.org/wiki/Special:FilePath/", wikibase:decodeUri(substr(str(?url),53)))) AS ?image)
}
LIMIT 10000

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?coordinates"):::projected v4("?date"):::projected v2("?file"):::projected v8("?filename") v6("?image"):::projected v7("?layer") v5("?url"):::projected v1("?username") a1((" ")) bind0[/"'Lutzto'"/] bind0 --as--o v1 v2 --"p:P170"--> a1 a1 --"p:qualifier/P4174"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 -."p:direct/P1259".-> v3 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P625"--> v3 end union0r <== or ==> union0l end end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P571".-> v4 end v2 --"schema:contentUrl"--> v5 bind1[/"concat('http://commons.wikimedia.org/wiki/Special:FilePath/',http://wikiba.se/ontology#decodeUri(substring(str(?url),'53^^xsd:integer')))"/] v5 --o bind1 bind1 --as--o v6 bind2[/"?date"/] v4 --o bind2 bind2 --as--o v7 bind3[/"http://wikiba.se/ontology#decodeUri(concat('File:',substring(str(?url),'53^^xsd:integer')))"/] v5 --o bind3 bind3 --as--o v8