Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 | 29 | 188686 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 20 | : 4 | Tree 1 | DPW 2 | 12 | Width 3ft | 6017760.57019 | 2097020.5910900002 | 37.739014844955705 | -122.381104000867 | (37.7390148449557, -122.381104000867) | |||
| 32 | 32 | 10933 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1359 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016893.48466 | 2096461.5108299998 | 37.7374318223223 | -122.384063092353 | (37.7374318223223, -122.384063092353) | |||
| 46 | 46 | 18228 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2004 12:00:00 AM | 12 | 3X3 | 6003682.1522 | 2114179.2812 | 37.785341320174396 | -122.431004998109 | (37.7853413201744, -122.431004998109) | ||
| 69 | 69 | 19206 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.40169859442699 | (37.7962500076802, -122.401698594427) | |||
| 72 | 72 | 25725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004286.7153 | 2111148.1106 | 37.777052715887706 | -122.428697236196 | (37.7770527158877, -122.428697236196) | |||
| 97 | 97 | 5266 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6001289.7409 | 2112772.8314 | 37.781343716873 | -122.43918115910401 | (37.781343716873, -122.439181159104) | |||
| 110 | 110 | 97646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5988290.0 | 2103126.0 | 37.7541078738982 | -122.48344595561899 | (37.7541078738982, -122.483445955619) | |||
| 116 | 116 | 26163 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999083.87135 | 2119853.9919 | 37.8006609458028 | -122.447322173097 | (37.8006609458028, -122.447322173097) | |||
| 124 | 124 | 20281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 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) | |||
| 175 | 175 | 17881 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | |||
| 194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
| 232 | 232 | 2726 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002817.4873 | 2114756.5606 | 37.7868773504916 | -122.43403775447099 | (37.7868773504916, -122.434037754471) | |||
| 237 | 237 | 2654 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1988 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 12 | 3X3 | 6004003.2237 | 2114978.8425 | 37.7875549020514 | -122.429951242636 | (37.7875549020514, -122.429951242636) | ||
| 255 | 255 | 19810 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 100 STAIRWAY24 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
| 264 | 264 | 20199 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002784.1975 | 2112923.5771 | 37.7818425521761 | -122.434021853774 | (37.7818425521761, -122.434021853774) | ||
| 278 | 278 | 9598 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003113.217999999 | 2112071.7207 | 37.7795222347306 | -122.43282272296999 | (37.7795222347306, -122.43282272297) | |||
| 286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
| 292 | 292 | 9421 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.42259863641199 | (37.7806825946662, -122.422598636412) | |
| 296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
| 337 | 337 | 14819 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | |||
| 342 | 342 | 21738 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002837.9936 | 2114410.7158 | 37.7859289122324 | -122.43394207733601 | (37.7859289122324, -122.433942077336) | |||
| 352 | 352 | 14742 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.779313094037704 | -122.427075791541 | (37.7793130940377, -122.427075791541) | |||
| 370 | 370 | 3092 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2980 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000114.4381800005 | 2115142.33295 | 37.7877828069853 | -122.443417371621 | (37.7877828069853, -122.443417371621) | |||
| 405 | 405 | 13887 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1028 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009423.7082400005 | 2112763.96692 | 37.781778865529105 | -122.411040866943 | (37.7817788655291, -122.411040866943) | |||
| 419 | 419 | 13971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008925.3091 | 2112314.2981 | 37.780516220741 | -122.412733301341 | (37.780516220741, -122.412733301341) | |||
| 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) | |||
| 455 | 455 | 234501 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2423 Market St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 8ft | 6002117.5892 | 2105782.84009 | 37.7621980066439 | -122.435816935712 | (37.7621980066439, -122.435816935712) | |||
| 460 | 460 | 142327 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 468 | 468 | 18829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.42495419379601 | (37.791048376629, -122.424954193796) | |||
| 470 | 470 | 98535 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | Permit Number 779899 | 5999990.232999999 | 2115142.7171 | 37.7877767779168 | -122.44384712433799 | (37.7877767779168, -122.443847124338) | ||
| 477 | 477 | 14079 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | ||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 493 | 493 | 14089 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 779892 | 6007243.2905 | 2110686.0046 | 37.7759507683181 | -122.418436722662 | (37.7759507683181, -122.418436722662) | ||
| 494 | 494 | 14085 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.775991697649104 | -122.418387229062 | (37.7759916976491, -122.418387229062) | ||
| 526 | 526 | 18856 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004191.661859999 | 2115995.22985 | 37.790356315029996 | -122.429371791378 | (37.79035631503, -122.429371791378) | |||
| 577 | 577 | 15499 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2704 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006991.0 | 2102555.0 | 37.7536107294676 | -122.41873270043001 | (37.7536107294676, -122.41873270043) | |||
| 579 | 579 | 2702 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2121 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003192.7078 | 2114808.0993 | 37.7870401500361 | -122.432743262211 | (37.7870401500361, -122.432743262211) | |||
| 584 | 584 | 14069 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007575.3554 | 2111000.5411 | 37.7768330981624 | -122.417310315452 | (37.7768330981624, -122.417310315452) | |||
| 602 | 602 | 15498 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.41865020170799 | (37.7536532168709, -122.418650201708) | |||
| 612 | 612 | 23503 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005820.29029 | 2119236.56275 | 37.7993482683535 | -122.42396743424999 | (37.7993482683535, -122.42396743425) | |||
| 615 | 615 | 2703 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2123 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1987 12:00:00 AM | 12 | 3X3 | 6003147.2203 | 2114799.0941 | 37.7870128441602 | -122.432899995096 | (37.7870128441602, -122.432899995096) | ||
| 647 | 647 | 13705 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6011215.546569999 | 2114485.16599 | 37.786605191509295 | -122.404963137048 | (37.7866051915093, -122.404963137048) | |||
| 684 | 684 | 24323 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006332.380890001 | 2112512.31586 | 37.7809140549901 | -122.42171754994101 | (37.7809140549901, -122.421717549941) | |||
| 686 | 686 | 23735 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 805 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2016 12:00:00 AM | 12 | 4X4 | 6003900.7925 | 2111534.0109 | 37.778090453740504 | -122.430059798517 | (37.7780904537405, -122.430059798517) | ||
| 696 | 696 | 5946 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.43084551167601 | (37.7815635260957, -122.430845511676) | |||
| 704 | 704 | 2199 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000885.4114 | 2112518.5919999997 | 37.7806226245627 | -122.440561697516 | (37.7806226245627, -122.440561697516) | |||
| 723 | 723 | 230153 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6004293.15538 | 2105508.69845 | 37.7615686206128 | -122.428272938555 | (37.7615686206128, -122.428272938555) | |||
| 760 | 760 | 38424 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1451 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/24/2005 12:00:00 AM | 12 | 3x3 | Permit Number 48015 | 6007280.7970900005 | 2117415.82487 | 37.79443132398921 | -122.418784361633 | (37.7944313239892, -122.418784361633) |
| 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) | |||
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 803 | 803 | 5878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1090 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005272.8038 | 2113070.2583 | 37.7823862204069 | -122.425422868476 | (37.7823862204069, -122.425422868476) | |||
| 812 | 812 | 19648 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 848 | 848 | 2190 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1055 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000864.0909 | 2112351.4116 | 37.7801623757286 | -122.44062346036199 | (37.7801623757286, -122.440623460362) | |||
| 850 | 850 | 14550 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 834 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1993 12:00:00 AM | 12 | 3X3 | 5999292.7589 | 2109954.5102 | 37.7734914941004 | -122.445886958088 | (37.7734914941004, -122.445886958088) | ||
| 854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
| 871 | 871 | 20198 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002788.752 | 2112893.404 | 37.7817599629104 | -122.43400393984501 | (37.7817599629104, -122.434003939845) | ||
| 884 | 884 | 20233 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1724 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002600.0088 | 2114219.702 | 37.785390928556396 | -122.43475177403499 | (37.7853909285564, -122.434751774035) | |||
| 889 | 889 | 3094 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3006 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 5999959.6352699995 | 2115120.4195 | 37.7877138091859 | -122.443951383666 | (37.7877138091859, -122.443951383666) | |||
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 911 | 911 | 12249 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.42623573054199 | (37.7758762780635, -122.426235730542) | |||
| 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) | |||
| 943 | 943 | 17376 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Property owner contact Achmed 821-1594. | 6014810.6051199995 | 2095342.4042099998 | 37.7342436096391 | -122.391186437905 | (37.7342436096391, -122.391186437905) | ||
| 972 | 972 | 17847 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2082 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003983.5737 | 2115317.762 | 37.788484376640206 | -122.430043414021 | (37.7884843766402, -122.430043414021) | |||
| 1016 | 1016 | 225959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.41836543223101 | (37.7377988968125, -122.418365432231) | |
| 1042 | 1042 | 21994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015909.89309 | 2103367.8988900003 | 37.756340904732596 | -122.387945645479 | (37.7563409047326, -122.387945645479) | |||
| 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) | |||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1119 | 1119 | 38280 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.9950099997 | 37.758114643000795 | -122.395027213942 | (37.7581146430008, -122.395027213942) | ||
| 1123 | 1123 | 28040 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.40279804081499 | (37.8044723526732, -122.402798040815) | ||
| 1133 | 1133 | 13945 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 12 | 4x4 | 6009115.3446 | 2112460.3733 | 37.7809279727613 | -122.412086202614 | (37.7809279727613, -122.412086202614) | ||
| 1147 | 1147 | 14071 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007529.5869 | 2110959.6416 | 37.7767182228199 | -122.41746574362101 | (37.7767182228199, -122.417465743621) | |||
| 1151 | 1151 | 13977 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150X Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008909.6011 | 2112263.4341 | 37.780375678658295 | -122.412784045926 | (37.7803756786583, -122.412784045926) | |||
| 1154 | 1154 | 246084 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | |||
| 1160 | 1160 | 18860 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004055.90045 | 2116026.39415 | 37.7904341972353 | -122.429843740294 | (37.7904341972353, -122.429843740294) | |||
| 1169 | 1169 | 246080 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 12 | Width 0ft | Permit Number 17683 | 5999123.3551 | 2108389.3434 | 37.7691842694065 | -122.446360330481 | (37.7691842694065, -122.446360330481) | |
| 1175 | 1175 | 2161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.71980743673429 | -122.408342124702 | (37.7198074367343, -122.408342124702) | |||
| 1245 | 1245 | 6073 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1944 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001125.2679 | 2112488.2186 | 37.7805528822601 | -122.439729742976 | (37.7805528822601, -122.439729742976) | |||
| 1261 | 1261 | 122608 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1214 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987092.2626 | 2106978.1702 | 37.7646150951119 | -122.487870979055 | (37.7646150951119, -122.487870979055) | |||
| 1270 | 1270 | 18055 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000192.328 | 2114789.41 | 37.786818213822706 | -122.443122531996 | (37.7868182138227, -122.443122531996) | |||
| 1317 | 1317 | 14834 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1288 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003007.4145 | 2111705.9811 | 37.7785120037891 | -122.433162602474 | (37.7785120037891, -122.433162602474) | |||
| 1331 | 1331 | 14830 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1284 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6003046.0718 | 2111709.6378 | 37.778524236985895 | -122.433029133637 | (37.7785242369859, -122.433029133637) | |||
| 1336 | 1336 | 7171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | ||
| 1339 | 1339 | 66377 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 621 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 12 | Permit Number 29502 | 6003558.1677 | 2110522.6128 | 37.775293994216 | -122.431172851087 | (37.775293994216, -122.431172851087) | |
| 1340 | 1340 | 7172 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003478.683999999 | 2111101.7087 | 37.7768795438362 | -122.43148915347099 | (37.7768795438362, -122.431489153471) | ||
| 1343 | 1343 | 7169 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.777041804334296 | -122.43152212680799 | (37.7770418043343, -122.431522126808) | ||
| 1345 | 1345 | 7170 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.776988731328295 | -122.43151116193 | (37.7769887313283, -122.43151116193) | ||
| 1346 | 1346 | 21675 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004079.3213 | 2114634.9946 | 37.7866150915141 | -122.42966342693899 | (37.7866150915141, -122.429663426939) | |||
| 1349 | 1349 | 20251 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 1880 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002540.9652 | 2114632.1752 | 37.786520122821 | -122.43498555674299 | (37.786520122821, -122.434985556743) | |||
| 1350 | 1350 | 19971 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 100 STAIRWAY44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 1351 | 1351 | 5208 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 802 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001567.0603 | 2111230.6559 | 37.777125069374705 | -122.438111266341 | (37.7771250693747, -122.438111266341) | |||
| 1361 | 1361 | 16698 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 950X Noriega St | 2 | Median : Cutout 11 | Landscaping 2 | DPW 2 | 12 | 8 | 5991017.9677099995 | 2103156.31666 | 37.7543495107367 | -122.47401428523999 | (37.7543495107367, -122.47401428524) | |||
| 1363 | 1363 | 21606 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | |||
| 1378 | 1378 | 19687 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 1396 | 1396 | 21755 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008465.3581 | 2120976.6726 | 37.8042751503167 | -122.414937771753 | (37.8042751503167, -122.414937771753) | |||
| 1423 | 1423 | 54061 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 12 | Permit Number 779745 | 5988745.7457 | 2113084.32895 | 37.7814772265446 | -122.482599571173 | (37.7814772265446, -122.482599571173) | ||
| 1437 | 1437 | 111252 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3129x Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5983208.5024 | 2097401.5189 | 37.7380929647396 | -122.500595473335 | (37.7380929647396, -122.500595473335) | |||
| 1445 | 1445 | 22600 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 837 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005887.44223 | 2112751.69518 | 37.78154623162111 | -122.42327383483999 | (37.7815462316211, -122.42327383484) |
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");