trees

Custom SQL query returning 101 rows (hide)

Query parameters

idqSpecies
101 Ficus Spp. ::
102 Crataegus phaenopyrum :: Washington Hawthorn
103 Melaleuca linariifolia :: Flaxleaf Paperbark
104 Prunus lyonii :: Catalina Cherry
105 Acacia spp :: Acacia Spp
106 Arbutus unedo :: Strawberry Tree
107 Fremontodendron spp :: Flannel Bush Tree
108 Corymbia calophylla ::
109 Cedrus deodara :: Deodar Cedar
110 Acer buergeranum :: Trident Maple
111 Acacia decurrens :: Acacia: Silver Wattle
112 Casuarina cunninghamiana :: Horsetail pine
113 Juniperus chinensis :: Juniper
114 Chitalpa tashkentensis ::
115 Ulmus 'Frontier' :: Frontier Elm
116 Trachycarpus fortunei :: Windmill Palm
117 Melaleuca spp :: Melaleuca spp
118 Pittosporum tobira :: Japanese Mockorange
119 Eriobotrya japonica :: Edible Loquat
120 Citrus spp :: Lemon: Orange: Lime
121 Fraxinus spp :: Ash Spp
122 Acacia baileyana :: Bailey's Acacia
123 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear
124 Acer japonicum :: Japanese Maple
125 Hymenosporum flavum :: Sweet Shade
126 Yucca gloriosa :: Spanish Dagger
127 Eucalyptus sideroxylon :: Red Ironbark
128 Acer rubrum 'October Glory' :: Red October Glory Maple
129 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree
130 Crateagus spp :: Hawthorn
131 Koelreuteria paniculata :: Golden Rain Tree
132 Ulmus propinqua 'Emerald Sunshine' :: Emerald Sunshine Elm
133 Crataegus laevigata :: English Hawthorn
134 Quercus coccinea :: Scarlet Oak
135 Arecastrum romanzoffianum :: Queen Palm
136 Cercis occidentalis :: Western Redbud
137 Podocarpus macrophyllus :: Yew Pine
138 Pittosporum eugenioides :: Tarata
139 Malus floribunda :: Showy Crab Apple: Japanese Crabapple
140 Acer rubrum 'Armstrong' :: Armstrong Red Maple
141 Magnolia champaca :: Champa
142 Eucalyptus cinerea :: Ash-colored Eucalyptus
143 Pittosporum tenuifolium :: Tawhiwhi Pittosporum
144 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush
145 Liriodendron tulipifera :: Tulip Tree
146 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'
147 Magnolia x soulangiana :: Saucer Magnolia
148 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore
149 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant'
150 Acacia longifolia :: Golden Wattle
151 Melaleuca ericifolia :: Heath Melaleuca
152 Cassia leptophylla :: Gold Medallion Tree
153 Celtis sinensis :: Chinese Hackberry
154 Tibochina urvilleana :: Princess Flower
155 Sequoia sempervirens :: Coast Redwood
156 Dracaena draco :: Dragon Tree
157 Leptospermum scoparium :: New Zealand Tea Tree
158 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum
159 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm
160 Phoenix canariensis :: Canary Island Date Palm
161 Olea europaea 'Swan Hill' :: Olive
162 Fraxinus oxycarpa 'Raywood' :: Raywood Ash
163 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius
164 Koelreuteria bipinnata :: Chinese Flame Tree
165 Carpinus betulus :: European Hornbeam
166 Photinia fraseri :: Photinia: Chinese photinia
167 Prunus blireiana :: Flowering Plum
168 Aesculus californica :: California Buckeye
169 Corynocarpus laevigata :: New Zealand Laurel
170 Pittosporum spp :: Pittosporum spp
171 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau'
172 Quercus agrifolia :: Coast Live Oak
173 Casurina stricta :: Beefwood: Drooping She-Oak
174 Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga
175 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust
176 Washingtonia filifera :: California Fan Palm
177 Olea europaea 'Fruitless' :: Fruitless Olive
178 Quercus tomentella :: Island oak
179 Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust
180 Acer macrophyllum :: Big Leaf Maple
181 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless
182 Gleditsia triacanthos :: Honey Locust
183 Olea Majestic Beauty ::
184 Populus alba :: White Poplar
185 Cupressocyparis leylandii :: Leyland Cypress
186 Heteromeles arbutifolia :: Toyon
187 Podocarpus henkelii :: Long-Leafed Yellow-Wood
188 Eucalyptus melliodora :: Yellow Box
189 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford
190 Aesculus hippocastanum :: White Horsechestnut
191 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz'
192 Ceanothus Sps :: California lilac
193 Acer rubrum 'Red Sunset' :: Red Swamp Maple
194 Paulownia fortunei :: Dragon tree
195 Cupaniopsis anacardioides :: Carrotwood
196 Robinia x ambigua :: Locust
197 Macadamia tetraphylla :: Macadamia
198 Fraxinus velutina 'Glabra' :: Arizona Ash
199 Albizia julibrissin :: Mimosa Silk Tree
200 Picea Spp :: Spruce Spp
201 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum