trees

39,840 rows where qLegalStatus_id = 7 sorted by PlotSize 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)
128168 98270 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   witin landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
118194 98271 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
119476 98272 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
164216 98273 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
55461 98269 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2700 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscape plot Permit Number 768491 6009963 2103401 37.7561005415225 -122.40851449565 (37.7561005415225, -122.40851449565) 2 4 7 28859 19
29672 49691 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 450 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/21/2003 12:00:00 AM   tx5 Permit Number 46512 5996840.32777146 2110125.42661407 37.7738204478349 -122.454382576109 (37.7738204478349, -122.454382576109) 15 5 2 29492 16
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
78009 229405 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1447 York St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2002 12:00:00 AM 13 Width 6ft Permit Number 45250 6010127.81182 2100843.97719 37.7490887528637 -122.407764223942 (37.7490887528637, -122.407764223942) 2 4 7 28859 19
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
17378 206294 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1291 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/1972 12:00:00 AM 14 Width 5ft Permit Number 10303 5995770.00748 2106810.2745 37.7646564626472 -122.457845020728 (37.7646564626472, -122.457845020728) 15 5 11 56 12
41485 123746 Permitted Site 7 Schinus terebinthifolius :: Brazilian Pepper 93 98 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   5995436.31203 2110822.24381 37.7756531053071 -122.459289731361 (37.7756531053071, -122.459289731361) 11 6 2 54 11
73885 123609 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 121 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/2018 12:00:00 AM 3 Width 5ft Permit Number 782700 5995062.26821 2114886.47744 37.786790890934 -122.460878253711 (37.786790890934, -122.460878253711) 11 6 1 54 11
162107 124114 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 4200 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   5993989.05364 2112856.58401 37.7811555438317 -122.464443855733 (37.7811555438317, -122.464443855733) 11 6 2 54 11
674 231751 Permitted Site 7 Maytenus boaria :: Mayten 58 1015 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1974 12:00:00 AM 10 Width 4ft Permit Number 14253 6001960.39787 2101086.72992 37.7492946868066 -122.436024547794 (37.7492946868066, -122.436024547794) 2 4 5 28862 22
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
1857 219599 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 953 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft Permit Number 782497 6008614.00505 2103032.05792 37.7550118695111 -122.41315370269 (37.7550118695111, -122.41315370269) 2 4 7 28859 19
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
3896 227738 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 1240 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1991 12:00:00 AM 9 Width 4ft Permit Number 30100 5997494.2501 2105433.95534 37.7609763468939 -122.451782059502 (37.7609763468939, -122.451782059502) 15 5 11 29492 12
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
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
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
6645 226161 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 126 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/1993 12:00:00 AM 9 Width 4ft Permit Number 32799 5997997.11826 2106529.02842 37.76401192934 -122.450121798605 (37.76401192934, -122.450121798605) 15 5 11 29492 9
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
10331 128078 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 245 North Point St 11 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:25:00 PM 3 Width 4ft   6009589.18536 2121879.68336 37.8068176775527 -122.411112486276 (37.8068176775527, -122.411112486276) 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
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
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
14510 225860 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1400 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/1979 12:00:00 AM 32 Width 4ft Permit Number 17861 5997829.91039 2105879.41446 37.7622186838636 -122.450653279939 (37.7622186838636, -122.450653279939) 15 5 11 29492 9
14831 195631 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 416 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 9 Width 4ft   6015940.74399 2112714.61706 37.782006663809 -122.388491328916 (37.782006663809, -122.388491328916) 6 2 9 28856 6
15190 210598 Permitted Site 7 Olea europaea :: Olive Tree 9 44 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM 16 Width 4ft Permit Number 9937 5995535.69173 2107072.5304 37.7653630851686 -122.458674438482 (37.7653630851686, -122.458674438482) 15 5 11 56 12
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
17399 168461 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2016 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 4ft   6004605.43639 2115769.81971 37.7897608127558 -122.427924090639 (37.7897608127558, -122.427924090639) 13 9 1 28858 27
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
17860 134277 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1999 Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2002 12:00:00 AM 8 Width 4ft Permit Number 45113 6006028.3836 2117033.66191 37.7933114045495 -122.423090693289 (37.7933114045495, -122.423090693289) 13 9 1 28858 27
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
18590 210743 Permitted Site 7 Olea europaea :: Olive Tree 9 45 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM 14 Width 4ft Permit Number 9938 5995615.49185 2107032.26685 37.7652571180555 -122.458395515563 (37.7652571180555, -122.458395515563) 15 5 11 56 12
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
24734 136867 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800 Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2014 12:00:00 AM 7 Width 4ft Permit Number 773338 6006067.02029 2112827.44756 37.7817643621779 -122.42265796469 (37.7817643621779, -122.42265796469) 7 9 11 28852 41
31559 239448 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 224 Miguel St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/1997 12:00:00 AM 11 Width 4ft Permit Number 38139 6004193.01737 2096717.47365 37.7374242967807 -122.427992792539 (37.7374242967807, -122.427992792539) 2 7 5 63 7
32851 136853 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 628 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782762 6008257.35293 2114172.86388 37.7855818817524 -122.415175683534 (37.7855818817524, -122.415175683534) 13 10 9 28858 36
45520 130013 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 229 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2011 12:00:00 AM 4 Width 4ft Permit Number 16819 6008995.68811 2113349.44791 37.783362444858 -122.41256302167 (37.783362444858, -122.41256302167) 7 10 9 28852 36
52039 250725 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2715 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782755 5987015.16529 2114429.97132 37.7850711441675 -122.488685403333 (37.7850711441675, -122.488685403333) 11 6 1 55 33
56218 229588 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 414 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM 1 Width 4ft Permit Number 775277 5998525.25898 2106782.00545 37.7647367487344 -122.448313341983 (37.7647367487344, -122.448313341983) 15 5 11 29492 9
59733 136068 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 2301 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2007 12:00:00 AM 5 Width 4ft Permit Number 27163 6002757.38982 2116271.99757 37.7910349425641 -122.434354064289 (37.7910349425641, -122.434354064289) 13 9 1 29490 27
62641 130232 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2013 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/2018 12:00:00 AM 3 Width 4ft Permit Number 782588 6007201.62912 2119237.06192 37.7994275274066 -122.419187542977 (37.7994275274066, -122.419187542977) 5 1 1 28858 32
72390 249578 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1075 Ofarrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2012 12:00:00 AM 3 Width 4ft   6006167.29869 2113834.65662 37.7845355682182 -122.422382634549 (37.7845355682182, -122.422382634549) 7 9 11 28858 41
74969 129644 Permitted Site 7 Elaeocarpus decipiens :: Japanese Blueberry Tree 321 724 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2018 12:00:00 AM 3 Width 4ft Permit Number 780816 6007831.26083 2120995.6473 37.804291598853 -122.417133467151 (37.804291598853, -122.417133467151) 5 1 1 308 32
86398 125408 Permitted Site 7 Acer rubrum :: Red Maple 75 830 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM 4 Width 4ft   6006361.84102 2113219.81406 37.7828583334858 -122.42166589828 (37.7828583334858, -122.42166589828) 7 9 11 28858 41
86794 232077 Permitted Site 7 Betula pendula :: European White Birch 253 256 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/2018 12:00:00 AM 3 Width 4ft Permit Number 782664 6006071.88671 2096082.49888 37.7357869155289 -122.421451570943 (37.7357869155289, -122.421451570943) 2 7 7 28859 2
89454 254862 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2715 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 Width 4ft Permit Number 782755 5987015.16529 2114429.97132 37.7850711441675 -122.488685403333 (37.7850711441675, -122.488685403333) 11 6 1 55 33
90520 218792 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1259 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2018 12:00:00 AM 3 Width 4ft Permit Number 781518 5995767.3383 2106956.01161 37.7650564658073 -122.457864799536 (37.7650564658073, -122.457864799536) 15 5 11 56 12
130041 123867 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 800 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/1997 12:00:00 AM 3 Width 4ft   5992987.31992 2114863.7473 37.7866088704155 -122.468055371527 (37.7866088704155, -122.468055371527) 11 6 1 54 11
134766 233988 Permitted Site 7 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 575 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/1969 12:00:00 AM 17 Width 4ft Permit Number 6238 5998611.18796 2105870.92024 37.7622400499559 -122.447950536602 (37.7622400499559, -122.447950536602) 15 5 11 29492 9
151975 123477 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 500 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2014 12:00:00 AM 1 Width 4ft   5995634.46455 2112663.63841 37.7807204773963 -122.458737616895 (37.7807204773963, -122.458737616895) 11 6 2 54 16
153192 229587 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 414 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM 1 Width 4ft Permit Number 775277 5998527.0865 2106764.50401 37.7646887986725 -122.448305760713 (37.7646887986725, -122.448305760713) 15 5 11 29492 9
169766 132828 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2928 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2012 12:00:00 AM 3 Width 4ft Permit Number 769224 6000686.20776 2116213.06011 37.7907553352436 -122.441516026759 (37.7907553352436, -122.441516026759) 13 6 1 29490 27
188328 214548 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW 06/17/2015 12:00:00 AM 1 Width 4ft Permit Number 768500 5993241.50872 2106665.18013 37.7641124834295 -122.46657980664 (37.7641124834295, -122.46657980664) 11 8 11 56 12
665 203589 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 50 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1993 12:00:00 AM 24 Width 3ft Permit Number 32829 5999730.96004 2093799.89189 37.7291598500324 -122.443210675031 (37.7291598500324, -122.443210675031) 9 7 4 63 40
733 218511 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 318 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM 7 Width 3ft Permit Number 43359 5996829.51445 2089654.64111 37.7176120972009 -122.45294206803 (37.7176120972009, -122.45294206803) 9 8 6 28861 24
1265 120363 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 6118 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5988496.49362 2114018.15896 37.7840267560995 -122.483530334528 (37.7840267560995, -122.483530334528) 11 6 2 55 26
1853 214288 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 38 Staples Ave 1 Sidewalk: Property side : Yard Tree Private 2   06/23/2000 12:00:00 AM 13 Width 3ft Permit Number 42619 5999806.95305 2093809.09712 37.7291894584065 -122.442948622496 (37.7291894584065, -122.442948622496) 9 7 4 63 40
2124 209922 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 870 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990546.69569 2099087.99208 37.7431516445476 -122.475347038257 (37.7431516445476, -122.475347038257) 1 8 4 29491 40
3331 250313 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3832 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft Permit Number 772728 5995868.43222 2115867.93469 37.7895320612144 -122.458160192637 (37.7895320612144, -122.458160192637) 11 6 1 54 31
3574 218861 Permitted Site 7 Olea europaea :: Olive Tree 9 44 Hugo St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5995517.64423 2107073.72636 37.7653653316693 -122.458736946766 (37.7653653316693, -122.458736946766) 15 5 11 56 12
3695 217936 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 2035 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   04/26/2004 12:00:00 AM 4 Width 3ft Permit Number 47390 5991589.39044 2101578.98372 37.7500516488693 -122.471923224775 (37.7500516488693, -122.471923224775) 1 8 4 29491 12
5390 244700 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 722 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 08:50:00 AM 3 Width 3ft Permit Number 32809 6002026.57128 2108798.52358 37.7704731625436 -122.43634756898 (37.7704731625436, -122.43634756898) 15 5 11 29492 9
5878 236882 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 150 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2016 12:00:00 AM 5 Width 3ft Permit Number 772898 5999413.41178 2107340.88769 37.7663220358477 -122.445281650937 (37.7663220358477, -122.445281650937) 15 5 5 29492 9
6478 220235 Permitted Site 7 Tree(s) :: 17 16 Montezuma St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2019 12:00:00 AM 3 Width 3ft Permit Number 783270 6007541.83601 2099741.68012 37.7459169869815 -122.4166285023 (37.7459169869815, -122.4166285023) 2 7 7 28859 2
7145 206261 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 57 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM 13 Width 3ft Permit Number 42423 5999614.39843 2093757.95077 37.729038042256 -122.443610625157 (37.729038042256, -122.443610625157) 9 7 4 63 40
7426 218839 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 850 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2010 12:00:00 AM 2 Width 3ft Permit Number 54033 5990579.44919 2099089.86589 37.7431586880264 -122.475233923312 (37.7431586880264, -122.475233923312) 1 8 4 29491 40
7519 210079 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103 821 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2010 12:00:00 AM 4 Width 3ft Permit Number 53470 5990649.2482 2099026.76257 37.7429894679859 -122.474987974033 (37.7429894679859, -122.474987974033) 1 8 4 29491 40
7575 221710 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 90 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1999 12:00:00 AM 4 Width 3ft Permit Number 41442 6005828.31885 2102883.52989 37.7544472652446 -122.422776859587 (37.7544472652446, -122.422776859587) 2 4 5 28859 19
7935 213699 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 62 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM 8 Width 3ft Permit Number 42424 5999655.47058 2093801.73285 37.7291606000606 -122.443471779698 (37.7291606000606, -122.443471779698) 9 7 4 63 40
8108 212799 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 69 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1992 12:00:00 AM 13 Width 3ft Permit Number 31026 5999569.71459 2093758.06013 37.7290357939629 -122.44376510799 (37.7290357939629, -122.44376510799) 9 7 4 63 40
8467 227792 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 234 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/1983 12:00:00 AM 18 Width 3ft Permit Number 20294 6004387.52295 2097025.09932 37.7382799693533 -122.427342203202 (37.7382799693533, -122.427342203202) 2 7 5 63 7
8819 218630 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 823 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2016 12:00:00 AM 1 Width 3ft Permit Number 777479 5990637.31518 2099027.3446 37.7429903745186 -122.475029277203 (37.7429903745186, -122.475029277203) 1 8 4 29491 40
8823 217937 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 2035 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2004 12:00:00 AM 4 Width 3ft Permit Number 47390 5991588.27788 2101560.12813 37.7499998119378 -122.471925697939 (37.7499998119378, -122.471925697939) 1 8 4 29491 12
9274 218494 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 248 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 1 Width 3ft Permit Number 772989 5994534.17979 2089038.5715 37.7157887100619 -122.460831317629 (37.7157887100619, -122.460831317629) 9 8 6 28861 24
9320 221746 Permitted Site 7 Pittosporum spp :: Pittosporum spp 170 200 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1973 12:00:00 AM 25 Width 3ft Permit Number 12382 5997646.78521 2106482.1718 37.7638632192392 -122.451330111502 (37.7638632192392, -122.451330111502) 15 5 11 29492 9
9444 205868 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 312 Lakeview Ave 1 : Tree Private 2   11/04/1969 12:00:00 AM 13 Width 3ft Permit Number 6398 5996845.79725 2089640.92362 37.7175753652817 -122.452884796511 (37.7175753652817, -122.452884796511) 9 8 6 28861 24
9586 191511 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 392 04th St 2 : Tree Private 2   09/27/2001 12:00:00 AM 5 Width 3ft Permit Number 44376 6012652.22642 2112454.21838 37.7811088850041 -122.399849876973 (37.7811088850041, -122.399849876973) 6 2 9 28856 34
10877 205247 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1436 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2002 12:00:00 AM 7 Width 3ft Permit Number 45929 5990862.22967 2105614.49151 37.7610899852431 -122.474732265294 (37.7610899852431, -122.474732265294) 1 8 4 56 12
11605 213995 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 146 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/1993 12:00:00 AM 6 Width 3ft Permit Number 32783 5999776.55649 2094090.41195 37.729960150431 -122.443073900754 (37.729960150431, -122.443073900754) 9 7 4 63 40
11753 211845 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 16 Stillings Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1973 12:00:00 AM 15 Width 3ft Permit Number 11714 6000344.48352 2095713.86547 37.7344501416455 -122.441226949568 (37.7344501416455, -122.441226949568) 9 7 5 63 40
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
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
12141 219848 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 47 Clarendon Ave 1 : Tree Private 2   06/20/2010 12:00:00 AM 4 Width 3ft Permit Number 768045 5998024.44262 2104629.5149 37.7587979065061 -122.449890386836 (37.7587979065061, -122.449890386836) 15 5 4 28862 38
12184 243309 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 780 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2017 10:07:00 AM 0 Width 3ft Permit Number 779025 6007491.90913 2105126.68883 37.7607001866898 -122.417182659168 (37.7607001866898, -122.417182659168) 2 4 7 28859 19
13108 207243 Permitted Site 7 Leptospermum scoparium :: New Zealand Tea Tree 157 324 Lakeview Ave 1 : Tree Private 2   08/19/2015 12:00:00 AM 1 Width 3ft Permit Number 776404 5996808.75565 2089668.45236 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795) 9 8 6 28861 24
13209 209883 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1862 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/1987 12:00:00 AM 11 Width 3ft Permit Number 24352 5993165.67031 2102796.35427 37.7534853189133 -122.46656088218 (37.7534853189133, -122.46656088218) 1 8 4 56 12
13924 209709 Permitted Site 7 Maytenus boaria :: Mayten 58 834 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990597.46719 2099089.22909 37.7431579838636 -122.475171576022 (37.7431579838636, -122.475171576022) 1 8 4 29491 40
14427 204355 Permitted Site 7 Arbutus unedo :: Strawberry Tree 106 1234 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM 11 Width 3ft Permit Number 39341 5995887.80147 2092235.32572 37.7246440338903 -122.456383625117 (37.7246440338903, -122.456383625117) 9 7 4 28861 40

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