Data source: data.sfgov.org
This data as json, CSV (advanced)
| id ▼ | value |
|---|---|
| 1 | Myoporum laetum :: Myoporum |
| 2 | Metrosideros excelsa :: New Zealand Xmas Tree |
| 3 | Pinus radiata :: Monterey Pine |
| 4 | Ligustrum japonicum :: Japanese Privet |
| 5 | Acacia melanoxylon :: Blackwood Acacia |
| 6 | Acer rubrum :: Red Maple |
| 7 | Agonis flexuosa :: Peppermint Willow |
| 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood |
| 9 | Pyrus calleryana :: Ornamental Pear |
| 10 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash |
| 11 | Lophostemon confertus :: Brisbane Box |
| 12 | Arbutus 'Marina' :: Hybrid Strawberry Tree |
| 13 | Podocarpus gracilor :: Fern Pine |
| 14 | Hakea suaveolens :: Sweet Hakea Tree |
| 15 | Platanus x hispanica :: Sycamore: London Plane |
| 16 | Prunus cerasifera :: Cherry Plum |
| 17 | Tree(s) :: |
| 18 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry |
| 19 | Juniperus chinensis :: Juniper |
| 20 | Callistemon viminalis :: Weeping Bottlebrush |
| 21 | Magnolia grandiflora :: Southern Magnolia |
| 22 | Maytenus boaria :: Mayten |
| 23 | Fraxinus americana :: American Ash |
| 24 | Araucaria heterophylla :: Norfolk Island Pine |
| 25 | Schinus terebinthifolius :: Brazilian Pepper |
| 26 | Pittosporum undulatum :: Victorian Box |
| 27 | Leptospermum scoparium :: New Zealand Tea Tree |
| 28 | Callistemon citrinus :: Lemon Bottlebrush |
| 29 | Potential Site :: Potential Site |
| 30 | Laurus nobilis :: Sweet Bay: Grecian Laurel |
| 31 | Trachycarpus fortunei :: Windmill Palm |
| 32 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' |
| 33 | Robinia x ambigua :: Locust |
| 34 | Cupressocyparis leylandii :: Leyland Cypress |
| 35 | Prunus serrulata :: Ornamental Cherry |
| 36 | Eucalyptus sideroxylon :: Red Ironbark |
| 37 | Tristaniopsis laurina :: Swamp Myrtle |
| 38 | Leptospermum laevigatum :: Australian Tea Tree |
| 39 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus |
| 40 | Eucalyptus Spp :: Eucalyptus |
| 41 | Olea europaea :: Olive Tree |
| 42 | Acacia baileyana :: Bailey's Acacia |
| 43 | Ficus nitida :: Laurel Fig |
| 44 | Ginkgo biloba :: Maidenhair Tree |
| 45 | Rhamnus alaternus :: Italian Buckthorn |
| 46 | Ulmus parvifolia :: Chinese Elm |
| 47 | Cupressus macrocarpa :: Monterey Cypress |
| 48 | Lagunaria patersonii :: Primrose Tree |
| 49 | Eriobotrya deflexa :: Bronze Loquat |
| 50 | Melaleuca quinquenervia :: Cajeput |
| 51 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' |
| 52 | Jacaranda mimosifolia :: Jacaranda |
| 53 | Ulmus pumila :: Siberian Elm |
| 54 | :: |
| 55 | Ligustrum lucidum :: Glossy Privet |
| 56 | Koelreuteria paniculata :: Golden Rain Tree |
| 57 | Prunus x 'Amanogawa' :: Flowering Cherry |
| 58 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' |
| 59 | Ficus retusa nitida :: Banyan Fig |
| 60 | Corymbia ficifolia :: Red Flowering Gum |
| 61 | Arbutus unedo :: Strawberry Tree |
| 62 | Liquidambar styraciflua :: American Sweet Gum |
| 63 | Prunus amygdalus :: Almond |
| 64 | Private shrub :: Private Shrub |
| 65 | Phoenix dactylifera :: Date Palm |
| 66 | Crataegus laevigata :: English Hawthorn |
| 67 | Gleditsia triacanthos :: Honey Locust |
| 68 | Geijera parviflora :: Australian Willow |
| 69 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm |
| 70 | Afrocarpus gracilior :: Fern Pine |
| 71 | Pinus canariensis :: Canary Island Pine |
| 72 | Prunus domestica 'Mariposa' :: Mariposa Plum |
| 73 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia |
| 74 | Acer negundo :: Box Elder |
| 75 | Washingtonia robusta :: Mexican Fan Palm |
| 76 | Quercus suber :: Cork Oak |
| 77 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive |
| 78 | Quercus ilex :: Holly Oak |
| 79 | Tristania conferta :: |
| 80 | Olea europaea 'Fruitless' :: Fruitless Olive |
| 81 | Platanus racemosa :: California Sycamore |
| 82 | Pyrus kawakamii :: Evergreen Pear |
| 83 | Fraxinus spp :: Ash Spp |
| 84 | Prunus spp :: Cherry |
| 85 | Liriodendron tulipifera :: Tulip Tree |
| 86 | Populus nigra 'Italica' :: Lombardy Poplar |
| 87 | Acer rubrum 'Armstrong' :: Armstrong Red Maple |
| 88 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia |
| 89 | Magnolia spp :: Magnolia |
| 90 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia |
| 91 | Hymenosporum flavum :: Sweet Shade |
| 92 | Magnolia x soulangiana :: Saucer Magnolia |
| 93 | Melaleuca nesophila :: Pink Melaleuca |
| 94 | Ficus microcarpa :: Chinese Banyan |
| 95 | Betula spp :: Birch |
| 96 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford |
| 97 | Ceratonia siliqua :: Carob |
| 98 | Shrub :: Shrub |
| 99 | Chamaerops humilis :: Mediterranean Fan Palm |
| 100 | Phoenix canariensis :: Canary Island Date Palm |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "qSpecies" ( "id" INTEGER PRIMARY KEY , "value" TEXT );