trees
5,599 rows where qSpecies_id = 38 sorted by qCareAssistant
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
73 | 127010 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1931 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003752.87677 | 2118634.51429 | 37.7975782631807 | -122.431078412364 | (37.7975782631807, -122.431078412364) | 13 | 9 | 1 | 57 | 17 | |||
77 | 225344 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 207 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004214.46195 | 2097518.65353 | 37.7396253677099 | -122.42797572342 | (37.7396253677099, -122.42797572342) | 2 | 7 | 5 | 63 | 7 | |||
286 | 18512 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 626 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6010135.39241 | 2115955.1821 | 37.7905810646201 | -122.408803973339 | (37.7905810646201, -122.408803973339) | 5 | 1 | 10 | 28857 | 21 | |||
489 | 225574 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Carmelita St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002579.4442 | 2108765.68107 | 37.7704143837497 | -122.434432832327 | (37.7704143837497, -122.434432832327) | 15 | 5 | 5 | 29492 | 9 | |||
588 | 59987 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1546 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/1982 12:00:00 AM | 20 | Permit Number 19471 | 6015827.92235 | 2097026.68646 | 37.7389247113108 | -122.387786695709 | (37.7389247113108, -122.387786695709) | 10 | 3 | 8 | 58 | 1 | ||
648 | 189633 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 10 | : | Tree | Private 2 | 10 | Width 3ft | 6007281.55408 | 2110475.16176 | 37.775373998252 | -122.418289406239 | (37.775373998252, -122.418289406239) | 8 | 2 | 9 | 28853 | 34 | |||
649 | 189627 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 4 | : | Tree | Private 2 | 16 | Width 3ft | 6007528.52851 | 2110215.72509 | 37.7746755460784 | -122.417416671761 | (37.7746755460784, -122.417416671761) | 8 | 2 | 9 | 28853 | 34 | |||
802 | 126843 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Avila St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001073.31574 | 2121444.93358 | 37.8051427271077 | -122.440552066845 | (37.8051427271077, -122.440552066845) | 13 | 9 | 1 | 57 | 17 | |||
834 | 225434 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4426 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6001253.02246 | 2105262.8868 | 37.7607211930514 | -122.438769876745 | (37.7607211930514, -122.438769876745) | 15 | 4 | 5 | 28862 | 3 | |||
878 | 126969 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 5999145.58694 | 2118075.75757 | 37.795781916869 | -122.44698057642 | (37.795781916869, -122.44698057642) | 11 | 1 | 57 | 30 | ||||
913 | 128077 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009569.08364 | 2121877.54409 | 37.8068106763465 | -122.411181901328 | (37.8068106763465, -122.411181901328) | 3 | 1 | 10 | 308 | 23 | |||
992 | 192119 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 22 | Width 4ft | 6010836.94593 | 2113119.25584 | 37.782833554469 | -122.406176740686 | (37.782833554469, -122.406176740686) | 12 | 2 | 9 | 28853 | 34 | |||
1042 | 189625 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 2 | : | Tree | Private 2 | 18 | Width 3ft | 6007555.58457 | 2110185.16197 | 37.7745931492825 | -122.417320912844 | (37.7745931492825, -122.417320912844) | 8 | 2 | 9 | 28853 | 34 | |||
1068 | 189619 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1022 Harrison St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 0ft | 6010873.70675 | 2110523.15136 | 37.7757073139658 | -122.405866629254 | (37.7757073139658, -122.405866629254) | 14 | 2 | 9 | 28853 | 34 | |||
1163 | 127620 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 888 O'Farrell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007042.74082 | 2114007.27438 | 37.7850588791954 | -122.419366145639 | (37.7850588791954, -122.419366145639) | 13 | 9 | 9 | 28858 | 36 | |||
1172 | 128195 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009814.56122 | 2122259.17064 | 37.8078722909471 | -122.410359337331 | (37.8078722909471, -122.410359337331) | 3 | 1 | 10 | 308 | 23 | |||
1210 | 225514 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004671.76265 | 2107221.11823 | 37.7662919319386 | -122.427085463842 | (37.7662919319386, -122.427085463842) | 8 | 4 | 5 | 28862 | 3 | |||
1266 | 5364 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 240 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6004803.91128 | 2106914.75304 | 37.7654581983585 | -122.426606568537 | (37.7654581983585, -122.426606568537) | 8 | 4 | 5 | 28862 | 3 | |||
1273 | 246677 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 25 Randall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6005248.94304 | 2097610.63078 | 37.7399363874552 | -122.424405469757 | (37.7399363874552, -122.424405469757) | 2 | 7 | 5 | 63 | 7 | ||||
1323 | 128710 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011603.69347 | 2118016.75724 | 37.7963237889749 | -122.403868840184 | (37.7963237889749, -122.403868840184) | 3 | 1 | 10 | 28860 | 4 | |||
1365 | 224776 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 6ft | 6005221 | 2098972 | 37.7436728204659 | -122.42459890056 | (37.7436728204659, -122.42459890056) | 2 | 7 | 5 | 63 | 22 | |||
1402 | 128081 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009658.72737 | 2121889.09987 | 37.8068474325394 | -122.410872486877 | (37.8068474325394, -122.410872486877) | 3 | 1 | 10 | 308 | 23 | |||
1548 | 128066 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 262 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009084.93005 | 2121810.40932 | 37.8065991773678 | -122.412852667211 | (37.8065991773678, -122.412852667211) | 3 | 1 | 10 | 308 | 23 | |||
1666 | 128592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013155.79734 | 2117635.08876 | 37.7953624065092 | -122.398471405135 | (37.7953624065092, -122.398471405135) | 3 | 1 | 10 | 28860 | 6 | |||
1771 | 126877 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 431 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998608.56646 | 2115039.1362 | 37.7874134653004 | -122.448619946057 | (37.7874134653004, -122.448619946057) | 13 | 6 | 1 | 54 | 31 | |||
1807 | 128108 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 102 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009837.41929 | 2121966.51853 | 37.8070700228254 | -122.410259554851 | (37.8070700228254, -122.410259554851) | 3 | 1 | 10 | 308 | 23 | |||
1824 | 224952 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3748 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5x5 | 6003449.35474 | 2103046.9521 | 37.7547614712767 | -122.431015593815 | (37.7547614712767, -122.431015593815) | 2 | 4 | 5 | 28862 | 22 | |||
1848 | 128781 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 163 Maiden Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010952.71288 | 2115032.74516 | 37.7880940182581 | -122.405911070134 | (37.7880940182581, -122.405911070134) | 5 | 1 | 10 | 28857 | 6 | |||
1979 | 92945 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3516 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5998014.58163 | 2115182.9594 | 37.7877743839331 | -122.450685374939 | (37.7877743839331, -122.450685374939) | 11 | 6 | 1 | 54 | 31 | ||||
2044 | 128391 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 295 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012104.01807 | 2116050.9072 | 37.7909539720909 | -122.401999334911 | (37.7909539720909, -122.401999334911) | 4 | 1 | 10 | 28854 | 6 | |||
2150 | 128068 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2005 12:00:00 AM | 13 | Width 4ft | Permit Number 48272 | 6009359.15547 | 2121848.2589 | 37.8067184913163 | -122.411906331309 | (37.8067184913163, -122.411906331309) | 3 | 1 | 10 | 308 | 23 | |
2178 | 56928 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 990 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 22 | Permit Number 14172 | 6008190.72994 | 2120000.83835 | 37.8015803191331 | -122.415819006365 | (37.8015803191331, -122.415819006365) | 5 | 1 | 10 | 308 | 32 | ||
2197 | 126966 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 32 Parker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5996866.78793 | 2114389.9756 | 37.7855312948716 | -122.454599192111 | (37.7855312948716, -122.454599192111) | 11 | 6 | 1 | 54 | 31 | |||
2219 | 127642 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008019.48928 | 2111712.32042 | 37.7788124517715 | -122.41582433125 | (37.7788124517715, -122.41582433125) | 7 | 10 | 9 | 28852 | 36 | |||
2395 | 224762 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004982.47318 | 2110039.87008 | 37.7740491098102 | -122.426211472077 | (37.7740491098102, -122.426211472077) | 7 | 9 | 11 | 28852 | 10 | |||
2428 | 224870 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 886 Castro St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002438.81243 | 2103075.76594 | 37.7547832744558 | -122.434512381839 | (37.7547832744558, -122.434512381839) | 2 | 4 | 5 | 28862 | 22 | |||
2456 | 260910 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 241 Laussat St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003564.7514 | 2109147.66361 | 37.7715190947724 | -122.431051921008 | (37.7715190947724, -122.431051921008) | 15 | 9 | 11 | 29492 | 10 | ||||
2527 | 127017 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2859 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999232.73482 | 2118356.53874 | 37.7965578456306 | -122.446699242399 | (37.7965578456306, -122.446699242399) | 13 | 9 | 1 | 57 | 17 | |||
2531 | 128379 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 27 Waverly Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 782186 | 6010751.08445 | 2117044.71701 | 37.793607132226 | -122.406750521634 | (37.793607132226, -122.406750521634) | 3 | 1 | 10 | 28857 | 4 | ||
2560 | 126872 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 346 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5998571.39948 | 2115304.13388 | 37.7881389538087 | -122.448767630033 | (37.7881389538087, -122.448767630033) | 13 | 6 | 1 | 54 | 31 | |||
2628 | 190261 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 133 Stevenson St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 6011936.19797 | 2114760.72734 | 37.7874020753891 | -122.402489228003 | (37.7874020753891, -122.402489228003) | 12 | 2 | 9 | 28855 | 6 | |||
2647 | 127707 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1425 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6008864.13435 | 2117782.3752 | 37.7955268025682 | -122.413331737877 | (37.7955268025682, -122.413331737877) | 5 | 1 | 10 | 308 | 21 | |||
2681 | 225302 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 6 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003467 | 2108426 | 37.7695320434676 | -122.431338524707 | (37.7695320434676, -122.431338524707) | 15 | 9 | 5 | 29492 | 10 | |||
2755 | 127908 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 894 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007564.93188 | 2120607.69354 | 37.8032113898512 | -122.41802760281 | (37.8032113898512, -122.41802760281) | 5 | 1 | 1 | 308 | 32 | |||
2847 | 128308 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1150 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012007.52553 | 2119595.1365 | 37.8006801903879 | -122.402582537171 | (37.8006801903879, -122.402582537171) | 3 | 1 | 10 | 28860 | 6 | |||
2882 | 100182 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6013808.29227 | 2112170.33848 | 37.7803937971776 | -122.39583053966 | (37.7803937971776, -122.39583053966) | 6 | 2 | 9 | 28856 | 34 | ||||
2982 | 100269 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015149.19988 | 2113471.58342 | 37.7840412261692 | -122.391282662663 | (37.7840412261692, -122.391282662663) | 6 | 2 | 9 | 28856 | 6 | |||
3047 | 189052 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1498 Fairfax Ave | 9 | : | Tree | Private 2 | 04/13/2020 12:00:00 AM | 3 | Width 4ft | 6016122.19881 | 2097851.77649 | 37.7412065377553 | -122.386826739572 | (37.7412065377553, -122.386826739572) | 10 | 3 | 8 | 58 | 1 | ||
3124 | 176457 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 432 Amherst St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007753.63778 | 2091789.49647 | 37.7240939374796 | -122.415333267232 | (37.7240939374796, -122.415333267232) | 9 | 3 | 7 | 309 | 28 | |||
3164 | 249333 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 840 Post St | 4 | : | Tree | Private 2 | 15 | Width 4ft | 6008047.50765 | 2114838.3401 | 37.7873973224712 | -122.415948831592 | (37.7873973224712, -122.415948831592) | 13 | 1 | 10 | 28858 | 21 | |||
3237 | 225589 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 574 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002963.17537 | 2108925.95481 | 37.7708762305838 | -122.433116959576 | (37.7708762305838, -122.433116959576) | 15 | 5 | 11 | 29492 | 9 | |||
3384 | 112797 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 741 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009912.30354 | 2118803.0369 | 37.7983880829054 | -122.409776957039 | (37.7983880829054, -122.409776957039) | 3 | 1 | 10 | 308 | 4 | |||
3389 | 126982 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004396.01598 | 2118466.17604 | 37.7971524719675 | -122.428840971039 | (37.7971524719675, -122.428840971039) | 13 | 9 | 1 | 57 | 17 | |||
3413 | 128074 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2019 12:00:00 AM | 3 | Width 4ft | 6009478.77374 | 2121864.7268 | 37.8067704181858 | -122.411493531709 | (37.8067704181858, -122.411493531709) | 3 | 1 | 10 | 308 | 23 | ||
3467 | 189657 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2505 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015867.18038 | 2103823.80533 | 37.7575903607135 | -122.388125177147 | (37.7575903607135, -122.388125177147) | 10 | 3 | 8 | 28856 | 29 | |||
3481 | 128267 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2 Lombard St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6011926.44398 | 2120867.47841 | 37.8041692046961 | -122.402952654037 | (37.8041692046961, -122.402952654037) | 3 | 1 | 10 | 28860 | 6 | |||
3501 | 189764 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2200 26th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6011937.99786 | 2101379.88854 | 37.7506614197981 | -122.401542205007 | (37.7506614197981, -122.401542205007) | 10 | 3 | 8 | 28856 | 29 | ||||
3503 | 127267 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2429 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001933.00752 | 2117690.75949 | 37.7948836677101 | -122.437308024273 | (37.7948836677101, -122.437308024273) | 13 | 9 | 1 | 57 | 27 | |||
3505 | 68022 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 17 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 5 | Permit Number 31753 | 6011202.97884 | 2114704.34705 | 37.7872063082823 | -122.405022057035 | (37.7872063082823, -122.405022057035) | 5 | 10 | 10 | 28857 | 6 | ||
3764 | 226567 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005696.43071 | 2106383.98783 | 37.76405126027 | -122.423481806642 | (37.76405126027, -122.423481806642) | 8 | 4 | 5 | 28859 | 19 | |||
3931 | 128405 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 251 Sutter St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6011177.50321 | 2115572.36471 | 37.7895882544408 | -122.405171343593 | (37.7895882544408, -122.405171343593) | 5 | 1 | 10 | 28857 | 6 | |||
3935 | 190231 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 536 Mission St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6013108.00219 | 2115380.57428 | 37.7891693781208 | -122.398478510672 | (37.7891693781208, -122.398478510672) | 12 | 2 | 9 | 28855 | 6 | |||
4062 | 127062 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3252 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001378.86232 | 2119524.81659 | 37.7998879892946 | -122.439356969471 | (37.7998879892946, -122.439356969471) | 13 | 9 | 1 | 57 | 17 | |||
4135 | 123361 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 756 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994763.35319 | 2110444.72464 | 37.7745778244496 | -122.461590268289 | (37.7745778244496, -122.461590268289) | 11 | 6 | 2 | 54 | 11 | |||
4145 | 86824 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 290 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6000862.93753 | 2120018.08903 | 37.801213010829 | -122.441177668529 | (37.801213010829, -122.441177668529) | 13 | 9 | 1 | 57 | 17 | |||
4189 | 192124 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 25 | Width 4ft | 6011038.85416 | 2113311.43716 | 37.783372530757 | -122.405491758548 | (37.783372530757, -122.405491758548) | 12 | 2 | 9 | 28853 | 34 | |||
4474 | 109514 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1501x FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | ||||
4486 | 225034 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4403 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001357 | 2105189 | 37.7605242327726 | -122.438404972116 | (37.7605242327726, -122.438404972116) | 2 | 4 | 5 | 28862 | 3 | |||
4608 | 128323 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Union St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6012158.21016 | 2119822.6074 | 37.8013131818191 | -122.402077103775 | (37.8013131818191, -122.402077103775) | 3 | 1 | 10 | 28860 | 6 | ||||
4765 | 110239 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2655 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000951.09283 | 2117196.46677 | 37.793470600727 | -122.440670108247 | (37.793470600727, -122.440670108247) | 13 | 9 | 1 | 29490 | 27 | |||
4826 | 116397 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 491 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5986229.08994 | 2112682.60062 | 37.7802274633353 | -122.491276289815 | (37.7802274633353, -122.491276289815) | 11 | 6 | 2 | 55 | 26 | |||
5024 | 189704 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1206 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6013644.41356 | 2106192.50463 | 37.7639708878813 | -122.395978449371 | (37.7639708878813, -122.395978449371) | 14 | 3 | 8 | 28856 | 29 | |||
5232 | 127794 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2229 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6008462.92143 | 2120654.02887 | 37.8033891147652 | -122.414923354455 | (37.8033891147652, -122.414923354455) | 5 | 1 | 10 | 308 | 32 | |||
5260 | 218923 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1242 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 5995843.28392 | 2107006.31801 | 37.7651989570802 | -122.457605764221 | (37.7651989570802, -122.457605764221) | 15 | 5 | 11 | 29492 | 12 | |||
5367 | 128547 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 530 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6011621.44747 | 2116740.16032 | 37.792819551831 | -122.40371753735 | (37.792819551831, -122.40371753735) | 4 | 1 | 10 | 28854 | 6 | |||
5396 | 128492 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 201 Montgomery St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6011956.55611 | 2116131.94021 | 37.7911682382735 | -122.402515250798 | (37.7911682382735, -122.402515250798) | 4 | 1 | 10 | 28854 | 6 | |||
5432 | 189807 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 220 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010828.58743 | 2107359.89419 | 37.7670192127893 | -122.405799840205 | (37.7670192127893, -122.405799840205) | 8 | 4 | 8 | 28853 | 19 | |||
5506 | 225470 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2231 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002657.30889 | 2107063.70687 | 37.765745599218 | -122.434041816972 | (37.765745599218, -122.434041816972) | 15 | 5 | 5 | 28862 | 3 | |||
5513 | 124042 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 835 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 7ft | 5992827.42703 | 2114798.67685 | 37.786420969756 | -122.468603820853 | (37.786420969756, -122.468603820853) | 11 | 6 | 2 | 54 | 11 | |||
5571 | 127724 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 6 Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6008350.29303 | 2116463.97857 | 37.7918779472632 | -122.415016360531 | (37.7918779472632, -122.415016360531) | 5 | 1 | 10 | 28858 | 21 | |||
5735 | 123023 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 320 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994043.99217 | 2113246.58876 | 37.7822295582626 | -122.464282120352 | (37.7822295582626, -122.464282120352) | 11 | 6 | 2 | 54 | 11 | |||
5769 | 127718 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1377 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008134.11977 | 2116552.38078 | 37.7921085280447 | -122.415770585055 | (37.7921085280447, -122.415770585055) | 5 | 1 | 10 | 28858 | 21 | |||
5834 | 126875 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 401 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998625 | 2115075 | 37.7875128775034 | -122.448565673536 | (37.7875128775034, -122.448565673536) | 13 | 6 | 1 | 54 | 31 | |||
5848 | 189784 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Texas St | 1 | : | Tree | Private 2 | 20 | Width 4ft | 6013708.09947 | 2105987.51004 | 37.7634115608072 | -122.39574381262 | (37.7634115608072, -122.39574381262) | 14 | 3 | 8 | 28856 | 29 | |||
5855 | 189614 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1022 Harrison St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 0ft | 6011103.60933 | 2110745.72652 | 37.7763313085817 | -122.405087010566 | (37.7763313085817, -122.405087010566) | 14 | 2 | 9 | 28853 | 34 | |||
5867 | 176470 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 130 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009916.73377 | 2094983.66925 | 37.7329857989392 | -122.408080900424 | (37.7329857989392, -122.408080900424) | 10 | 3 | 7 | 309 | 28 | |||
5930 | 128735 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 545 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011426.2676 | 2118320.12222 | 37.7971468422023 | -122.404504139281 | (37.7971468422023, -122.404504139281) | 3 | 1 | 10 | 308 | 4 | |||
5946 | 127771 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1460 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006950.85449 | 2115730.19168 | 37.7897844109646 | -122.419806340388 | (37.7897844109646, -122.419806340388) | 13 | 9 | 10 | 28858 | 21 | |||
5961 | 128358 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1335 Battery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6012159.58757 | 2120622.92627 | 37.803510739994 | -122.402128634953 | (37.803510739994, -122.402128634953) | 3 | 1 | 10 | 28860 | 6 | |||
6024 | 128476 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 109 Front St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 5ft | 6013054.34541 | 2116659.14888 | 37.7926770542453 | -122.398753923573 | (37.7926770542453, -122.398753923573) | 4 | 1 | 10 | 28860 | 6 | |||
6026 | 128070 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6009396.36006 | 2121851.96105 | 37.8067307436876 | -122.41177783889 | (37.8067307436876, -122.41177783889) | 3 | 1 | 10 | 308 | 23 | |||
6064 | 128753 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 145 Geary St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6010888.72367 | 2114838.04786 | 37.7875558468704 | -122.406118740704 | (37.7875558468704, -122.406118740704) | 5 | 1 | 10 | 28857 | 6 | |||
6102 | 55726 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2150 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1973 12:00:00 AM | 30 | 4x4 | Permit Number 11752 | 6003240.02272888 | 2107147.06325899 | 37.7660075287211 | -122.43203228921 | (37.7660075287211, -122.43203228921) | 15 | 5 | 5 | 28862 | 3 | |
6163 | 225557 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 56 Deming St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999325.48062 | 2105227.47982 | 37.7605141259519 | -122.445433809042 | (37.7605141259519, -122.445433809042) | 15 | 5 | 5 | 28862 | 3 | |||
6165 | 128151 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007611.87437 | 2121662.99743 | 37.806111628806 | -122.417940009725 | (37.806111628806, -122.417940009725) | 5 | 1 | 10 | 308 | 23 | |||
6210 | 92707 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2600 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52950 | 6000514.42126 | 2118236.58998 | 37.7963016287713 | -122.442255722737 | (37.7963016287713, -122.442255722737) | 13 | 9 | 1 | 57 | 17 | |
6261 | 128069 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009374.1078 | 2121849.01591 | 37.8067214087259 | -122.411854639205 | (37.8067214087259, -122.411854639205) | 3 | 1 | 10 | 308 | 23 | |||
6281 | 128011 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 590 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008173.68388 | 2121395.11526 | 37.8054076943845 | -122.415976787008 | (37.8054076943845, -122.415976787008) | 5 | 1 | 10 | 308 | 23 | |||
6294 | 5744 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1759 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 6x6 | 6005374.75018 | 2098167.61874 | 37.7414728539803 | -122.424010079215 | (37.7414728539803, -122.424010079215) | 2 | 7 | 5 | 28859 | 7 | |||
6442 | 224868 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 175 Grand View Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6000828.74292 | 2103376.29787 | 37.7555169332749 | -122.440101980424 | (37.7555169332749, -122.440101980424) | 2 | 4 | 5 | 28862 | 38 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );