399 rows where qSpecies_id = 2 sorted by qAddress

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)
106231 96158 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767791 6003728 2095595 37.7343159198258 -122.429520547314 (37.7343159198258, -122.429520547314) 2 7 5 28861 25
14858 171814 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Dartmouth St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6008473.26376 2093533.30473 37.7289224829841 -122.412968858728 (37.7289224829841, -122.412968858728) 9 3 7 309 28
61373 88349 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183) 9 7 6 28861 5
72199 88350 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Vienna St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183) 9 7 6 28861 5
8200 3929 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100X Castro St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/18/2014 12:00:00 AM 3 4x4   6002188.32938 2107609.30269 37.7672170447484 -122.435702952048 (37.7672170447484, -122.435702952048) 15 5 5 28862 3
13136 255218 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 101 Goettingen St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
190892 93295 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1019 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004430 2102966 37.7545947138847 -122.427618485613 (37.7545947138847, -122.427618485613) 2 4 5 28862 22
43681 85727 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1025 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2007 12:00:00 AM 3 3x3   6010365 2111820 37.7792396944918 -122.40771784288 (37.7792396944918, -122.40771784288) 14 2 9 28853 34
171702 85728 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1025 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2007 12:00:00 AM 3 3x3   6010365 2111820 37.7792396944918 -122.40771784288 (37.7792396944918, -122.40771784288) 14 2 9 28853 34
19302 18446 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1036 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010478.12987 2103164.08177 37.7554788523745 -122.406716298816 (37.7554788523745, -122.406716298816) 10 4 7 28859 19
143258 93294 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1037 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004436 2102861 37.7543067479004 -122.427590255736 (37.7543067479004, -122.427590255736) 2 4 5 28862 22
136361 5577 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1041 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2010 12:00:00 AM 3 3x3   6005148.8764838 2102292.2742932 37.7527854561506 -122.425084482909 (37.7527854561506, -122.425084482909) 2 4 5 28859 19
74521 93293 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1049 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004440 2102791 37.7541147705659 -122.42757143594 (37.7541147705659, -122.42757143594) 2 4 5 28862 22
115917 85721 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1049 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 3x3   6010189 2111652 37.7787685519268 -122.408314849736 (37.7787685519268, -122.408314849736) 14 2 9 28853 34
7379 93250 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1050 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004388 2102776 37.7540706426955 -122.42775019598 (37.7540706426955, -122.42775019598) 2 4 5 28862 22
147253 93292 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1059 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004443 2102732 37.7539529400822 -122.427556858105 (37.7539529400822, -122.427556858105) 2 4 5 28862 22
116645 93251 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1060 CHURCH ST 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004371 2102721 37.7539186639277 -122.427805067459 (37.7539186639277, -122.427805067459) 2 4 5 28862 22
76153 93291 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1065 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004445 2102697 37.7538569514077 -122.427547448283 (37.7538569514077, -122.427547448283) 2 4 5 28862 22
52263 93252 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1070 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004394 2102659 37.7537497275294 -122.427721110855 (37.7537497275294, -122.427721110855) 2 4 5 28862 22
95178 93253 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1070 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004394 2102659 37.7537497275294 -122.427721110855 (37.7537497275294, -122.427721110855) 2 4 5 28862 22
105243 93254 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1070 Church St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004394 2102659 37.7537497275294 -122.427721110855 (37.7537497275294, -122.427721110855) 2 4 5 28862 22
139198 93255 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1070 Church St 4 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004394 2102659 37.7537497275294 -122.427721110855 (37.7537497275294, -122.427721110855) 2 4 5 28862 22
139333 93290 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1071 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004519 2102665.5 37.7537746450798 -122.427289295317 (37.7537746450798, -122.427289295317) 2 4 5 28862 22
65551 104727 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1079 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3 Permit Number 770313 6004450 2102615 37.7536320814231 -122.427524315639 (37.7536320814231, -122.427524315639) 2 4 5 28862 22
30278 10232 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 11 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/30/2002 12:00:00 AM 8     6005984.55063 2109644.68395 37.7730206127534 -122.422717019597 (37.7730206127534, -122.422717019597) 7 9 11 28852 10
175044 230378 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 11 Haight St 3 : Tree Private 2     5 Width 4ft   6006027.69558 2109650.1201 37.7730379732539 -122.422568162015 (37.7730379732539, -122.422568162015) 7 9 11 28852 10
180205 230377 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 11 Haight St 2 : Tree Private 2     6 Width 4ft   6006012.13878 2109648.33208 37.7730321861234 -122.422621847921 (37.7730321861234, -122.422621847921) 7 9 11 28852 10
20501 103817 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1100 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006925.9 2114751.5 37.7870957589339 -122.41982320605 (37.7870957589339, -122.41982320605) 13 9 10 28858 21
88054 29774 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1100X Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2017 12:44:00 PM 3 3x3   6018183.3236 2096672.8034 37.7380832156692 -122.379618142779 (37.7380832156692, -122.379618142779) 10 3 8 58 1
88606 85598 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1101 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/08/2014 12:00:00 AM 3 3x3   6017523.881587 2093256.051678 37.7286650962772 -122.381660625783 (37.7286650962772, -122.381660625783) 10 3 8 58 1
168373 85597 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1101 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 6 3x3   6017523.881587 2093256.051678 37.7286650962772 -122.381660625783 (37.7286650962772, -122.381660625783) 10 3 8 58 1
3150 85599 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1115 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2014 12:00:00 AM 3 3x3   6017434.0078 2093308.576 37.7288043549368 -122.381974980078 (37.7288043549368, -122.381974980078) 10 3 8 58 1
121444 93256 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1120 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3 Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted 6004410 2102371 37.7529598520175 -122.427645261537 (37.7529598520175, -122.427645261537) 2 4 5 28862 22
143361 4421 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1133 Church St 3 Sidewalk: Curb side : Cutout Tree DPW 1   08/23/2012 12:00:00 AM 3 4X4 Permit Number 769145 6004474.71062 2102295.4201 37.7527559874039 -122.427416096072 (37.7527559874039, -122.427416096072) 2 4 5 28862 22
113947 85720 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1133 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 3x3   6009666.355548 2111144.506481 37.777345813652 -122.410087051507 (37.777345813652, -122.410087051507) 8 2 9 28853 34
144023 100465 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1140 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010498.9 2102571.5 37.7538529165301 -122.40660271212 (37.7538529165301, -122.40660271212) 10 4 7 28859 19
29186 85712 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1144 Howard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6009550 2111081 37.7771649174601 -122.410485079371 (37.7771649174601, -122.410485079371) 8 2 9 28853 34
101456 88442 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1148 Treat Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/11/2008 12:00:00 AM   3x3 Permit Number 51406 6008612.9 2101850.1 37.7517664174328 -122.413073954345 (37.7517664174328, -122.413073954345) 2 4 7 28859 19
19434 242839 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1151 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/12/2016 05:27:00 AM 0 7x7   6005182.83568 2101610.74761 37.7509160601321 -122.424918561756 (37.7509160601321, -122.424918561756) 2 4 5 28859 19
184649 93289 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1159 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004476 2102138 37.7523238215074 -122.427400423827 (37.7523238215074, -122.427400423827) 2 4 5 28862 22
179089 85719 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1175 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 3x3   6009405 2110901 37.7766625499179 -122.410973965657 (37.7766625499179, -122.410973965657) 8 2 9 28853 34
89747 93258 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1180X Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004390.8 2101994.4 37.7519247103798 -122.427684828837 (37.7519247103798, -122.427684828837) 2 4 5 28862 22
99625 93257 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1180X Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004390.8 2101994.4 37.7519247103798 -122.427684828837 (37.7519247103798, -122.427684828837) 2 4 5 28862 22
84232 6725 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1200X Fairfax Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2008 12:00:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
1822 51694 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1205 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2005 12:00:00 AM     Permit Number 47971 5995825.9822194 2092036.11859211 37.7240935095077 -122.456582925823 (37.7240935095077, -122.456582925823) 9 8 4 28861 40
21135 102590 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1205 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47971 5995820 2092088.8 37.724237816628 -122.4566074133 (37.724237816628, -122.4566074133) 9 7 4 28861 40
100917 103792 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1214 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
105898 103793 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1214 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
138526 103794 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1214 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
188352 103791 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1214 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006878.4 2115091.6 37.7880269138329 -122.420011690177 (37.7880269138329, -122.420011690177) 13 9 10 28858 21
63030 251164 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1215 Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2017 01:46:00 PM 3 3x3   6017471 2096747 37.7382476302403 -122.382086185189 (37.7382476302403, -122.382086185189) 10 3 8 58 1
77180 248912 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1215 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6017471 2096747 37.7382476302403 -122.382086185189 (37.7382476302403, -122.382086185189) 10 3 8 58 1
98656 93259 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1234 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004459 2101704 37.7511311972424 -122.427428297659 (37.7511311972424, -122.427428297659) 2 4 5 28862 22
189245 52671 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1234@ LINCOLN 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53911 5993637.83557736 2107090.14039952 37.7653021756316 -122.465239907967 (37.7653021756316, -122.465239907967) 11 8 11 56 12
77573 93260 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1250X Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004401.7 2101569.1 37.7507575523117 -122.427616837084 (37.7507575523117, -122.427616837084) 2 4 5 28862 22
104815 93261 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1252 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004465 2101602 37.7508514683439 -122.427400283526 (37.7508514683439, -122.427400283526) 2 4 5 28862 22
58550 93288 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1259 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004494 2101568 37.7507597523824 -122.427297577126 (37.7507597523824, -122.427297577126) 2 4 5 28862 22
28398 230376 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 126 Dolores St 1 : Tree Private 2     4 Width 3ft   6004756.55794 2107626.00234 37.7674084411732 -122.426821010098 (37.7674084411732, -122.426821010098) 8 4 5 28862 3
129033 85569 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1260 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.519633 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139) 10 3 8 58 1
177837 85570 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1260 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016711.517151 2093911.519633 37.7304199931233 -122.384514682139 (37.7304199931233, -122.384514682139) 10 3 8 58 1
38684 85604 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1261 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016687.610646 2093879.449725 37.7303306134548 -122.384595098105 (37.7303306134548, -122.384595098105) 10 3 8 58 1
147657 85568 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1264 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016691.22613 2093926.645569 37.7304604038472 -122.384585884949 (37.7304604038472, -122.384585884949) 10 3 8 58 1
181273 84852 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1266 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2007 12:00:00 AM     Permit No. 49294 6005132 2100972 37.7491593351889 -122.425048913935 (37.7491593351889, -122.425048913935) 2 4 5 28862 22
1519 154406 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1270 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/2019 12:00:00 AM 3 4x4 Permit Number 782729 6004450.91353 2101490.17776 37.7505436337949 -122.427441030576 (37.7505436337949, -122.427441030576) 2 4 5 28862 22
89302 85567 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1274 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016640.49857 2093964.460415 37.7305614304838 -122.384763892339 (37.7305614304838, -122.384763892339) 10 3 8 58 1
9624 6769 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1275 Fairfax Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2007 12:00:00 AM 3 3x3   6017217.4089567 2096970.3613046 37.7388469269577 -122.382978527185 (37.7388469269577, -122.382978527185) 10 3 8 58 1
185603 85565 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1276 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016630.35305 2093972.02339 37.7305816357941 -122.384799493903 (37.7305816357941, -122.384799493903) 10 3 8 58 1
140577 93287 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1279 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004501 2101449 37.7504334019421 -122.427264894728 (37.7504334019421, -122.427264894728) 2 4 5 28862 22
52463 93286 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1283 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004502 2101425 37.7503675600759 -122.427259727267 (37.7503675600759, -122.427259727267) 2 4 5 28862 22
135595 93285 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1289 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004504 2101389 37.7502688255514 -122.427250247058 (37.7502688255514, -122.427250247058) 2 4 5 28862 22
83634 109258 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1290 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773444 5982171 2106334.4 37.7625591927486 -122.504844313965 (37.7625591927486, -122.504844313965) 1 8 3 56 35
183063 18480 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1298 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/31/2017 01:20:00 PM 3 3x3   6010561.39126 2101710.28558 37.7514917080909 -122.406325925618 (37.7514917080909, -122.406325925618) 10 4 7 28859 19
3079 203064 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300 Evans Ave 34 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/2017 01:07:00 PM 3 Width 3ft   6017493.20317 2097219.31473 37.7395457381522 -122.382042262644 (37.7395457381522, -122.382042262644) 10 3 8 58 1
101381 188685 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300 Evans Ave 14 : Tree DPW 1   04/10/2017 01:01:00 PM 3 Width 3ft   6017863.85792 2096944.20177 37.7388107959886 -122.380741566863 (37.7388107959886, -122.380741566863) 10 3 8 58 1
135674 188687 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300 Evans Ave 30 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/2017 12:53:00 PM 3 Width 4ft   6017556.40659 2097171.27575 37.7394173230594 -122.381820390005 (37.7394173230594, -122.381820390005) 10 3 8 58 1
180775 197655 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6016998.37545 2097206.43045 37.7394830203258 -122.383752282143 (37.7394830203258, -122.383752282143) 10 3 8 58 1
151153 6746 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1300X Fairfax Ave 16 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2007 12:00:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
17740 96032 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1314 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767671 6007241 2115796 37.7899814452739 -122.418807131377 (37.7899814452739, -122.418807131377) 13 9 10 28858 21
22004 93263 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1326 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004490 2101167 37.7496584733742 -122.427282847994 (37.7496584733742, -122.427282847994) 2 4 5 28862 22
38042 93264 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1326 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004490 2101167 37.7496584733742 -122.427282847994 (37.7496584733742, -122.427282847994) 2 4 5 28862 22
3529 79630 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1331 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6011736.35903 2102141.72528 37.7527420040406 -122.402293051689 (37.7527420040406, -122.402293051689) 10 3 8 28856 29
44915 103874 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1331 Polk St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006716.3 2115545.2 37.7892632533111 -122.42060474069 (37.7892632533111, -122.42060474069) 13 9 10 28858 21
77056 251288 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1335 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/18/2017 01:58:00 PM 3 3x3   6016828 2097292 37.7397085577181 -122.384347329812 (37.7397085577181, -122.384347329812) 10 3 8 58 1
59431 85827 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1345 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2007 12:00:00 AM 3 3x3   6008580 2110114 37.7744553372704 -122.413772211324 (37.7744553372704, -122.413772211324) 8 2 9 28853 34
97145 93284 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1347 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004523 2101050 37.7493390847523 -122.427160399995 (37.7493390847523, -122.427160399995) 2 4 5 28862 22
142124 88687 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 135 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2008 12:00:00 AM     Permit Number 51638 6003417 2105051 37.7602622759886 -122.431270527939 (37.7602622759886, -122.431270527939) 2 4 5 28862 3
109523 108761 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1350 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3 3x3 Permit Number 774645 6004491.73804 2101024.57628 37.7492675091862 -122.427266693799 (37.7492675091862, -122.427266693799) 2 4 5 28862 22
131390 108760 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1350 Church St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6004491.73804 2101024.57628 37.7492675091862 -122.427266693799 (37.7492675091862, -122.427266693799) 2 4 5 28862 22
191699 9298 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 135X Mansell St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/10/1992 12:00:00 AM 3 3X3   6011497.3933158 2090592.5284866 37.7210170109869 -122.40230748066 (37.7210170109869, -122.40230748066) 10 7 8 309 28
72148 6787 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1360 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   01/03/2017 06:55:00 AM 3 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
105367 6784 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1360 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2007 12:00:00 AM 4 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
41844 108873 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 137 Cole St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773403 5997771.92218 2110131.23662 37.7738897825389 -122.451160475717 (37.7738897825389, -122.451160475717) 15 5 11 29492 16
176520 85577 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1370 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016127.199744 2094347.098919 37.73158367729 -122.386565129485 (37.73158367729, -122.386565129485) 10 3 8 58 1
177200 94896 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1375 Keith St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53955 6016208.4 2094705 37.7325708970962 -122.386309345138 (37.7325708970962, -122.386309345138) 10 3 8 58 1
118417 93283 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1377 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004533 2100877 37.7488646323576 -122.427113499044 (37.7488646323576, -122.427113499044) 2 4 5 28862 22
13050 108392 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1382 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773801 6011141.7607 2101910.8917 37.7520749768049 -122.404333044887 (37.7520749768049, -122.404333044887) 10 4 8 28859 19
96836 93282 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1383 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004535 2100841 37.7487658977962 -122.427104019222 (37.7487658977962, -122.427104019222) 2 4 5 28862 22
86673 85578 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1388 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6016034.726363 2094416.033185 37.7317678372886 -122.386889636739 (37.7317678372886, -122.386889636739) 10 3 8 58 1
160902 85607 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1397 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015969.720597 2094414.600713 37.7317603044799 -122.387114277117 (37.7317603044799, -122.387114277117) 10 3 8 58 1
29881 85825 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1399X Howard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/2007 12:00:00 AM 3 3x3   6008422.422874 2109956.642426 37.7740144201285 -122.414306166437 (37.7740144201285, -122.414306166437) 8 2 9 28853 34

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