Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186005 | 186005 | 227076 | Undocumented 2 | Lagerstroemia spp :: Crape myrtle species 562 | 35 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000264.72064 | 2104678.20499 | 37.7590595255837 | -122.442145988358 | (37.7590595255837, -122.442145988358) | |||
| 185862 | 185862 | 232267 | Undocumented 2 | Moringa oleifera :: Drumstick tree 561 | 38 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009278.96363 | 2097829.67893 | 37.7407645965011 | -122.41048674157801 | (37.7407645965011, -122.410486741578) | |||
| 185138 | 185138 | 227078 | Undocumented 2 | Lagerstroemia x 'Tuscarora' :: Tuscarora Crape Myrtle 560 | 139 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005638.73494 | 2099902.37732 | 37.7462510077934 | -122.42322059318 | (37.7462510077934, -122.42322059318) | |||
| 184767 | 184767 | 234869 | Undocumented 2 | Populus deltoides :: Eastern cottonwood 559 | 483 Valley St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 6002812.524730001 | 2099166.42238 | 37.7440703451703 | -122.432940705074 | (37.7440703451703, -122.432940705074) | ||||
| 184389 | 184389 | 246328 | Undocumented 2 | Eucalyptus citriodora :: Lemon scented eucalyptus 558 | 1735 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6006779.179 | 2108213.1723 | 37.76913482316721 | -122.419866697495 | (37.7691348231672, -122.419866697495) | |||
| 179168 | 179168 | 247007 | Undocumented 2 | Callistemon salignus :: White flowering bottlebrush 557 | 401 Valley St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6003259.67301 | 2099184.77085 | 37.744146077987 | -122.431395876644 | (37.744146077987, -122.431395876644) | |||
| 178973 | 178973 | 222747 | Undocumented 2 | Cedrela fissilis :: Argentine cedar 556 | 131 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005909.4208 | 2106484.7834799998 | 37.764340040684296 | -122.422752299085 | (37.7643400406843, -122.422752299085) | |||
| 177621 | 177621 | 34624 | Permitted Site 1 | Pinus torreyana :: Torrey Pine 555 | 1440 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 12 | Permit Number 38306 | 5988698.57904624 | 2105516.51025916 | 37.7606953425859 | -122.482208131756 | (37.7606953425859, -122.482208131756) | |
| 170666 | 170666 | 187858 | Undocumented 2 | Acer platanoides :: Norway Maple 554 | 550 Missouri St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6013512.81245 | 2104486.93396 | 37.7592804422575 | -122.39631407184099 | (37.7592804422575, -122.396314071841) | ||||
| 170201 | 170201 | 243956 | Undocumented 2 | Wodyetia bifurcata :: Foxtail palm 553 | 1374 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010321.8959800005 | 2101296.94026 | 37.7503433529628 | -122.407125000243 | (37.7503433529628, -122.407125000243) | |||
| 168425 | 168425 | 49167 | Permitted Site 1 | Acer tegmentosum :: Manchurian snakebark maple 552 | 559 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2003 12:00:00 AM | 4 | Permit Number 46289 | 6011256.105830001 | 2105759.6348200003 | 37.762649160563704 | -122.40420847273998 | (37.7626491605637, -122.40420847274) | ||
| 173140 | 173140 | 248498 | Undocumented 2 | Arbutus menziesii :: Pacific Madrone 551 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998302.5369 | 2107853.4873 | 37.7676660307619 | -122.449160873661 | (37.7676660307619, -122.449160873661) | |||
| 166103 | 166103 | 248402 | Undocumented 2 | Arbutus menziesii :: Pacific Madrone 551 | 701 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997566.8136 | 2108099.9902 | 37.7683007569323 | -122.45172341954999 | (37.7683007569323, -122.45172341955) | |||
| 180948 | 180948 | 188541 | Undocumented 2 | Acacia iteaphylla :: Willow wattle 550 | 1201 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6014304.71414 | 2104773.92766 | 37.7601124986177 | -122.393595357466 | (37.7601124986177, -122.393595357466) | |||
| 162882 | 162882 | 220117 | Undocumented 2 | Acacia iteaphylla :: Willow wattle 550 | 1200 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010017.12435 | 2102145.65843 | 37.7526566844658 | -122.408238779095 | (37.7526566844658, -122.408238779095) | |||
| 162156 | 162156 | 193474 | Undocumented 2 | Mangifera indica :: Mango 549 | 1310 Indiana St | 25 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014936.17409 | 2102358.6880200002 | 37.7535158347022 | -122.391242588881 | (37.7535158347022, -122.391242588881) | ||||
| 161504 | 161504 | 225137 | Undocumented 2 | Cercocarpus betuloides :: Mountain mahogany 548 | 1101 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004725.51952 | 2096307.5135400002 | 37.736328750759796 | -122.42612250576 | (37.7363287507598, -122.42612250576) | ||||
| 160417 | 160417 | 101728 | Permitted Site 1 | Cercidiphyllum japonicum :: Katsura tree 547 | 90 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2012 12:00:00 AM | 7 | 3x3 | Permit Number 769383 | 6003346.97259 | 2094586.71516 | 37.731525817059705 | -122.430765951898 | (37.7315258170597, -122.430765951898) | |
| 160329 | 160329 | 118189 | Undocumented 2 | Pinus sylvestris :: Scots Pine 546 | 806 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5985428.5638 | 2110364.72057 | 37.773816419818296 | -122.493874773697 | (37.7738164198183, -122.493874773697) | |||
| 168155 | 168155 | 188838 | Undocumented 2 | Brachychiton rupestris :: Narrow-leaf bottle tree 545 | 1639 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6014968.28203 | 2096897.0990000002 | 37.738521233155204 | -122.39074990519501 | (37.7385212331552, -122.390749905195) | |||
| 155559 | 155559 | 188839 | Undocumented 2 | Brachychiton rupestris :: Narrow-leaf bottle tree 545 | 1754 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014336.85502 | 2094986.79308 | 37.7332408718702 | -122.392799486222 | (37.7332408718702, -122.392799486222) | |||
| 186930 | 186930 | 188812 | Undocumented 2 | Beaucarnea recurvata :: Ponytail palm 544 | 2211 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012100.78981 | 2101856.17323 | 37.7519782763782 | -122.40101271476601 | (37.7519782763782, -122.401012714766) | ||||
| 167381 | 167381 | 187566 | Undocumented 2 | Beaucarnea recurvata :: Ponytail palm 544 | 136 Alpha St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6010914.5006 | 2088119.67508 | 37.7141945043399 | -122.404148432227 | (37.7141945043399, -122.404148432227) | |||
| 154172 | 154172 | 187565 | Undocumented 2 | Beaucarnea recurvata :: Ponytail palm 544 | 136 Alpha St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6010916.99184 | 2088120.11863 | 37.714195861437794 | -122.404139852688 | (37.7141958614378, -122.404139852688) | |||
| 153481 | 153481 | 136057 | Undocumented 2 | Pseudopanax lessonii :: Five finger 543 | 331 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998559.644719999 | 2115379.19074 | 37.7883443679496 | -122.448813707713 | (37.7883443679496, -122.448813707713) | |||
| 161876 | 161876 | 116755 | Undocumented 2 | Meryta sinclairii :: Puka or puke tree 542 | 601x Wisconsin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012732.7732 | 2104597.96658 | 37.7595418769705 | -122.39901963633999 | (37.7595418769705, -122.39901963634) | |||
| 150767 | 150767 | 131244 | Undocumented 2 | Meryta sinclairii :: Puka or puke tree 542 | 2770 Green St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999801.9058 | 2117795.56718 | 37.795050062951496 | -122.44468945095899 | (37.7950500629515, -122.444689450959) | |||
| 147432 | 147432 | 248427 | Undocumented 2 | Acer campestre :: Hedge Maple 541 | 730 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999078.0822 | 2108014.2896 | 37.768151880704 | -122.44648994003401 | (37.768151880704, -122.446489940034) | |||
| 144144 | 144144 | 94944 | Significant Tree 6 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 540 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 142384 | 142384 | 106198 | Significant Tree 6 | Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 539 | 2101 42ND AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5983206.1 | 2100796.8 | 37.74741533456479 | -122.500854798087 | (37.7474153345648, -122.500854798087) | ||||
| 138584 | 138584 | 94587 | Permitted Site 1 | Persea americana 'Stewart' :: Stewart Avocado 538 | 4072 24th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2010 12:00:00 AM | 3x3 | Permit Number 53764 | 6002706.0 | 2101836.0 | 37.7513943353159 | -122.433499781921 | (37.7513943353159, -122.433499781921) | |||
| 136860 | 136860 | 107594 | Permitted Site 1 | Prunus campanulata :: Taiwan Flowering Cherry 537 | 1801X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x6 | 5993052.66806 | 2112040.96292 | 37.778862048054 | -122.467623923273 | (37.778862048054, -122.467623923273) | |||
| 136308 | 136308 | 223353 | Undocumented 2 | Dypsis decaryi :: Triangle palm 536 | 476 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002943.03103 | 2105483.62599 | 37.7614232910681 | -122.432940670896 | (37.7614232910681, -122.432940670896) | |||
| 136054 | 136054 | 191713 | Undocumented 2 | Erythrina caffra :: Coral tree 535 | 601 Wisconsin St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6012726.33226 | 2104665.52893 | 37.759727029402704 | -122.399046654695 | (37.7597270294027, -122.399046654695) | |||
| 180475 | 180475 | 188232 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1498 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014336.19933 | 2102024.0819200003 | 37.7525637629087 | -122.39329403420601 | (37.7525637629087, -122.393294034206) | |||
| 163433 | 163433 | 205609 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1484 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5991184.61852 | 2105324.79706 | 37.760313237173 | -122.47359614005899 | (37.760313237173, -122.473596140059) | |||
| 133988 | 133988 | 221178 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1101 San Jose Ave | 68 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005051.84205 | 2096632.8627099998 | 37.7372405248233 | -122.425017413417 | (37.7372405248233, -122.425017413417) | |||
| 133932 | 133932 | 197368 | Undocumented 2 | Rhopalostylis sapida :: Nikau palm 533 | 601 Wisconsin St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012729.08438 | 2104643.98882 | 37.759668038361504 | -122.399035624504 | (37.7596680383615, -122.399035624504) | |||
| 128879 | 128879 | 40225 | Permitted Site 1 | Acer ginnela :: Amur Maple 532 | 394 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | Permit Number 41407 | 6003833.01657725 | 2102180.77232097 | 37.7524048777321 | -122.429627013671 | (37.7524048777321, -122.429627013671) | ||
| 128807 | 128807 | 102796 | Undocumented 2 | Magnolia grandiflora 'Timeless Beauty' :: Timeless Beauty Southern Magnolia 531 | 536 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002890.0 | 2102715.0 | 37.753818298827206 | -122.43292628008001 | (37.7538182988272, -122.43292628008) | ||||
| 124878 | 124878 | 97955 | Significant Tree 6 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 530 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | |||
| 122921 | 122921 | 106507 | Undocumented 2 | Ceanothus thyrsiflorus :: Blueblossom Ceanothus 529 | 50 FANNING WAY | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991716.2 | 2101233.1 | 37.749109278682795 | -122.471459514348 | (37.7491092786828, -122.471459514348) | ||||||
| 142788 | 142788 | 57101 | Permitted Site 1 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 528 | 3721 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 4 | 3x3 | Permit Number 14371 | 6004927.69179762 | 2102493.53287665 | 37.753325568237294 | -122.425863704952 | (37.7533255682373, -122.425863704952) | |
| 133909 | 133909 | 58103 | Permitted Site 1 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 528 | 756 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52383 | 6011525.71136 | 2104836.68468 | 37.7601300066003 | -122.403211071536 | (37.7601300066003, -122.403211071536) | |
| 122731 | 122731 | 104778 | Undocumented 2 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 528 | 736 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002380.5 | 2103803.5 | 37.7567781475012 | -122.434766079383 | (37.7567781475012, -122.434766079383) | |||
| 165189 | 165189 | 215574 | Undocumented 2 | Ulmus procera :: English Elm 527 | 637 Detroit St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5999417.56245 | 2095197.50098 | 37.732979482112 | -122.444394512913 | (37.732979482112, -122.444394512913) | |||
| 118076 | 118076 | 26589 | Permitted Site 1 | Ulmus procera :: English Elm 527 | 1647 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | 6 | 3X3 | 6012128.96715 | 2091072.2459200001 | 37.722369452807605 | -122.400157976887 | (37.7223694528076, -122.400157976887) | ||
| 161922 | 161922 | 225212 | Undocumented 2 | Chionanthus retusa :: Chinese Fringe Tree 526 | 1357 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007181.04871 | 2107590.64768 | 37.76744814894921 | -122.41843250275801 | (37.7674481489492, -122.418432502758) | |||
| 155426 | 155426 | 190034 | Undocumented 2 | Chionanthus retusa :: Chinese Fringe Tree 526 | 594 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012963.9697199995 | 2104277.8254 | 37.7586757201207 | -122.398197577755 | (37.7586757201207, -122.398197577755) | |||
| 131449 | 131449 | 120240 | Undocumented 2 | Chionanthus retusa :: Chinese Fringe Tree 526 | 288 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5988397.12224 | 2114058.72928 | 37.7841323663842 | -122.483877094997 | (37.7841323663842, -122.483877094997) | |||
| 128374 | 128374 | 104497 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) | ||
| 117945 | 117945 | 104498 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) | ||
| 162265 | 162265 | 227077 | Undocumented 2 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle 525 | 644 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007449.2504900005 | 2105879.4887599996 | 37.7627648007686 | -122.417383547038 | (37.7627648007686, -122.417383547038) | |||
| 115182 | 115182 | 53140 | Permitted Site 1 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle 525 | 1498@ KEITH Underwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | ||
| 113666 | 113666 | 101255 | DPW Maintained 3 | x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree 524 | 3700X Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005840.6 | 2100555.6 | 37.74805599841039 | -122.422568977073 | (37.7480559984104, -122.422568977073) | |||||
| 112390 | 112390 | 82083 | Permitted Site 1 | Ulmus parvifolia 'True Green' :: True Green Chinese Elm 523 | 1442 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767418 | 6003903.93114879 | 2099873.27169394 | 37.746073034264604 | -122.42921725762 | (37.7460730342646, -122.42921725762) | |
| 112157 | 112157 | 122695 | Undocumented 2 | Acer saccharum :: Sugar Maple 522 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | ||||
| 109820 | 109820 | 7938 | Permitted Site 1 | Crinodendron patagua :: Lily-of-the-Valley Tree 521 | 1410X Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6005829.8939946 | 2114877.7740744 | 37.7873806719016 | -122.42362413098199 | (37.7873806719016, -122.423624130982) | |||
| 122132 | 122132 | 99793 | Undocumented 2 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 520 | 4120-4124 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002399.0 | 2101817.0 | 37.7513247429435 | -122.43456006421499 | (37.7513247429435, -122.434560064215) | ||||
| 109005 | 109005 | 99791 | Undocumented 2 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 520 | 4120-4124 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 6002399.0 | 2101817.0 | 37.7513247429435 | -122.43456006421499 | (37.7513247429435, -122.434560064215) | ||||
| 125233 | 125233 | 38821 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 426 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 777484 | 5994995.0692300005 | 2112615.41295 | 37.7805512921286 | -122.460946081899 | (37.7805512921286, -122.460946081899) | |
| 122707 | 122707 | 100078 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 266 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776410 | 5990586.53381 | 2113609.7978 | 37.7830269371305 | -122.47626979286501 | (37.7830269371305, -122.476269792865) | |
| 108919 | 108919 | 100076 | Permitted Site 1 | Quercus tomentella :: Island oak 519 | 262 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776532 | 5990584.51145 | 2113652.92092 | 37.783145223942 | -122.47627994024201 | (37.783145223942, -122.476279940242) | |
| 121702 | 121702 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 | 30 Onondaga Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.721861535681704 | -122.437972107548 | (37.7218615356817, -122.437972107548) | ||||
| 108754 | 108754 | 104003 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 | 2109 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/17/2013 12:00:00 AM | Permit Number 767176 | 6002333.5 | 2115633.4 | 37.789257448084605 | -122.435774995524 | (37.7892574480846, -122.435774995524) | |||
| 107483 | 107483 | 51021 | Permitted Site 1 | Prunus sargentii :: Sargent Cherry 517 | 4275 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50421 | 6001430.71351981 | 2101713.7407115 | 37.750986202789 | -122.43790110742201 | (37.750986202789, -122.437901107422) | ||
| 144647 | 144647 | 50176 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 1400 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | Permit Number 46885 | 5993138.94338431 | 2097622.37512786 | 37.739277347046496 | -122.46627731988 | (37.7392773470465, -122.46627731988) | |||
| 123428 | 123428 | 46361 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 160 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2002 12:00:00 AM | Permit Number 44599 | 6015543.16497343 | 2115073.84916298 | 37.7884625396437 | -122.390031641839 | (37.7884625396437, -122.390031641839) | |||
| 121318 | 121318 | 48732 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 1840 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2002 12:00:00 AM | Permit Number 46012 | 6001561.51478574 | 2114750.36064197 | 37.7867889680887 | -122.438382676367 | (37.7867889680887, -122.438382676367) | |||
| 105760 | 105760 | 52841 | Permitted Site 1 | Populus canadensis :: Canadian Poplar 516 | 2600@ PIERCE Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48859 | 6001694.15234168 | 2117006.51478628 | 37.7929913285029 | -122.43808545751499 | (37.7929913285029, -122.438085457515) | |||
| 104446 | 104446 | 53220 | Permitted Site 1 | Citrus x hystrix :: Kaffir lime 515 | 311 San Benito Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/04/2012 12:00:00 AM | 3x7 | Permit Number 769253 | 5992906.41199583 | 2094772.69381636 | 37.7314394147179 | -122.466874195473 | (37.7314394147179, -122.466874195473) | ||
| 140878 | 140878 | 107632 | Undocumented 2 | Chorisia speciosa :: Silk Floss Tree 514 | 814 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010397.84183 | 2104391.4418 | 37.758844416174 | -122.407080469655 | (37.758844416174, -122.407080469655) | |||
| 105186 | 105186 | 113783 | Undocumented 2 | Chorisia speciosa :: Silk Floss Tree 514 | 1188 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6008033.0 | 2101004.0 | 37.7494106463882 | -122.41501945132 | (37.7494106463882, -122.41501945132) | |||
| 103902 | 103902 | 112152 | Undocumented 2 | Chorisia speciosa :: Silk Floss Tree 514 | 299x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | ||||
| 115983 | 115983 | 35968 | Permitted Site 1 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 513 | 123 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39126 | 6005630.57353586 | 2096425.6693507 | 37.7367042924726 | -122.423001748533 | (37.7367042924726, -122.423001748533) | ||
| 101864 | 101864 | 122731 | Undocumented 2 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 513 | 310 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003508.0 | 2106439.0 | 37.7640785470532 | -122.431054869188 | (37.7640785470532, -122.431054869188) | |||
| 113613 | 113613 | 23368 | DPW Maintained 3 | Eucalyptus simmondsi :: Simmond's Peppermint 512 | 1356X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | |||
| 101656 | 101656 | 23365 | DPW Maintained 3 | Eucalyptus simmondsi :: Simmond's Peppermint 512 | 1356X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | |||
| 100778 | 100778 | 102077 | Significant Tree 6 | Ulmus glabra :: Scotch Elm 511 | 273 Magellan Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 100332 | 100332 | 21434 | DPW Maintained 3 | Pinus pinaster :: Maritime Pine 510 | 2692X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 129280 | 129280 | 13725 | DPW Maintained 3 | Platanus orientalis :: Eastern Plane Tree 509 | 776 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 6011167.8494838 | 2114433.7120502 | 37.786461244836296 | -122.40512453376499 | (37.7864612448363, -122.405124533765) | |||
| 99928 | 99928 | 13724 | DPW Maintained 3 | Platanus orientalis :: Eastern Plane Tree 509 | 774X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6011177.3442372 | 2114442.7932563997 | 37.786486710466704 | -122.40509232379499 | (37.7864867104667, -122.405092323795) | |||
| 141616 | 141616 | 3915 | Permitted Site 1 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 99X Castro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 121943 | 121943 | 3925 | DPW Maintained 3 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 99X Castro St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 96007 | 96007 | 102903 | Undocumented 2 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6002396.0 | 2104853.0 | 37.7596607018428 | -122.43478752318701 | (37.7596607018428, -122.434787523187) | |||
| 141601 | 141601 | 108981 | Permitted Site 1 | Eucalyptus odorata :: Peppermint Box 507 | 10 ARBOR ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/02/2015 12:00:00 AM | 3 | Permit Number 774690 | 6002183.8 | 2097008.7 | 37.7381100606509 | -122.434960408352 | (37.7381100606509, -122.434960408352) | |||
| 95817 | 95817 | 23447 | DPW Maintained 3 | Eucalyptus odorata :: Peppermint Box 507 | 2100X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006027.0678818 | 2117578.0674993 | 37.794806131309706 | -122.42313396012399 | (37.7948061313097, -122.423133960124) | |||
| 94793 | 94793 | 106979 | DPW Maintained 3 | Prunus domestica 'Green Gage' :: Green Gage Plum 506 | 801X Clipper St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 24 | 5999765.50041 | 2100345.59515 | 37.7471347718267 | -122.443561289165 | (37.7471347718267, -122.443561289165) | ||||
| 120962 | 120962 | 108073 | Undocumented 2 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 505 | 101 BUENA VISTA AVE EAST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001336.0 | 2108482.0 | 37.769564805176394 | -122.438713569331 | (37.7695648051764, -122.438713569331) | ||||
| 102112 | 102112 | 108072 | Permitted Site 1 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 505 | 101 BUENA VISTA AVE EAST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001336.0 | 2108482.0 | 37.769564805176394 | -122.438713569331 | (37.7695648051764, -122.438713569331) | ||||
| 94322 | 94322 | 63293 | Permitted Site 1 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 505 | 15 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23859 | 6008094.27360425 | 2100056.59433468 | 37.7468127256176 | -122.41474052571199 | (37.7468127256176, -122.414740525712) | ||
| 92918 | 92918 | 110864 | Undocumented 2 | Aesculus spp :: Horsechestnut 504 | 1798x 22ND ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012787.0 | 2103832.0 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | |||||
| 145968 | 145968 | 98223 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1501X 42nd Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
| 143095 | 143095 | 99561 | Undocumented 2 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 418 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002462.0 | 2100938.0 | 37.748914793116995 | -122.434279368207 | (37.748914793117, -122.434279368207) | |||||
| 108295 | 108295 | 23405 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1700X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006206.237645401 | 2116289.0241793 | 37.79127685023521 | -122.422422371222 | (37.7912768502352, -122.422422371222) | |||
| 92792 | 92792 | 98222 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
| 101276 | 101276 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | ||
| 91632 | 91632 | 87216 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007640.7 | 2097187.4 | 37.7389090609704 | -122.416105779709 | (37.7389090609704, -122.416105779709) | ||
| 118068 | 118068 | 55720 | Permitted Site 1 | Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum 501 | 58 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2010 12:00:00 AM | Permit Number 53177 | 6003133.68670367 | 2107965.52082477 | 37.7682487847408 | -122.432458547407 | (37.7682487847408, -122.432458547407) | |||
| 90478 | 90478 | 52993 | Permitted Site 1 | Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum 501 | 1210 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 24 | 3x3 | Permit Number 49019 | 6003829.10545601 | 2101223.75142142 | 37.749776901068 | -122.42957229205601 | (37.749776901068, -122.429572292056) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");