Street_Tree_List

Data source: data.sfgov.org

85 rows where qSpecies = 89 sorted by SiteOrder

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
80806 86711 Permitted Site 1 Magnolia spp :: Magnolia 89 3714 Cesar Chavez St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/24/2007 12:00:00 AM 6   Permit Number 49697 6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
81789 86872 Permitted Site 1 Magnolia spp :: Magnolia 89 2160 Green St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/19/2007 12:00:00 AM   3x3 Permit Number 49804 6002705.0 2118187.0 37.796290071465 -122.43467232535102 (37.796290071465, -122.434672325351)
94855 86873 Permitted Site 1 Magnolia spp :: Magnolia 89 2160 Green St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/19/2007 12:00:00 AM   3x3 Permit Number 49804 6002705.0 2118187.0 37.796290071465 -122.43467232535102 (37.796290071465, -122.434672325351)
504 81687 Permitted Site 1 Magnolia spp :: Magnolia 89 210 Frederick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/2017 12:00:00 AM 3   Permit Number 777040 5999000.68344445 2107685.40393875 37.7672444226119 -122.446733986311 (37.7672444226119, -122.446733986311)
23507 208860 Undocumented 2 Magnolia spp :: Magnolia 89 1359 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991111.19274 2106147.12197 37.762566869885 -122.473910078106 (37.762566869885, -122.473910078106)
42433 208861 Undocumented 2 Magnolia spp :: Magnolia 89 263 Flood Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     5998987.837069999 2094055.2995 37.7298187374412 -122.44579806412399 (37.7298187374412, -122.445798064124)
47434 96416 Permitted Site 1 Magnolia spp :: Magnolia 89 2749 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 10x10   6008995.5323 2102438.8768 37.7534045389876 -122.411792354923 (37.7534045389876, -122.411792354923)
52473 230427 Undocumented 2 Magnolia spp :: Magnolia 89 230 Coso Ave 1 Side Yard : Yard 17 Tree 1 Private 1     1     6007601.41363 2099515.46986 37.74529921477939 -122.416406470502 (37.7452992147794, -122.416406470502)
52886 131013 Undocumented 2 Magnolia spp :: Magnolia 89 2531 Filbert St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 3ft   6000837.80329 2118568.05574 37.797230171598 -122.44116054993401 (37.797230171598, -122.441160549934)
61210 75375 Undocumented 2 Magnolia spp :: Magnolia 89 242 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1994 12:00:00 AM 2     5997883.096 2109628.0405 37.77251450021 -122.450739621122 (37.77251450021, -122.450739621122)
78197 104467 Permitted Site 1 Magnolia spp :: Magnolia 89 857 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/2013 12:00:00 AM 3 3x3 Permit Number 769287 6009159.4 2104178.6 37.7581906182499 -122.41134855663601 (37.7581906182499, -122.411348556636)
80599 62672 Permitted Site 1 Magnolia spp :: Magnolia 89 48 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/28/1986 12:00:00 AM 3   Permit Number 23004 6002888.71912125 2108707.39458203 37.770271894100794 -122.433358884898 (37.7702718941008, -122.433358884898)
81616 53478 Permitted Site 1 Magnolia spp :: Magnolia 89 51 Vicksburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2014 12:00:00 AM 15 4x4 Permit Number 772738 6004118.50395547 2102762.60365408 37.7540186110043 -122.428681223641 (37.7540186110043, -122.428681223641)
81779 110680 Undocumented 2 Magnolia spp :: Magnolia 89 162 DUNCAN ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005508.0 2099957.0 37.7463936103079 -122.423676542195 (37.7463936103079, -122.423676542195)
87189 33522 Permitted Site 1 Magnolia spp :: Magnolia 89 174 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/03/2009 12:00:00 AM   3x3 Permit Number 52072 6007260.41005057 2098019.68890663 37.7411729520807 -122.41747961878099 (37.7411729520807, -122.417479618781)
87378 85257 Permitted Site 1 Magnolia spp :: Magnolia 89 689 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2007 12:00:00 AM     Permit Number 49556 6001247.0 2102379.0 37.7528023963993 -122.438584066967 (37.7528023963993, -122.438584066967)
88027 21552 DPW Maintained 3 Magnolia spp :: Magnolia 89 1405 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2x2   6005864.0928275 2114832.0476095 37.787257048711794 -122.423502557849 (37.7872570487118, -122.423502557849)
88182 59775 Permitted Site 1 Magnolia spp :: Magnolia 89 100x PRECITA AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1981 12:00:00 AM 8 9x7 Permit Number 19223 6007128.0 2100007.0 37.7466222122015 -122.418078299823 (37.7466222122015, -122.418078299823)
89417 106244 Significant Tree 6 Magnolia spp :: Magnolia 89 735 MANGELS AVE 1 Front Yard : Yard 7 Tree 1 Private 1   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.45399649391199 (37.7328983615352, -122.453996493912)
91131 117373 Permitted Site 1 Magnolia spp :: Magnolia 89 2219 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/2016 12:00:00 AM 3   Permit Number 778546 5983853.5 2100037.4 37.7453682200001 -122.498560081441 (37.7453682200001, -122.498560081441)
93078 57434 Permitted Site 1 Magnolia spp :: Magnolia 89 4324 18TH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/16/1976 12:00:00 AM 20 9x6 Permit Number 16276 6001563.0 2105306.0 37.760857201453206 -122.437700893331 (37.7608572014532, -122.437700893331)
94633 67833 Permitted Site 1 Magnolia spp :: Magnolia 89 469 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/1992 12:00:00 AM   3x3 Permit Number 31495 6002871.84745267 2099449.75945792 37.7448516873624 -122.432755816877 (37.7448516873624, -122.432755816877)
95574 106372 Undocumented 2 Magnolia spp :: Magnolia 89 260 MAGELLAN AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5994684.4 2100364.8 37.7468964099217 -122.461132589625 (37.7468964099217, -122.461132589625)
95669 52263 Permitted Site 1 Magnolia spp :: Magnolia 89 40 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/29/2005 12:00:00 AM     Permit Number 48428 6005651.79801021 2099662.26802464 37.7455924596089 -122.423158358307 (37.7455924596089, -122.423158358307)
98708 110448 Undocumented 2 Magnolia spp :: Magnolia 89 28 BELCHER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 775444 6003746.0 2108157.0 37.7688092427031 -122.430354279635 (37.7688092427031, -122.430354279635)
103196 84073 Permitted Site 1 Magnolia spp :: Magnolia 89 3936 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/28/2008 12:00:00 AM   3x3 Permit Number 50418 6003544.24731161 2102468.85848111 37.753179539265794 -122.43064618026001 (37.7531795392658, -122.43064618026)
103722 79058 Permitted Site 1 Magnolia spp :: Magnolia 89 84 Berkeley Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/2011 12:00:00 AM     Permit Number 54829 6001112.32299105 2097379.40258298 37.7390670270865 -122.438691586574 (37.7390670270865, -122.438691586574)
104620 85065 Permitted Site 1 Magnolia spp :: Magnolia 89 168 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2007 12:00:00 AM     Permit Number 49431 5992213.6 2114351.2 37.78515684437129 -122.470694882766 (37.7851568443713, -122.470694882766)
104776 57433 Permitted Site 1 Magnolia spp :: Magnolia 89 4316 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/16/1976 12:00:00 AM 20 6x6 Permit Number 16275 6001651.18541617 2105289.61210405 37.7608172180801 -122.437394726023 (37.7608172180801, -122.437394726023)
105107 12534 Permitted Site 1 Magnolia spp :: Magnolia 89 129 LAKE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   5995062.0 2114816.0 37.786597363514296 -122.46087407188999 (37.7865973635143, -122.46087407189)
109354 19337 DPW Maintained 3 Magnolia spp :: Magnolia 89 420 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/12/2014 12:00:00 AM 3 3x3   5992930.1579343 2089870.1086696 37.71797948671671 -122.46643591192101 (37.7179794867167, -122.466435911921)
114905 87384 Permitted Site 1 Magnolia spp :: Magnolia 89 152 Pixley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2008 12:00:00 AM 7 3x3 Permit Number 50364 6002625.0 2119034.0 37.7986111712331 -122.43500974871701 (37.7986111712331, -122.435009748717)
115320 111036 Significant Tree 6 Magnolia spp :: Magnolia 89 3991-3997 Washington St 1 Front Yard : Yard 7 Tree 1 Private 1           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409)
117095 87371 Permitted Site 1 Magnolia spp :: Magnolia 89 67 Belcher St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/2008 12:00:00 AM   3x3 Permit Number 50351 6003819.0 2107947.0 37.768236768438705 -122.430086795172 (37.7682367684387, -122.430086795172)
117331 51939 Permitted Site 1 Magnolia spp :: Magnolia 89 61 Pond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2005 12:00:00 AM 8 5x2 Permit Number 48164 6003201.44301211 2106166.49517673 37.763312938971 -122.43209569818701 (37.763312938971, -122.432095698187)
118597 115761 Undocumented 2 Magnolia spp :: Magnolia 89 924 NOE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6003074.0 2102857.0 37.7542186318325 -122.43230010699301 (37.7542186318325, -122.432300106993)
119385 96515 Permitted Site 1 Magnolia spp :: Magnolia 89 3119 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2011 12:00:00 AM     Permit Number 58566 6009076.0 2100510.0 37.7481127876266 -122.411377822838 (37.7481127876266, -122.411377822838)
120037 57435 Permitted Site 1 Magnolia spp :: Magnolia 89 4328 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/16/1976 12:00:00 AM 24 6x6 Permit Number 16277 6001615.3752967995 2105287.59579624 37.760809645895705 -122.43751843269301 (37.7608096458957, -122.437518432693)
121124 5627 Permitted Site 1 Magnolia spp :: Magnolia 89 1215 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 6   6005207.4348277 2101278.8703511003 37.750006191310796 -122.42480988758899 (37.7500061913108, -122.424809887589)
122138 100151 Undocumented 2 Magnolia spp :: Magnolia 89 4047 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 5x5 Permit Number 776452 6002690.0 2105300.0 37.760904743288705 -122.433802674054 (37.7609047432887, -122.433802674054)
122377 53927 Permitted Site 1 Magnolia spp :: Magnolia 89 616-618 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/24/1972 12:00:00 AM     Permit Number 9640 6001839.32774762 2102295.7359044 37.752607450257 -122.43652973358499 (37.752607450257, -122.436529733585)
128044 117330 Permitted Site 1 Magnolia spp :: Magnolia 89 1144 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/07/2016 12:00:00 AM 3   Permit Number 778490 5998226.1 2106298.1 37.7633909587408 -122.449313182994 (37.7633909587408, -122.449313182994)
128418 85245 Permitted Site 1 Magnolia spp :: Magnolia 89 1307 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2007 12:00:00 AM     Permit Number 49546 6001610.0 2110428.0 37.774923619861205 -122.437905219532 (37.7749236198612, -122.437905219532)
131573 244383 Undocumented 2 Magnolia spp :: Magnolia 89 251 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6005771.1844 2110310.2456 37.7748360439411 -122.423502407009 (37.7748360439411, -122.423502407009)
132803 245119 Undocumented 2 Magnolia spp :: Magnolia 89 129 Baker St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6000771.8557 2109441.6092 37.7721675418639 -122.44073376176 (37.7721675418639, -122.44073376176)
140277 62900 Permitted Site 1 Magnolia spp :: Magnolia 89 42 Berkeley Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/30/1986 12:00:00 AM 1   Permit Number 23274 6001400.58144689 2097305.17262336 37.7388796034552 -122.437689607497 (37.7388796034552, -122.437689607497)
141237 67897 Permitted Site 1 Magnolia spp :: Magnolia 89 463 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/08/1994 12:00:00 AM   3x3 Permit Number 31599 5997692.14982092 2094077.11475557 37.7298045712917 -122.450278952768 (37.7298045712917, -122.450278952768)
141702 85208 Undocumented 2 Magnolia spp :: Magnolia 89 3099 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/16/2007 12:00:00 AM     Permit Number 49530 5999545.0 2115014.0 37.7873979483893 -122.44537828227502 (37.7873979483893, -122.445378282275)
141848 96914 Undocumented 2 Magnolia spp :: Magnolia 89 4396X 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/1996 12:00:00 AM   3x3 Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. 6000641.3 2102303.1 37.7525595190983 -122.440673239158 (37.7525595190983, -122.440673239158)
145476 101407 Permitted Site 1 Magnolia spp :: Magnolia 89 395X Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839.0 2105646.7 37.7621475376843 -122.41601905110501 (37.7621475376843, -122.416019051105)
148646 230429 Undocumented 2 Magnolia spp :: Magnolia 89 2649 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010278.55114 2103378.6457700003 37.756056828675206 -122.407421632625 (37.7560568286752, -122.407421632625)
171894 67230 Permitted Site 1 Magnolia spp :: Magnolia 89 519 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1992 12:00:00 AM 5   Permit Number 30689 5984068.99923 2112275.3941 37.7789829387423 -122.49871882925801 (37.7789829387423, -122.498718829258)
177913 140178 Undocumented 2 Magnolia spp :: Magnolia 89 246 COLE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5997876.1972 2109680.9307 37.7726593281832 -122.450767298801 (37.7726593281832, -122.450767298801)
183597 230428 Undocumented 2 Magnolia spp :: Magnolia 89 436 Murray St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006457.38895 2096010.6224 37.7356112869209 -122.42011363694999 (37.7356112869209, -122.42011363695)
35469 208862 Undocumented 2 Magnolia spp :: Magnolia 89 639 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     5997188.9726599995 2095238.55048 37.7329647871987 -122.45210224963499 (37.7329647871987, -122.452102249635)
57021 230426 Undocumented 2 Magnolia spp :: Magnolia 89 230 Coso Ave 2 Side Yard : Yard 17 Tree 1 Private 1     1     6007649.023990001 2099489.86888 37.745231597464795 -122.416240028469 (37.7452315974648, -122.416240028469)
89893 111037 Significant Tree 6 Magnolia spp :: Magnolia 89 3991-3997 Washington St 2 Front Yard : Yard 7 Tree 1 Private 1           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409)
90860 104718 Undocumented 2 Magnolia spp :: Magnolia 89 100x PRECITA AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6007128.0 2100007.0 37.7466222122015 -122.418078299823 (37.7466222122015, -122.418078299823)
91693 110449 Undocumented 2 Magnolia spp :: Magnolia 89 28 BELCHER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 775444 6003746.0 2108157.0 37.7688092427031 -122.430354279635 (37.7688092427031, -122.430354279635)
104200 101408 Permitted Site 1 Magnolia spp :: Magnolia 89 395X Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839.0 2105646.7 37.7621475376843 -122.41601905110501 (37.7621475376843, -122.416019051105)
115897 12528 Permitted Site 1 Magnolia spp :: Magnolia 89 100 Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/15/2008 12:00:00 AM 3 3X3   5995135.72177 2114954.21759 37.7869811132671 -122.4606290341 (37.7869811132671, -122.4606290341)
116950 87372 Permitted Site 1 Magnolia spp :: Magnolia 89 67 Belcher St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/2008 12:00:00 AM   3x3 Permit Number 50351 6003819.0 2107947.0 37.768236768438705 -122.430086795172 (37.7682367684387, -122.430086795172)
121390 94784 Permitted Site 1 Magnolia spp :: Magnolia 89 1X CASELLI AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2010 12:00:00 AM   3x3 Permit Number 53882 6000842.0 2104917.0 37.7597480805722 -122.44016661153098 (37.7597480805722, -122.440166611531)
122178 112552 Permitted Site 1 Magnolia spp :: Magnolia 89 51 VICKSBURG ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6004133.0 2102760.0 37.7540122823763 -122.42863090726001 (37.7540122823763, -122.42863090726)
128589 96516 Permitted Site 1 Magnolia spp :: Magnolia 89 3119 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2011 12:00:00 AM     Permit Number 58566 6009076.0 2100510.0 37.7481127876266 -122.411377822838 (37.7481127876266, -122.411377822838)
129027 104763 Undocumented 2 Magnolia spp :: Magnolia 89 51 VICKSBURG ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2014 12:00:00 AM 15 4x4 Permit Number 772738 6004133.6 2102760.4 37.7540134146385 -122.428628860828 (37.7540134146385, -122.428628860828)
148968 245120 Undocumented 2 Magnolia spp :: Magnolia 89 129 Baker St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   6000774.8471 2109422.9959 37.7721166047697 -122.44072207891001 (37.7721166047697, -122.44072207891)
160103 140179 Undocumented 2 Magnolia spp :: Magnolia 89 246 COLE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5997872.7479 2109697.411 37.7727043813962 -122.450780418722 (37.7727043813962, -122.450780418722)
591 139532 Permitted Site 1 Magnolia spp :: Magnolia 89 2103 O'Farrell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2017 12:00:00 AM 3 Width 0ft Permit Number 779818 6001200.3588 2113145.5057 37.7823618989571 -122.439517100245 (37.7823618989571, -122.439517100245)
26735 75220 Undocumented 2 Magnolia spp :: Magnolia 89 246 Cole St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1994 12:00:00 AM 1     5997870.8316 2109714.2746 37.772750574805 -122.450788263508 (37.772750574805, -122.450788263508)
100276 94785 Permitted Site 1 Magnolia spp :: Magnolia 89 1X CASELLI AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2010 12:00:00 AM   3x3 Permit Number 53882 6000842.0 2104917.0 37.7597480805722 -122.44016661153098 (37.7597480805722, -122.440166611531)
105436 37939 Permitted Site 1 Magnolia spp :: Magnolia 89 730 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40183 6015727.50058131 2103973.29458622 37.757993086421706 -122.38861868565901 (37.7579930864217, -122.388618685659)
111861 101409 Permitted Site 1 Magnolia spp :: Magnolia 89 395X Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839.0 2105646.7 37.7621475376843 -122.41601905110501 (37.7621475376843, -122.416019051105)
123461 28056 DPW Maintained 3 Magnolia spp :: Magnolia 89 33 Haight St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 4X4   6005944.78414 2109618.42708 37.77294627400379 -122.42285271058 (37.7729462740038, -122.42285271058)
43331 94786 Permitted Site 1 Magnolia spp :: Magnolia 89 1X CASELLI AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2010 12:00:00 AM   3x3 Permit Number 53882 6000842.0 2104917.0 37.7597480805722 -122.44016661153098 (37.7597480805722, -122.440166611531)
80813 104947 Undocumented 2 Magnolia spp :: Magnolia 89 532 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
121835 28057 DPW Maintained 3 Magnolia spp :: Magnolia 89 33 Haight St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 4X4   6005944.78414 2109618.42708 37.77294627400379 -122.42285271058 (37.7729462740038, -122.42285271058)
128741 5427 DPW Maintained 3 Magnolia spp :: Magnolia 89 460X Dolores St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6004889.2026724005 2105697.5669461996 37.7621209168257 -122.42622490044901 (37.7621209168257, -122.426224900449)
93089 6779 DPW Maintained 3 Magnolia spp :: Magnolia 89 1355 Fairfax Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/17/2011 12:00:00 AM 3 3x3   6016787.8631263 2097291.0360598997 37.7397036915046 -122.38448604022699 (37.7397036915046, -122.384486040227)
24029 250142 DPW Maintained 3 Magnolia spp :: Magnolia 89 2550x Lyon St 10 Median : Yard 3 Tree 1 DPW 2     1     5999229.6006 2117622.80882 37.7945430395703 -122.44665726921801 (37.7945430395703, -122.446657269218)
89150 106270 Undocumented 2 Magnolia spp :: Magnolia 89 49 MISSOURI ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6013498.7 2106906.8 37.765924077220504 -122.39653250625 (37.7659240772205, -122.39653250625)
98423 6713 DPW Maintained 3 Magnolia spp :: Magnolia 89 1200X Fairfax Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/2015 11:14:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
166123 193439 Undocumented 2 Magnolia spp :: Magnolia 89 1301 Minnesota St 10 Front Yard : Yard 7 Tree 1 Private 1     1     6015387.42836 2102311.75717 37.753412005279294 -122.38967876317 (37.7534120052793, -122.38967876317)
90682 6716 DPW Maintained 3 Magnolia spp :: Magnolia 89 1200X Fairfax Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/2015 11:25:00 AM 3 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
13972 20404 DPW Maintained 3 Magnolia spp :: Magnolia 89 262X Sunset Blvd 49 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 64.651ms · Data source: data.sfgov.org