8,298 rows where qLegalStatus_id = 4 sorted by Supervisor Districts

View and edit SQL

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)
25934 135966 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6001187.63413 2117406.94715 37.7940619922234 -122.439866757361 (37.7940619922234, -122.439866757361) 13 9 1 57 27
26219 95209 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2203@Clay Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000868 2115894 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631) 13 6 1 29490 27
26290 100794 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2499X Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002707 2116776 37.7924159434372 -122.434564464045 (37.7924159434372, -122.434564464045) 13 9 1 29490 27
26359 111940 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 90 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     22     5987707 2115818 37.7889226212876 -122.486393845778 (37.7889226212876, -122.486393845778) 11 6 1 55 33
26574 100103 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
27011 111934 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 60 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     30     5987882 2115824 37.7889492944095 -122.485788817699 (37.7889492944095, -122.485788817699) 11 6 1 55 33
27453 111935 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 66 SEACLIFF AVE   Sidewalk: Curb side : Cutout Tree Private 2     30     5987847 2115823 37.788944509176 -122.485909838035 (37.788944509176, -122.485909838035) 11 6 1 55 33
28155 106768 Undocumented 4 Olea europaea :: Olive Tree 9 226 Mallorca Way 1 Sidewalk: Curb side : Cutout Tree Private 2       8x9   6001629.46862 2120633.92047 37.8029475537601 -122.438569291156 (37.8029475537601, -122.438569291156) 13 9 1 57 17
29014 115937 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 500X LAKE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5993877 2114929 37.786839375345 -122.464982060228 (37.786839375345, -122.464982060228) 11 6 1 54 11
29507 115701 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2840 LAKE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x15   5986626 2114487 37.785205010982 -122.490035970437 (37.785205010982, -122.490035970437) 11 6 1 55 33
30009 99508 Undocumented 4 Aesculus x carnea :: Red Horse Chestnut 267 2828 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000030 2117468 37.7941636633745 -122.443876667305 (37.7941636633745, -122.443876667305) 13 9 1 57 27
30032 121066 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3199x Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
30326 99286 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2839 Pacific Ave 3 Sidewalk: Property side : Cutout Tree Private 2           6000564.2 2116779 37.7923023065947 -122.44197880494 (37.7923023065947, -122.44197880494) 13 6 1 29490 27
30378 110304 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3735 BUCHANAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002991 2121133 37.8043952513031 -122.433893386438 (37.8043952513031, -122.433893386438) 13 9 1 57 17
30771 101430 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2501X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
30889 254841 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 71 06th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3 3x3   5993910 2115089 37.7872805943627 -122.464879512834 (37.7872805943627, -122.464879512834) 11 6 1 54 11
30901 103929 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 191 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       4x10   5994248.3 2114379.9 37.7853530981444 -122.463657591004 (37.7853530981444, -122.463657591004) 11 6 1 54 11
31119 255523 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
31664 115699 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2840 LAKE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x15   5986626 2114487 37.785205010982 -122.490035970437 (37.785205010982, -122.490035970437) 11 6 1 55 33
32115 112617 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2399X DIVISADERO ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000719 2116473 37.7914709305552 -122.441421227792 (37.7914709305552, -122.441421227792) 13 6 1 29490 27
32201 117042 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 2220x SUTTER ST 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
32472 116801 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2120 BROADWAY 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003325 2117599 37.7947107530845 -122.432484978634 (37.7947107530845, -122.432484978634) 13 9 1 29490 27
32479 125072 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2559 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002527.91845 2116093.19627 37.7905309723786 -122.435135231625 (37.7905309723786, -122.435135231625) 13 9 1 29490 27
32544 105274 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 232 30th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5986553.3 2114252.8 37.784557719608 -122.490270252434 (37.784557719608, -122.490270252434) 11 6 1 55 33
32710 115086 Undocumented 4 Thuja plicata :: Western Red Cedar 307 2784X JACKSON ST 1 Sidewalk: Property side : Cutout Tree Private 2     7 3x3   6000894 2116629 37.7919092338162 -122.440826927692 (37.7919092338162, -122.440826927692) 13 6 1 29490 27
33165 115318 Undocumented 4 Ficus macrophylla :: Morton Bay Fig 322 3370 WASHINGTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5998663 2115944 37.7899010948859 -122.448496808995 (37.7899010948859, -122.448496808995) 13 6 1 54 31
34089 102756 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2807 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002069 2117756 37.7950705311236 -122.436842144361 (37.7950705311236, -122.436842144361) 13 9 1 57 27
34132 111168 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100X Magnolia St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6003190.19669 2119810.74673 37.8007759915841 -122.43310951859 (37.8007759915841, -122.43310951859) 13 9 1 57 17
34398 101661 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
34652 108151 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2232 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
35338 113934 Undocumented 4 Tree(s) :: 17 800 EL CAMINO DEL MAR 3 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2016 12:00:00 AM   3x3 Permit Number 776988 5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33
35465 109382 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 17 17TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5990474.2 2114948.8 37.78669694813 -122.476756279285 (37.78669694813, -122.476756279285) 11 6 1 55 33
36178 108990 Undocumented 4 :: 45 2073-2099X Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
36751 121063 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
37319 105121 Undocumented 4 :: 45 721 BEACH ST   Sidewalk: Curb side : Cutout Tree Private 2     9     6006739.7 2121813.5 37.8064757462399 -122.420969011396 (37.8064757462399, -122.420969011396) 5 1 1 28858 32
37383 121052 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
37428 105715 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 40X 18TH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     15 6x9   5990254.2 2114862 37.7864458560817 -122.477511071909 (37.7864458560817, -122.477511071909) 11 6 1 55 33
38143 97575 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 501x Presidio Ave 5 Sidewalk: Curb side : Cutout Tree Private 2           5999116.8 2114959.9 37.7872249510267 -122.4468558657 (37.7872249510267, -122.4468558657) 15 6 1 54 31
38158 101288 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 3355X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001810.5 2119614.7 37.8001593395999 -122.437869785341 (37.8001593395999, -122.437869785341) 13 9 1 57 17
38651 113775 Undocumented 4 Ficus nitida :: Laurel Fig 53 1712 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6000121 2114885 37.7870766118482 -122.443376178084 (37.7870766118482, -122.443376178084) 13 6 1 29490 27
39370 107630 Undocumented 4 Ficus nitida :: Laurel Fig 53 2164 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001495 2119755 37.8005266206576 -122.438971595662 (37.8005266206576, -122.438971595662) 13 9 1 57 17
39406 129582 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2230 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6003450.16372 2117252.10795 37.7937653733223 -122.432027112554 (37.7937653733223, -122.432027112554) 13 9 1 29490 27
39521 107816 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 222 28TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     18 5x20   5987167.1 2114462.1 37.7851682253333 -122.488162125765 (37.7851682253333, -122.488162125765) 11 6 1 55 33
39656 115936 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 500X LAKE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5993877 2114929 37.786839375345 -122.464982060228 (37.786839375345, -122.464982060228) 11 6 1 54 11
39975 121061 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
40072 95210 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2203@Clay Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6000868 2115894 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631) 13 6 1 29490 27
40559 104272 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3675 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997210.1 2115656.5 37.7890285184352 -122.453502918425 (37.7890285184352, -122.453502918425) 11 6 1 54 31
41223 111952 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 73 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     24     5987709 2115789 37.7888431121968 -122.486384796167 (37.7888431121968, -122.486384796167) 11 6 1 55 33
41363 102755 Undocumented 4 Shrub :: Shrub 66 61 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   5996159.1 2114114.4 37.7847340229516 -122.457027629275 (37.7847340229516, -122.457027629275) 11 6 1 54 31
41557 115704 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2820 LAKE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x15   5986689 2114483 37.7851977068092 -122.489817718558 (37.7851977068092, -122.489817718558) 11 6 1 55 33
41620 111945 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 95 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree Private 2           5987570 2115773 37.7887910778243 -122.486864535179 (37.7887910778243, -122.486864535179) 11 6 1 55 33
43292 113935 Undocumented 4 Tree(s) :: 17 800 EL CAMINO DEL MAR 4 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2016 12:00:00 AM   3x3 Permit Number 776988 5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33
43566 113936 Undocumented 4 Myoporum laetum :: Myoporum 62 800 EL CAMINO DEL MAR 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 776988 5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33
43975 122579 Undocumented 4 Prunus spp :: Cherry 68 2500X Lyon St 1 Median : Cutout Tree Private 2     30 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
44007 111937 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 78 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     28     5987777 2115821 37.7889349383365 -122.486151878662 (37.7889349383365, -122.486151878662) 11 6 1 55 33
44631 122582 Undocumented 4 Acer rubrum :: Red Maple 75 2500X Lyon St 2 Median : Cutout Tree Private 2     6 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
44767 111955 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 49 Seacliff Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5987872.34655427 2115783.06288074 37.7888363303163 -122.485819211038 (37.7888363303163, -122.485819211038) 11 6 1 55 33
45400 117067 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 299X PRESIDIO AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998965 2115900 37.7897975450498 -122.447448751983 (37.7897975450498, -122.447448751983) 13 6 1 54 31
45633 115929 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3990 SACRAMENTO ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995601 2114876 37.7867931062819 -122.459013621631 (37.7867931062819, -122.459013621631) 11 6 1 54 31
45816 121324 Undocumented 4 Tree(s) :: 17 3699X Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
46946 112740 Undocumented 4 Tree(s) :: 17 2514 CLAY ST 1 Sidewalk: Property side : Cutout Tree Private 2   11/09/2015 12:00:00 AM   3x3 Permit Number 776637 6002696 2116178 37.7907733646004 -122.43455974658 (37.7907733646004, -122.43455974658) 13 9 1 29490 27
47028 110967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2439 WASHINGTON ST   Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003043 2116458 37.7915618650441 -122.433379161821 (37.7915618650441, -122.433379161821) 13 9 1 29490 27
48110 108103 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 5 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
48350 111430 Undocumented 4 Ficus nitida :: Laurel Fig 53 500X PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999200 2114887 37.7870295394193 -122.446562765799 (37.7870295394193, -122.446562765799) 15 6 1 29490 31
48413 113168 Undocumented 4 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 3902 CLAY ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996089 2115262 37.7878809990319 -122.457353202257 (37.7878809990319, -122.457353202257) 11 6 1 54 31
48655 113933 Undocumented 4 Tree(s) :: 17 800 EL CAMINO DEL MAR 2 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2016 12:00:00 AM   3x3 Permit Number 776988 5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33
48758 112741 Undocumented 4 Cupressus sempervirens :: Italian Cypress 204 2514 CLAY ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002696 2116178 37.7907733646004 -122.43455974658 (37.7907733646004, -122.43455974658) 13 9 1 29490 27
48825 116196 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 3751 CLAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996888 2115293 37.7880119756846 -122.454591065245 (37.7880119756846, -122.454591065245) 11 6 1 54 31
48998 98105 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 850 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6001068 2114562 37.7862436951175 -122.440076605796 (37.7862436951175, -122.440076605796) 13 6 1 29490 27
49204 101667 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 7 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
49686 99089 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2801@Broderick Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000146.4 2117058.8 37.7930467467367 -122.443444504836 (37.7930467467367, -122.443444504836) 13 6 1 29490 27
50213 111938 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 78 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree Private 2           5987777 2115821 37.7889349383365 -122.486151878662 (37.7889349383365, -122.486151878662) 11 6 1 55 33
50422 121422 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2466 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999524 2119846 37.8006641419807 -122.445798577396 (37.8006641419807, -122.445798577396) 13 9 1 57 17
50742 117072 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3105X CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999725 2115439 37.7885751609396 -122.444786082443 (37.7885751609396, -122.444786082443) 13 6 1 29490 27
50841 103385 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 104 PRESIDIO AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999013 2116197 37.7906157715272 -122.447304062173 (37.7906157715272, -122.447304062173) 13 6 1 29490 31
51051 111449 Undocumented 4 Acacia spp :: Acacia Spp 105 291 32ND AVE 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5985855 2113985 37.7837816114828 -122.492666369295 (37.7837816114828, -122.492666369295) 11 6 1 55 33
52051 100288 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
52243 250405 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 16 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5988113.64161 2115836.93474 37.788998304588 -122.484988328172 (37.788998304588, -122.484988328172) 11 6 1 55 33
52306 103014 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1950X Turk St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 4x4   6000619.3 2112146.9 37.7795868963645 -122.441455622144 (37.7795868963645, -122.441455622144) 15 5 1 29490 16
52804 122693 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2500X Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
53341 255638 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 220 Masonic Ave 1 Sidewalk: Property side : Yard Tree Private 2           5999023 2112089 37.7793368479896 -122.446973720271 (37.7793368479896, -122.446973720271) 15 5 1 54 16
54729 121020 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1653 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005036 2119492 37.8000053242339 -122.426699554936 (37.8000053242339, -122.426699554936) 13 9 1 57 17
55120 116042 Undocumented 4 Tree(s) :: 17 2617 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003977 2117866 37.7954808176447 -122.43024802945 (37.7954808176447, -122.43024802945) 13 9 1 29490 27
55655 250016 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 1250 Geary Blvd 2 : Tree Private 2     12 Width 5ft   6005727.9579 2114178.12622 37.7854538578564 -122.423927038497 (37.7854538578564, -122.423927038497) 13 9 1 28858 41
55823 120504 Undocumented 4 Salix spp :: Willow 203 2050 Turk Blvd 1 Back Yard : Yard Tree Private 2           6000175 2112136 37.7795316461312 -122.442991859062 (37.7795316461312, -122.442991859062) 15 5 1 29490 16
55994 102686 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2140 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 4x4   6001431 2115640 37.7892242640561 -122.438898003801 (37.7892242640561, -122.438898003801) 13 6 1 29490 27
56112 112489 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2690x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM   3x3   6007377.71104 2121658.59908 37.8060863706979 -122.418750060411 (37.8060863706979, -122.418750060411) 5 1 1 308 32
56384 107052 Undocumented 4 Tree(s) :: 17 450 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2           5998625.9783 2115075.11894 37.7875132600186 -122.448562297399 (37.7875132600186, -122.448562297399) 13 6 1 54 31
56533 99086 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 2801@Broderick Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000146.4 2117058.8 37.7930467467367 -122.443444504836 (37.7930467467367, -122.443444504836) 13 6 1 29490 27
57242 114460 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1462 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005986 2118991 37.7986833693446 -122.423376553534 (37.7986833693446, -122.423376553534) 13 9 1 28858 32
57863 111985 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 15 SEACLIFF AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     30     5988113 2115801 37.7888996007164 -122.484987910575 (37.7888996007164, -122.484987910575) 11 6 1 55 33
58089 121568 Undocumented 4 Myoporum laetum :: Myoporum 62 499X Laurel St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998083 2114873 37.7869272334312 -122.450426308155 (37.7869272334312, -122.450426308155) 11 6 1 54 31
58698 254582 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 3239 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 3x3   6001867 2119344 37.799419281227 -122.437654876352 (37.799419281227, -122.437654876352) 13 9 1 57 17
59499 114431 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2787 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000638 2114779 37.7868150321065 -122.441579867848 (37.7868150321065, -122.441579867848) 13 6 1 29490 27
59647 93614 Undocumented 4 Tree(s) :: 17 3865 Sacramento St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 53255 5996391.2 2114920.9 37.7869617823748 -122.456282979232 (37.7869617823748, -122.456282979232) 11 6 1 54 31
59777 113939 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3333 BUCHANAN ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003181 2119826 37.8008173514055 -122.433142433403 (37.8008173514055, -122.433142433403) 13 9 1 57 17
59827 117033 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 2220x SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
59847 116495 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2501x CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6002786 2116136 37.7906631519982 -122.434245347461 (37.7906631519982, -122.434245347461) 13 9 1 29490 27
59873 117586 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1800X BRODERICK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000654 2114867 37.787057568893 -122.441530828991 (37.787057568893, -122.441530828991) 13 6 1 29490 27

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