Topic: Pollinators

I am looking into the possibility of having a 'Pollinators' data search option and it has proved remarkably difficult to find a definitive list of the groups that are thought to be involved. I have put together the list below (sourced mainly from an American university website). I don't want the list to be complete as species level, so if a family of insects contains some species that are known to be pollinators then it is simpler to pull in the whole lot. The list is in SQL format, so if you want to copy and paste it into your own queries you can do so - in our system it will form a view, and for those non SQL readers, the lines that begin with "--" are comment lines, there for my benefit to know which taxon group the families belong to.

Does anyone have any thoughts on groups I've missed or suggestions for further refinements?

Dave


WHERE    DEN.TAXON_GROUP = 'insect - butterfly'
    Or DEN.TAXON_GROUP = 'insect - moth'
-- DEN.TAXON_GROUP= 'insect - hymenopteran'
    Or Hier.Family = 'Formicidae'
    Or Hier.Family = 'Tenthredinidae'
    Or Hier.Family = 'Sphecidae'
    Or Hier.Family = 'Vespidae'
    Or Hier.Family = 'Pompilidae'
    Or Hier.Family = 'Andrenidae'
    Or Hier.Family = 'Apidae'
    Or Hier.Family = 'Colletidae'
    Or Hier.Family = 'Halicidae'
    Or Hier.Family = 'Megachilidae'
--    Or DEN.TAXON_GROUP = 'insect - beetle (Coleoptera)'
    Or Hier.Family = 'Elateridae'
    Or Hier.Family = 'Scarabaeidae'
    Or Hier.Family = 'Cleridae'
    Or Hier.Family = 'Nitidulidae'
    Or Hier.Family = 'Chrysomelidae'
    Or Hier.Family = 'Staphylinidae'
    Or Hier.Family = 'Meloidae'
    Or Hier.Family = 'Cerambycidae'
    Or Hier.Family = 'Mordellidae'
    Or Hier.Family = 'Oedemeridae'
    Or Hier.Family = 'Melyridae'    -- No records
    Or DEN.TAXON_GROUP = 'insect - true bug (Hemiptera)'
--    Or DEN.TAXON_GROUP = 'insect - true fly (Diptera)'
    Or Hier.Family = 'Mycetophilidae'
    Or Hier.Family = 'Cecidomiidae'    -- No records
    Or Hier.Family = 'Simuliidae'
    Or Hier.Family = 'Chironomidae'
    Or Hier.Family = 'Certopogonidae'
    Or Hier.Family = 'Culicidae'
    Or Hier.Family = 'Bibionidae'
    Or Hier.Family = 'Bombyliidae'
    Or Hier.Family = 'Empididae'
    Or Hier.Family = 'Stratiomyidae'
    Or Hier.Family = 'Phoridae'
    Or Hier.Family = 'Lonchopteridae'
    Or Hier.Family = 'Dolichopodidae'
    Or Hier.Family = 'Syrphidae'
    Or Hier.Family = 'Conopidae'
    Or Hier.Family = 'Tachinidae'
    Or Hier.Family = 'Calliphoridae'
    Or Hier.Family = 'Muscidae'
    Or Hier.Family = 'Anthomyiidae'
    Or DEN.TAXON_GROUP = 'insect - scorpion fly (Mecoptera)'
    Or DEN.TAXON_GROUP = 'insect - stick insect (Phasmida)'
    Or DEN.TAXON_GROUP = 'insect - earwig (Dermaptera)'
    Or DEN.TAXON_GROUP = 'insect - thrips (Thysanoptera)'

Dave Slade
Senior IT & Records Officer,  SEWBReC
13 St Andrews Crescent, Cardiff, CF10 3DB

Re: Pollinators

I think the lack of a definitive list is because no one knows-  or rather, pretty much anything can be a pollinator. In fact, it's probably easier to exclude those (insects) that aren't pollinators (stylops? water beetles?). E.g. you can add Cantharidae, Curculionidae, Scraptiidae, Pyrochroidae, Coccinellidae, Kateretidae, Byturidae... to the beetle list.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership