User:Charles Matthews/Plant editation SPARQL
Jump to navigation
Jump to search
Try it!
Try it!
Try it!
Try it!
Try it!
#Selects plants that have a pollinator statement
SELECT ?item ?itemLabel
WHERE
{?item wdt:P1703 [ ]
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#Selects plants that have a pollinator statement and no Wikidata image
SELECT ?item ?itemLabel
WHERE
{?item wdt:P1703 [ ].
MINUS {?item wdt:P18 [ ]}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#Selects pollinators that have a plant statement
SELECT ?item ?itemLabel
WHERE
{?item wdt:P1704 [ ]
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#Seed plant species
SELECT ?q { ?q wdt:P171* wd:Q25814 ; wdt:P105 wd:Q7432 }
#Canidae (for example, your taxon here) mapped by "genus" and "species" (i.e. one and two levels down in the taxonomic tree). TreeMap view in rectangles.
#defaultView:TreeMap
SELECT ?family ?familyLabel ?genus ?genusLabel ?species ?speciesLabel
WHERE
{
BIND(wd:Q25324 AS ?family) .
?species wdt:P171 ?genus.
?genus wdt:P171 ?family.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}