Common name     Scientific name

A - C D - F G - J K - M N - P Q - S T - V W - Z

Select species SELECT Code, Common_Name AS Name FROM gwg_species WHERE SubStr(Common_Name, 1,1)='A' UNION SELECT Code, Name AS Name FROM gwg_species_other_names WHERE SubStr(Name, 1,1)='A' ORDER BY NameAboudikrou Aboudikrou Acacia Acajou d'Afrique Acajou d'Afrique African mahogany African mahogany Aimela alan Alaskan cedar Almaciga minyak Amabilis fir Amboyna wood (burls) Amboyna wood (burls) American mahogany American white ash Angsena Angsena Apa apa Apitong Ash SELECT Code, Common_Name AS Name FROM gwg_species WHERE SubStr(Common_Name, 1,1)='B' UNION SELECT Code, Name AS Name FROM gwg_species_other_names WHERE SubStr(Name, 1,1)='B' ORDER BY NameBalau Baltic pine Bamboo bangkirai Basswood Bau (Indonesia) Bau (Indonesia) Bauvudi (Fiji) Belian Bengang Benuang billian Bindang Bintangor Binuang Bitis Black walnut Black walnut Black walnut Black walnut Black walnut Blackbean Blackbutt boelian Borneo kauri Brown podocarp Brown terminalia SELECT Code, Common_Name AS Name FROM gwg_species WHERE SubStr(Common_Name, 1,1)='C' UNION SELECT Code, Name AS Name FROM gwg_species_other_names WHERE SubStr(Name, 1,1)='C' ORDER BY NameCalifornian walnut Californian walnut Californian walnut Californian walnut Californian walnut Calophyllum Canadian pine Canadian rock maple Canadian rock maple Canadian white ash Canadian white ash Canoe cedar Caribbean pine CBFT (community based fair trade) taun Celtis Celtis hard Celtis light Chestnut white oak Chestnut white oak Chestnut white oak Coast spruce Coastal douglas fir Coconut wood Cuban mahogany Cypress