399 rows where qSpecies_id = 2 sorted by qCaretaker_id

View and edit SQL

Supervisor Districts

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)
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
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
119339 96670 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1425 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2012 12:00:00 AM 4 4x4   6015007.7446 2095379.2401 37.7343556918302 -122.390507431087 (37.7343556918302, -122.390507431087) 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
121808 5355 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 214 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/03/2009 12:00:00 AM 3 6   6004795.29962 2107076.64131 37.7659022179413 -122.426647883401 (37.7659022179413, -122.426647883401) 8 4 5 28862 3
122477 93276 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1603 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004604 2099562 37.7452579604553 -122.426774346316 (37.7452579604553, -122.426774346316) 2 7 5 63 22
125882 9308 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 240X Mansell St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2007 12:00:00 AM 3 3X100   6011154.1519898 2090628.8663314 37.7210976210121 -122.403496526224 (37.7210976210121, -122.403496526224) 10 3 7 309 28
127073 85583 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1500 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015418.292964 2094875.921588 37.7329964475839 -122.389052889382 (37.7329964475839, -122.389052889382) 10 3 8 58 1
128455 93274 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1613 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004607 2099503 37.7450961296299 -122.426759771954 (37.7450961296299, -122.426759771954) 2 7 5 63 22
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
129205 103834 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.07623 2113939.67696 37.7848568419422 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
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
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
136291 5477 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6005026.79294 2104432.16218 37.7586541903676 -122.425658960999 (37.7586541903676, -122.425658960999) 2 4 5 28859 19
138694 85696 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.7861224301769 -122.399185316932 (37.7861224301769, -122.399185316932) 12 2 9 28855 6
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
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
140650 26918 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2000X Bay Shore Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1   10/19/2010 12:00:00 AM 3 3X3   6012375.8565272 2088505.2474917 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859) 10 7 8 309 39
142517 93280 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1485 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004568 2100246 37.7471340314151 -122.426947534581 (37.7471340314151, -122.426947534581) 2 7 5 63 22
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
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
144650 85708 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 964 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6010738 2112218 37.7803533827236 -122.406455527485 (37.7803533827236, -122.406455527485) 14 2 9 28853 34
144661 5385 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 325X Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/2013 12:00:00 AM   4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
144860 10236 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 33 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/30/2002 12:00:00 AM 8 4X4   6005944.57875 2109639.18298 37.7730032531225 -122.422854896447 (37.7730032531225, -122.422854896447) 7 9 11 28852 10
146908 103849 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
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
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
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
153331 18361 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 530 Potrero Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   06/02/2015 11:39:00 AM 3 3x3   6010330.8079075 2105828.5872592 37.7627867420622 -122.407413622665 (37.7627867420622, -122.407413622665) 8 4 8 28859 19
154650 11953 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1436 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/27/2007 12:00:00 AM 6 3X4   6015854.7568499 2096315.1604747 37.7369724919298 -122.387644284768 (37.7369724919298, -122.387644284768) 10 3 8 58 1
155368 93268 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1574 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/29/2015 05:47:00 AM 3 3x3   6004569 2099722 37.7456953047191 -122.42690676352 (37.7456953047191, -122.42690676352) 2 7 5 63 22
157770 5356 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 220 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/2015 03:17:00 PM 3 6x6 posted for removal 3/27/14 DPW 6004796.95819 2107043.90776 37.7658124332187 -122.426639815582 (37.7658124332187, -122.426639815582) 8 4 5 28862 3
158563 103862 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1436 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006766.2 2115894.4 37.7902248822442 -122.420456889097 (37.7902248822442, -122.420456889097) 13 9 10 28858 21
160107 85560 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 980 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6018187.977749 2092810.892369 37.727479421244 -122.379333871981 (37.727479421244, -122.379333871981) 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
163406 85562 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767) 10 3 8 58 1
165962 85737 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 843 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6011572.165806 2112967.734183 37.7824586081659 -122.40362250947 (37.7824586081659, -122.40362250947) 6 2 9 28853 34
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
168460 3904 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 84 Castro St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2014 11:00:00 AM 3 2X2   6002180.9408165 2107753.3024618 37.7676120130603 -122.435738811724 (37.7676120130603, -122.435738811724) 15 5 5 29492 3
168926 85580 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1458 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015655.098903 2094699.254039 37.7325244779387 -122.38822185678 (37.7325244779387, -122.38822185678) 10 3 8 58 1
170951 85832 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 5 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/2007 12:00:00 AM 3 3x3   6011370.824524 2112775.117387 37.7819184786136 -122.404305504694 (37.7819184786136, -122.404305504694) 6 2 9 28853 34
171845 93265 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1400X Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004448.1 2100692.1 37.7483521384228 -122.427393913264 (37.7483521384228, -122.427393913264) 2 4 5 63 22
172825 103850 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 3 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
173603 9306 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 240X Mansell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2007 12:00:00 AM 3 3X100   6011154.1519898 2090628.8663314 37.7210976210121 -122.403496526224 (37.7210976210121, -122.403496526224) 10 3 7 309 28
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
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
179694 85831 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/2007 12:00:00 AM 3 3x3   6011370.824524 2112775.117387 37.7819184786136 -122.404305504694 (37.7819184786136, -122.404305504694) 6 2 9 28853 34
180008 2389 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2642X Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2007 12:00:00 AM 3 3X3   6009749.5258463 2101948.1671123 37.7520994293613 -122.409150251369 (37.7520994293613, -122.409150251369) 2 4 7 28859 19
181472 15056 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1441 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2012 12:00:00 AM 3 4x4   6015002 2095363 37.7343107811298 -122.390526157796 (37.7343107811298, -122.390526157796) 10 3 8 58 1
181972 18423 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 952 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/20/2013 12:00:00 AM 3 3x3   6010455.30853 2103703.28348 37.7569581031602 -122.406833222372 (37.7569581031602, -122.406833222372) 10 4 7 28859 19
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
183177 93278 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1559 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004592 2099818 37.7459601990913 -122.426834068489 (37.7459601990913, -122.426834068489) 2 7 5 63 22
183182 85813 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1675 Howard St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/18/2007 12:00:00 AM 3 3x3   6007516 2108769 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156) 8 2 9 28853 19
184033 103836 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006751.07623 2113939.67696 37.7848568419422 -122.420370415446 (37.7848568419422, -122.420370415446) 13 9 9 28858 36
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
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
188346 85707 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 960 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6010763 2112242 37.7804206796364 -122.406370731962 (37.7804206796364, -122.406370731962) 14 2 9 28853 34
188775 85561 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6018144.213614 2092843.516343 37.7275665867834 -122.379487431767 (37.7275665867834, -122.379487431767) 10 3 8 58 1
190659 93279 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1557 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004591 2099830 37.7459930917878 -122.426838380811 (37.7459930917878, -122.426838380811) 2 7 5 63 22
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
192345 85697 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.7861224301769 -122.399185316932 (37.7861224301769, -122.399185316932) 12 2 9 28855 6
193248 85830 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/2007 12:00:00 AM 3 3x3   6011370.824524 2112775.117387 37.7819184786136 -122.404305504694 (37.7819184786136, -122.404305504694) 6 2 9 28853 34
193910 85695 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6012881.28755 2114275.485576 37.7861224301769 -122.399185316932 (37.7861224301769, -122.399185316932) 12 2 9 28855 6
847 92588 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 11 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
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
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
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
3624 151146 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2900 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2020 12:00:00 AM 3 Width 4ft   6008882.69002 2105920.7172 37.7629585507151 -122.412428682741 (37.7629585507151, -122.412428682741) 8 4 7 28859 19
4497 264869 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1655 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 4x6   5986201 2103975 37.7563171904504 -122.490732590523 (37.7563171904504, -122.490732590523) 1 8 3 56 35
4809 181872 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2330 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/24/2020 12:00:00 AM 3 4x6   5985803.3054 2099347.2154 37.7435873132981 -122.491767267489 (37.7435873132981, -122.491767267489) 1 8 3 29491 35
5015 224353 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3030 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 11:50:00 AM 3 Width 4ft   6006632.75905 2106740.09726 37.7650818572521 -122.420268591949 (37.7650818572521, -122.420268591949) 8 4 7 28853 19
5494 261029 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 863 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 4x6   5986308 2110038 37.7729707519219 -122.490808659035 (37.7729707519219, -122.490808659035) 11 6 2 55 26
7622 253826 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 701 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 02/22/2018 12:20:00 PM 3 3x3                      
8189 151145 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2900 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2020 12:00:00 AM 3 Width 4ft   6008902.66747 2105921.7543 37.762962519431 -122.412359660679 (37.762962519431, -122.412359660679) 8 4 7 28859 19
8599 262043 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 245 11th St   : Cutout Tree Private 2 FUF 04/14/2020 12:00:00 AM 3   Permit Number 785251 6008265.74007 2109435.35593 37.7725742877847 -122.414811260337 (37.7725742877847, -122.414811260337) 8 2 9 28853 34
8777 18349 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 3 3X3   6010308 2106081 37.7634785336334 -122.407510304274 (37.7634785336334, -122.407510304274) 8 4 8 28859 19
9447 91424 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2008 12:00:00 AM   3x3 Permit Number 52102 6003571 2107157 37.7660535712373 -122.430888215554 (37.7660535712373, -122.430888215554) 7 4 5 28862 3
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
9751 261814 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1622 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2020 12:00:00 AM 3 5x4   5985349 2104146 37.7567369022815 -122.493691659097 (37.7567369022815, -122.493691659097) 1 8 3 56 35
10779 49299 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3   Permit Number 46308 5981979.10455 2111331.16831 37.7762675789736 -122.505878467652 (37.7762675789736, -122.505878467652) 11 6 2 55 26
11859 262397 Undocumented 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 498 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 3x3   6008907 2105964 37.7630787595522 -122.412347662048 (37.7630787595522, -122.412347662048) 8 4 7 28859 19
12272 117721 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 471 40th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/25/2020 11:12:00 AM 3 Width 3ft   5983437.41308 2112653.95912 37.779985305245 -122.500931708584 (37.779985305245, -122.500931708584) 11 6 2 55 26
12577 17385 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1649 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1996 12:00:00 AM 12 6x5   6014583.05525 2095408.96107 37.7344137306531 -122.391977809509 (37.7344137306531, -122.391977809509) 10 3 8 58 1
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
13828 144979 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 626 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 Width 3ft   5990674.57486 2111094.54046 37.7761258404607 -122.47578147193 (37.7761258404607, -122.47578147193) 11 6 2 54 26
13904 50261 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 31 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2002 12:00:00 AM     Permit Number 46967 6005053.32023027 2096760.11488265 37.737590014135 -122.425021354004 (37.737590014135, -122.425021354004) 2 7 5 28859 2
15395 262455 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1788 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000684 2093777 37.7291512919898 -122.43991430419 (37.7291512919898, -122.43991430419) 9 7 6 28861 25
15650 261311 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3368 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2019 12:00:00 AM 3 3x3   5998140.71226 2116180.16914 37.7905196763565 -122.450320900484 (37.7905196763565, -122.450320900484) 13 6 1 54 31
16126 264873 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2330 34th Ave 2 Sidewalk: Curb side : Yard Tree Private 2   10/24/2020 12:00:00 AM 3 4x6   5985803.3054 2099347.2154 37.7435873132981 -122.491767267489 (37.7435873132981, -122.491767267489) 1 8 3 29491 35
16185 182600 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1959 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2020 12:00:00 AM 3 4x4   5985980.7032 2101896.5884 37.7505975691069 -122.4913414752 (37.7505975691069, -122.4913414752) 1 8 3 29491 35
16462 91091 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
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
18500 144214 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 786 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/2020 12:25:00 PM 0 Width 4ft   5982943.75928 2110448.71022 37.7739013377013 -122.502476188525 (37.7739013377013, -122.502476188525) 11 6 2 55 26
19079 229898 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 590 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2020 12:00:00 AM 3 Width 2ft Permit Number 787828 6001392.90328 2100882.89168 37.7487027395486 -122.437972352563 (37.7487027395486, -122.437972352563) 2 4 5 28862 22
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
20524 87026 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 863 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2007 12:00:00 AM   3x3 Permit Number 49970 6004379 2103877 37.7570932205384 -122.427859766577 (37.7570932205384, -122.427859766577) 2 4 5 28862 3
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
21865 91095 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2008 12:00:00 AM 3 3x3 Permit Number 51985 6006736 2105525 37.7617513016467 -122.419825278263 (37.7617513016467, -122.419825278263) 2 4 7 28859 19
22249 109286 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1438 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 771727 5982826.9 2105321.3 37.75981607235 -122.502500845014 (37.75981607235, -122.502500845014) 1 8 3 56 35

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