Street_Tree_List

Data source: data.sfgov.org

5,685 rows where qSpecies = 32 sorted by PlantDate descending

View and edit SQL

Suggested facets: qLegalStatus, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▲ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
14496 843 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 111X Potrero Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2015 12:00:00 AM 40 3x3 Permit Number 777000 6010316.34076 2107575.5688099996 37.7675827459718 -122.407586838062 (37.7675827459718, -122.407586838062)
16748 18307 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 111 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2015 12:00:00 AM 18 3x3 Permit Number 777000 6010317.92211 2107539.48864 37.7674837665976 -122.407578824211 (37.7674837665976, -122.407578824211)
6046 69534 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2471 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/1997 12:00:00 AM 5 3x3 Permit Number 38589 6002877.05945 2116466.93377 37.7915769792578 -122.433953952308 (37.7915769792578, -122.433953952308)
46706 68915 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1707 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 14   Permit Number 32895 6008302.71306 2118323.38129 37.7969807347398 -122.41531267543999 (37.7969807347398, -122.41531267544)
161811 68946 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 763 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 11   Permit Number 32935 5989112.30351 2110126.59265 37.773377424717104 -122.481114833001 (37.7733774247171, -122.481114833001)
105032 44208 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2159 Bay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2000 12:00:00 AM 6   Permit Number 43656 6000484.20256 2120266.2645799997 37.8018728542015 -122.442506081411 (37.8018728542015, -122.442506081411)
150173 39559 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 877 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1998 12:00:00 AM 10   Permit Number 40981 6012176.17162 2104320.1117700003 37.7587479168064 -122.40092513068899 (37.7587479168064, -122.400925130689)
23118 81902 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1855X Evans Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2012 12:00:00 AM 6 3x3 Permit Number 769738 6014398.74448 2099411.75035 37.7453943270819 -122.392894990609 (37.7453943270819, -122.392894990609)
148353 61256 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1828 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/1983 12:00:00 AM 10   Permit Number 21139 6007811.10071 2118708.12842 37.79800951239079 -122.41704105189699 (37.7980095123908, -122.417041051897)
184468 48434 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1190 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/25/2005 12:00:00 AM 10 3x3 Permit Number 45810 6009120.00947 2116723.6961 37.7926342914851 -122.412371495743 (37.7926342914851, -122.412371495743)
148386 35016 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 636 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/24/1997 12:00:00 AM 10   Permit Number 38588 6010422.28275 2115868.19949 37.79035829625379 -122.40780520873699 (37.7903582962538, -122.407805208737)
92647 59124 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 758 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3   Permit Number 773782 5992918.14123 2110285.54239 37.7740343688165 -122.46796158292801 (37.7740343688165, -122.467961582928)
118588 58851 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 615 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/20/1979 12:00:00 AM   3x3 Permit Number 18110 6008337.394024299 2114564.58255444 37.7866619441951 -122.414926498345 (37.7866619441951, -122.414926498345)
187480 71692 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 364 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/1981 12:00:00 AM 26 6x7   6006147.03421 2111101.3621799997 37.777029465781496 -122.422258481339 (37.7770294657815, -122.422258481339)
28747 46103 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2744 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/2001 12:00:00 AM 13   Permit Number 44469 5999905.69247 2117801.50671 37.795072293301395 -122.44433076175899 (37.7950722933014, -122.444330761759)
66363 60560 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 563 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM 15   Permit Number 20170 5985010.58842 2112038.5904099997 37.7783879229396 -122.495444072976 (37.7783879229396, -122.495444072976)
131073 60561 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 623 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM 13   Permit Number 20171 5985027.194180001 2111588.97397 37.777154377764894 -122.495353460829 (37.7771543777649, -122.495353460829)
176033 60537 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 543 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM 11   Permit Number 20147 5985322.70304 2112176.441 37.7787846915609 -122.49437453162099 (37.7787846915609, -122.494374531621)
27675 53550 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 433 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/1969 12:00:00 AM 5   Permit Number 6462 6012147.712719999 2116753.05985 37.7928843551861 -122.401897531662 (37.7928843551861, -122.401897531662)
30271 59997 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3699 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/1992 12:00:00 AM 10   Permit Number 31424 5997202.971059999 2115353.3034099997 37.7881956128749 -122.453505683052 (37.7881956128749, -122.453505683052)
186081 61722 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 240 Mallorca Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/1984 12:00:00 AM 16   Permit Number 21724 6001552.32219 2120677.39647 37.8030625385713 -122.43883937455799 (37.8030625385713, -122.438839374558)
156037 92880 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2336 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/2009 12:00:00 AM 7 3x3 Permit Number 53094 6000658.22191 2119643.48009 37.800172771301206 -122.441859170283 (37.8001727713012, -122.441859170283)
73558 53563 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1508 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/1969 12:00:00 AM 15   Permit Number 6479 6008870.79622 2118042.44902 37.7962412752711 -122.41332708747801 (37.7962412752711, -122.413327087478)
15804 25479 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 513 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2016 12:00:00 AM 3 3x3   6010415.98374 2105766.37654 37.7626206925093 -122.407114642722 (37.7626206925093, -122.407114642722)
163574 73353 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2121 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/12/1992 12:00:00 AM 9     5988988.09253 2110533.92881 37.7744886354086 -122.48157433024099 (37.7744886354086, -122.481574330241)
60648 57196 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/1974 12:00:00 AM 15   Permit Number 14477 6012440.56108 2119841.07989 37.801379657914794 -122.40110133756501 (37.8013796579148, -122.401101337565)
49249 61193 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 801 Montgomery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/09/1983 12:00:00 AM 15   Permit Number 21056 6011684.30719 2118103.28791 37.796565884660104 -122.40359598947701 (37.7965658846601, -122.403595989477)
9212 60089 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1216 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/08/2016 12:00:00 AM 3   Permit Number 19590 6007184.48933 2118821.16351 37.7982846096101 -122.41921733482799 (37.7982846096101, -122.419217334828)
21166 28489 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1501X Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/08/2003 12:00:00 AM 12 3X3   6005293.91901 2099563.3377099996 37.7453006168403 -122.424388815185 (37.7453006168403, -122.424388815185)
158617 64765 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2850 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/08/1988 12:00:00 AM 10   Permit Number 25743 6000063.71687 2118410.79691 37.79675425756721 -122.44382777094201 (37.7967542575672, -122.443827770942)
181468 58731 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1050 Battery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/08/1981 12:00:00 AM 15   Permit Number 19424 6012335.49363 2119717.01394 37.8010331410233 -122.401456195674 (37.8010331410233, -122.401456195674)
44069 41259 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/1999 12:00:00 AM 3   Permit Number 41947 6012965.42505 2116862.48993 37.7932304259924 -122.39907587276501 (37.7932304259924, -122.399075872765)
65408 41260 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 California St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/1999 12:00:00 AM 6   Permit Number 41947 6013005.9617800005 2116868.5306599997 37.7932492712794 -122.398936036278 (37.7932492712794, -122.398936036278)
188689 41258 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/1999 12:00:00 AM 4   Permit Number 41947 6012985.5179 2116864.57793 37.793237278822204 -122.399006496356 (37.7932372788222, -122.399006496356)
175380 44129 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2720 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2000 12:00:00 AM 7   Permit Number 43632 6001619.2356 2117785.34422 37.7951255304666 -122.43840049728 (37.7951255304666, -122.43840049728)
146857 65164 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 851 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/05/1989 12:00:00 AM 9   Permit Number 28336 6010209.3102400005 2116483.28297 37.7920352422804 -122.408585490238 (37.7920352422804, -122.408585490238)
130722 33652 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 284 Linden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/03/1996 12:00:00 AM 17   Permit Number 37742 6006070.94642 2110907.70548 37.7764934392605 -122.42250792899799 (37.7764934392605, -122.422507928998)
2140 225336 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3030 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/03/1980 12:00:00 AM 15 Width 2ft Permit Number 18789 6002856.92306 2096000.60547 37.7353802609748 -122.43256110120899 (37.7353802609748, -122.432561101209)
63948 59946 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 670 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/02/1981 12:00:00 AM 2   Permit Number 19420 6012595.89432 2114020.0714 37.785405213512796 -122.40015476333299 (37.7854052135128, -122.400154763333)
175741 59411 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2863 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/02/1980 12:00:00 AM 18   Permit Number 18769 6001036.1664 2116210.80318 37.79076906967779 -122.44030502844801 (37.7907690696778, -122.440305028448)
163225 53555 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1952 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/02/1969 12:00:00 AM 15   Permit Number 6467 6003653.90861 2118674.0797900003 37.79768129131 -122.431423694445 (37.79768129131, -122.431423694445)
187262 31505 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 101 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/2014 12:00:00 AM 13 3x3 Permit Number 54070 6005154.62899 2099588.74591 37.7453625153619 -122.424872264669 (37.7453625153619, -122.424872264669)
21838 5756 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 15X Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/1992 12:00:00 AM 6 3X3   6002852.1776 2108197.50954 37.7688698017364 -122.43344883911301 (37.7688698017364, -122.433448839113)
180752 61229 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2281 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/1983 12:00:00 AM 15   Permit Number 21098 6002033.23121 2119092.6594599998 37.7987386161519 -122.437061654086 (37.7987386161519, -122.437061654086)
95852 55438 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2179 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/1972 12:00:00 AM   3x3 Permit Number 11386 6003157.5538321 2107090.38264344 37.7658472217414 -122.43231348373301 (37.7658472217414, -122.432313483733)
68715 61689 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2190 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/29/1984 12:00:00 AM 15   Permit Number 21686 6003676.08205 2117283.71001 37.793864949854104 -122.431247671937 (37.7938649498541, -122.431247671937)
52670 65422 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 630 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/28/1989 12:00:00 AM 8   Permit Number 28280 6009709.51126 2115541.2486 37.7894206396969 -122.410248265639 (37.7894206396969, -122.410248265639)
32918 33806 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2007 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/1996 12:00:00 AM 7   Permit Number 37824 6004463.72985 2117345.0166700003 37.7940778868436 -122.428526707464 (37.7940778868436, -122.428526707464)
178253 33807 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2007 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/1996 12:00:00 AM 7   Permit Number 37824 6004452.20499 2117343.195 37.794072232801106 -122.42856645478001 (37.7940722328011, -122.42856645478)
164554 64059 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2300 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/2009 12:00:00 AM 8 3x3 Permit Number 53049 6002577.31781 2117478.2709999997 37.7943368358245 -122.435063417162 (37.7943368358245, -122.435063417162)
126321 41191 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 231 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1999 12:00:00 AM 10   Permit Number 41906 6011781.48647 2120441.8774200003 37.802992512855894 -122.40342433316002 (37.8029925128559, -122.40342433316)
131437 59928 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 830 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/1981 12:00:00 AM 9   Permit Number 19399 5992991.39498 2111421.37228 37.777157281801294 -122.467790814086 (37.7771572818013, -122.467790814086)
43284 41169 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 15 Avila St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/23/1999 12:00:00 AM 9   Permit Number 41890 6001073.75913 2119781.5587400002 37.8005755677693 -122.44043116197399 (37.8005755677693, -122.440431161974)
157977 41170 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 15 Avila St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/23/1999 12:00:00 AM 9   Permit Number 41890 6001075.79735 2119765.90095 37.800532691681106 -122.44042298532699 (37.8005326916811, -122.440422985327)
134003 39212 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1335 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/23/1998 12:00:00 AM 10 3x3 Permit Number 40856 6007172.84303 2115954.73885 37.7904134651654 -122.419054213104 (37.7904134651654, -122.419054213104)
169771 48900 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1800 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2002 12:00:00 AM 9   Permit Number 46104 6004370.80891 2118422.99193 37.7970324727301 -122.42892511339599 (37.7970324727301, -122.428925113396)
52092 64746 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3018 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/1988 12:00:00 AM 16   Permit Number 25708 6003425.34038 2118796.1283299997 37.7980034482597 -122.432223323072 (37.7980034482597, -122.432223323072)
23832 66290 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1867 Jefferson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/21/1990 12:00:00 AM 10   Permit Number 29401 6000316.855380001 2121283.51551 37.804656412419206 -122.443158280554 (37.8046564124192, -122.443158280554)
57765 55825 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 134 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 11   Permit Number 21658 5992444.90169 2114563.5183 37.785753184810794 -122.469910122182 (37.7857531848108, -122.469910122182)
63170 61658 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 115 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 15   Permit Number 21651 5992701.25469 2114694.76424 37.78612836504821 -122.4690327763 (37.7861283650482, -122.4690327763)
72679 61660 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 112 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 11   Permit Number 21653 5992438.39496 2114696.12164 37.7861169009047 -122.469942291754 (37.7861169009047, -122.469942291754)
137817 61662 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 116 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 10   Permit Number 21656 5992439.36742 2114670.21257 37.786045817956705 -122.469937040208 (37.7860458179567, -122.469937040208)
174490 61195 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 149 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 16   Permit Number 21659 5992399.94537 2114452.9387 37.7854469649294 -122.470057602229 (37.7854469649294, -122.470057602229)
31379 64112 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2370 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1987 12:00:00 AM 14   Permit Number 24880 5999415.77049 2120510.85768 37.80248348218029 -122.446220946954 (37.8024834821803, -122.446220946954)
153035 58090 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2520 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1977 12:00:00 AM 22   Permit Number 17062 6001522.66402 2117332.90572 37.7938777589127 -122.438702213564 (37.7938777589127, -122.438702213564)
42218 38965 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1550 Bay St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1998 12:00:00 AM 4   Permit Number 40757 6003436.08273 2120726.6321400004 37.803304718789796 -122.432324100197 (37.8033047187898, -122.432324100197)
71657 38964 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1550 Bay St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1998 12:00:00 AM 5   Permit Number 40757 6003391.6163099995 2120720.68173 37.8032858591085 -122.432477552408 (37.8032858591085, -122.432477552408)
160082 38963 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1550 Bay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1998 12:00:00 AM 4   Permit Number 40757 6003449.4154900005 2120728.07407 37.8033094339307 -122.432278064792 (37.8033094339307, -122.432278064792)
163365 38966 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1550 Bay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1998 12:00:00 AM 5   Permit Number 40757 6003466.21083 2120730.18048 37.8033161698654 -122.432220094493 (37.8033161698654, -122.432220094493)
166956 38967 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1550 Bay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1998 12:00:00 AM 5   Permit Number 40757 6003480.31275 2120733.07848 37.8033249265625 -122.432171501416 (37.8033249265625, -122.432171501416)
176982 38968 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1550 Bay St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1998 12:00:00 AM 4   Permit Number 40757 6003405.68786 2120722.10839 37.803290574274605 -122.432428959327 (37.8032905742746, -122.432428959327)
39863 63031 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 71 Stevenson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1986 12:00:00 AM 8   Permit Number 23500 6012658.13242 2115466.3125 37.789379723244 -122.40004103778601 (37.789379723244, -122.400041037786)
152032 63044 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2666 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/1986 12:00:00 AM 19   Permit Number 23514 6000161.09146 2118878.17531 37.798043108366606 -122.443524424211 (37.7980431083666, -122.443524424211)
42698 68775 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2030 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/16/1993 12:00:00 AM 10   Permit Number 32705 6002061.93681 2119840.4172400003 37.8007933943611 -122.437015886694 (37.8007933943611, -122.437015886694)
2469 48871 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 535 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/15/2002 12:00:00 AM 12 3x3 Permit Number 46080 6011476.385009999 2118326.9888400002 37.797168496982 -122.404331203243 (37.797168496982, -122.404331203243)
164127 64712 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1649 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/14/1988 12:00:00 AM 8   Permit Number 25661 6002326.1726400005 2121218.5491400003 37.804592396896794 -122.436200200684 (37.8045923968968, -122.436200200684)
42730 58356 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1441 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/13/1978 12:00:00 AM 13   Permit Number 17383 6008856.28297 2117856.15313 37.7957289377938 -122.413364125179 (37.7957289377938, -122.413364125179)
143172 90957 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4645 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/12/2008 12:00:00 AM 3 3x3   5981126.99481 2110929.9331 37.7751157135635 -122.50879629988701 (37.7751157135635, -122.508796299887)
33173 41425 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1568 Indiana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/12/2005 12:00:00 AM 14   Permit Number 42032 6015102.0577 2101304.61846 37.750630787079395 -122.390595272152 (37.7506307870794, -122.390595272152)
47530 61308 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2309 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/12/2005 12:00:00 AM 15   Permit Number 21207 6011873.01335 2101843.0794599997 37.751929614981705 -122.401799483056 (37.7519296149817, -122.401799483056)
182803 72081 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 195 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/10/1984 12:00:00 AM 15     5993024.92764 2114284.47413 37.7850205170043 -122.467883110599 (37.7850205170043, -122.467883110599)
159293 61645 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 425 Walnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/09/1984 12:00:00 AM 15   Permit Number 21634 5998600.96038 2115083.84217 37.7875357812027 -122.448649482513 (37.7875357812027, -122.448649482513)
45544 37548 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 952 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/08/2003 12:00:00 AM 13   Permit Number 39988 6008033.82968 2115183.28467 37.7883436871616 -122.416020592081 (37.7883436871616, -122.416020592081)
122955 57236 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2177 Jerrold Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/2007 12:00:00 AM 19 3x3 Permit Number 49872 6012267.86149 2099249.98907 37.7448315745341 -122.400251926092 (37.7448315745341, -122.400251926092)
51186 33067 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1355 Sansome St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM 15   Permit Number 37331 6011851.2252400005 2120346.7992599998 37.8027353463091 -122.40317630735599 (37.8027353463091, -122.403176307356)
63721 33066 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1355 Sansome St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM 14   Permit Number 37331 6011848.07365 2120375.25315 37.8028132977535 -122.403189216236 (37.8028132977535, -122.403189216236)
130026 33065 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1355 Sansome St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM 13   Permit Number 37331 6011842.82405 2120405.3415200002 37.802895619911205 -122.403209500424 (37.8028956199112, -122.403209500424)
169432 54139 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2466 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1992 12:00:00 AM 14   Permit Number 31290 6001787.7774 2117718.48372 37.794951534142704 -122.437812526832 (37.7949515341427, -122.437812526832)
63979 60221 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 355 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/1991 12:00:00 AM 18 3x3 Permit Number 30105 6014723.848259999 2113334.8901299997 37.7836422824045 -122.39274467072399 (37.7836422824045, -122.392744670724)
74238 66818 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2632 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/1991 12:00:00 AM 12   Permit Number 30108 6002664.62031 2117284.9468099996 37.7938109743374 -122.434747509611 (37.7938109743374, -122.434747509611)
7546 7345 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2201 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/03/1995 12:00:00 AM 20 3x3   6002814.8619099995 2115881.6003099997 37.789966273667396 -122.434127293036 (37.7899662736674, -122.434127293036)
176845 60420 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1701 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/03/1982 12:00:00 AM 17 3x3 Permit Number 20003 6008305.058569999 2118304.25453 37.7969283492221 -122.415303204696 (37.7969283492221, -122.415303204696)
187099 65403 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 840 Geary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/1989 12:00:00 AM 15   Permit Number 28252 6007717.08524 2114448.95426 37.7863095816566 -122.41706442708599 (37.7863095816566, -122.417064427086)
156656 61637 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3110 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/1984 12:00:00 AM 15   Permit Number 21623 6004251.95247 2119832.12373 37.8008948576803 -122.42943692656799 (37.8008948576803, -122.429436926568)
100499 97662 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1909 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2011 12:00:00 AM   5x6 Permit Number 768299 5999946.0 2115458.0 37.7886399393615 -122.44402282420499 (37.7886399393615, -122.444022824205)
39503 32970 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 336 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1996 12:00:00 AM 12 7x7 Permit Number 37285 6013456.70104 2105487.0572099998 37.7620234392501 -122.396578241401 (37.7620234392501, -122.396578241401)
70827 59332 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 821 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1980 12:00:00 AM 15   Permit Number 18679 6011694.06815 2113065.52729 37.7827339338614 -122.40320765949801 (37.7827339338614, -122.403207659498)
105782 58316 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1501-1519X 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1978 12:00:00 AM     Permit Number 17339 6007402.0 2107334.0 37.7667558904507 -122.41765006763599 (37.7667558904507, -122.417650067636)
48505 58060 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1351 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1977 12:00:00 AM 11   Permit Number 17029 6006459.14995 2119360.48433 37.7997245725954 -122.42176555933399 (37.7997245725954, -122.421765559334)
146896 53485 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 147 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1969 12:00:00 AM 10   Permit Number 6394 5993327.4346 2114508.15513 37.7856521474573 -122.46685280764 (37.7856521474573, -122.46685280764)

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