trees

5,599 rows where qSpecies_id = 38

✎ View and edit SQL

This data as json, CSV (advanced)

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)
10669 113451 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 21X Leroy Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008325.83409 2116548.49106 37.7921086233576 -122.415106973525 (37.7921086233576, -122.415106973525) 5 1 10 28858 21
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
10727 190148 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1711 Oakdale Ave 1 : Tree Private 2     6 Width 3ft   6014397.54059 2095926.93864 37.7358256897857 -122.392655422032 (37.7358256897857, -122.392655422032) 10 3 8 58 1
10802 190210 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 55 Main St 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013925.01532 2116617.87783 37.7926122059272 -122.395738456263 (37.7926122059272, -122.395738456263) 12 2 9 28855 6
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
10886 192122 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     23 Width 4ft   6010961.41826 2113239.46389 37.7831705790105 -122.405754586311 (37.7831705790105, -122.405754586311) 12 2 9 28853 34
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                    
11011 249339 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 839 Post St 1 : Tree Private 2     13 Width 3ft   6008120.77004 2114802.70738 37.7873036023197 -122.415692834155 (37.7873036023197, -122.415692834155) 13 1 9 28858 36
11110 192149 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 63 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 5ft   6007788.06434 2110652.2421 37.7758887171372 -122.416549810724 (37.7758887171372, -122.416549810724) 8 2 9 28853 34
11125 127105 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1601 Beach St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002505.01994 2121244.09156 37.8046726892538 -122.435583111981 (37.8046726892538, -122.435583111981) 13 9 1 57 17
11132 19204 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 630 Sansome St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6012243.07343 2117875.47251 37.7959715542054 -122.401646502996 (37.7959715542054, -122.401646502996) 3 1 10 28860 4
11215 127251 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2655 Pierce St 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6001594.68789 2117605.84286 37.7946312702617 -122.438472568947 (37.7946312702617, -122.438472568947) 13 9 1 57 27
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
11298 127916 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1175 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/31/1990 12:00:00 AM 13 Width 4ft   6007863.00532 2121226.60678 37.8049275409425 -122.417039987112 (37.8049275409425, -122.417039987112) 5 1 1 308 32
11305 189630 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 7 : Tree Private 2     14 Width 3ft   6007441.71426 2110305.43642 37.7749169870715 -122.417723340559 (37.7749169870715, -122.417723340559) 8 2 9 28853 34
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
11574 224725 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 601 Treat Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008501.01971 2104985.35015 37.7603688215875 -122.413682590383 (37.7603688215875, -122.413682590383) 2 4 7 28859 19
11597 189629 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 6 : Tree Private 2     16 Width 3ft   6007461.61467 2110284.7901 37.774861417042 -122.417653036967 (37.774861417042, -122.417653036967) 8 2 9 28853 34
11615 189628 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 5 : Tree Private 2     11 Width 3ft   6007505.86156 2110238.1728 37.7747359067747 -122.417496672745 (37.7747359067747, -122.417496672745) 8 2 9 28853 34
11696 189660 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2573 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 Width 4ft   6015900.45488 2103484.96239 37.7566618134199 -122.387986454936 (37.7566618134199, -122.387986454936) 10 3 8 28856 29
11735 260909 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 241 Laussat St 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003564.7514 2109147.66361 37.7715190947724 -122.431051921008 (37.7715190947724, -122.431051921008) 15 9 11 29492 10
11772 225309 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 104 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/1987 12:00:00 AM 16 Width 3ft Permit Number 24228 6003856.7224 2108736.74248 37.7704073456534 -122.430012659982 (37.7704073456534, -122.430012659982) 7 9 11 29492 10
11784 127030 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3851 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000069.69361 2121560.37704 37.8054025034915 -122.444033510631 (37.8054025034915, -122.444033510631) 13 9 1 57 17
11786 4500 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1740 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6004605.06487 2098773.28135 37.743092380112 -122.426714507892 (37.743092380112, -122.426714507892) 2 7 5 63 22
11793 126809 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2460 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5999542.14007 2119832.86925 37.800629124187 -122.445734860683 (37.800629124187, -122.445734860683) 13 9 1 57 17
11937 224824 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3560 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6004632.97491 2103109.67148 37.7550006810587 -122.42692677575 (37.7550006810587, -122.42692677575) 2 4 5 28862 22
11943 246684 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 7 Sidewalk: Property side : Yard Tree Private 2     17 Width 4ft   6004997.42528 2097597.83608 37.7398870497478 -122.425274204056 (37.7398870497478, -122.425274204056) 2 7 5 63 7
11954 224730 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 21 Oakwood St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1983 12:00:00 AM 15 Width 5ft Permit Number 20367 6005252.62208 2105310.75713 37.7610793633446 -122.42494044944 (37.7610793633446, -122.42494044944) 2 4 5 28859 19
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
11969 225360 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 127 Otis St 3 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6006951.60276 2109409.2477 37.7724286744738 -122.41935515412 (37.7724286744738, -122.41935515412) 8 2 9 28853 19
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
11995 127689 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1020 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009869.61301 2116828.44156 37.7929639334768 -122.409785225409 (37.7929639334768, -122.409785225409) 3 1 10 28857 21
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
12010 128071 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009416.46616 2121854.31268 37.8067383285777 -122.411708423825 (37.8067383285777, -122.411708423825) 3 1 10 308 23
12022 251011 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3832 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2015 12:00:00 AM 12 Width 3ft Permit Number 32266 5995890.12624 2115872.70718 37.7895464116889 -122.458085479669 (37.7895464116889, -122.458085479669) 11 6 1 54 31
12034 189635 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 12 : Tree Private 2     13 Width 3ft   6007252.77598 2110507.15575 37.7754602261381 -122.418391225675 (37.7754602261381, -122.418391225675) 8 2 9 28853 34
12134 192099 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 999 Brannan St 9 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6010725.77317 2108634.41691 37.7705130105866 -122.406245268117 (37.7705130105866, -122.406245268117) 14 2 9 28853 34
12239 189672 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2427 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6015841.43821 2104253.31303 37.7587682711682 -122.388244179947 (37.7587682711682, -122.388244179947) 10 3 8 28856 29
12286 127676 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1300 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6007154.04551 2115409.35326 37.7889149122532 -122.419080550627 (37.7889149122532, -122.419080550627) 13 9 10 28858 21
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
12375 226540 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1220 Potrero Ave 2 : Tree Private 2     28 Width 4ft   6010529.29654 2102158.63708 37.752720986907 -122.406468503221 (37.752720986907, -122.406468503221) 10 4 7 28859 19
12427 189631 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 8 : Tree Private 2     9 Width 3ft   6007308.18753 2110441.11785 37.7752820209699 -122.418194860528 (37.7752820209699, -122.418194860528) 8 2 9 28853 34
12432 189645 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2300 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6010927.82584 2105101.25032 37.7608230358835 -122.405297514886 (37.7608230358835, -122.405297514886) 10 3 8 28856 29
12434 64629 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1824 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/1988 12:00:00 AM 12 3x3 Permit Number 25539 6004249.16577 2118756.87495 37.7979423438312 -122.429369849745 (37.7979423438312, -122.429369849745) 13 9 1 57 17
12443 126758 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2252 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6002155.35779 2118810.64175 37.7979712102548 -122.436618860277 (37.7979712102548, -122.436618860277) 13 9 1 57 17
12460 106116 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 615 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008342 2114560 37.7866496204263 -122.414910238271 (37.7866496204263, -122.414910238271) 13 1 9 28858 36
12465 192125 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 7 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     23 Width 4ft   6011096.71819 2113372.25093 37.7835427463303 -122.405295854729 (37.7835427463303, -122.405295854729) 12 2 9 28853 34
12501 126681 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2961 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5999971.48713 2118755.27158 37.7976948324145 -122.44417167168 (37.7976948324145, -122.44417167168) 13 9 1 57 17
12592 190145 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1270 Fairfax Ave 5 : Tree Private 2     16 Width 4ft   6017279.69898 2096994.64423 37.7389170445949 -122.38276484453 (37.7389170445949, -122.38276484453) 10 3 8 58 1
12667 128102 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2201 Grant Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6010206.19487 2122052.60554 37.8073270607527 -122.408989401833 (37.8073270607527, -122.408989401833) 3 1 10 308 23
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
12718 127207 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2332 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999792.21615 2116884.67261 37.7925484341161 -122.444657475575 (37.7925484341161, -122.444657475575) 13 6 1 29490 27
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
12804 128534 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 California St 9 Sidewalk: Curb side : Pot Tree Private 2     7 Width 4ft   6012182.93636 2116816.58192 37.7930607374112 -122.40178012248 (37.7930607374112, -122.40178012248) 4 1 10 28854 6
12810 189626 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 3 : Tree Private 2     14 Width 3ft   6007544.58338 2110195.50679 37.7746209347449 -122.417359701486 (37.7746209347449, -122.417359701486) 8 2 9 28853 34
12986 189793 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 308 Hernandez Ave 1 : Tree Private 2     13 Width 3ft   6013450.09241 2105609.9853 37.7623606049856 -122.396609715861 (37.7623606049856, -122.396609715861) 10 3 8 28856 29
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
13257 190280 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 165 02nd St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6013037.87602 2114674.12201 37.7872257183411 -122.398671543862 (37.7872257183411, -122.398671543862) 12 2 9 28855 6
13311 192077 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 121 Vermont St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011151.74903 2107654.57043 37.7678463939135 -122.404702815691 (37.7678463939135, -122.404702815691) 8 2 8 28853 20
13328 11025 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1432 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2019 12:49:00 PM 3 3X3   6007519.86638 2117318.51464 37.7941775919798 -122.417950249398 (37.7941775919798, -122.417950249398) 5 1 10 28858 32
13331 116006 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 901x Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 5x4   6012340.70136 2119306.19591 37.7999054244574 -122.401409287026 (37.7999054244574, -122.401409287026) 3 1 10 28860 6
13416 225005 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 33 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002660.97624 2105683.76524 37.7619568228629 -122.433930486302 (37.7619568228629, -122.433930486302) 15 4 5 28862 3
13470 225418 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 761 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6003096.19363 2103772.0695 37.7567324533532 -122.432288704686 (37.7567324533532, -122.432288704686) 2 4 5 28862 3
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
13585 11032 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1500 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6007492.86428 2117507.22815 37.794694232707 -122.418057064576 (37.794694232707, -122.418057064576) 5 1 10 28858 32
13688 189611 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1001x Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 8ft   6011323 2110932 37.776855034552 -122.404341187165 (37.776855034552, -122.404341187165) 14 2 9 28853 34
13815 127886 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1041 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007944.67087 2119227.24756 37.7994423968049 -122.416615652791 (37.7994423968049, -122.416615652791) 5 1 10 308 32
13912 189747 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2101 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6011437.2397 2105085.01288 37.7608069191222 -122.403534526214 (37.7608069191222, -122.403534526214) 10 3 8 28856 29
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
13991 224924 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 335 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002959.54697 2101510.24003 37.7505142574246 -122.432599720794 (37.7505142574246, -122.432599720794) 2 4 5 28862 22
14007 260416 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 360 Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003567.24671 2108663.75145 37.7701905316964 -122.431008746366 (37.7701905316964, -122.431008746366) 15 9 11 29492 10
14047 128080 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009637.33282 2121886.34956 37.8068386812172 -122.410946332908 (37.8068386812172, -122.410946332908) 3 1 10 308 23
14094 224812 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 271 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 4x4   6004788.43522 2102099.80744 37.7522366192399 -122.426317253057 (37.7522366192399, -122.426317253057) 2 4 5 28862 22
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
14255 128145 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007754.46725 2121683.60014 37.8061762226282 -122.41744800324 (37.8061762226282, -122.41744800324) 5 1 10 308 23
14405 11035 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1516 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6007484.17478 2117558.36602 37.7948341555154 -122.418090758582 (37.7948341555154, -122.418090758582) 5 1 10 28858 32
14467 121481 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 974 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6007930.82264 2115167.72637 37.7882951759371 -122.416375878271 (37.7882951759371, -122.416375878271) 13 1 10 28858 21
14519 126987 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3100 Baker St 1 Median : Cutout Tree Private 2     20 Width 2ft   5999366.53139 2119613.96333 37.8000180393548 -122.446326780069 (37.8000180393548, -122.446326780069) 13 9 1 57 17
14567 128480 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 330 Pine St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6012292.28897 2116471.0493 37.7921180887322 -122.401377460022 (37.7921180887322, -122.401377460022) 4 1 10 28854 6
14588 224829 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3762 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6004651.57948 2102527.73834 37.7534038808035 -122.426820994809 (37.7534038808035, -122.426820994809) 2 4 5 28862 22
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
14627 127654 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 290 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6006004.92126 2110899.69306 37.7764677141485 -122.422735759666 (37.7764677141485, -122.422735759666) 7 9 11 28852 10
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
14745 128030 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2601 Jones St 9 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007872.77059 2121403.52137 37.8054138529431 -122.41701873613 (37.8054138529431, -122.41701873613) 5 1 10 308 23
14778 18836 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2055 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004953.14987 2116100.26294 37.7906877916676 -122.426744576702 (37.7906877916676, -122.426744576702) 13 9 1 28858 27
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
14908 127573 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 515 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6008275.3046 2113776.68195 37.7844950708296 -122.415085522888 (37.7844950708296, -122.415085522888) 7 10 9 28858 36
14947 218904 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 33 Cragmont Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992852.19687 2101722.68629 37.7505192091019 -122.467566857535 (37.7505192091019, -122.467566857535) 1 8 4 29491 12
15009 12639 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 916 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 6x7   5992597.52584 2114847.07961 37.7865405872228 -122.469402738454 (37.7865405872228, -122.469402738454) 11 6 1 54 11
15053 128006 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 444 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008599.60953 2121451.88752 37.8055875138213 -122.414506829842 (37.8055875138213, -122.414506829842) 3 1 10 308 23
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
15149 224382 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 580 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   6004948.95647 2107823.26062 37.7679609414671 -122.426169574466 (37.7679609414671, -122.426169574466) 8 4 5 28853 19
15151 128556 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 505 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6012249 2117377 37.7946031984867 -122.401590943664 (37.7946031984867, -122.401590943664) 3 1 10 28860 4
15244 260908 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 241 Laussat St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003564.7514 2109147.66361 37.7715190947724 -122.431051921008 (37.7715190947724, -122.431051921008) 15 9 11 29492 10
15330 192018 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 477 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6013668.60468 2111446.81153 37.7783993850599 -122.396263063192 (37.7783993850599, -122.396263063192) 6 2 9 28856 34
15334 59986 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1552 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/1982 12:00:00 AM 19 3x3 Permit Number 19470 6015757.2015 2097078.53248 37.7390631520541 -122.388034834851 (37.7390631520541, -122.388034834851) 10 3 8 58 1

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