Street_Tree_List

Data source: data.sfgov.org

5,685 rows where qSpecies = 32 sorted by TreeID

View and edit SQL

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
18429 5662 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1359 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3x3   6005250.93276 2100400.67941 37.747597337862004 -122.424597007367 (37.747597337862, -122.424597007367)
17422 5666 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1386 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 4x4   6005171.18394 2100267.5671 37.747227337869 -122.42486330559099 (37.747227337869, -122.424863305591)
17068 5668 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1410 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 2x2   6005180.48328 2100097.67272 37.7467613721366 -122.42481906436001 (37.7467613721366, -122.42481906436)
17395 5671 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1421 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/25/2003 12:00:00 AM 25 3X3   6005267.3091400005 2100058.51794 37.7466587657846 -122.42451604410499 (37.7466587657846, -122.424516044105)
17171 5673 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1427 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6005269.65277 2100030.15773 37.7465810274965 -122.424505923113 (37.7465810274965, -122.424505923113)
18090 5681 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1475 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   6005285.89878 2099762.93917 37.7458482239295 -122.42443074250099 (37.7458482239295, -122.424430742501)
22183 5688 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1529 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   6005300.97335 2099447.43901 37.74498278382271 -122.424356180604 (37.7449827838227, -122.424356180604)
18131 5691 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1543 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   6005307.11022 2099391.5249900003 37.7448296032196 -122.424330984292 (37.7448296032196, -122.424330984292)
21185 5694 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1547 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6005309.1643 2099369.41542 37.7447690113731 -122.42432230943899 (37.7447690113731, -122.424322309439)
18473 5701 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1573 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 5X5   6005320.34173 2099180.98827 37.7442522645292 -122.42427026118901 (37.7442522645292, -122.424270261189)
22021 5704 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1592 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3x3   6005234.83472 2099132.33541 37.7441138462791 -122.42456246619 (37.7441138462791, -122.42456246619)
21691 5719 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1652 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   6005259.7539800005 2098674.6778700002 37.7428586301118 -122.424443754787 (37.7428586301118, -122.424443754787)
21310 5730 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1703 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3x3   6005364.14251 2098372.71448 37.742035401517796 -122.42406133876601 (37.7420354015178, -122.424061338766)
17193 5734 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1725 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3x3   6005365.37115 2098326.9608400003 37.7419098417621 -122.424053837524 (37.7419098417621, -122.424053837524)
20877 5740 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1749 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005372.5481199995 2098218.79368 37.7416132444522 -122.424021331535 (37.7416132444522, -122.424021331535)
22203 5744 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1759 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005374.75018 2098167.6187400003 37.7414728539803 -122.424010079215 (37.7414728539803, -122.424010079215)
17547 5745 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1764 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 4X6   6005291.38109 2098122.5242 37.7413443273726 -122.424295134606 (37.7413443273726, -122.424295134606)
21614 5746 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1765 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/1998 12:00:00 AM 50 3x3   6005379.08907 2098105.72339 37.74130314832521 -122.42399067635401 (37.7413031483252, -122.423990676354)
21381 5749 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1772 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 6X6   6005295.3267 2098040.1604299997 37.74111839790721 -122.424275635536 (37.7411183979072, -122.424275635536)
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)
19886 5779 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 496 Duboce Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6003455.82861 2108380.6044799997 37.7694067653271 -122.43137392508899 (37.7694067653271, -122.431373925089)
21270 5781 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 492 Duboce Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 7x4   6003508.34359 2108380.71805 37.769410053253395 -122.431192286293 (37.7694100532534, -122.431192286293)
22759 6141 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 956 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 2x2   6006237.10649 2113548.0769 37.783752628311 -122.422120756488 (37.783752628311, -122.422120756488)
22674 6149 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 998X Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3x3   6006219.052080001 2113544.77353 37.7837425397409 -122.422182983282 (37.7837425397409, -122.422182983282)
22754 6150 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 998X Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 4x4   6006191.740119999 2113539.8235400002 37.7837274077384 -122.42227712071 (37.7837274077384, -122.42227712071)
22553 6151 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 998X Ellis St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 2x2   6006159.131130001 2113535.212 37.783712906156204 -122.422389607903 (37.7837129061562, -122.422389607903)
22493 6152 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 998X Ellis St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 4x4   6006127.91467 2113531.0311 37.78369966545571 -122.42249730802901 (37.7836996654557, -122.422497308029)
7086 6376 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 311X Elm St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006100.46192 2112621.53299 37.7812008577844 -122.422527635837 (37.7812008577844, -122.422527635837)
8693 6377 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 311X Elm St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006125.71755 2112628.3698 37.7812210547395 -122.422440749665 (37.7812210547395, -122.422440749665)
23208 6749 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1215 Fairfax Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6017498.178719999 2096747.56806 37.738250691012205 -122.381992253155 (37.7382506910122, -122.381992253155)
23319 6750 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1215 Fairfax Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6017497.29462 2096749.0937700002 37.7382548314821 -122.381995416066 (37.7382548314821, -122.381995416066)
14914 6792 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1375 Fairfax Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6016736.55231 2097315.7132900003 37.739768612644 -122.384665171383 (37.739768612644, -122.384665171383)
14817 6802 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1381 Fairfax Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6016686.26757 2097353.7409 37.739870247704204 -122.384841684893 (37.7398702477042, -122.384841684893)
16261 6803 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1381 Fairfax Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6016702.460969999 2097342.51463 37.7398403182643 -122.384784912507 (37.7398403182643, -122.384784912507)
15509 6804 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1381 Fairfax Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x9   6016716.56136 2097329.28644 37.7398047761739 -122.384735237561 (37.7398047761739, -122.384735237561)
14941 6814 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400X Fairfax Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Fire Dept 11     12 3X3   6016451.12132 2097615.70854 37.7405765491786 -122.38567298313801 (37.7405765491786, -122.385672983138)
15881 6819 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400X Fairfax Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Fire Dept 11     12 3X3   6016343.96785 2097693.33127 37.7407837556653 -122.386048891651 (37.7407837556653, -122.386048891651)
436 6932 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004980.8762 2110598.20876 37.775582081585895 -122.42625675563801 (37.7755820815859, -122.426256755638)
18436 6947 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 577 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 12x6   6004695.20098 2110505.3645599997 37.77531100253479 -122.427238361166 (37.7753110025348, -122.427238361166)
7832 7341 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2133 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002836.01293 2115704.12201 37.7894801640146 -122.434041420394 (37.7894801640146, -122.434041420394)
8621 7342 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2142 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/30/2011 12:00:00 AM 3 3x3   6002873.64296 2115779.16456 37.7896883471937 -122.433916590893 (37.7896883471937, -122.433916590893)
8383 7343 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2195 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002825.78223 2115774.95026 37.7896740596703 -122.43408188267999 (37.7896740596703, -122.43408188268)
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)
5444 7347 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2226 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   6002843.64008 2115975.51024 37.790225759563 -122.43403443894199 (37.790225759563, -122.434034438942)
6379 7348 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2226 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6002838.16405 2116011.64355 37.79032466161 -122.434055969611 (37.79032466161, -122.434055969611)
762 7350 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2239 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002792.88059 2116041.24067 37.790403357673895 -122.434214763813 (37.7904033576739, -122.434214763813)
5945 7354 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2302 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002812.8867 2116206.99877 37.790859622428705 -122.43415739873899 (37.7908596224287, -122.434157398739)
7303 7359 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2318 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6002798.384190001 2116304.6096200002 37.7911268136944 -122.434214557878 (37.7911268136944, -122.434214557878)
6128 7360 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2318 Fillmore St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6002794.80589 2116321.1342700003 37.79117198305129 -122.434228120527 (37.7911719830513, -122.434228120527)
8725 7362 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2329 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6002748.31334 2116334.0850400003 37.7912049036346 -122.43438990946999 (37.7912049036346, -122.43438990947)
3516 7363 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2343 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002738.924769999 2116408.16832 37.791407784388795 -122.434427692684 (37.7914077843888, -122.434427692684)
6494 7364 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2360 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002779.17574 2116404.82668 37.7914008937989 -122.43428818627198 (37.7914008937989, -122.434288186272)
6745 7365 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2360 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002776.693940001 2116420.21341 37.791443000945705 -122.43429787376002 (37.7914430009457, -122.43429787376)
1018 7366 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2360 Fillmore St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002774.54957 2116438.38146 37.79149276403471 -122.434306592692 (37.7914927640347, -122.434306592692)
7986 7370 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2420 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002758.068969999 2116587.9502 37.7919025059375 -122.434374313431 (37.7919025059375, -122.434374313431)
8783 7373 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2440 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002748.17801 2116678.1241200003 37.7921495389154 -122.43441498617901 (37.7921495389154, -122.434414986179)
21557 7710 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 47 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6006505.57437 2110325.13763 37.774918357632 -122.420963052012 (37.774918357632, -122.420963052012)
8391 7856 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 915 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6006092.78469 2113271.83344 37.782985990458606 -122.422600419785 (37.7829859904586, -122.422600419785)
22742 7864 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1000 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6006105.6971 2113551.82535 37.783755507964294 -122.42257565063998 (37.7837555079643, -122.42257565064)
22534 7865 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1000 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6006105.0189 2113565.09712 37.7837919107224 -122.42257894036301 (37.7837919107224, -122.422578940363)
22469 7866 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1000 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6006104.07556 2113580.8996 37.7838352472299 -122.42258332726801 (37.7838352472299, -122.422583327268)
22629 7867 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1000 Franklin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6006097.1257 2113612.9246799997 37.7839227881431 -122.42260964772 (37.7839227881431, -122.42260964772)
22708 7868 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1000 Franklin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6006094.882730001 2113627.1755 37.7839617908505 -122.42261842060101 (37.7839617908505, -122.422618420601)
22475 7869 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1000 Franklin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6006093.62914 2113643.3001 37.7840059943141 -122.422623903791 (37.7840059943141, -122.422623903791)
23111 7884 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1187 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19     6005973.3508 2114075.31974 37.7851854273041 -122.423070740949 (37.7851854273041, -122.423070740949)
23260 7885 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1187 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 3X3   6005978.9516900005 2114038.3694 37.785084286843 -122.42304873632901 (37.785084286843, -122.423048736329)
22481 7886 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1187 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6005985.62608 2114011.52102 37.7850109444432 -122.42302373605601 (37.7850109444432, -122.423023736056)
22528 7887 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1187 Franklin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005988.84512 2113979.6927799997 37.784923733590205 -122.423010336179 (37.7849237335902, -122.423010336179)
22437 7888 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1187 Franklin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005995.08562 2113950.47576 37.7848438629952 -122.42298666871001 (37.7848438629952, -122.42298666871)
22411 7889 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1187 Franklin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005995.918959999 2113921.74849 37.7847650320158 -122.422981743131 (37.7847650320158, -122.422981743131)
22434 7890 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1187 Franklin St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006000.00879 2113898.80959 37.7847022782275 -122.42296596272 (37.7847022782275, -122.42296596272)
22699 7928 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1355 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x4   6005875.43984 2114804.13862 37.7871810579978 -122.42346131468399 (37.7871810579978, -122.423461314684)
22590 7929 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1355 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6005876.4579300005 2114785.77426 37.7871306914809 -122.42345648625201 (37.7871306914809, -122.423456486252)
22426 7930 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1355 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6005883.49372 2114761.44957 37.787064299019605 -122.423430414002 (37.7870642990196, -122.423430414002)
22444 7931 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1355 Franklin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x4   6005884.64786 2114736.13414 37.786994854263604 -122.42342462055001 (37.7869948542636, -122.42342462055)
910 7954 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1756 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3X3   6005736.45543 2116153.36588 37.7908778543671 -122.424038156058 (37.7908778543671, -122.424038156058)
8948 7955 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1756 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6005731.7408300005 2116171.91633 37.790928523081895 -122.424055788151 (37.7909285230819, -122.424055788151)
8336 7987 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2123 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005516.51902 2117364.58787 37.7941911456586 -122.424885336313 (37.7941911456586, -122.424885336313)
7245 7988 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2123 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005523.45781 2117337.0408 37.794115900277205 -122.424859366576 (37.7941159002772, -122.424859366576)
23019 8332 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1115 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     6006224.34418 2114188.56599 37.785510534017 -122.42221042876301 (37.785510534017, -122.422210428763)
23082 8333 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1111 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x5   6006254.89283 2114192.6699900003 37.785523525637004 -122.42210503092501 (37.785523525637, -122.422105030925)
23059 8334 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1119 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3X5   6006192.11935 2114184.4968 37.785497543332205 -122.422321628135 (37.7854975433322, -122.422321628135)
8011 9691 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 330 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6005982.01492 2110919.04398 37.776519554674294 -122.422816374886 (37.7765195546743, -122.422816374886)
6871 9692 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 330 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6005977.63731 2110934.31764 37.7765612454456 -122.422832604057 (37.7765612454456, -122.422832604057)
2950 9693 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 414 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/17/2012 12:00:00 AM 3 3X3   6005939.70475 2111200.2280099997 37.777289230461705 -122.422982727867 (37.7772892304617, -122.422982727867)
22466 9863 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400X Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6005484.31896 2114507.898 37.78634557162879 -122.42479342650101 (37.7863455716288, -122.424793426501)
22449 9864 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400X Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 3X3   6005479.123269999 2114533.19407 37.7864147348969 -122.424813202561 (37.7864147348969, -122.424813202561)
22694 9865 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400X Gough St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6005476.5022 2114563.1372599998 37.7864968034169 -122.42482440183599 (37.7864968034169, -122.424824401836)
22630 9866 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400X Gough St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 3X3   6005472.9324900005 2114589.87673 37.7865700217345 -122.424838655194 (37.7865700217345, -122.424838655194)
22687 9867 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1400X Gough St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6005468.52862 2114618.9775 37.7866496764769 -122.42485596263 (37.7866496764769, -122.42485596263)
22659 9868 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1450X Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6005462.7454699995 2114640.10242 37.786707353608 -122.42487747443701 (37.786707353608, -122.424877474437)
22648 9869 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1450X Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   6005460.28192 2114658.9871799997 37.7867590673152 -122.424887341798 (37.7867590673152, -122.424887341798)
22503 9870 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1450X Gough St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     36 3X3   6005458.91532 2114681.2842099997 37.7868202122258 -122.42489365683599 (37.7868202122258, -122.424893656836)
22380 9871 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1450X Gough St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     36 3X3   6005453.91763 2114704.56484 37.786883852758 -122.424912604636 (37.786883852758, -122.424912604636)
22432 9872 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1450X Gough St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6005450.688630001 2114725.08205 37.786940005526205 -122.42492523651698 (37.7869400055262, -122.424925236517)
22775 9873 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1450X Gough St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     36 3X3   6005447.50636 2114747.87072 37.7870023977962 -122.424937868409 (37.7870023977962, -122.424937868409)
4853 9903 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1800 Gough St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3X3   6005280.3283400005 2115938.07678 37.7902609617121 -122.425601007782 (37.7902609617121, -122.425601007782)
6056 9906 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1801 Gough St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 3X3   6005239.41389 2115914.36204 37.7901935350552 -122.42574088024999 (37.7901935350552, -122.42574088025)
181 9914 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1900 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     126 3X3   6005235.69262 2116267.9294 37.7911641319684 -122.42577893234899 (37.7911641319684, -122.425778932349)
2770 9915 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1900 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 3X3   6005229.572240001 2116308.1912 37.791274334888705 -122.42580297571999 (37.7912743348887, -122.42580297572)

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