5,599 rows where qSpecies_id = 38 sorted by PlotSize

View and edit SQL

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
5605 72081 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 195 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     5993024.92764 2114284.47413 37.7850205170043 -122.467883110599 (37.7850205170043, -122.467883110599) 11 6 2 54 11
6000 73609 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 583 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5983776.7045 2111867.80576 37.7778466722362 -122.499699845252 (37.7778466722362, -122.499699845252) 11 6 2 55 26
6504 64373 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 376 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1988 12:00:00 AM 9   Permit Number 25212 6011164.54643 2119369.06968 37.8000123673464 -122.405483677229 (37.8000123673464, -122.405483677229) 3 1 10 308 23
6796 61320 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1477 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 16   Permit Number 21223 6011774.39181 2101489.85478 37.7509542327749 -122.402115701805 (37.7509542327749, -122.402115701805) 10 3 8 28856 29
7735 72939 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1941 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5999440.2574 2115574.76841 37.7889316917948 -122.445781013002 (37.7889316917948, -122.445781013002) 13 6 1 29490 31
8121 60537 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 543 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1982 12:00:00 AM 11   Permit Number 20147 5985322.70304 2112176.441 37.7787846915609 -122.494374531621 (37.7787846915609, -122.494374531621) 11 6 2 55 26
8779 75939 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2100 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004008.54398 2117326.08278 37.7940001296632 -122.430100346576 (37.7940001296632, -122.430100346576) 13 9 1 29490 27
9057 64002 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1022 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM 19   Permit Number 24749 6007961.58195 2119970.38672 37.8014838218701 -122.416609806295 (37.8014838218701, -122.416609806295) 5 1 10 308 32
9293 61314 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1367 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 14   Permit Number 21216 6011746.30755 2101998.58659 37.752349531804 -122.40224858471 (37.752349531804, -122.40224858471) 10 3 8 28856 29
9932 59703 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3151 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/24/2020 12:00:00 AM 3   Permit Number 19133 5999623.74954 2116015.3785 37.7901519665752 -122.445177847597 (37.7901519665752, -122.445177847597) 13 6 1 29490 27
10035 55896 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3305 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1973 12:00:00 AM 22   Permit Number 11953 5999805.23357 2119943.78324 37.8009486821054 -122.444832429667 (37.8009486821054, -122.444832429667) 13 9 1 57 17
10414 41425 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1568 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/2000 12:00:00 AM 14   Permit Number 42032 6015102.0577 2101304.61846 37.7506307870794 -122.390595272152 (37.7506307870794, -122.390595272152) 10 3 8 28856 1
10718 61315 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1407 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 22   Permit Number 21218 6011759.20106 2101763.54314 37.7517048734844 -122.402187473086 (37.7517048734844, -122.402187473086) 10 3 8 28856 29
10869 114473 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 145 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15     6007374.36978 2108955.06944 37.7712054103423 -122.417860558238 (37.7712054103423, -122.417860558238) 8 2 9 28853 19
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
11275 75984 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2100 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004038.06226 2117331.41602 37.7940164451412 -122.429998590982 (37.7940164451412, -122.429998590982) 13 9 1 29490 27
11377 66090 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1024 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM 16   Permit Number 29134 6007982.68967 2119627.22736 37.8005427793916 -122.416512442105 (37.8005427793916, -122.416512442105) 5 1 1 308 32
11506 65817 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3117 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/1990 12:00:00 AM 12   Permit Number 28806 5999897.13421 2119287.78113 37.7991527197746 -122.444467242891 (37.7991527197746, -122.444467242891) 13 9 1 57 17
11963 116806 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1300 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     5991537.43634 2110683.08947 37.7750460962456 -122.472766623766 (37.7750460962456, -122.472766623766) 11 6 2 54 26
11991 54423 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 735 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/1972 12:00:00 AM 15   Permit Number 10197 6011692.51449 2118000.35932 37.796283725966 -122.403560344851 (37.796283725966, -122.403560344851) 3 1 10 28860 4
12004 72032 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1050 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6007830.36811 2119954.20617 37.8014320137479 -122.417062719267 (37.8014320137479, -122.417062719267) 5 1 10 308 32
12328 61311 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1434 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 17   Permit Number 21210 6011707.20776 2101666.6953 37.7514360481513 -122.402360464866 (37.7514360481513, -122.402360464866) 10 3 8 28856 29
12350 62535 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1250 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/16/1986 12:00:00 AM 16   Permit Number 22718 6007046.83163 2118802.59844 37.798225881165 -122.419692354914 (37.798225881165, -122.419692354914) 5 1 10 28858 32
12693 72442 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 640 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6009698.8624 2115604.67168 37.7895941872619 -122.410289589507 (37.7895941872619, -122.410289589507) 5 1 10 28857 21
12746 62599 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 769 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1986 12:00:00 AM 15   Permit Number 22905 5984445.13215 2110599.07692 37.774402307788 -122.497293873927 (37.774402307788, -122.497293873927) 11 6 2 55 26
12792 62132 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 145 San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/1985 12:00:00 AM 11   Permit Number 22246 6001265.02575 2092251.26554 37.724995031173 -122.437796421771 (37.724995031173, -122.437796421771) 9 7 6 28861 25
13045 60561 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 623 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1982 12:00:00 AM 13   Permit Number 20171 5985027.19418 2111588.97397 37.7771543777649 -122.495353460829 (37.7771543777649, -122.495353460829) 11 6 2 55 26
13193 47563 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 920 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM 13   Permit Number 45425 6011893.37334 2111591.15852 37.778696788166 -122.402414441286 (37.778696788166, -122.402414441286) 14 2 9 28856 34
13478 61365 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1989 12:00:00 AM 10   Permit Number 25881 5996679.04897 2110829.87956 37.7757454412735 -122.454991374462 (37.7757454412735, -122.454991374462) 11 6 2 54 16
13975 34940 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 448 Amherst St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1997 12:00:00 AM 6   Permit Number 38537 6007767.30311 2091743.17418 37.7239675143844 -122.415282750512 (37.7239675143844, -122.415282750512) 9 3 7 309 28
14172 62577 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 411 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1986 12:00:00 AM 6   Permit Number 22780 6011223.32824 2106373.5119 37.7643328973823 -122.404365050124 (37.7643328973823, -122.404365050124) 8 3 8 28856 29
14596 64358 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1364 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1988 12:00:00 AM 13   Permit Number 25194 6006491.60586 2118720.35929 37.7979687811858 -122.421607760696 (37.7979687811858, -122.421607760696) 13 9 10 28858 32
14743 62600 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 775 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1986 12:00:00 AM 13   Permit Number 22906 5984443.81379 2110567.09676 37.7743144221812 -122.497296073019 (37.7743144221812, -122.497296073019) 11 6 2 55 26
14817 104471 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 717 Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2013 12:00:00 AM 15   Permit Number 767241 6012439.90278 2118592.87775 37.797952358665 -122.401015863303 (37.797952358665, -122.401015863303) 3 1 10 28860 6
15146 92502 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 645 05th St 3 : Tree Private 2     23     6013059.80814 2110709.87576 37.7763420329883 -122.398317413322 (37.7763420329883, -122.398317413322) 6 2 9 28856 34
15500 75967 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2100 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6004022.22932 2117328.34706 37.7940071218757 -122.430053155526 (37.7940071218757, -122.430053155526) 13 9 1 29490 27
15656 30489 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 947 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM 16   Permit Number 149 6008994.77228 2115613.22786 37.7895781874332 -122.41272628189 (37.7895781874332, -122.41272628189) 5 1 10 28858 21
15863 106734 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2652 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2014 12:00:00 AM 3   Permit Number 770178 5999150.64318 2119434.00692 37.7995115951419 -122.447060875059 (37.7995115951419, -122.447060875059) 13 9 1 57 17
15973 73076 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1308 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6008053.57424 2116951.24629 37.7931991862554 -122.416077534465 (37.7931991862554, -122.416077534465) 5 1 10 28858 21
16041 62085 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 509 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 15   Permit Number 31131 6013285.17961 2104603.40467 37.7595875760112 -122.397109508714 (37.7595875760112, -122.397109508714) 10 3 8 28856 29
16047 68177 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 63 Rossi Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM 7   Permit Number 31948 5996332.84265 2111732.38304 37.7782036117907 -122.45625425125 (37.7782036117907, -122.45625425125) 11 6 2 54 16
16081 62973 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2160 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM 20   Permit Number 23362 6006840.08749 2118678.81808 37.7978743631783 -122.420398962157 (37.7978743631783, -122.420398962157) 5 9 10 28858 32
16187 59653 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 587 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/1981 12:00:00 AM 23   Permit Number 19073 6011264.22145 2105613.67031 37.762248828236 -122.404170130169 (37.762248828236, -122.404170130169) 8 3 8 28856 29
16428 60560 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 563 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1982 12:00:00 AM 15   Permit Number 20170 5985010.58842 2112038.59041 37.7783879229396 -122.495444072976 (37.7783879229396, -122.495444072976) 11 6 2 55 26
16523 49710 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2841GREENWICH Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2003 12:00:00 AM 10   Permit Number 46523 5999496.96891 2118665.02672 37.7974199618166 -122.445807134711 (37.7974199618166, -122.445807134711) 13 9 1 57 17
16621 70332 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 765 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5982891.42605 2110581.736 37.7742635126433 -122.502667063271 (37.7742635126433, -122.502667063271) 11 6 2 55 26
16639 62134 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 215 San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/1985 12:00:00 AM 11   Permit Number 22242 6001128.88331 2092317.53271 37.7251692433568 -122.438271795315 (37.7251692433568, -122.438271795315) 9 7 6 28861 25
16862 72075 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 177 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     5989896.15607 2114192.30044 37.7845862663566 -122.478700804688 (37.7845862663566, -122.478700804688) 11 6 2 55 26
17889 58681 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2339 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/1979 12:00:00 AM 13   Permit Number 17909 6001837.83245 2118026.07393 37.7957989428223 -122.437661368787 (37.7957989428223, -122.437661368787) 13 9 1 57 27
17937 66603 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1225 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 7   Permit Number 29798 6008039.621 2115833.32115 37.790128854013 -122.416046607673 (37.790128854013, -122.416046607673) 13 1 10 28858 21
18362 31033 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 105x Bennington St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM 14   Permit Number 34795 6007139 2097159 37.7388028593756 -122.417838417363 (37.7388028593756, -122.417838417363) 2 7 7 28859 2
18683 64976 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3024 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1989 12:00:00 AM 11   Permit Number 26011 6004714.90539 2119991.34549 37.8013582396417 -122.427846265115 (37.8013582396417, -122.427846265115) 13 9 1 57 17
20318 58775 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1151 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/1979 12:00:00 AM 21   Permit Number 18018 6011965.68548 2103057.98267 37.7552706449278 -122.401564386789 (37.7552706449278, -122.401564386789) 10 3 8 28856 29
20398 106085 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2710 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     16     6003043.75991 2118055.45149 37.795948098984 -122.433490741223 (37.795948098984, -122.433490741223) 13 9 1 57 17
20857 57294 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3030 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM     Permit Number 16115 6006612.86147234 2106740.75991177 37.7650825555261 -122.420337459951 (37.7650825555261, -122.420337459951) 8 4 7 28853 19
20926 40346 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3625 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     5   Permit Number 41477 5996889.13616 2115964.594 37.7898560581496 -122.454635672204 (37.7898560581496, -122.454635672204) 11 6 1 54 31
21734 61319 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1425 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/1984 12:00:00 AM 24   Permit Number 21222 6011767.84786 2101592.50554 37.7512357241518 -122.402145547589 (37.7512357241518, -122.402145547589) 10 3 8 28856 29
21742 55626 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2150 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/1973 12:00:00 AM 17   Permit Number 11605 6003872.40922 2116984.632 37.7930548819164 -122.43054701104 (37.7930548819164, -122.43054701104) 13 9 1 29490 27
21971 36892 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 10 Presidio Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM 9   Permit Number 39545 5998941.54083 2116530.8219 37.7915282746499 -122.447575345738 (37.7915282746499, -122.447575345738) 13 6 1 29490 31
22226 51925 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM 8   Permit Number 48124 5998455.0177 2116126.83868 37.7903912276242 -122.449229583883 (37.7903912276242, -122.449229583883) 13 6 1 54 31
22354 38759 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 325 05th St 1 Sidewalk: Curb side : Cutout Tree Private 2     36   Permit Number 40631 6011796.14841 2112034.18458 37.7799078071241 -122.402781947454 (37.7799078071241, -122.402781947454) 6 2 9 28856 34
22581 57899 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1908 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/1977 12:00:00 AM 19   Permit Number 16855 6003815.15753 2118345.7305 37.7967888661753 -122.430842284546 (37.7967888661753, -122.430842284546) 13 9 1 57 17
22583 53485 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 147 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1969 12:00:00 AM 10   Permit Number 6394 5993327.4346 2114508.15513 37.7856521474573 -122.46685280764 (37.7856521474573, -122.46685280764) 11 6 2 54 11
22640 218960 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 374 Joost Ave 2 Sidewalk: Property side : Yard Tree Private 2     13     5999594.52291 2094990.63523 37.7324215723769 -122.443767859899 (37.7324215723769, -122.443767859899) 9 7 4 63 40
22659 53616 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/1986 12:00:00 AM 8   Permit Number 23021 6011569.0599 2116730.65971 37.7927905387988 -122.403898132903 (37.7927905387988, -122.403898132903) 4 1 10 28854 6
23037 247033 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 550x Valley St 11 Median : Yard Tree DPW 1     8     6002285.13208 2099166.02387 37.7440393230544 -122.434764280156 (37.7440393230544, -122.434764280156) 2 7 5 63 22
23239 42962 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2510 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     11   Permit Number 42851 6002078.83909 2116730.65434 37.7922557569435 -122.436734666867 (37.7922557569435, -122.436734666867) 13 6 1 29490 27
23341 65336 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1699 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/1989 12:00:00 AM 9   Permit Number 28164 6005487.09348 2118184.69125 37.7964412799947 -122.425045530732 (37.7964412799947, -122.425045530732) 13 9 1 28858 27
23540 44129 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2720 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2000 12:00:00 AM 7   Permit Number 43632 6001619.2356 2117785.34422 37.7951255304666 -122.43840049728 (37.7951255304666, -122.43840049728) 13 9 1 57 27
23545 58731 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1050 Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/1981 12:00:00 AM 15   Permit Number 19424 6012335.49363 2119717.01394 37.8010331410233 -122.401456195674 (37.8010331410233, -122.401456195674) 3 1 10 28860 6
23594 55892 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3146 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1973 12:00:00 AM 15   Permit Number 11949 5999926.66303 2119408.65494 37.7994862918221 -122.444373754755 (37.7994862918221, -122.444373754755) 13 9 1 57 17
23757 111580 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1501-1555 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2015 12:00:00 AM 3     6012799.17131 2106096.78532 37.7636610021682 -122.398895191771 (37.7636610021682, -122.398895191771) 14 3 8 28856 29
23817 64712 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1649 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/1988 12:00:00 AM 8   Permit Number 25661 6002326.17264 2121218.54914 37.8045923968968 -122.436200200684 (37.8045923968968, -122.436200200684) 13 9 1 57 17
23914 8332 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1115 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12     6006224.34418 2114188.56599 37.785510534017 -122.422210428763 (37.785510534017, -122.422210428763) 13 9 11 28858 41
24436 55846 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2203 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1973 12:00:00 AM 21   Permit Number 11895 6001329.93654 2116033.76295 37.7902996847396 -122.43927590546 (37.7902996847396, -122.43927590546) 13 6 1 29490 27

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