Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1037 | 1037 | 189668 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6015920.2977599995 | 2103253.32542 | 37.7560268866495 | -122.387901667748 | (37.7560268866495, -122.387901667748) | |||
| 1960 | 1960 | 18692 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999079.26803 | 2119858.05546 | 37.800671840202796 | -122.447338395052 | (37.8006718402028, -122.447338395052) | |||
| 2467 | 2467 | 192164 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 5ft | Permit Number 779453 | 6007314.84465 | 2109842.28548 | 37.7736381448041 | -122.418129368272 | (37.7736381448041, -122.418129368272) | ||
| 5579 | 5579 | 26845 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | Permit Number 775213 | 6006964.16578 | 2111032.6003799997 | 37.776886719994295 | -122.41942688403799 | (37.7768867199943, -122.419426884038) | ||
| 6913 | 6913 | 42637 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356463999 | (37.7982247489172, -122.42607356464) |
| 7903 | 7903 | 23532 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 9 | 3x3 | 6005730.01613 | 2119881.88283 | 37.8011150557677 | -122.42432573765801 | (37.8011150557677, -122.424325737658) | ||
| 14154 | 14154 | 117219 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013733.69082 | 2111323.12296 | 37.7780633857557 | -122.39602923405701 | (37.7780633857557, -122.396029234057) | |
| 15776 | 15776 | 100272 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015193.569569999 | 2113513.1652900004 | 37.7841578628497 | -122.391132065814 | (37.7841578628497, -122.391132065814) | |||
| 22434 | 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) | |||
| 23118 | 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) | |
| 23933 | 23933 | 128016 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 590 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008082.43699 | 2121383.0698599997 | 37.8053694902723 | -122.416291706192 | (37.8053694902723, -122.416291706192) | |||
| 25142 | 25142 | 127643 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 30 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007955.2586900005 | 2111707.55332 | 37.7787957513555 | -122.416046193094 | (37.7787957513555, -122.416046193094) | |||
| 25364 | 25364 | 127938 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2680 Leavenworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007365.918930001 | 2121887.11424 | 37.8067131511504 | -122.418807085686 | (37.8067131511504, -122.418807085686) | |||
| 26364 | 26364 | 126688 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2801 Divisadero St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6000574.048880001 | 2117936.56798 | 37.79548124560729 | -122.44202785340201 | (37.7954812456073, -122.442027853402) | |||
| 26688 | 26688 | 128421 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 555 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011600.63632 | 2116672.46382 | 37.792632510835205 | -122.403784779643 | (37.7926325108352, -122.403784779643) | |||
| 27247 | 27247 | 126839 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1700 Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001937.55377 | 2121143.67179 | 37.804364716433604 | -122.43753968513599 | (37.8043647164336, -122.437539685136) | |||
| 28516 | 28516 | 127610 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Myrtle St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007135.536169999 | 2114155.17167 | 37.785470194951 | -122.41905559625098 | (37.785470194951, -122.419055596251) | |||
| 28655 | 28655 | 189805 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2301 Alameda St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010182.35255 | 2107832.16681 | 37.7682798042076 | -122.408068386371 | (37.7682798042076, -122.408068386371) | |||
| 29084 | 29084 | 128090 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009951.3177 | 2121929.0355700003 | 37.8069734877909 | -122.409862736173 | (37.8069734877909, -122.409862736173) | |||
| 29773 | 29773 | 128224 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 68 Green St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012506.10829 | 2119556.4133200003 | 37.8006016885769 | -122.400854502449 | (37.8006016885769, -122.400854502449) | |||
| 31737 | 31737 | 128276 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6010962.710469999 | 2121375.05717 | 37.8055090290786 | -122.40632352801 | (37.8055090290786, -122.40632352801) | |||
| 32248 | 32248 | 249347 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 825 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008271.46114 | 2114824.52265 | 37.7873719714978 | -122.415173017931 | (37.7873719714978, -122.415173017931) | |||
| 34114 | 34114 | 224405 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 298 Clinton Park | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6004863.65624 | 2108215.6835 | 37.7690336186259 | -122.426492564193 | (37.7690336186259, -122.426492564193) | |||
| 34370 | 34370 | 192111 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 367 Tehama St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011472.90263 | 2112583.62947 | 37.7813984010644 | -122.403938880301 | (37.7813984010644, -122.403938880301) | |||
| 34949 | 34949 | 189630 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1455 11th St | 7 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6007441.71426 | 2110305.43642 | 37.7749169870715 | -122.41772334055901 | (37.7749169870715, -122.417723340559) | |||
| 36739 | 36739 | 128654 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012944.99431 | 2118859.4388200003 | 37.7987124341865 | -122.399286813242 | (37.7987124341865, -122.399286813242) | |||
| 38654 | 38654 | 192087 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 09th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6010677.93424 | 2108350.4025 | 37.769730496086 | -122.406390728966 | (37.769730496086, -122.406390728966) | |||
| 38934 | 38934 | 128755 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 Geary St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6010904.689619999 | 2114841.17743 | 37.7875653329327 | -122.406063721978 | (37.7875653329327, -122.406063721978) | |||
| 39145 | 39145 | 128109 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 102 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009824.62354 | 2121965.4752 | 37.8070664408401 | -122.410303763703 | (37.8070664408401, -122.410303763703) | |||
| 39147 | 39147 | 128532 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6012207.58991 | 2116821.4003 | 37.793075343307706 | -122.401695158101 | (37.7930753433077, -122.401695158101) | |||
| 40176 | 40176 | 224364 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3298 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6004947.36041 | 2106653.6362900003 | 37.764749342832104 | -122.426091820002 | (37.7647493428321, -122.426091820002) | |||
| 40397 | 40397 | 127634 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 11 Hyde St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008239.21705 | 2111794.19116 | 37.779049599393794 | -122.41507000059299 | (37.7790495993938, -122.415070000593) | |||
| 40510 | 40510 | 128576 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012747.342 | 2117831.85498 | 37.7958799168802 | -122.399898560867 | (37.7958799168802, -122.399898560867) | |||
| 40994 | 40994 | 127335 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2519 Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6003633.144859999 | 2116974.97757 | 37.793014816223 | -122.43137418947701 | (37.793014816223, -122.431374189477) | |||
| 42388 | 42388 | 189812 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010834.843090001 | 2107242.62186 | 37.766697559475105 | -122.40576994135598 | (37.7666975594751, -122.405769941356) | |||
| 42599 | 42599 | 190131 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6011654.92131 | 2097288.97497 | 37.7394128516087 | -122.402233521954 | (37.7394128516087, -122.402233521954) | |||
| 42610 | 42610 | 190236 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013048.93642 | 2115320.74397 | 37.78900180744421 | -122.39867867189 | (37.7890018074442, -122.39867867189) | |||
| 43269 | 43269 | 126992 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3298 Lyon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5998988.15912 | 2120165.48755 | 37.8015107592616 | -122.447675811712 | (37.8015107592616, -122.447675811712) | ||||
| 44419 | 44419 | 128155 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 200 Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008938.01662 | 2122186.29317 | 37.8076230123466 | -122.413387690112 | (37.8076230123466, -122.413387690112) | |||
| 46535 | 46535 | 127325 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2701 Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6003536.28306 | 2117659.90623 | 37.794889964762895 | -122.431758262041 | (37.7948899647629, -122.431758262041) | |||
| 48490 | 48490 | 128327 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 Union St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012210.62358 | 2119808.8026900003 | 37.8012782026937 | -122.401894758141 | (37.8012782026937, -122.401894758141) | |||
| 48642 | 48642 | 128399 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 316 Sutter St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 2ft | 6010737.082769999 | 2115568.6338 | 37.789553378722296 | -122.406694896775 | (37.7895533787223, -122.406694896775) | |||
| 49415 | 49415 | 128593 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 298 Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013139.86676 | 2117633.6194 | 37.795357484516295 | -122.398526424776 | (37.7953574845163, -122.398526424776) | |||
| 49770 | 49770 | 127469 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 726 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6009034.92183 | 2115323.10485 | 37.7887838333487 | -122.412566850996 | (37.7887838333487, -122.412566850996) | |||
| 50455 | 50455 | 190179 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Spear St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014074.231980001 | 2116888.78528 | 37.7933643539261 | -122.395241142863 | (37.7933643539261, -122.395241142863) | |||
| 51387 | 51387 | 218933 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1003 Ortega St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990778.98274 | 2102431.84048 | 37.7523464435342 | -122.474787872164 | (37.7523464435342, -122.474787872164) | |||
| 52229 | 52229 | 192076 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Vermont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011154.1372 | 2107629.21819 | 37.767776915900605 | -122.404692770268 | (37.7677769159006, -122.404692770268) | |||
| 53447 | 53447 | 128074 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 111 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6009478.77374 | 2121864.7268 | 37.8067704181858 | -122.411493531709 | (37.8067704181858, -122.411493531709) | |||
| 54186 | 54186 | 95553 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1333 Bush St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6007222.04725 | 2115366.66641 | 37.7888015338151 | -122.418842244669 | (37.7888015338151, -122.418842244669) | ||||
| 54256 | 54256 | 128003 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2445 Mason St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008817.62186 | 2121599.22016 | 37.8060042974296 | -122.413762792825 | (37.8060042974296, -122.413762792825) | |||
| 56424 | 56424 | 127987 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009619.29964 | 2121586.63724 | 37.80601473495471 | -122.410987557846 | (37.8060147349547, -122.410987557846) | |||
| 57105 | 57105 | 189746 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1800 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6012140.18497 | 2105642.48558 | 37.7623768548348 | -122.40114250943998 | (37.7623768548348, -122.40114250944) | |||
| 57608 | 57608 | 128292 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011685.15599 | 2120779.40875 | 37.803913910547294 | -122.403781453055 | (37.8039139105473, -122.403781453055) | |||
| 60281 | 60281 | 202078 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Gould St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6012742.601 | 2090834.0731400002 | 37.721749674703496 | -122.398020073164 | (37.7217496747035, -122.398020073164) | ||||
| 63622 | 63622 | 192125 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 807 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6011096.71819 | 2113372.25093 | 37.7835427463303 | -122.405295854729 | (37.7835427463303, -122.405295854729) | |||
| 64031 | 64031 | 128037 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 685 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007823.09444 | 2121635.5178900003 | 37.806048062038705 | -122.41720709733102 | (37.8060480620387, -122.417207097331) | |||
| 64774 | 64774 | 128187 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 151 Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009478.21071 | 2122214.1365400003 | 37.8077297780823 | -122.411520182236 | (37.8077297780823, -122.411520182236) | |||
| 65009 | 65009 | 127618 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 888 O'Farrell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6007093.2303 | 2114012.5981400004 | 37.78507634045221 | -122.419191845354 | (37.7850763404522, -122.419191845354) | |||
| 65586 | 65586 | 112702 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010077.3299 | 2121997.6645 | 37.80716898692771 | -122.40943148969102 | (37.8071689869277, -122.409431489691) | |||
| 65980 | 65980 | 192027 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012875.74039 | 2110695.7884 | 37.77629309727929 | -122.398953170173 | (37.7762930972793, -122.398953170173) | |||
| 67898 | 67898 | 190313 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 235 01st St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6013939.38091 | 2115053.62545 | 37.788317932359796 | -122.39557910629699 | (37.7883179323598, -122.395579106297) | |||
| 67971 | 67971 | 128492 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 Montgomery St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6011956.55611 | 2116131.9402099997 | 37.7911682382735 | -122.40251525079799 | (37.7911682382735, -122.402515250798) | |||
| 68475 | 68475 | 123304 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 05th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994338.97398 | 2112379.83373 | 37.779866680369004 | -122.463198710798 | (37.779866680369, -122.463198710798) | |||
| 68728 | 68728 | 128671 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013413.2137 | 2117977.34147 | 37.7963164882801 | -122.397604712284 | (37.7963164882801, -122.397604712284) | |||
| 70696 | 70696 | 127857 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1032 Broadway | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6008555.20047 | 2118315.13815 | 37.7969722882858 | -122.414438422015 | (37.7969722882858, -122.414438422015) | |||
| 71114 | 71114 | 189616 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1022 Harrison St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 0ft | 6010960.00413 | 2110606.3499 | 37.7759405837328 | -122.405573964684 | (37.7759405837328, -122.405573964684) | |||
| 71642 | 71642 | 224414 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Treat Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6008498.98653 | 2105917.02908 | 37.762926883786 | -122.413755524492 | (37.762926883786, -122.413755524492) | |||
| 71750 | 71750 | 192067 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011249.12867 | 2107468.95499 | 37.7673421782378 | -122.404352922768 | (37.7673421782378, -122.404352922768) | |||
| 71961 | 71961 | 127414 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1945 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005427.802519999 | 2116823.5699299998 | 37.792700635388606 | -122.42515379112601 | (37.7927006353886, -122.425153791126) | |||
| 73610 | 73610 | 192051 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 311 Townsend St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 8ft | 6013302.41922 | 2110215.29688 | 37.7749975429264 | -122.39744345487499 | (37.7749975429264, -122.397443454875) | |||
| 74218 | 74218 | 190246 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012243.7419300005 | 2115020.28985 | 37.7881319372733 | -122.40144343157301 | (37.7881319372733, -122.401443431573) | |||
| 75952 | 75952 | 226543 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1301 Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010637.73921 | 2101746.6676 | 37.7515958756507 | -122.406064466614 | (37.7515958756507, -122.406064466614) | |||
| 76757 | 76757 | 128437 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 315 Montgomery St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6011892.5017099995 | 2116589.46867 | 37.79242092643929 | -122.402769069158 | (37.7924209264393, -122.402769069158) | |||
| 76844 | 76844 | 128099 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2021 Grant Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010197.42674 | 2122104.48311 | 37.8074690124503 | -122.409023408829 | (37.8074690124503, -122.409023408829) | |||
| 94133 | 94133 | 102332 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3201X 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | |||
| 107285 | 107285 | 102341 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401X Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007842.0 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | |||
| 130040 | 130040 | 128602 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 302 Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012752.63127 | 2117575.0435599997 | 37.7951750687143 | -122.39986221657 | (37.7951750687143, -122.39986221657) | |||
| 130122 | 130122 | 128450 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Leidesdorff St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012147.27472 | 2116600.52614 | 37.7924655094397 | -122.40188831991001 | (37.7924655094397, -122.40188831991) | |||
| 130152 | 130152 | 189050 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1498 Fairfax Ave | 7 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6016154.01606 | 2097829.997 | 37.7411484972995 | -122.386715207445 | (37.7411484972995, -122.386715207445) | |||
| 130680 | 130680 | 218948 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 265 Casitas Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994974.326309999 | 2096444.2195099997 | 37.7361481498027 | -122.459846109406 | (37.7361481498027, -122.459846109406) | |||
| 130776 | 130776 | 224342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2789 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6010825.6121 | 2101786.2418 | 37.7517150439273 | -122.40541756176701 | (37.7517150439273, -122.405417561767) | |||
| 131394 | 131394 | 225356 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 133 Otis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006823.06416 | 2109286.7497400003 | 37.772085083982795 | -122.419791088814 | (37.7720850839828, -122.419791088814) | |||
| 131997 | 131997 | 192059 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650 07th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6011983.814619999 | 2109113.51904 | 37.771898806507394 | -122.40192735228099 | (37.7718988065074, -122.401927352281) | |||
| 135652 | 135652 | 126917 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 Maple St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996734.555919999 | 2114878.15027 | 37.7868641072511 | -122.455091962144 | (37.7868641072511, -122.455091962144) | |||
| 136809 | 136809 | 190334 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014720.686319999 | 2115960.41525 | 37.7908511957851 | -122.392939364079 | (37.7908511957851, -122.392939364079) | |||
| 137524 | 137524 | 128028 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2601 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007861.509930001 | 2121473.46742 | 37.8056052736304 | -122.41706266443 | (37.8056052736304, -122.41706266443) | |||
| 137541 | 137541 | 127219 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2864 Broadway | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5999916.98549 | 2117117.82475 | 37.793195727460706 | -122.44424253287599 | (37.7931957274607, -122.444242532876) | |||
| 137889 | 137889 | 128149 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 580 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007659.25914 | 2121669.6790400003 | 37.8061326414825 | -122.417776500385 | (37.8061326414825, -122.417776500385) | |||
| 144243 | 144243 | 104474 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 717 Battery St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2013 12:00:00 AM | 14 | Permit Number 767241 | 6012445.63467 | 2118546.91939 | 37.7978264877715 | -122.400992798387 | (37.7978264877715, -122.400992798387) | ||
| 146898 | 146898 | 128314 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1150 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011984.40166 | 2119726.28847 | 37.8010390109056 | -122.40267178407301 | (37.8010390109056, -122.402671784073) | |||
| 147114 | 147114 | 190159 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 70 Steuart St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6014355.228490001 | 2117111.93138 | 37.7939926841722 | -122.394284498051 | (37.7939926841722, -122.394284498051) | |||
| 147165 | 147165 | 190210 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013925.015319999 | 2116617.87783 | 37.792612205927206 | -122.395738456263 | (37.7926122059272, -122.395738456263) | |||
| 147364 | 147364 | 190341 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014814.94374 | 2116051.9719599998 | 37.7911078245033 | -122.39261964247801 | (37.7911078245033, -122.392619642478) | |||
| 147604 | 147604 | 126768 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 200 Moulton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002248.64122 | 2119333.11737 | 37.7994110923038 | -122.43633348560101 | (37.7994110923038, -122.436333485601) | |||
| 150863 | 150863 | 225507 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Church St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6004191.740130001 | 2106290.7229299997 | 37.763710133929294 | -122.428679441106 | (37.7637101339293, -122.428679441106) | |||
| 150981 | 150981 | 128695 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012818.92366 | 2117896.8128299997 | 37.7960622661024 | -122.39965543634199 | (37.7960622661024, -122.399655436342) | |||
| 151383 | 151383 | 128065 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 262 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009064.72363 | 2121808.37868 | 37.8065924675308 | -122.412922451915 | (37.8065924675308, -122.412922451915) | |||
| 152620 | 152620 | 190101 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014861.300969999 | 2113474.7267299998 | 37.7840338750996 | -122.39227891636101 | (37.7840338750996, -122.392278916361) | |||
| 153112 | 153112 | 127696 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 751 Powell St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 6010042.923140001 | 2116244.05578 | 37.79136906228221 | -122.409144305564 | (37.7913690622822, -122.409144305564) | |||
| 155693 | 155693 | 128082 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 109 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6009683.35171 | 2121893.27188 | 37.8068602685411 | -122.41078756392 | (37.8068602685411, -122.41078756392) |
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");