trees

399 rows where qSpecies_id = 2 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

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)
193387 230379 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 636 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010352.94216 2105328.73163 37.7614154903439 -122.407301828531 (37.7614154903439, -122.407301828531) 10 4 8 28859 19
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
105437 193408 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010314.12402 2106048.65269 37.7633900580388 -122.407486842464 (37.7633900580388, -122.407486842464) 8 4 8 28859 19
120199 116966 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6010311.67872 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703) 8 4 8 28859 19
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
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
16221 18344 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 440 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   07/16/2015 07:27:00 AM 3 4x4   6010309.57073 2106285.64769 37.7640405376657 -122.40751930078 (37.7640405376657, -122.40751930078) 8 4 8 28859 19
3345 258176 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 255 Silliman St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010040.21914 2094084.80619 37.7305246249549 -122.4075906244 (37.7305246249549, -122.4075906244) 10 3 7 309 28
7155 258178 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 255 Silliman St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010040.21914 2094084.80619 37.7305246249549 -122.4075906244 (37.7305246249549, -122.4075906244) 10 3 7 309 28
19452 258177 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 255 Silliman St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010040.21914 2094084.80619 37.7305246249549 -122.4075906244 (37.7305246249549, -122.4075906244) 10 3 7 309 28
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
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
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
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
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
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
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
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
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
148316 94258 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 5 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
185712 94261 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2850X 20th St 2 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
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
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
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
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
141097 94245 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 7 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
172339 94247 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2125 BRYANT ST 11 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
69419 86595 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2154 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 6 3x3   6009566 2104744 37.7597658751742 -122.409982265203 (37.7597658751742, -122.409982265203) 2 4 7 28859 19
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
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
50443 96012 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
53527 96014 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
53962 96013 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
161466 96015 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
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
24900 13061 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 583 Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/01/2013 12:00:00 AM 12 2X2   6009566.8887098 2120490.1657189 37.8030011583731 -122.411091436508 (37.8030011583731, -122.411091436508) 3 1 10 308 23
59261 83828 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 755-757 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM     Permit Number 52235 6009406.96888923 2119078.72581504 37.7991167247732 -122.411545064383 (37.7991167247732, -122.411545064383) 3 1 10 308 4
85121 83826 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 755-757 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM     Permit Number 52235 6009406.96888923 2119078.72581504 37.7991167247732 -122.411545064383 (37.7991167247732, -122.411545064383) 3 1 10 308 4
183348 83827 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 755-757 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM     Permit Number 52235 6009406.96888923 2119078.72581504 37.7991167247732 -122.411545064383 (37.7991167247732, -122.411545064383) 3 1 10 308 4
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
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
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
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
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
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
138954 108977 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2970 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2015 12:00:00 AM 3 3x3 Permit Number 773794 6008402.2 2103930 37.7574655215329 -122.413949705223 (37.7574655215329, -122.413949705223) 2 4 7 28859 19
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
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
167046 85824 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1399X Howard St 1 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
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
11 264841 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
21 264839 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
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
159084 230389 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 4 : Tree Private 2     6 Width 3ft   6008142.81587 2108281.73826 37.7693998171644 -122.415154794967 (37.7693998171644, -122.415154794967) 8 4 7 28853 19
99872 230388 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 3 : Tree Private 2     8 Width 4ft   6008125.59993 2108283.70929 37.7694042616334 -122.41521448386 (37.7694042616334, -122.41521448386) 8 4 7 28853 19
88872 230387 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 2 : Tree Private 2     7 Width 4ft   6008108.07186 2108284.25114 37.7694047643365 -122.415275151222 (37.7694047643365, -122.415275151222) 8 4 7 28853 19
37543 230386 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 51 13th St 1 : Tree Private 2     9 Width 4ft   6008087.40778 2108285.62264 37.769407368778 -122.415346724678 (37.769407368778, -122.415346724678) 8 4 7 28853 19
162176 34756 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 930 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM     Permit Number 767406 6007964.37275398 2102502.67346206 37.7535218086 -122.415362848727 (37.7535218086, -122.415362848727) 2 4 7 28859 19
158553 85822 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1499X Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2007 12:00:00 AM 3 3x3   6008077.269337 2109627.004998 37.7730899192917 -122.415476772701 (37.7730899192917, -122.415476772701) 8 2 9 28853 34
28890 85821 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1501 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6008072 2109608 37.7730374398788 -122.415493654294 (37.7730374398788, -122.415493654294) 8 2 9 28853 19
134990 85820 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1501 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6008072 2109608 37.7730374398788 -122.415493654294 (37.7730374398788, -122.415493654294) 8 2 9 28853 19
137137 85817 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1581 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6007957.739489 2109502.485486 37.7727412989479 -122.415881423672 (37.7727412989479, -122.415881423672) 8 2 9 28853 19
168045 85818 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1525 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2007 12:00:00 AM 3 3x3   6007957 2109502 37.7727399243445 -122.415883947269 (37.7727399243445, -122.415883947269) 8 2 9 28853 19
103120 87853 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 599 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM   3x3 Permit Number 50764 6007684 2096571 37.7372189966792 -122.415912430403 (37.7372189966792, -122.415912430403) 2 7 7 28859 2
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
138301 32721 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 644 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM 3 3x3 Permit Number 37113 6007901.48303797 2114768.35798987 37.7871969578975 -122.416449089052 (37.7871969578975, -122.416449089052) 13 1 9 28858 36
143563 32720 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 644 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM 3 3x3 Permit Number 37113 6007901.48303797 2114768.35798987 37.7871969578975 -122.416449089052 (37.7871969578975, -122.416449089052) 13 1 9 28858 36
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
192832 85814 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1607 Howard St 1 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
151915 63015 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 75 Wool St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/16/2014 12:00:00 AM     Permit Number 772837 6007421.64921795 2097871.12423845 37.7407740975251 -122.416911586715 (37.7407740975251, -122.416911586715) 2 7 7 28859 2
10234 85811 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1675 Howard St 2 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
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
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
193856 85810 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1675 Howard St 1 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
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
33153 88751 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 8 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
41333 88753 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 10 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
87848 88749 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
98572 88750 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
159193 88752 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
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
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
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
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
146375 91093 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 5 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
178576 91090 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 2 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
182836 91089 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 1 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
189781 91092 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3417X 18th St 4 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
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
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
34950 103838 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 5 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
40281 103835 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 900X O'Farrell St 2 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
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
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
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
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

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