query-043cfecb4becd99e8ff4fc8f3d64b060

rq turtle/ttl

by CamelCaseNick prefix osmt: https://wiki.openstreetmap.org/wiki/Key:

select (?stolperstein as ?item) ?osm (str(strbefore(?fullAddress, ",")) as ?address) ?inscription ?other ?stpst_hh ?extract (str(coalesce(?statedAs, replace(?label, "^Stolperstein für (?!den|die|das)", ""))) as ?name) where { ?stolperstein wdt:P31 wd:Q26703203; wdt:P131+ wd:!REPLACEME!. optional { ?stolperstein wdt:P6375 ?fullAddress. } optional { ?stolperstein wdt:P1684 ?inscription. } optional { ?stolperstein p:P547/pq:P1932 ?statedAs. } optional { ?stolperstein wdt:P8804 ?stpst_hh. }

minus { ?stolperstein wdt:P576|wdt:P1366 []. }

optional { service https://sophox.org/sparql { ?osm osmt:wikidata ?stolperstein. } }

optional { ?stolperstein wdt:P547/^schema:about ?article. ?article schema:name ?title; schema:isPartOf https://de.wikipedia.org/. minus { ?article wikibase:badge ?badge. values ?badge { wd:Q70893996 wd:Q70894304 } } service wikibase:mwapi { bd:serviceParam wikibase:endpoint "de.wikipedia.org"; wikibase:api "Generator"; mwapi:generator "allpages"; mwapi:prop "extracts"; wikibase:limit "once"; mwapi:gaplimit 1; mwapi:gapfrom ?title; mwapi:exchars 300; mwapi:exintro true; mwapi:explaintext true. ?extract wikibase:apiOutput "extract/text()".
} }

bind(if(exists { ?stolpersteinB wdt:P31 wd:Q26703203; wdt:P547/^wdt:P547 ?stolperstein. minus { ?stolpersteinB wdt:P576|wdt:P1366 []. } filter (?stolpersteinB != ?stolperstein) }, "y", "") as ?other)

service wikibase:label { bd:serviceParam wikibase:language "de,en". ?stolperstein rdfs:label ?label. } } order by asc(?address) asc(replace(?name, "^.?([^ ]+)( geb\..)?$", "$1")) asc(?name)

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#by CamelCaseNick
prefix osmt: <https://wiki.openstreetmap.org/wiki/Key:>

select
(?stolperstein as ?item) ?osm (str(strbefore(?fullAddress, ",")) as ?address) ?inscription ?other ?stpst_hh ?extract
(str(coalesce(?statedAs, replace(?label, "^Stolperstein für (?!den|die|das)", ""))) as ?name) 
where {
  ?stolperstein wdt:P31 wd:Q26703203;
                wdt:P131+ wd:!REPLACEME!.
  optional { ?stolperstein wdt:P6375 ?fullAddress. }
  optional { ?stolperstein wdt:P1684 ?inscription. }
  optional { ?stolperstein p:P547/pq:P1932 ?statedAs. }
  optional { ?stolperstein wdt:P8804 ?stpst_hh. }

  minus { ?stolperstein wdt:P576|wdt:P1366 []. }

  optional {
    service <https://sophox.org/sparql> {
      ?osm osmt:wikidata ?stolperstein.
    }
  }

  optional {
    ?stolperstein wdt:P547/^schema:about ?article.
    ?article schema:name ?title; schema:isPartOf <https://de.wikipedia.org/>.
    minus { ?article wikibase:badge ?badge. values ?badge { wd:Q70893996 wd:Q70894304 } }
    service wikibase:mwapi {
      bd:serviceParam wikibase:endpoint "de.wikipedia.org";
                      wikibase:api "Generator"; mwapi:generator "allpages"; mwapi:prop "extracts";
                      wikibase:limit "once"; mwapi:gaplimit 1;
                      mwapi:gapfrom ?title;
                      mwapi:exchars 300; mwapi:exintro true; mwapi:explaintext true.
      ?extract wikibase:apiOutput "extract/text()".  
    }
  }

  bind(if(exists {
    ?stolpersteinB wdt:P31 wd:Q26703203;
                   wdt:P547/^wdt:P547 ?stolperstein.
    minus { ?stolpersteinB wdt:P576|wdt:P1366 []. }
    filter (?stolpersteinB != ?stolperstein)
  }, "y", "") as ?other)

  service wikibase:label {
    bd:serviceParam wikibase:language "de,en".
    ?stolperstein rdfs:label ?label.
  }
}
order by asc(?address) asc(replace(?name, "^.*?([^ ]+)( geb\\..*)?$", "$1")) asc(?name)

Query found at