Data source: data.sfgov.org
This data as json, CSV (advanced)
| id ▲ | value |
|---|---|
| 562 | Lagerstroemia spp :: Crape myrtle species |
| 561 | Moringa oleifera :: Drumstick tree |
| 560 | Lagerstroemia x 'Tuscarora' :: Tuscarora Crape Myrtle |
| 559 | Populus deltoides :: Eastern cottonwood |
| 558 | Eucalyptus citriodora :: Lemon scented eucalyptus |
| 557 | Callistemon salignus :: White flowering bottlebrush |
| 556 | Cedrela fissilis :: Argentine cedar |
| 555 | Pinus torreyana :: Torrey Pine |
| 554 | Acer platanoides :: Norway Maple |
| 553 | Wodyetia bifurcata :: Foxtail palm |
| 552 | Acer tegmentosum :: Manchurian snakebark maple |
| 551 | Arbutus menziesii :: Pacific Madrone |
| 550 | Acacia iteaphylla :: Willow wattle |
| 549 | Mangifera indica :: Mango |
| 548 | Cercocarpus betuloides :: Mountain mahogany |
| 547 | Cercidiphyllum japonicum :: Katsura tree |
| 546 | Pinus sylvestris :: Scots Pine |
| 545 | Brachychiton rupestris :: Narrow-leaf bottle tree |
| 544 | Beaucarnea recurvata :: Ponytail palm |
| 543 | Pseudopanax lessonii :: Five finger |
| 542 | Meryta sinclairii :: Puka or puke tree |
| 541 | Acer campestre :: Hedge Maple |
| 540 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' |
| 539 | Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' |
| 538 | Persea americana 'Stewart' :: Stewart Avocado |
| 537 | Prunus campanulata :: Taiwan Flowering Cherry |
| 536 | Dypsis decaryi :: Triangle palm |
| 535 | Erythrina caffra :: Coral tree |
| 534 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree |
| 533 | Rhopalostylis sapida :: Nikau palm |
| 532 | Acer ginnela :: Amur Maple |
| 531 | Magnolia grandiflora 'Timeless Beauty' :: Timeless Beauty Southern Magnolia |
| 530 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar |
| 529 | Ceanothus thyrsiflorus :: Blueblossom Ceanothus |
| 528 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' |
| 527 | Ulmus procera :: English Elm |
| 526 | Chionanthus retusa :: Chinese Fringe Tree |
| 525 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle |
| 524 | x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree |
| 523 | Ulmus parvifolia 'True Green' :: True Green Chinese Elm |
| 522 | Acer saccharum :: Sugar Maple |
| 521 | Crinodendron patagua :: Lily-of-the-Valley Tree |
| 520 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry |
| 519 | Quercus tomentella :: Island oak |
| 518 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple |
| 517 | Prunus sargentii :: Sargent Cherry |
| 516 | Populus canadensis :: Canadian Poplar |
| 515 | Citrus x hystrix :: Kaffir lime |
| 514 | Chorisia speciosa :: Silk Floss Tree |
| 513 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree |
| 512 | Eucalyptus simmondsi :: Simmond's Peppermint |
| 511 | Ulmus glabra :: Scotch Elm |
| 510 | Pinus pinaster :: Maritime Pine |
| 509 | Platanus orientalis :: Eastern Plane Tree |
| 508 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia |
| 507 | Eucalyptus odorata :: Peppermint Box |
| 506 | Prunus domestica 'Green Gage' :: Green Gage Plum |
| 505 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree |
| 504 | Aesculus spp :: Horsechestnut |
| 503 | Eucalyptus macarthuri :: Camden Wollybutt |
| 502 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust |
| 501 | Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum |
| 500 | Fraxinus holotricha :: Holotricha Ash |
| 499 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree |
| 498 | Malus 'Gala' :: Apple Tree 'Gala' |
| 497 | Melaleuca leucadendron :: Weeping Tea Tree |
| 496 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn |
| 495 | Prunus serrula :: Birchbark Cherry |
| 494 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn |
| 493 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree |
| 492 | Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' |
| 491 | Eucalyptus longifolia :: Woollybutt |
| 490 | Aesculus x carnea 'O'Neill' :: O'Neill Red Horse Chestnut |
| 489 | Geijera spp :: Geijera |
| 488 | Acer pseudoplatanus :: Sycamore Maple |
| 487 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree |
| 486 | Fortunella margarita :: Kumquat |
| 485 | Acer x 'Autumn Blaze' :: Hybrid Maple |
| 484 | Ilex opaca :: American Holly |
| 483 | Quercus frainetto 'Trump' :: Hungarian Oak |
| 482 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' |
| 481 | Liquidambar formosana :: Chinese Sweet Gum |
| 480 | Sambucus mexicana :: Blue Elderberry |
| 479 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum |
| 478 | Fagus sylvatica 'Red Obelisk' :: Red Obelisk Beech |
| 477 | Griselinia lucida :: Griselinia |
| 476 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine |
| 475 | Cupressus arizonica :: Arizona Cypress |
| 474 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree |
| 473 | Prunus sargentii 'Columnaris' :: Sargent Cherry Tree 'Columnaris' |
| 472 | Malus x 'Callaway' :: White-Flowered Crabapple |
| 471 | Castanea dentata :: American Chestnut |
| 470 | Tilia spp :: Linden |
| 469 | Ficus carica 'Brown Turkey' :: Brown Turkey Fig |
| 468 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree |
| 467 | Prunus spp 'Purpurea' :: Cherry Plum |
| 466 | New Zealand Tea Tree :: New Zealand Tea Tree |
| 465 | Eucalyptus microtheca :: Flooded Box: Coolibah |
| 464 | Ulmus 'Frontier' :: Frontier Elm |
| 463 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "qSpecies" ( "id" INTEGER PRIMARY KEY , "value" TEXT );