trees

399 rows where qSpecies_id = 2 sorted by XCoord

✎ 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)
2 262167 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
6 262166 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
19 262168 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
4376 259271 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1721x Taylor St 5 Side Yard : Yard Tree DPW 1 Private 05/25/2019 12:00:00 AM 3                        
5865 262160 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 98 Arleta Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
7622 253826 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 701 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 02/22/2018 12:20:00 PM 3 3x3                      
9316 262159 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 98 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3                        
13136 255218 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 101 Goettingen St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
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
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
22249 109286 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1438 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 771727 5982826.9 2105321.3 37.75981607235 -122.502500845014 (37.75981607235, -122.502500845014) 1 8 3 56 35
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
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
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
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
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
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
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
186849 88363 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2294 31st Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52532 5986746.4 2099664.8 37.7445143908471 -122.48852965845 (37.7445143908471, -122.48852965845) 1 8 3 29491 35
163472 109142 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 342 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773572 5986886.5 2113633.7 37.7828773022088 -122.489071978745 (37.7828773022088, -122.489071978745) 11 6 2 55 26
128665 95423 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2187 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM   3x3 Permit Number 767291 5989736.1 2100494 37.7469651560486 -122.478252612879 (37.7469651560486, -122.478252612879) 1 8 3 29491 35
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
190320 72375 Private 9 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 4299X Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.477688796337 (37.773031079694, -122.477688796337) 11 6 2 55 26
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
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
147278 100431 Significant Tree 6 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 200X Stonecrest Dr 1 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
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
174018 114091 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1717 15th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/01/2015 12:00:00 AM     Permit Number 775992 5991423.2 2103752.9 37.7560110367904 -122.472656396727 (37.7560110367904, -122.472656396727) 1 8 4 56 12
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
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
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
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
115835 92587 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 10 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
122719 86795 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 2 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
129134 92585 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 8 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
132976 92580 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 3 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
137187 92586 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 9 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
163939 92583 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 6 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
174678 86796 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 1 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
192324 92581 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Wawona St 4 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
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
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
189245 52671 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1234@ LINCOLN 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53911 5993637.83557736 2107090.14039952 37.7653021756316 -122.465239907967 (37.7653021756316, -122.465239907967) 11 8 11 56 12
95100 112744 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 235 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/2015 12:00:00 AM     Permit Number 774127 5993719.1 2088769.4 37.7150026970857 -122.463629063261 (37.7150026970857, -122.463629063261) 9 8 6 64 24
156287 117298 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1590 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778522 5993741.6 2104678.7 37.7586869726954 -122.464705888807 (37.7586869726954, -122.464705888807) 1 8 4 56 12
29972 53133 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 925 Holloway Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 08/19/2015 12:00:00 AM     Permit Number 774158 5994000.81776041 2091173.40830125 37.7216197566197 -122.462829635252 (37.7216197566197, -122.462829635252) 9 8 6 64 24
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
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
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
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
41844 108873 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 137 Cole St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773403 5997771.92218 2110131.23662 37.7738897825389 -122.451160475717 (37.7738897825389, -122.451160475717) 15 5 11 29492 16
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
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
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
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
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
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
109159 87857 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1X CASELLI AVE 5 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
171027 55516 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 299 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2014 12:00:00 AM     Permit Number 772528 6001150.72264648 2104659.12373936 37.7590575866262 -122.439080412698 (37.7590575866262, -122.439080412698) 2 4 5 28862 3
179751 72994 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 590 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2011 12:00:00 AM   3x3 Permit Number 768023 6001377.74978743 2100887.76679336 37.748715263692 -122.438025102274 (37.748715263692, -122.438025102274) 2 4 5 28862 22
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
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
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
164641 125088 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2498X Pierce St 4 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
185594 135722 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2498X Pierce St 5 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
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
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
114396 95387 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 949 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767255 6001944 2101334 37.7499727001327 -122.436098944037 (37.7499727001327, -122.436098944037) 2 4 5 28862 22
63966 95388 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 4290 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767255 6001987.9 2101228 37.7496841432906 -122.43593955208 (37.7496841432906, -122.43593955208) 2 4 5 28862 22
168460 3904 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 84 Castro St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/2014 11:00:00 AM 3 2X2   6002180.9408165 2107753.3024618 37.7676120130603 -122.435738811724 (37.7676120130603, -122.435738811724) 15 5 5 29492 3
8200 3929 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100X Castro St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/18/2014 12:00:00 AM 3 4x4   6002188.32938 2107609.30269 37.7672170447484 -122.435702952048 (37.7672170447484, -122.435702952048) 15 5 5 28862 3
128897 87882 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1771 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM 6 3x3 Permit Number 50853 6002283.00879 2120864.77597 37.8036185768076 -122.436324238766 (37.8036185768076, -122.436324238766) 13 9 1 57 17
111986 131011 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1771 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002300.20603 2120865.81933 37.8036224187107 -122.436264801676 (37.8036224187107, -122.436264801676) 13 9 1 57 17
109636 95738 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 445 Edinburg St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767484 6003120.3 2091142.7 37.7220564786865 -122.431303852024 (37.7220564786865, -122.431303852024) 9 7 6 28861 5
142124 88687 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 135 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2008 12:00:00 AM     Permit Number 51638 6003417 2105051 37.7602622759886 -122.431270527939 (37.7602622759886, -122.431270527939) 2 4 5 28862 3
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
177568 108791 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 323 Edinburgh St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774649 6003546.88289 2091819.58764 37.7239392283561 -122.429877518865 (37.7239392283561, -122.429877518865) 9 7 6 28861 5
88803 94689 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 218 Roanoke St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53815 6003547 2096007 37.7354369283878 -122.430175705062 (37.7354369283878, -122.430175705062) 2 7 5 63 7
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
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
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
162109 91423 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 3 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
167491 91426 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 6 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
171265 91425 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2112 15th St 5 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
51058 96159 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767792 6003680 2095311.9 37.7335358734479 -122.429666314328 (37.7335358734479, -122.429666314328) 2 7 5 28861 25
114564 96160 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2 Milton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767792 6003680 2095311.9 37.7335358734479 -122.429666314328 (37.7335358734479, -122.429666314328) 2 7 5 28861 25
106231 96158 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767791 6003728 2095595 37.7343159198258 -122.429520547314 (37.7343159198258, -122.429520547314) 2 7 5 28861 25
87030 95566 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 168 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2014 12:00:00 AM   3x3 Permit Number 772810 6004034 2101610 37.7508490487538 -122.4288912915 (37.7508490487538, -122.4288912915) 2 4 5 28862 22
185957 177451 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 836 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004096.83843 2090858.43848 37.7213312534072 -122.427907954105 (37.7213312534072, -122.427907954105) 9 7 6 28861 5
110617 225504 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     18 6x6   6004179.96928 2106475.61191 37.7642171285539 -122.428733333881 (37.7642171285539, -122.428733333881) 8 4 5 28862 3
87079 225503 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     17 6x6   6004180.73654 2106512.8354 37.7643193787498 -122.428733333891 (37.7643193787498, -122.428733333891) 8 4 5 28862 3
114542 225505 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     19 6x6   6004182.33297 2106439.09947 37.7641170079293 -122.428722555516 (37.7641170079293, -122.428722555516) 8 4 5 28862 3
126216 225507 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     17 6x6   6004191.74013 2106290.72293 37.7637101339293 -122.428679441106 (37.7637101339293, -122.428679441106) 8 4 5 28862 3
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
151033 225509 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     22 6x6   6004197.80145 2106206.80833 37.7634800675805 -122.428652494712 (37.7634800675805, -122.428652494712) 8 4 5 28862 3
62341 225510 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4     21 6x6   6004199.54992 2106135.78909 37.7632851647079 -122.42864138449 (37.7632851647079, -122.42864138449) 8 4 5 28862 3
153477 225511 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 450 Church St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4     17 6x6   6004201.15911 2106105.10523 37.7632010052443 -122.428633631453 (37.7632010052443, -122.428633631453) 8 4 5 28862 3
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
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

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