User:Charles Matthews/Plant editation SPARQL

#Selects plants that have a pollinator statement
SELECT ?item ?itemLabel
  WHERE
     {?item wdt:P1703 [ ]
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
      }

Try it!

#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". }
      }

Try it!

#Selects pollinators that have a plant statement
SELECT ?item ?itemLabel
  WHERE
     {?item wdt:P1704 [ ]
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
      }

Try it!

#Seed plant species
SELECT ?q { ?q wdt:P171* wd:Q25814 ; wdt:P105 wd:Q7432 }

Try it!

#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" }
}

Try it!