268 rows where qSpecies_id = 77 sorted by SiteOrder

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)
246 136052 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1114 Greenwich St 1 Side Yard : Yard Tree Private 2     3     6007569.13805 2119905.68389 37.801284085155 -122.417963252702 (37.801284085155, -122.417963252702) 5 1 1 28858 32
2376 57631 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 724 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/15/1976 12:00:00 AM 8   Permit Number 16529 6004511.94268 2110995.61836 37.7766467538829 -122.427907235555 (37.7766467538829, -122.427907235555) 7 9 11 28852 10
10454 106790 Undocumented 4 Prunus x yedoensis :: Yoshino Cherry 77 174 FAIRMOUNT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x6   6004503.2 2097272.2 37.7389649933023 -122.426959842808 (37.7389649933023, -122.426959842808) 2 7 5 63 7
17624 120418 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 779 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5988805.2712 2110017.74707 37.7730607113316 -122.482168912555 (37.7730607113316, -122.482168912555) 11 6 2 55 26
19717 47020 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 521 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM 4   Permit Number 45015 6004890.00739 2110720.29512 37.7759121642541 -122.426579788542 (37.7759121642541, -122.426579788542) 7 9 11 28852 10
22137 120283 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 139 24th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13     5988317.15466 2115062.63745 37.786884157218 -122.484227400222 (37.786884157218, -122.484227400222) 11 6 1 55 33
22465 136051 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 584 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6004614.40707 2110680.65398 37.7757877349621 -122.427530336862 (37.7757877349621, -122.427530336862) 7 9 11 28852 10
22899 238577 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 133 Buchanan St 1 : Tree Private 2     9 Width 3ft   6004747.18096 2108954.98025 37.771056963743 -122.426948105892 (37.771056963743, -122.426948105892) 7 9 11 28852 10
24045 141370 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 430 BRODERICK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6001204.6932 2110218.0701 37.7743241488087 -122.439292208301 (37.7743241488087, -122.439292208301) 15 5 11 29492 10
24291 123575 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 118 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5994297.68738 2114732.87451 37.7863251158785 -122.463512352181 (37.7863251158785, -122.463512352181) 11 6 1 54 11
24773 98036 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2242 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768378 6002381.4 2115984.8 37.7902250230638 -122.43563441767 (37.7902250230638, -122.43563441767) 13 9 1 29490 27
25738 97483 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 50 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2011 12:00:00 AM 3   Permit Number 768208 5989920.47182 2114841.78 37.7863709666179 -122.478664195663 (37.7863709666179, -122.478664195663) 11 6 1 55 33
27412 65777 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1796- 1796 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1990 12:00:00 AM 3   Permit Number 28742 6004431.04108 2118780.7342 37.7980181503743 -122.428742211078 (37.7980181503743, -122.428742211078) 13 9 1 57 17
29395 83672 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 76 Santa Fe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 6 3x3 Permit Number 52299 6012122.94965 2095206.11599 37.7337198723641 -122.400469008954 (37.7337198723641, -122.400469008954) 10 3 8 58 1
30515 238584 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 73 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6005403.70836 2103296.31784 37.7555567183818 -122.42427463098 (37.7555567183818, -122.42427463098) 2 4 5 28859 19
31602 196549 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 40 Ledyard St 1 : Tree Private 2     7 Width 2ft   6011616.35938 2095078.64568 37.7333416013201 -122.402211492182 (37.7333416013201, -122.402211492182) 10 3 8 58 1
32892 238578 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 149 Buchanan St 1 : Tree Private 2     2 Width 3ft   6004732.39628 2109051.52361 37.7713212124262 -122.427006123859 (37.7713212124262, -122.427006123859) 7 9 11 28852 10
35128 5454 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 561 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2009 12:00:00 AM 3 8   6004988.38949 2105109.00015 37.7605104576133 -122.425839954961 (37.7605104576133, -122.425839954961) 2 4 5 28859 19
35888 239027 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 26 Harry St 1 Sidewalk: Property side : Yard Tree Private 2     4     6003403.2403 2097795.09814 37.740338493218 -122.430800300593 (37.740338493218, -122.430800300593) 2 7 5 63 7
38026 50359 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1044 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM 5   Permit Number 47031 6014195.81741 2102278.81797 37.753255413506 -122.3937973317 (37.753255413506, -122.3937973317) 10 3 8 28856 29
39652 124172 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 81 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5995886.79128 2112251.90704 37.7796044719959 -122.457834899878 (37.7796044719959, -122.457834899878) 11 6 2 54 16
42382 84481 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 59 Santa Fe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2008 12:00:00 AM 4 3x3 Permit Number 50146 6012081.07031 2095312.02235 37.7340083335059 -122.40062123629 (37.7340083335059, -122.40062123629) 10 3 8 58 1
43016 51309 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 518 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2004 12:00:00 AM 7   Permit Number 47675 5989718.85945 2111803.87155 37.7780180115133 -122.479139410746 (37.7780180115133, -122.479139410746) 11 6 2 55 26
43615 114880 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 1687 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2015 12:00:00 AM   3x3   6009362.4 2099644 37.7457510020701 -122.4103263211 (37.7457510020701, -122.4103263211) 2 7 7 28859 2
43837 124379 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 37 Jordan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5996169.18438 2114263.97819 37.785145303794 -122.457003563892 (37.785145303794, -122.457003563892) 11 6 1 54 31
46845 238593 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006434.12493 2107338.12771 37.7667127130356 -122.420998084205 (37.7667127130356, -122.420998084205) 8 4 7 28853 19
48308 136039 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3434 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999787.69729 2120389.72868 37.8021721279018 -122.44492518757 (37.8021721279018, -122.44492518757) 13 9 1 57 17
51956 196545 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 938 Rhode Island St 1 : Tree Private 2     1 Width 4ft   6011854.06587 2104027.62304 37.7579268348784 -122.402018565106 (37.7579268348784, -122.402018565106) 10 3 8 28856 29
52279 196548 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1828 Illinois St 1 : Tree Private 2     7 Width 4ft   6016259.97415 2100569.45799 37.748676359729 -122.386539809975 (37.748676359729, -122.386539809975) 10 3 8 58 1
52717 5516 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 839 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/30/2009 12:00:00 AM 3 6X6   6005075.66356 2103479.99989 37.7560425375576 -122.425422183901 (37.7560425375576, -122.425422183901) 2 4 5 28859 19
53920 33647 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 532 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/2004 12:00:00 AM 6   Permit Number 47617 6004852.49961 2110739.683 37.7759632781281 -122.426710918693 (37.7759632781281, -122.426710918693) 7 9 11 28852 10
54637 238586 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 991 San Bruno Ave 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   6011096.08107 2103736.70014 37.7570856908704 -122.404619530365 (37.7570856908704, -122.404619530365) 10 4 8 28859 19
56484 122199 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 171 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991475.81854 2114309.23252 37.7849989216744 -122.473244290329 (37.7849989216744, -122.473244290329) 11 6 2 54 26
56628 196546 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1017 Rhode Island St 1 : Tree Private 2     2 Width 3ft   6011946.26987 2103466.67493 37.7563917406915 -122.401660256322 (37.7563917406915, -122.401660256322) 10 3 8 28856 29
57891 196540 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012078.91363 2106521.10785 37.7647859371415 -122.401416175823 (37.7647859371415, -122.401416175823) 14 3 8 28856 29
59809 45688 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 614 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2001 12:00:00 AM 6   Permit Number 44373 5988813.86357 2111116.63856 37.7760784619734 -122.482219714975 (37.7760784619734, -122.482219714975) 11 6 2 55 26
60441 46239 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1050 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM 5   Permit Number 44533 6014194.98195 2102252.43023 37.7531829119855 -122.393798374016 (37.7531829119855, -122.393798374016) 10 3 8 28856 29
61657 246464 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 212 Duncan St 1 : Tree Private 2     3 Width 3ft   6005064.93111 2099921.35386 37.7462707137301 -122.425206088515 (37.7462707137301, -122.425206088515) 2 7 5 63 22
65368 50856 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 743 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2004 12:00:00 AM 4   Permit Number 47371 5985677.37672 2110827.17931 37.7751007543065 -122.493048175392 (37.7751007543065, -122.493048175392) 11 6 2 55 26
69930 57837 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 1339 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2009 12:00:00 AM   3x3 Permit Number 52005 5994540.33028408 2106409.85629846 37.763486295989 -122.46206907635 (37.763486295989, -122.46206907635) 1 5 11 56 12
70362 4175 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3812X Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 6 3X3   6005112.58146 2100504.28147 37.7478739908906 -122.425082788743 (37.7478739908906, -122.425082788743) 2 4 5 63 22
76508 196550 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 44 Ledyard St 1 : Tree Private 2     7 Width 2ft   6011631.22474 2095058.90735 37.7332882337562 -122.402158710982 (37.7332882337562, -122.402158710982) 10 3 8 58 1
77284 44274 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 730 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2001 12:00:00 AM 4   Permit Number 43700 6011255.06578 2104741.61874 37.7598538580824 -122.404140420144 (37.7598538580824, -122.404140420144) 10 3 8 28856 29
79691 124155 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 970 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5995858.43793 2112228.39454 37.7795382839593 -122.457931283713 (37.7795382839593, -122.457931283713) 11 6 2 54 16
83158 57747 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3425 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/1977 12:00:00 AM 8   Permit Number 16667 5997831.65027 2116097.2527 37.7902743175622 -122.45138424801 (37.7902743175622, -122.45138424801) 11 6 1 54 31
84016 196547 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 970 Wisconsin St 1 : Tree Private 2     10 Width 6ft   6012751.32394 2103003.67516 37.7551653352247 -122.398843585967 (37.7551653352247, -122.398843585967) 10 3 8 28856 29
84948 107672 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 184 Cook St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2014 12:00:00 AM 3 3x3 Permit Number 773528 5997643.33289 2112648.90363 37.7807952777935 -122.45178694364 (37.7807952777935, -122.45178694364) 15 6 2 54 16
92612 238575 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 127 Buchanan St 1 : Tree Private 2   05/02/2002 12:00:00 AM 7 Width 3ft Permit Number 45000 6004751.79623 2108930.40583 37.7709897493005 -122.426930391028 (37.7709897493005, -122.426930391028) 7 9 11 28852 10
94425 115309 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 500x Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2x2   6004961.03279 2110755.75124 37.776013533141 -122.426336618167 (37.776013533141, -122.426336618167) 7 9 11 28852 10
94982 239017 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 420 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6004649.23928 2110026.77374 37.7739943096302 -122.427363252712 (37.7739943096302, -122.427363252712) 7 9 11 28852 10
96537 239010 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 60 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010651.97236 2100432.84922 37.747989214748 -122.405922704693 (37.747989214748, -122.405922704693) 2 7 7 28859 2
97109 239025 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 323 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6006919.22148 2096314.31292 37.7364711647048 -122.41853842942 (37.7364711647048, -122.41853842942) 2 7 7 28859 2
97447 84400 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 611-613 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2008 12:00:00 AM 3 3x3 Permit Number 51577 5993447.66428 2111301.75717 37.7768551863663 -122.466203752377 (37.7768551863663, -122.466203752377) 11 6 2 54 11
99570 114197 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1701x 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6012196.35096 2106527.32725 37.7648095659429 -122.4010104251 (37.7648095659429, -122.4010104251) 14 3 8 28856 29
100212 238582 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3456 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006754.5466 2100607.36077 37.7482496404132 -122.41941224938 (37.7482496404132, -122.41941224938) 2 4 7 28859 19
100238 57625 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1040 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2014 12:00:00 AM 3   Permit Number 773355 6014196.28428 2106222.11039 37.7640828669594 -122.394071750814 (37.7640828669594, -122.394071750814) 14 3 8 28856 29
101900 47502 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
104300 196537 Planning Code 138.1 required 2 Prunus x yedoensis :: Yoshino Cherry 77 526 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782869 6010635.96485 2105787.36101 37.7626906193079 -122.406355282166 (37.7626906193079, -122.406355282166) 8 4 8 28859 19
105268 213731 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 72 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994987.04868 2099905.16215 37.7456517715262 -122.460052772716 (37.7456517715262, -122.460052772716) 1 8 4 59 40
106048 61899 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 335 Maple St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1985 12:00:00 AM 5   Permit Number 21942 5996649.71832 2115128.18725 37.7875457744774 -122.455403556547 (37.7875457744774, -122.455403556547) 11 6 1 54 31
106942 62466 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 708 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/23/2012 12:00:00 AM 2   Permit Number 769096 6011238.859 2104985.8972 37.7605236866263 -122.40421366454 (37.7605236866263, -122.40421366454) 10 3 8 28856 29
107927 239012 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 417 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009194 2100253 37.7474137401608 -122.410951632147 (37.7474137401608, -122.410951632147) 2 7 7 28859 2
108435 98407 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 24 19th Ave 1 Sidewalk: Curb side : Tree Private 2   02/09/2012 12:00:00 AM 3   Permit Number 768590 5989919.44776 2114906.64899 37.7865490191546 -122.478672484402 (37.7865490191546, -122.478672484402) 11 6 1 55 33
113704 239024 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 389 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004038.85397 2100110.5602 37.7467322107326 -122.428767625048 (37.7467322107326, -122.428767625048) 2 7 5 63 22
114222 52710 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1@ JACKSON Cherry St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM 7   Permit Number 48767 5996063.73844 2115999.96188 37.7899057925288 -122.457494014373 (37.7899057925288, -122.457494014373) 11   1 54 31
114927 196551 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 48 Ledyard St 1 : Tree Private 2     6 Width 2ft   6011647.63932 2095039.33012 37.7332353949856 -122.402100585073 (37.7332353949856, -122.402100585073) 10 3 8 58 1
115364 105908 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1237 NORIEGA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2014 12:00:00 AM 20 3x3 Permit Number 772682 5990134.3 2103036.1 37.7539682014274 -122.477061416534 (37.7539682014274, -122.477061416534) 1 8 3 56 35
116083 239015 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 380 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6004736.9455 2110029.27372 37.7740061339081 -122.427060040012 (37.7740061339081, -122.427060040012) 7 9 11 28852 10
118474 136041 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3399 Jackson St 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   5998034.28644 2116116.08829 37.7903376361102 -122.450684503481 (37.7903376361102, -122.450684503481) 13 6 1 54 31
118812 90480 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 139 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2008 12:00:00 AM 3 3x3   5988320.04401 2115047.37952 37.7868424315213 -122.484216284461 (37.7868424315213, -122.484216284461) 11 6 1 55 33
119039 67591 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 210 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 4   Permit Number 31158 6013702.18081 2106068.08806 37.763632481088 -122.395769929855 (37.763632481088, -122.395769929855) 14 3 8 28856 29
119873 239006 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2801 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009817.72923 2104524.2582 37.7591766191261 -122.409096148662 (37.7591766191261, -122.409096148662) 2 4 7 28859 19
120545 202152 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1951 Armstrong Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 7ft   6013046.17664 2093441.40359 37.7289257780866 -122.397153419018 (37.7289257780866, -122.397153419018) 10 3 8 58 1
120741 31876 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 457 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1995 12:00:00 AM 2   Permit Number 35315 5984053.55944 2112762.76101 37.7803202011246 -122.498808255642 (37.7803202011246, -122.498808255642) 11 6 2 55 26
120911 118028 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Shore View Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5984316.15967 2112798.24876 37.780433038793 -122.49790243493 (37.780433038793, -122.49790243493) 11 6 2 55 26
121261 196544 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1200x Kansas St 1 Median : Cutout Tree DPW 1   05/15/2018 12:10:00 PM 4 Width 5ft   6011674.97402 2102731.27183 37.7543573429212 -122.402546786412 (37.7543573429212, -122.402546786412) 10 3 8 28856 29
121681 120334 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 16 West Clay St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   5988822.29899 2115016.65173 37.7867872922875 -122.482476367259 (37.7867872922875, -122.482476367259) 11 6 1 55 33
121753 136038 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2400 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6001472.99161 2118372.51035 37.7967294155856 -122.438948622379 (37.7967294155856, -122.438948622379) 13 9 1 57 17
122436 239021 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 530 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6004598.87911 2110377.72269 37.7749550814495 -122.427562465139 (37.7749550814495, -122.427562465139) 7 9 11 28852 10
124046 44512 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 131 Fairmount St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2001 12:00:00 AM 10 4x4 Permit Number 43806 6004687.03371464 2097226.29740092 37.7388493482812 -122.426320962915 (37.7388493482812, -122.426320962915) 2 7 5 63 7
127095 32222 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 623 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1995 12:00:00 AM 15   Permit Number 35543 6009718.6984 2100387.54672 37.7478125842885 -122.40914674543 (37.7478125842885, -122.40914674543) 2 7 7 28859 2
128052 238581 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 18 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006358.36528 2099816.491 37.7460557694506 -122.420726098652 (37.7460557694506, -122.420726098652) 2 7 5 28859 2
128463 109327 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1868 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2015 12:00:00 AM 3   Permit Number 774911 6003963.48635 2119408.041 37.7997140999836 -122.430404865987 (37.7997140999836, -122.430404865987) 13 9 1 57 17
131277 179170 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 179 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001259.83204 2087347.33172 37.7115296332658 -122.437463366848 (37.7115296332658, -122.437463366848) 9 7 6 28861 5
132173 85064 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 57 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2007 12:00:00 AM     Permit Number 49430 6005948 2102270 37.7527694058254 -122.422319381816 (37.7527694058254, -122.422319381816) 2 4 5 28859 19
135957 40046 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1732 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 5 7.5x2.5 Permit Number 767656 6014557.3351 2095185.10659 37.7337976439298 -122.392051083889 (37.7337976439298, -122.392051083889) 10 3 8 58 1
136463 213720 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 398 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992203.97011 2094317.89279 37.7301500773614 -122.469269557468 (37.7301500773614, -122.469269557468) 9 8 4 59 40
140665 246630 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3320 Harrison St 1 Front Yard : Yard Tree Private 2     1     6009028.43524 2099278.75412 37.7447293908617 -122.411455327621 (37.7447293908617, -122.411455327621) 2 7 7 28859 2
140943 38818 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 221 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/04/2005 12:00:00 AM 4   Permit Number 47857 5994895.35063 2113953.79381 37.7842203879728 -122.461388106023 (37.7842203879728, -122.461388106023) 11 6 2 54 11
142625 196552 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 56 Ledyard St 1 : Tree Private 2     6 Width 2ft   6011678.30483 2094998.2948 37.7331244321513 -122.401991681687 (37.7331244321513, -122.401991681687) 10 3 8 58 1
144554 28271 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1227 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 5   6005204.12074 2101185.69152 37.7497501565604 -122.424814719731 (37.7497501565604, -122.424814719731) 2 4 5 28859 19
146029 98235 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 42 19th Ave 1 Sidewalk: Curb side : Tree Private 2   01/09/2012 12:00:00 AM 3   Permit Number 768620 5989920.54745 2114876.26257 37.7864656504451 -122.47866645673 (37.7864656504451, -122.47866645673) 11 6 1 55 33
146207 213717 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1783 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5991214.07731 2103294.38523 37.7547399684927 -122.47334616449 (37.7547399684927, -122.47334616449) 1 8 4 56 12
146323 238579 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 415 Buchanan St 1 : Tree Private 2     7 Width 6ft   6004609.7624 2109940.50049 37.7737551915801 -122.427493662508 (37.7737551915801, -122.427493662508) 7 9 11 28852 10
147009 41609 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM     Permit Number 42107 6006559.89893522 2106145.26349714 37.7634444777116 -122.420478371661 (37.7634444777116, -122.420478371661) 8 4 7 28859 19
147344 239016 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 399 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6004681.24572 2110023.15394 37.773986180653 -122.427252279074 (37.773986180653, -122.427252279074) 7 9 11 28852 10
149200 96001 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 321 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 3 3x3 Permit Number 767651 6013592.98879 2094402.89056 37.73159625106 -122.395330363713 (37.73159625106, -122.395330363713) 10 3 8 58 1
151721 41603 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 98X Hoff St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM 8 3x3 Permit Number 42107 6006559.89893522 2106145.26349714 37.7634444777116 -122.420478371661 (37.7634444777116, -122.420478371661) 8 4 7 28859 19
152029 123081 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 756 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992285.07246 2110293.11916 37.7740185941965 -122.470152007973 (37.7740185941965, -122.470152007973) 11 6 2 54 11
152123 43636 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 375 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2000 12:00:00 AM     Permit Number 43286 6006792.72953639 2101606.12998031 37.750994184096 -122.419351056484 (37.750994184096, -122.419351056484) 2 4 7 28859 19

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