Street_Tree_List

Data source: data.sfgov.org

5,685 rows where qSpecies = 32 sorted by qCareAssistant descending

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant ▲ PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
71504 98651 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2110 Greenwich St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4   23 5x5   6002674.17203 2119228.66956 37.799148474973705 -122.434853527066 (37.7991484749737, -122.434853527066)
1568 251592 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1999X Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6007220.0 2119146.0 37.799178528828 -122.41911751038602 (37.799178528828, -122.419117510386)
5535 98626 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3500X Fillmore St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 6x6   6002283.11168 2120054.94147 37.8013949904512 -122.43626589165301 (37.8013949904512, -122.436265891653)
5696 98622 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3500X Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   12 6x6   6002297.34528 2119958.5907400004 37.8011312453645 -122.436209738003 (37.8011312453645, -122.436209738003)
6913 42637 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x4 Permit Number 42688 6005203.48268 2118840.06651 37.7982247489172 -122.42607356463999 (37.7982247489172, -122.42607356464)
6980 98636 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3500X Fillmore St 15 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   12 6x6   6002249.0569400005 2120273.69699 37.8019937006086 -122.436399401415 (37.8019937006086, -122.436399401415)
7085 42636 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x5 Permit Number 42688 6005181.30457 2118838.80185 37.7982200229931 -122.426150217479 (37.7982200229931, -122.426150217479)
7354 42635 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x5 Permit Number 42688 6005113.3477300005 2118824.42387 37.7981767035488 -122.426384344263 (37.7981767035488, -122.426384344263)
7911 42632 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1651 Union St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/26/2000 12:00:00 AM 16 4x4 Permit Number 42688 6005134.3142099995 2118828.07494 37.7981879136105 -122.42631205408199 (37.7981879136105, -122.426312054082)
8255 98623 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3500X Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   12 6x6   6002295.23154 2119980.02637 37.80118998188 -122.43621858733299 (37.80118998188, -122.436218587333)
8457 98627 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3500X Fillmore St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 6x6   6002279.94472 2120071.20683 37.801439470916 -122.43627801543998 (37.801439470916, -122.43627801544)
8784 98624 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3500X Fillmore St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   12 6x6   6002286.82962 2120018.90884 37.801296265561 -122.436250445798 (37.801296265561, -122.436250445798)
24331 116062 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2100x 19th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   22 3x3   6011361.02056 2105129.82914 37.7609257168785 -122.40380128939199 (37.7609257168785, -122.403801289392)
35622 116053 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 650x Kansas St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   11 4x4   6011508.109619999 2105241.51829 37.761240606399795 -122.40330042728901 (37.7612406063998, -122.403300427289)
132178 116054 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 650x Kansas St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   23 4x4   6011511.93551 2105220.59815 37.761183378041395 -122.403285723377 (37.7611833780414, -122.403285723377)
156514 122751 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 693 Vermont St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   18     6011280.99043 2105260.13165 37.7612790272197 -122.40408725043301 (37.7612790272197, -122.404087250433)
170121 116065 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 693 Vermont St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   20 8x7   6011274.01561 2105377.63125 37.761601265113896 -122.404119643106 (37.7616012651139, -122.404119643106)
174085 43304 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 693 Vermont St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/12/2000 12:00:00 AM 19   Permit Number 43072 6011287.96925 2105166.37556 37.7610219838923 -122.404056515205 (37.7610219838923, -122.404056515205)
7916 63582 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1370 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1987 12:00:00 AM 7 3x3 Permit Number 24205 6006460.0817 2118715.02595 37.797952359573 -122.42171646446998 (37.797952359573, -122.42171646447)
13361 117223 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013667.943030001 2111389.10897 37.7782409101283 -122.39626130683997 (37.7782409101283, -122.39626130684)
13660 117220 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013718.755890001 2111339.55053 37.7781076611892 -122.39608205125799 (37.7781076611892, -122.396082051258)
14091 31394 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 364 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/24/1995 12:00:00 AM 18   Permit Number 34987 6013462.98605 2105398.17838 37.7617797472724 -122.39655027337 (37.7617797472724, -122.39655027337)
14154 117219 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013733.69082 2111323.12296 37.7780633857557 -122.39602923405701 (37.7780633857557, -122.396029234057)
14214 69442 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013823.57483 2111230.5410599997 37.777814177306 -122.395711802165 (37.777814177306, -122.395711802165)
14549 117222 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013683.04729 2111373.4456700003 37.7781987427098 -122.396207957236 (37.7781987427098, -122.396207957236)
14702 117215 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013784.57093 2111269.26347 37.7779183304931 -122.395849445217 (37.7779183304931, -122.395849445217)
15546 117216 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013770.84151 2111284.28441 37.7779588107877 -122.395897993299 (37.7779588107877, -122.395897993299)
15669 117221 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013696.95586 2111359.6496200003 37.778161635782396 -122.39615887494499 (37.7781616357824, -122.396158874945)
15792 30661 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 83 Lafayette St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/30/1995 12:00:00 AM 8 3x3 Permit Number 34594 6007673.53493 2109511.3804599997 37.7727497405427 -122.416865151724 (37.7727497405427, -122.416865151724)
16129 117218 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013744.24197 2111311.0843599997 37.7780309175198 -122.395991889732 (37.7780309175198, -122.395991889732)
16357 117217 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013756.29755 2111297.17195 37.77799338791311 -122.395949209701 (37.7779933879131, -122.395949209701)
16504 117214 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013802.24625 2111251.09103 37.7778694163842 -122.395787025958 (37.7778694163842, -122.395787025958)
23201 69744 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1855X Evans Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/16/2002 12:00:00 AM 8 3x3   6014390.51341 2099418.69013 37.7454129250631 -122.392923937985 (37.7454129250631, -122.392923937985)
24457 61320 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1477 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/10/1984 12:00:00 AM 16   Permit Number 21223 6011774.39181 2101489.8547799997 37.750954232774895 -122.402115701805 (37.7509542327749, -122.402115701805)
24697 52867 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1907 REVISED Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/02/2006 12:00:00 AM 13   Permit Number 48876 6007724.12776 2118978.20854 37.798746192027394 -122.417361153918 (37.7987461920274, -122.417361153918)
26098 42705 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1035 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM 4   Permit Number 42722 6008002.308069999 2119233.94027 37.799464014698 -122.41641668139499 (37.799464014698, -122.416416681395)
28159 116806 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1300 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   14     5991537.4363400005 2110683.08947 37.7750460962456 -122.472766623766 (37.7750460962456, -122.472766623766)
28341 66603 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1225 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/29/1992 12:00:00 AM 7   Permit Number 29798 6008039.621 2115833.32115 37.790128854013 -122.416046607673 (37.790128854013, -122.416046607673)
28490 65126 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 222 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/1989 12:00:00 AM 16   Permit Number 27096 5989645.84476 2113859.10793 37.783656876429205 -122.479542401246 (37.7836568764292, -122.479542401246)
28965 68584 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1335 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/1995 12:00:00 AM 15   Permit Number 32481 6008309.92013 2116907.08816 37.793092348579 -122.415187431374 (37.793092348579, -122.415187431374)
29028 68177 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 63 Rossi Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/03/1993 12:00:00 AM 7   Permit Number 31948 5996332.84265 2111732.38304 37.7782036117907 -122.45625425125 (37.7782036117907, -122.45625425125)
29163 65104 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 179 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/1989 12:00:00 AM 12   Permit Number 27071 5988966.04699 2114149.58894 37.7844149444345 -122.481915500518 (37.7844149444345, -122.481915500518)
29810 39866 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Laurel St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 4   Permit Number 41168 5997948.5707 2116247.7626900002 37.790694272177895 -122.45099057155198 (37.7906942721779, -122.450990571552)
30198 64002 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1022 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/1987 12:00:00 AM 19   Permit Number 24749 6007961.58195 2119970.3867200003 37.8014838218701 -122.416609806295 (37.8014838218701, -122.416609806295)
30848 65107 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 182 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/1989 12:00:00 AM 4   Permit Number 27074 5989016.12351 2114112.182 37.784315147689796 -122.48173951424499 (37.7843151476898, -122.481739514245)
31558 71280 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2046 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/14/1990 12:00:00 AM 12 6x7   6003095.65483 2119286.01418 37.7993298493627 -122.433399154261 (37.7993298493627, -122.433399154261)
31612 65846 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 45 Rico Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/1990 12:00:00 AM 12   Permit Number 28837 6001437.53726 2121346.67782 37.804893676057205 -122.439284590205 (37.8048936760572, -122.439284590205)
33173 41425 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1568 Indiana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/12/2005 12:00:00 AM 14   Permit Number 42032 6015102.0577 2101304.61846 37.750630787079395 -122.390595272152 (37.7506307870794, -122.390595272152)
33434 42248 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 565 Natoma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM 7   Permit Number 42494 6009953.25863 2111737.1400200003 37.7789891226943 -122.409136384353 (37.7789891226943, -122.409136384353)
34391 64955 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2809 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/1989 12:00:00 AM 11   Permit Number 25986 6004773.14771 2119232.31756 37.7992774386635 -122.42759061302401 (37.7992774386635, -122.427590613024)
37459 64979 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2844 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/24/1989 12:00:00 AM 14   Permit Number 26014 6004799.978680001 2119386.09357 37.7997011857265 -122.42750872976102 (37.7997011857265, -122.427508729761)
37707 75939 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2100 Pacific Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/04/1995 12:00:00 AM 7     6004008.543980001 2117326.08278 37.7940001296632 -122.430100346576 (37.7940001296632, -122.430100346576)
38704 52949 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 31 Capistrano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 14   Permit Number 48936 6001265.83557 2093905.19731 37.7295363961645 -122.437912033237 (37.7295363961645, -122.437912033237)
39503 32970 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 336 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1996 12:00:00 AM 12 7x7 Permit Number 37285 6013456.70104 2105487.0572099998 37.7620234392501 -122.396578241401 (37.7620234392501, -122.396578241401)
40134 63976 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1000 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/1987 12:00:00 AM 18   Permit Number 24713 6008118.773440001 2119296.69749 37.7996428790721 -122.416018115343 (37.7996428790721, -122.416018115343)
40156 68982 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2370 Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1994 12:00:00 AM 14   Permit Number 32972 5999967.44884 2119893.1184900003 37.8008188262957 -122.4442674549 (37.8008188262957, -122.4442674549)
42281 66083 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1944 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/08/1990 12:00:00 AM 11   Permit Number 29127 6008659.19905 2119579.04325 37.800448499850205 -122.414168026436 (37.8004484998502, -122.414168026436)
43284 41169 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 15 Avila St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/23/1999 12:00:00 AM 9   Permit Number 41890 6001073.75913 2119781.5587400002 37.8005755677693 -122.44043116197399 (37.8005755677693, -122.440431161974)
43456 64974 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3054 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/19/1989 12:00:00 AM 11   Permit Number 26009 6004698.47765 2120116.2927 37.80170038313 -122.42791202082199 (37.80170038313, -122.427912020822)
43583 61507 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 195 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/27/1984 12:00:00 AM 16   Permit Number 21462 5989900.42739 2114099.23547 37.784330984044 -122.478679219068 (37.784330984044, -122.478679219068)
43741 64973 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3106 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/19/1989 12:00:00 AM 9   Permit Number 26008 6004680.11759 2120258.7850900004 37.8020905917753 -122.42798571486901 (37.8020905917753, -122.427985714869)
45544 37548 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 952 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/08/2003 12:00:00 AM 13   Permit Number 39988 6008033.82968 2115183.28467 37.7883436871616 -122.416020592081 (37.7883436871616, -122.416020592081)
46706 68915 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1707 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 14   Permit Number 32895 6008302.71306 2118323.38129 37.7969807347398 -122.41531267543999 (37.7969807347398, -122.41531267544)
47530 61308 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2309 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/12/2005 12:00:00 AM 15   Permit Number 21207 6011873.01335 2101843.0794599997 37.751929614981705 -122.401799483056 (37.7519296149817, -122.401799483056)
48171 72442 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 640 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/11/1996 12:00:00 AM 6     6009698.8624 2115604.67168 37.7895941872619 -122.410289589507 (37.7895941872619, -122.410289589507)
48185 68978 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3553 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1994 12:00:00 AM 17   Permit Number 32968 6000213.91744 2120509.86382 37.802526302503296 -122.44345889961001 (37.8025263025033, -122.44345889961)
49348 61316 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1411 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/10/1984 12:00:00 AM 21   Permit Number 21219 6011759.251 2101715.45537 37.7515728377404 -122.40218391985901 (37.7515728377404, -122.402183919859)
50920 41757 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1308 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM 10   Permit Number 42185 6008053.97146 2116940.94284 37.7931709178551 -122.41607543003401 (37.7931709178551, -122.416075430034)
51588 62606 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 818 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 11   Permit Number 22914 5984501.0298 2110256.07846 37.7734638082368 -122.497075193473 (37.7734638082368, -122.497075193473)
52670 65422 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 630 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/28/1989 12:00:00 AM 8   Permit Number 28280 6009709.51126 2115541.2486 37.7894206396969 -122.410248265639 (37.7894206396969, -122.410248265639)
54214 43672 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 511 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM 14   Permit Number 43315 5995279.48447 2112057.32986 37.779035306259 -122.459921722201 (37.779035306259, -122.459921722201)
54841 68232 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 106 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 9   Permit Number 32027 6001414.70118 2121097.37736 37.804207863862096 -122.439345736027 (37.8042078638621, -122.439345736027)
55690 73684 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1050 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/12/1987 12:00:00 AM 13     6007850.01602 2119957.2918599998 37.8014415915259 -122.416994947282 (37.8014415915259, -122.416994947282)
56592 62087 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 505 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/1985 12:00:00 AM 17   Permit Number 22173 6013281.361219999 2104671.31066 37.759773818435605 -122.39712747625 (37.7597738184356, -122.39712747625)
56899 31339 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 365 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 8   Permit Number 34952 6006078.70022 2111390.77564 37.7778202702316 -122.42251544013 (37.7778202702316, -122.42251544013)
57765 55825 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 134 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 11   Permit Number 21658 5992444.90169 2114563.5183 37.785753184810794 -122.469910122182 (37.7857531848108, -122.469910122182)
58170 71991 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 785 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 11     5984443.61146 2110542.72626 37.774247495924 -122.49729497348301 (37.774247495924, -122.497294973483)
60079 61646 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3401 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/1991 12:00:00 AM 3   Permit Number 29598 5998560.057030001 2115214.7102799998 37.787892771574 -122.448800429192 (37.787892771574, -122.448800429192)
60097 41275 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2401X Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/04/2002 12:00:00 AM 8 5x6 Permit Number 41958 6001411.89604 2118660.00924 37.7975153358094 -122.439180642975 (37.7975153358094, -122.439180642975)
61654 39864 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Laurel St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 3   Permit Number 41168 5997953.08795 2116209.11804 37.7905884228715 -122.450972154365 (37.7905884228715, -122.450972154365)
61816 50437 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2629 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/09/2003 12:00:00 AM 3   Permit Number 47088 6001609.64635 2117498.51267 37.794337420391 -122.438413117481 (37.794337420391, -122.438413117481)
62978 66450 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3429 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/1991 12:00:00 AM 8   Permit Number 29600 5998447.7021 2115198.86222 37.7878428313222 -122.449188012729 (37.7878428313222, -122.449188012729)
63116 34940 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 448 Amherst St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/19/2000 12:00:00 AM 6   Permit Number 38537 6007767.30311 2091743.1741799999 37.7239675143844 -122.415282750512 (37.7239675143844, -122.415282750512)
63170 61658 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 115 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 15   Permit Number 21651 5992701.25469 2114694.76424 37.78612836504821 -122.4690327763 (37.7861283650482, -122.4690327763)
63561 67596 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 332 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/1992 12:00:00 AM 13 7x7 Permit Number 31163 6013456.33323 2105513.79855 37.7620968446271 -122.396581388139 (37.7620968446271, -122.396581388139)
63701 62973 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2160 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/14/1987 12:00:00 AM 20   Permit Number 23362 6006840.08749 2118678.81808 37.797874363178295 -122.420398962157 (37.7978743631783, -122.420398962157)
65497 65094 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 195 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1989 12:00:00 AM 9   Permit Number 27059 5988970.35279 2114105.07086 37.7842929607651 -122.481897341966 (37.7842929607651, -122.481897341966)
65507 67424 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1305 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/1992 12:00:00 AM 8   Permit Number 30926 5991581.6444 2110628.2851299997 37.774898177463605 -122.47260970334801 (37.7748981774636, -122.472609703348)
65689 65986 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 871 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1990 12:00:00 AM 12 3x3 Permit Number 29015 6009385.3158 2118731.53771 37.798162217257 -122.411595448294 (37.798162217257, -122.411595448294)
65739 62711 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1263 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/1986 12:00:00 AM 14   Permit Number 23051 6006994.18776 2118747.72679 37.798072251784795 -122.419870623035 (37.7980722517848, -122.419870623035)
66363 60560 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 563 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM 15   Permit Number 20170 5985010.58842 2112038.5904099997 37.7783879229396 -122.495444072976 (37.7783879229396, -122.495444072976)
68135 67423 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1300 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/1996 12:00:00 AM 13   Permit Number 30925 5991580.37693 2110684.47332 37.7750523815864 -122.47261818525 (37.7750523815864, -122.47261818525)
68581 71612 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 583 39th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/14/1995 12:00:00 AM 7     5983777.48185 2111850.0463 37.77779795552679 -122.499695843243 (37.7777979555268, -122.499695843243)
69638 41758 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1308 Leavenworth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM 7   Permit Number 42185 6008053.90934 2116945.33468 37.7931829732725 -122.416075956145 (37.7931829732725, -122.416075956145)
69992 67946 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 767 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/1993 12:00:00 AM 12   Permit Number 31660 5989111.82964 2110104.21091 37.7733159430986 -122.481114832992 (37.7733159430986, -122.481114832992)
70749 73609 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 583 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/14/1995 12:00:00 AM 6     5983776.7045 2111867.80576 37.7778466722362 -122.499699845252 (37.7778466722362, -122.499699845252)
71445 61365 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2600 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 10   Permit Number 25881 5996679.04897 2110829.87956 37.7757454412735 -122.454991374462 (37.7757454412735, -122.454991374462)
71484 64978 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2932 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/24/1989 12:00:00 AM 12   Permit Number 26013 6004757.58546 2119683.64744 37.8005157943267 -122.427676637667 (37.8005157943267, -122.427676637667)
72679 61660 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 112 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1984 12:00:00 AM 11   Permit Number 21653 5992438.39496 2114696.12164 37.7861169009047 -122.469942291754 (37.7861169009047, -122.469942291754)
73127 42247 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 565 Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM 6   Permit Number 42494 6009939.10598 2111727.36867 37.7789615000051 -122.409184654573 (37.7789615000051, -122.409184654573)

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 1895.689ms · Data source: data.sfgov.org