trees

399 rows where qSpecies_id = 2 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
42966 10342 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 935 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/04/2011 12:00:00 AM 3 4x4   6001663.93706 2109024.15924 37.7710720905099 -122.437618081823 (37.7710720905099, -122.437618081823) 15 5 11 29492 9
43002 32722 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 644 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2011 12:00:00 AM 3 3x3 Permit Number 768334 6007901.48303797 2114768.35798987 37.7871969578975 -122.416449089052 (37.7871969578975, -122.416449089052) 13 1 9 28858 36
43519 29856 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1800X Evans Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/12/2011 12:00:00 AM 3 4x4   6014606.392164 2099329.1692391 37.745179108267 -122.392171198439 (37.745179108267, -122.392171198439) 10 3 8 58 1
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
43765 5416 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 430X Dolores St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/11/2011 12:00:00 AM 3 6x150   6004853.9708326 2105864.857711 37.7625782660478 -122.426358665446 (37.7625782660478, -122.426358665446) 8 4 5 28859 3
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
47537 18353 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2013 12:00:00 AM 3 3x3   6010310.70956 2106111.3358 37.7635619805233 -122.407503071611 (37.7635619805233, -122.407503071611) 8 4 8 28859 19
48598 94246 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 4 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
50013 93300 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 589X Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/12/2008 12:00:00 AM 3 3x3   6004575.9 2105667 37.7620192734995 -122.427306317148 (37.7620192734995, -122.427306317148) 8 4 5 28862 3
50146 94262 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.7592608098643 -122.409349258874 (37.7592608098643, -122.409349258874) 2 4 8 28859 19
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
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
56510 85815 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1607 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6007663 2109095 37.7716058657462 -122.416872087793 (37.7716058657462, -122.416872087793) 8 2 9 28853 19
56547 124911 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3234 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998736.95045 2116593.12953 37.7916876606053 -122.448287711302 (37.7916876606053, -122.448287711302) 11 6 1 54 30
57632 103843 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1541 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.7911013847793 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
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
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
60072 85828 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 1 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
60125 109530 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 76 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/2015 12:00:00 AM 3 3x3 Permit Number 775000 6005863.7 2102913.1 37.7545304541232 -122.422656603423 (37.7545304541232, -122.422656603423) 2 4 5 28859 19
60208 108834 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 163 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774662 6004445.49273 2094062.11561 37.7301475609408 -122.426930805706 (37.7301475609408, -122.426930805706) 9 7 6 28861 5
60588 125087 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2498X Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 Width 4ft Permit Number 779691 6001734 2116823 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064) 13 6 1 29490 27
61769 93266 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1440 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004482.7 2100527.8 37.747902965476 -122.427262565386 (37.747902965476, -122.427262565386) 2 4 5 63 22
62023 108507 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 796 19th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773790 5990094.5666 2109953.25495 37.772958540137 -122.477704410848 (37.772958540137, -122.477704410848) 11 6 2 55 26
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
63660 124910 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3234 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998760.11738 2116596.00833 37.7916968894517 -122.4482077616 (37.7916968894517, -122.4482077616) 11 6 1 54 30
64305 18418 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 645X POTRERO AVE 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/02/2016 12:00:00 AM 3 3X3   6010440 2105310 37.7613689295586 -122.406999409931 (37.7613689295586, -122.406999409931) 10 4 8 28859 19
64762 13340 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 230 Mansell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2007 12:00:00 AM 3 3X24   6011187.2509688 2090638.9738565 37.721127222942 -122.403382822785 (37.721127222942, -122.403382822785) 10 3 7 309 28
65044 93273 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1679 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004706.9 2099119.3 37.7440482251279 -122.426387020617 (37.7440482251279, -122.426387020617) 2 7 5 63 22
66728 18391 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 874 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2013 12:00:00 AM 3 4x4   6010420.6643105 2104143.6455038 37.7581653002339 -122.406984073056 (37.7581653002339, -122.406984073056) 10 4 7 28859 19
67555 93267 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1550 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004563 2099865 37.7460876105373 -122.426937693393 (37.7460876105373, -122.426937693393) 2 7 5 63 22
68827 93281 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1465 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004562 2100365 37.7474604386711 -122.426976756198 (37.7474604386711, -122.426976756198) 2 7 5 63 22
69485 85584 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1512 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2007 12:00:00 AM 3 3x3   6015354.897796 2094923.102787 37.7331224832721 -122.389275358402 (37.7331224832721, -122.389275358402) 10 3 8 58 1
70138 88771 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 461 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2015 12:00:00 AM 3 3x3 Permit Number 775199 6000624 2110522 37.7751256013752 -122.441322740074 (37.7751256013752, -122.441322740074) 15 5 11 29492 16
71427 2390 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2642X Bryant St 2 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
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
72266 93277 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1565 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004670.9 2099777.3 37.7458529070189 -122.426558345234 (37.7458529070189, -122.426558345234) 2 7 5 63 22
73027 85698 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 640 Howard St 4 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
73332 85812 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1675 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6007516 2108769 37.7707024771995 -122.417357464156 (37.7707024771995, -122.417357464156) 8 2 9 28853 19
73558 91094 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 6 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
73597 226527 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 635 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2017 12:00:00 AM 3 3x3 Permit Number 780912 6010443.26884 2105321.1926 37.7613998448343 -122.406988893247 (37.7613998448343, -122.406988893247) 10 4 8 28859 19
74455 94260 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.7592608098643 -122.409349258874 (37.7592608098643, -122.409349258874) 2 4 8 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
75023 5475 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 601 Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2008 12:00:00 AM 3 4X4   6005004.3744 2104794.07494 37.759646650683 -122.425762254445 (37.759646650683, -122.425762254445) 2 4 5 28859 19
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
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
77343 17426 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1869 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/05/2015 01:06:00 PM 3 3X3   6013447.63917 2096284.81189 37.736755533926 -122.395964698714 (37.736755533926, -122.395964698714) 10 3 8 58 1
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
79656 2 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 850X Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/25/2009 12:00:00 AM 3 3X3   5992872.52482 2114854.21479 37.7865760666822 -122.468451837381 (37.7865760666822, -122.468451837381) 11 6 1 54 11
81325 94244 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 3 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
81910 225512 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4   01/08/2019 12:00:00 AM 3 6x6   6004203.25115 2106055.40872 37.7630646689183 -122.428622853063 (37.7630646689183, -122.428622853063) 8 4 5 28862 3
82825 103844 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1541 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.7911013847793 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
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
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
84916 85833 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St 6 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
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
86741 5370 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 265 DOLORES ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/2015 03:03:00 PM 3 3X3   6005008.2 2106862.7 37.765326820302 -122.425896274391 (37.765326820302, -122.425896274391) 8 4 5 28853 19
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
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
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
89928 103848 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 1 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
90555 94243 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
93248 103851 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2   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
93337 85826 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1399X Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   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
93856 4894 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 745X Mansell St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2007 12:00:00 AM 3 3X3   6009751.8988059 2090059.5024837 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874) 9 3 8 309 18
94874 29047 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 244 11th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/31/2012 12:00:00 AM 3 3x3   6008230.7231961 2109406.8924959 37.7724941663121 -122.414930372766 (37.7724941663121, -122.414930372766) 8 2 9 28853 19
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
95867 94263 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009745.2 2104556.4 37.7592608098643 -122.409349258874 (37.7592608098643, -122.409349258874) 2 4 8 28859 19
96508 115347 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 398X HARRISON ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854 2114630 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
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
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
97816 103845 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1540 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006747 2116248.1 37.7911949727431 -122.420548437624 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
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
98913 434 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 890X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2013 12:00:00 AM 3 3x3   6010425.4291782 2104052.7086425 37.7579158746071 -122.406961184613 (37.7579158746071, -122.406961184613) 10 4 7 28859 19
99446 86637 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2679 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6009805.531856 2101750.09748 37.7515587115691 -122.408942599671 (37.7515587115691, -122.408942599671) 2 4 7 28859 19
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
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
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
101718 93272 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1689 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004632 2099057 37.7438729293821 -122.42664157265 (37.7438729293821, -122.42664157265) 2 7 5 63 22
102280 131010 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3099 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001935.38679 2118702.33437 37.7976613236686 -122.437372261923 (37.7976613236686, -122.437372261923) 13 9 1 57 17
102956 85559 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 980 Palou Ave 1 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
103060 13103 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1516 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2008 12:00:00 AM 3 3x3   6005111 2119918 37.8011792509168 -122.426470375667 (37.8011792509168, -122.426470375667) 13 9 1 57 17
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
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
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
106272 115435 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 563 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777504 6001919.8 2090201.1 37.7194029477524 -122.435386355519 (37.7194029477524, -122.435386355519) 9 7 6 28861 5
108000 108709 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 280 Fair Oaks St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773390 6005432.93594 2102084.07132 37.7522298213067 -122.424087347331 (37.7522298213067, -122.424087347331) 2 4 5 28859 19
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
110634 117395 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 544 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3   Permit Number 778554 5991215.4 2097083.4 37.7376862859043 -122.47288871789 (37.7376862859043, -122.47288871789) 1 8 4 29491 40
111254 93275 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1607 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004606 2099539 37.7451949208192 -122.42676579302 (37.7451949208192, -122.42676579302) 2 7 5 63 22
113636 103846 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1540 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006747 2116248.1 37.7911949727431 -122.420548437624 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
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
114647 103837 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 4 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
115916 94259 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2777X 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2010 12:00:00 AM 3 3x3 Permit Number 53614 6009684.4 2104752.7 37.7597963985886 -122.409573390285 (37.7597963985886, -122.409573390285) 2 4 8 28859 19
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
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
117680 149924 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 595 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2018 12:00:00 AM 3 Width 4ft Permit Number 778997 6015473.11557 2106243.07147 37.764211304535 -122.389656990574 (37.764211304535, -122.389656990574) 14 3 8 28856 29
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
120075 230383 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6005020.28561 2104519.96917 37.7588949199761 -122.425687715924 (37.7588949199761, -122.425687715924) 2 4 5 28859 19
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

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