trees

8,298 rows where qLegalStatus_id = 4 sorted by PlotSize descending

✎ View and edit SQL

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)
38900 97781 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 249 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 strip   5992441.6 2097612.4 37.7392096976829 -122.468687674985 (37.7392096976829, -122.468687674985) 1 8 4 59 40
20014 178243 Undocumented 4 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 3 Front Yard : Yard Tree Private 2     26 Width 8ft   6009152.06447 2086268.0035 37.7090115585089 -122.410109471469 (37.7090115585089, -122.410109471469) 9 7 8 309 39
33077 178244 Undocumented 4 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 4 Front Yard : Yard Tree Private 2     17 Width 8ft   6009170.0421 2086265.24197 37.7090049835504 -122.410047143074 (37.7090049835504, -122.410047143074) 9 7 8 309 39
111272 192051 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 311 Townsend St 7 Sidewalk: Property side : Yard Tree Private 2     31 Width 8ft   6013302.41922 2110215.29688 37.7749975429264 -122.397443454875 (37.7749975429264, -122.397443454875) 14 2 9 28856 20
170418 213755 Undocumented 4 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 90 Melrose Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   5999563.10942 2095536.13882 37.7339176053979 -122.443915642793 (37.7339176053979, -122.443915642793) 9 7 4 63 40
172633 204582 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 90 Melrose Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 8ft   5999570.33408 2095534.33569 37.7339130665349 -122.443890535522 (37.7339130665349, -122.443890535522) 9 7 4 63 40
24902 180669 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 171 Winding Way 3 Sidewalk: Curb side : Yard Tree Private 2     0 Width 6ft   6002170.18422 2086635.71157 37.7096273944518 -122.434266111507 (37.7096273944518, -122.434266111507) 9 7 6 28861 5
37063 212059 Undocumented 4 Tree(s) :: 17 125 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2   04/08/2019 12:00:00 AM 3 Width 6ft Permit Number 779144 5994018.1401 2096987.89262 37.7375859049576 -122.463191447135 (37.7375859049576, -122.463191447135) 9 8 4 59 40
40245 180646 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 451 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 6ft   6002230.18825 2087673.61332 37.7124806510226 -122.434132874236 (37.7124806510226, -122.434132874236) 9 7 6 28861 5
54306 237027 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St 8 : Tree Private 2     5 Width 6ft   6005758.33223 2109504.65873 37.7726233714135 -122.423489581302 (37.7726233714135, -122.423489581302) 7 9 11 28852 10
55857 237026 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Octavia St 7 : Tree Private 2     3 Width 6ft   6005759.75569 2109493.68206 37.7725933124646 -122.423483876889 (37.7725933124646, -122.423483876889) 7 9 11 28852 10
72124 251752 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 128 South Hill Blvd 2 Sidewalk: Curb side : Yard Tree Private 2       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608) 9 7 6 28861 5
73067 180648 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 120 Seville St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 6ft   6001751.26715 2087361.8508 37.7115974268507 -122.435765878508 (37.7115974268507, -122.435765878508) 9 7 6 28861 5
76386 180625 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 18 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 6ft   6002816.84046 2087215.85653 37.7112570289525 -122.432072557104 (37.7112570289525, -122.432072557104) 9 7 6 28861 5
91191 180655 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 128 South Hill Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     31 Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608) 9 7 6 28861 5
101361 222898 Undocumented 4 Ceratonia siliqua :: Carob 5 2771 22nd St 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 6ft   6009527.7031 2103333.93064 37.7558919964247 -122.410015170384 (37.7558919964247, -122.410015170384) 2 4 7 28859 19
102614 127905 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 937 Lombard St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 6ft   6007996.96181 2120271.7748 37.8023133475557 -122.416508736883 (37.8023133475557, -122.416508736883) 5 1 10 308 32
146645 227999 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1227 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   5997427.0236 2105612.47787 37.7614626741762 -122.452027445805 (37.7614626741762, -122.452027445805) 15 5 11 29492 12
168353 180626 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 18 Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 6ft   6002802.39914 2087193.02957 37.7111935323316 -122.432120840807 (37.7111935323316, -122.432120840807) 9 7 6 28861 5
185565 251753 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 128 South Hill Blvd 3 Sidewalk: Curb side : Yard Tree Private 2       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608) 9 7 6 28861 5
14635 124488 Undocumented 4 Myoporum laetum :: Myoporum 62 3015 Turk Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   5996527.76957 2111462.12046 37.7774727294111 -122.455560392543 (37.7774727294111, -122.455560392543) 11 6 2 54 16
21597 224729 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 21 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6005253.61364 2105295.59302 37.7610377822877 -122.424935941151 (37.7610377822877, -122.424935941151) 2 4 5 28859 19
23868 205774 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 367 Kensington Way 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   5994104.03782 2099097.57437 37.7433835122355 -122.463047484554 (37.7433835122355, -122.463047484554) 1 8 4 59 40
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
91617 228392 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 741 Douglass St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6001282.56527 2101791.06389 37.7511900880551 -122.438418956794 (37.7511900880551, -122.438418956794) 2 4 5 28862 22
92779 229187 Undocumented 4 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 3291 Cesar Chavez St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 5ft   6007776.8751 2100527.33423 37.7480874332941 -122.415871390946 (37.7480874332941, -122.415871390946) 2 4 7 28859 2
121385 119124 Undocumented 4 :: 45 601 46th Ave 3 Sidewalk: Property side : Yard Tree Private 2       Width 5ft   5981605.53063 2111566.74083 37.7768923962204 -122.507188220302 (37.7768923962204, -122.507188220302) 11 6 2 55 26
128535 213913 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1205 04th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/16/2015 02:38:00 PM 3 Width 5ft 415-564-3245 marykittner@att.net 5994820.88687 2107315.71116 37.7659896869053 -122.461164393249 (37.7659896869053, -122.461164393249) 15 5 11 56 12
142370 231440 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 101x Portola Dr 3 Median : Cutout Tree Private 2     27 Width 5ft Permit Number 782331 5999772.05051 2101277.39678 37.7496936476461 -122.44360556645 (37.7496936476461, -122.44360556645) 2 4 5 28862 38
150859 221227 Undocumented 4 Betula pendula :: European White Birch 253 26 Crescent Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6005423.00406 2095885.44307 37.7352092369163 -122.42368100828 (37.7352092369163, -122.42368100828) 2 7 7 28859 2
164869 250015 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 1250 Geary Blvd 1 : Tree Private 2     12 Width 5ft   6005749.01753 2114177.69322 37.7854538578504 -122.423854147548 (37.7854538578504, -122.423854147548) 13 9 1 28858 41
168200 205773 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 367 Kensington Way 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   5994090.41781 2099105.65375 37.7434049116147 -122.463095164805 (37.7434049116147, -122.463095164805) 1 8 4 59 40
185328 228391 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 741 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6001283.19215 2101774.69957 37.7511451912112 -122.438415616682 (37.7511451912112, -122.438415616682) 2 4 5 28862 22
191685 193733 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 210 Channel 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6014775.46671 2109801.19254 37.7739424115586 -122.392318855239 (37.7739424115586, -122.392318855239) 14 3 9 310 20
193346 178671 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 624 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6002757.8843 2087321.68 37.7115442544376 -122.432283877092 (37.7115442544376, -122.432283877092) 9 7 6 28861 5
7948 259183 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 35 09th St 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6007987.0607 2111156.01389 37.7772831438281 -122.415897110674 (37.7772831438281, -122.415897110674) 8 2 9 28853 34
8514 250400 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 15 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5988097.76743 2115798.38338 37.7888915289683 -122.485040420476 (37.7888915289683, -122.485040420476) 11 6 1 55 33
11738 259182 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 35 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6007987.0607 2111156.01389 37.7772831438281 -122.415897110674 (37.7772831438281, -122.415897110674) 8 2 9 28853 34
12482 177894 Undocumented 4 Olea europaea :: Olive Tree 9 350 Rutland St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6010334.18865 2088569.51073 37.7153972189891 -122.406185898468 (37.7153972189891, -122.406185898468) 9 7 8 309 39
16869 195858 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 35 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6007987.0607 2111156.01389 37.7772831438281 -122.415897110674 (37.7772831438281, -122.415897110674) 8 2 9 28853 34
25651 191577 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 750 Phelps St 20 : Tree Private 2     11 Width 4ft   6015326.98728 2098089.14563 37.7418142438421 -122.38959289501 (37.7418142438421, -122.38959289501) 10 3 8 58 1
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
26575 209525 Undocumented 4 Maytenus boaria :: Mayten 58 1975 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5993787.23171 2102090.81527 37.7515839380697 -122.464360185395 (37.7515839380697, -122.464360185395) 1 8 4 29491 12
31707 242484 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2675 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6008307.71975 2102954.44615 37.7547815657263 -122.414207437417 (37.7547815657263, -122.414207437417) 2 4 7 28859 19
34481 201714 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 726 Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6015317.96334 2088364.51894 37.7151118613908 -122.388945312084 (37.7151118613908, -122.388945312084) 10 3 8 58 1
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
43136 181033 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 39 Curtis St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 4ft   6000587.53239 2088326.47 37.7141798831749 -122.439857163381 (37.7141798831749, -122.439857163381) 9 7 6 28861 5
45829 131224 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 41 Jones St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6009083.28027 2112713.95456 37.7816224473696 -122.412215056906 (37.7816224473696, -122.412215056906) 7 10 9 28852 36
46347 177891 Undocumented 4 Olea europaea :: Olive Tree 9 350 Rutland St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6010352.02594 2088617.41992 37.7155297655706 -122.406127617893 (37.7155297655706, -122.406127617893) 9 7 8 309 39
50233 237038 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Octavia St 1 : Tree Private 2     5 Width 4ft   6005608.42983 2109742.33589 37.773267513529 -122.424025015163 (37.773267513529, -122.424025015163) 7 9 11 28852 10
50629 225859 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 784 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   5998015.01543 2107655.1459 37.7671049865286 -122.450141071966 (37.7671049865286, -122.450141071966) 15 5 11 29492 9
50640 129442 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 144 Cyril Magnin St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6010104.97756 2114284.67603 37.7859925517698 -122.408791302782 (37.7859925517698, -122.408791302782) 14 10 10 28852 36
52117 131429 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009867.09443 2114421.62691 37.7863552591459 -122.40962398688 (37.7863552591459, -122.40962398688) 5 10 10 28852 36
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
63327 191576 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 750 Phelps St 10 : Tree Private 2     3 Width 4ft   6015473.23648 2098286.93961 37.7423654535913 -122.389101016203 (37.7423654535913, -122.389101016203) 10 3 8 58 1
63497 177892 Undocumented 4 Olea europaea :: Olive Tree 9 350 Rutland St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010348.87494 2088600.69344 37.7154836618219 -122.406137331491 (37.7154836618219, -122.406137331491) 9 7 8 309 39
75255 118899 Undocumented 4 Myoporum laetum :: Myoporum 62 7300 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5980716.90165 2109609.13106 37.771464998604 -122.510116727255 (37.771464998604, -122.510116727255) 11 6 2 55 26
75871 125324 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6013147.44886 2118845.30288 37.798684901431 -122.398585258406 (37.798684901431, -122.398585258406) 3 1 10 28860 6
83125 177890 Undocumented 4 Olea europaea :: Olive Tree 9 350 Rutland St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6010359.41892 2088635.45885 37.7155797103057 -122.406103334421 (37.7155797103057, -122.406103334421) 9 7 8 309 39
90401 250397 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 8 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5988195.49232 2115836.13559 37.789000877549 -122.484705080384 (37.789000877549, -122.484705080384) 11 6 1 55 33
93278 131107 Undocumented 4 Maytenus boaria :: Mayten 58 2400 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003178.6473 2116233.7601 37.7909538542967 -122.432893797319 (37.7909538542967, -122.432893797319) 13 9 1 29490 27
95826 239156 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Octavia St 4 : Tree Private 2     5 Width 4ft   6005612.49957 2109700.10187 37.7731517788755 -122.42400793342 (37.7731517788755, -122.42400793342) 7 9 11 28852 10
102701 223409 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 898 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010169.99414 2104057.76493 37.7579154611487 -122.407844947098 (37.7579154611487, -122.407844947098) 2 4 7 28859 19
103850 210536 Undocumented 4 Myoporum laetum :: Myoporum 62 1482 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   5994312.93494 2105441.26855 37.7608137107938 -122.462785287219 (37.7608137107938, -122.462785287219) 1 5 11 56 12
104904 129975 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 264 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009238.58117 2113617.10883 37.7841110063469 -122.411741623201 (37.7841110063469, -122.411741623201) 14 10 9 28852 36
112244 130099 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009103.32764 2112603.74896 37.7813209739269 -122.412137911252 (37.7813209739269, -122.412137911252) 7 10 9 28852 36
116500 250406 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 18 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5988082.54257 2115834.78323 37.788990585691 -122.485095767482 (37.788990585691, -122.485095767482) 11 6 1 55 33
116550 250398 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 8 Seacliff Ave 2 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   5988180.43307 2115835.98663 37.7889995915087 -122.484757171825 (37.7889995915087, -122.484757171825) 11 6 1 55 33
119462 237040 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Octavia St 3 : Tree Private 2     5 Width 4ft   6005610.09761 2109720.52403 37.7732077175873 -122.424017694677 (37.7732077175873, -122.424017694677) 7 9 11 28852 10
128988 250401 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 15 Seacliff Ave 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5988118.48036 2115798.88106 37.7888941019258 -122.484968793995 (37.7888941019258, -122.484968793995) 11 6 1 55 33
133542 128763 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Grant Ave 3 Sidewalk: Curb side : Pot Tree Private 2     3 Width 4ft   6011215.3339 2114610.75087 37.7869500059829 -122.40497271844 (37.7869500059829, -122.40497271844) 5 10 10 28857 6
135308 235358 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1575 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6006985.4322 2107308.54488 37.7666625470602 -122.419089103205 (37.7666625470602, -122.419089103205) 8 4 7 28853 19
136415 237037 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 129 Octavia St 1 : Tree Private 2     6 Width 4ft   6005605.52362 2109755.39176 37.7733031977155 -122.424035996776 (37.7733031977155, -122.424035996776) 7 9 11 28852 10
136737 237034 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 150 Octavia St 1 : Tree Private 2     4 Width 4ft   6005711.67822 2109842.25548 37.7735476972984 -122.423674970241 (37.7735476972984, -122.423674970241) 7 9 11 28852 10
141471 211095 Undocumented 4 Pinus radiata :: Monterey Pine 15 66 Aerial Way 4 Sidewalk: Curb side : Pot Tree Private 2     38 Width 4ft   5992315.3975 2102577.16618 37.7528343824016 -122.469485327309 (37.7528343824016, -122.469485327309) 1 8 4 56 12
145499 239158 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Octavia St 6 : Tree Private 2     4 Width 4ft   6005617.18186 2109670.50026 37.7730707643493 -122.423989631326 (37.7730707643493, -122.423989631326) 7 9 11 28852 10
146981 256571 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 66 Aerial Way 5 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   5992257.72323 2102553.22068 37.7527653009777 -122.469683030659 (37.7527653009777, -122.469683030659) 1 8 4 56 12
149928 212198 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 820 Bosworth St 6 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6001725.38163 2095552.74982 37.7340863191191 -122.436441210896 (37.7340863191191, -122.436441210896) 9 7 5 63 7
150560 201715 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 726 Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6015296.60638 2088393.85947 37.715191240972 -122.389021178889 (37.715191240972, -122.389021178889) 10 3 8 58 1
151230 188700 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1498 Evans Ave 6 : Tree Private 2     17 Width 4ft   6016385.13466 2098043.91296 37.7417486598831 -122.385930982422 (37.7417486598831, -122.385930982422) 10 3 8 58 1
156419 250399 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5988151.26478 2115836.13663 37.7889983045622 -122.484858100014 (37.7889983045622, -122.484858100014) 11 6 1 55 33
158571 234989 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1345 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6003281.84215 2100423.29636 37.747548037017 -122.43140761637 (37.747548037017, -122.43140761637) 2 4 5 63 22
161013 177893 Undocumented 4 Olea europaea :: Olive Tree 9 350 Rutland St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6010340.10601 2088584.08173 37.7154375589705 -122.406166471321 (37.7154375589705, -122.406166471321) 9 7 8 309 39
162503 246851 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 398 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6001242.81313 2109957.23852 37.7736101399319 -122.439141646592 (37.7736101399319, -122.439141646592) 15 5 11 29492 10
169219 120739 Undocumented 4 Myoporum laetum :: Myoporum 62 704 20th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5989768.45154 2110490.84197 37.7744156752518 -122.47887179631 (37.7744156752518, -122.47887179631) 11 6 2 55 26
170909 237039 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Octavia St 2 : Tree Private 2     7 Width 4ft   6005609.24206 2109730.37641 37.7732347215415 -122.424021354908 (37.7732347215415, -122.424021354908) 7 9 11 28852 10
172466 250402 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 15 Seacliff Ave 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   5988140.1435 2115799.82698 37.7888979609226 -122.484893912851 (37.7888979609226, -122.484893912851) 11 6 1 55 33
173722 250672 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 726 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2018 12:00:00 AM 3 Width 4ft Permit Number 781557 5986349.68151 2114864.86182 37.7862263710027 -122.491019750162 (37.7862263710027, -122.491019750162) 11 6 1 55 33
176875 212201 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 820 Bosworth St 9 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6001684.04904 2095564.31513 37.7341157260662 -122.436584937851 (37.7341157260662, -122.436584937851) 9 7 5 63 7
178226 131108 Undocumented 4 Maytenus boaria :: Mayten 58 2400 Clay St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003167.86263 2116231.97608 37.7909483441395 -122.432930984297 (37.7909483441395, -122.432930984297) 13 9 1 29490 27
180495 200337 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 9 : Tree Private 2     10 Width 4ft   6015484.25752 2098301.13552 37.7424050435698 -122.389063899405 (37.7424050435698, -122.389063899405) 10 3 8 58 1
180897 210472 Undocumented 4 Myoporum laetum :: Myoporum 62 624 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5993801.69661 2106684.35823 37.7641974522641 -122.464643687651 (37.7641974522641, -122.464643687651) 11 8 11 56 12
182314 250403 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 15 Seacliff Ave 4 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5988162.69777 2115798.41147 37.7888953879622 -122.484815775245 (37.7888953879622, -122.484815775245) 11 6 1 55 33
182628 131223 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 41 Jones St 1 Sidewalk: Curb side : Pot Tree Private 2     2 Width 4ft   6009081.9899 2112741.73787 37.7816986613089 -122.412221485227 (37.7816986613089, -122.412221485227) 7 10 9 28852 36
186345 239157 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Octavia St 5 : Tree Private 2     3 Width 4ft   6005616.09638 2109686.32891 37.7731141647188 -122.423994511963 (37.7731141647188, -122.423994511963) 7 9 11 28852 10
194143 118792 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 746 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5982002.3368 2110652.98782 37.7744068613492 -122.505747814892 (37.7744068613492, -122.505747814892) 11 6 2 55 26
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
3310 175373 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10 Junipero Serra Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991419.90979 2088711.03664 37.714709696259 -122.47157171488 (37.714709696259, -122.47157171488) 9 8 6 64 24
3950 230064 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 501 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007631.21664 2095734.29453 37.7349186191825 -122.416035690789 (37.7349186191825, -122.416035690789) 2 7 7 28859 2
4364 228727 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 3700 17th St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004008.60516 2106001.5865 37.7629058684239 -122.429292229258 (37.7629058684239, -122.429292229258) 8 4 5 28862 3

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