trees

163,064 rows where qCaretaker_id = 2 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)
2598 95032 - 12 Tree(s) :: 17 211 Maynard St   Front Yard : Cutout Landscaping Private 2           6004772 2093802 37.7294517978782 -122.425783519869 (37.7294517978782, -122.425783519869) 9 7 6 28861 5
4559 109532 - 12 Sequoia sempervirens :: Coast Redwood 155 818 Goettingen St 1 Back Yard : Yard Tree Private 2           6010847.3 2090865.3 37.7217296747854 -122.404573864697 (37.7217296747854, -122.404573864697) 10 3 7 309 28
16209 262261 - 12 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 290 Green St   : Tree Private 2 FUF 06/18/2020 12:00:00 AM 3   Permit Number 785454 6011550.34746 2119418.71162 37.8001702361868 -122.404152146942 (37.8001702361868, -122.404152146942) 3 1 10 308 23
27555 173771 - 12 Tree(s) :: 17 231 Stratford Dr 1 Sidewalk: Property side : Yard Tree Private 2   02/13/2017 12:00:00 AM 3 3x3 Permit Number 779366 5990884.97189 2090977.23451 37.7209011553391 -122.473585870316 (37.7209011553391, -122.473585870316) 9 8 4 64 40
37579 110020 - 12 Myoporum laetum :: Myoporum 62 1490X Douglass St 1 Sidewalk: Property side : Yard Tree Private 2       9x9   6001386.81709 2099547.0285 37.7450344302078 -122.437897729467 (37.7450344302078, -122.437897729467) 2 7 5 63 22
39770 122604 - 12 Prunus serrulata :: Ornamental Cherry 84 132 Surrey St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2016 12:00:00 AM 3 3x3 Permit Number 779127 6002205.30607 2096205.31937 37.7359053840536 -122.434828615692 (37.7359053840536, -122.434828615692) 2 7 5 63 7
50373 95369 - 12 Tree(s) :: 17 27 Hartford St   Front Yard : Cutout Landscaping Private 2   02/18/2011 12:00:00 AM       6002651 2105744 37.7621216467866 -122.433969295968 (37.7621216467866, -122.433969295968) 15 4 5 28862 3
54547 105345 - 12 Acacia melanoxylon :: Blackwood Acacia 70 466 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934) 1 8 4 64 14
57641 87858 - 12 Koelreuteria paniculata :: Golden Rain Tree 131     Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000340.49747 2104887.90927 37.7596396402708 -122.441898968169 (37.7596396402708, -122.441898968169) 2 4 5 28862 3
66547 105124 - 12 Maytenus boaria :: Mayten 58 134 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   5987764.1 2115070.3 37.7868729795597 -122.486141380245 (37.7868729795597, -122.486141380245) 11 6 1 55 33
88442 32776 - 12 Tree(s) :: 17 552 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/20/2010 12:00:00 AM     Permit Number 54024 6001158.24288979 2110568.68225327 37.7752841981665 -122.43947802668 (37.7752841981665, -122.43947802668) 15 5 11 29492 10
132048 105442 - 12 Tree(s) :: 17 38 Museum Way 1 Sidewalk: Curb side : Cutout Tree Private 2           6000691.7 2106753.8 37.764782922965 -122.440818185531 (37.764782922965, -122.440818185531) 15 5 5 28862 3
153890 173885 - 12 Tree(s) :: 17 410 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/03/2017 12:00:00 AM 3 3x3 Permit Number 774920 5998687.3529 2094401.81487 37.7307530256695 -122.446861792344 (37.7307530256695, -122.446861792344) 9 7 4 59 40
161403 85018 - 12 Prunus cerasifera :: Cherry Plum 7 455 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2007 12:00:00 AM     Permit Number 49374 6002971 2099180 37.744116613623 -122.432393702977 (37.744116613623, -122.432393702977) 2 7 5 63 22
175182 122603 - 12 Prunus serrulata :: Ornamental Cherry 84 132 Surrey St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779127 6002205.30607 2096205.31937 37.7359053840536 -122.434828615692 (37.7359053840536, -122.434828615692) 2 7 5 63 7
1493 264741 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 2040 Sutter St 2 Back Yard : Yard Tree Private 2           6002832.74822 2114456.05498 37.7860531044459 -122.433963466929 (37.7860531044459, -122.433963466929) 13 9 11 29490 27
4150 111749 Landmark tree 11 Quercus agrifolia :: Coast Live Oak 172 4124 23rd St 1 Back Yard : Yard Tree Private 2           6002319.4 2102413.2 37.752957247271 -122.434877962118 (37.752957247271, -122.434877962118) 2 4 5 28862 22
4378 264740 Landmark tree 11 Araucaria heterophylla :: Norfolk Island Pine 238 2040 Sutter St 1 Back Yard : Yard Tree Private 2       3x3   6002718 2114518 37.7862166771353 -122.434364894821 (37.7862166771353, -122.434364894821) 13 9 11 29490 27
10284 262216 Landmark tree 11 Quercus agrifolia :: Coast Live Oak 172 4124 23rd St 1 Back Yard : Yard Tree Private 2       3x3   6002319 2102413 37.7529566754079 -122.43487933109 (37.7529566754079, -122.43487933109) 2 4 5 28862 22
14339 151836 Landmark tree 11 Quercus agrifolia :: Coast Live Oak 172 20 Rosemont Pl 2 Back Yard : Yard Tree Private 2     0 Width 3ft   6005099.05709 2108071.10762 37.7686499525699 -122.425668035147 (37.7686499525699, -122.425668035147) 8 4 5 28853 19
15348 264739 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 2040 Sutter St 1 Back Yard : Yard Tree Private 2           6002832.74822 2114456.05498 37.7860531044459 -122.433963466929 (37.7860531044459, -122.433963466929) 13 9 11 29490 27
16246 262100 Landmark tree 11 Sequoiadendron giganteum :: Sierra Redwood 240 3066 Market St 1 Back Yard : Yard Tree Private 2           6000145.77567 2105436.95685 37.7611360918542 -122.442611833669 (37.7611360918542, -122.442611833669) 15 5 5 28862 3
16836 255909 Landmark tree 11 Aesculus californica :: California Buckeye 168 2694 McAllister St 1 Front Yard : Yard Tree Private 2         Under Review 5996297 2110789 37.7756112723889 -122.456310013186 (37.7756112723889, -122.456310013186) 11 6 2 54 16
17641 262215 Landmark tree 11 Cupressus macrocarpa :: Monterey Cypress 41 2626 Vallejo St 1 Back Yard : Yard Tree Private 2       3x3   6001000 2117623 37.7946445343139 -122.440531492639 (37.7946445343139, -122.440531492639) 13 9 1 57 27
18463 262218 Landmark tree 11 Sequoia sempervirens :: Coast Redwood 155 46 Stillings Ave 1 Back Yard : Yard Tree Private 2       3x3   6000246 2095728 37.7344833413152 -122.441568452522 (37.7344833413152, -122.441568452522) 9 7 5 63 40
27160 111763 Landmark tree 11 Cupressus macrocarpa :: Monterey Cypress 41 2626 Vallejo St 1 Back Yard : Yard Tree Private 2           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268) 13 9 1 57 27
28932 105444 Landmark tree 11 Quercus agrifolia :: Coast Live Oak 172 20-28 ROSEMONT PL 1 Back Yard : Yard Tree Private 2           6005075.5 2108088.5 37.7686963767089 -122.425750755404 (37.7686963767089, -122.425750755404) 8 4 5 28853 19
40100 251597 Landmark tree 11 Ficus macrophylla :: Morton Bay Fig 322 1650 Valencia St 1 Side Yard : Yard Tree Private 2           6006336 2100501 37.7479340151765 -122.420852023863 (37.7479340151765, -122.420852023863) 2 7 7 28859 2
49220 7946 Landmark tree 11 Melaleuca ericifolia :: Heath Melaleuca 151 1701 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005703.15328 2116043.32965 37.7905738421571 -122.424145551273 (37.7905738421571, -122.424145551273) 13 9 1 28858 27
51932 253858 Landmark tree 11 Arctostaphylos manzanita 'Dr Hurd' :: Dr. Hurd Manzanita 417 115 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996817 2113681 37.7835817804999 -122.454720202744 (37.7835817804999, -122.454720202744) 11 6 1 54 31
64831 111748 Landmark tree 11 Aesculus californica :: California Buckeye 168 730 28th Ave 1 Back Yard : Yard Tree Private 2           5987294.2 2110946.4 37.7755225253955 -122.487464059213 (37.7755225253955, -122.487464059213) 11 6 2 55 26
92644 113742 Landmark tree 11 Ficus macrophylla :: Morton Bay Fig 322 1580 Valencia St 2 Front Yard : Yard Tree Private 2     80     6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
126945 255504 Landmark tree 11 Aesculus californica :: California Buckeye 168 757 Pennsylvania Ave 7 Back Yard : Yard Tree Private 2 FUF         6014476.10973 2103508.37921 37.7566470977886 -122.392914033755 (37.7566470977886, -122.392914033755) 10 3 8 28856 29
144603 231331 Landmark tree 11 Metrosideros excelsa :: New Zealand Xmas Tree 16 1221 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1988 12:00:00 AM 25 Width 4ft Permit Number 25220 5997416.53254 2105659.95446 37.7615924319549 -122.452067155375 (37.7615924319549, -122.452067155375) 15 5 11 29492 12
146489 111205 Landmark tree 11 Araucaria heterophylla :: Norfolk Island Pine 238 46 COOK ST   Back Yard : Yard Tree Private 2     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514 2113392 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469) 15 6 1 54 31
167750 64380 Landmark tree 11 Metrosideros excelsa 'Aurea' :: 471 1221 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1988 12:00:00 AM     Permit Number 25220 5997415.00742592 2105661.0761541 37.7615954244829 -122.452072511028 (37.7615954244829, -122.452072511028) 15 5 11 29492 12
172915 248932 Landmark tree 11 Araucaria heterophylla :: Norfolk Island Pine 238 46 Cook St 1 Front Yard : Yard Tree Private 2         Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514 2113392 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469) 15 6 1 54 31
963 109935 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
4156 221064 Section 143 10 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006466.14931 2110109.21502 37.7743232636311 -122.421084097148 (37.7743232636311, -122.421084097148) 7 9 11 28852 10
6326 117138 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
6989 109119 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
12295 108536 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1036X Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009831.24398 2112235.16984 37.7803497589148 -122.409593644194 (37.7803497589148, -122.409593644194) 14 2 9 28853 34
13217 109951 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 11 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
15934 113606 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
20128 103466 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
20563 109121 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
21125 109116 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
22900 103469 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 799X Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012272.7 2118721.6 37.7982964705447 -122.401603488036 (37.7982964705447, -122.401603488036) 3 1 10 28860 6
23173 109936 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
23235 109950 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 10 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
23848 114246 Section 143 10 Magnolia grandiflora :: Southern Magnolia 19 54 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996571 2114184 37.7849487713586 -122.455607632252 (37.7849487713586, -122.455607632252) 11 6 1 54 31
25414 109115 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
26043 100060 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
33280 110797 Section 143 10 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 440 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.7436064433062 -122.429866615733 (37.7436064433062, -122.429866615733) 2 7 5 63 22
34396 116471 Section 143 10 Olea europaea 'Fruitless' :: Fruitless Olive 177 882 Carolina St   Sidewalk: Curb side : Cutout Tree Private 2   04/04/2016 12:00:00 AM 3 3x3   6012399.9 2103853.8 37.757480004392 -122.400118621436 (37.757480004392, -122.400118621436) 10 3 8 28856 29
37646 110789 Section 143 10 Pinus radiata :: Monterey Pine 15 850x SANCHEZ ST 3 Front Yard : Cutout Tree Private 2       3x3   6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
38343 85458 Section 143 10 Tree(s) :: 17 265 Guerrero St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
38713 113610 Section 143 10 Olea europaea :: Olive Tree 9 595 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
41083 101926 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
41644 109948 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 8 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
41654 112585 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 6 Sidewalk: Property side : Cutout Tree Private 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
42158 43568 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 601 29TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2000 12:00:00 AM     Permit Number 43230 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
42613 85457 Section 143 10 Tree(s) :: 17 265 Guerrero St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
43048 98285 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
43092 85452 Section 143 10 Tree(s) :: 17 275 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138 2107427 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748) 8 4 7 28853 19
43321 108260 Section 143 10 Liquidambar styraciflua :: American Sweet Gum 37 45 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.54469 37.7686143220373 -122.430103370918 (37.7686143220373, -122.430103370918) 7 9 5 28862 3
43905 103465 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
46414 112583 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 1 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
51111 112619 Section 143 10 Cassia leptophylla :: Gold Medallion Tree 152 3534 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2015 12:00:00 AM   3x3   6005980 2102026.6 37.7521028905256 -122.42219142885 (37.7521028905256, -122.42219142885) 2 4 5 28859 19
52587 107964 Section 143 10 Platanus x hispanica :: Sycamore: London Plane 27 2401x SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
52698 118340 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
53747 113998 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 1110 SOUTH VAN NESS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2015 12:00:00 AM 3 3x3   6007591 2103152 37.7552837189859 -122.416700052453 (37.7552837189859, -122.416700052453) 2 4 7 28859 19
54018 98287 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 3 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54581 98286 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54759 102523 Section 143 10 Liquidambar styraciflua :: American Sweet Gum 37 2192 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2013 12:00:00 AM   3X3 Permit Number 769544 5992300.8 2100554.8 37.7472806432819 -122.469388612726 (37.7472806432819, -122.469388612726) 1 8 4 29491 40
55082 108822 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
55582 117143 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 8 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
56667 103097 Section 143 10 Fagus sylvatica 'Red Obelisk' :: Red Obelisk Beech 483 1199X Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM   3x3 Permit Number 768649 6008392.3 2117900.9 37.7958257402639 -122.414972764224 (37.7958257402639, -122.414972764224) 5 1 10 308 21
57202 109123 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
59693 113605 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
62944 108821 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3 5x5 Permit Number 774616 6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
65275 113613 Section 143 10 Olea europaea :: Olive Tree 9 595 ALABAMA ST 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
67230 107533 Section 143 10 Tree(s) :: 17 130 MATEO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2015 12:00:00 AM 3 3x3 Permit Number 774373 6003821.3 2096389.2 37.7365018950939 -122.429254591879 (37.7365018950939, -122.429254591879) 2 7 5 63 7
67384 112573 Section 143 10 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 56 ROCKWOOD CT 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
69927 113600 Section 143 10 Olea europaea :: Olive Tree 9 550 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM 1 3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
71895 113602 Section 143 10 Olea europaea :: Olive Tree 9 550 FLORIDA ST 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
73175 85449 Section 143 10 Tree(s) :: 17 287 GUERRERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005798 2107491.2 37.7670971345308 -122.423209217168 (37.7670971345308, -122.423209217168) 8 4 5 28853 19
77706 85451 Section 143 10 Tree(s) :: 17 281 GUERRERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005518.5 2107341.2 37.7666694929162 -122.424165297356 (37.7666694929162, -122.424165297356) 8 4 5 28853 19
79198 112368 Section 143 10 Prunus cerasifera :: Cherry Plum 7 550 Jessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
84488 112892 Section 143 10 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1X WEBSTER ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
86051 109944 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 4 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
86412 109945 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 5 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
89445 113603 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
89702 109120 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
90728 113796 Section 143 10 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 331 TERESITA BLVD 2 Hanging basket : Cutout Tree Private 2       3x3   5997873 2098382 37.7416351035083 -122.449963874894 (37.7416351035083, -122.449963874894) 9 7 4 59 40
90738 117140 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 5 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
92107 109124 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 10 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
93470 109942 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
93555 112370 Section 143 10 Prunus cerasifera :: Cherry Plum 7 550 Jessie St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
94624 110787 Section 143 10 Tree(s) :: 17 850x SANCHEZ ST 1 Front Yard : Cutout Tree Private 2   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22

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