trees

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

✎ 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)
42570 224716 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 5 Front Yard : Cutout Tree MTA 3     13 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
68467 224715 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 4 Front Yard : Cutout Tree MTA 3     12 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
141413 224714 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 3 Front Yard : Cutout Tree MTA 3     11 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
154580 224422 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 2 Front Yard : Cutout Tree MTA 3     16 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
913 128077 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009569.08364 2121877.54409 37.8068106763465 -122.411181901328 (37.8068106763465, -122.411181901328) 3 1 10 308 23
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
1402 128081 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009658.72737 2121889.09987 37.8068474325394 -122.410872486877 (37.8068474325394, -122.410872486877) 3 1 10 308 23
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
3413 128074 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2019 12:00:00 AM 3 Width 4ft   6009478.77374 2121864.7268 37.8067704181858 -122.411493531709 (37.8067704181858, -122.411493531709) 3 1 10 308 23
4189 192124 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     25 Width 4ft   6011038.85416 2113311.43716 37.783372530757 -122.405491758548 (37.783372530757, -122.405491758548) 12 2 9 28853 34
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
6026 128070 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6009396.36006 2121851.96105 37.8067307436876 -122.41177783889 (37.8067307436876, -122.41177783889) 3 1 10 308 23
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
6261 128069 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6009374.1078 2121849.01591 37.8067214087259 -122.411854639205 (37.8067214087259, -122.411854639205) 3 1 10 308 23
8181 192121 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     27 Width 4ft   6010922.27002 2113199.63335 37.783059024392 -122.405887217429 (37.783059024392, -122.405887217429) 12 2 9 28853 34
8631 128082 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009683.35171 2121893.27188 37.8068602685411 -122.41078756392 (37.8068602685411, -122.41078756392) 3 1 10 308 23
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
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
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
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
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
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
15447 128076 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 7 Width 4ft   6009546.7837 2121872.26218 37.8067949229139 -122.411258701628 (37.8067949229139, -122.411258701628) 3 1 10 308 23
15602 192120 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     17 Width 4ft   6010853.09093 2113135.89795 37.7828801528353 -122.406122058309 (37.7828801528353, -122.406122058309) 12 2 9 28853 34
16148 255011 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 17 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6009525.60238 2121869.50761 37.806786171612 -122.411331809333 (37.806786171612, -122.411331809333) 3 1 10 308 23
16938 128083 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009715.0017 2121896.66309 37.8068713545053 -122.410678271985 (37.8068713545053, -122.410678271985) 3 1 10 308 23
17607 128073 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009455.6728 2121862.0115 37.8067616668876 -122.411573285385 (37.8067616668876, -122.411573285385) 3 1 10 308 23
18083 128072 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009436.58528 2121857.30143 37.806747663529 -122.411639008733 (37.806747663529, -122.411639008733) 3 1 10 308 23
18678 128079 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 13 Width 4ft   6009619.79049 2121884.15798 37.8068316799992 -122.411006886985 (37.8068316799992, -122.411006886985) 3 1 10 308 23
20857 57294 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3030 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM     Permit Number 16115 6006612.86147234 2106740.75991177 37.7650825555261 -122.420337459951 (37.7650825555261, -122.420337459951) 8 4 7 28853 19
22256 104835 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4595-4599 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000476 2105174 37.7604328955242 -122.441450863046 (37.7604328955242, -122.441450863046) 2 4 5 28862 3
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
30684 97622 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
30934 56353 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 157 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1973 12:00:00 AM   5x5 Permit Number 12495 6002706.41661255 2104989.75216117 37.7600538090993 -122.433723721804 (37.7600538090993, -122.433723721804) 2 4 5 28862 3
34276 104696 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 953 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770164 6008633.4 2103067 37.7551089013639 -122.413089099766 (37.7551089013639, -122.413089099766) 2 4 7 28859 19
34282 102882 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2886-2888 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 21288 6007521 2106777 37.765233194266 -122.41719899188 (37.765233194266, -122.41719899188) 8 4 7 28853 19
43869 67061 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3751 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1992 12:00:00 AM     Permit Number 30442 6004747.16045801 2102483.32750571 37.7532873427532 -122.426487293458 (37.7532873427532, -122.426487293458) 2 4 5 28862 22
46325 49965 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1809 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2004 12:00:00 AM 7   Permit Number 47574 5999971.57227 2115235.0808 37.7880293201371 -122.443918325478 (37.7880293201371, -122.443918325478) 13 6 1 29490 27
47418 97098 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1096 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008668 2115966 37.7905284677514 -122.413881848265 (37.7905284677514, -122.413881848265) 5 1 10 28857 21
50784 59024 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3126 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/1980 12:00:00 AM 18 3x3 Permit Number 18315 6008124.06152001 2102722.66772469 37.7541348368957 -122.414826177271 (37.7541348368957, -122.414826177271) 2 4 7 28859 19
55676 59495 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3131 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/02/1981 12:00:00 AM     Permit Number 18870 6005949.30607357 2106651.86371307 37.7648010537929 -122.422626220724 (37.7648010537929, -122.422626220724) 8 4 5 28859 19
58192 58074 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4600 18th St 1 Sidewalk: Property side : Cutout Tree Private 2   10/28/1977 12:00:00 AM 17 3x3 Permit Number 771745 6000620.25163536 2105231.11273523 37.7605979299832 -122.440956061888 (37.7605979299832, -122.440956061888) 15 4 5 28862 3
60374 59971 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 953 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1982 12:00:00 AM     Permit Number 770164 6008622.11827174 2103000.09497074 37.7549245619495 -122.413123384766 (37.7549245619495, -122.413123384766) 2 4 7 28859 19
64926 104439 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200X Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004765.42963 2102220.02594 37.7525654108037 -122.426405368946 (37.7525654108037, -122.426405368946) 2 4 5 28862 22
69701 97616 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333 Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
72111 225474 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2226 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 22 Width 3ft Permit Number 11757 6002690.53654 2107114.77272 37.765887699278 -122.433930540269 (37.765887699278, -122.433930540269) 15 5 5 28862 3
81966 60170 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3530 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1982 12:00:00 AM     Permit Number 19739 6006073.64013371 2104949.4412081 37.7601336156662 -122.4220752293 (37.7601336156662, -122.4220752293) 2 4 5 28859 19
82579 97624 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
88337 97091 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
89410 55438 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2179 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/1972 12:00:00 AM   3x3 Permit Number 11386 6003157.5538321 2107090.38264344 37.7658472217414 -122.432313483733 (37.7658472217414, -122.432313483733) 15 5 5 28862 3
93208 107826 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2861 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2     20     6002939.21041 2118441.54148 37.797002269889 -122.433880112598 (37.797002269889, -122.433880112598) 13 9 1 57 17
99723 57859 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 243 Banks St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1977 12:00:00 AM     Permit Number 16802 6008653.70601919 2097500.21669417 37.7398248927239 -122.412625369635 (37.7398248927239, -122.412625369635) 10 7 7 28859 2
103401 97621 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
106974 97623 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
109995 104442 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200X Chattanooga St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004765.42963 2102220.02594 37.7525654108037 -122.426405368946 (37.7525654108037, -122.426405368946) 2 4 5 28862 22
112221 97102 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1096@Jones Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008668 2115966 37.7905284677514 -122.413881848265 (37.7905284677514, -122.413881848265) 5 1 10 28857 21
113033 97662 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1909 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2011 12:00:00 AM   5x6 Permit Number 768299 5999946 2115458 37.7886399393615 -122.444022824205 (37.7886399393615, -122.444022824205) 13 6 1 29490 27
117254 58316 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1501-1519X 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1978 12:00:00 AM     Permit Number 17339 6007402 2107334 37.7667558904507 -122.417650067636 (37.7667558904507, -122.417650067636) 8 4 7 28853 19
118744 104695 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 953 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770164 6008633.4 2103067 37.7551089013639 -122.413089099766 (37.7551089013639, -122.413089099766) 2 4 7 28859 19
122877 58282 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1512 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/1978 12:00:00 AM 14 4x4 Permit Number 17295 6007307 2107372 37.7668548833005 -122.417981351596 (37.7668548833005, -122.417981351596) 8 4 7 28853 19
123495 101891 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 196X Wool St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 21188 6007299.5 2097331.3 37.7392849882208 -122.417295688779 (37.7392849882208, -122.417295688779) 2 7 7 28859 2
130617 96930 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 649 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2011 12:00:00 AM   3x3 Permit Number 768122 6009413.8 2111202 37.7774895185086 -122.410964788592 (37.7774895185086, -122.410964788592) 8 2 9 28853 34
132627 113238 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3030 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6006612.86147234 2106740.75991177 37.7650825555261 -122.420337459951 (37.7650825555261, -122.420337459951) 8 4 7 28853 19
133176 97092 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
138501 225477 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 27 Width 3ft Permit Number 11752 6003189 2107166 37.7660566316339 -122.432210118878 (37.7660566316339, -122.432210118878) 15 5 5 28862 3
141104 55731 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2226 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM   6x6 Permit Number 11757 6002704.74665442 2107117.26012075 37.7658953354732 -122.433881568302 (37.7658953354732, -122.433881568302) 15 5 5 28862 3
146774 97094 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
150094 57302 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3200 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM 22 8x8 Permit Number 16124 6005516.93996159 2106679.95459701 37.7648537822647 -122.424123662752 (37.7648537822647, -122.424123662752) 8 4 5 28853 19
158578 51678 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 672 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2005 12:00:00 AM     Permit Number 770377 6007616.9101817 2096263.07678619 37.7363697350759 -122.416122590192 (37.7363697350759, -122.416122590192) 2 7 7 28859 2
161929 104441 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200X Chattanooga St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004765.42963 2102220.02594 37.7525654108037 -122.426405368946 (37.7525654108037, -122.426405368946) 2 4 5 28862 22
162918 58851 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 615 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/1979 12:00:00 AM   3x3 Permit Number 18110 6008337.3940243 2114564.58255444 37.7866619441951 -122.414926498345 (37.7866619441951, -122.414926498345) 13 1 9 28858 36
164757 104463 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3260X 16TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     16 8x8   6005124 2106632 37.764699916645 -122.425479329399 (37.764699916645, -122.425479329399) 8 4 5 28859 19
165142 97620 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
179993 57439 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4401 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1976 12:00:00 AM     Permit Number 16282 6001390.76806136 2105222.86680343 37.7606191434319 -122.438290610369 (37.7606191434319, -122.438290610369) 2 4 5 28862 3
154508 109210 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2637 Larkin St 1 Front Yard : Yard Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774817 6006569.78732 2120282.61277 37.8022627417937 -122.421448236261 (37.8022627417937, -122.421448236261) 5 9 1 28858 32
158154 258096 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 941 Mission St 4 Sidewalk: Property side : Yard Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6010493.2294 2112796.27211 37.7819274857178 -122.407343084927 (37.7819274857178, -122.407343084927) 14 2 9 28853 34
166311 127110 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201 Laguna St 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812) 13 9 1 57 17
185953 126695 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2829 Divisadero St 2 Front Yard : Yard Tree Private 2     11 10x10 Permit Number 779774 6000551.43021 2118023.61416 37.7957189625051 -122.442112369006 (37.7957189625051, -122.442112369006) 13 9 1 57 17
4474 109514 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1501x FULTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000537 2110949 37.7762930788063 -122.441654341711 (37.7762930788063, -122.441654341711) 15 5 11 29492 16
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
9788 128384 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 109 Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6010084.71998 2117858.53397 37.7958043693257 -122.40911365939 (37.7958043693257, -122.40911365939) 3 1 10 308 4
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                    
16477 224849 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4 Rotteck St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 779889 6003244.13534 2095137.54828 37.7330324530887 -122.431160782146 (37.7330324530887, -122.431160782146) 9 7 5 28861 25
20101 102885 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2940 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007175 2106758 37.7651615533416 -122.418394378814 (37.7651615533416, -122.418394378814) 8 4 7 28853 19
21248 98029 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 493 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003709.9 2105435.7 37.7613351647369 -122.430284971477 (37.7613351647369, -122.430284971477) 8 4 5 28862 3
21597 224729 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 21 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6005253.61364 2105295.59302 37.7610377822877 -122.424935941151 (37.7610377822877, -122.424935941151) 2 4 5 28859 19
21823 98030 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 493 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003709.9 2105435.7 37.7613351647369 -122.430284971477 (37.7613351647369, -122.430284971477) 8 4 5 28862 3
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
25344 103031 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769938 6014508.3 2114897.4 37.787920602156 -122.393599785715 (37.787920602156, -122.393599785715) 6 2 9 28855 6
25988 102335 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
28246 105037 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 60 Hiliritas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770444 6001403.1 2096820.4 37.7375486740807 -122.437646191192 (37.7375486740807, -122.437646191192) 2 7 5 63 7
29549 102344 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 10 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
30758 102329 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201X 18th St 10 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
35668 100851 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1043-1049 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003181 2102169 37.7523356131155 -122.431880952183 (37.7523356131155, -122.431880952183) 2 4 5 28862 22
42508 103032 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300X Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769938 6014508.3 2114897.4 37.787920602156 -122.393599785715 (37.787920602156, -122.393599785715) 6 2 9 28855 6
44459 104392 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 590 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6008924 2105519 37.7618578454917 -122.412257411031 (37.7618578454917, -122.412257411031) 8 4 7 28859 19
46295 104566 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 268 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6004756 2102109 37.7522600263907 -122.426430073656 (37.7522600263907, -122.426430073656) 2 4 5 28862 22
49039 128383 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 109 Trenton St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6010080.15671 2117907.34216 37.7959381290836 -122.409132894969 (37.7959381290836, -122.409132894969) 3 1 10 308 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)
);