trees
8,298 rows where qLegalStatus_id = 4 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189307 | 111392 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 189287 | 98413 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 790 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002783 | 2109590 | 37.7726893128067 | -122.433787659392 | (37.7726893128067, -122.433787659392) | 15 | 5 | 11 | 29492 | 9 | ||||
| 189272 | 173806 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007805.70004 | 2120292.05671 | 37.8023582786402 | -122.417172035787 | (37.8023582786402, -122.417172035787) | 5 | 1 | 1 | 308 | 32 | ||||
| 189249 | 99561 | Undocumented 4 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 418 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002462 | 2100938 | 37.748914793117 | -122.434279368207 | (37.748914793117, -122.434279368207) | 2 | 4 | 5 | 28862 | 22 | |||||
| 189220 | 121499 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 851 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004400 | 2103913 | 37.7571932560102 | -122.427789705541 | (37.7571932560102, -122.427789705541) | 2 | 4 | 5 | 28862 | 3 | ||||
| 189172 | 122833 | Undocumented 4 | Carpinus betulus :: European Hornbeam 165 | 201x Broadway | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 6012272 | 2118721 | 37.7982947840288 | -122.401605868068 | (37.7982947840288, -122.401605868068) | 3 | 1 | 10 | 28860 | 6 | ||||
| 189140 | 111212 | Undocumented 4 | Arbutus unedo :: Strawberry Tree 106 | 3100x 19TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
| 189112 | 115869 | Undocumented 4 | :: 45 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 189040 | 256467 | Undocumented 4 | Syzygium australe :: Eugenia 228 | 2901X Sunset Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5984943 | 2095249 | 37.7322843937213 | -122.494439909578 | (37.7322843937213, -122.494439909578) | 1 | 8 | 4 | 64 | 35 | ||||
| 189027 | 108128 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1901 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008051 | 2107091 | 37.7661251677687 | -122.415388074018 | (37.7661251677687, -122.415388074018) | 8 | 4 | 7 | 28853 | 19 | ||||
| 188995 | 119265 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1317 Bosworth St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000208 | 2096491 | 37.7365761953737 | -122.441754571906 | (37.7365761953737, -122.441754571906) | 2 | 7 | 5 | 63 | 7 | |||||
| 188962 | 103137 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993979.5 | 2106772.5 | 37.7644497152943 | -122.464035120318 | (37.7644497152943, -122.464035120318) | 11 | 5 | 11 | 56 | 12 | ||||
| 188945 | 112147 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
| 188898 | 254463 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 57 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 188894 | 115828 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 65 CHUMASERO DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||
| 188887 | 116899 | Undocumented 4 | Auranticarpa rhombifolia :: Queensland Pittosporum 237 | 898 PACHECO ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5992167 | 2103065 | 37.754165269847 | -122.470034026433 | (37.754165269847, -122.470034026433) | 1 | 8 | 4 | 56 | 12 | ||||
| 188882 | 256045 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
| 188867 | 121000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
| 188829 | 102556 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
| 188825 | 102612 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 376 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010060 | 2120948 | 37.8042858984606 | -122.409417337419 | (37.8042858984606, -122.409417337419) | 3 | 1 | 10 | 308 | 23 | ||||
| 188786 | 99614 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 188776 | 98742 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | |
| 188742 | 107075 | Undocumented 4 | Tree(s) :: 17 | 1861 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 60x3 | Permit Number 773144 | 6015696 | 2106749 | 37.7656128312083 | -122.388921414698 | (37.7656128312083, -122.388921414698) | 14 | 3 | 9 | 310 | 29 | |
| 188736 | 98324 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1899X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | 13 | 6 | 11 | 29490 | 27 | |||
| 188645 | 112861 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2098x ULLOA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989583 | 2098399 | 37.7412039444452 | -122.47862882847 | (37.7412039444452, -122.47862882847) | 1 | 8 | 3 | 29491 | 35 | ||||
| 188636 | 108133 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1901 FOLSOM ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008051 | 2107091 | 37.7661251677687 | -122.415388074018 | (37.7661251677687, -122.415388074018) | 8 | 4 | 7 | 28853 | 19 | ||||
| 188627 | 121062 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
| 188624 | 116367 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 100x SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013491 | 2117477 | 37.7949470000015 | -122.397300449207 | (37.7949470000015, -122.397300449207) | 3 | 1 | 10 | 28860 | 6 | ||||
| 188603 | 103545 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 905X Phelps St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | 10 | 3 | 8 | 58 | 1 | |||
| 188590 | 115474 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 50X LAUREL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998040 | 2116185 | 37.7905271763734 | -122.450669705536 | (37.7905271763734, -122.450669705536) | 13 | 6 | 1 | 54 | 31 | ||||
| 188587 | 99565 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 650X Brunswick St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 188579 | 114935 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 11 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 188567 | 109070 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 3027 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006619.6 | 2106627.5 | 37.7647719501604 | -122.420306113631 | (37.7647719501604, -122.420306113631) | 8 | 4 | 7 | 28859 | 19 | ||||
| 188536 | 117125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | ||||
| 188525 | 113667 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X THE EMBARCADERO | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013440 | 2119057 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | 3 | 1 | 10 | 28860 | 6 | ||||
| 188520 | 110936 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
| 188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
| 188515 | 111022 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1254 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993942 | 2106950 | 37.7649349225469 | -122.464177708405 | (37.7649349225469, -122.464177708405) | 11 | 5 | 11 | 56 | 12 | ||||
| 188497 | 99458 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 550X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
| 188484 | 103409 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
| 188472 | 116257 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 188461 | 97939 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
| 188448 | 113470 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 188430 | 114064 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 898x ELIZABETH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 777118 | 6000938 | 2102006 | 37.7517606457442 | -122.439625904919 | (37.7517606457442, -122.439625904919) | 2 | 4 | 5 | 28862 | 22 | |||
| 188390 | 103471 | Undocumented 4 | Tree(s) :: 17 | 1190X Vermont St | 2 | Front Yard : Yard | Tree | Private 2 | 05/03/2013 12:00:00 AM | 24 | Permit Number 770173 | 6011370.8 | 2102820.9 | 37.7545864559266 | -122.403605009348 | (37.7545864559266, -122.403605009348) | 10 | 4 | 8 | 28859 | 19 | ||
| 188385 | 114463 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1953 OFARRELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x5 | 6001997 | 2113175 | 37.7824881896361 | -122.436763189672 | (37.7824881896361, -122.436763189672) | 15 | 5 | 11 | 29490 | 41 | |||
| 188329 | 102460 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 559 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007888 | 2104678 | 37.7594904656222 | -122.415780983244 | (37.7594904656222, -122.415780983244) | 2 | 4 | 7 | 28859 | 19 | |||
| 188310 | 112373 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 15 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009208 | 2121303 | 37.8052128657777 | -122.412390870606 | (37.8052128657777, -122.412390870606) | 3 | 1 | 10 | 308 | 23 | ||||
| 188306 | 106573 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 580 York St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.409379620361 | (37.7621113428358, -122.409379620361) | 8 | 4 | 8 | 28859 | 19 | |||||
| 188265 | 256631 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 4805 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2104713 | 37.7591256596381 | -122.443932088895 | (37.7591256596381, -122.443932088895) | 2 | 4 | 5 | 28862 | 3 | ||||
| 188233 | 109165 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
| 188219 | 100853 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 490X Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003181 | 2102169 | 37.7523356131155 | -122.431880952183 | (37.7523356131155, -122.431880952183) | 2 | 4 | 5 | 28862 | 22 | ||||
| 188194 | 183859 | Undocumented 4 | :: 45 | 2247 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987908.9096 | 2099989.7957 | 37.745474508043 | -122.484533819529 | (37.745474508043, -122.484533819529) | 1 | 8 | 3 | 29491 | 35 | |||
| 188189 | 111222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
| 188186 | 102391 | Undocumented 4 | Tree(s) :: 17 | 30X Harriet St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010362 | 2111859 | 37.7793466114027 | -122.407730971847 | (37.7793466114027, -122.407730971847) | 14 | 2 | 9 | 28853 | 34 | ||||
| 188164 | 121092 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 30X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000475 | 2103841 | 37.7567727470696 | -122.441358672007 | (37.7567727470696, -122.441358672007) | 2 | 4 | 5 | 28862 | 38 | ||||
| 188136 | 120939 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 485 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012395 | 2105853 | 37.7629690927527 | -122.400275979648 | (37.7629690927527, -122.400275979648) | 14 | 3 | 8 | 28856 | 29 | ||||
| 188115 | 104360 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
| 188105 | 108171 | Undocumented 4 | Tree(s) :: 17 | 59x MACONDRAY LN | 1 | Back Yard : Yard | Tree | Private 2 | 30 | Permit Number 774825 | 6008454 | 2119149 | 37.7992561803015 | -122.414847646907 | (37.7992561803015, -122.414847646907) | 5 | 1 | 10 | 308 | 32 | |||
| 188095 | 116733 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1798x 23RD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989126 | 2103185 | 37.7543184934463 | -122.480559215931 | (37.7543184934463, -122.480559215931) | 1 | 8 | 3 | 56 | 35 | ||||
| 187976 | 108750 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 180x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 187968 | 98511 | Undocumented 4 | Tree(s) :: 17 | 1209 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 3x3 | Permit Number 775766 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||
| 187946 | 98141 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 75 Starview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5997450.6 | 2101840.3 | 37.7511065679937 | -122.451673790409 | (37.7511065679937, -122.451673790409) | 1 | 5 | 4 | 63 | 38 | ||||
| 187945 | 113180 | Undocumented 4 | Alnus rhombifolia :: White Alder 327 | 1701X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013992.4427 | 2092768.26292 | 37.7271301034749 | -122.393834984976 | (37.7271301034749, -122.393834984976) | 10 | 3 | 8 | 58 | 1 | |||||
| 187897 | 96107 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2780X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865922 | (37.7618258328219, -122.40992865922) | 8 | 4 | 8 | 28859 | 19 | ||
| 187865 | 108116 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 148 28TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987142.8 | 2114987.8 | 37.7866102289445 | -122.488284841308 | (37.7866102289445, -122.488284841308) | 11 | 6 | 1 | 55 | 33 | |||||
| 187848 | 111234 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601X 15TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991704 | 2097685 | 37.7393664008113 | -122.471243228199 | (37.7393664008113, -122.471243228199) | 1 | 8 | 4 | 29491 | 40 | ||||
| 187818 | 76380 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2111 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1994 12:00:00 AM | 18 | 6008755.93357293 | 2106237.29701545 | 37.7638206919277 | -122.412889475083 | (37.7638206919277, -122.412889475083) | 8 | 4 | 7 | 28859 | 19 | |||
| 187758 | 121318 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1218 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6007627 | 2102496 | 37.7534845172069 | -122.416529087187 | (37.7534845172069, -122.416529087187) | 2 | 4 | 7 | 28859 | 19 | |||
| 187605 | 257952 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 187514 | 110688 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 1 EDDY ST | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6010419 | 2113787 | 37.7846436353836 | -122.40766976216 | (37.7846436353836, -122.40766976216) | 14 | 10 | 10 | 28852 | 36 | ||||
| 187430 | 104646 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1455X Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001386.81709 | 2099547.0285 | 37.7450344302078 | -122.437897729467 | (37.7450344302078, -122.437897729467) | 2 | 7 | 5 | 63 | 22 | |||||
| 187402 | 121251 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4151 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 776206 | 6001358 | 2105811 | 37.762232149605 | -122.438446078367 | (37.762232149605, -122.438446078367) | 15 | 5 | 5 | 28862 | 3 | ||
| 187361 | 108184 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010686.57825 | 2116924.79472 | 37.7932742451254 | -122.406965263124 | (37.7932742451254, -122.406965263124) | 3 | 1 | 10 | 28857 | 4 | ||||
| 187338 | 120564 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2190 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015644 | 2105426 | 37.7619772765313 | -122.389008893863 | (37.7619772765313, -122.389008893863) | 10 | 3 | 8 | 28856 | 29 | |||
| 187337 | 105079 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3770 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004633.1 | 2101955.7 | 37.7518321521274 | -122.426844164794 | (37.7518321521274, -122.426844164794) | 2 | 4 | 5 | 28862 | 22 | |||
| 187241 | 116520 | Undocumented 4 | Tree(s) :: 17 | 715 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003102 | 2109569 | 37.7726497483837 | -122.432682704276 | (37.7726497483837, -122.432682704276) | 15 | 5 | 11 | 29492 | 9 | ||||
| 187222 | 115857 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 187142 | 99505 | Undocumented 4 | Aesculus x carnea :: Red Horse Chestnut 267 | 2828 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000030 | 2117468 | 37.7941636633745 | -122.443876667305 | (37.7941636633745, -122.443876667305) | 13 | 9 | 1 | 57 | 27 | ||||
| 187103 | 102053 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 100 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6000816.5 | 2105709 | 37.7619212664781 | -122.440311602097 | (37.7619212664781, -122.440311602097) | 15 | 5 | 5 | 28862 | 3 | |||
| 187091 | 100051 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 187045 | 112794 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21x JOICE ST | 5 | Unaccepted Street : Cutout | Tree | Private 2 | 6010276 | 2116206 | 37.7912776248382 | -122.408335175586 | (37.7912776248382, -122.408335175586) | 5 | 1 | 10 | 28857 | 21 | |||||
| 186966 | 114134 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 186957 | 118311 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||||
| 186940 | 97797 | Undocumented 4 | Tree(s) :: 17 | 400 Sussex St | Front Yard : Yard | Tree | Private 2 | 11/14/2011 12:00:00 AM | 17 | Permit Number 768175 | 6000884.7 | 2096726.7 | 37.7372619068373 | -122.439431826375 | (37.7372619068373, -122.439431826375) | 2 | 7 | 5 | 63 | 7 | |||
| 186932 | 107280 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
| 186930 | 113144 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
| 186873 | 99114 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
| 186814 | 114519 | Undocumented 4 | Arbutus unedo :: Strawberry Tree 106 | 199x WESTWOOD DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5995156 | 2093967 | 37.7293567553632 | -122.459038680416 | (37.7293567553632, -122.459038680416) | 9 | 7 | 4 | 28861 | 40 | |||
| 186797 | 101484 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
| 186796 | 101485 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1805X Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011653.3 | 2107915 | 37.7685894941919 | -122.402986319314 | (37.7685894941919, -122.402986319314) | 8 | 2 | 8 | 28853 | 20 | |||
| 186783 | 114217 | Undocumented 4 | Pinus thunbergii :: Japanese Black Pine 207 | 2X ACEVEDO AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5987907 | 2090895 | 37.72050244758 | -122.483873669144 | (37.72050244758, -122.483873669144) | 1 | 8 | 4 | 64 | 14 | ||||
| 186753 | 102383 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 471-473 Noe St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2013 12:00:00 AM | 12 | 3x3 | Permit Number 769850 | 6002995 | 2105507 | 37.7614904180073 | -122.432762601795 | (37.7614904180073, -122.432762601795) | 15 | 4 | 5 | 28862 | 3 | |
| 186749 | 100279 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 3460X 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007182 | 2104415 | 37.7587286142457 | -122.418204039558 | (37.7587286142457, -122.418204039558) | 2 | 4 | 7 | 28859 | 19 | |||
| 186730 | 120142 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 10X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007842 | 2111812 | 37.7790761683861 | -122.416445400738 | (37.7790761683861, -122.416445400738) | 7 | 10 | 9 | 28852 | 36 | ||||
| 186717 | 107211 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2255 CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003966.3 | 2116269.9 | 37.7910977281266 | -122.430171131086 | (37.7910977281266, -122.430171131086) | 13 | 9 | 1 | 29490 | 27 | |||||
| 186697 | 99773 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4348 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001650 | 2100601 | 37.7479433490982 | -122.437063136505 | (37.7479433490982, -122.437063136505) | 2 | 4 | 5 | 28862 | 22 | ||||
| 186675 | 100522 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008910 | 2103320 | 37.7558191060193 | -122.412150412844 | (37.7558191060193, -122.412150412844) | 2 | 4 | 7 | 28859 | 19 | |||
| 186643 | 121594 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 68X Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002713 | 2095655 | 37.7344231446599 | -122.433034012036 | (37.7344231446599, -122.433034012036) | 2 | 7 | 5 | 63 | 7 | |||
| 186636 | 254465 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 59 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );