qSpecies

Data source: data.sfgov.org

562 rows

View and edit SQL

id ▼ value
101 Fraxinus oxycarpa 'Raywood' :: Raywood Ash
102 Prunus blireiana :: Flowering Plum
103 Eucalyptus globulus :: Blue Gum
104 Photinia fraseri :: Photinia: Chinese photinia
105 Pinus Spp :: Pine Spp
106 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau'
107 Eucalyptus pulverulenta :: Silver Mountain Gum Tree
108 Pittosporum crassifolium :: Karo Tree
109 Acacia stenophylla :: Shoestring Acacia
110 Pittosporum eugenioides :: Tarata
111 Celtis sinensis :: Chinese Hackberry
112 Morus alba :: White Mulberry
113 Persea americana :: Avocado
114 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint
115 Brahea edulis :: Guadalupe Palm
116 Sequoia sempervirens :: Coast Redwood
117 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa'
118 Cupaniopsis anacardioides :: Carrotwood
119 Ulmus americana :: American Elm
120 Acer buergeranum :: Trident Maple
121 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash
122 Eucalyptus robusta :: Swamp mahogany
123 Casuarina cunninghamiana :: Horsetail pine
124 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust
125 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree
126 Albizia julibrissin :: Mimosa Silk Tree
127 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore
128 Pittosporum spp :: Pittosporum spp
129 Cedrus deodara :: Deodar Cedar
130 Melaleuca spp :: Melaleuca spp
131 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear
132 Dodonaea viscosa :: Hop Bush
133 Prunus caroliniana :: Carolina Cherry Laurel
134 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold
135 Crataegus phaenopyrum :: Washington Hawthorn
136 Cupressus sempervirens :: Italian Cypress
137 Brugmansia spp :: Angel trumpet
138 Schinus molle :: California Pepper
139 Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia
140 Acacia longifolia :: Golden Wattle
141 Cordyline australis :: Dracena Palm
142 Syagrus romanzoffianum :: Queen Palm
143 Pinus pinea :: Italian Stone Pine
144 Rhaphiolepis indica :: India Hawthorn
145 Grevillea robusta :: Silk Oak Tree
146 Betula pendula :: European White Birch
147 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer'
148 Ficus macrophylla :: Morton Bay Fig
149 Butia capitata :: Pindo Palm
150 Pistacia chinensis :: Chinese Pistache
151 Leptospermum quinquenervia :: Tea Tree
152 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane
153 Photinia fraseri :: Photinia Tree
154 Araucaria araucana :: Monkey puzzle
155 Melaleuca linariifolia :: Flaxleaf Paperbark
156 Styphnolobium japonicum :: Chinese scholar tree
157 Magnolia x soulangiana 'Rustica Rubra' :: Chinese Magnolia
158 Acer spp :: Maple
159 Acer macrophyllum :: Big Leaf Maple
160 Crateagus spp :: Hawthorn
161 Palm (unknown Genus) :: Palm Spp
162 Nyssa sylvatica :: Tupelo: Sour Gum
163 Ilex spp :: Holly Species
164 Pinus halepensis :: Allepo Pine
165 Corymbia maculata :: Spotted Gum
166 Populus tremuloides :: Quaking aspen
167 Ficus microcarpa 'Retusa' :: Pot Belly Fig
168 Podocarpus macrophyllus :: Yew Pine
169 Robinia pseudoacacia :: Black Locust
170 Magnolia champaca :: Champa
171 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks'
172 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud
173 Sapium sebiferum :: Chinese Tallow
174 Zelkova serrata :: Sawleaf Zelkova
175 Acer palmatum :: Japanese Maple
176 Acacia spp :: Acacia Spp
177 Calocedrus decurrens :: Incense Cedar
178 Syzygium australe :: Eugenia
179 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair
180 Quercus agrifolia :: Coast Live Oak
181 Acacia decurrens :: Acacia: Silver Wattle
182 Salix babylonica :: Weeping Willow
183 Acer japonicum :: Japanese Maple
184 Melaleuca ericifolia :: Heath Melaleuca
185 Araucaria columnaris :: Coral reef araucaria
186 Juniperus silicicola :: Southern red cedar
187 Magnolia doltsopa :: Himalayan Magnolia
188 Ficus rubiginosa :: Port Jackson Fig
189 Washingtonia filifera :: California Fan Palm
190 Eriobotrya japonica :: Edible Loquat
191 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius
192 Olea Majestic Beauty ::
193 Pittosporum tenuifolium :: Tawhiwhi Pittosporum
194 Aesculus x carnea :: Red Horse Chestnut
195 Umbellularia californica :: California Bay
196 Prunus persica nectarina :: Flowering Nectarine Tree
197 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush
198 Syzygium paniculatum :: Brush Cherry
199 Lagerstroemia indica :: Crape Myrtle
200 Escallonia bifida :: White escallonia

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 5.729ms · Data source: data.sfgov.org