Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2750 | 2750 | 23535 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005732.6393 | 2119914.78395 | 37.8012055419589 | -122.424319001733 | (37.8012055419589, -122.424319001733) | |||
2770 | 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) | |||
2796 | 2796 | 101896 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1030 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 769674 | 6008183.011080001 | 2116026.65387 | 37.7906677592601 | -122.41556418166901 | (37.7906677592601, -122.415564181669) | ||
2843 | 2843 | 23527 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005732.6493 | 2119830.06962 | 37.800972938614294 | -122.424312938499 | (37.8009729386143, -122.424312938499) | |||
2879 | 2879 | 105455 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2307X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777222 | 6003193.66965 | 2116635.80681 | 37.7920586237566 | -122.43287055523899 | (37.7920586237566, -122.432870555239) | |
2893 | 2893 | 11107 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2016 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007247.08519 | 2119278.6571299997 | 37.799544297196995 | -122.419033200434 | (37.799544297197, -122.419033200434) | |||
2950 | 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) | ||
3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
3059 | 3059 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2829 Divisadero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.44211236900601 | (37.7957189625051, -122.442112369006) | ||
3064 | 3064 | 104743 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010761.049240001 | 2116971.9366099997 | 37.7934078523287 | -122.406710911 | (37.7934078523287, -122.406710911) | |||
3067 | 3067 | 104742 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010759.24365 | 2116982.20549 | 37.793435947175205 | -122.406717882525 | (37.7934359471752, -122.406717882525) | |||
3069 | 3069 | 128380 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010746.0 | 2116993.0 | 37.7934648453026 | -122.406764467868 | (37.7934648453026, -122.406764467868) | |||
3213 | 3213 | 107592 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1812 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772847 | 5999539.4256 | 2115189.16926 | 37.7878785991598 | -122.44541016857 | (37.7878785991598, -122.44541016857) | |
3241 | 3241 | 23530 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005733.88187 | 2119852.14358 | 37.8010336176693 | -122.424310244146 | (37.8010336176693, -122.424310244146) | |||
3308 | 3308 | 220877 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 600X Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998682.13916 | 2105626.63204 | 37.7615733510574 | -122.44768755773701 | (37.7615733510574, -122.447687557737) | |||
3329 | 3329 | 110970 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2485 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002790.71835 | 2116462.02658 | 37.791558605188705 | -122.434252340185 | (37.7915586051887, -122.434252340185) | |||
3358 | 3358 | 11102 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1987 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007225.03995 | 2119093.74122 | 37.799035323169704 | -122.419096361621 | (37.7990353231697, -122.419096361621) | |||
3407 | 3407 | 11127 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2124 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007196.70195 | 2119630.59252 | 37.8005077858571 | -122.419232523471 | (37.8005077858571, -122.419232523471) | |||
3414 | 3414 | 102265 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2029 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6001885.4061199995 | 2115556.68597 | 37.789021347891 | -122.437319848541 | (37.789021347891, -122.437319848541) | |||
3474 | 3474 | 106212 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 585X Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 12 | 3x5 | 6010752.41967 | 2115858.63176 | 37.790350501826204 | -122.406662277468 | (37.7903505018262, -122.406662277468) | |||
3499 | 3499 | 85478 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1745 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6007333.51995 | 2118328.0568 | 37.7969390538357 | -122.41866665564699 | (37.7969390538357, -122.418666655647) | |||
3516 | 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) | |||
3564 | 3564 | 127915 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007842.32885 | 2121243.82267 | 37.8049736482837 | -122.417112761139 | (37.8049736482837, -122.417112761139) | |||
3574 | 3574 | 127916 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007863.0053199995 | 2121226.60678 | 37.8049275409425 | -122.417039987112 | (37.8049275409425, -122.417039987112) | |||
3594 | 3594 | 127750 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1033 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008528.0 | 2116225.0 | 37.791231755005896 | -122.41438457516001 | (37.7912317550059, -122.41438457516) | |||
3607 | 3607 | 107433 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3000 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999745.83562 | 2116735.23196 | 37.792135462722705 | -122.444807206383 | (37.7921354627227, -122.444807206383) | |||
3624 | 3624 | 127356 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Webster St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003284.8942599995 | 2116317.33043 | 37.7911893426569 | -122.432532159241 | (37.7911893426569, -122.432532159241) | ||
3628 | 3628 | 127357 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Webster St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003276.2668 | 2116362.2656799997 | 37.791312234126295 | -122.432565221033 | (37.7913122341263, -122.432565221033) | ||
3655 | 3655 | 116023 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 755 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x5 | 6012121.98551 | 2118393.88956 | 37.7973882454367 | -122.40210195745199 | (37.7973882454367, -122.402101957452) | |||
3669 | 3669 | 128007 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008574.61168 | 2121448.10995 | 37.8055757371873 | -122.414593071218 | (37.8055757371873, -122.414593071218) | ||
3671 | 3671 | 128005 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 444 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008626.93235 | 2121456.53692 | 37.805601814825394 | -122.414412604251 | (37.8056018148254, -122.414412604251) | ||
3725 | 3725 | 51148 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600X North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 47562 | 6003040.244080001 | 2121015.99755 | 37.804076787673104 | -122.43371460583799 | (37.8040767876731, -122.433714605838) | ||
3728 | 3728 | 18515 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 634 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010129.36296 | 2116007.85487 | 37.790725353638 | -122.408828552704 | (37.790725353638, -122.408828552704) | |||
3741 | 3741 | 11063 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1706 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X4 | 6007392.7334199995 | 2118206.86499 | 37.7966096249815 | -122.418453164696 | (37.7966096249815, -122.418453164696) | |||
3802 | 3802 | 11116 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2054 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007222.73261 | 2119440.0608900003 | 37.7999860999421 | -122.419128924277 | (37.7999860999421, -122.419128924277) | |||
3872 | 3872 | 62953 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1439 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1986 12:00:00 AM | 14 | 3x3 | Permit Number 23336 | 6006137.63839 | 2118621.23272 | 37.797676639130295 | -122.42282554258101 | (37.7976766391303, -122.422825542581) | |
3947 | 3947 | 93478 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 1.5x3 | Tree 3 on Leroy | 6008314.47624 | 2116646.88711 | 37.792378156480396 | -122.415153240053 | (37.7923781564804, -122.415153240053) | ||
3958 | 3958 | 49965 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1809 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 7 | Permit Number 47574 | 5999971.572269999 | 2115235.0808 | 37.7880293201371 | -122.443918325478 | (37.7880293201371, -122.443918325478) | ||
3995 | 3995 | 18900 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2590 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002437.1511699995 | 2115800.3303799997 | 37.789721683256296 | -122.435428321554 | (37.7897216832563, -122.435428321554) | |||
4248 | 4248 | 115669 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600X Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001202.18162 | 2117312.3728400003 | 37.793803143947294 | -122.43980963780399 | (37.7938031439473, -122.439809637804) | |
4314 | 4314 | 100306 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1434 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769213 | 6008902.154180001 | 2117844.1551 | 37.795698569500104 | -122.413204553065 | (37.7956985695001, -122.413204553065) | |
4442 | 4442 | 11124 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2115 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2002 12:00:00 AM | 3 | 3X3 | 6007136.72657 | 2119705.75668 | 37.8007107898386 | -122.41944539839899 | (37.8007107898386, -122.419445398399) | ||
4476 | 4476 | 94930 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1771 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004538.80013 | 2118744.2703 | 37.7979241280397 | -122.428366733352 | (37.7979241280397, -122.428366733352) | |||
4539 | 4539 | 112349 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 Perine Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002105.70967 | 2115571.30242 | 37.7890740023038 | -122.436558674947 | (37.7890740023038, -122.436558674947) | |||
4543 | 4543 | 224782 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3870 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/1976 12:00:00 AM | 23 | Width 4ft | Permit Number 16267 | 6004694.83499 | 2101360.27534 | 37.7502007447699 | -122.426588281746 | (37.7502007447699, -122.426588281746) | |
4585 | 4585 | 11106 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2000 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007250.571380001 | 2119242.4391400004 | 37.7994450480158 | -122.41901856665899 | (37.7994450480158, -122.419018566659) | |||
4624 | 4624 | 98532 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999984.2458 | 2115196.51475 | 37.7879241507313 | -122.443871705528 | (37.7879241507313, -122.443871705528) | |||
4756 | 4756 | 11056 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1626 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007429.229230001 | 2117940.34689 | 37.795879887193706 | -122.418307974559 | (37.7958798871937, -122.418307974559) | |||
4853 | 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) | |||
4868 | 4868 | 225613 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 235 Laussat St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | |||
4878 | 4878 | 23564 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2945 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005549.1196800005 | 2120503.94425 | 37.8028128606857 | -122.424996002386 | (37.8028128606857, -122.424996002386) | |||
5073 | 5073 | 104053 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2465 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6002918.10064 | 2116474.72915 | 37.791600712350295 | -122.433812507839 | (37.7916007123503, -122.433812507839) | ||||
5148 | 5148 | 11040 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1529 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6007430.95213 | 2117616.8305599997 | 37.7949916888776 | -122.418279064023 | (37.7949916888776, -122.418279064023) | |||
5196 | 5196 | 225446 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4633 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1979 12:00:00 AM | 14 | Width 3ft | Permit Number 18031 | 6000267.22366 | 2105166.93872 | 37.760401610855496 | -122.442172414947 | (37.7604016108555, -122.442172414947) | |
5200 | 5200 | 18839 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2055 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005013.40971 | 2116109.26217 | 37.7907159080697 | -122.426536721815 | (37.7907159080697, -122.426536721815) | |||
5202 | 5202 | 123243 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 590 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | Permit Number 780398 | 5993481.9137 | 2111464.4660900002 | 37.7773039172851 | -122.466097100812 | (37.7773039172851, -122.466097100812) | ||
5232 | 5232 | 11064 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1718 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x4 | 6007387.23956 | 2118261.4099 | 37.79675908240829 | -122.418476044354 | (37.7967590824083, -122.418476044354) | |||
5276 | 5276 | 64629 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1824 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1988 12:00:00 AM | 12 | 3x3 | Permit Number 25539 | 6004249.16577 | 2118756.87495 | 37.7979423438312 | -122.429369849745 | (37.7979423438312, -122.429369849745) | |
5284 | 5284 | 14661 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 683 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2016 12:00:00 AM | 35 | 3x3 | 6005906.95663 | 2112062.04188 | 37.7796537135926 | -122.42315728808501 | (37.7796537135926, -122.423157288085) | ||
5365 | 5365 | 23511 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2642 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005783.8382 | 2119486.2694099997 | 37.8000318412439 | -122.42411133926599 | (37.8000318412439, -122.424111339266) | |||
5400 | 5400 | 100479 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 340 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009830.0840300005 | 2114659.89537 | 37.7870074133103 | -122.40976885865601 | (37.7870074133103, -122.409768858656) | |||
5444 | 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) | |||
5446 | 5446 | 110972 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2485 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6002826.66374 | 2116467.13888 | 37.7915746823815 | -122.43412833534799 | (37.7915746823815, -122.434128335348) | |||
5454 | 5454 | 26842 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 775213 | 6006970.057999999 | 2110963.93279 | 37.7766985071661 | -122.419401628405 | (37.7766985071661, -122.419401628405) | ||
5474 | 5474 | 23494 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2517 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6005746.70695 | 2119056.5774 | 37.7988499198478 | -122.424209251152 | (37.7988499198478, -122.424209251152) | |||
5497 | 5497 | 23429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1940 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006113.16891 | 2117146.74095 | 37.7936266753722 | -122.422805369879 | (37.7936266753722, -122.422805369879) | |||
5534 | 5534 | 11055 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1623 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007391.69604 | 2117910.02014 | 37.7957945046705 | -122.41843569535 | (37.7957945046705, -122.41843569535) | |||
5535 | 5535 | 98626 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002283.11168 | 2120054.94147 | 37.8013949904512 | -122.43626589165301 | (37.8013949904512, -122.436265891653) | ||
5558 | 5558 | 18892 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2512 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002699.44606 | 2115838.2675 | 37.789840741817706 | -122.43452352174499 | (37.7898407418177, -122.434523521745) | |||
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) | ||
5583 | 5583 | 11099 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1954 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007274.65529 | 2119058.52438 | 37.7989414204558 | -122.41892217641599 | (37.7989414204558, -122.418922176416) | |||
5680 | 5680 | 112346 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 21 Perine Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002111.28405 | 2115552.10792 | 37.789021615903 | -122.436538013926 | (37.789021615903, -122.436538013926) | |||
5696 | 5696 | 98622 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002297.34528 | 2119958.5907400004 | 37.8011312453645 | -122.436209738003 | (37.8011312453645, -122.436209738003) | ||
5799 | 5799 | 9920 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1950 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005221.35655 | 2116381.71252 | 37.7914757416708 | -122.42583663734501 | (37.7914757416708, -122.425836637345) | |||
5844 | 5844 | 11094 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1919 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6007253.30573 | 2118908.87044 | 37.798529306126795 | -122.41898543293001 | (37.7985293061268, -122.41898543293) | |||
5845 | 5845 | 110971 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2485 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6002809.55078 | 2116465.5408400004 | 37.791569323321 | -122.434187431628 | (37.791569323321, -122.434187431628) | |||
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) | |||
5868 | 5868 | 106881 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3261 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778851 | 5999192.38841 | 2115631.9922700003 | 37.789074657915 | -122.446642721777 | (37.789074657915, -122.446642721777) | ||
5870 | 5870 | 11049 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007448.09091 | 2117829.58315 | 37.7955768192645 | -122.41823485247299 | (37.7955768192645, -122.418234852473) | |||
5911 | 5911 | 11043 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1544 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007466.55131 | 2117689.1178599996 | 37.795192175619704 | -122.41816101271601 | (37.7951921756197, -122.418161012716) | |||
5933 | 5933 | 11024 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1421 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007479.55159 | 2117260.34001 | 37.7940155898903 | -122.418085617153 | (37.7940155898903, -122.418085617153) | |||
5942 | 5942 | 11045 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1555 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007422.39408 | 2117681.06672 | 37.7951675836594 | -122.418313232892 | (37.7951675836594, -122.418313232892) | |||
5945 | 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) | |||
5960 | 5960 | 23430 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1940 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006108.8789099995 | 2117166.17514 | 37.793679794731396 | -122.422821595465 | (37.7936797947314, -122.422821595465) | |||
5971 | 5971 | 11078 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1825X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6007296.45899 | 2118589.59773 | 37.7976550931564 | -122.41881345378799 | (37.7976550931564, -122.418813453788) | |||
6009 | 6009 | 103505 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1348 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008358.2632 | 2116617.67877 | 37.7923004181806 | -122.41499966729799 | (37.7923004181806, -122.414999667298) | |||
6013 | 6013 | 95273 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004855.86616 | 2110874.93767 | 37.776334844721 | -122.42670890691299 | (37.776334844721, -122.426708906913) | |||
6021 | 6021 | 11047 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1563 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4x4 | 6007413.09908 | 2117743.8873400004 | 37.7953395502211 | -122.41834985148 | (37.7953395502211, -122.41834985148) | |||
6036 | 6036 | 11119 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6007209.66009 | 2119548.23397 | 37.8002823797943 | -122.41918183766701 | (37.8002823797943, -122.419181837667) | |||
6046 | 6046 | 69534 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2471 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38589 | 6002877.05945 | 2116466.93377 | 37.7915769792578 | -122.433953952308 | (37.7915769792578, -122.433953952308) | |
6051 | 6051 | 11126 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2115 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007143.25106 | 2119664.6187 | 37.8005982028049 | -122.419419900825 | (37.8005982028049, -122.419419900825) | |||
6056 | 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) | |||
6094 | 6094 | 11092 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1913 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 5x5 | 6007257.74663 | 2118885.66933 | 37.7984658517671 | -122.41896841955099 | (37.7984658517671, -122.418968419551) | |||
6113 | 6113 | 106866 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1892 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 6003972.43426 | 2118715.7250900003 | 37.7978136859103 | -122.430324481915 | (37.7978136859103, -122.430324481915) | |||
6114 | 6114 | 18942 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2788 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6001482.36653 | 2115669.03687 | 37.789306914141704 | -122.43872236373998 | (37.7893069141417, -122.43872236374) | |||
6128 | 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) | |||
6163 | 6163 | 27270 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2080 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006058.24019 | 2117527.2274 | 37.7946682962453 | -122.423022484211 | (37.7946682962453, -122.423022484211) | |||
6178 | 6178 | 11083 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1853 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007278.4685 | 2118708.01787 | 37.7979792322209 | -122.41888410901001 | (37.7979792322209, -122.41888410901) | |||
6208 | 6208 | 11051 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1601 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007396.80616 | 2117887.0680299997 | 37.7957317715643 | -122.418416385103 | (37.7957317715643, -122.418416385103) | |||
6211 | 6211 | 106217 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 585X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 10 | 3x5 | 6010670.9358 | 2115847.8332700003 | 37.790316292506795 | -122.40694344599301 | (37.7903162925068, -122.406943445993) |
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");