Data source: data.sfgov.org
This data as json, CSV (advanced)
| id | value ▼ |
|---|---|
| 256 | Ficus laurel :: |
| 148 | Ficus macrophylla :: Morton Bay Fig |
| 167 | Ficus microcarpa 'Retusa' :: Pot Belly Fig |
| 94 | Ficus microcarpa :: Chinese Banyan |
| 32 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' |
| 43 | Ficus nitida :: Laurel Fig |
| 59 | Ficus retusa nitida :: Banyan Fig |
| 188 | Ficus rubiginosa :: Port Jackson Fig |
| 486 | Fortunella margarita :: Kumquat |
| 449 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash |
| 23 | Fraxinus americana :: American Ash |
| 320 | Fraxinus angustifolia :: Narrow-leaved Ash |
| 500 | Fraxinus holotricha :: Holotricha Ash |
| 380 | Fraxinus ornus :: Flowering Ash |
| 101 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash |
| 206 | Fraxinus oxycarpa :: Ash |
| 83 | Fraxinus spp :: Ash Spp |
| 121 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash |
| 10 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash |
| 242 | Fraxinus velutina 'Glabra' :: Arizona Ash |
| 412 | Fraxinus velutina 'Modesto' :: Modesto Ash Tree 'Modesto' |
| 405 | Fraxinus velutina :: Modesto Ash |
| 462 | Fraxinus x Moraine :: Moraine Ash |
| 331 | Fremontodendron spp :: Flannel Bush Tree |
| 505 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree |
| 474 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree |
| 68 | Geijera parviflora :: Australian Willow |
| 489 | Geijera spp :: Geijera |
| 134 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold |
| 461 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo |
| 316 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo |
| 179 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair |
| 418 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga |
| 44 | Ginkgo biloba :: Maidenhair Tree |
| 456 | Gleditsia triacanthos 'Aurea' :: Honey Locust 'Aurea' |
| 373 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' |
| 334 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust |
| 67 | Gleditsia triacanthos :: Honey Locust |
| 171 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' |
| 145 | Grevillea robusta :: Silk Oak Tree |
| 369 | Grevillea spp :: Silkoak species |
| 477 | Griselinia lucida :: Griselinia |
| 263 | Hakea laurina :: Sea Urchin Tree |
| 14 | Hakea suaveolens :: Sweet Hakea Tree |
| 322 | Heteromeles arbutifolia :: Toyon |
| 240 | Howea forsteriana :: Kentia Palm |
| 91 | Hymenosporum flavum :: Sweet Shade |
| 286 | Hypelate trifoliata :: White ironwood |
| 310 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree |
| 277 | Ilex aquifolium :: European Holly |
| 484 | Ilex opaca :: American Holly |
| 163 | Ilex spp :: Holly Species |
| 52 | Jacaranda mimosifolia :: Jacaranda |
| 425 | Jubaea chilensis :: Chilean Wine Palm |
| 492 | Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' |
| 407 | Juglans californica :: Walnut: Black (s.calif) |
| 442 | Juglans hindsii :: Walnut: Black (n.calif) |
| 288 | Juglans nigra :: Eastern black walnut |
| 348 | Juglans regia :: Walnut: English |
| 226 | Juniperus californica :: California juniper |
| 19 | Juniperus chinensis :: Juniper |
| 539 | Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' |
| 186 | Juniperus silicicola :: Southern red cedar |
| 283 | Koelreuteria bipinnata :: Chinese Flame Tree |
| 56 | Koelreuteria paniculata :: Golden Rain Tree |
| 525 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle |
| 205 | Lagerstroemia indica 'Tuscarora' :: Tuscarora Crape Myrtle |
| 199 | Lagerstroemia indica :: Crape Myrtle |
| 562 | Lagerstroemia spp :: Crape myrtle species |
| 560 | Lagerstroemia x 'Tuscarora' :: Tuscarora Crape Myrtle |
| 48 | Lagunaria patersonii :: Primrose Tree |
| 30 | Laurus nobilis :: Sweet Bay: Grecian Laurel |
| 457 | Laurus x 'Saratoga' :: Hybrid Laurel |
| 38 | Leptospermum laevigatum :: Australian Tea Tree |
| 448 | Leptospermum petersonii :: Lemon Scented Tea Tree |
| 151 | Leptospermum quinquenervia :: Tea Tree |
| 248 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree |
| 264 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree |
| 487 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree |
| 27 | Leptospermum scoparium :: New Zealand Tea Tree |
| 375 | Leucadendron 'Gold Strike' :: Yellow conebush |
| 427 | Leucodendron argenteum :: Silver Tree |
| 4 | Ligustrum japonicum :: Japanese Privet |
| 55 | Ligustrum lucidum :: Glossy Privet |
| 284 | Ligustrum ovalifolium :: California privet |
| 481 | Liquidambar formosana :: Chinese Sweet Gum |
| 312 | Liquidambar orientalis :: Oriental Sweet Gum |
| 501 | Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum |
| 479 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum |
| 450 | Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum |
| 328 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum |
| 530 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar |
| 62 | Liquidambar styraciflua :: American Sweet Gum |
| 85 | Liriodendron tulipifera :: Tulip Tree |
| 245 | Lithocarpus densiflorus :: Tan Oak |
| 410 | Livistona chinensis :: Chinese fan palm |
| 11 | Lophostemon confertus :: Brisbane Box |
| 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood |
| 354 | Macadamia tetraphylla :: Macadamia |
| 170 | Magnolia champaca :: Champa |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "qSpecies" ( "id" INTEGER PRIMARY KEY , "value" TEXT );