Street_Tree_List

Data source: data.sfgov.org

4,395 rows where qLegalStatus = 2 and qSpecies = 32

View and edit SQL

qLegalStatus

  • Undocumented · 4,395
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
354 93479 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 113X Leroy Pl 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 1.5x3 Tree 4 on Leroy 6008317.250990001 2116630.80353 37.792334150853 -122.415142500331 (37.792334150853, -122.415142500331)
448 224849 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
461 98533 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 6x6 Permit Number 779899 5999986.39066 2115181.83206 37.787883958235504 -122.44386322941901 (37.7878839582355, -122.443863229419)
462 187628 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
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)
486 98534 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3 Permit Number 779899 5999986.755609999 2115164.0145 37.787835056676705 -122.443860686142 (37.7878350566767, -122.443860686142)
592 251331 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2232 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
599 251330 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2232 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
1217 113450 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 21X Leroy Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6008324.74095 2116562.6798400003 37.7921475208351 -122.415111760598 (37.7921475208351, -122.415111760598)
1381 189623 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 347 10th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6009091.0 2109329.0 37.7723285943803 -122.411949073152 (37.7723285943803, -122.411949073152)
1627 101897 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1030 Leavenworth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3 Permit Number 769674 6008181.44725 2116041.89613 37.7907095228698 -122.415570672075 (37.7907095228698, -122.415570672075)
1770 192158 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 13 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft Permit Number 779453 6007102.0 2110018.0 37.7741086326202 -122.418878096719 (37.7741086326202, -122.418878096719)
1771 192159 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 13 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft Permit Number 779453 6007133.19838 2109972.1913099997 37.7739846095361 -122.41876692647 (37.7739846095361, -122.41876692647)
1825 224880 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 691 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/19/2016 12:00:00 AM 15 Width 3ft Permit Number 779045 6002530.35822 2095666.1320599997 37.734443349068606 -122.43366625920099 (37.7344433490686, -122.433666259201)
1903 127944 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 101 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012622.90875 2119176.76577 37.7995657819845 -122.400423640834 (37.7995657819845, -122.400423640834)
1908 127945 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 101 Vallejo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2017 12:00:00 AM 3 Width 2ft   6012656.99006 2119182.6904 37.7995839500992 -122.40030612282601 (37.7995839500992, -122.400306122826)
1911 127947 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 855 Front St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012711.6665 2119148.4967900002 37.7994931113801 -122.400114518675 (37.7994931113801, -122.400114518675)
1913 127946 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 855 Front St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012709.78092 2119164.70922 37.7995375216859 -122.400122182714 (37.7995375216859, -122.400122182714)
1924 127943 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 101 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2017 12:00:00 AM 3 Width 3ft   6012601.19681 2119174.02118 37.7995570351977 -122.400498579547 (37.7995570351977, -122.400498579547)
2170 127072 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3399X Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft Permit Number 779572 6001832.0 2119600.0 37.800120199825 -122.437794333712 (37.800120199825, -122.437794333712)
2472 224776 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1600 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 6ft   6005221.0 2098972.0 37.743672820465896 -122.42459890056001 (37.7436728204659, -122.42459890056)
2493 127969 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 73 Castle St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 1ft   6011253.45973 2119573.0614099996 37.8005774500495 -122.405190374142 (37.8005774500495, -122.405190374142)
2505 127968 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 73 Castle St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 1ft   6011251.91529 2119582.84216 37.8006042192626 -122.405196407682 (37.8006042192626, -122.405196407682)
2796 101896 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1030 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3 Permit Number 769674 6008183.011080001 2116026.65387 37.7906677592601 -122.41556418166901 (37.7906677592601, -122.415564181669)
2879 105455 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2307X Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777222 6003193.66965 2116635.80681 37.7920586237566 -122.43287055523899 (37.7920586237566, -122.432870555239)
3064 104743 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Waverly Pl 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6010761.049240001 2116971.9366099997 37.7934078523287 -122.406710911 (37.7934078523287, -122.406710911)
3067 104742 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Waverly Pl 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6010759.24365 2116982.20549 37.793435947175205 -122.406717882525 (37.7934359471752, -122.406717882525)
3069 128380 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Waverly Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6010746.0 2116993.0 37.7934648453026 -122.406764467868 (37.7934648453026, -122.406764467868)
3308 220877 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 600X Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5998682.13916 2105626.63204 37.7615733510574 -122.44768755773701 (37.7615733510574, -122.447687557737)
3329 110970 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2485 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3x3   6002790.71835 2116462.02658 37.791558605188705 -122.434252340185 (37.7915586051887, -122.434252340185)
3414 102265 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2029 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6001885.4061199995 2115556.68597 37.789021347891 -122.437319848541 (37.789021347891, -122.437319848541)
3474 106212 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 5 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     12 3x5   6010752.41967 2115858.63176 37.790350501826204 -122.406662277468 (37.7903505018262, -122.406662277468)
3594 127750 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1033 Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008528.0 2116225.0 37.791231755005896 -122.41438457516001 (37.7912317550059, -122.41438457516)
3607 107433 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3000 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   5999745.83562 2116735.23196 37.792135462722705 -122.444807206383 (37.7921354627227, -122.444807206383)
3624 127356 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2100 Webster St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2017 12:00:00 AM 3 Width 4ft   6003284.8942599995 2116317.33043 37.7911893426569 -122.432532159241 (37.7911893426569, -122.432532159241)
3628 127357 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2100 Webster St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2017 12:00:00 AM 3 Width 4ft   6003276.2668 2116362.2656799997 37.791312234126295 -122.432565221033 (37.7913122341263, -122.432565221033)
3655 116023 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 755 Sansome St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3x5   6012121.98551 2118393.88956 37.7973882454367 -122.40210195745199 (37.7973882454367, -122.402101957452)
3669 128007 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 450 Bay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/15/2017 12:00:00 AM 3 Width 3ft   6008574.61168 2121448.10995 37.8055757371873 -122.414593071218 (37.8055757371873, -122.414593071218)
3671 128005 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 444 Bay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/15/2017 12:00:00 AM 3 Width 3ft   6008626.93235 2121456.53692 37.805601814825394 -122.414412604251 (37.8056018148254, -122.414412604251)
3947 93478 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 113X Leroy Pl 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 1.5x3 Tree 3 on Leroy 6008314.47624 2116646.88711 37.792378156480396 -122.415153240053 (37.7923781564804, -122.415153240053)
4539 112349 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 60 Perine Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6002105.70967 2115571.30242 37.7890740023038 -122.436558674947 (37.7890740023038, -122.436558674947)
4624 98532 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   5999984.2458 2115196.51475 37.7879241507313 -122.443871705528 (37.7879241507313, -122.443871705528)
4868 225613 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 235 Laussat St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003605.0 2109124.0 37.77145640087421 -122.430911009882 (37.7714564008742, -122.430911009882)
5073 104053 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2465 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18     6002918.10064 2116474.72915 37.791600712350295 -122.433812507839 (37.7916007123503, -122.433812507839)
5202 123243 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 590 08th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft Permit Number 780398 5993481.9137 2111464.4660900002 37.7773039172851 -122.466097100812 (37.7773039172851, -122.466097100812)
5400 100479 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 340 Mason St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6009830.0840300005 2114659.89537 37.7870074133103 -122.40976885865601 (37.7870074133103, -122.409768858656)
5446 110972 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2485 Washington St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 3x3   6002826.66374 2116467.13888 37.7915746823815 -122.43412833534799 (37.7915746823815, -122.434128335348)
5680 112346 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 21 Perine Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6002111.28405 2115552.10792 37.789021615903 -122.436538013926 (37.789021615903, -122.436538013926)
5845 110971 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2485 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 3x3   6002809.55078 2116465.5408400004 37.791569323321 -122.434187431628 (37.791569323321, -122.434187431628)
5868 106881 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3261 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3 Permit Number 778851 5999192.38841 2115631.9922700003 37.789074657915 -122.446642721777 (37.789074657915, -122.446642721777)
6009 103505 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1348 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6008358.2632 2116617.67877 37.7923004181806 -122.41499966729799 (37.7923004181806, -122.414999667298)
6113 106866 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1892 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 4x4   6003972.43426 2118715.7250900003 37.7978136859103 -122.430324481915 (37.7978136859103, -122.430324481915)
6211 106217 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     10 3x5   6010670.9358 2115847.8332700003 37.790316292506795 -122.40694344599301 (37.7903162925068, -122.406943445993)
6302 106216 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     10 3x5   6010698.10573 2115852.22595 37.7903298740626 -122.406849749212 (37.7903298740626, -122.406849749212)
6385 105541 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2098X Greenwich St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 10x6   6002946.2979 2119265.29451 37.799264483936604 -122.43391449907 (37.7992644839366, -122.43391449907)
6604 105538 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2098X Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 10x7   6003015.95136 2119274.793 37.7992945167788 -122.43367415343398 (37.7992945167788, -122.433674153434)
6780 105542 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2098X Greenwich St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 10x6   6002909.68864 2119260.2606900004 37.7992485848011 -122.434040819625 (37.7992485848011, -122.434040819625)
6822 93476 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 113X Leroy Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3 Tree 1 on Leroy. 6008309.35619 2116677.55783 37.79246208300879 -122.41517312764499 (37.7924620830088, -122.415173127645)
6860 93474 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1345 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x2   6008356.752640001 2116586.1732799998 37.792213826952704 -122.41500266293501 (37.7922138269527, -122.415002662935)
7044 115410 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2025 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3x3   5999874.89435 2115932.55527 37.7899388875113 -122.444302954718 (37.7899388875113, -122.444302954718)
7146 100477 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 340 Mason St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6009834.90147 2114634.4517 37.7869378210564 -122.40975039469102 (37.7869378210564, -122.409750394691)
7182 106215 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 585X Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6     14 3x5   6010717.90235 2115854.24398 37.79033652277371 -122.406781396238 (37.7903365227737, -122.406781396238)
7209 106548 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1439 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6006143.70032 2118621.75372 37.797678411694 -122.422804603669 (37.797678411694, -122.422804603669)
7221 109623 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 451 Jackson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/16/2015 12:00:00 AM 3 3x3 Permit Number 775170 6011938.15364 2118065.18841 37.79647544883721 -122.402714938942 (37.7964754488372, -122.402714938942)
7281 99181 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 350 Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6008511.54291 2122127.64338 37.807438020907995 -122.41485945401001 (37.807438020908, -122.41485945401)
7315 93472 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1329 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x2   6008412.15519 2116591.32221 37.7922310777524 -122.414811333085 (37.7922310777524, -122.414811333085)
7426 113070 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3108 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6002434.36436 2118927.2467400003 37.7983072284463 -122.435661765772 (37.7983072284463, -122.435661765772)
7492 110964 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2461 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6002930.46719 2116476.98281 37.7916076020582 -122.43376988089899 (37.7916076020582, -122.433769880899)
7611 93477 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 113X Leroy Pl 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 1.5x3 Tree 2 on Leroy 6008311.901880001 2116662.47431 37.7924208104303 -122.415163251278 (37.7924208104303, -122.415163251278)
7636 99241 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 560X Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     10 4x4   6008235.1228 2113825.75072 37.7846275436788 -122.415228013286 (37.7846275436788, -122.415228013286)
7646 120112 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2602 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6001610.3249699995 2116996.65392 37.7929594854561 -122.43837479737499 (37.7929594854561, -122.438374797375)
7647 99242 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 560X Ellis St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     8 4x4   6008195.716580001 2113819.71845 37.7846087658129 -122.415363918808 (37.7846087658129, -122.415363918808)
7648 100475 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 340 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6009838.89839 2114609.02446 37.786868227930604 -122.40973477074101 (37.7868682279306, -122.409734770741)
7758 107629 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2166 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6001500.40723 2119762.44668 37.80054737492579 -122.438953418459 (37.8005473749258, -122.438953418459)
7893 113778 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1753 Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/2016 12:00:00 AM 3 3x3 Permit Number 776886 6004527.88766 2119441.95127 37.7998391633122 -122.428454248166 (37.7998391633122, -122.428454248166)
8014 99179 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 350 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6008592.55792 2122139.39153 37.8074748301781 -122.414579914146 (37.8074748301781, -122.414579914146)
8227 105539 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2098X Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 12x8   6002981.58919 2119269.06905 37.799276850493996 -122.433792649035 (37.799276850494, -122.433792649035)
8277 84968 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3400 Sacramento St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   5998503.80126 2115252.56316 37.78799348844711 -122.448997790814 (37.7879934884471, -122.448997790814)
8298 99117 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 480 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6011185.797590001 2119018.9032900003 37.799052083852295 -122.40538546587901 (37.7990520838523, -122.405385465879)
8497 99180 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 350 Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6008539.94575 2122132.3901400003 37.807452650197 -122.41476149536699 (37.807452650197, -122.414761495367)
8531 103932 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1935 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 7x9   6003485.19153 2119295.34788 37.79937756918579 -122.432051888901 (37.7993775691858, -122.432051888901)
8598 100530 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1434 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16     6008903.531140001 2117829.38309 37.7956580864982 -122.413198743428 (37.7956580864982, -122.413198743428)
8604 101074 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1969 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6003610.72225 2118616.0414400003 37.797519485292604 -122.431568985315 (37.7975194852926, -122.431568985315)
8623 93473 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1345 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x2   6008345.85317 2116585.5339599997 37.792211459052794 -122.415040330141 (37.7922114590528, -122.415040330141)
8625 112608 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2200X Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 3x3   6002378.33364 2115831.7760400004 37.7898046843888 -122.43563407476101 (37.7898046843888, -122.435634074761)
8697 113446 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 7X Leroy Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6008335.71081 2116491.16868 37.7919517851958 -122.415068740628 (37.7919517851958, -122.415068740628)
8716 100476 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 340 Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6009833.38685 2114620.58318 37.786899656544705 -122.409754655664 (37.7868996565447, -122.409754655664)
8912 113777 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1753 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/2016 12:00:00 AM 3 3x3 Permit Number 776886 6004511.02573 2119439.59827 37.799831748383 -122.428512428932 (37.799831748383, -122.428512428932)
8941 107233 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1209 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6007149.8711 2118772.43156 37.798148854252204 -122.41933366571001 (37.7981488542522, -122.41933366571)
12965 96562 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 421 Hamilton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 2x2   6009504.65574 2092358.16495 37.7257536399061 -122.40932035147199 (37.7257536399061, -122.409320351472)
13023 96561 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 421 Hamilton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 2x2   6009510.75375 2092344.78253 37.725717236250404 -122.40929832706101 (37.7257172362504, -122.409298327061)
13456 100270 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Federal St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 1x1   6015164.42669 2113486.59389 37.7840832865491 -122.39123103259399 (37.7840832865491, -122.391231032594)
13478 102736 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 665 Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6009133.1923400005 2111209.09694 37.7774932659425 -122.411936008959 (37.7774932659425, -122.411936008959)
13549 100271 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Federal St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 1x1   6015178.9141 2113499.10422 37.7841184410568 -122.391181785729 (37.7841184410568, -122.391181785729)
13568 99590 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1855X Evans Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6014282.77579 2099498.50206 37.745626086882 -122.393302064265 (37.745626086882, -122.393302064265)
13737 38759 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 325 05th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     36   Permit Number 40631 6011796.14841 2112034.18458 37.7799078071241 -122.40278194745399 (37.7799078071241, -122.402781947454)
13839 100181 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 230 Ritch St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15     6013794.16577 2112184.81721 37.7804327665865 -122.39588042503999 (37.7804327665865, -122.39588042504)
13875 100273 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Federal St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 1x1   6015216.1617 2113535.8467 37.7842213945326 -122.391055490318 (37.7842213945326, -122.391055490318)
13921 100267 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Federal St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 1x1   6015119.18661 2113440.6394599997 37.783954595377104 -122.391384334617 (37.7839545953771, -122.391384334617)
14073 100266 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Federal St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/2017 12:00:00 AM 3 1x1 Permit Number 779105 6015095.83494 2113421.2206 37.783899979542106 -122.391463765467 (37.7838999795421, -122.391463765467)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2766.912ms · Data source: data.sfgov.org