305 rows where qSpecies_id = 49 sorted by PermitNotes 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)
4238 193153 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 33 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2020 12:00:00 AM 3 Width 2ft Permit Number 785449 6013826.51313 2114547.38647 37.7869216386586 -122.395934124458 (37.7869216386586, -122.395934124458) 6 2 9 28855 6
78395 132020 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1028 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2018 12:00:00 AM 3 Width 3ft Permit Number 782077 6007946.58222 2119968.79133 37.8014785977268 -122.416661599167 (37.8014785977268, -122.416661599167) 5 1 10 308 32
56180 255527 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 730 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782016 6003494.63141 2110038.24994 37.7739604525435 -122.431358054188 (37.7739604525435, -122.431358054188) 15 9 11 29492 10
15309 16874 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 269 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781998 6005705.9301 2110300.3269 37.7748051262311 -122.423727430112 (37.7748051262311, -122.423727430112) 7 9 11 28852 10
132572 54713 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2701 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2018 12:00:00 AM 3   Permit Number 781936 6001165.76206 2116883.2589 37.7926228359235 -122.43990487064 (37.7926228359235, -122.43990487064) 13 6 1 29490 27
47719 108874 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 138 Cole St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2018 12:00:00 AM 3 3x3 Permit Number 781829 5997812.45112 2110130.24113 37.773889369558 -122.451020208331 (37.773889369558, -122.451020208331) 15 5 11 29492 16
27287 255049 Planning Code 138.1 required 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 925 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2018 12:00:00 AM 3 3x3 Permit Number 779631 6009075.60356 2091383.60862 37.7230536656288 -122.410734764023 (37.7230536656288, -122.410734764023) 9 3 7 309 28
104688 117301 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2238 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778520 5985801.3 2099978.9 37.7453216318219 -122.491820695636 (37.7453216318219, -122.491820695636) 1 8 3 29491 35
151715 117300 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2238 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778520 5985801.3 2099978.9 37.7453216318219 -122.491820695636 (37.7453216318219, -122.491820695636) 1 8 3 29491 35
96348 115319 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 86 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3   Permit Number 777439 6000946.9 2101238.5 37.7496537815844 -122.439540113547 (37.7496537815844, -122.439540113547) 2 4 5 28862 22
29129 34304 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1248 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2016 12:00:00 AM     Permit Number 777415 6010821.325282 2102511.88817286 37.7537072691799 -122.405483487001 (37.7537072691799, -122.405483487001) 10 4 8 28859 19
121448 115375 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 230 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 776301 6007067.3 2096865.5 37.7379929380378 -122.418065521541 (37.7379929380378, -122.418065521541) 2 7 7 28859 2
139355 114987 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 157 Thrift St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2015 12:00:00 AM     Permit Number 775985 5995400.7 2089591.3 37.7173561925503 -122.457876217939 (37.7173561925503, -122.457876217939) 9 8 6 28861 24
139324 115273 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1314 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775588 5985278.7 2106245.9 37.7624985311794 -122.49408954164 (37.7624985311794, -122.49408954164) 1 8 3 56 35
102625 52820 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2850@ ANZA Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2018 12:00:00 PM 3   Permit Number 775537 5989777.02787 2111978.29339 37.778500303461 -122.478950948669 (37.778500303461, -122.478950948669) 11 6 2 55 26
146964 52821 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2850@ ANZA Anza St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2018 12:32:00 PM 3   Permit Number 775537 5989762.54787 2111977.16007 37.7784963508186 -122.479000957003 (37.7784963508186, -122.479000957003) 11 6 2 55 26
77890 115285 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 32 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2016 12:00:00 AM     Permit Number 775365 6004721.1 2096171.8 37.7359558621574 -122.426128127271 (37.7359558621574, -122.426128127271) 2 7 5 28861 2
74860 39178 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1050 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2015 12:00:00 AM 3 4x4 Permit Number 775243 6007589.88726975 2103539.15878969 37.7563467058962 -122.416731326975 (37.7563467058962, -122.416731326975) 2 4 7 28859 19
133579 39177 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1050 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2015 12:00:00 AM 3 4x4 Permit Number 775243 6007589.88726975 2103539.15878969 37.7563467058962 -122.416731326975 (37.7563467058962, -122.416731326975) 2 4 7 28859 19
90449 115264 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1634 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775141 5989384.4 2104210.4 37.7571489820097 -122.479740639367 (37.7571489820097, -122.479740639367) 1 8 3 56 35
115784 115265 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1634 22nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775141 5989384.4 2104210.4 37.7571489820097 -122.479740639367 (37.7571489820097, -122.479740639367) 1 8 3 56 35
7720 109781 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1335 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775057 5991737.5 2106325 37.7630915327801 -122.471756892939 (37.7630915327801, -122.471756892939) 1 8 11 56 12
60765 109580 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 822 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2017 10:16:00 AM 3 3x3 Permit Number 775019 6004058.45374 2090883.76652 37.7213986270377 -122.428042443214 (37.7213986270377, -122.428042443214) 9 7 6 28861 5
155215 109566 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 56 Seneca Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/2015 12:00:00 AM 3 3x3 Permit Number 775012 6000375.8 2089821 37.7182714712375 -122.440696127295 (37.7182714712375, -122.440696127295) 9 7 6 28861 25
3337 261748 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 16 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
11461 261747 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 15 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
15024 261746 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 14 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
185606 43588 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2014 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/21/2015 12:00:00 AM 0   Permit Number 774769 5986972.77982158 2101544.10082167 37.7496876538817 -122.48788494443 (37.7496876538817, -122.48788494443) 1 8 3 29491 35
160733 108628 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 741 Ellis St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774600 6007319.99858 2113650.90643 37.7840959912819 -122.418381641984 (37.7840959912819, -122.418381641984) 7 9 9 28858 36
42298 108621 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 150-198X Webster St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3   Permit Number 774592 6005405 2109611 37.7728954095296 -122.424719362301 (37.7728954095296, -122.424719362301) 7 9 11 28852 10
149431 18474 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1260 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3 0 Permit Number 773798 6010545.83787 2101980.95756 37.7522340435672 -122.406398781502 (37.7522340435672, -122.406398781502) 10 4 7 28859 19
7799 112881 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 634 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2015 12:00:00 AM     Permit Number 773545 5985072.5 2111537.7 37.7770162467569 -122.495192953952 (37.7770162467569, -122.495192953952) 11 6 2 55 26
174483 108870 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 636 Lyon St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773421 6000111.40758 2111064.83155 37.7765868652264 -122.443134899814 (37.7765868652264, -122.443134899814) 15 5 11 29492 16
104437 106758 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 445 Grafton Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/02/2014 12:00:00 AM     Permit Number 772911 5995409.1 2090523.2 37.7199154518997 -122.457914582927 (37.7199154518997, -122.457914582927) 9 8 6 28861 24
89203 108393 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 321 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2014 12:00:00 AM 3 3x3 Permit Number 772685 6006734.79675 2104244.32387 37.7582347949878 -122.419738566409 (37.7582347949878, -122.419738566409) 2 4 7 28859 19
47271 106182 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 26 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2014 12:00:00 AM 9   Permit Number 772520 5996564.2 2114395.4 37.7855288291914 -122.455646443632 (37.7855288291914, -122.455646443632) 11 6 1 54 31
175364 115252 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 438 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 772344 5995084 2088641.7 37.7147306151804 -122.458902180491 (37.7147306151804, -122.458902180491) 9 8 6 28861 24
143429 108627 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 223 Douglass St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772318 6001122.48631 2104986.51759 37.7599549235553 -122.439201532761 (37.7599549235553, -122.439201532761) 2 4 5 28862 3
192201 84013 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 207 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM   3x3 Permit Number 771913 5997093.91103174 2089409.10522836 37.7169530610701 -122.452010468882 (37.7169530610701, -122.452010468882) 9 8 6 28861 24
81653 109448 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 143 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/18/2015 12:00:00 AM 3 3x3 Permit Number 770854 6005451.2 2102876.8 37.7544075015735 -122.424080557223 (37.7544075015735, -122.424080557223) 2 4 5 28859 19
148083 104967 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 143-147 FAIR OAKS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3 Permit Number 770854 6005451.2 2102876.8 37.7544075015735 -122.424080557223 (37.7544075015735, -122.424080557223) 2 4 5 28859 19
73814 99874 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1301X San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/2011 12:00:00 AM 3 3x3 Permit Number 770597 6003616.3 2095455.7 37.7339271085192 -122.429896797189 (37.7339271085192, -122.429896797189) 2 7 5 28861 25
156269 8129 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 899 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2013 12:00:00 AM 12 3X3 Permit Number 770378 6003470.39544 2111382.10126 37.7776489625125 -122.431537848369 (37.7776489625125, -122.431537848369) 7 9 11 29492 10
174012 101369 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2007 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2012 12:00:00 AM 12 3x3 Permit Number 769245 5999888.5 2111553 37.7779145386147 -122.443941082049 (37.7779145386147, -122.443941082049) 15 5 11 29490 16
32707 100007 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 3 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
35004 100003 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 2 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
52174 99998 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 1 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013420 2115433 37.7893307029327 -122.397402707509 (37.7893307029327, -122.397402707509) 12 2 9 28855 6
88404 100008 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 4 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
109946 64806 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1375 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2012 12:00:00 AM 22 5x5 Permit Number 768180 6003293.30156995 2100236.74825313 37.747036468941 -122.43135467592 (37.747036468941, -122.43135467592) 2 7 5 63 22
187255 54682 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1212 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2011 12:00:00 AM     Permit Number 767886 5993014.13432891 2107214.38358529 37.7656073275163 -122.467406160634 (37.7656073275163, -122.467406160634) 11 8 11 56 12
192982 96632 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1212 10th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2011 12:00:00 AM     Permit Number 767886 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359) 11 8 11 56 12
21662 81651 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1100@ 12th Ave Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6   Permit Number 767881 5992197.33713 2110704.35062 37.7751426520596 -122.470485452724 (37.7751426520596, -122.470485452724) 11 6 2 54 11
31727 45656 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2011 12:00:00 AM     Permit Number 767754 5994244 2106639 37.7640983993107 -122.463110607355 (37.7640983993107, -122.463110607355) 1 5 11 56 12
103176 54058 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2011 12:00:00 AM     Permit Number 767754 5994238.69785688 2106641.55496777 37.7641051091536 -122.463129131181 (37.7641051091536, -122.463129131181) 1 5 11 56 12
167902 45655 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2011 12:00:00 AM     Permit Number 767754 5994244 2106639 37.7640983993107 -122.463110607355 (37.7640983993107, -122.463110607355) 1 5 11 56 12
188069 95808 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 974 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/2011 12:00:00 AM 3 3x3 Permit Number 767552 6011863.56882 2103875.82821 37.7575105701687 -122.401975028944 (37.7575105701687, -122.401975028944) 10 3 8 28856 29
49718 93670 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 12 Robblee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2011 12:00:00 AM 1 3x3 Permit Number 54071 6012650.87025 2095997.96753 37.7359235585191 -122.398699370703 (37.7359235585191, -122.398699370703) 10 3 8 58 1
134063 62821 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 165 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2010 12:00:00 AM   3x3 Permit Number 53769 6004060.48554268 2101568.78877881 37.7507373914484 -122.42879676445 (37.7507373914484, -122.42879676445) 2 4 5 28862 22
155192 50070 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 178 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53758 6003140.05481803 2105079.35140699 37.7603244234929 -122.432230375273 (37.7603244234929, -122.432230375273) 2 4 5 28862 3
189972 17872 Section 143 10 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2148 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.7883334451781 -122.431177809024 (37.7883334451781, -122.431177809024) 13 9 1 29490 27
129187 94327 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1132 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2010 12:00:00 AM   3x3 Permit Number 53627 5995101.4 2091446 37.7224315574184 -122.459044970295 (37.7224315574184, -122.459044970295) 9 8 4 28861 24
191716 56557 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 27 Ardenwood Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/2010 12:00:00 AM     Permit Number 53358 5991301.89931547 2096270.47961182 37.7354592201324 -122.472530401662 (37.7354592201324, -122.472530401662) 1 8 4 29491 40
73843 93629 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 251 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2010 12:00:00 AM   3x3 Permit Number 53264 5985797 2114222 37.7844289534299 -122.492884487425 (37.7844289534299, -122.492884487425) 11 6 1 55 33
185674 82560 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 832 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52208 6009084.37207289 2104307.27777207 37.7585397298832 -122.411617128308 (37.7585397298832, -122.411617128308) 2 4 7 28859 19
144083 88518 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 133 Kenwood Way   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51449 5994469.5 2093573.6 37.7282370866894 -122.46138344933 (37.7282370866894, -122.46138344933) 9 8 4 59 40
193859 84342 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1153 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM 3 3x3 Permit Number 50832 6005241.68146 2120923.06914 37.8039462987346 -122.426089751557 (37.8039462987346, -122.426089751557) 13 9 1 28858 17
54675 87806 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 291 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 3 3x12 Permit Number 50584 5987096.8 2114028.5 37.7839735823988 -122.48837346173 (37.7839735823988, -122.48837346173) 11 6 1 55 33
60679 87807 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 291 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 3 3x3 Permit Number 50584 5987096.8 2114028.5 37.7839735823988 -122.48837346173 (37.7839735823988, -122.48837346173) 11 6 1 55 33
666 49628 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1591 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 3   Permit Number 46483 6007746.40275 2109230.16933 37.7719816997133 -122.416593168865 (37.7719816997133, -122.416593168865) 8 2 9 28853 19
7352 49629 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1591 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 3   Permit Number 46483 6007726.58715 2109200.55407 37.7718992687552 -122.416659614369 (37.7718992687552, -122.416659614369) 8 2 9 28853 19
6816 46977 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1310 Minnesota St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM 2   Permit Number 44998 6015323.66021 2102361.18474 37.7535441867291 -122.389902741142 (37.7535441867291, -122.389902741142) 10 3 8 28856 29
126697 46981 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1310 Minnesota St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM 1   Permit Number 44998 6015319.9852 2102418.03165 37.7537000725041 -122.389919420856 (37.7537000725041, -122.389919420856) 10 3 8 28856 29
175179 46980 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1310 Minnesota St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM 2   Permit Number 44998 6015320.43653 2102435.84562 37.7537490109239 -122.389919104308 (37.7537490109239, -122.389919104308) 10 3 8 28856 29
49816 46416 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 700 Illinois St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2002 12:00:00 AM 5 3x3 Permit Number 44641 6015974.86179 2105759.18936 37.7629104774528 -122.387887811877 (37.7629104774528, -122.387887811877) 10 3 8 28856 29
143820 46415 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 700 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2002 12:00:00 AM 5 3x3 Permit Number 44641 6015975.28241 2105780.03754 37.7629677453768 -122.3878878119 (37.7629677453768, -122.3878878119) 10 3 8 28856 29
136676 43256 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 400 Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/12/2000 12:00:00 AM 5   Permit Number 43041 6010098.35132 2093185.30376 37.7280580348411 -122.407326264919 (37.7280580348411, -122.407326264919) 10 3 7 309 28
100823 37947 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 255 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 8   Permit Number 40187 6013212.35398 2105880.56458 37.7630903220716 -122.39745094713 (37.7630903220716, -122.39745094713) 14 3 8 28856 29
192615 37946 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 255 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40187 6013211.43951 2105863.92108 37.7630445717758 -122.397452942701 (37.7630445717758, -122.397452942701) 14 3 8 28856 29
42544 37824 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 450X Moscow St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003906.75378 2090460.71651 37.7202284408775 -122.428536688136 (37.7202284408775, -122.428536688136) 9 7 6 28861 5
49364 35383 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 557 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 6   Permit Number 38839 6011254.22436 2105785.28099 37.7627194740588 -122.4042167852 (37.7627194740588, -122.4042167852) 8 3 8 28856 29
128026 35331 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2222 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 7   Permit Number 38797 6011102.74031 2105580.11017 37.7621476554073 -122.404726272704 (37.7621476554073, -122.404726272704) 8 3 8 28856 29
82789 67599 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 380 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1992 12:00:00 AM 5   Permit Number 31168 6014306.36915 2105365.66412 37.7617373703071 -122.393631049748 (37.7617373703071, -122.393631049748) 10 3 8 28856 29
69262 58794 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 2 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1979 12:00:00 AM     Permit Number 18041 6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
79191 55909 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 3020 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3   Permit Number 11967 5986171.45599 2111171.12387 37.7760740114518 -122.491364390312 (37.7760740114518, -122.491364390312) 11 6 2 55 26
102 258152 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
979 171867 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 825 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 Width 3ft   6009309.97305 2091452.93347 37.7232571551673 -122.409929483882 (37.7232571551673, -122.409929483882) 9 3 7 309 28
1355 172161 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 224 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6010825.0191 2091483.87945 37.7234269210881 -122.404694409734 (37.7234269210881, -122.404694409734) 10 3 7 309 28
2615 193428 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1151 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6014491.22334 2103857.32403 37.7576060646987 -122.392886177259 (37.7576060646987, -122.392886177259) 10 3 8 28856 29
2698 216704 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 251 Faxon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2017 08:35:00 AM 3 Width 2ft   5994715.27121 2090263.18688 37.7191616308917 -122.460294062627 (37.7191616308917, -122.460294062627) 9 8 6 28861 24
2951 258117 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 601 Brussels St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010889.02957 2091945.92933 37.724699191929 -122.404505645081 (37.724699191929, -122.404505645081) 10 3 7 309 28
3314 193435 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 600 Missouri St 1 : Tree Private 2     7 Width 3ft   6013537.44197 2104295.86136 37.7587571690323 -122.396215498963 (37.7587571690323, -122.396215498963) 10 3 8 28856 29
3354 258363 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 526 Silliman St   Sidewalk: Property side : Cutout Tree DPW 1 FUF     4x5   6009244.29167 2093882.64592 37.7299249505577 -122.410328004922 (37.7299249505577, -122.410328004922) 9 3 7 309 28
3543 258123 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 601 Brussels St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010889.02957 2091945.92933 37.724699191929 -122.404505645081 (37.724699191929, -122.404505645081) 10 3 7 309 28
3712 171727 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1151 Silliman St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   0 4x5   6007391.28997 2093272.37114 37.7281452205055 -122.416690852302 (37.7281452205055, -122.416690852302) 9 3 7 309 5
3719 258151 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 500X Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
3933 258362 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 520 Silliman St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF     4x5   6009260.75409 2093887.69259 37.7299397304564 -122.410271448334 (37.7299397304564, -122.410271448334) 9 3 7 309 28
5082 258116 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2245 Jones St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6008057.63672 2120117.2159 37.8018923796488 -122.416287818099 (37.8018923796488, -122.416287818099) 5 1 10 308 32
5303 254848 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 914 Central Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x5   5999583 2111627 37.7781002923949 -122.445003231417 (37.7781002923949, -122.445003231417) 15 5 11 29490 16
5799 29248 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 470X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 3X3   6010243.1599 2097486.61497 37.7398766239144 -122.40712872252 (37.7398766239144, -122.40712872252) 10 3 7 58 2
6295 258118 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 601 Brussels St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010889.02957 2091945.92933 37.724699191929 -122.404505645081 (37.724699191929, -122.404505645081) 10 3 7 309 28

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