User:ChristianSW/Snippets

States of Germany with iNat-place-ID

The following query uses these:

• P18
• P31
• P625
• P7471
• Q1221156

#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!