home / trees

qSpecies

Data source: data.sfgov.org

568 rows

View and edit SQL

id value
1 Pinus radiata :: Monterey Pine
2 Palm (unknown Genus) :: Palm Spp
3 Metrosideros excelsa :: New Zealand Xmas Tree
4 Geijera parviflora :: Australian Willow
5 Corymbia ficifolia :: Red Flowering Gum
6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem'
7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia
8 Tristaniopsis laurina :: Swamp Myrtle
9 Lophostemon confertus :: Brisbane Box
10 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry
11 Platanus x hispanica :: Sycamore: London Plane
12 Ligustrum lucidum :: Glossy Privet
13 Tree(s) ::
14 Olea europaea 'Fruitless' :: Fruitless Olive
15 Acacia decurrens :: Acacia: Silver Wattle
16 Ceanothus Sps :: California lilac
17 Melaleuca quinquenervia :: Cajeput
18 Ficus nitida :: Laurel Fig
19 Prunus x yedoensis :: Yoshino Cherry
20 Arbutus 'Marina' :: Hybrid Strawberry Tree
21 Acacia melanoxylon :: Blackwood Acacia
22 Pinus canariensis :: Canary Island Pine
23 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus
24 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud'
25 Quercus tomentella :: Island oak
26 Ulmus parvifolia :: Chinese Elm
27 Myoporum laetum :: Myoporum
28 Pyrus calleryana :: Ornamental Pear
29 Jacaranda mimosifolia :: Jacaranda
30 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius
31 Ulmus pumila :: Siberian Elm
32 Ficus carica :: Edible Fig
33 Pittosporum crassifolium :: Karo Tree
34 Radermachera sinica :: China Doll Tree
35 Liriodendron tulipifera :: Tulip Tree
36 Callistemon viminalis :: Weeping Bottlebrush
37 Magnolia spp :: Magnolia
38 Pittosporum undulatum :: Victorian Box
39 Magnolia grandiflora :: Southern Magnolia
40 Salix spp :: Willow
41 Quercus suber :: Cork Oak
42 Olea europaea :: Olive Tree
43 Prunus cerasifera :: Cherry Plum
44 Liquidambar styraciflua :: American Sweet Gum
45 Callistemon citrinus :: Lemon Bottlebrush
46 Magnolia grandiflora 'Russet' :: Russet Magnolia
47 Shrub :: Shrub
48 Trachycarpus fortunei :: Windmill Palm
49 Ginkgo biloba :: Maidenhair Tree
50 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant'
51 Maytenus boaria :: Mayten
52 Alnus cordata :: Italian Alder
53 Rhamnus alaternus :: Italian Buckthorn
54 Persea americana :: Avocado
55 ::
56 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo
57 Cupaniopsis anacardioides :: Carrotwood
58 Arbutus unedo :: Strawberry Tree
59 Liquidambar orientalis :: Oriental Sweet Gum
60 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear
61 Pyrus spp :: Pear Tree
62 Cercis occidentalis :: Western Redbud
63 Chamaerops humilis :: Mediterranean Fan Palm
64 Eriobotrya deflexa :: Bronze Loquat
65 Pyrus kawakamii :: Evergreen Pear
66 Acacia longifolia :: Golden Wattle
67 Pistacia chinensis :: Chinese Pistache
68 Acer rubrum :: Red Maple
69 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore
70 Rhaphiolepis indica :: India Hawthorn
71 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint
72 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair
73 Leptospermum laevigatum :: Australian Tea Tree
74 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia
75 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane
76 Leptospermum scoparium :: New Zealand Tea Tree
77 Eucalyptus pulverulenta :: Silver Mountain Gum Tree
78 Pinus halepensis :: Allepo Pine
79 Ficus microcarpa :: Chinese Banyan
80 Lagunaria patersonii :: Primrose Tree
81 Taxus baccata :: Irish Yew
82 Cordyline australis :: Dracena Palm
83 Phoenix canariensis :: Canary Island Date Palm
84 Acer spp :: Maple
85 Pittosporum tenuifolium :: Tawhiwhi Pittosporum
86 Washingtonia robusta :: Mexican Fan Palm
87 Prunus laurocerasus :: English laurel
88 Cedrus atlantica Glauca :: Blue Atlas Cedar
89 Pinus Spp :: Pine Spp
90 Schinus molle :: California Pepper
91 Cupressus macrocarpa :: Monterey Cypress
92 Syagrus romanzoffianum :: Queen Palm
93 Magnolia doltsopa :: Himalayan Magnolia
94 Juniperus chinensis :: Juniper
95 Ficus rubiginosa :: Port Jackson Fig
96 Cedrus deodara :: Deodar Cedar
97 Araucaria columnaris :: Coral reef araucaria
98 Pinus pinea :: Italian Stone Pine
99 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree
100 Ligustrum japonicum :: Japanese Privet

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "qSpecies" (
                    "id" INTEGER PRIMARY KEY,
                    "value" TEXT
                )
Powered by Datasette · Query took 3.03ms · Data source: data.sfgov.org