5,599 rows where qSpecies_id = 38 sorted by qCareAssistant descending

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)
34689 251592 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1999X Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6007220 2119146 37.799178528828 -122.419117510386 (37.799178528828, -122.419117510386) 5 1 10 28858 32
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
1089 60912 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 149 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/1993 12:00:00 AM 8 3x3 Permit Number 32000 6012148.61414 2119800.05377 37.8012507194169 -122.402108723944 (37.8012507194169, -122.402108723944) 3 1 10 28860 6
1097 73684 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1050 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6007850.01602 2119957.29186 37.8014415915259 -122.416994947282 (37.8014415915259, -122.416994947282) 5 1 10 308 32
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
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
2199 61312 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1458 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 20 4x4 Permit Number 21213 6011710.55671 2101566.51843 37.7511611712496 -122.402341840826 (37.7511611712496, -122.402341840826) 10 3 8 28856 29
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
2595 71280 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2046 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 6x7   6003095.65483 2119286.01418 37.7993298493627 -122.433399154261 (37.7993298493627, -122.433399154261) 13 9 1 57 17
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
2798 119275 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 350 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 3x3   6012236.75747 2118139.41245 37.7966959176338 -122.40168691852 (37.7966959176338, -122.40168691852) 3 1 10 28860 4
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
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
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
6462 48434 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1190 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2002 12:00:00 AM 10 3x3 Permit Number 45810 6009120.00947 2116723.6961 37.7926342914851 -122.412371495743 (37.7926342914851, -122.412371495743) 3 1 10 28857 21
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
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
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
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
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
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
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
15710 41275 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2401X Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/24/2000 12:00:00 AM 8 5x6 Permit Number 41958 6001411.89604 2118660.00924 37.7975153358094 -122.439180642975 (37.7975153358094, -122.439180642975) 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
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
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
17006 40089 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1464 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 20 4x4 Permit Number 41313 6011714.10496 2101526.60671 37.7510517804331 -122.40232676458 (37.7510517804331, -122.40232676458) 10 3 8 28856 29
17179 30661 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 80x Lafayette St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1995 12:00:00 AM 8 3x3 Permit Number 34594 6007679 2109478 37.7726583931046 -122.416843882018 (37.7726583931046, -122.416843882018) 8 2 9 28853 19
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
17959 69744 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1855X Evans Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8 3x3   6014390.51341 2099418.69013 37.7454129250631 -122.392923937985 (37.7454129250631, -122.392923937985) 10 3 8 58 1
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
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
22476 65771 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2052 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1990 12:00:00 AM 13 7.5x6 Permit Number 28735 6003069.74843 2119283.0108 37.7993201330793 -122.433488584626 (37.7993201330793, -122.433488584626) 13 9 1 57 17
26393 69442 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013823.57483 2111230.54106 37.777814177306 -122.395711802165 (37.777814177306, -122.395711802165) 6 2 9 28856 34
26614 67381 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 746 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1992 12:00:00 AM 11   Permit Number 30877 5992283.56809 2110358.49026 37.7741979986154 -122.470161972963 (37.7741979986154, -122.470161972963) 11 6 2 54 11
32038 66092 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1045 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/1991 12:00:00 AM 13   Permit Number 30057 6007920.64716 2119570.39456 37.8003832414466 -122.416723106486 (37.8003832414466, -122.416723106486) 5 1 1 308 32
32598 66449 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3425 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM 10   Permit Number 29599 5998479.21023 2115203.29872 37.7878568148822 -122.449079320659 (37.7878568148822, -122.449079320659) 13 6 1 54 31
32944 65094 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 195 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1989 12:00:00 AM 9   Permit Number 27059 5988970.35279 2114105.07086 37.7842929607651 -122.481897341966 (37.7842929607651, -122.481897341966) 11 6 2 55 26
34898 65104 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 179 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 12   Permit Number 27071 5988966.04699 2114149.58894 37.7844149444345 -122.481915500518 (37.7844149444345, -122.481915500518) 11 6 2 55 26
36715 39864 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Laurel St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM 3   Permit Number 41168 5997953.08795 2116209.11804 37.7905884228715 -122.450972154365 (37.7905884228715, -122.450972154365) 11 6 1 54 31
37979 68982 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2370 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1994 12:00:00 AM 14   Permit Number 32972 5999967.44884 2119893.11849 37.8008188262957 -122.4442674549 (37.8008188262957, -122.4442674549) 13 9 1 57 17
38344 34265 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 190 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM 4   Permit Number 38069 5988067.01852 2114738.37532 37.7859792587146 -122.48506900308 (37.7859792587146, -122.48506900308) 11 6 1 55 33
38827 66091 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1034 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM 14   Permit Number 29135 6007971.34361 2119625.28067 37.8005367961869 -122.416551566212 (37.8005367961869, -122.416551566212) 5 1 1 308 32
41345 67596 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 332 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 13 7x7 Permit Number 31163 6013456.33323 2105513.79855 37.7620968446271 -122.396581388139 (37.7620968446271, -122.396581388139) 10 3 8 28856 29
46137 63976 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1000 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM 18   Permit Number 24713 6008118.77344 2119296.69749 37.7996428790721 -122.416018115343 (37.7996428790721, -122.416018115343) 5 1 1 308 32
46547 117217 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013756.29755 2111297.17195 37.7779933879131 -122.395949209701 (37.7779933879131, -122.395949209701) 6 2 9 28856 34
47506 68261 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 331 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 4   Permit Number 32067 6009662.93548 2092873.24927 37.72717681975 -122.408809511343 (37.72717681975, -122.408809511343) 10 3 7 309 28
47712 41757 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1308 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM 10   Permit Number 42185 6008053.97146 2116940.94284 37.7931709178551 -122.416075430034 (37.7931709178551, -122.416075430034) 5 1 10 28858 21
49628 31062 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 11 Pearl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 11   Permit Number 34812 6005632.00792 2108946.6146 37.7710839856666 -122.423886862202 (37.7710839856666, -122.423886862202) 8 2 5 28853 19
53095 66450 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3429 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM 8   Permit Number 29600 5998447.7021 2115198.86222 37.7878428313222 -122.449188012729 (37.7878428313222, -122.449188012729) 13 6 1 54 31
53923 116807 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1300 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   18     5991517.51239 2110683.05155 37.7750448387434 -122.472835541621 (37.7750448387434, -122.472835541621) 11 6 2 54 26
54451 42248 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 565 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM 7   Permit Number 42494 6009953.25863 2111737.14002 37.7789891226943 -122.409136384353 (37.7789891226943, -122.409136384353) 14 2 9 28853 34
56757 63987 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2323 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM 17   Permit Number 24733 6008004.76254 2120437.22728 37.8027680771474 -122.416493469105 (37.8027680771474, -122.416493469105) 5 1 1 308 32
57140 61507 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 195 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/1984 12:00:00 AM 16   Permit Number 21462 5989900.42739 2114099.23547 37.784330984044 -122.478679219068 (37.784330984044, -122.478679219068) 11 6 2 55 26
59005 41758 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1308 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM 7   Permit Number 42185 6008053.90934 2116945.33468 37.7931829732725 -122.416075956145 (37.7931829732725, -122.416075956145) 5 1 10 28858 21
61276 117218 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2016 12:00:00 AM 3   Permit Number 778712 6013744.24197 2111311.08436 37.7780309175198 -122.395991889732 (37.7780309175198, -122.395991889732) 6 2 9 28856 34
61816 64975 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3048 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1989 12:00:00 AM 10   Permit Number 26010 6004703.95755 2120073.6188 37.8015835216136 -122.427890015323 (37.8015835216136, -122.427890015323) 13 9 1 57 17
62026 41169 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Avila St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/1999 12:00:00 AM 9   Permit Number 41890 6001073.75913 2119781.55874 37.8005755677693 -122.440431161974 (37.8005755677693, -122.440431161974) 13 9 1 57 17
62576 64955 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2809 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1989 12:00:00 AM 11   Permit Number 25986 6004773.14771 2119232.31756 37.7992774386635 -122.427590613024 (37.7992774386635, -122.427590613024) 13 9 1 57 17
65396 61528 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 366 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1984 12:00:00 AM 11   Permit Number 21485 5991243.78847 2112949.32705 37.7812515598972 -122.473947781715 (37.7812515598972, -122.473947781715) 11 6 2 54 26
66896 67945 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 759 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM 12   Permit Number 31659 5989112.06569 2110153.62937 37.7734516462501 -122.481117635738 (37.7734516462501, -122.481117635738) 11 6 2 55 26
67444 112803 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 871 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13 3x3   6009403.91874 2118733.1946 37.7981678101526 -122.411531193508 (37.7981678101526, -122.411531193508) 3 1 10 308 4
68648 61195 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 149 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1984 12:00:00 AM 16   Permit Number 21659 5992399.94537 2114452.9387 37.7854469649294 -122.470057602229 (37.7854469649294, -122.470057602229) 11 6 2 54 11
69891 65846 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/1990 12:00:00 AM 12   Permit Number 28837 6001437.53726 2121346.67782 37.8048936760572 -122.439284590205 (37.8048936760572, -122.439284590205) 13 9 1 57 17
72210 63985 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1016 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM 15   Permit Number 24731 6007985.39703 2119974.81422 37.8014973180156 -122.416527708984 (37.8014973180156, -122.416527708984) 5 1 10 308 32
74427 116808 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1300 Cabrillo St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   21     5991501.56814 2110682.77742 37.775043163026 -122.472890675729 (37.775043163026, -122.472890675729) 11 6 2 54 26

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