trees

226 rows where qCaretaker_id = 2 and qSpecies_id = 2 sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 226 ✖
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)
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
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
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
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
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
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
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
22322 85732 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 901 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 3x3   6011193.193535 2112605.183477 37.7814419523203 -122.404908060988 (37.7814419523203, -122.404908060988) 14 2 9 28853 34
24373 177452 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 404 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6003440.2849 2091219.73942 37.7222861409715 -122.430203237092 (37.7222861409715, -122.430203237092) 9 7 6 28861 5
25318 16583 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 810X Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2008 12:00:00 AM 2 3X3   5992991.92524 2114858.80829 37.7865955752076 -122.468039078982 (37.7865955752076, -122.468039078982) 11 6 1 54 11
26492 149925 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 595 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2018 12:00:00 AM 3 Width 4ft Permit Number 778997 6015496.37916 2106243.76048 37.7642144863464 -122.389576575905 (37.7642144863464, -122.389576575905) 14 3 8 28856 29
28398 230376 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 126 Dolores St 1 : Tree Private 2     4 Width 3ft   6004756.55794 2107626.00234 37.7674084411732 -122.426821010098 (37.7674084411732, -122.426821010098) 8 4 5 28862 3
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
32063 230390 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3431 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005492.40988 2103117.15388 37.7550697840629 -122.423955133335 (37.7550697840629, -122.423955133335) 2 4 5 28859 19
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
33725 91422 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2008 12:00:00 AM   3x3 Permit Number 52102; Tree 2 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 6003571 2107157 37.7660535712373 -122.430888215554 (37.7660535712373, -122.430888215554) 7 4 5 28862 3
37463 252931 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 71 Edgar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997064 2091155 37.7217451669512 -122.452239761545 (37.7217451669512, -122.452239761545) 9 8 6 28861 24
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
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
42638 230392 Undocumented 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3416 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005586.33797 2103162.25218 37.7551989159029 -122.423633508794 (37.7551989159029, -122.423633508794) 2 4 5 28859 19
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
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
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
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
56473 93743 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 875 Howard St   Sidewalk: Curb side : Cutout Tree Private 2   03/29/2010 12:00:00 AM   3x3 Permit Number 53322 6011367.4 2112778.7 37.7819281242694 -122.40431760427 (37.7819281242694, -122.40431760427) 6 2 9 28853 34
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
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
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
59794 92589 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 12 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
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
61373 88349 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183) 9 7 6 28861 5
62082 55564 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1X CASELLI AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50796 6000842 2104917 37.7597480805722 -122.440166611531 (37.7597480805722, -122.440166611531) 2 4 5 28862 3
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
69525 92582 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 5 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
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
72127 230394 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 280 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005433.48505 2102088.45121 37.7522418784739 -122.42408575987 (37.7522418784739, -122.42408575987) 2 4 5 28859 19
72199 88350 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Vienna St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183) 9 7 6 28861 5
72989 92584 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 7 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
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
74920 225508 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 8 Sidewalk: Curb side : Cutout Tree Private 2     17 6x6   6004195.74141 2106258.0557 37.763620663995 -122.428663273099 (37.763620663995, -122.428663273099) 8 4 5 28862 3
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
77180 248912 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1215 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6017471 2096747 37.7382476302403 -122.382086185189 (37.7382476302403, -122.382086185189) 10 3 8 58 1
78957 51994 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3858 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1977 12:00:00 AM     Permit Number 769135 5995734.40748516 2115851.40858603 37.78947898308 -122.458622703992 (37.78947898308, -122.458622703992) 11 6 1 54 31
80541 87452 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 601 Dolores St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2008 12:00:00 AM 4 3x3   6004976 2104871 37.7598562652774 -122.425865863079 (37.7598562652774, -122.425865863079) 2 4 5 28862 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
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
84741 230375 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 70 Pearl St 1 : Tree Private 2     9 Width 4ft   6005616.00843 2108643.76201 37.770251521926 -122.423920665902 (37.770251521926, -122.423920665902) 8 2 5 28853 19
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
86389 230391 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3425 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6005521.318 2103117.66656 37.7550728237692 -122.423855197061 (37.7550728237692, -122.423855197061) 2 4 5 28859 19
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
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
90052 91421 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2008 12:00:00 AM   3x3 Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012 6003571 2107157 37.7660535712373 -122.430888215554 (37.7660535712373, -122.430888215554) 7 4 5 28862 3
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
92580 18371 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 636 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2016 12:00:00 AM 4 2X2   6010355.57301 2105342.69627 37.7614539813358 -122.40729371394 (37.7614539813358, -122.40729371394) 10 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
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
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
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
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
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
101791 230380 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1450 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010406.10881 2100942.79845 37.7493756698697 -122.406808829185 (37.7493756698697, -122.406808829185) 2 4 7 28859 19
101899 100432 Significant Tree 6 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 200X Stonecrest Dr 2 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
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
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
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
105367 6784 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1360 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2007 12:00:00 AM 4 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
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
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
108744 230393 Undocumented 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3420 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005567.36067 2103163.57677 37.7552014816894 -122.423699232135 (37.7552014816894, -122.423699232135) 2 4 5 28859 19

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