Street_Tree_List

Data source: data.sfgov.org

830 rows where qSpecies = 88

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25005 177418 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 857 Dartmouth St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 4ft   6009516.77243 2090302.7647799999 37.720110619797104 -122.409133494811 (37.7201106197971, -122.409133494811)
25024 208840 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1350 Plymouth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5995903.3540199995 2092975.62657 37.7266776159651 -122.456383367909 (37.7266776159651, -122.456383367909)
25430 113267 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 83 Exeter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/16/2015 12:00:00 AM 2   Permit Number 774551 6012507.044369999 2090789.37208 37.7216138123142 -122.398831200496 (37.7216138123142, -122.398831200496)
25560 131008 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 150x Drumm St 3 Median : Yard 3 Tree 1 DPW 2     4 Width 7ft   6013685.844769999 2117434.71438 37.7948417395127 -122.396623287539 (37.7948417395127, -122.396623287539)
26519 115980 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
26535 177420 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 121 Cotter St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6001985.26237 2093449.7289900002 37.728326668619296 -122.435392337892 (37.7283266686193, -122.435392337892)
27017 230320 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 469 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002876.4268 2099458.33871 37.7448755037027 -122.432740595108 (37.7448755037027, -122.432740595108)
27217 230322 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 4089 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6003345.458190001 2100655.86235 37.7481902141138 -122.43120423378299 (37.7481902141138, -122.431204233783)
27684 208849 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 15 Santa Rita Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5993729.602000001 2100694.18749 37.7477458321253 -122.464458079273 (37.7477458321253, -122.464458079273)
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)
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)
28196 88382 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 355 17th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 2 3x3 Permit Number 51360 5990561.77007 2113010.94096 37.7813812065074 -122.476311706446 (37.7813812065074, -122.476311706446)
28385 230289 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3798 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6005260.07773 2101390.67485 37.750316153870294 -122.424635797817 (37.7503161538703, -122.424635797817)
28727 177449 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 324 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001907.3749400005 2086972.3844599999 37.7105369040276 -122.43519848992901 (37.7105369040276, -122.435198489929)
28898 250221 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 312 Filbert St 2 Side Yard : Yard 17 Tree 1 Private 1     8 Width 0ft   6011282.00764 2120080.85256 37.8019733165766 -122.405127362244 (37.8019733165766, -122.405127362244)
29022 208856 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 331 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   5999876.46994 2094937.06877 37.732290569037104 -122.44278926080901 (37.7322905690371, -122.442789260809)
29464 230344 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1801 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004583.81865 2098292.85658 37.7417720422523 -122.426753765994 (37.7417720422523, -122.426753765994)
29562 193317 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 136 Hawthorne St 3 : 4 Tree 1 Private 1     9 Width 2ft   6013319.34244 2113654.62795 37.7844421016727 -122.397626191699 (37.7844421016727, -122.397626191699)
29718 130970 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2801 Webster St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   6002945.56276 2118345.7946599997 37.796739734404 -122.433851284829 (37.796739734404, -122.433851284829)
29927 83659 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 559 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/03/2005 12:00:00 AM 6     6001685.54257 2090383.4533900002 37.7198903425557 -122.436209138162 (37.7198903425557, -122.436209138162)
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)
30218 208836 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1677 18th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5990563.73281 2104000.71919 37.756641694668396 -122.47564678406499 (37.7566416946684, -122.475646784065)
30570 193337 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1270 Minnesota St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6015308.479069999 2102559.27559 37.7540872603324 -122.389969077812 (37.7540872603324, -122.389969077812)
30883 119446 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 881 32nd Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   5986011.18097 2109924.94508 37.7726429911374 -122.49182705320801 (37.7726429911374, -122.491827053208)
31120 131005 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1109 Sansome St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6011966.28047 2119507.31076 37.8004367394276 -122.40271908303001 (37.8004367394276, -122.40271908303)
31130 177416 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 538 Madrid St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6002518.22292 2090772.4099400002 37.721005605292504 -122.433358634398 (37.7210056052925, -122.433358634398)
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)
32597 130988 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008672.99088 2115994.19666 37.7906061691929 -122.41386657548 (37.7906061691929, -122.41386657548)
32841 193369 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 262 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013943.1918 2116180.78279 37.791413056208704 -122.39564492587601 (37.7914130562087, -122.395644925876)
32904 130968 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 95 Heather Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     5997356.6821800005 2113906.91877 37.7842330344764 -122.45286943159799 (37.7842330344764, -122.452869431598)
32960 124335 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 176 Palm Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 2ft   5995959.20478 2113110.98096 37.78196742074471 -122.457646568088 (37.7819674207447, -122.457646568088)
33199 193347 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 444 Mississippi St 1 : 4 Tree 1 Private 1     10 Width 4ft   6014042.11061 2105043.11718 37.760837039231205 -122.394522434371 (37.7608370392312, -122.394522434371)
33296 110565 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 135 Theresa St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x9   6002103.512680001 2093689.48997 37.728991712774295 -122.43500068223301 (37.7289917127743, -122.435000682233)
33482 230350 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 35 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002643.63835 2096299.62877 37.7361892128574 -122.433319865541 (37.7361892128574, -122.433319865541)
33867 70607 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1256 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/13/1994 12:00:00 AM 9     6007485.00571 2115457.39575 37.78906545695621 -122.41793887748301 (37.7890654569562, -122.417938877483)
34070 177396 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 650 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002554.32379 2089489.05378 37.7174838421787 -122.433142195459 (37.7174838421787, -122.433142195459)
34177 177411 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 474 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6003775.47727 2089725.4167 37.7182020389599 -122.42893807173 (37.7182020389599, -122.42893807173)
34364 177430 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 294 Ney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6005292.64234 2094059.9977799999 37.730189610640004 -122.424001946647 (37.73018961064, -122.424001946647)
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)
34714 177431 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 268 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6005673.422730001 2092431.0022599997 37.7257382372047 -122.42256982665 (37.7257382372047, -122.42256982665)
34741 230311 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2901 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009504.69694 2104506.09173 37.7591091969416 -122.41017748630101 (37.7591091969416, -122.410177486301)
34906 120793 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 559 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5989373.68445 2111524.6737 37.7772313596652 -122.48031303988998 (37.7772313596652, -122.48031303989)
35331 193332 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1258 Minnesota St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6015304.05705 2102667.26372 37.7543835276007 -122.38999191341999 (37.7543835276007, -122.38999191342)
35817 83433 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 760 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/03/2005 12:00:00 AM 4     6000998.571 2089370.50235 37.7170699516967 -122.43851121642099 (37.7170699516967, -122.438511216421)
35821 130973 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2801 Webster St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   6002952.36205 2118301.89076 37.796619571497104 -122.43382461811501 (37.7966195714971, -122.433824618115)
35824 131007 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 150x Drumm St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 7ft   6013687.07221 2117423.5151299997 37.7948110573238 -122.396618254944 (37.7948110573238, -122.396618254944)
36033 177437 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 93 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010115.68283 2091447.6223799998 37.72328769526371 -122.407143912081 (37.7232876952637, -122.407143912081)
36370 130994 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 800 Lombard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008432.69085 2120383.1883 37.8026437557674 -122.41500878732401 (37.8026437557674, -122.415008787324)
36589 177408 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 638 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6002397.88484 2090069.70643 37.71906931008821 -122.43372440936301 (37.7190693100882, -122.433724409363)
36649 177403 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 688 Vienna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002695.8436900005 2089531.77748 37.7176091789075 -122.432656076817 (37.7176091789075, -122.432656076817)
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)
36826 218387 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 50 San Marcos Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5993857.52408 2100226.90247 37.746470159084396 -122.46398181990101 (37.7464701590844, -122.463981819901)
37388 123549 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 65 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   5994237.46417 2115165.09446 37.7875084040974 -122.46375209006099 (37.7875084040974, -122.463752090061)
37460 230298 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 613 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009857.38844 2105338.70025 37.761415114429795 -122.409016453452 (37.7614151144298, -122.409016453452)
37487 177439 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 79 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010188.86492 2091471.00105 37.7233559834822 -122.406892581232 (37.7233559834822, -122.406892581232)
37514 193348 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2501 18th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6010227.27367 2105486.95448 37.7618429003376 -122.407747622459 (37.7618429003376, -122.407747622459)
38082 131000 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 937 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007889.3393 2120258.1981200003 37.8022700164033 -122.416880201885 (37.8022700164033, -122.416880201885)
38105 177410 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 470 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6003782.11139 2089736.37793 37.718232511606296 -122.428915921448 (37.7182325116063, -122.428915921448)
38343 122390 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1958 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x2   5991007.0 2102078.0 37.7513881006776 -122.47397354599501 (37.7513881006776, -122.473973545995)
38918 87076 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2565 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/2007 12:00:00 AM 3 3x3 Permit Number 50014 6006601.66741 2120051.34913 37.8016295480248 -122.421321483111 (37.8016295480248, -122.421321483111)
38961 230341 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 65 Chenery St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6004909.36728 2097888.2006599996 37.7406793497697 -122.425599332346 (37.7406793497697, -122.425599332346)
39201 177424 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 85 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000559.946819999 2092109.10715 37.7245645787726 -122.440223605655 (37.7245645787726, -122.440223605655)
39226 230287 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3798 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6005284.60936 2101393.03847 37.750324029253505 -122.42455113382299 (37.7503240292535, -122.424551133823)
39423 193355 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 60 Main St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6013990.6766 2116456.52969 37.792172834057496 -122.39549995516701 (37.7921728340575, -122.395499955167)
39525 208855 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 358 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5999047.687609999 2095262.2243 37.7331360864596 -122.445677914709 (37.7331360864596, -122.445677914709)
39564 120406 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 619 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5988769.80583 2111094.18017 37.7760142347438 -122.48237047472901 (37.7760142347438, -122.482370474729)
40091 95676 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 232 Goettingen St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2011 12:00:00 AM 3 3x3 Permit Number 767428 6010063.65694 2093465.1071400002 37.7288243741431 -122.407465923318 (37.7288243741431, -122.407465923318)
40468 114753 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 10 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/2015 12:00:00 AM 1   Permit Number 777133 6010495.976919999 2091580.43732 37.723673652787596 -122.40583865223101 (37.7236736527876, -122.405838652231)
40529 230283 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 626 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010353.7895 2105370.3020900004 37.761529680867 -122.40730182853201 (37.761529680867, -122.407301828532)
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)
41811 108815 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 474 Munich St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774652 6003779.44726 2089723.3814299998 37.7181966752665 -122.42892420414499 (37.7181966752665, -122.428924204145)
41960 177441 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 71 Karen Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010258.66598 2091491.8701799999 37.7234171913236 -122.406652760812 (37.7234171913236, -122.406652760812)
42139 230337 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 823 Castro St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002470.86224 2103420.79735 37.7557324674964 -122.43442621241199 (37.7557324674964, -122.434426212412)
42297 80634 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 577 Arkansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/2002 12:00:00 AM 1     6013018.0309 2104352.7115 37.758884352052604 -122.398015861652 (37.7588843520526, -122.398015861652)
42403 124334 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 176 Palm Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 4ft   5995958.15323 2113125.95358 37.782008471168 -122.457651289636 (37.782008471168, -122.457651289636)
42961 193318 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 136 Hawthorne St 4 : 4 Tree 1 Private 1     10 Width 2ft   6013332.96782 2113640.4980900004 37.7844040630434 -122.397578060899 (37.7844040630434, -122.397578060899)
43019 130992 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1645 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006789.62412 2117015.0975 37.7933033592027 -122.420455425186 (37.7933033592027, -122.420455425186)
43609 177447 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 762 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002442.748380001 2087164.23323 37.711094066412294 -122.433361825211 (37.7110940664123, -122.433361825211)
43802 65195 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 277 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1989 12:00:00 AM 2   Permit Number 27179 6002900.88646 2091805.0724099998 37.723862768534104 -122.432109587587 (37.7238627685341, -122.432109587587)
44168 177405 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 688 Vienna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002677.6930599995 2089500.91725 37.71752341415829 -122.432716611994 (37.7175234141583, -122.432716611994)
44551 230342 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 65 Chenery St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6004911.05921 2097907.1085200002 37.740731362062704 -122.42559482765499 (37.7407313620627, -122.425594827655)
44581 177415 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 451 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6003094.686869999 2091098.4419099998 37.7219335042119 -122.431389232421 (37.7219335042119, -122.431389232421)
44983 250184 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 1 : 4 Tree 1 Private 1     2 Width 4ft   5997216.13133 2110917.44789 37.7760166771611 -122.45313980466699 (37.7760166771611, -122.453139804667)
45125 193342 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 401 Texas St 4 : 4 Tree 1 Private 1     1 Width 3ft   6013812.69862 2105193.07398 37.7612360315304 -122.39532637971901 (37.7612360315304, -122.395326379719)
45146 177401 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 263 Dublin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003956.36283 2088919.05641 37.7159981864394 -122.42825539008601 (37.7159981864394, -122.428255390086)
45211 193377 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 250 10th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008648.26214 2109663.47426 37.773222132835706 -122.41350420897899 (37.7732221328357, -122.413504208979)
45272 98453 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 518 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/15/2012 12:00:00 AM 2 3x3 Permit Number 768642 6014340.87186 2104676.4561900003 37.7598468721503 -122.393463482668 (37.7598468721503, -122.393463482668)
45642 131006 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 25 Joice St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6010297.06637 2116294.60935 37.7915221044126 -122.40826853856599 (37.7915221044126, -122.408268538566)
45725 130982 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3601 Broderick St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5999659.44076 2120919.3234599996 37.8036189320344 -122.44540711714701 (37.8036189320344, -122.445407117147)
45916 99538 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 801X Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/2012 12:00:00 AM 1 3x3 Permit Number 768631 5999563.7 2111218.2 37.776976730821794 -122.445040600733 (37.7769767308218, -122.445040600733)
46226 230288 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3798 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6005272.34355 2101391.85682 37.7503200920091 -122.424593465816 (37.7503200920091, -122.424593465816)
46349 177433 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 439 Bowdoin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008733.06168 2093861.6141400002 37.7298385306021 -122.412093908309 (37.7298385306021, -122.412093908309)
47177 177448 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1022 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6001291.58576 2086844.2282099999 37.7101500273691 -122.437317616421 (37.7101500273691, -122.437317616421)
47863 177393 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1657 Sunnydale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   6006855.18138 2087491.9955900002 37.7122433757141 -122.41813457086599 (37.7122433757141, -122.418134570866)
48031 130967 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 213 Walnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5998523.7164 2115638.03819 37.7890530400256 -122.448956666639 (37.7890530400256, -122.448956666639)
48337 230332 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 73 Leese St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6005526.20735 2096295.99594 37.736342348511 -122.423353372654 (37.736342348511, -122.423353372654)
48794 193328 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 900 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6015574.56777 2102562.74505 37.7541115402303 -122.389049112743 (37.7541115402303, -122.389049112743)
49119 65035 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1205 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51820 6003879.11104946 2101261.18670708 37.7498825208731 -122.429402039878 (37.7498825208731, -122.429402039878)
49125 84779 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 224 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/2007 12:00:00 AM 3   Permit No. 49287 6013986.61648 2106050.38487 37.7635996908854 -122.394784908699 (37.7635996908854, -122.394784908699)
49219 247756 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 52 Alpine Ter 2 : 4 Tree 1 Private 1     3 Width 3ft   6001615.48849 2108494.65039 37.7696154359451 -122.437747736977 (37.7696154359451, -122.437747736977)

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