4,014 rows where qSpecies_id = 40 sorted by Fire Prevention Districts descending

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)
1021 213351 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 752 Head St 1 : Tree Private 2     3 Width 3ft   5993534.80603 2090819.23886 37.7206204409725 -122.464414798499 (37.7206204409725, -122.464414798499) 9 8 6 64 24
1194 213495 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 613 Faxon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994845.46831 2092391.05162 37.725011726204 -122.45999808945 (37.725011726204, -122.45999808945) 9 8 4 28861 40
1339 73360 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 236 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003402.60575 2092794.29016 37.72660737262 -122.430445774353 (37.72660737262, -122.430445774353) 9 7 6 28861 5
1448 178997 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6001810.75276 2089136.90013 37.7164746985284 -122.435687194116 (37.7164746985284, -122.435687194116) 9 7 6 28861 5
1688 213308 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 219 Tara St 1 : Tree Private 2     3 Width 3ft   5997858.51511 2090428.83634 37.7197967734736 -122.44944104777 (37.7197967734736, -122.44944104777) 9 8 6 28861 24
2070 213331 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 151 Byxbee St 1 : Tree Private 2     6 Width 2ft   5991924.78555 2089552.62516 37.7170496899626 -122.469887910591 (37.7170496899626, -122.469887910591) 9 8 6 64 24
2473 88167 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 189 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2013 12:00:00 AM 1 3x3 Permit Number 51184 6010014.6058 2087504.2072 37.7124542316575 -122.407215472312 (37.7124542316575, -122.407215472312) 9 7 8 309 39
2670 262494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Miraloma Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994945 2097531 37.7391304944698 -122.4600262078 (37.7391304944698, -122.4600262078) 9 7 4 59 40
2810 178982 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5998252.81183 2087192.10261 37.7109319923872 -122.447845208002 (37.7109319923872, -122.447845208002) 9 7 6 28861 25
3019 70395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 190 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6005551.02847 2092833.80452 37.7268373382622 -122.423021551618 (37.7268373382622, -122.423021551618) 9 7 7 309 5
3057 70502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 78 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11 6x7   6004601.41978 2093074.4867 37.727444566791 -122.426321455564 (37.727444566791, -122.426321455564) 9 7 6 28861 5
3215 48784 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 268 Onondaga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2002 12:00:00 AM 7   Permit Number 46039 6000083.90087 2091529.02554 37.7229446929396 -122.441827615748 (37.7229446929396, -122.441827615748) 9 7 6 28861 25
3396 214751 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 115 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5995612.00056 2093441.40457 37.7279398000583 -122.457424244157 (37.7279398000583, -122.457424244157) 9 7 4 28861 40
3894 178998 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001820.55644 2089152.21762 37.7165173138053 -122.435654403046 (37.7165173138053, -122.435654403046) 9 7 6 28861 5
3897 214702 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 520 Darien Way 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5992979.91933 2094883.59777 37.7317481717454 -122.466628127212 (37.7317481717454, -122.466628127212) 9 8 4 59 40
3915 79787 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1000 Russia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003769.36441 2089501.77219 37.7175876140639 -122.428943265313 (37.7175876140639, -122.428943265313) 9 7 6 28861 5
4321 214786 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34 Fairfield Way 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993908.89145 2093024.31926 37.7266966141529 -122.463281639244 (37.7266966141529, -122.463281639244) 9 8 4 59 40
4459 78281 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34 Wanda St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000546.67018 2091525.62315 37.7229617089923 -122.440227677765 (37.7229617089923, -122.440227677765) 9 7 6 28861 25
4692 74315 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6000588.28843 2093013.22945 37.7270487050229 -122.440190437741 (37.7270487050229, -122.440190437741) 9 7 6 28861 25
4965 70417 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 124 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6007053.10759 2093048.17382 37.7275105968359 -122.417844078137 (37.7275105968359, -122.417844078137) 9 3 7 309 5
4971 214807 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 550 Judson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5996780.18786 2093638.94841 37.7285492382588 -122.453400068478 (37.7285492382588, -122.453400068478) 9 7 4 28861 40
5538 178975 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 60 Dichiera Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5998617.79966 2087941.66603 37.7130109785485 -122.44663762445 (37.7130109785485, -122.44663762445) 9 7 6 28861 25
5924 214716 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 163 Westgate Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5993482.35353 2094088.81019 37.729594862901 -122.464833426615 (37.729594862901, -122.464833426615) 9 8 4 59 40
6061 72942 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 115 Gladstone Dr 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6006185.1456 2093706.67224 37.7292698047343 -122.420891365245 (37.7292698047343, -122.420891365245) 9 7 6 28861 5
6141 69800 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 367 Delano Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5999779.7835 2091764.72169 37.7235745268131 -122.442895800812 (37.7235745268131, -122.442895800812) 9 7 6 28861 25
6211 44491 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 9   Permit Number 45395 6005461.21441 2093276.54578 37.728047939957 -122.423363497235 (37.728047939957, -122.423363497235) 9 7 7 309 5
6325 213549 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 167 Valdez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996164.20068 2094572.39502 37.7310769303549 -122.455596998927 (37.7310769303549, -122.455596998927) 9 7 4 28861 40
6401 70501 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 75 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6004654.40413 2093072.16776 37.7274411943513 -122.42613812337 (37.7274411943513, -122.42613812337) 9 7 6 28861 5
6493 214723 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 591 Miramar Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5995322.28894 2093286.27731 37.7274972131074 -122.458414554203 (37.7274972131074, -122.458414554203) 9 7 4 28861 40
6690 79764 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 26 Wanda St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000559.45557 2091550.49268 37.7230307229714 -122.440185263946 (37.7230307229714, -122.440185263946) 9 7 6 28861 25
7018 213561 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 130 Montecito Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996368.30466 2094246.96905 37.7301950992263 -122.454867876251 (37.7301950992263, -122.454867876251) 9 7 4 28861 40
7072 179119 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 621 Bowdoin St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008944.10696 2093176.6835 37.7279696962286 -122.411315930896 (37.7279696962286, -122.411315930896) 9 3 7 309 28
7312 254991 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1508 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/21/2020 12:00:00 PM 3 4x4   6002019 2093366 37.7280986838153 -122.435269719024 (37.7280986838153, -122.435269719024) 9 7 6 28861 25
7565 121637 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 298x Otsego Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000311 2091736 37.7235259352509 -122.441057424661 (37.7235259352509, -122.441057424661) 9 7 6 28861 25
7591 213529 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1301 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5995838.74514 2092736.52805 37.7260173993826 -122.456589434062 (37.7260173993826, -122.456589434062) 9 7 4 28861 40
7901 70504 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 437 Peru Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   18     6004727.68791 2092850.78229 37.7268374605684 -122.425869029139 (37.7268374605684, -122.425869029139) 9 7 6 28861 5
7935 213699 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 62 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM 8 Width 3ft Permit Number 42424 5999655.47058 2093801.73285 37.7291606000606 -122.443471779698 (37.7291606000606, -122.443471779698) 9 7 4 63 40
8150 179100 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 135 Craut St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004051.95756 2094086.86306 37.7301932520093 -122.428293070766 (37.7301932520093, -122.428293070766) 9 7 6 28861 5
8215 78428 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1000 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003760.55793 2089507.02649 37.7176015427445 -122.428974079707 (37.7176015427445, -122.428974079707) 9 7 6 28861 5
8306 179066 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Otsego Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000335.97419 2091752.60204 37.723572943118 -122.440972284042 (37.723572943118, -122.440972284042) 9 7 6 28861 25
8324 78480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 575 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6001855.96209 2090141.35003 37.719235261989 -122.435602746878 (37.719235261989, -122.435602746878) 9 7 6 28861 5
8326 72143 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 12 Meda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6000249.61025 2091756.38076 37.7235783992966 -122.441271099083 (37.7235783992966, -122.441271099083) 9 7 6 28861 25
8680 179049 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 179 Santa Rosa Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001280.87762 2093214.71451 37.7276413438501 -122.437810596884 (37.7276413438501, -122.437810596884) 9 7 6 28861 25
9573 108831 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 774658 6003763.1265 2093992.42876 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217) 9 7 6 28861 5
9707 213504 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 435 Montecito Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995680.74302 2093936.83291 37.7293040752209 -122.457222425468 (37.7293040752209, -122.457222425468) 9 7 4 28861 40
9950 78381 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 631 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6003379.38532 2089522.9059 37.7176235608499 -122.430292752023 (37.7176235608499, -122.430292752023) 9 7 6 28861 5
9953 73879 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 345 Congdon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6004728.86924 2093550.80398 37.7287596319363 -122.425914753389 (37.7287596319363, -122.425914753389) 9 7 6 28861 5
10361 70279 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 90 Arago St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5999591.10411 2092976.06015 37.7268898235963 -122.443635008456 (37.7268898235963, -122.443635008456) 9 7 6 28861 25
10377 91396 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2009 12:00:00 AM   3x3 Permit Number 52091 5996731.3 2091236.4 37.7219496073249 -122.453395686079 (37.7219496073249, -122.453395686079) 9 8 4 28861 24
10601 78363 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 575 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6001858.24783 2090145.25438 37.7192461122881 -122.435595125122 (37.7192461122881, -122.435595125122) 9 7 6 28861 5
11336 213698 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 54 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM 9 Width 2ft Permit Number 42422 5999705.61228 2093800.4183 37.7291598500291 -122.443298341854 (37.7291598500291, -122.443298341854) 9 7 4 63 40
11361 78243 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 30 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000646.02726 2093117.37413 37.7273379494759 -122.439998300301 (37.7273379494759, -122.439998300301) 9 7 6 28861 25
11529 179062 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 18 Colonial Way 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000439.3413 2093583.91766 37.7286072022493 -122.440746262842 (37.7286072022493, -122.440746262842) 9 7 6 28861 25
11713 214758 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 47 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5995620 2092942 37.7265690145806 -122.457360475692 (37.7265690145806, -122.457360475692) 9 7 4 28861 40
11717 78354 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1125 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000366.91048 2090562.17909 37.7203060748337 -122.440779991907 (37.7203060748337, -122.440779991907) 9 7 6 28861 25
11785 72266 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 359 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6002393.10905 2091502.19798 37.7230023412585 -122.43384325117 (37.7230023412585, -122.43384325117) 9 7 6 28861 5
11922 78132 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 738 Dartmouth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6009313.83221 2090783.01669 37.7214179201914 -122.409868876754 (37.7214179201914, -122.409868876754) 9 3 7 309 28
12067 78234 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5999806.62934 2090324.19629 37.7196207041996 -122.44269961461 (37.7196207041996, -122.44269961461) 9 7 6 28861 25
12254 213339 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 375 Ralston St 1 : Tree Private 2     4 Width 3ft   5992194.58269 2090348.43318 37.7192503768696 -122.469013242585 (37.7192503768696, -122.469013242585) 9 8 6 64 24
14275 72259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 231 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6002836.88949 2092205.70744 37.7249591941085 -122.432359414777 (37.7249591941085, -122.432359414777) 9 7 6 28861 5
14334 70497 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 182 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6003784.02088 2092788.04528 37.7266118242601 -122.429126790893 (37.7266118242601, -122.429126790893) 9 7 6 28861 5
14380 70403 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 215 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   18     6006511.50188 2092924.30251 37.7271399781258 -122.419707630826 (37.7271399781258, -122.419707630826) 9 7 7 309 5
14705 78251 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 559 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6002953.55708 2090366.3939 37.7199154633005 -122.431824838869 (37.7199154633005, -122.431824838869) 9 7 6 28861 5
14762 62197 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 195 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1986 12:00:00 AM 14   Permit Number 22671 6000569.72887 2092182.49012 37.7247666285575 -122.44019505038 (37.7247666285575, -122.44019505038) 9 7 6 28861 25
14964 62499 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1986 12:00:00 AM 11   Permit Number 22673 6000619.30471 2092428.32179 37.725444448481 -122.440041292395 (37.725444448481, -122.440041292395) 9 7 6 28861 25
15305 62479 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 35 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM 10   Permit Number 31826 6000682.25846 2093099.29894 37.7272903816351 -122.439871753995 (37.7272903816351, -122.439871753995) 9 7 6 28861 25
15324 213539 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1560 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995783.29259 2094350.88739 37.7304468581388 -122.456897840377 (37.7304468581388, -122.456897840377) 9 7 4 28861 40
15377 214743 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 143 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5995640.47159 2093655.78153 37.7285300628876 -122.457341322169 (37.7285300628876, -122.457341322169) 9 7 4 28861 40
15572 70521 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 345 Congdon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6004728.05962 2093562.78266 37.7287924769796 -122.425918404632 (37.7287924769796, -122.425918404632) 9 7 6 28861 5
15892 78237 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1215 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3   Permit Number 779512 5999758.88688 2090259.2057 37.7194395330998 -122.442859978114 (37.7194395330998, -122.442859978114) 9 7 6 28861 25
15931 70127 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 236 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6003416.21624 2092787.34546 37.7265890750119 -122.430398228113 (37.7265890750119, -122.430398228113) 9 7 6 28861 5
16564 62492 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 61 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1986 12:00:00 AM 17   Permit Number 22663 6000854.65183 2092771.54235 37.7264002488622 -122.43925230995 (37.7264002488622, -122.43925230995) 9 7 6 28861 25
16604 213316 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 325 Howth St 2 : Tree Private 2     3 Width 3ft   5997165.98186 2090264.50059 37.7193059055324 -122.451823029928 (37.7193059055324, -122.451823029928) 9 8 6 28861 24
16830 213628 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 518 Rockdale Dr 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5997988.71827 2097660.25448 37.7396599853215 -122.449511768669 (37.7396599853215, -122.449511768669) 9 7 4 59 40
16875 108379 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 Bertita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/28/2020 01:08:00 PM 3 3x3 Permit Number 773806 6000690.09097 2090159.58738 37.7192190489897 -122.439634019098 (37.7192190489897, -122.439634019098) 9 7 6 28861 25
17185 78318 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 605 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5 3x6   6008900.36842 2091273.56909 37.7227416934471 -122.411332749116 (37.7227416934471, -122.411332749116) 9 3 7 309 28
17266 178980 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998273.42881 2087174.03892 37.7108835719974 -122.447772651587 (37.7108835719974, -122.447772651587) 9 7 6 28861 25
17823 62478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 19 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1986 12:00:00 AM 17   Permit Number 22649 6000701.05589 2093131.58953 37.7273801141826 -122.439809085645 (37.7273801141826, -122.439809085645) 9 7 6 28861 25
18961 62496 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1986 12:00:00 AM 13   Permit Number 22668 6000676.96581 2092453.05984 37.7255156559072 -122.439843736499 (37.7255156559072, -122.439843736499) 9 7 6 28861 25
19023 70459 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 73 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6004663.96157 2093087.11793 37.727482784398 -122.426106147103 (37.727482784398, -122.426106147103) 9 7 6 28861 5
19033 213284 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 152 Jules Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994475.62527 2090947.51619 37.7210268472907 -122.461171998816 (37.7210268472907, -122.461171998816) 9 8 6 28861 24
19321 78229 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 605 Colby St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6 3x9   6008895.81383 2091285.82356 37.7227750861924 -122.411349358704 (37.7227750861924, -122.411349358704) 9 3 7 309 28
19353 213689 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 571 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5997645.02441 2095249.56156 37.7330211342111 -122.450526361304 (37.7330211342111, -122.450526361304) 9 7 4 59 40
19595 214748 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 131 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5995627.33147 2093578.02961 37.7283158201112 -122.457381125259 (37.7283158201112, -122.457381125259) 9 7 4 28861 40
19752 40654 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 300 Congdon St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2005 12:00:00 AM 9   Permit Number 47919 6004685.50571 2093693.15993 37.7291480590261 -122.426074794035 (37.7291480590261, -122.426074794035) 9 7 6 28861 5
19755 40666 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Maynard St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767516 6004070.62612566 2093782.39936272 37.7293583191123 -122.428206841061 (37.7293583191123, -122.428206841061) 9 7 6 28861 5
19987 109057 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 825 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772770 5997289.53523 2087142.99435 37.7107420465867 -122.451170962984 (37.7107420465867, -122.451170962984) 9 7 6 28861 25
20179 213518 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 130 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995655.95253 2093561.21811 37.7282713036556 -122.45728096595 (37.7282713036556, -122.45728096595) 9 7 4 28861 40
20213 49303 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 301-329X Santa Rosa Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM     Permit Number 46312 6000618.30444023 2093710.90436804 37.7289660686913 -122.440136680877 (37.7289660686913, -122.440136680877) 9 7 6 28861 25
20733 213548 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 140 Colon Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5996162.65905 2093980.6549 37.7294520658493 -122.455559574538 (37.7294520658493, -122.455559574538) 9 7 4 28861 40
21882 213345 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 542 Arch St 1 : Tree Private 2     5 Width 3ft   5992754.74517 2090800.4755 37.7205239248105 -122.467109837375 (37.7205239248105, -122.467109837375) 9 8 6 64 24
22608 214802 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 277 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5997453.26468 2096576.46519 37.7366535157474 -122.451284985326 (37.7366535157474, -122.451284985326) 9 7 4 59 40
22700 178996 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Wanda St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6000569.64733 2091569.32394 37.7230830095612 -122.440151382899 (37.7230830095612, -122.440151382899) 9 7 6 28861 25
22830 68274 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 530 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 2   Permit Number 32081 6008779.93848 2093554.15422 37.7289969414408 -122.411910130973 (37.7289969414408, -122.411910130973) 9 3 7 309 28
22955 40530 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 130 San Aleso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45382 5993353.73347688 2094704.41991722 37.7312777588569 -122.46532277559 (37.7312777588569, -122.46532277559) 9 8 4 59 40
23343 214837 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 527 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994748.36207 2092060.94977 37.7240997605754 -122.460309866409 (37.7240997605754, -122.460309866409) 9 8 4 28861 24
23615 117008 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1315 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2016 12:00:00 AM 3 3x3   6006952.61647 2093135.11232 37.7277436552341 -122.418197638517 (37.7277436552341, -122.418197638517) 9 3 7 309 5
23722 214819 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6001004.15668 2094363.77519 37.7307806612912 -122.438849530576 (37.7307806612912, -122.438849530576) 9 7 4 63 40
23854 86960 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 208 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/2007 12:00:00 AM 6 3x3 Permit Number 49928 5993493.7535 2087361.9529 37.7111251955331 -122.464305827668 (37.7111251955331, -122.464305827668) 9 8 4 64 24
24127 46734 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 315 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/2002 12:00:00 AM     Permit Number 44844 5993734.25176167 2089288.64398892 37.7164292900251 -122.463614355193 (37.7164292900251, -122.463614355193) 9 8 6 64 24

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