User:ChristianSW/Snippets

States of Germany with iNaturalist Search URLs

#defaultView:Map

SELECT ?placename ?pic ?coord ?iNatlinkI ?iNatlinkII  WHERE {
SERVICE <https://query.wikidata.org/sparql> {
  ?place wdt:P31   wd:Q1221156 ;
         wdt:P7471 ?iNat_place_ID ;
         wdt:P625  ?coord .
OPTIONAL { ?place wdt:P18 ?pic . }
BIND(URI(CONCAT("https://www.inaturalist.org/places/", STR(?iNat_place_ID))) AS ?iNatlinkI)
BIND(URI(CONCAT("https://www.inaturalist.org/observations?subview=grid&view=species&place_id=", STR(?iNat_place_ID))) AS ?iNatlinkII)
  ?place rdfs:label ?placename FILTER (lang(?placename) = "de") .
  }
}

Try it!