User:ChristianSW/Examples: Difference between revisions

m (sparql -list)
m (...)
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
<sparql tryit="1">
<sparql tryit="1">
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/>
PREFIX observer: <https://www.inaturalist.org/people/>
PREFIX observer: <https://www.inaturalist.org/people/>


Line 66: Line 65:
</sparql>
</sparql>


== My Coccinellidae ==
== My ladybirds ==
<sparql tryit="1">
<sparql tryit="1">
#defaultView:Map
#defaultView:Map{"hide":"?location"}


PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/>
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>
PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/>
PREFIX observer: <https://www.inaturalist.org/people/>
PREFIX observer: <https://www.inaturalist.org/people/>


SELECT ?location ?iNatlink ?layer WHERE {
SELECT DISTINCT ?location ?iNatlink ?layer WHERE {
   ?observation    wbt:P3  observer:christiansw ;
   ?observation    wbt:P3  observer:christiansw ;
                     wbt:P8  ?location ;
                     wbt:P8  ?location ;
Line 84: Line 83:
   ?wikidata_mapping rdfs:label ?label FILTER (lang(?label) = "de") .
   ?wikidata_mapping rdfs:label ?label FILTER (lang(?label) = "de") .
   BIND(?label AS ?layer).
   BIND(?label AS ?layer).
    }
  }
}
}
</sparql>
</sparql>

Latest revision as of 22:25, 26 February 2020

Observations by observer with links to iNaturalist

PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>
PREFIX observer: <https://www.inaturalist.org/people/>

SELECT ?iNatlink WHERE {
   ?observation wbt:P3 observer:christiansw .
   ?observation wbt:P6 ?iNatlink .
}

Try it!


Single observation with location and link to iNaturalist

#defaultView:Map

PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/>
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>

SELECT ?location ?iNatlink WHERE {
  VALUES ?observation {wb:Q124485}
   ?observation wbt:P8 ?location ;
                wbt:P6 ?iNatlink .
}

Try it!


Link to German Wikipedia

#defaultView:Map

PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/>
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>

SELECT ?location ?iNatlink ?wikipedia WHERE {
  VALUES ?observation {wb:Q124625}
   ?observation     wbt:P8  ?location ;
                    wbt:P6  ?iNatlink ;
                    wbt:P9  ?scientific_name .
   ?scientific_name wbt:P11 ?wikidata_mapping .
SERVICE <https://query.wikidata.org/sparql> {
    ?wikipedia schema:about ?wikidata_mapping . 
    ?wikipedia schema:inLanguage "de" .
    ?wikipedia schema:isPartOf <https://de.wikipedia.org/> .
    }
}

Try it!


Link to Wikispecies

#defaultView:Map

PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/>
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>

SELECT ?location ?iNatlink ?wikispecies WHERE {
  VALUES ?observation {wb:Q131704}
   ?observation     wbt:P8  ?location ;
                    wbt:P6  ?iNatlink ;
                    wbt:P9  ?scientific_name .
   ?scientific_name wbt:P11 ?wikidata_mapping .
SERVICE <https://query.wikidata.org/sparql> {
    ?wikispecies schema:about ?wikidata_mapping . 
    ?wikispecies schema:isPartOf <https://species.wikimedia.org/> .
    }
}

Try it!


My ladybirds

#defaultView:Map{"hide":"?location"}

PREFIX wb: <http://biodiversity.wiki.opencura.com/entity/>
PREFIX wbt: <http://biodiversity.wiki.opencura.com/prop/direct/>
PREFIX observer: <https://www.inaturalist.org/people/>

SELECT DISTINCT ?location ?iNatlink ?layer WHERE {
   ?observation     wbt:P3  observer:christiansw ;
                    wbt:P8  ?location ;
                    wbt:P6  ?iNatlink ;
                    wbt:P9  ?scientific_name .
   ?scientific_name wbt:P11 ?wikidata_mapping .
FILTER(?scientific_name IN (wb:Q5053, wb:Q5526, wb:Q97245, wb:Q128695, wb:Q96351)).
SERVICE <https://query.wikidata.org/sparql> {
   ?wikidata_mapping rdfs:label ?label FILTER (lang(?label) = "de") .
   BIND(?label AS ?layer).
   }
}

Try it!