268 rows where qSpecies_id = 77 sorted by qCareAssistant

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
4262 213721 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x Santa Monica Way 2 Median : Yard Tree DPW 1     1     5993647.57824 2097426.08398 37.7387677148629 -122.464504452814 (37.7387677148629, -122.464504452814) 1 8 4 59 40
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
15965 136043 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3425 Jackson St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5997844.87788 2116098.17267 37.7902776009696 -122.451338548042 (37.7902776009696, -122.451338548042) 11 6 1 54 31
16844 249665 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 17 Front Yard : Yard Tree Private 2     9     5999244.57563 2117118.96584 37.7931604758161 -122.44656918694 (37.7931604758161, -122.44656918694) 11   1 57 30
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
19457 96917 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2151X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2011 12:00:00 AM 3 3x3 Permit Number 768104 5988894.20073 2110528.61903 37.7744685962766 -122.481898727171 (37.7744685962766, -122.481898727171) 11 6 2 55 26
21481 41610 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 4 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
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
22259 31877 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 457 38th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1995 12:00:00 AM 2   Permit Number 35315 5984054.95538 2112747.63581 37.7802787535999 -122.498802308795 (37.7802787535999, -122.498802308795) 11 6 2 55 26
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
22945 250158 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2500 Lyon St 5 Side Yard : Yard Tree Private 2     7     5999254.28786 2117464.37854 37.7941094422474 -122.446560444632 (37.7941094422474, -122.446560444632) 13 9 1 57 27
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
24251 136053 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1101 Greenwich St 13 Front Yard : Yard Tree Private 2     4     6007566.05683 2119890.57017 37.8012424132723 -122.417972843093 (37.8012424132723, -122.417972843093) 5 1 1 28858 32
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
25428 238585 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 73 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6005403.58671 2103307.08135 37.7555862656019 -122.424275817175 (37.7555862656019, -122.424275817175) 2 4 5 28859 19
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
26148 250147 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 2 Front Yard : Yard Tree Private 2     7     5999210.3991 2117472.66602 37.7941296904761 -122.446712900392 (37.7941296904761, -122.446712900392) 11   1 57 30
26278 239005 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 250 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6005423.80449 2102247.03404 37.7526767636284 -122.424130513718 (37.7526767636284, -122.424130513718) 2 4 5 28859 19
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
29597 238598 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006428.46561 2107477.24993 37.7670943907258 -122.421027537902 (37.7670943907258, -122.421027537902) 8 4 7 28853 19
30391 239020 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 482 Hickory St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6004672.88732 2110370.92399 37.7749405996584 -122.427305970394 (37.7749405996584, -122.427305970394) 7 9 11 28852 10
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
33456 239029 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 26 Harry St 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   6003326.30087 2097748.91757 37.7402073325128 -122.431063031234 (37.7402073325128, -122.431063031234) 2 7 5 63 7
33567 249637 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2400 Lyon St 3 Side Yard : Yard Tree Private 2     7     5999297.09837 2117106.84322 37.7931301902456 -122.4463865832 (37.7931301902456, -122.4463865832) 13 9 1 57 27
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
36420 124156 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 970 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5995846.07339 2112226.83412 37.7795332890719 -122.457973944713 (37.7795332890719, -122.457973944713) 11 6 2 54 16
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
38537 249640 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2400 Lyon St 6 Side Yard : Yard Tree Private 2     7     5999291.59314 2117167.12216 37.79329538582 -122.446409970041 (37.79329538582, -122.446409970041) 13 9 1 57 27
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
43319 239004 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1299 York St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010075.23485 2101730.69719 37.751520546657 -122.40800856074 (37.751520546657, -122.40800856074) 2 4 7 28859 19
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
45234 202184 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1900 Armstrong Ave 4 Sidewalk: Property side : Yard Tree Private 2     6     6013198.98425 2093399.22832 37.7288184790723 -122.396622193069 (37.7288184790723, -122.396622193069) 10 3 8 58 1
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
51211 122964 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 98 09th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     10 Width 5ft   5993049.94359 2114912.63546 37.7867467201865 -122.467842267803 (37.7867467201865, -122.467842267803) 11 6 1 54 11
51859 238588 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1600 15th St 8 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006604.02075 2107329.38217 37.7666982753322 -122.420409821465 (37.7666982753322, -122.420409821465) 8 4 7 28853 19
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
52161 106889 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1040 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2014 12:00:00 AM 3   Permit Number 773355 6014125.23342 2106217.58962 37.7640665046851 -122.394317180299 (37.7640665046851, -122.394317180299) 14 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
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
56637 239007 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2801 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009827.40599 2104524.43186 37.7591776380486 -122.409062693893 (37.7591776380486, -122.409062693893) 2 4 7 28859 19
57531 250151 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 6 Front Yard : Yard Tree Private 2     6     5999220.87756 2117406.81737 37.7939494861264 -122.446671903881 (37.7939494861264, -122.446671903881) 11   1 57 30
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
59098 98408 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 24 19th Ave 2 Sidewalk: Curb side : Tree Private 2   02/09/2012 12:00:00 AM 3   Permit Number 768590 5989918.49451 2114923.36913 37.7865948726066 -122.478677005621 (37.7865948726066, -122.478677005621) 11 6 1 55 33
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
60025 124684 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3899 Jackson St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5995566.4285 2115772.64492 37.7892530636592 -122.459198183151 (37.7892530636592, -122.459198183151) 11 6 1 54 31
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
62806 52709 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1@ JACKSON Cherry St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM 8   Permit Number 48767 5996047.33493 2115997.05017 37.7898968555268 -122.457550557933 (37.7898968555268, -122.457550557933) 11   1 54 31
63461 213724 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x Santa Monica Way 8 Median : Yard Tree DPW 1     8     5993565.41473 2097500.59466 37.7389675657933 -122.46479394281 (37.7389675657933, -122.46479394281) 1 8 4 59 40
63795 124683 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3899 Jackson St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5995553.12452 2115771.60073 37.7892494317403 -122.459244137371 (37.7892494317403, -122.459244137371) 11 6 1 54 31
64185 52711 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1@ JACKSON Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM 5   Permit Number 48767 5996055.9612 2115990.01738 37.7898780408886 -122.457520202963 (37.7898780408886, -122.457520202963) 11   1 54 31
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
67120 249663 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 15 Front Yard : Yard Tree Private 2     9     5999240.36151 2117161.61527 37.7932773391397 -122.446586837907 (37.7932773391397, -122.446586837907) 11   1 57 30
67181 239028 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 26 Harry St 2 Sidewalk: Property side : Yard Tree Private 2     5     6003397.86036 2097787.1303 37.7403163105472 -122.430818333806 (37.7403163105472, -122.430818333806) 2 7 5 63 7
67698 249638 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2400 Lyon St 5 Side Yard : Yard Tree Private 2     11     5999293.71803 2117149.90797 37.7932482415769 -122.446401378842 (37.7932482415769, -122.446401378842) 13 9 1 57 27
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
70516 123029 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 730 Funston Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991968.39214 2110452.13533 37.7744368966539 -122.471259036935 (37.7744368966539, -122.471259036935) 11 6 2 54 11
75753 196539 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012100.68573 2106521.94936 37.7647894624906 -122.401340930463 (37.7647894624906, -122.401340930463) 14 3 8 28856 29
75784 82345 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 254 Dublin St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM 1 3x3 Permit Number 774176 6003940.30685 2088972.31262 37.7161435078943 -122.428314680584 (37.7161435078943, -122.428314680584) 9 7 6 28861 5
76440 136047 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 20 Cherry St 6 Sidewalk: Curb side : Yard Tree Private 2     6     5996079.9197 2115992.25742 37.7898855676012 -122.457437471381 (37.7898855676012, -122.457437471381) 11   1 54 31
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
77776 196541 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012133.24244 2106522.80627 37.7647936317506 -122.401228384779 (37.7647936317506, -122.401228384779) 14 3 8 28856 29
79306 136048 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 20 Cherry St 7 Sidewalk: Curb side : Yard Tree Private 2     8     5996075.48126 2116002.11474 37.7899123782026 -122.457453541344 (37.7899123782026, -122.457453541344) 11   1 54 31
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
80211 122200 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 171 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5991476.58631 2114290.78647 37.784948318391 -122.473240288339 (37.784948318391, -122.473240288339) 11 6 2 54 26
80849 238589 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1600 15th St 9 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006580.76101 2107327.1643 37.7666908748181 -122.420490115647 (37.7666908748181, -122.420490115647) 8 4 7 28853 19
80871 46546 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 637 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2002 12:00:00 AM     Permit Number 44689 6009489.66445837 2111279.62627541 37.7777069157879 -122.410707830593 (37.7777069157879, -122.410707830593) 8 2 9 28853 34
83042 123363 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 770 04th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5994763.50549 2110414.96281 37.7744961151162 -122.461587583233 (37.7744961151162, -122.461587583233) 11 6 2 54 11
83140 41607 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 3 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
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
84425 41604 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 2 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
84577 250155 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2500 Lyon St 2 Side Yard : Yard Tree Private 2     6     5999259.65981 2117410.03204 37.7939605280209 -122.446537945371 (37.7939605280209, -122.446537945371) 13 9 1 57 27
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
88103 250148 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 3 Front Yard : Yard Tree Private 2     6     5999211.58041 2117458.26171 37.7940902075462 -122.446707776048 (37.7940902075462, -122.446707776048) 11   1 57 30
88338 213729 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 150 Alton Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993589.16073 2101660.48807 37.7503909504883 -122.465013883688 (37.7503909504883, -122.465013883688) 1 8 4 29491 40
90085 136045 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2 Laurel St 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   5997979.66837 2116375.74786 37.7910474656235 -122.45089220822 (37.7910474656235, -122.45089220822) 13 6 1 54 31
90248 249642 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2460 Lyon St 2 Front Yard : Yard Tree Private 2     11     5999289.16084 2117209.34278 37.7934111735351 -122.446421424722 (37.7934111735351, -122.446421424722) 13 9 1 57 27
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
93507 114199 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1701x 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012227.07645 2106528.11077 37.7648134312296 -122.400904207967 (37.7648134312296, -122.400904207967) 14 3 8 28856 29
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

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