Street_Tree_List

Data source: data.sfgov.org

830 rows where qSpecies = 88 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
21415 136 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1025X 14th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 3X3   6001971.14414 2107605.72409 37.767194880067294 -122.436453906645 (37.7671948800673, -122.436453906645)
119795 450 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 700x 23rd Ave 10 Median : Cutout 11 Tree 1 DPW 2   05/29/2015 01:42:00 PM 3     5988819.93055 2110324.8097900003 37.773904673102 -122.48214070454901 (37.773904673102, -122.482140704549)
103588 1922 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 66 Berkeley Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2016 02:50:00 PM 3 3x3   6001235.3932896 2097346.6778621003 37.7389841732277 -122.43826372276199 (37.7389841732277, -122.438263722762)
17580 4334 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 852 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6001755.94767 2095865.71194 37.7349473777015 -122.436357925586 (37.7349473777015, -122.436357925586)
6833 4378 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2425X Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6006994.61601 2120672.53629 37.803357316535795 -122.42000580642201 (37.8033573165358, -122.420005806422)
22057 5393 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 347 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/10/2014 12:00:00 AM 3 6x7   6004928.4905 2106245.9446799997 37.7636288523174 -122.426128059965 (37.7636288523174, -122.426128059965)
17962 5397 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 347 Dolores St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/10/2014 12:00:00 AM 30 6x6   6004921.39011 2106378.39566 37.7639921298444 -122.42616204806002 (37.7639921298444, -122.42616204806)
84429 5717 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1647 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/2008 12:00:00 AM 3 3X3   6005332.0180626 2098744.9227683996 37.7430555871926 -122.424198880257 (37.7430555871926, -122.424198880257)
505 6741 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1300X Fairfax Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 01:50:00 PM 3 3x3   6016924.03316 2097256.8815900004 37.739617439282604 -122.38401284003099 (37.7396174392826, -122.384012840031)
500 6742 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1300X Fairfax Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 01:53:00 PM 3 3x3   6016901.500630001 2097278.26947 37.7396749203573 -122.384092237585 (37.7396749203573, -122.384092237585)
9836 6755 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1215 Fairfax Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/03/2017 06:41:00 AM 3 3x3   6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
143719 8223 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1500X Galvez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/10/2015 08:24:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
81549 8225 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1500X Galvez Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/10/2015 08:37:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
116957 8230 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1500X Galvez Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/10/2015 08:33:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
103533 12529 Private 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 105 Lake St 1 Front Yard : Cutout 8 Tree 1 Private 1 FUF 1 07/12/2004 12:00:00 AM 6 3x3 Permit Number 773769 5995136.95364 2114887.49287 37.78679797610221 -122.460619935074 (37.7867979761022, -122.460619935074)
111710 12532 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 120 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 6x7.4   5995061.5103400005 2114935.24706 37.7869247555074 -122.460884411661 (37.7869247555074, -122.460884411661)
101009 12725 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1544 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/07/2003 12:00:00 AM 3 3X3   5990592.796680001 2114771.31925 37.7862165141869 -122.476332998319 (37.7862165141869, -122.476332998319)
4168 13059 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 583 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/2015 07:23:00 AM 3 2x2   6009557.0524 2120495.5376 37.8030153566132 -122.41112585507 (37.8030153566132, -122.41112585507)
143305 13238 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2322 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/15/1998 12:00:00 AM 3 3X3   6001219.43305 2119376.81704 37.7994725475626 -122.439898035919 (37.7994725475626, -122.439898035919)
23030 17382 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1627 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/21/2015 12:00:00 AM 1 3X3 Permit Number 776412 6014690.32946 2095358.97831 37.7342824432881 -122.39160343105 (37.7342824432881, -122.39160343105)
117870 17877 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2189 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3X3   6003478.4464424 2115194.6078963 37.7881176060092 -122.431782277912 (37.7881176060092, -122.431782277912)
6628 17981 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2583 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/28/2014 12:00:00 AM 3 3x3   6001557.63 2114929.1565 37.7872796746141 -122.438408931359 (37.7872796746141, -122.438408931359)
90740 18413 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 799X Potrero Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/05/2013 12:00:00 AM 3 4X4   6010481.346466599 2104567.7087473 37.759333078347105 -122.406804093165 (37.7593330783471, -122.406804093165)
89613 24369 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 134 Duboce Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/19/2016 04:44:00 AM 3 3x3   6005829.420761799 2108507.0022787 37.7698880583785 -122.42317275016899 (37.7698880583785, -122.423172750169)
116356 26561 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 430 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/10/2007 12:00:00 AM 3 3X3   6010306.750370901 2097855.6706051 37.740893529599106 -122.406934857164 (37.7408935295991, -122.406934857164)
84281 26689 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1295X Pierce St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4X4   6002245.89461 2112942.9215 37.7818651028046 -122.435885513106 (37.7818651028046, -122.435885513106)
10311 27188 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 258 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/2002 12:00:00 AM 5 2X3   6002908.14927 2093727.2885 37.729141154025506 -122.43222169348999 (37.7291411540255, -122.43222169349)
56020 30506 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3615 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/1998 12:00:00 AM 6   Permit Number 40581 5997549.204530001 2115073.9457400003 37.787448412048604 -122.45228761430599 (37.7874484120486, -122.452287614306)
83616 30531 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 100 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/1986 12:00:00 AM 2 3x3 Permit Number 34534 5989617.18715 2114630.7338900003 37.7857738797228 -122.479698023599 (37.7857738797228, -122.479698023599)
41605 30800 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 199 Burnside Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1995 12:00:00 AM 4   Permit Number 34666 6001059.22701 2095245.3674599999 37.7332044430184 -122.438722291799 (37.7332044430184, -122.438722291799)
181062 31608 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 5 Lucerne St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/1995 12:00:00 AM 4   Permit Number 35133 6012020.8525 2109827.45516 37.7738611793697 -122.401849428724 (37.7738611793697, -122.401849428724)
52436 31977 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 134 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/1995 12:00:00 AM 7   Permit Number 35376 5995230.64434 2114664.73917 37.7861917443429 -122.460279644251 (37.7861917443429, -122.460279644251)
137110 32048 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 167 Stillings Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/1995 12:00:00 AM 10   Permit Number 35429 5999662.091580001 2095748.4383599998 37.7345061757178 -122.443588678099 (37.7345061757178, -122.443588678099)
2326 32310 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 600 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.21346 2105535.41825 37.762046590490705 -122.40338299943899 (37.7620465904907, -122.403382999439)
173281 32337 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2626 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/03/1996 12:00:00 AM 3   Permit Number 36899 5995236.946330001 2110306.39824 37.7742252654946 -122.459942005265 (37.7742252654946, -122.459942005265)
77021 32342 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 130 Lexington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/20/1998 12:00:00 AM 1   Permit Number 770451 6006450.269730001 2105316.80145 37.761163536302206 -122.420798725186 (37.7611635363022, -122.420798725186)
91749 32526 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 871 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2015 12:00:00 AM     Permit Number 776214 6007576.4663397 2095282.92697428 37.733676184028795 -122.416193025137 (37.7336761840288, -122.416193025137)
144271 33553 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 238 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/09/2010 12:00:00 AM   3x3 Permit Number 53983 6007052.33241005 2097631.90832878 37.740096482896 -122.418171592585 (37.740096482896, -122.418171592585)
16526 33774 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013834.28126 2116198.48682 37.791455608540396 -122.396022998165 (37.7914556085404, -122.396022998165)
14755 33779 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013803.37475 2116233.23226 37.79154929181811 -122.396132371028 (37.7915492918181, -122.396132371028)
13895 33780 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013824.14126 2116210.79912 37.7914888510795 -122.39605894586 (37.7914888510795, -122.39605894586)
16231 33782 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013852.02109 2116179.41654 37.7914042329729 -122.395960281264 (37.7914042329729, -122.395960281264)
14247 33783 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013842.9233800005 2116188.62598 37.7914290137913 -122.395992405042 (37.7914290137913, -122.395992405042)
13642 33785 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013812.6799 2116223.3583 37.7915226979635 -122.39609948281701 (37.7915226979635, -122.396099482817)
16533 33792 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013856.54517 2116173.60161 37.7913885182281 -122.395944220262 (37.7913885182281, -122.395944220262)
14233 33800 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 77 Beale St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013865.37275 2116161.97621 37.7913570887062 -122.39591286179899 (37.7913570887062, -122.395912861799)
178157 34926 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2625 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/31/2012 12:00:00 AM 4   Permit Number 768761 5999600.82758 2117890.72086 37.795299853268205 -122.445392054402 (37.7952998532682, -122.445392054402)
172672 34927 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2625 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/31/2012 12:00:00 AM 3   Permit Number 768761 5999601.94789 2117876.9745400003 37.7952621734732 -122.44538718908301 (37.7952621734732, -122.445387189083)
53628 34942 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 462 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1997 12:00:00 AM 8   Permit Number 38539 5995310.64413 2112404.55918 37.7799904974934 -122.459839088006 (37.7799904974934, -122.459839088006)
134484 34949 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1246 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/18/1995 12:00:00 AM 8   Permit Number 38547 6007519.4935099995 2115461.74269 37.7890793334842 -122.417819862092 (37.7890793334842, -122.417819862092)
127785 37585 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 210 Eagle St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM     Permit Number 40016 5999628.99810136 2104552.86123042 37.758679112173205 -122.444335603116 (37.7586791121732, -122.444335603116)
124483 37803 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 465 Woolsey St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/02/2015 12:00:00 AM     Permit Number 774759 6010402.90992445 2091781.87036726 37.7242215408534 -122.406174555323 (37.7242215408534, -122.406174555323)
22989 37859 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 127 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2004 12:00:00 AM 6   Permit Number 47618 6004006.380580001 2093054.46604 37.7273559413142 -122.42837708183399 (37.7273559413142, -122.428377081834)
56984 38711 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2000 McAllister St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2012 12:00:00 AM 1   Permit Number 768631 5999529.3553 2111223.7902 37.7769901198015 -122.44515981121201 (37.7769901198015, -122.445159811212)
27791 38712 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2000 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2012 12:00:00 AM 1   Permit Number 768631 5999544.5843 2111225.8207 37.7769965642688 -122.44510727559799 (37.7769965642688, -122.445107275598)
188880 38814 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 286 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/2008 12:00:00 AM 4 3x3 Permit Number 51147 5995268.26088 2113665.38834 37.7834499595789 -122.460077076847 (37.7834499595789, -122.460077076847)
89634 39742 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 4248 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50468 6002277.29168205 2104153.16512299 37.7577323837885 -122.435148020003 (37.7577323837885, -122.435148020003)
108546 41047 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1394 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/15/2010 12:00:00 AM   3x3 Permit Number 53732 5999600.05829403 2107789.40004447 37.767564190631106 -122.444668318417 (37.7675641906311, -122.444668318417)
184009 41941 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 646 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 10   Permit Number 42299 5994427.444490001 2111105.89465 37.7763738805691 -122.46280020914 (37.7763738805691, -122.46280020914)
153325 43146 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 243 Gambier St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/01/2015 12:00:00 AM 1   Permit Number 774635 6005976.40354 2092622.5546099998 37.7262812865364 -122.421536041574 (37.7262812865364, -122.421536041574)
72897 43147 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 249 Gambier St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2011 12:00:00 AM 4 3x3 Permit Number 767437 6005979.23995 2092615.6379200001 37.7262624547464 -122.421525745221 (37.7262624547464, -122.421525745221)
180774 43160 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 261 Harvard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2011 12:00:00 AM 4 3x3 Permit Number 767438 6006282.82959 2092642.1581700002 37.7263523869376 -122.42047813126499 (37.7263523869376, -122.420478131265)
106292 43751 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 255 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/24/2015 12:00:00 AM 3   Permit Number 773834 5991170.79793 2113718.28394 37.7833586747671 -122.474256417664 (37.7833586747671, -122.474256417664)
34611 45681 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 440 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2001 12:00:00 AM 8   Permit Number 44368 6014041.208930001 2105068.9613799998 37.760907951647795 -122.39452736264099 (37.7609079516478, -122.394527362641)
174893 46093 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 100 19th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2001 12:00:00 AM 4   Permit Number 44465 5989926.67635 2114640.8160200003 37.785819536272 -122.478628027687 (37.785819536272, -122.478628027687)
98602 46567 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3900 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51812 6002455.82917315 2102994.91492425 37.754562242839704 -122.43444775294701 (37.7545622428397, -122.434447752947)
122771 46568 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3900 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51812 6002455.82917315 2102994.91492425 37.754562242839704 -122.43444775294701 (37.7545622428397, -122.434447752947)
53463 47067 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 604 Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2012 12:00:00 AM 1   Permit Number 768780 6004041.40702 2110873.30571 37.7762842830232 -122.429526231047 (37.7762842830232, -122.429526231047)
149654 47068 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 604 Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2012 12:00:00 AM 1   Permit Number 768780 6004042.80919 2110860.8938 37.7762502823647 -122.429520495178 (37.7762502823647, -122.429520495178)
142314 47094 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 336 Willard North St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2008 12:00:00 AM   3x3 Permit Number 51142 5996292.61494047 2110619.69439374 37.775146151844794 -122.456312937477 (37.7751461518448, -122.456312937477)
52541 47432 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 432 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 2   Permit Number 45343 5982855.38785 2112869.9347900003 37.7805441204791 -122.50296115463001 (37.7805441204791, -122.50296115463)
29955 48772 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 766 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/22/2002 12:00:00 AM 2   Permit Number 46029 5987276.54902 2110739.79263 37.7749542102717 -122.48750993680099 (37.7749542102717, -122.487509936801)
87428 49067 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1298 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/2008 12:00:00 AM   3x3 Permit Number 50555 5995836.31315767 2092013.47244835 37.724031921729704 -122.45654557668001 (37.7240319217297, -122.45654557668)
36801 49512 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1928& 21st AVE Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/2003 12:00:00 AM 4   Permit Number 46417 5989493.41802 2113376.93915 37.7823241210106 -122.480034435471 (37.7823241210106, -122.480034435471)
103390 49736 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 251 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM 3 3x12 Permit Number 46536 5987104.42255848 2114202.9919751 37.7844531321546 -122.488359918659 (37.7844531321546, -122.488359918659)
90183 49737 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 251 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2003 12:00:00 AM 3 3x12 Permit Number 46536 5987104.42255848 2114202.9919751 37.7844531321546 -122.488359918659 (37.7844531321546, -122.488359918659)
153237 50024 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1704 Felton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM 3   Permit Number 46757 6005953.2164199995 2092396.45471 37.725659158041104 -122.421600147046 (37.7256591580411, -122.421600147046)
60907 50426 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 250 Howth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/12/2014 12:00:00 AM 3   Permit Number 773627 5997303.25557645 2090612.9654569 37.7202705700793 -122.45137364778 (37.7202705700793, -122.45137364778)
66641 50836 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 202 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742)
129492 50837 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 202 Kirkham St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742)
51726 51497 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 741 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/18/2008 12:00:00 AM 6 3x3 Permit Number 50950 6009247.81044 2119754.33215 37.80096284371879 -122.412143582356 (37.8009628437188, -122.412143582356)
86132 51656 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 949 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50463 6003796.70592748 2102740.00151399 37.7539383334149 -122.42979246604999 (37.7539383334149, -122.42979246605)
145621 51877 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 4200 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50819 6002010.54318716 2105309.8458945 37.760893198333704 -122.436153317055 (37.7608931983337, -122.436153317055)
118340 52314 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 4284 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2008 12:00:00 AM 3 3x3 Permit Number 50258 6001331.50265799 2102347.48483234 37.7527206699479 -122.438289584359 (37.7527206699479, -122.438289584359)
97155 52415 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 445 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50993 5997805.99655674 2094075.37872241 37.729806319232004 -122.44988524851401 (37.729806319232, -122.449885248514)
110911 52432 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1890 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51617 6004399.67181712 2115311.0350232 37.7884894628626 -122.42860329951401 (37.7884894628626, -122.428603299514)
27994 52460 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 682@ CABRILLO 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2005 12:00:00 AM 1   Permit Number 48571 5992268.12798 2110826.06835 37.775480948973396 -122.470249439229 (37.7754809489734, -122.470249439229)
71256 52791 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 955@ MOSCOW Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM 1   Permit Number 48832 6004754.52241 2091271.3997400003 37.7225023397811 -122.425663900979 (37.7225023397811, -122.425663900979)
2327 53079 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 600 Kansas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.70702 2105522.9440900004 37.7620123668039 -122.4033804148 (37.7620123668039, -122.4033804148)
86466 53191 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 720@ 20TH ST. Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50943 6002391.64717096 2103940.90451156 37.757156060155104 -122.434737353785 (37.7571560601551, -122.434737353785)
31482 53932 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 140 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/1972 12:00:00 AM 1   Permit Number 9646 5993064.176969999 2114524.47346 37.785681755762894 -122.46776478269899 (37.7856817557629, -122.467764782699)
122922 55172 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3599X 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2013 12:00:00 AM     Permit Number 11079 6002961.15352471 2106486.99776749 37.7641793352608 -122.432949678981 (37.7641793352608, -122.432949678981)
68884 55891 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1981 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/24/1979 12:00:00 AM 4   Permit Number 17936 6003525.54431 2118603.6465 37.7974806237872 -122.43186283789801 (37.7974806237872, -122.431862837898)
179016 56947 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 690 Arkansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/1974 12:00:00 AM 5   Permit Number 14199 6012986.78866 2103864.51855 37.7575421408828 -122.398089663624 (37.7575421408828, -122.398089663624)
110256 57018 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 73 Henry St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/16/1974 12:00:00 AM 3 3x3 Permit Number 14277 6003050.12162516 2107377.07151823 37.766628307485 -122.43270555008101 (37.766628307485, -122.432705550081)
52442 59600 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1116 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/26/1981 12:00:00 AM 9   Permit Number 19001 6015518.08801 2103793.04215 37.757486543884 -122.389330342431 (37.757486543884, -122.389330342431)
14678 59614 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1014 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2011 12:00:00 AM 3 3x3 Permit Number 767137 6015492.62077 2104343.80938 37.7589974211239 -122.389456881532 (37.7589974211239, -122.389456881532)
66302 61318 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1419 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/02/2014 12:00:00 AM 1   Permit Number 772899 6011764.55732 2101642.9103 37.751373940974204 -122.402160470048 (37.7513739409742, -122.402160470048)
156259 61491 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 178 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/11/1990 12:00:00 AM 3   Permit Number 28869 5989634.7512 2114171.8446400003 37.784514919234205 -122.47960366993601 (37.7845149192342, -122.479603669936)
164563 61691 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 61 Lucy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1992 12:00:00 AM 4   Permit Number 31258 6014147.06906 2093799.2682599998 37.7299696274983 -122.393372558494 (37.7299696274983, -122.393372558494)

Next page

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 494.197ms · Data source: data.sfgov.org