Street_Tree_List

Data source: data.sfgov.org

830 rows where qSpecies = 88 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

SiteOrder ✖

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
53993 53993 177425 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1764 Cayuga Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 8ft   5997936.35064 2088551.93116 37.7146476772225 -122.44903686276301 (37.7146476772225, -122.449036862763)
157255 157255 230354 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 531 30th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   6003165.5903900005 2098301.47872 37.7417154299181 -122.431658143201 (37.7417154299181, -122.431658143201)
181142 181142 208857 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1 Gennessee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5997408.7613699995 2093610.5667299998 37.7285073190505 -122.451225020336 (37.7285073190505, -122.451225020336)
5133 5133 242839 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1151 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 7ft   6005182.8356800005 2101610.74761 37.750916060132106 -122.424918561756 (37.7509160601321, -122.424918561756)
25560 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)
35824 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)
54511 54511 131009 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 150x Drumm St 4 Median : Yard 3 Tree 1 DPW 2     4 Width 7ft   6013684.354719999 2117443.2289299998 37.794865035532396 -122.396629040522 (37.7948650355324, -122.396629040522)
30883 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)
55977 55977 230279 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 529 Buchanan St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6004554.65684 2110370.74902 37.774933432055 -122.42771494250499 (37.774933432055, -122.427714942505)
112214 112214 230331 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 217 Montcalm St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 6ft   6009886.65194 2099610.71375 37.745688979177 -122.40851117835699 (37.745688979177, -122.408511178357)
27217 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)
37388 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)
37514 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)
54472 54472 230304 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3689 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6005034.41688 2104845.09352 37.7597884333033 -122.42566198362101 (37.7597884333033, -122.425661983621)
59160 59160 230296 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3500 19th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006123.351530001 2104947.42015 37.7601308699707 -122.421903157405 (37.7601308699707, -122.421903157405)
74024 74024 230292 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3500 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006199.95177 2104950.54929 37.760143781519496 -122.42163845546499 (37.7601437815195, -122.421638455465)
132124 132124 193349 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2501 18th St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6010309.72434 2105489.81742 37.761855376635104 -122.407462658778 (37.7618553766351, -122.407462658778)
153672 153672 230305 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3689 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6005047.22841 2104845.66376 37.7597907229735 -122.42561771539499 (37.7597907229735, -122.425617715395)
154138 154138 177445 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 15 Karen Ct 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6010506.33995 2091553.32971 37.723599800462296 -122.405800920297 (37.7235998004623, -122.405800920297)
157233 157233 208838 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1450 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5991176.37038 2105519.1814900003 37.7608464875004 -122.47363884617799 (37.7608464875004, -122.473638846178)
161500 161500 230295 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3500 19th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006165.1210199995 2104950.71502 37.7601422724637 -122.42175893043199 (37.7601422724637, -122.421758930432)
161888 161888 217796 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 21 Sloat Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   5991264.945169999 2095927.55542 37.7345154980788 -122.472633170284 (37.7345154980788, -122.472633170284)
165212 165212 230294 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3500 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006176.610669999 2104951.77673 37.760145835588006 -122.421719268545 (37.760145835588, -122.421719268545)
167402 167402 193327 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1398 Tennessee St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015585.429769999 2102602.25227 37.7542206208044 -122.38901430715799 (37.7542206208044, -122.389014307158)
184182 184182 230293 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3500 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006188.70146 2104951.15176 37.7601448013679 -122.42167740779301 (37.7601448013679, -122.421677407793)
23977 23977 177421 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 0 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6001079.38248 2091791.86287 37.7237230579705 -122.438405269984 (37.7237230579705, -122.438405269984)
25005 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)
28385 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)
32841 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)
33199 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)
39226 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 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 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)
42403 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)
44983 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)
45725 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)
46226 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)
47177 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)
48031 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)
48794 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)
53678 53678 193364 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 260 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013990.639330001 2116225.4508599997 37.791538343481605 -122.395483887876 (37.7915383434816, -122.395483887876)
54081 54081 193373 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 61 Beale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013783.27133 2116255.65231 37.7916097334637 -122.39620350109699 (37.7916097334637, -122.396203501097)
54394 54394 193368 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 262 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013947.275280001 2116186.44855 37.79142884020779 -122.395631194149 (37.7914288402078, -122.395631194149)
54565 54565 177434 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 131 Brussels St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6010258.4147 2094004.87757 37.7303173692474 -122.40683065573099 (37.7303173692474, -122.406830655731)
55251 55251 130983 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2200 Beach St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   5999604.2907300005 2120890.91469 37.8035377808009 -122.44559592174 (37.8035377808009, -122.44559592174)
57463 57463 193356 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 60 Main St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014000.33626 2116445.25726 37.7921424198756 -122.395465742269 (37.7921424198756, -122.395465742269)
60128 60128 250187 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 4 : 4 Tree 1 Private 1     1 Width 4ft   5997222.68042 2110871.6887 37.7758914096851 -122.453113845732 (37.7758914096851, -122.453113845732)
62272 62272 177397 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 650 France Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6002573.73742 2089477.3552599999 37.717452821874105 -122.433074256169 (37.7174528218741, -122.433074256169)
66770 66770 193362 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 246 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014011.61838 2116245.86436 37.7915955610366 -122.39541273082399 (37.7915955610366, -122.395412730824)
68072 68072 250185 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 2 : 4 Tree 1 Private 1     2 Width 4ft   5997218.614440001 2110901.95743 37.7759742867055 -122.453130096488 (37.7759742867055, -122.453130096488)
69630 69630 177417 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1x Rolph St 1 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   6000503.4246 2088653.73075 37.7150736797726 -122.440171325345 (37.7150736797726, -122.440171325345)
72311 72311 193321 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2111 18th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6011418.14714 2105550.13938 37.7620829860523 -122.403633286154 (37.7620829860523, -122.403633286154)
73056 73056 123366 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 780 04th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994765.69029 2110380.32738 37.774401141157796 -122.461577514019 (37.7744011411578, -122.461577514019)
73090 73090 123057 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 514 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5991919.1397400005 2111920.98536 37.778467110254795 -122.47153646453998 (37.7784671102548, -122.47153646454)
73543 73543 193322 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2111 18th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6011436.66428 2105551.33646 37.762087307318104 -122.403569326371 (37.7620873073181, -122.403569326371)
75476 75476 208842 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 168 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993717.6087 2099811.01881 37.7453201833801 -122.46443543703998 (37.7453201833801, -122.46443543704)
127114 127114 193361 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 246 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014025.95999 2116259.22664 37.7916330483898 -122.39536404513599 (37.7916330483898, -122.395364045136)
129880 129880 177446 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 323 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6003320.62443 2091964.27953 37.7243237043587 -122.43066997803999 (37.7243237043587, -122.43066997804)
130079 130079 193365 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 260 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6013979.60171 2116214.89575 37.7915087476865 -122.39552133835899 (37.7915087476865, -122.395521338359)
130198 130198 208841 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2134 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993696.59277 2101147.8080700003 37.74898945599679 -122.46460515623001 (37.7489894559968, -122.46460515623)
133119 133119 122152 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 263 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5991173.60125 2113665.4764900003 37.783213842540796 -122.474242864812 (37.7832138425408, -122.474242864812)
133388 133388 193370 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 262 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013935.48002 2116174.11264 37.791394312559596 -122.39567114113001 (37.7913943125596, -122.39567114113)
134263 134263 193367 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 262 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013957.97413 2116198.08841 37.791461395664896 -122.395594991931 (37.7914613956649, -122.395594991931)
134536 134536 193357 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 62 Main St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014010.133090001 2116432.89008 37.7921090073852 -122.395430978058 (37.7921090073852, -122.395430978058)
134678 134678 130980 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3001 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6003394.29695 2118690.35312 37.797711256726 -122.43232318378 (37.797711256726, -122.43232318378)
136274 136274 193319 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2111 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6011383.02095 2105548.33564 37.762076071170895 -122.403754647862 (37.7620760711709, -122.403754647862)
150941 150941 193359 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 208 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014052.912819999 2116289.5789400004 37.7917178877279 -122.39527291503299 (37.7917178877279, -122.395272915033)
151961 151961 177422 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 0 Santa Ynez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6001061.39064 2091803.12496 37.7237529577069 -122.438468271097 (37.7237529577069, -122.438468271097)
155447 155447 118202 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 744 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5985103.04881 2110791.51915 37.774969236334 -122.495032243047 (37.774969236334, -122.495032243047)
155809 155809 193320 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2111 18th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6011400.26798 2105549.24377 37.762079528159795 -122.403695060604 (37.7620795281598, -122.403695060604)
156067 156067 193372 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 61 Beale St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013792.54079 2116244.01793 37.791578303941705 -122.39617061288999 (37.7915783039417, -122.39617061289)
158279 158279 124566 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3943 Sacramento St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   5995914.73243 2114852.9465900003 37.7867478376308 -122.457926519067 (37.7867478376308, -122.457926519067)
159964 159964 193358 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 62 Main St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014021.3474 2116423.46881 37.79208376250261 -122.395391515812 (37.7920837625026, -122.395391515812)
160153 160153 193360 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 208 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014042.14131 2116274.34783 37.7916754675957 -122.395309117238 (37.7916754675957, -122.395309117238)
160542 160542 130984 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2200 Beach St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   5999592.955130001 2120888.49408 37.803530487293 -122.445634974783 (37.803530487293, -122.445634974783)
160548 160548 177398 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 650 France Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6002590.58454 2089466.88592 37.7174250310079 -122.433015275935 (37.7174250310079, -122.433015275935)
160936 160936 121810 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 106 19th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5989928.89895 2114601.72994 37.7857123459232 -122.478617478776 (37.7857123459232, -122.478617478776)
161578 161578 230318 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 107 Valley St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6005160.92225 2099293.15868 37.744551255839795 -122.424829478514 (37.7445512558398, -122.424829478514)
161633 161633 177444 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 15 Karen Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6010486.61044 2091547.46792 37.7235826018289 -122.40586870937 (37.7235826018289, -122.40586870937)
163844 163844 123126 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 771 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5992555.29457 2110202.5485900003 37.773785530078605 -122.469210678659 (37.7737855300786, -122.469210678659)
165271 165271 230308 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3795 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6005100.08631 2104263.85733 37.7581962060976 -122.42539350181801 (37.7581962060976, -122.425393501818)
169196 169196 250186 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 665 Parker Ave 3 : 4 Tree 1 Private 1     2 Width 4ft   5997220.39466 2110886.1472400003 37.7759309780695 -122.4531227967 (37.7759309780695, -122.4531227967)
169527 169527 193363 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 246 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6014000.9996 2116238.17517 37.791573857707704 -122.39544893303801 (37.7915738577077, -122.395448933038)
169605 169605 193341 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1751 22nd St 6 Side Yard : Yard 17 Tree 1 Private 1     2 Width 4ft   6012847.48484 2103764.38864 37.757259446178104 -122.398564409431 (37.7572594461781, -122.398564409431)
171396 171396 123367 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 780 04th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994765.802759999 2110367.1849 37.774365061862504 -122.461576171928 (37.7743650618625, -122.461576171928)
171575 171575 230321 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1297 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6003909.46951 2100753.0320099997 37.748488965296204 -122.42926082853901 (37.7484889652962, -122.429260828539)
172126 172126 193371 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 264 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013926.2454699995 2116163.52102 37.791364716756 -122.395702350277 (37.791364716756, -122.395702350277)
174129 174129 193351 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1752 Quesada Ave 2 : 4 Tree 1 Private 1     1 Width 4ft   6014452.02014 2095263.45344 37.734006920685204 -122.392420670182 (37.7340069206852, -122.392420670182)
174305 174305 130981 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3001 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6003397.35892 2118675.30556 37.797670113634794 -122.43231151328399 (37.7976701136348, -122.432311513284)
175002 175002 230325 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 30 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6004684.33252 2103302.03118 37.7555317594992 -122.426762864436 (37.7555317594992, -122.426762864436)
175968 175968 177426 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 125 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6003455.72001 2092686.0671599999 37.7263132250654 -122.430254442684 (37.7263132250654, -122.430254442684)
176448 176448 130979 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3001 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6003392.63825 2118710.5388700003 37.7977665875245 -122.432330365752 (37.7977665875245, -122.432330365752)
176873 176873 230285 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 112 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6005732.266 2100246.49817 37.7472011631029 -122.422921627052 (37.7472011631029, -122.422921627052)
184438 184438 119038 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 675 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5982249.27103 2111200.72651 37.7759253222044 -122.50493423498501 (37.7759253222044, -122.504934234985)
185939 185939 193350 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1752 Quesada Ave 1 : 4 Tree 1 Private 1     1 Width 4ft   6014471.5284 2095248.21375 37.7339661589078 -122.39235215802799 (37.7339661589078, -122.392352158028)
186109 186109 193366 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 260 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6013970.035680001 2116205.7483599996 37.7914830990039 -122.395553795767 (37.7914830990039, -122.395553795767)
2512 2512 178827 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 927 Brazil Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004338.08735 2090755.04432 37.7210610008535 -122.427066663506 (37.7210610008535, -122.427066663506)
2517 2517 178826 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 927 Brazil Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004356.8834 2090741.4764900003 37.7210248094256 -122.427000725205 (37.7210248094256, -122.427000725205)
3940 3940 179536 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1880 Alemany Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 10:42:00 AM 3 Width 3ft   6000969.55481 2091096.3953200001 37.7218072142025 -122.438735113438 (37.7218072142025, -122.438735113438)
5141 5141 237496 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 3927 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003620.49393 2101843.48933 37.751466742003295 -122.430337889878 (37.7514667420033, -122.430337889878)

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