Data source: data.sfgov.org
This data as json, CSV (advanced)
| id | value ▲ |
|---|---|
| 524 | x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree |
| 355 | Ziziphus jujuba :: Jujube |
| 174 | Zelkova serrata :: Sawleaf Zelkova |
| 402 | Yucca spp :: Yucca |
| 224 | Yucca gloriosa :: Spanish Dagger |
| 211 | Yucca elephantipes :: Giant Yucca |
| 391 | Xylosma congestum :: Brush holly |
| 553 | Wodyetia bifurcata :: Foxtail palm |
| 75 | Washingtonia robusta :: Mexican Fan Palm |
| 189 | Washingtonia filifera :: California Fan Palm |
| 236 | Vitex lucens :: Puriri tree |
| 419 | Viburnum odoratissimum var. awabuki :: Sweet viburnum |
| 195 | Umbellularia californica :: California Bay |
| 215 | Ulmus spp :: Elm Spp |
| 53 | Ulmus pumila :: Siberian Elm |
| 527 | Ulmus procera :: English Elm |
| 46 | Ulmus parvifolia :: Chinese Elm |
| 523 | Ulmus parvifolia 'True Green' :: True Green Chinese Elm |
| 257 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm |
| 69 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm |
| 528 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' |
| 511 | Ulmus glabra :: Scotch Elm |
| 377 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' |
| 119 | Ulmus americana :: American Elm |
| 255 | Ulmus 'Prospector' :: Prospector Elm |
| 464 | Ulmus 'Frontier' :: Frontier Elm |
| 37 | Tristaniopsis laurina :: Swamp Myrtle |
| 51 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' |
| 79 | Tristania conferta :: |
| 17 | Tree(s) :: |
| 31 | Trachycarpus fortunei :: Windmill Palm |
| 409 | Torreya californica :: California nutmeg |
| 470 | Tilia spp :: Linden |
| 208 | Tilia cordata :: Littleleaf Linden |
| 323 | Tilia americana :: Basswood Linden |
| 411 | Tilia americana 'Redmond' :: Redmond Linden |
| 260 | Tibochina urvilleana :: Princess Flower |
| 317 | Thuja plicata :: Western Red Cedar |
| 321 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae |
| 389 | Tecoma stans :: Trumpet bush |
| 241 | Taxus baccata :: Irish Yew |
| 333 | Taxodium mucronatum :: Montezuma Cypress |
| 384 | Taxodium distichum :: Bald Cypress |
| 198 | Syzygium paniculatum :: Brush Cherry |
| 178 | Syzygium australe :: Eugenia |
| 422 | Syringa :: Lilac Tree |
| 142 | Syagrus romanzoffianum :: Queen Palm |
| 451 | Styrax japonicus :: Japanese Snowdrop Tree |
| 156 | Styphnolobium japonicum :: Chinese scholar tree |
| 290 | Stenocarpus sinuatus :: Firewheel tree |
| 414 | Sorbus aucuparia :: European Mountain Ash Tr |
| 280 | Sophora japonica :: Japanese Pagoda |
| 261 | Sophora japonica 'Regent' :: Regent Scholar Tree |
| 269 | Solanum rantonnetti :: |
| 98 | Shrub :: Shrub |
| 212 | Sequoiadendron giganteum :: Sierra Redwood |
| 116 | Sequoia sempervirens :: Coast Redwood |
| 25 | Schinus terebinthifolius :: Brazilian Pepper |
| 324 | Schinus polygamus :: Chilean pepper tree |
| 138 | Schinus molle :: California Pepper |
| 386 | Schefflera species :: Umbrella tree |
| 173 | Sapium sebiferum :: Chinese Tallow |
| 432 | Sambucus species :: Elderberry |
| 480 | Sambucus mexicana :: Blue Elderberry |
| 218 | Salix spp :: Willow |
| 228 | Salix matsudana 'Tortuosa' :: Corkscrew Willow |
| 213 | Salix lasiolepis :: Arroyo willow |
| 437 | Salix discolor :: Pussy Willow |
| 182 | Salix babylonica :: Weeping Willow |
| 33 | Robinia x ambigua :: Locust |
| 124 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust |
| 502 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust |
| 169 | Robinia pseudoacacia :: Black Locust |
| 441 | Rhus typhina :: Staghorn sumac |
| 352 | Rhus lancea :: African Sumac |
| 533 | Rhopalostylis sapida :: Nikau palm |
| 376 | Rhopalostylis baueri :: Palm |
| 144 | Rhaphiolepis indica :: India Hawthorn |
| 106 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' |
| 232 | Rhamnus californica :: Coffeeberry Tree |
| 45 | Rhamnus alaternus :: Italian Buckthorn |
| 494 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn |
| 431 | Radermachera sinica :: China Doll Tree |
| 343 | Quillaja saponaria :: Chilean Soapbark |
| 446 | Quercus wislizenii :: Interior Live Oak |
| 341 | Quercus virginiana :: Southern Live Oak |
| 519 | Quercus tomentella :: Island oak |
| 76 | Quercus suber :: Cork Oak |
| 297 | Quercus spp :: Oak |
| 285 | Quercus rubra :: Red Oak |
| 358 | Quercus robur :: English Oak |
| 394 | Quercus palustris :: Pin Oak |
| 318 | Quercus lobata :: Valley Oak |
| 307 | Quercus keloggii :: California Black Oak |
| 78 | Quercus ilex :: Holly Oak |
| 483 | Quercus frainetto 'Trump' :: Hungarian Oak |
| 453 | Quercus engelmannii :: Engelmann oak |
| 387 | Quercus douglasii :: Blue Oak |
| 308 | Quercus coccinea :: Scarlet Oak |
| 439 | Quercus alba :: White oak |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "qSpecies" ( "id" INTEGER PRIMARY KEY , "value" TEXT );