5,599 rows where qSpecies_id = 38 sorted by SiteOrder

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)
22402 104719 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 61- 63 SUSSEX ST   Sidewalk: Curb side : Cutout Tree Private 2     14 3x3 Permit Number 771137 6002409.7 2096544.3 37.7368477492981 -122.434146170859 (37.7368477492981, -122.434146170859) 2 7 5 63 7
72110 104720 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 63 SUSSEX ST   Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6002455.5 2096493.1 37.7367097651894 -122.433984161514 (37.7367097651894, -122.433984161514) 2 7 5 63 7
77 225344 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 207 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004214.46195 2097518.65353 37.7396253677099 -122.42797572342 (37.7396253677099, -122.42797572342) 2 7 5 63 7
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
834 225434 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4426 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6001253.02246 2105262.8868 37.7607211930514 -122.438769876745 (37.7607211930514, -122.438769876745) 15 4 5 28862 3
992 192119 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
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
1323 128710 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6011603.69347 2118016.75724 37.7963237889749 -122.403868840184 (37.7963237889749, -122.403868840184) 3 1 10 28860 4
1365 224776 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1600 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 6ft   6005221 2098972 37.7436728204659 -122.42459890056 (37.7436728204659, -122.42459890056) 2 7 5 63 22
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
1824 224952 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3748 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 5x5   6003449.35474 2103046.9521 37.7547614712767 -122.431015593815 (37.7547614712767, -122.431015593815) 2 4 5 28862 22
1848 128781 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 163 Maiden Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010952.71288 2115032.74516 37.7880940182581 -122.405911070134 (37.7880940182581, -122.405911070134) 5 1 10 28857 6
1979 92945 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3516 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5998014.58163 2115182.9594 37.7877743839331 -122.450685374939 (37.7877743839331, -122.450685374939) 11 6 1 54 31
2015 61308 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2309 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 15   Permit Number 21207 6011873.01335 2101843.07946 37.7519296149817 -122.401799483056 (37.7519296149817, -122.401799483056) 10 3 8 28856 29
2150 128068 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2005 12:00:00 AM 13 Width 4ft Permit Number 48272 6009359.15547 2121848.2589 37.8067184913163 -122.411906331309 (37.8067184913163, -122.411906331309) 3 1 10 308 23
2176 59307 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3180 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1980 12:00:00 AM 18   Permit Number 18647 5999500.07139 2116046.04634 37.7902291122342 -122.445607969042 (37.7902291122342, -122.445607969042) 13 6 1 29490 27
2178 56928 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 990 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 22   Permit Number 14172 6008190.72994 2120000.83835 37.8015803191331 -122.415819006365 (37.8015803191331, -122.415819006365) 5 1 10 308 32
2197 126966 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 32 Parker Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5996866.78793 2114389.9756 37.7855312948716 -122.454599192111 (37.7855312948716, -122.454599192111) 11 6 1 54 31
2199 61312 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1458 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 20 4x4 Permit Number 21213 6011710.55671 2101566.51843 37.7511611712496 -122.402341840826 (37.7511611712496, -122.402341840826) 10 3 8 28856 29
2274 40857 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1446 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1999 12:00:00 AM 19   Permit Number 41781 6011709.76908 2101616.07805 37.7512972071976 -122.402348048823 (37.7512972071976, -122.402348048823) 10 3 8 28856 29
2324 68584 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1335 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 15   Permit Number 32481 6008309.92013 2116907.08816 37.793092348579 -122.415187431374 (37.793092348579, -122.415187431374) 5 1 10 28858 21
2345 59877 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2125 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/1981 12:00:00 AM 11   Permit Number 19342 6002756.67005 2118848.34018 37.7981088730742 -122.434540847196 (37.7981088730742, -122.434540847196) 13 9 1 57 17
2395 224762 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004982.47318 2110039.87008 37.7740491098102 -122.426211472077 (37.7740491098102, -122.426211472077) 7 9 11 28852 10
2428 224870 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 886 Castro St 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   6002438.81243 2103075.76594 37.7547832744558 -122.434512381839 (37.7547832744558, -122.434512381839) 2 4 5 28862 22
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
2681 225302 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 6 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003467 2108426 37.7695320434676 -122.431338524707 (37.7695320434676, -122.431338524707) 15 9 5 29492 10
2696 37548 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 952 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM 13   Permit Number 39988 6008033.82968 2115183.28467 37.7883436871616 -122.416020592081 (37.7883436871616, -122.416020592081) 13 1 10 28858 21
2847 128308 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1150 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6012007.52553 2119595.1365 37.8006801903879 -122.402582537171 (37.8006801903879, -122.402582537171) 3 1 10 28860 6
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
3124 176457 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 432 Amherst St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6007753.63778 2091789.49647 37.7240939374796 -122.415333267232 (37.7240939374796, -122.415333267232) 9 3 7 309 28
3467 189657 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2505 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6015867.18038 2103823.80533 37.7575903607135 -122.388125177147 (37.7575903607135, -122.388125177147) 10 3 8 28856 29
3505 68022 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 17 Grant Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1993 12:00:00 AM 5   Permit Number 31753 6011202.97884 2114704.34705 37.7872063082823 -122.405022057035 (37.7872063082823, -122.405022057035) 5 10 10 28857 6
3620 67423 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1300 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/1992 12:00:00 AM 13   Permit Number 30925 5991580.37693 2110684.47332 37.7750523815864 -122.47261818525 (37.7750523815864, -122.47261818525) 11 6 2 54 26
3761 58790 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 350 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/13/1979 12:00:00 AM 5   Permit Number 18035 6012539.98809 2116868.26339 37.793222561422 -122.400548327356 (37.793222561422, -122.400548327356) 4 1 10 28854 6
3764 226567 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 36 Camp St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005696.43071 2106383.98783 37.76405126027 -122.423481806642 (37.76405126027, -122.423481806642) 8 4 5 28859 19
3884 61317 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1415 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/1984 12:00:00 AM 22   Permit Number 21220 6011760.1009 2101696.61273 37.7515211473979 -122.402179656165 (37.7515211473979, -122.402179656165) 10 3 8 28856 29
3931 128405 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 251 Sutter St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 3ft   6011177.50321 2115572.36471 37.7895882544408 -122.405171343593 (37.7895882544408, -122.405171343593) 5 1 10 28857 6
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
4486 225034 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4403 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001357 2105189 37.7605242327726 -122.438404972116 (37.7605242327726, -122.438404972116) 2 4 5 28862 3
4765 110239 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2655 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6000951.09283 2117196.46677 37.793470600727 -122.440670108247 (37.793470600727, -122.440670108247) 13 9 1 29490 27
4791 71991 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 785 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5984443.61146 2110542.72626 37.774247495924 -122.497294973483 (37.774247495924, -122.497294973483) 11 6 2 55 26
5024 189704 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1206 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6013644.41356 2106192.50463 37.7639708878813 -122.395978449371 (37.7639708878813, -122.395978449371) 14 3 8 28856 29
5232 127794 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2229 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   6008462.92143 2120654.02887 37.8033891147652 -122.414923354455 (37.8033891147652, -122.414923354455) 5 1 10 308 32
5506 225470 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2231 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002657.30889 2107063.70687 37.765745599218 -122.434041816972 (37.765745599218, -122.434041816972) 15 5 5 28862 3
5513 124042 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 835 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 7ft   5992827.42703 2114798.67685 37.786420969756 -122.468603820853 (37.786420969756, -122.468603820853) 11 6 2 54 11
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
5735 123023 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 320 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5994043.99217 2113246.58876 37.7822295582626 -122.464282120352 (37.7822295582626, -122.464282120352) 11 6 2 54 11
5769 127718 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1377 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008134.11977 2116552.38078 37.7921085280447 -122.415770585055 (37.7921085280447, -122.415770585055) 5 1 10 28858 21
5848 189784 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Texas St 1 : Tree Private 2     20 Width 4ft   6013708.09947 2105987.51004 37.7634115608072 -122.39574381262 (37.7634115608072, -122.39574381262) 14 3 8 28856 29
5867 176470 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 130 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6009916.73377 2094983.66925 37.7329857989392 -122.408080900424 (37.7329857989392, -122.408080900424) 10 3 7 309 28
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
6102 55726 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2150 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 30 4x4 Permit Number 11752 6003240.02272888 2107147.06325899 37.7660075287211 -122.43203228921 (37.7660075287211, -122.43203228921) 15 5 5 28862 3
6163 225557 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 56 Deming St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5999325.48062 2105227.47982 37.7605141259519 -122.445433809042 (37.7605141259519, -122.445433809042) 15 5 5 28862 3
6210 92707 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2009 12:00:00 AM 13 3x3 Permit Number 52950 6000514.42126 2118236.58998 37.7963016287713 -122.442255722737 (37.7963016287713, -122.442255722737) 13 9 1 57 17
6294 5744 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1759 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x6   6005374.75018 2098167.61874 37.7414728539803 -122.424010079215 (37.7414728539803, -122.424010079215) 2 7 5 28859 7
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
6513 224799 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 159 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6004849.19122 2099568.27784 37.7452890578355 -122.425926962559 (37.7452890578355, -122.425926962559) 2 7 5 63 22
6741 120401 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 173 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5988655.68624 2114206.04007 37.7845518888292 -122.482993367442 (37.7845518888292, -122.482993367442) 11 6 2 55 26
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
6941 7350 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2239 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002792.88059 2116041.24067 37.7904033576739 -122.434214763813 (37.7904033576739, -122.434214763813) 13 9 1 29490 27
7084 119456 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 766 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5985728.91492 2110666.6398 37.7746629724789 -122.492858068519 (37.7746629724789, -122.492858068519) 11 6 2 55 26
7290 103105 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010638.43235 2115205.50204 37.7885507857476 -122.407010612771 (37.7885507857476, -122.407010612771) 5 1 10 28852 6
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
7804 225515 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1930 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 5x7   6004641.55449 2107219.04447 37.7662845296296 -122.427189800463 (37.7662845296296, -122.427189800463) 8 4 5 28862 3
7839 126779 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2055 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6003068.79068 2119239.76733 37.7992013434186 -122.43348880679 (37.7992013434186, -122.43348880679) 13 9 1 57 17
7841 224759 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 231 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6010166.15347 2099991.74226 37.7467508491909 -122.407571558604 (37.7467508491909, -122.407571558604) 2 7 7 28859 2
7963 56974 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 143 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM 6 3x3 Permit Number 14227 5995185.81125 2114601.91547 37.7860166684359 -122.46043020011 (37.7860166684359, -122.46043020011) 11 6 1 54 11
8017 249355 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 625 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008323.0201 2114666.64303 37.7869413697974 -122.414983455249 (37.7869413697974, -122.414983455249) 13 1 9 28858 36
8051 127739 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1301 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008381.5529 2116915.61445 37.7931197850904 -122.41494018075 (37.7931197850904, -122.41494018075) 5 1 10 28858 21
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
8253 11057 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1630 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007426.31744 2117960.00612 37.7959337026338 -122.418319444503 (37.7959337026338, -122.418319444503) 5 1 10 28858 32
8284 115669 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600X Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2016 12:00:00 AM 3 3x3 Permit Number 777079 6001202.18162 2117312.37284 37.7938031439473 -122.439809637804 (37.7938031439473, -122.439809637804) 13 9 1 57 27
8460 12704 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1424 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   5991031.65731 2114791.36704 37.7862970008275 -122.47481613459 (37.7862970008275, -122.47481613459) 11 6 1 54 33
8519 126819 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1861 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000341.48277 2121286.03183 37.8046647257642 -122.443073236154 (37.8046647257642, -122.443073236154) 13 9 1 57 17
8608 218881 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1374 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5993982.19031 2106154.46944 37.7627529198293 -122.463980949379 (37.7627529198293, -122.463980949379) 1 5 11 56 12
8837 251690 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 98 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779453 6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
8948 128780 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 116 Maiden Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6011134.63349 2115083.13634 37.7882425530045 -122.405285203167 (37.7882425530045, -122.405285203167) 5 1 10 28857 6
8971 224736 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3751 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 6x9   6005316.30441 2104275.01271 37.7582390497985 -122.424646518647 (37.7582390497985, -122.424646518647) 2 4 5 28859 19
8984 127637 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 30 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6008197.67751 2111734.21851 37.7788825944034 -122.415209456658 (37.7788825944034, -122.415209456658) 7 10 9 28852 36
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
9310 5671 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1421 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6005267.30914 2100058.51794 37.7466587657846 -122.424516044105 (37.7466587657846, -122.424516044105) 2 7 5 28859 22
9353 218922 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1225 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5995446.34406 2107212.89211 37.7657433464104 -122.45899363306 (37.7657433464104, -122.45899363306) 15 5 11 56 12
9530 225492 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 25 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6001938.93672 2107786.0573 37.7676882004846 -122.436578216329 (37.7676882004846, -122.436578216329) 15 5 5 29492 3
9566 224977 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 51 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6003350.18904 2106235.72692 37.7635114646938 -122.431586177673 (37.7635114646938, -122.431586177673) 15 4 5 28862 3
9733 5598 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1114 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6005085.74952 2101846.15416 37.7515569476132 -122.425271044719 (37.7515569476132, -122.425271044719) 2 4 5 28862 22
9781 113450 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 21X Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008324.74095 2116562.67984 37.7921475208351 -122.415111760598 (37.7921475208351, -122.415111760598) 5 1 10 28858 21
9901 225315 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 107 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003691.1062 2108820.63843 37.7706283225572 -122.430591513988 (37.7706283225572, -122.430591513988) 15 9 11 29492 10
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
10190 128389 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 295 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6012038.5922 2116040.80306 37.79092257676 -122.402224996381 (37.79092257676, -122.402224996381) 4 1 10 28854 6
10227 189669 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2475 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 5ft   6015848.0451 2104085.46802 37.7583077705949 -122.388209616279 (37.7583077705949, -122.388209616279) 10 3 8 28856 29
10366 224768 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 310 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004950.30827 2110058.97913 37.7740997605225 -122.4263240969 (37.7740997605225, -122.4263240969) 7 9 11 28852 10
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
10570 224802 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1450 Sanchez St 1 Sidewalk: Curb side : Pot Tree Private 2     11 Width 2ft   6003910.21401 2099792.41233 37.7458513688561 -122.42918976771 (37.7458513688561, -122.42918976771) 2 7 5 63 22
10654 128380 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 15 Waverly Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010746 2116993 37.7934648453026 -122.406764467868 (37.7934648453026, -122.406764467868) 3 1 10 28857 4

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