trees

5,599 rows where qSpecies_id = 38

✎ View and edit SQL

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
723 62606 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 818 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1986 12:00:00 AM 11   Permit Number 22914 5984501.0298 2110256.07846 37.7734638082368 -122.497075193473 (37.7734638082368, -122.497075193473) 11 6 2 55 26
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
1089 60912 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 149 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/1993 12:00:00 AM 8 3x3 Permit Number 32000 6012148.61414 2119800.05377 37.8012507194169 -122.402108723944 (37.8012507194169, -122.402108723944) 3 1 10 28860 6
1097 73684 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1050 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6007850.01602 2119957.29186 37.8014415915259 -122.416994947282 (37.8014415915259, -122.416994947282) 5 1 10 308 32
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
1426 84231 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 178 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988065.20329 2114809.31405 37.7861739305031 -122.48508048983 (37.7861739305031, -122.48508048983) 11 6 1 55 33
1510 61316 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1411 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 21   Permit Number 21219 6011759.251 2101715.45537 37.7515728377404 -122.402183919859 (37.7515728377404, -122.402183919859) 10 3 8 28856 29
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
2015 61308 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2309 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 15   Permit Number 21207 6011873.01335 2101843.07946 37.7519296149817 -122.401799483056 (37.7519296149817, -122.401799483056) 10 3 8 28856 29
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
2176 59307 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3180 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1980 12:00:00 AM 18   Permit Number 18647 5999500.07139 2116046.04634 37.7902291122342 -122.445607969042 (37.7902291122342, -122.445607969042) 13 6 1 29490 27
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
2199 61312 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1458 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 20 4x4 Permit Number 21213 6011710.55671 2101566.51843 37.7511611712496 -122.402341840826 (37.7511611712496, -122.402341840826) 10 3 8 28856 29
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
2274 40857 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1446 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1999 12:00:00 AM 19   Permit Number 41781 6011709.76908 2101616.07805 37.7512972071976 -122.402348048823 (37.7512972071976, -122.402348048823) 10 3 8 28856 29
2324 68584 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1335 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 15   Permit Number 32481 6008309.92013 2116907.08816 37.793092348579 -122.415187431374 (37.793092348579, -122.415187431374) 5 1 10 28858 21
2345 59877 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2125 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/1981 12:00:00 AM 11   Permit Number 19342 6002756.67005 2118848.34018 37.7981088730742 -122.434540847196 (37.7981088730742, -122.434540847196) 13 9 1 57 17
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
2595 71280 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2046 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 6x7   6003095.65483 2119286.01418 37.7993298493627 -122.433399154261 (37.7993298493627, -122.433399154261) 13 9 1 57 17
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
2696 37548 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 952 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM 13   Permit Number 39988 6008033.82968 2115183.28467 37.7883436871616 -122.416020592081 (37.7883436871616, -122.416020592081) 13 1 10 28858 21
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
2798 119275 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 350 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 3x3   6012236.75747 2118139.41245 37.7966959176338 -122.40168691852 (37.7966959176338, -122.40168691852) 3 1 10 28860 4
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
2900 34181 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 111 Gilbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1997 12:00:00 AM 12   Permit Number 38007 6011922.99653 2109561.23009 37.7731247245485 -122.402169209655 (37.7731247245485, -122.402169209655) 14 2 9 28853 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
3620 67423 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1300 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/1992 12:00:00 AM 13   Permit Number 30925 5991580.37693 2110684.47332 37.7750523815864 -122.47261818525 (37.7750523815864, -122.47261818525) 11 6 2 54 26
3761 58790 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 350 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/13/1979 12:00:00 AM 5   Permit Number 18035 6012539.98809 2116868.26339 37.793222561422 -122.400548327356 (37.793222561422, -122.400548327356) 4 1 10 28854 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
3884 61317 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1415 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 22   Permit Number 21220 6011760.1009 2101696.61273 37.7515211473979 -122.402179656165 (37.7515211473979, -122.402179656165) 10 3 8 28856 29
3929 71612 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 583 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5983777.48185 2111850.0463 37.7777979555268 -122.499695843243 (37.7777979555268, -122.499695843243) 11 6 2 55 26
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
4173 73353 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2121 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5988988.09253 2110533.92881 37.7744886354086 -122.481574330241 (37.7744886354086, -122.481574330241) 11 6 2 55 26
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
4791 71991 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 785 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5984443.61146 2110542.72626 37.774247495924 -122.497294973483 (37.774247495924, -122.497294973483) 11 6 2 55 26
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);