5,599 rows where qSpecies_id = 38 sorted by Supervisor Districts

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)
22342 23393 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1525 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6006200.49958 2115768.09459 37.7898461836045 -122.422405194958 (37.7898461836045, -122.422405194958) 13 9 1 28858 41
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
22552 11442 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2200X Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6005100.87554 2117226.15448 37.7937875569128 -122.426313648558 (37.7937875569128, -122.426313648558) 13 9 1 28858 27
22560 127090 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3700 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002585.26215 2121327.12362 37.8049052305658 -122.43531136925 (37.8049052305658, -122.43531136925) 13 9 1 57 17
22565 126742 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2600 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6000494.04635 2118234.18891 37.7962938748199 -122.442326051507 (37.7962938748199, -122.442326051507) 13 9 1 57 17
22581 57899 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1908 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/1977 12:00:00 AM 19   Permit Number 16855 6003815.15753 2118345.7305 37.7967888661753 -122.430842284546 (37.7967888661753, -122.430842284546) 13 9 1 57 17
22601 126687 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2801 Divisadero St 8 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   6000575.90002 2117927.00422 37.7954550915302 -122.442020761354 (37.7954550915302, -122.442020761354) 13 9 1 57 17
22699 127073 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3300 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001871.53921 2119490.55222 37.799821933201 -122.437649670404 (37.799821933201, -122.437649670404) 13 9 1 57 17
22732 126996 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2801 Scott St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6001058.00496 2118008.7846 37.7957071004512 -122.440358468872 (37.7957071004512, -122.440358468872) 13 9 1 57 17
23003 126994 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2934 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6000027.86912 2118666.87845 37.7974553447383 -122.44397022085 (37.7974553447383, -122.44397022085) 13 9 1 57 17
23183 126844 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 Avila St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6001083.66334 2121459.71745 37.8051839088787 -122.440517318817 (37.8051839088787, -122.440517318817) 13 9 1 57 17
23239 42962 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2510 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     11   Permit Number 42851 6002078.83909 2116730.65434 37.7922557569435 -122.436734666867 (37.7922557569435, -122.436734666867) 13 6 1 29490 27
23341 65336 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1699 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/1989 12:00:00 AM 9   Permit Number 28164 6005487.09348 2118184.69125 37.7964412799947 -122.425045530732 (37.7964412799947, -122.425045530732) 13 9 1 28858 27
23397 124713 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3801 Jackson St 9 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5996049.91136 2115838.85181 37.7894626335257 -122.457530193146 (37.7894626335257, -122.457530193146) 11 6 1 54 31
23540 44129 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2720 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2000 12:00:00 AM 7   Permit Number 43632 6001619.2356 2117785.34422 37.7951255304666 -122.43840049728 (37.7951255304666, -122.43840049728) 13 9 1 57 27
23594 55892 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3146 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1973 12:00:00 AM 15   Permit Number 11949 5999926.66303 2119408.65494 37.7994862918221 -122.444373754755 (37.7994862918221, -122.444373754755) 13 9 1 57 17
23630 127001 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2163 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002666.12266 2118488.36209 37.7971153263746 -122.434828410807 (37.7971153263746, -122.434828410807) 13 9 1 57 17
23700 127181 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2964 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   5999996.25641 2116444.29792 37.7913509220472 -122.443919837252 (37.7913509220472, -122.443919837252) 13 6 1 29490 27
23817 64712 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1649 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/1988 12:00:00 AM 8   Permit Number 25661 6002326.17264 2121218.54914 37.8045923968968 -122.436200200684 (37.8045923968968, -122.436200200684) 13 9 1 57 17
23928 115509 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2711 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6004386.03823 2118553.27789 37.7973910665864 -122.428881709442 (37.7973910665864, -122.428881709442) 13 9 1 57 17
24172 9915 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1900 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1     26 3X3   6005229.57224 2116308.1912 37.7912743348887 -122.42580297572 (37.7912743348887, -122.42580297572) 13 9 1 28858 27
24284 64059 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2300 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2009 12:00:00 AM 8 3x3 Permit Number 53049 6002577.31781 2117478.271 37.7943368358245 -122.435063417162 (37.7943368358245, -122.435063417162) 13 9 1 29490 27
24433 127189 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3245 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5999214.09377 2115959.49818 37.789975142788 -122.44659119695 (37.789975142788, -122.44659119695) 13 6 1 29490 31
24436 55846 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2203 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1973 12:00:00 AM 21   Permit Number 11895 6001329.93654 2116033.76295 37.7902996847396 -122.43927590546 (37.7902996847396, -122.43927590546) 13 6 1 29490 27
24523 115410 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2025 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   5999874.89435 2115932.55527 37.7899388875113 -122.444302954718 (37.7899388875113, -122.444302954718) 13 6 1 29490 27
24578 66818 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2632 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1991 12:00:00 AM 12   Permit Number 30108 6002664.62031 2117284.94681 37.7938109743374 -122.434747509611 (37.7938109743374, -122.434747509611) 13 9 1 29490 27
24713 123014 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 70 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5993974.37833 2115085.79297 37.7872755003719 -122.464656546249 (37.7872755003719, -122.464656546249) 11 6 1 54 11
24821 51922 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Walnut St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2005 12:00:00 AM 9   Permit Number 48124 5998457.45389 2116096.16414 37.790307142815 -122.449218944009 (37.790307142815, -122.449218944009) 13 6 1 54 31
25038 126734 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2228 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6002331.10395 2118490.2524 37.7971014902863 -122.435987791624 (37.7971014902863, -122.435987791624) 13 9 1 57 17
25050 110970 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2485 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6002790.71835 2116462.02658 37.7915586051887 -122.434252340185 (37.7915586051887, -122.434252340185) 13 9 1 29490 27
25197 126799 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3630 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000707.25025 2120861.95262 37.8035211658411 -122.441777010916 (37.8035211658411, -122.441777010916) 13 9 1 57 17
25297 103154 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3200 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 5x6   6002394.82985 2119211.46643 37.7990853758604 -122.435818913307 (37.7990853758604, -122.435818913307) 13 9 1 57 17
25478 127122 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 80 Perine Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001998.40789 2115556.42644 37.7890270585863 -122.436928859288 (37.7890270585863, -122.436928859288) 13 6 1 29490 27
25546 126990 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3298 Lyon St 3 Sidewalk: Property side : Yard Tree Private 2     10     5998994.74544 2120127.11864 37.8014057850056 -122.447650256552 (37.8014057850056, -122.447650256552) 13 9 1 57 17
25874 31211 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2740 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1995 12:00:00 AM 15   Permit Number 34903 6001607.27323 2117888.69637 37.795408628064 -122.438449297224 (37.795408628064, -122.438449297224) 13 9 1 57 27
25887 127050 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 669 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5999809.39493 2121550.341 37.8053600950608 -122.444933583643 (37.8053600950608, -122.444933583643) 13 9 1 57 17
26103 127849 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2637 Larkin St 2 Sidewalk: Curb side : Pot Tree Private 2     11 Width 4ft   6006571.66028 2120272.67725 37.8022355669843 -122.421441048889 (37.8022355669843, -122.421441048889) 5 9 1 28858 32
26223 126763 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200 Moulton St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002301.79204 2119339.47254 37.7994315617776 -122.436150020305 (37.7994315617776, -122.436150020305) 13 9 1 57 17
26256 126677 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2853 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6000020.62124 2118391.3045 37.7966982783501 -122.44397548997 (37.7966982783501, -122.44397548997) 13 9 1 57 17
26298 126733 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2237 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002259.4459 2118428.90563 37.7969289769584 -122.436231353201 (37.7969289769584, -122.436231353201) 13 9 1 57 17
26373 18941 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2782 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3 Replace with P. Undulatum 6001522.42549 2115673.82967 37.7893223527794 -122.438584108286 (37.7893223527794, -122.438584108286) 13 6 1 29490 27
26422 101416 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2800X Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     18   Permit Number 11899 6001215.87512 2116284.81447 37.7909825156781 -122.439688554896 (37.7909825156781, -122.439688554896) 13 6 1 29490 27
26588 127872 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1089 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006645.59841 2120434.4244 37.8026838520455 -122.421196678795 (37.8026838520455, -122.421196678795) 5 1 1 28858 32
26844 126868 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5998432.48421 2116293.23201 37.7908468106678 -122.449319541261 (37.7908468106678, -122.449319541261) 13 6 1 54 31
27082 126823 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 250 Capra Way 2 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   6000777.77536 2120517.25541 37.8025787374811 -122.441508206236 (37.8025787374811, -122.441508206236) 13 9 1 57 17
27314 127424 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1973 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6005339.16647 2116478.47444 37.7917480824639 -122.425435905736 (37.7917480824639, -122.425435905736) 13 9 1 28858 27
27500 127171 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1906 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   5999981.84158 2115541.4331 37.7888710693804 -122.443904814949 (37.7888710693804, -122.443904814949) 13 6 1 29490 27
27826 127024 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2198 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 6ft   6002458.58256 2119198.03735 37.7990521243208 -122.435597346446 (37.7990521243208, -122.435597346446) 13 9 1 57 17
28089 126925 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3536 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5997913.84251 2115170.44479 37.7877342552736 -122.451033008777 (37.7877342552736, -122.451033008777) 11 6 1 54 31
28144 127841 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2728 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006912.36807 2121678.45588 37.8061146811113 -122.420361869618 (37.8061146811113, -122.420361869618) 5 1 1 28858 32
28280 98532 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1805X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5999984.2458 2115196.51475 37.7879241507313 -122.443871705528 (37.7879241507313, -122.443871705528) 13 6 1 29490 27
28363 58265 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3773 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1979 12:00:00 AM 8   Permit Number 18039 5996781.67477 2115294.23702 37.7880092733608 -122.45495901894 (37.7880092733608, -122.45495901894) 11 6 1 54 31
28405 127400 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2000 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6004568.78165 2117080.20576 37.7933567276962 -122.428144336387 (37.7933567276962, -122.428144336387) 13 9 1 28858 27
28483 7930 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1355 Franklin St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005883.49372 2114761.44957 37.7870642990196 -122.423430414002 (37.7870642990196, -122.423430414002) 13 9 1 28858 41
28487 127055 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 619 Marina Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5999957.78015 2121570.64869 37.8054243219321 -122.444421539327 (37.8054243219321, -122.444421539327) 13 9 1 57 17
28585 68201 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2400 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 19   Permit Number 31983 6001408.58226 2118706.52124 37.7976428569797 -122.439195444927 (37.7976428569797, -122.439195444927) 13 9 1 57 17
28836 34139 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2709 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     14   Permit Number 37988 5999564.62899 2118151.65029 37.7960142297258 -122.445536079034 (37.7960142297258, -122.445536079034) 13 9 1 57 17
28940 61825 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2520 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1985 12:00:00 AM 10   Permit Number 21858 6000785.3618 2118271.60427 37.7964132067589 -122.441320728162 (37.7964132067589, -122.441320728162) 13 9 1 57 17
29098 126698 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2074 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003065.95856 2118590.70746 37.7974190328195 -122.433452198957 (37.7974190328195, -122.433452198957) 13 9 1 57 17
29159 127086 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1400 Jefferson St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   6002483.38051 2121629.71373 37.805730276683 -122.435685603204 (37.805730276683, -122.435685603204) 13 9 1 57 17
29164 126906 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5997004.79116 2116083.10275 37.7901880842626 -122.4542440822 (37.7901880842626, -122.4542440822) 11 6 1 54 31
29169 127425 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1870 Sacramento St 4 Sidewalk: Curb side : Pot Tree Private 2     4 Width 5ft   6005832.46311 2116271.3392 37.7912071995888 -122.423714365048 (37.7912071995888, -122.423714365048) 13 9 1 28858 27
29215 126656 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3230 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002367.15387 2119385.89753 37.7995627458862 -122.435927169217 (37.7995627458862, -122.435927169217) 13 9 1 57 17
29557 126930 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3640 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5997406.37072 2115100.08552 37.7875120013275 -122.45278367493 (37.7875120013275, -122.45278367493) 11 6 1 54 31
29801 127368 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2235 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6004181.36761 2116525.43375 37.7918115377216 -122.429445235415 (37.7918115377216, -122.429445235415) 13 9 1 29490 27
29886 127040 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2170 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6000407.85412 2120302.58369 37.8019682246043 -122.442772891381 (37.8019682246043, -122.442772891381) 13 9 1 57 17
29964 126716 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2350 Green St 11 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   6001651.6937 2118053.91111 37.7958647911841 -122.43830743725 (37.7958647911841, -122.43830743725) 13 9 1 57 17
30067 126920 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3675 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5996684.10777 2115934.72989 37.7897622975396 -122.455342888265 (37.7897622975396, -122.455342888265) 11 6 1 54 31
30078 126980 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2821 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   6004337.66608 2118882.75287 37.7982929823055 -122.429072593227 (37.7982929823055, -122.429072593227) 13 9 1 57 17
30094 126684 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2828 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000611.46538 2118048.07665 37.7957895512039 -122.441906393664 (37.7957895512039, -122.441906393664) 13 9 1 57 17
30095 44062 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2700 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM 14   Permit Number 43588 6001633.0165 2117719.97649 37.7949468315795 -122.438348127963 (37.7949468315795, -122.438348127963) 13 9 1 57 27
30126 126637 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2162 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6002651.43296 2118532.77773 37.7972364461612 -122.43488241871 (37.7972364461612, -122.43488241871) 13 9 1 57 17
30246 58046 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3673 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/1977 12:00:00 AM 11   Permit Number 17015 5997304.19448 2115040.38484 37.7873422237233 -122.453132870908 (37.7873422237233, -122.453132870908) 11 6 1 54 31
30467 127441 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2101 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     15 Width 4ft   6005937.76794 2117668.55868 37.7950495575331 -122.423449386982 (37.7950495575331, -122.423449386982) 13 9 1 28858 27
30596 97093 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
30639 127209 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2332 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5999784.48165 2116934.40464 37.7926845438044 -122.444687813303 (37.7926845438044, -122.444687813303) 13 6 1 29490 27
31079 126845 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 5 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6001699.54492 2121326.58753 37.8048534196989 -122.438376445828 (37.8048534196989, -122.438376445828) 13 9 1 57 17
31203 23527 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2750 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005732.6493 2119830.06962 37.8009729386143 -122.424312938499 (37.8009729386143, -122.424312938499) 13 9 1 28858 32
31411 66674 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3114 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1991 12:00:00 AM 17   Permit Number 29898 5999814.12709 2115762.16278 37.7894675672246 -122.444500952184 (37.7894675672246, -122.444500952184) 13 6 1 29490 27
31501 127147 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2889 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000958.98087 2116200.88741 37.7907374486335 -122.440571374383 (37.7907374486335, -122.440571374383) 13 6 1 29490 27
31566 58047 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3678 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/1977 12:00:00 AM 14   Permit Number 17016 5997283.41422 2115083.31486 37.7874589071499 -122.45320786625 (37.7874589071499, -122.45320786625) 11 6 1 54 31
31611 92880 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2336 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/2009 12:00:00 AM 7 3x3 Permit Number 53094 6000658.22191 2119643.48009 37.8001727713012 -122.441859170283 (37.8001727713012, -122.441859170283) 13 9 1 57 17
31786 124636 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 142 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5995541.73223 2115226.59948 37.7877523507074 -122.459244070891 (37.7877523507074, -122.459244070891) 11 6 1 54 31
31930 57478 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2859 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1976 12:00:00 AM 13   Permit Number 16328 5999193.93442 2118351.69962 37.796542342215 -122.446833151424 (37.796542342215, -122.446833151424) 13 9 1 57 17
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
32218 23535 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2750 Van Ness Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005732.6393 2119914.78395 37.8012055419589 -122.424319001733 (37.8012055419589, -122.424319001733) 13 9 1 28858 32
32264 50981 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 199 REVISED Richardson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2004 12:00:00 AM 15 3x3 Permit Number 47465 5999138.00108 2119690.5383 37.8002152390887 -122.447123092879 (37.8002152390887, -122.447123092879) 13 9 1 57 17
32486 127276 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2753 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6001555.8195 2117928.81157 37.7955158470348 -122.438630211115 (37.7955158470348, -122.438630211115) 13 9 1 57 27
32553 59246 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2242 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/1980 12:00:00 AM 17   Permit Number 18577 6002201.61867 2118815.32481 37.7979866974971 -122.436459120009 (37.7979866974971, -122.436459120009) 13 9 1 57 17
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
32753 126798 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3838 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000129.88568 2121484.99432 37.8051989563256 -122.443819789445 (37.8051989563256, -122.443819789445) 13 9 1 57 17
32842 126712 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1836 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6004190.38443 2118746.81039 37.7979113810643 -122.42957253174 (37.7979113810643, -122.42957253174) 13 9 1 57 17
32873 103145 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2801X Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 4x5   6001540.61955 2118054.83132 37.795860999639 -122.43869183985 (37.795860999639, -122.43869183985) 13 9 1 57 17
33249 126642 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2811 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6004769.45594 2119264.99397 37.7993669508855 -122.427605717143 (37.7993669508855, -122.427605717143) 13 9 1 57 17
33317 127439 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1624 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 4ft   6005574.70794 2118246.4283 37.7966157430646 -122.424746759761 (37.7966157430646, -122.424746759761) 13 9 1 28858 17
33398 127272 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2720 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001618.24325 2117803.86192 37.7951763187933 -122.438405258294 (37.7951763187933, -122.438405258294) 13 9 1 57 27
33432 127925 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2801 Leavenworth St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6007284.4707 2122171.33191 37.8074889540196 -122.419109126608 (37.8074889540196, -122.419109126608) 5 1 1 308 32
33457 126651 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2936 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002038.3527 2118270.166 37.7964805551997 -122.436985016566 (37.7964805551997, -122.436985016566) 13 9 1 57 17
33464 127243 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2519 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6001650.53635 2117256.81935 37.7936761191987 -122.43825431068 (37.7936761191987, -122.43825431068) 13 6 1 29490 27
33618 49323 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 595 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2003 12:00:00 AM 7   Permit Number 46320 6000142.6347 2121597.91663 37.8055097377428 -122.443783787801 (37.8055097377428, -122.443783787801) 13 9 1 57 17

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