trees

399 rows where qSpecies_id = 2 sorted by Neighborhoods (old)

✎ 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) ▼
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
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
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
86741 5370 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 265 DOLORES ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/2015 03:03:00 PM 3 3X3   6005008.2 2106862.7 37.765326820302 -122.425896274391 (37.765326820302, -122.425896274391) 8 4 5 28853 19
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
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
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
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
98913 434 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 890X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2013 12:00:00 AM 3 3x3   6010425.4291782 2104052.7086425 37.7579158746071 -122.406961184613 (37.7579158746071, -122.406961184613) 10 4 7 28859 19
99446 86637 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 2679 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/30/2007 12:00:00 AM 3 3x3   6009805.531856 2101750.09748 37.7515587115691 -122.408942599671 (37.7515587115691, -122.408942599671) 2 4 7 28859 19
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
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
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
108000 108709 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 280 Fair Oaks St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773390 6005432.93594 2102084.07132 37.7522298213067 -122.424087347331 (37.7522298213067, -122.424087347331) 2 4 5 28859 19
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
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
120075 230383 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6005020.28561 2104519.96917 37.7588949199761 -122.425687715924 (37.7588949199761, -122.425687715924) 2 4 5 28859 19
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
126676 25487 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 645X POTRERO AVE 4 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2013 12:00:00 AM 3 3X3   6010440 2105310 37.7613689295586 -122.406999409931 (37.7613689295586, -122.406999409931) 10 4 8 28859 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
136291 5477 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6005026.79294 2104432.16218 37.7586541903676 -122.425658960999 (37.7586541903676, -122.425658960999) 2 4 5 28859 19
136361 5577 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1041 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2010 12:00:00 AM 3 3x3   6005148.8764838 2102292.2742932 37.7527854561506 -122.425084482909 (37.7527854561506, -122.425084482909) 2 4 5 28859 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
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
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
144023 100465 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1140 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010498.9 2102571.5 37.7538529165301 -122.40660271212 (37.7538529165301, -122.40660271212) 10 4 7 28859 19
144661 5385 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 325X Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/2013 12:00:00 AM   4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
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
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
149323 230381 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 6ft   6005021.94421 2104476.35643 37.7587752633866 -122.425678875606 (37.7587752633866, -122.425678875606) 2 4 5 28859 19
150628 230385 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 581 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 9ft   6004995.95318 2104998.86424 37.760208477866 -122.425805956086 (37.760208477866, -122.425805956086) 2 4 5 28859 19
152696 95786 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3431 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767530 6005503 2103116 37.7550672136514 -122.423918427558 (37.7550672136514, -122.423918427558) 2 4 5 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
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
161160 5458 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 589 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2009 12:00:00 AM 90 3x3   6004996.57492 2104960.58209 37.7601033992601 -122.425801080858 (37.7601033992601, -122.425801080858) 2 4 5 28859 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
164462 230384 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 601 Dolores St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005003.81478 2104818.83763 37.7597146115626 -122.425765952455 (37.7597146115626, -122.425765952455) 2 4 5 28859 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
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
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
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
181972 18423 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 952 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/20/2013 12:00:00 AM 3 3x3   6010455.30853 2103703.28348 37.7569581031602 -122.406833222372 (37.7569581031602, -122.406833222372) 10 4 7 28859 19
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
183063 18480 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1298 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/31/2017 01:20:00 PM 3 3x3   6010561.39126 2101710.28558 37.7514917080909 -122.406325925618 (37.7514917080909, -122.406325925618) 10 4 7 28859 19
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
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
186916 230382 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 655 Dolores St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 6ft   6005021.64655 2104500.02665 37.7588402394163 -122.42568158976 (37.7588402394163, -122.42568158976) 2 4 5 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
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
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
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
13904 50261 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 31 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2002 12:00:00 AM     Permit Number 46967 6005053.32023027 2096760.11488265 37.737590014135 -122.425021354004 (37.737590014135, -122.425021354004) 2 7 5 28859 2
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
139812 114762 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 27X Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2015 12:00:00 AM     Permit Number 46967 6005096.96871 2096699.60241 37.7374263260205 -122.424866136467 (37.7374263260205, -122.424866136467) 2 7 5 28859 2
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
3024 103847 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1529 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006640.1 2116184.7 37.7910148670423 -122.420913805894 (37.7910148670423, -122.420913805894) 13 9 10 28858 21
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
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
44915 103874 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1331 Polk St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006716.3 2115545.2 37.7892632533111 -122.42060474069 (37.7892632533111, -122.42060474069) 13 9 10 28858 21
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
57632 103843 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1541 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.7911013847793 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
82825 103844 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1541 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006635.7 2116216.3 37.7911013847793 -122.420931274285 (37.7911013847793, -122.420931274285) 13 9 10 28858 21
89928 103848 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
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
97816 103845 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1540 Polk St 1 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006747 2116248.1 37.7911949727431 -122.420548437624 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
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
113636 103846 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1540 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006747 2116248.1 37.7911949727431 -122.420548437624 (37.7911949727431, -122.420548437624) 13 9 10 28858 21
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
146908 103849 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 2 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
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
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
172825 103850 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1524 Polk St 3 Sidewalk: Curb side : Pot Tree DPW 1   08/21/2013 12:00:00 AM 3 3x3   6006765.8 2116184.9 37.7910225007002 -122.420478902042 (37.7910225007002, -122.420478902042) 13 9 10 28858 21
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
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
7379 93250 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1050 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004388 2102776 37.7540706426955 -122.42775019598 (37.7540706426955, -122.42775019598) 2 4 5 28862 22
14455 708 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1504X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/06/2015 02:27:00 PM 3 6x4   6005213.6425 2099570.03766 37.7453144798919 -122.424666874798 (37.7453144798919, -122.424666874798) 2 7 5 63 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
22004 93263 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1326 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004490 2101167 37.7496584733742 -122.427282847994 (37.7496584733742, -122.427282847994) 2 4 5 28862 22
22857 93269 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1730 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004618 2098811 37.7431966782063 -122.426672467078 (37.7431966782063, -122.426672467078) 2 7 5 63 22
36426 93271 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1699X Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004711 2099043.6 37.7438406020251 -122.426367454995 (37.7438406020251, -122.426367454995) 2 7 5 63 22
38042 93264 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1326 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004490 2101167 37.7496584733742 -122.427282847994 (37.7496584733742, -122.427282847994) 2 4 5 28862 22
52263 93252 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1070 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004394 2102659 37.7537497275294 -122.427721110855 (37.7537497275294, -122.427721110855) 2 4 5 28862 22
52463 93286 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1283 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004502 2101425 37.7503675600759 -122.427259727267 (37.7503675600759, -122.427259727267) 2 4 5 28862 22
58550 93288 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1259 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004494 2101568 37.7507597523824 -122.427297577126 (37.7507597523824, -122.427297577126) 2 4 5 28862 22
61769 93266 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1440 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004482.7 2100527.8 37.747902965476 -122.427262565386 (37.747902965476, -122.427262565386) 2 4 5 63 22
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
65044 93273 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1679 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004706.9 2099119.3 37.7440482251279 -122.426387020617 (37.7440482251279, -122.426387020617) 2 7 5 63 22
65551 104727 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1079 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3 Permit Number 770313 6004450 2102615 37.7536320814231 -122.427524315639 (37.7536320814231, -122.427524315639) 2 4 5 28862 22
67555 93267 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1550 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004563 2099865 37.7460876105373 -122.426937693393 (37.7460876105373, -122.426937693393) 2 7 5 63 22
68827 93281 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1465 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004562 2100365 37.7474604386711 -122.426976756198 (37.7474604386711, -122.426976756198) 2 7 5 63 22
72266 93277 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1565 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004670.9 2099777.3 37.7458529070189 -122.426558345234 (37.7458529070189, -122.426558345234) 2 7 5 63 22
74521 93293 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1049 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004440 2102791 37.7541147705659 -122.42757143594 (37.7541147705659, -122.42757143594) 2 4 5 28862 22
76153 93291 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1065 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2008 12:00:00 AM 3 3x3   6004445 2102697 37.7538569514077 -122.427547448283 (37.7538569514077, -122.427547448283) 2 4 5 28862 22
77573 93260 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1250X Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2008 12:00:00 AM 3 3x3   6004401.7 2101569.1 37.7507575523117 -122.427616837084 (37.7507575523117, -122.427616837084) 2 4 5 28862 22

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