Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143 | 143 | 18836 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2055 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004953.14987 | 2116100.2629400003 | 37.7906877916676 | -122.426744576702 | (37.7906877916676, -122.426744576702) | |||
181 | 181 | 9914 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.42577893234899 | (37.7911641319684, -122.425778932349) | |||
183 | 183 | 15429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2015 12:00:00 AM | 15 | 4X4 | 6006871.98757 | 2105962.63928 | 37.762960616913205 | -122.41938599878401 | (37.7629606169132, -122.419385998784) | ||
269 | 269 | 127441 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2101 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 4ft | 6005937.76794 | 2117668.55868 | 37.795049557533105 | -122.423449386982 | (37.7950495575331, -122.423449386982) | |||
288 | 288 | 226558 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 7ft | 6004836.50691 | 2106380.98977 | 37.7639944545966 | -122.42645581878 | (37.7639944545966, -122.42645581878) | |||
315 | 315 | 127442 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2101 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 4ft | 6005941.14617 | 2117647.79475 | 37.794992735681504 | -122.423436220932 | (37.7949927356815, -122.423436220932) | |||
388 | 388 | 11057 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1630 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007426.31744 | 2117960.00612 | 37.795933702633796 | -122.418319444503 | (37.7959337026338, -122.418319444503) | |||
436 | 436 | 6932 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004980.8762 | 2110598.20876 | 37.775582081585895 | -122.42625675563801 | (37.7755820815859, -122.426256755638) | |||
562 | 562 | 15241 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 49662 | 6008042.0 | 2110573.0 | 37.7756854149614 | -122.415665767345 | (37.7756854149614, -122.415665767345) | ||
762 | 762 | 7350 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2239 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002792.88059 | 2116041.24067 | 37.790403357673895 | -122.434214763813 | (37.7904033576739, -122.434214763813) | |||
926 | 926 | 19204 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012243.07343 | 2117875.4725099998 | 37.7959715542054 | -122.401646502996 | (37.7959715542054, -122.401646502996) | |||
941 | 941 | 18512 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010135.39241 | 2115955.1821 | 37.790581064620106 | -122.408803973339 | (37.7905810646201, -122.408803973339) | |||
945 | 945 | 26844 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | ||
1018 | 1018 | 7366 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2360 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002774.54957 | 2116438.38146 | 37.79149276403471 | -122.434306592692 | (37.7914927640347, -122.434306592692) | |||
1021 | 1021 | 189660 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 4ft | 6015900.45488 | 2103484.96239 | 37.7566618134199 | -122.38798645493601 | (37.7566618134199, -122.387986454936) | |||
1035 | 1035 | 189666 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 5ft | 6015923.45326 | 2103178.08659 | 37.7558204715491 | -122.38788550510598 | (37.7558204715491, -122.387885505106) | |||
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) | |||
1044 | 1044 | 189667 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 5ft | 6015923.778390001 | 2103213.67674 | 37.7559182125844 | -122.38788686398199 | (37.7559182125844, -122.387886863982) | |||
1046 | 1046 | 189659 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2573 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 4ft | 6015895.51865 | 2103530.26934 | 37.7567859432258 | -122.388006687875 | (37.7567859432258, -122.388006687875) | |||
1055 | 1055 | 21993 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015910.4355 | 2103353.3332599998 | 37.756300940646604 | -122.387942753271 | (37.7563009406466, -122.387942753271) | |||
1057 | 1057 | 189664 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 5ft | 6015924.43943 | 2103136.85911 | 37.755707324239395 | -122.38787921795799 | (37.7557073242394, -122.387879217958) | |||
1062 | 1062 | 189665 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6015925.0907 | 2103156.8300799998 | 37.755762196378996 | -122.387878359099 | (37.755762196379, -122.387878359099) | |||
1074 | 1074 | 11442 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2200X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6005100.87554 | 2117226.15448 | 37.7937875569128 | -122.42631364855801 | (37.7937875569128, -122.426313648558) | |||
1182 | 1182 | 11089 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/2007 12:00:00 AM | 70 | 3X3 | 6007306.35542 | 2118856.39008 | 37.798388195314296 | -122.418798140138 | (37.7983881953143, -122.418798140138) | ||
1306 | 1306 | 127778 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1459 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6007455.77406 | 2117413.73976 | 37.794435449198495 | -122.418178770753 | (37.7944354491985, -122.418178770753) | |||
1435 | 1435 | 226556 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 301 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 6ft | 6004916.06592 | 2106558.9555200003 | 37.7644876032441 | -122.42619331838199 | (37.7644876032441, -122.426193318382) | |||
1441 | 1441 | 226555 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 301 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 6ft | 6004913.144780001 | 2106531.61539 | 37.7644123686589 | -122.42620147522699 | (37.7644123686589, -122.426201475227) | |||
1568 | 1568 | 251592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1999X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6007220.0 | 2119146.0 | 37.799178528828 | -122.41911751038602 | (37.799178528828, -122.419117510386) | |||
1752 | 1752 | 11021 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1407 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007490.12051 | 2117192.20597 | 37.7938291055709 | -122.41804421508002 | (37.7938291055709, -122.41804421508) | |||
1787 | 1787 | 11037 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1523 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007436.11305 | 2117588.78298 | 37.794914967702496 | -122.41825921689801 | (37.7949149677025, -122.418259216898) | |||
1802 | 1802 | 123705 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 448 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 7 | Width 3ft | 5994163.86514 | 2111457.6280799997 | 37.7773244619044 | -122.46373753196501 | (37.7773244619044, -122.463737531965) | ||
2043 | 2043 | 127861 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6007317.93078 | 2118761.71757 | 37.798128900073294 | -122.418751368192 | (37.7981289000733, -122.418751368192) | |||
2047 | 2047 | 127862 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6007316.9194 | 2118776.88276 | 37.7981704829404 | -122.41875594393 | (37.7981704829404, -122.41875594393) | |||
2060 | 2060 | 127860 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 6ft | 6007322.606430001 | 2118731.77235 | 37.798046941256 | -122.418733064272 | (37.798046941256, -122.418733064272) | |||
2209 | 2209 | 189798 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6010293.93626 | 2108038.50565 | 37.7688526102954 | -122.407696978027 | (37.7688526102954, -122.407696978027) | |||
2364 | 2364 | 192162 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 29 | Width 5ft | Permit Number 779453 | 6007414.0762 | 2109937.75552 | 37.7739058675964 | -122.417792878858 | (37.7739058675964, -122.417792878858) | ||
2416 | 2416 | 192163 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 29 | Width 5ft | Permit Number 779453 | 6007335.7591 | 2109863.52425 | 37.7736976385647 | -122.41805852779 | (37.7736976385647, -122.41805852779) | ||
2426 | 2426 | 192160 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 3ft | Permit Number 779453 | 6007491.12658 | 2110012.65001 | 37.774115845790796 | -122.41753165726699 | (37.7741158457908, -122.417531657267) | ||
2442 | 2442 | 192161 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | Width 5ft | Permit Number 779453 | 6007448.619659999 | 2109968.2743599997 | 37.7739916089565 | -122.417675550588 | (37.7739916089565, -122.417675550588) | ||
2449 | 2449 | 192165 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2008 12:00:00 AM | 29 | Width 4ft | Permit Number 779453 | 6007288.76075 | 2109818.60353 | 37.7735716516336 | -122.418217917334 | (37.7735716516336, -122.418217917334) | |
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) | ||
2646 | 2646 | 18988 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2939 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000733.58986 | 2115514.6365 | 37.7888403449574 | -122.44130195304301 | (37.7888403449574, -122.441301953043) | |||
2697 | 2697 | 11019 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1401 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007491.51177 | 2117162.78636 | 37.793748404921 | -122.418037314589 | (37.793748404921, -122.418037314589) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
6266 | 6266 | 11079 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1827 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007292.79546 | 2118623.6274900003 | 37.7977483240791 | -122.41882854531 | (37.7977483240791, -122.41882854531) | |||
6294 | 6294 | 23536 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005728.741 | 2119933.47422 | 37.801256640539606 | -122.424333821661 | (37.8012566405396, -122.424333821661) | |||
6311 | 6311 | 18513 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010133.96255 | 2115968.0118400003 | 37.7906162119074 | -122.408809826127 | (37.7906162119074, -122.408809826127) | |||
6379 | 6379 | 7348 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2226 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002838.16405 | 2116011.64355 | 37.79032466161 | -122.434055969611 | (37.79032466161, -122.434055969611) | |||
6483 | 6483 | 23497 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2529 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6005737.90239 | 2119081.40662 | 37.7989175974325 | -122.424241484673 | (37.7989175974325, -122.424241484673) | |||
6487 | 6487 | 27264 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1735 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6006104.02915 | 2116478.43214 | 37.791791150977105 | -122.422789477077 | (37.7917911509771, -122.422789477077) | |||
6494 | 6494 | 7364 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2360 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002779.17574 | 2116404.82668 | 37.7914008937989 | -122.43428818627198 | (37.7914008937989, -122.434288186272) | |||
6527 | 6527 | 18518 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6010076.89605 | 2116057.79617 | 37.7908595414795 | -122.409013611597 | (37.7908595414795, -122.409013611597) | |||
6535 | 6535 | 23531 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 12 | 3x14 | 6005745.76756 | 2119852.67475 | 37.801035747261096 | -122.42426915231701 | (37.8010357472611, -122.424269152317) | ||
6581 | 6581 | 18689 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 210 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999128.28109 | 2119816.58855 | 37.800560783808706 | -122.44716580436899 | (37.8005607838087, -122.447165804369) | |||
6647 | 6647 | 23432 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1946 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6006100.2402099995 | 2117213.04995 | 37.7938080137776 | -122.42285481909799 | (37.7938080137776, -122.422854819098) | |||
6742 | 6742 | 11038 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1520 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007480.78096 | 2117584.84386 | 37.7949066660644 | -122.41810437973801 | (37.7949066660644, -122.418104379738) |
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");