Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21041 | 21041 | 440 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 905X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005107.10521 | 2103067.32029 | 37.7549111922079 | -122.425284083114 | (37.7549111922079, -122.425284083114) | |||
| 116178 | 116178 | 453 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988823.177519999 | 2110218.88788 | 37.773614029759706 | -122.482121711467 | (37.7736140297597, -122.482121711467) | ||||
| 86980 | 86980 | 454 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988822.540159999 | 2110230.27386 | 37.7736452554339 | -122.482124750469 | (37.7736452554339, -122.482124750469) | |||
| 20203 | 20203 | 480 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1189X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010603.38594 | 2102417.78534 | 37.753436695258706 | -122.40623054442699 | (37.7534366952587, -122.406230544427) | |||
| 21482 | 21482 | 680 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1092X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005078.24263 | 2101996.40983 | 37.751969090723705 | -122.425307695709 | (37.7519690907237, -122.425307695709) | |||
| 14496 | 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) | |
| 92304 | 92304 | 1647 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 899X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5995653.038380001 | 2110431.71806 | 37.774593282288706 | -122.458511750812 | (37.7745932822887, -122.458511750812) | |||
| 19943 | 19943 | 1648 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1357X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6005249.3225300005 | 2100424.02807 | 37.747661356982704 | -122.424604236094 | (37.7476613569827, -122.424604236094) | |||
| 21353 | 21353 | 1650 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1407 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004562.01875 | 2100658.96573 | 37.748267601670705 | -122.426997625236 | (37.7482676016707, -122.426997625236) | |||
| 97686 | 97686 | 2016 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 598 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | Permit Number 772999 | 6002387.133452299 | 2095371.0933820999 | 37.7336251126369 | -122.43414034926901 | (37.7336251126369, -122.434140349269) | ||
| 20453 | 20453 | 2307 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2201 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009664.819 | 2104484.86111 | 37.7590598763402 | -122.409622207113 | (37.7590598763402, -122.409622207113) | |||
| 7955 | 7955 | 2559 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010139.86522 | 2115942.29028 | 37.790545917314795 | -122.40878758770201 | (37.7905459173148, -122.408787587702) | |||
| 5848 | 5848 | 2810 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009146.78627 | 2116331.3706 | 37.7915585638337 | -122.412251105309 | (37.7915585638337, -122.412251105309) | |||
| 7378 | 7378 | 2811 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009171.094 | 2116334.89627 | 37.791569608406895 | -122.412167249844 | (37.7915696084069, -122.412167249844) | |||
| 6910 | 6910 | 2812 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009199.61723 | 2116339.14024 | 37.7915828617187 | -122.41206885950301 | (37.7915828617187, -122.412068859503) | |||
| 728 | 728 | 2813 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009225.04881 | 2116342.3210299998 | 37.7915930222591 | -122.41198109107599 | (37.7915930222591, -122.411981091076) | |||
| 20429 | 20429 | 4155 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3723-3725 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/1980 12:00:00 AM | 12 | 3X3 | 6005676.6062 | 2100493.36935 | 37.7478758740818 | -122.42313163940901 | (37.7478758740818, -122.423131639409) | ||
| 19197 | 19197 | 4157 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3731-3733 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/1980 12:00:00 AM | 12 | 3X3 | 6005624.61374 | 2100492.15836 | 37.7478696147883 | -122.42331134107201 | (37.7478696147883, -122.423311341072) | ||
| 20357 | 20357 | 4169 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3790 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/1980 12:00:00 AM | 36 | 3X3 | 6005318.71508 | 2100516.71727 | 37.7479197789855 | -122.424370871929 | (37.7479197789855, -122.424370871929) | ||
| 17341 | 17341 | 4170 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3792 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/1980 12:00:00 AM | 60 | 3X3 | 6005296.89649 | 2100516.85549 | 37.7479189264148 | -122.42444632955 | (37.7479189264148, -122.42444632955) | ||
| 18413 | 18413 | 4238 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4019 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003737.20071 | 2100388.64531 | 37.7474786902894 | -122.429830543661 | (37.7474786902894, -122.429830543661) | |||
| 17280 | 17280 | 4240 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4023 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003709.8954 | 2100384.1668 | 37.7474648470367 | -122.429924644222 | (37.7474648470367, -122.429924644222) | |||
| 18294 | 18294 | 4311 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 704 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002439.77272 | 2095706.35497 | 37.734548651581605 | -122.433982316925 | (37.7345486515816, -122.433982316925) | |||
| 21149 | 21149 | 4400 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1030 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/18/2004 12:00:00 AM | 12 | 3X3 | 6004376.2698 | 2102866.9292900003 | 37.7543196496346 | -122.42779724037399 | (37.7543196496346, -122.427797240374) | ||
| 20753 | 20753 | 4401 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1036 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6004376.63552 | 2102848.97177 | 37.754270363187 | -122.42779469618401 | (37.754270363187, -122.427794696184) | |||
| 20346 | 20346 | 4402 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1036 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6004377.15212 | 2102838.33768 | 37.7542411936947 | -122.42779215199499 | (37.7542411936947, -122.427792151995) | |||
| 19370 | 19370 | 4415 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1124 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004407.3846 | 2102323.75725 | 37.7528299865372 | -122.42765094045299 | (37.7528299865372, -122.427650940453) | |||
| 20070 | 20070 | 4445 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1351 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004542.9935 | 2100988.75138 | 37.749172040866206 | -122.427086900064 | (37.7491720408662, -122.427086900064) | |||
| 19971 | 19971 | 4446 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1355 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x4 | 6004542.014880001 | 2100967.34778 | 37.749113216203 | -122.427088759848 | (37.749113216203, -122.427088759848) | |||
| 20438 | 20438 | 4451 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1378 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6004489.31548 | 2100836.19087 | 37.7487501095263 | -122.427261653602 | (37.7487501095263, -122.427261653602) | |||
| 18668 | 18668 | 4452 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1383 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004549.42676 | 2100835.98556 | 37.748752945111704 | -122.427053774433 | (37.7487529451117, -122.427053774433) | |||
| 17689 | 17689 | 4453 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1395 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x4 | 6004550.8518900005 | 2100795.77415 | 37.74864261447971 | -122.427045982684 | (37.7486426144797, -122.427045982684) | |||
| 17927 | 17927 | 4454 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1401 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004556.83257 | 2100694.42254 | 37.7483646646087 | -122.427018083911 | (37.7483646646087, -122.427018083911) | |||
| 18589 | 18589 | 4463 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1457 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004575.70732 | 2100374.4541700003 | 37.7474871727112 | -122.426930030392 | (37.7474871727112, -122.426930030392) | |||
| 17898 | 17898 | 4481 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1545 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004601.24999 | 2099921.13488 | 37.746243906725 | -122.426809426834 | (37.746243906725, -122.426809426834) | |||
| 17313 | 17313 | 4486 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1579 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004612.83847 | 2099652.68979 | 37.7455074734878 | -122.42675024153601 | (37.7455074734878, -122.426750241536) | |||
| 17100 | 17100 | 4500 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1740 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004605.06487 | 2098773.28135 | 37.743092380111996 | -122.426714507892 | (37.743092380112, -122.426714507892) | |||
| 7160 | 7160 | 4592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2016 01:42:00 PM | 3 | 3x3 | 6011401.079390001 | 2118088.92644 | 37.796510626729706 | -122.40457501395299 | (37.7965106267297, -122.404575013953) | ||
| 206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
| 7865 | 7865 | 4751 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007679.06678 | 2121391.72732 | 37.8053705712658 | -122.41768823913601 | (37.8053705712658, -122.417688239136) | |||
| 114573 | 114573 | 4953 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 598 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 772999 | 6002387.133452299 | 2095371.0933820999 | 37.7336251126369 | -122.43414034926901 | (37.7336251126369, -122.434140349269) | ||
| 19931 | 19931 | 5118 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2721 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6002423.4063 | 2096112.9381400002 | 37.735664106798794 | -122.434067955786 | (37.7356641067988, -122.434067955786) | |||
| 21578 | 21578 | 5327 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004755.67064 | 2107733.77413 | 37.7677043064343 | -122.426831755188 | (37.7677043064343, -122.426831755188) | |||
| 18442 | 18442 | 5328 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6004844.5773 | 2107740.43574 | 37.7677276240574 | -122.426524712264 | (37.7677276240574, -122.426524712264) | |||
| 22171 | 22171 | 5329 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 115 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6X8 | 6004845.87922 | 2107712.31593 | 37.767650487414706 | -122.42651820656499 | (37.7676504874147, -122.426518206565) | |||
| 21563 | 21563 | 5331 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x8 | 6004849.02051 | 2107663.93155 | 37.7675178131103 | -122.42650389563299 | (37.7675178131103, -122.426503895633) | |||
| 21044 | 21044 | 5341 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 170 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004776.509819999 | 2107393.36664 | 37.766770807464106 | -122.42673543061301 | (37.7667708074641, -122.426735430613) | |||
| 17473 | 17473 | 5347 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 199 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004867.38316 | 2107258.6385 | 37.7664060136476 | -122.426411520896 | (37.7664060136476, -122.426411520896) | |||
| 21888 | 21888 | 5353 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004878.5791 | 2107096.4330599997 | 37.765961269229706 | -122.42636124607901 | (37.7659612692297, -122.426361246079) | |||
| 21322 | 21322 | 5360 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004798.07492 | 2106976.61217 | 37.765627718772 | -122.42663116052499 | (37.765627718772, -122.426631160525) | |||
| 17327 | 17327 | 5361 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004801.1830400005 | 2106961.82172 | 37.7655872834524 | -122.42661935690901 | (37.7655872834524, -122.426619356909) | |||
| 16993 | 16993 | 5362 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004802.4691 | 2106941.40414 | 37.765531294370106 | -122.42661345466999 | (37.7655312943701, -122.42661345467) | |||
| 18672 | 18672 | 5363 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004802.21847 | 2106929.2313599996 | 37.7654978566596 | -122.426613454658 | (37.7654978566596, -122.426613454658) | |||
| 17431 | 17431 | 5364 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004803.911280001 | 2106914.7530400003 | 37.765458198358495 | -122.42660656853701 | (37.7654581983585, -122.426606568537) | |||
| 17353 | 17353 | 5365 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6004803.09071 | 2106888.71484 | 37.7653866572999 | -122.426607552398 | (37.7653866572999, -122.426607552398) | |||
| 9826 | 9826 | 5367 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 247 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004885.80801 | 2106938.09523 | 37.7655269200494 | -122.42632496832701 | (37.7655269200494, -122.426324968327) | |||
| 21170 | 21170 | 5396 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 347 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 6004920.3528 | 2106347.10243 | 37.763906147460496 | -122.42616340782699 | (37.7639061474605, -122.426163407827) | |||
| 18433 | 18433 | 5401 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 366 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6004840.34463 | 2106247.67705 | 37.7636286265866 | -122.42643305244499 | (37.7636286265866, -122.426433052445) | |||
| 17461 | 17461 | 5407 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 389 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6004934.31167 | 2106099.66089 | 37.763227520851295 | -122.426097511793 | (37.7632275208513, -122.426097511793) | |||
| 18127 | 18127 | 5411 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 0 | 6004855.17183 | 2105951.94902 | 37.762817465963394 | -122.426360712783 | (37.7628174659634, -122.426360712783) | |||
| 22274 | 22274 | 5420 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 425x Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 8x8 | 6004948.45636 | 2105854.10542 | 37.7625540833275 | -122.426031108549 | (37.7625540833275, -122.426031108549) | |||
| 18934 | 18934 | 5430 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 481 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 6004966.9264400005 | 2105556.94593 | 37.761739197733704 | -122.425946073151 | (37.7617391977337, -122.425946073151) | |||
| 21957 | 21957 | 5431 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 487 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 0 | 6004965.24548 | 2105536.3333099997 | 37.7616825053662 | -122.42595041957199 | (37.7616825053662, -122.425950419572) | |||
| 18604 | 18604 | 5495 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 750 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004966.716680001 | 2103932.35304 | 37.757278437156295 | -122.42583115599399 | (37.7572784371563, -122.425831155994) | |||
| 17139 | 17139 | 5496 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 750 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004967.46439 | 2103919.59639 | 37.757243452645604 | -122.42582766212401 | (37.7572434526456, -122.425827662124) | |||
| 17585 | 17585 | 5497 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 750 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004967.58 | 2103908.86443 | 37.7572139917372 | -122.425826498419 | (37.7572139917372, -122.425826498419) | |||
| 17673 | 17673 | 5500 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 760 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004969.0478300005 | 2103882.01013 | 37.7571403390842 | -122.42581951066099 | (37.7571403390842, -122.425819510661) | |||
| 22250 | 22250 | 5510 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 811 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X5 | 6005073.335580001 | 2103604.24932 | 37.756383565871296 | -122.425439076749 | (37.7563835658713, -122.425439076749) | |||
| 21908 | 21908 | 5511 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 815 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X5 | 6005074.37606 | 2103575.6908299997 | 37.7563052097331 | -122.425433446104 | (37.7563052097331, -122.425433446104) | |||
| 17263 | 17263 | 5517 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 848 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 5x5 | 6004997.88514 | 2103403.44708 | 37.7558279467221 | -122.425685719428 | (37.7558279467221, -122.425685719428) | |||
| 17566 | 17566 | 5520 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 861 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6X6 | 6005083.64012 | 2103377.03639 | 37.7557602745442 | -122.42538727132201 | (37.7557602745442, -122.425387271322) | |||
| 18054 | 18054 | 5536 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 900X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X6 | 6005028.08743 | 2102877.14934 | 37.7543845627197 | -122.425543815419 | (37.7543845627197, -122.425543815419) | |||
| 22162 | 22162 | 5537 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 900X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6X6 | 6005030.13119 | 2102849.86658 | 37.754309766104704 | -122.425534806003 | (37.7543097661047, -122.425534806003) | |||
| 20769 | 20769 | 5541 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 907 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005108.57079 | 2103048.19479 | 37.754858760847505 | -122.425277653837 | (37.7548587608475, -122.425277653837) | |||
| 18495 | 18495 | 5542 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 907 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3x3 | 6005107.40755 | 2103030.34702 | 37.7548096893191 | -122.42528040668002 | (37.7548096893191, -122.42528040668) | |||
| 17308 | 17308 | 5543 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 913 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 5X5 | 6005108.77841 | 2103002.69982 | 37.75473385400671 | -122.42527369861901 | (37.7547338540067, -122.425273698619) | |||
| 21716 | 21716 | 5553 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 966 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 6x9 | 6005037.527369999 | 2102725.93475 | 37.7539698961026 | -122.425500408737 | (37.7539698961026, -122.425500408737) | |||
| 21138 | 21138 | 5560 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 986 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6005042.03687 | 2102621.3171900003 | 37.753682895456706 | -122.42547736900801 | (37.7536828954567, -122.425477369008) | |||
| 19915 | 19915 | 5567 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1010 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 6 | 6005058.01413 | 2102367.77538 | 37.752987631383 | -122.42540407423401 | (37.752987631383, -122.425404074234) | |||
| 17956 | 17956 | 5584 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1070 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6005072.3503 | 2102110.66979 | 37.7522824891524 | -122.425336202406 | (37.7522824891524, -122.425336202406) | |||
| 18438 | 18438 | 5591 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1088 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778628 | 6005076.53143 | 2102027.71599 | 37.7520549534969 | -122.425315840853 | (37.7520549534969, -122.425315840853) | |
| 19228 | 19228 | 5594 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1100 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6005083.47223 | 2101907.17994 | 37.7517243815975 | -122.425283262017 | (37.7517243815975, -122.425283262017) | |||
| 21293 | 21293 | 5597 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1105 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6005169.34187 | 2101859.81222 | 37.7515991716815 | -122.424982943335 | (37.7515991716815, -122.424982943335) | |||
| 19890 | 19890 | 5598 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1114 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6005085.74952 | 2101846.15416 | 37.7515569476132 | -122.42527104471901 | (37.7515569476132, -122.425271044719) | |||
| 17600 | 17600 | 5600 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1120-1122 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 6X6 | 6005086.74805 | 2101818.38067 | 37.751480744460295 | -122.42526561553801 | (37.7514807444603, -122.425265615538) | ||
| 21652 | 21652 | 5604 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1133 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005175.72714 | 2101732.2974900003 | 37.7512494064453 | -122.424951790803 | (37.7512494064453, -122.424951790803) | |||
| 18355 | 18355 | 5605 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1137 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005177.464240001 | 2101699.96728 | 37.7511607332939 | -122.424943483753 | (37.7511607332939, -122.424943483753) | |||
| 19067 | 19067 | 5609 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1148 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005093.60054 | 2101693.54565 | 37.75113836355 | -122.42523303668999 | (37.75113836355, -122.42523303669) | |||
| 17677 | 17677 | 5618 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1188 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005106.19937 | 2101428.2604799997 | 37.7504106636179 | -122.425170594072 | (37.7504106636179, -122.425170594072) | |||
| 18260 | 18260 | 5620 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1198 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005107.41501 | 2101411.03621 | 37.750363438429396 | -122.425165164842 | (37.7503634384294, -122.425165164842) | |||
| 17322 | 17322 | 5621 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1200 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/1997 12:00:00 AM | 12 | 3X3 | 6005112.05023 | 2101292.8901400003 | 37.7500392984813 | -122.42514073028099 | (37.7500392984813, -122.425140730281) | ||
| 17491 | 17491 | 5623 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1206 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005115.22639 | 2101256.4712400003 | 37.7499394800206 | -122.425127155905 | (37.7499394800206, -122.425127155905) | |||
| 18936 | 18936 | 5626 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1212 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005119.5171300005 | 2101140.6770599997 | 37.7496217783286 | -122.42510408019699 | (37.7496217783286, -122.425104080197) | |||
| 20546 | 20546 | 5630 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1231 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005204.70803 | 2101163.32944 | 37.7496887886191 | -122.424811098167 | (37.7496887886191, -122.424811098167) | |||
| 18207 | 18207 | 5631 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1234 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005123.01487 | 2101119.88751 | 37.749564892610394 | -122.425090505838 | (37.7495648926104, -122.425090505838) | |||
| 19967 | 19967 | 5638 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1272 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005135.78776 | 2100920.26504 | 37.749017496880995 | -122.425032135324 | (37.749017496881, -122.425032135324) | |||
| 17271 | 17271 | 5646 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1297 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 3X3 | 6005225.48444 | 2100822.82631 | 37.7487550189501 | -122.42471503258498 | (37.7487550189501, -122.424715032585) | |||
| 10178 | 10178 | 5650 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1306 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005149.82479 | 2100705.7608 | 37.748429310564106 | -122.42496833563601 | (37.7484293105641, -122.424968335636) | |||
| 18468 | 18468 | 5656 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1340 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6005156.96461 | 2100557.4969900004 | 37.7480226155558 | -122.424933099281 | (37.7480226155558, -122.424933099281) | |||
| 21956 | 21956 | 5657 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1348 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 7x7 | 6005159.98864 | 2100529.32517 | 37.7479454330293 | -122.424920638272 | (37.7479454330293, -122.424920638272) |
JSON shape: default, array, newline-delimited
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");