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 Acacia Acajou d'Afrique African mahogany Aimela Alan Alaskan cedar Almaciga minyak Amabilis fir Amboyna wood (burls) American cherry American mahogany American red oak American walnut American white ash American white oak 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) Bauvudi (Fiji) Belian Bengang Benuang Billian Bindang Bintangor Binuang Bitis Black walnut Blackbean Blackbutt Boelian Borneo kauri Brown podocarp Brown terminalia Brush box 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 Calophyllum Canada pine Canadian pine Canadian rock maple Canadian white ash Canoe cedar Caribbean pine Celtis Celtis hard Celtis light Cherry Chestnut white oak Coast spruce Coastal douglas fir Coconut wood Cuban mahogany Cypress