215 rows where qLegalStatus_id = 9 sorted by DBH

View and edit SQL

Neighborhoods (old)

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)
99 255073 Private 9 Tree(s) :: 17 173R Glenview Dr   Back Yard : Yard Tree Private 2                              
273 117070 Private 9 Tree(s) :: 17 6 JOY ST 3 Front Yard : Yard Tree Private 2           6010444 2098901 37.7437714571602 -122.406533939617 (37.7437714571602, -122.406533939617) 2 7 7 28859 2
985 262391 Private 9 Pinus Spp :: Pine Spp 100 2646 38th Ave 1 Back Yard : Yard Tree Private 2       Width 0ft   5984657 2097167 37.7375339667511 -122.495570077384 (37.7375339667511, -122.495570077384) 1 8 3 29491 35
4884 260462 Private 9 Pinus radiata :: Monterey Pine 15 119 Moffitt St 1 Back Yard : Yard Tree Private 2       3x3   6002736 2096650 37.7371564911538 -122.433025558613 (37.7371564911538, -122.433025558613) 2 7 5 63 7
4985 260550 Private 9 Private shrub :: Private Shrub 284 155 Graystone Ter 1 Sidewalk: Property side : Yard Landscaping Private 2       3x3   5999080 2104142 37.7575196509651 -122.446204727568 (37.7575196509651, -122.446204727568) 2 5 5 28862 3
5914 254656 Private 9 :: 45 640 Larch St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004524 2112776 37.781535924842 -122.427992425483 (37.781535924842, -122.427992425483) 7 9 11 29490 41
6273 173900 Private 9 Ligustrum lucidum :: Glossy Privet 57 601x Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2                              
8510 259163 Private 9 Shrub :: Shrub 66 1 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9208 259164 Private 9 Shrub :: Shrub 66 1 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
10049 261052 Private 9 Ginkgo biloba :: Maidenhair Tree 22 100 Hooper St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013012.2905 2108046.92839 37.769027533769 -122.398294909078 (37.769027533769, -122.398294909078) 14 3 8 28856 20
11563 259753 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 1229 Connecticut St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013525 2101361 37.7506979810533 -122.396052856578 (37.7506979810533, -122.396052856578) 10 3 8 28856 1
13162 251365 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 2 Sidewalk: Property side : Yard Tree Private 2                              
13718 251364 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
14046 262297 Private 9 Sequoia sempervirens :: Coast Redwood 155 666 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009767 2091318 37.722912259595 -122.408340109411 (37.722912259595, -122.408340109411) 9 3 7 309 28
15219 251366 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 138x Gladeview Way 3 Sidewalk: Property side : Yard Tree Private 2                              
15590 260947 Private 9 Tree(s) :: 17 143 Gambier St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6005856 2093079 37.72752779603 -122.421984681693 (37.72752779603, -122.421984681693) 9 7 7 309 5
15840 258303 Private 9 Juniperus chinensis :: Juniper 113 1x Dawnview Way 1 Sidewalk: Property side : Yard Tree Private 2                              
16285 114961 Private 9 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 220 Evelyn Way 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM     Permit Number 776128 5997838.7 2098850.9 37.7429206264442 -122.450116261368 (37.7429206264442, -122.450116261368) 9 7 4 59 40
16349 259165 Private 9 Shrub :: Shrub 66 1 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
20327 109501 Private 9 Ulmus americana :: American Elm 74 1400X on Filbert Montgomery St 1 Unaccepted Street : Yard Tree Private 2         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.8021053817179 -122.404424889694 (37.8021053817179, -122.404424889694) 3 1 10 308 23
23696 108446 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 672 05th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773773 5994431.81479 2110948.53978 37.7759420777365 -122.462773673163 (37.7759420777365, -122.462773673163) 11 6 2 54 11
33729 109829 Private 9 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 629 TAYLOR ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 775362 6009246.3 2115118.4 37.7882336239769 -122.41182103906 (37.7882336239769, -122.41182103906) 5 1 10 28852 21
34779 104448 Private 9 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2490X Folsom St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
44862 114642 Private 9 Crataegus phaenopyrum :: Washington Hawthorn 102 30 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 773527 6010319.9 2099707.2 37.745978163197 -122.407019863158 (37.745978163197, -122.407019863158) 2 7 7 28859 2
65512 108459 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 771 11th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334) 11 6 2 54 11
68698 104451 Private 9 Acacia melanoxylon :: Blackwood Acacia 70 2490X Folsom St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
74288 105439 Private 9 Tree(s) :: 17 790 LAKEVIEW AVE 1 Front Yard : Yard Tree Private 2           5994224.8 2089960.8 37.7183031233486 -122.461967505828 (37.7183031233486, -122.461967505828) 9 8 6 28861 24
80106 114666 Private 9 Podocarpus gracilor :: Fern Pine 51 382 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 774512 6007233.6 2095963.6 37.7355258779344 -122.417426639907 (37.7355258779344, -122.417426639907) 2 7 7 28859 2
86075 100243 Private 9 Tree(s) :: 17 1326-1332 Shotwell St   unknown : Yard Tree Private 2           6008043 2100485 37.7479861507453 -122.414948142067 (37.7479861507453, -122.414948142067) 2 7 7 28859 2
91085 111308 Private 9 Pinus radiata :: Monterey Pine 15 780x JAMESTOWN AVE 1 Sidewalk: Property side : Yard Tree Private 2       6x90   6015099 2088640 37.7158561393861 -122.389721379672 (37.7158561393861, -122.389721379672) 10 3 8 58 1
91676 104449 Private 9 Acacia melanoxylon :: Blackwood Acacia 70 2490X Folsom St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
96093 39626 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 1550 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
99316 108440 Private 9 Magnolia grandiflora :: Southern Magnolia 19 105 Lake St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11
100633 104881 Private 9 Privet :: 212 101 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2         missing? 5990474.7 2090014.4 37.7182336817112 -122.474933796522 (37.7182336817112, -122.474933796522) 1 8 4 64 14
102300 113801 Private 9 Ulmus parvifolia :: Chinese Elm 31 806 SHOTWELL ST 3 Front Yard : Yard Tree Private 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
107120 121090 Private 9 Pinus radiata :: Monterey Pine 15 1X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
108521 110587 Private 9 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 151 EDGEWOOD AVE 1 Front Yard : Yard Tree Private 2           5996558 2106132 37.7628393335165 -122.45507056335 (37.7628393335165, -122.45507056335) 15 5 11 29492 12
108854 104446 Private 9 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2490X Folsom St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
119017 105441 Private 9 Eucalyptus globulus :: Blue Gum 56 425 WAWONA ST   unknown : Yard Tree Private 2           5991587.6 2097036.5 37.7375790508831 -122.471598439568 (37.7375790508831, -122.471598439568) 1 8 4 29491 40
119423 114977 Private 9 Pittosporum undulatum :: Victorian Box 36 183 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM     Permit Number 774982 5996484.3 2091092.2 37.7215395068839 -122.454239087603 (37.7215395068839, -122.454239087603) 9 8 6 28861 24
122325 104309 Private 9 Myoporum laetum :: Myoporum 62 3747 23RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
137357 117353 Private 9 Pittosporum crassifolium :: Karo Tree 95 101X China Basin St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 772935 6015309.46376 2108739.72137 37.7710574836343 -122.390397474374 (37.7710574836343, -122.390397474374) 14 3 9 310 20
141599 251417 Private 9 Eucalyptus globulus :: Blue Gum 56 418 19th Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5990003 2112517 37.7799925618685 -122.478208632121 (37.7799925618685, -122.478208632121) 11 6 2 55 26
150142 114761 Private 9 Pinus radiata :: Monterey Pine 15 2155 10TH AVE 1 Back Yard : Yard Tree Private 2       10x10   5993160 2101036 37.7486515109126 -122.466452556212 (37.7486515109126, -122.466452556212) 1 8 4 29491 40
156160 108314 Private 9 Corymbia ficifolia :: Red Flowering Gum 28 2501X DIAMOND ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002141 2097265 37.7388113707969 -122.435126715418 (37.7388113707969, -122.435126715418) 2 7 5 63 7
160381 256862 Private 9 Picea Spp :: Spruce Spp 200 133 Majestic Ave 1 Back Yard : Yard Tree Private 2           5997017.00624 2089223.65081 37.7164394409514 -122.452262915882 (37.7164394409514, -122.452262915882) 9 8 6 28861 24
160937 102060 Private 9 Cupressus macrocarpa :: Monterey Cypress 41 115 Kensington Way 1 Back Yard : Yard Tree Private 2           5994908.3 2098325.8 37.7413107073974 -122.460210667073 (37.7413107073974, -122.460210667073) 1 8 4 59 40
165045 114647 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 331 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 774946 6008851.6 2097283.6 37.7392412152063 -122.41192582952 (37.7392412152063, -122.41192582952) 10 7 7 28859 2
171901 82180 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 105 Lake St 1 Front Yard : Cutout Tree Private 2 FUF     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.7867910649613 -122.460471849521 (37.7867910649613, -122.460471849521) 11 6 1 54 11
180111 256895 Private 9 Ginkgo biloba :: Maidenhair Tree 22 701 Congo St 1 Sidewalk: Property side : Cutout Tree Private 2       3x12 Permit Number 768867 6000183.68977 2096091.89275 37.7354789553486 -122.441809987085 (37.7354789553486, -122.441809987085) 9 7 4 63 40
181524 121089 Private 9 Eucalyptus globulus :: Blue Gum 56 1X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
187934 108441 Private 9 Magnolia grandiflora :: Southern Magnolia 19 105 Lake St   Front Yard : Cutout Tree Private 2 FUF     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 54 11
190320 72375 Private 9 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 4299X Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.477688796337 (37.773031079694, -122.477688796337) 11 6 2 55 26
193423 108885 Private 9 Cupaniopsis anacardioides :: Carrotwood 195 707 NOE ST 5 Back Yard : Yard Tree Private 2       3x3   6003152.4 2104071.5 37.7575578048507 -122.432115704961 (37.7575578048507, -122.432115704961) 2 4 5 28862 3
675 150019 Private 9 Tree(s) :: 17 777 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015489.62882 2105456.11878 37.7620514180509 -122.389544911688 (37.7620514180509, -122.389544911688) 10 3 8 28856 29
3212 150016 Private 9 Tree(s) :: 17 777 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015494.18586 2105386.64383 37.7618609074738 -122.389524298311 (37.7618609074738, -122.389524298311) 10 3 8 28856 29
8842 150020 Private 9 Tree(s) :: 17 777 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015489.50926 2105477.62507 37.7621104630605 -122.389546827243 (37.7621104630605, -122.389546827243) 10 3 8 28856 29
14649 150018 Private 9 Tree(s) :: 17 777 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015492.47093 2105432.35195 37.7619863170408 -122.389533421936 (37.7619863170408, -122.389533421936) 10 3 8 28856 29
15916 150017 Private 9 Tree(s) :: 17 777 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015494.08881 2105409.25245 37.7619229804945 -122.389526212978 (37.7619229804945, -122.389526212978) 10 3 8 28856 29
51620 26198 Private 9 Lophostemon confertus :: Brisbane Box 11 3830 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x4   6015747.5106038 2098323.3315623 37.742480578689 -122.388155190044 (37.742480578689, -122.388155190044) 10 3 8 58 1
123246 22155 Private 9 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1570X FAIRFAX AVE 7 Sidewalk: Curb side : Cutout Tree Private 2     1 3X3   6015579 2098247 37.7422616499572 -122.388732527256 (37.7422616499572, -122.388732527256) 10 3 8 58 1
108163 104358 Private 9 Maytenus boaria :: Mayten 58 745X GOLDEN GATE AVE   Sidewalk: Curb side : Cutout Tree Private 2     10 3   6005986 2112447 37.7807151749226 -122.422911209833 (37.7807151749226, -122.422911209833) 7 9 11 28852 41
154962 22381 Private 9 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
180187 112262 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 1 Holly Park Cir 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x15   6006308.21143459 2096885.36921844 37.7380047408881 -122.420691480393 (37.7380047408881, -122.420691480393) 2 7 7 28859 2
120017 105072 Private 9 Metrosideros excelsa :: New Zealand Xmas Tree 16 88X PROSPECT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x6   6007074 2099135 37.7442248567037 -122.418203213837 (37.7442248567037, -122.418203213837) 2 7 7 28859 2
165242 104317 Private 9 Pyrus calleryana :: Ornamental Pear 44 13011305 SANCHEZ ST 2 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   6003956 2100665 37.7482498839608 -122.429093651106 (37.7482498839608, -122.429093651106) 2 4 5 63 22
186484 109125 Private 9 Schinus molle :: California Pepper 91 890x CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
97720 104310 Private 9 Brachychiton populneus :: Bottle Tree 348 3747 23RD ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
167961 104436 Private 9 Corymbia ficifolia :: Red Flowering Gum 28 2 SAN FERNANDO WAY 1 Front Yard : Yard Tree Private 2     13     5992040 2096369 37.7357724272627 -122.469985704629 (37.7357724272627, -122.469985704629) 1 8 4 59 40
16189 104502 Private 9 Pinus radiata :: Monterey Pine 15 30X SATURN ST 1 Median : Yard Tree DPW 1     14     6000456 2106003 37.7627079858093 -122.44157952537 (37.7627079858093, -122.44157952537) 15 5 5 28862 3
33896 104968 Private 9 Pinus halepensis :: Allepo Pine 330 495 COLLINGWOOD ST 1 Front Yard : Yard Tree Private 2     15   Permit Number 770776 6002186.6 2103026 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855) 2 4 5 28862 22
57138 104401 Private 9 Ulmus parvifolia :: Chinese Elm 31 727 Ashbury St   Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999017 2108166 37.768564950056 -122.44671213341 (37.768564950056, -122.44671213341) 15 5 11 29492 9
112431 104768 Private 9 Ulmus parvifolia :: Chinese Elm 31 912 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6002431.1 2102873.8 37.7542282864134 -122.434524613527 (37.7542282864134, -122.434524613527) 2 4 5 28862 22
165107 104627 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 49 BRODERICK ST 4 Sidewalk: Curb side : Cutout Tree Private 2     17 5X5   6001306 2108720 37.7702165872443 -122.438834395611 (37.7702165872443, -122.438834395611) 15 5 11 29492 9
35396 104626 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 49 BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     18 6X5   6001285 2108936 37.7708084746611 -122.438922516011 (37.7708084746611, -122.438922516011) 15 5 11 29492 9
18526 250107 Private 9 Tree(s) :: 17 1688 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005911.45005 2115583.38163 37.7893226981327 -122.423392144226 (37.7893226981327, -122.423392144226) 13 9 1 28858 41
19392 191529 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6016082.02245 2107209.57323 37.7668988547309 -122.387618372283 (37.7668988547309, -122.387618372283) 14 3 9 310 20
60173 80520 Private 9 Pyrus spp :: Pear Tree 281 2499X Mendell St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 2     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
176299 104400 Private 9 Maytenus boaria :: Mayten 58 755 Ashbury St   Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5999044 2107976 37.768044800389 -122.446605071221 (37.768044800389, -122.446605071221) 15 5 11 29492 9
193685 104552 Private 9 Metrosideros excelsa :: New Zealand Xmas Tree 16 151 STARVIEW WAY 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5997447 2102183 37.7520473310587 -122.451710958005 (37.7520473310587, -122.451710958005) 1 5 4 63 38
7435 239668 Private 9 Butia capitata :: Pindo Palm 313 180 Dolores St 3 Sidewalk: Property side : Pot Landscaping Private 2     23 Width 4ft   6004776.3298 2107329.36682 37.7665950691341 -122.426731495165 (37.7665950691341, -122.426731495165) 8 4 5 28862 3
149976 104650 Private 9 Corymbia ficifolia :: Red Flowering Gum 28 346 LAKE ST   Sidewalk: Curb side : Cutout Tree Private 2     28 10x8   5994385.6 2114927.2 37.7868637456835 -122.463222305141 (37.7868637456835, -122.463222305141) 11 6 1 54 11
60 264971 Private 9 Ulmus parvifolia :: Chinese Elm 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26
585 75271 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015975.8041 2106880.05369 37.7659881814233 -122.387962771269 (37.7659881814233, -122.387962771269) 14 3 9 310 20
893 226590 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port 08/14/2019 12:00:00 AM 3 3x3 Permit Number 784594 6001099.54842 2099653.23365 37.7453097044788 -122.438898660558 (37.7453097044788, -122.438898660558) 2 4 5 63 22
1077 149677 Private 9 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2100x Mariposa St 1 Front Yard : Cutout Tree DPW 1   05/19/2020 12:00:00 AM 3 Width 4ft Permit Number 784452 6011154.9566 2106050.92707 37.7634433311543 -122.404578819881 (37.7634433311543, -122.404578819881) 8 3 8 28856 29
2295 193115 Private 9 Tree(s) :: 17 1791 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 4x3 Permit Number 782693 6014511.3912 2096886.32335 37.7384662854853 -122.392328872775 (37.7384662854853, -122.392328872775) 10 3 8 58 1
2685 264708 Private 9 Callistemon citrinus :: Lemon Bottlebrush 67 4345 Clement St 4 Sidewalk: Property side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
3361 261454 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
3416 262187 Private 9 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2100x Mariposa St 4 Front Yard : Cutout Tree DPW 1   05/19/2020 12:00:00 AM 3 Width 4ft Permit Number 784452 6011170 2106024 37.76337023621 -122.404524893747 (37.76337023621, -122.404524893747) 8 3 8 28856 29
3984 243570 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port   3 3x3 Permit Number 784594 6001117.2647 2099653.19311 37.7453106011164 -122.438837397829 (37.7453106011164, -122.438837397829) 2 4 5 63 22
4077 102546 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015961.34604 2107137.76144 37.7666949900978 -122.388030764508 (37.7666949900978, -122.388030764508) 14 3 9 310 20
4192 264915 Private 9 Pistacia chinensis :: Chinese Pistache 32 1461 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2020 12:00:00 AM 3 3x3 Permit Number 784397 6015819.34366 2093828.22518 37.7301419060949 -122.387593270969 (37.7301419060949, -122.387593270969) 10 3 8 58 1
4221 160246 Private 9 Potential Site :: Potential Site 48 962 Edinburgh St 1 Front Yard : Cutout Tree Private 2 DPW 02/20/2020 12:00:00 AM 3 3x3 Permit Number 779047 6001480.24176 2088600.7563 37.7149837880375 -122.436791243222 (37.7149837880375, -122.436791243222) 9 7 6 28861 5
4850 262150 Private 9 Lagunaria patersonii :: Primrose Tree 6 1295 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
4984 154060 Private 9 Tree(s) :: 17 1796 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 4x3 Permit Number 782693 6014554.77098 2096926.88452 37.7385800668269 -122.392181721216 (37.7385800668269, -122.392181721216) 10 3 8 58 1
5551 74240 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015971.85212 2106927.76687 37.7661189725478 -122.387979770277 (37.7661189725478, -122.387979770277) 14 3 9 310 20
5653 215048 Private 9 Olea europaea :: Olive Tree 9 1719 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2020 12:00:00 AM 3 3x3 Permit Number 782897 5990885.18116 2103671.34742 37.7557559568771 -122.474511074324 (37.7557559568771, -122.474511074324) 1 8 4 56 12
6336 261055 Private 9 Afrocarpus gracilior :: Fern Pine 89 1948 Quesada Ave 1 Front Yard : Cutout Tree Private 2 DPW 11/20/2019 12:00:00 AM 3 3x3 Permit Number 780729 6013389.35902 2096036.97619 37.7360717858924 -122.396148836191 (37.7360717858924, -122.396148836191) 10 3 8 58 1
6683 262152 Private 9 Lagunaria patersonii :: Primrose Tree 6 1295 47th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);