8,298 rows where qLegalStatus_id = 4 sorted by PlantDate descending

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)
59912 108412 Undocumented 4 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 99x HYDE ST 8 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108 2112443 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
82815 108411 Undocumented 4 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 99x HYDE ST 7 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108 2112443 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
115122 108413 Undocumented 4 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 99x HYDE ST 9 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108 2112443 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
135346 108414 Undocumented 4 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 99x HYDE ST 10 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108 2112443 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338) 7 10 9 28852 36
5267 121644 Undocumented 4 Tree(s) :: 17 362 Teresita Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2016 12:00:00 AM 3 2x4 Permit Number 779268 5997955 2098188 37.741107118117 -122.449666371295 (37.741107118117, -122.449666371295) 9 7 4 59 40
180932 121557 Undocumented 4 Myoporum laetum :: Myoporum 62 421 Alvarado St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779269 6003622 2102696 37.7538076209017 -122.430393500907 (37.7538076209017, -122.430393500907) 2 4 5 28862 22
36150 113586 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X AUGUSTA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM   3x3   6011271 2095434 37.7342980459086 -122.403430493306 (37.7342980459086, -122.403430493306) 10 3 8 58 1
121 120916 Undocumented 4 Tree(s) :: 17 1430 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2016 12:00:00 AM 3 3x3 Permit Number 778800 5990886 2105639 37.7611586563939 -122.474651843595 (37.7611586563939, -122.474651843595) 1 8 4 56 12
14571 205488 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1430 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2016 12:00:00 AM 19 Width 3ft Permit Number 778800 5990862.44739 2105654.74875 37.761200533507 -122.474734450646 (37.761200533507, -122.474734450646) 1 8 4 56 12
167071 120917 Undocumented 4 Tree(s) :: 17 1430 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2016 12:00:00 AM 3 3x3 Permit Number 778800 5990886 2105639 37.7611586563939 -122.474651843595 (37.7611586563939, -122.474651843595) 1 8 4 56 12
104186 83711 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 3955 17TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2   12/25/2005 12:00:00 AM 12 3x3   6002562.7 2105843.1 37.7623887399353 -122.434281776631 (37.7623887399353, -122.434281776631) 15 4 5 28862 3
89821 102141 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 53 Wilder St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2012 12:00:00 AM 3 2x3 Permit Number 769415 6002570.6 2095528.3 37.7340671770771 -122.433517283514 (37.7340671770771, -122.433517283514) 2 7 5 63 7
111982 102142 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 53 Wilder St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2012 12:00:00 AM 5 2x3 Permit Number 769415 6002570.6 2095528.3 37.7340671770771 -122.433517283514 (37.7340671770771, -122.433517283514) 2 7 5 63 7
108635 121694 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1225 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2016 12:00:00 AM 3 3x3   6011141 2102636 37.7540659221604 -122.404386709259 (37.7540659221604, -122.404386709259) 10 4 8 28859 19
94071 96101 Undocumented 4 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 2780X 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773748 6009596.8 2105493.6 37.7618258328219 -122.40992865922 (37.7618258328219, -122.40992865922) 8 4 8 28859 19
149055 96108 Undocumented 4 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 2780X 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773748 6009596.8 2105493.6 37.7618258328219 -122.40992865922 (37.7618258328219, -122.40992865922) 8 4 8 28859 19
48616 121497 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 468 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2016 12:00:00 AM 3 3x3   6002891 2099226 37.7442383822567 -122.432673610292 (37.7442383822567, -122.432673610292) 2 7 5 63 22
79504 121496 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 468 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2016 12:00:00 AM 3 3x3   6002891 2099226 37.7442383822567 -122.432673610292 (37.7442383822567, -122.432673610292) 2 7 5 63 22
121773 109952 Undocumented 4 Tree(s) :: 17 214 States St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2015 12:00:00 AM   3x3 Permit Number 777151 6000937 2106455.5 37.7639778318365 -122.43994836829 (37.7639778318365, -122.43994836829) 15 5 5 28862 3
133497 106805 Undocumented 4 Tree(s) :: 17 422 VICENTE ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2014 12:00:00 AM 3   Permit Number 773237 5991611.7 2097778.6 37.7396180631534 -122.471569176587 (37.7396180631534, -122.471569176587) 1 8 4 29491 40
80900 112179 Undocumented 4 Tree(s) :: 17 607 29TH AVE 5 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2015 12:00:00 AM   3x3 Permit Number 777059 5986867 2111783 37.777794668928 -122.489003342792 (37.777794668928, -122.489003342792) 11 6 2 55 26
153175 112178 Undocumented 4 Tree(s) :: 17 607 29TH AVE 4 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2015 12:00:00 AM   3x3 Permit Number 777059 5986867 2111783 37.777794668928 -122.489003342792 (37.777794668928, -122.489003342792) 11 6 2 55 26
21975 107666 Undocumented 4 Quillaja saponaria :: Chilean Soapbark 349 140 STRATFORD DR 1 Front Yard : Yard Tree Private 2   12/17/2014 12:00:00 AM 3   Permit Number 774157 5990881.4 2091504.3 37.7223481397163 -122.473636645054 (37.7223481397163, -122.473636645054) 9 8 4 64 40
169343 109156 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 200 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2015 01:49:00 PM 3 4x4   6005726 2110076 37.7741903117261 -122.423642051276 (37.7741903117261, -122.423642051276) 7 9 11 28852 10
23474 107219 Undocumented 4 Tree(s) :: 17 100 WINSTON DR 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2015 12:00:00 AM 36   Permit Number 776841 5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
19641 121627 Undocumented 4 Tree(s) :: 17 1706 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2016 12:00:00 AM 3 3x3 Permit Number 779124 6009277 2099394 37.7450597695073 -122.410603971932 (37.7450597695073, -122.410603971932) 2 7 7 28859 2
100516 113361 Undocumented 4 Tree(s) :: 17 378 SANCHEZ ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2015 12:00:00 AM 15 3x3 Permit Number 776225 6003537 2106091 37.7631246661428 -122.430929728833 (37.7631246661428, -122.430929728833) 15 4 5 28862 3
82749 101950 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 149 09th St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 11 3x3 Permit Number 769636 6008537 2110562 37.7756830245653 -122.413952655551 (37.7756830245653, -122.413952655551) 8 2 9 28853 34
110810 101949 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 149 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 10 3x3 Permit Number 769636 6008537 2110562 37.7756830245653 -122.413952655551 (37.7756830245653, -122.413952655551) 8 2 9 28853 34
52959 97989 Undocumented 4 Olea europaea :: Olive Tree 9 876 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2011 12:00:00 AM   3x3 Permit Number 768167 6000897 2099683 37.7453799097395 -122.439601171278 (37.7453799097395, -122.439601171278) 2 4 5 63 22
174238 97957 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2270 McKinnon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2011 12:00:00 AM   3x3 Permit Number 768057 6011896.3 2098543.4 37.7428707065024 -122.401487073764 (37.7428707065024, -122.401487073764) 10 3 8 58 1
176903 121587 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1136 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2016 12:00:00 AM 3 3x3   6012170 2103110 37.7554248716487 -122.400861456416 (37.7554248716487, -122.400861456416) 10 3 8 28856 29
174260 75710 Undocumented 4 Geijera parviflora :: Australian Willow 25 1190 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1993 12:00:00 AM 12 18x3   6008645.48606603 2101619.0486747 37.7511338315754 -122.412944932355 (37.7511338315754, -122.412944932355) 2 4 7 28859 19
70739 83691 Undocumented 4 Olea europaea :: Olive Tree 9 201 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/2005 12:00:00 AM 8     6004196.42852 2092337.1873 37.7253972052947 -122.427669003321 (37.7253972052947, -122.427669003321) 9 7 6 28861 5
22885 81254 Undocumented 4 Myoporum laetum :: Myoporum 62 706 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/02/2016 12:00:00 AM 3 3x3   5989768.37779 2110442.38687 37.7742826266156 -122.478868506685 (37.7742826266156, -122.478868506685) 11 6 2 55 26
130832 121549 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 53 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2016 12:00:00 AM 3 3x3   6002689 2105575 37.7616597701015 -122.433825788836 (37.7616597701015, -122.433825788836) 15 4 5 28862 3
143633 121421 Undocumented 4 Tree(s) :: 17 301 Sussex St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/02/2016 12:00:00 AM 3   Permit Number 779128 6001229.40575975 2096509.00524046 37.7366837791531 -122.438224431893 (37.7366837791531, -122.438224431893) 2 7 5 63 7
125436 113094 Undocumented 4 Myoporum laetum :: Myoporum 62 5725 DIAMOND HEIGHTS BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM   3x3 Permit Number 776952 6000738 2097078 37.7382181444182 -122.4399642161 (37.7382181444182, -122.4399642161) 2 7 5 63 7
190527 106859 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 946 RHODE ISLAND ST   Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 14 3x3 Permit Number 773008 6011839.2 2104029.4 37.7579308843014 -122.402070102772 (37.7579308843014, -122.402070102772) 10 3 8 28856 29
44658 108198 Undocumented 4 Myoporum laetum :: Myoporum 62 808 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2014 12:00:00 AM 3 2x2 Permit Number 774168 5999486.009 2095579.26454 37.7340316201973 -122.444185299389 (37.7340316201973, -122.444185299389) 9 7 4 63 40
163373 109096 Undocumented 4 Tree(s) :: 17 194 FARALLONES ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2016 12:00:00 AM 3 3x3 Permit Number 779352 5995118.3 2088431.1 37.71415432875 -122.458768388595 (37.71415432875, -122.458768388595) 9 8 6 28861 24
158970 95223 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 299 on 16th St Dolores St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM 3 3x3 Permit Number 774713 6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
174174 95221 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 299 on 16th St Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 774713 6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
68588 101001 Undocumented 4 Tree(s) :: 17 500X Ogden Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/2012 12:00:00 AM     Permit Number 769389 6008398.5 2096033.1 37.7357821841588 -122.413404038925 (37.7357821841588, -122.413404038925) 10 7 7 28859 2
136720 121400 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 3998X 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2016 12:00:00 AM 3 3x3 Permit Number 779042 6003912 2101337 37.7500925484643 -122.429293713772 (37.7500925484643, -122.429293713772) 2 4 5 28862 22
163662 121401 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 3998X 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2016 12:00:00 AM 3 3x3 Permit Number 779042 6003912 2101337 37.7500925484643 -122.429293713772 (37.7500925484643, -122.429293713772) 2 4 5 28862 22
190196 101232 Undocumented 4 Tree(s) :: 17 3575 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2016 12:00:00 AM 3 3x3 Permit Number 779254 5997770 2115107 37.7875518165957 -122.451526095937 (37.7875518165957, -122.451526095937) 11 6 1 54 31
107208 100135 Undocumented 4 Tree(s) :: 17 155 05th St 1 Front Yard : Yard Tree Private 2   11/27/2012 12:00:00 AM 9   Permit Number 769351 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
32686 114513 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 418 BELVEDERE ST 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   6x7   5998550 2106753 37.7646585215155 -122.448225680862 (37.7646585215155, -122.448225680862) 15 5 11 29492 9
145129 98012 Undocumented 4 Podocarpus gracilor :: Fern Pine 51 4515 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 8 3x3 Permit Number 770790 6001417 2104061 37.7574304316811 -122.43811665528 (37.7574304316811, -122.43811665528) 2 4 5 28862 3
159895 113553 Undocumented 4 Ficus nitida :: Laurel Fig 53 700 TAYLOR ST 3 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   3x3   6009263 2115423 37.7890709188275 -122.411784791395 (37.7890709188275, -122.411784791395) 5 1 10 28857 21
49635 121237 Undocumented 4 Tree(s) :: 17 3512 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2016 12:00:00 AM 3 3x3 Permit Number 779014 6004884 2103735 37.7567318772846 -122.42610317358 (37.7567318772846, -122.42610317358) 2 4 5 28862 3
52148 121580 Undocumented 4 Tree(s) :: 17 3595 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2016 12:00:00 AM 3 5x6 Permit Number 779170 6004440 2103609 37.7563608063483 -122.427629711642 (37.7563608063483, -122.427629711642) 2 4 5 28862 22
168718 121567 Undocumented 4 Tree(s) :: 17 499X Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2016 12:00:00 AM 3 3x3 Permit Number 779059 5998083 2114873 37.7869272334312 -122.450426308155 (37.7869272334312, -122.450426308155) 11 6 1 54 31
4766 121797 Undocumented 4 Myoporum laetum :: Myoporum 62 310 Miguel St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3 Permit Number 779075 6004274 2096577 37.7370431692485 -122.427702791955 (37.7370431692485, -122.427702791955) 2 7 5 63 7
10955 116918 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1390x TENNESSEE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015390 2102613 37.7542392969383 -122.389690908339 (37.7542392969383, -122.389690908339) 10 3 8 28856 29
20151 110833 Undocumented 4 Cupressocyparis leylandii :: Leyland Cypress 185 533 PARNASSUS AVE 6 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3   5995513 2106277 37.7631774598891 -122.458695326495 (37.7631774598891, -122.458695326495) 15 5 4 63 12
22255 121800 Undocumented 4 Myoporum laetum :: Myoporum 62 310 Miguel St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3   6004274 2096577 37.7370431692485 -122.427702791955 (37.7370431692485, -122.427702791955) 2 7 5 63 7
115327 121799 Undocumented 4 Myoporum laetum :: Myoporum 62 310 Miguel St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3 Permit Number 779075 6004274 2096577 37.7370431692485 -122.427702791955 (37.7370431692485, -122.427702791955) 2 7 5 63 7
119280 116920 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1390x TENNESSEE ST 3 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015390 2102613 37.7542392969383 -122.389690908339 (37.7542392969383, -122.389690908339) 10 3 8 28856 29
119381 116919 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1390x TENNESSEE ST 2 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015390 2102613 37.7542392969383 -122.389690908339 (37.7542392969383, -122.389690908339) 10 3 8 28856 29
125215 121798 Undocumented 4 Myoporum laetum :: Myoporum 62 310 Miguel St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3   6004274 2096577 37.7370431692485 -122.427702791955 (37.7370431692485, -122.427702791955) 2 7 5 63 7
147805 116922 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 900x 24TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015390 2102613 37.7542392969383 -122.389690908339 (37.7542392969383, -122.389690908339) 10 3 8 28856 29
154306 116921 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1390x TENNESSEE ST 4 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015390 2102613 37.7542392969383 -122.389690908339 (37.7542392969383, -122.389690908339) 10 3 8 28856 29
115656 121604 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 132 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2016 12:00:00 AM 3 3x3 Permit Number 779127 6002211 2096230 37.7359734746513 -122.434810693949 (37.7359734746513, -122.434810693949) 2 7 5 63 7
159934 68048 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2000 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/2004 12:00:00 AM     Permit Number 31785 5993199.49138674 2101849.51717042 37.7508874994446 -122.466375113285 (37.7508874994446, -122.466375113285) 1 8 4 29491 40
140003 30525 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 96 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2005 12:00:00 AM 10 3x3   6008672.39963745 2112539.12321188 37.7811193385199 -122.413624143987 (37.7811193385199, -122.413624143987) 7 10 9 28852 36
166953 74710 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 838 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   11/19/1988 12:00:00 AM   3x3   6010100.08183161 2118181.67167684 37.7966924872417 -122.409083316519 (37.7966924872417, -122.409083316519) 3 1 10 308 4
175838 74557 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 838 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   11/19/1988 12:00:00 AM   3x3   6010100.08183161 2118181.67167684 37.7966924872417 -122.409083316519 (37.7966924872417, -122.409083316519) 3 1 10 308 4
4589 261026 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 758 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5989802 2110189 37.7735888483109 -122.478733667362 (37.7735888483109, -122.478733667362) 11 6 2 55 26
12651 261028 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 743 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM 3 3x3   5989712 2110287 37.7738527032106 -122.479052157213 (37.7738527032106, -122.479052157213) 11 6 2 55 26
16338 261024 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 751 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5989703 2110237 37.773714894321 -122.479079631213 (37.773714894321, -122.479079631213) 11 6 2 55 26
19473 261023 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 631 32nd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5985931 2111585 37.7771963436428 -122.492226661995 (37.7771963436428, -122.492226661995) 11 6 2 55 26
19544 261022 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 393 30th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5986499 2113341 37.7820510072297 -122.490391009154 (37.7820510072297, -122.490391009154) 11 6 2 55 26
91014 74195 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1035 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1995 12:00:00 AM 9     6007605.80977 2115075.33872 37.7880232200293 -122.417493821895 (37.7880232200293, -122.417493821895) 13 1 10 28858 21
84100 77325 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/18/1988 12:00:00 AM 3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
154876 112809 Undocumented 4 Myoporum laetum :: Myoporum 62 666 47TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM   3x3 Permit Number 776751 5981389 2111175 37.7758040356864 -122.507908173068 (37.7758040356864, -122.507908173068) 11 6 2 55 26
170569 112810 Undocumented 4 Myoporum laetum :: Myoporum 62 666 47TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM   3x3 Permit Number 776751 5981389 2111175 37.7758040356864 -122.507908173068 (37.7758040356864, -122.507908173068) 11 6 2 55 26
189475 105446 Undocumented 4 Tree(s) :: 17 44 MUSEUM WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM 22 4x4 Permit Number 776880 6000683.8 2106710.7 37.7646641311164 -122.440842417505 (37.7646641311164, -122.440842417505) 15 5 5 28862 3
12 264792 Undocumented 4 Olea europaea :: Olive Tree 9 99 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
20 264793 Undocumented 4 Olea europaea :: Olive Tree 9 99 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
186940 97797 Undocumented 4 Tree(s) :: 17 400 Sussex St   Front Yard : Yard Tree Private 2   11/14/2011 12:00:00 AM 17   Permit Number 768175 6000884.7 2096726.7 37.7372619068373 -122.439431826375 (37.7372619068373, -122.439431826375) 2 7 5 63 7
63535 101699 Undocumented 4 Tree(s) :: 17 2700 18th St 3 Sidewalk: Property side : Cutout Tree Private 2   11/13/2012 12:00:00 AM   2x3 Permit Number 769052 6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152) 8 4 8 28859 19
192531 101702 Undocumented 4 Tree(s) :: 17 2700 18th St 6 Sidewalk: Property side : Cutout Tree Private 2   11/13/2012 12:00:00 AM   2x3 Permit Number 769052 6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152) 8 4 8 28859 19
50864 107995 Undocumented 4 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 907 Minnesota St   Sidewalk: Curb side : Cutout Tree Private 2   11/12/2014 12:00:00 AM 3 6x11 Permit Number 774103 6015290.10173 2104424.85479 37.7592087238569 -122.390162955696 (37.7592087238569, -122.390162955696) 10 3 8 28856 29
50333 73636 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 701x 27TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/11/1995 12:00:00 AM   3x3   6001948 2099969 37.7462249605563 -122.435987450823 (37.7462249605563, -122.435987450823) 2 7 5 63 22
164307 71729 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 701x 27TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   11/11/1995 12:00:00 AM       6001948 2099969 37.7462249605563 -122.435987450823 (37.7462249605563, -122.435987450823) 2 7 5 63 22
3790 262255 Undocumented 4 Tree(s) :: 17 4210 Ocean Ave 8 Sidewalk: Property side : Yard Tree Private 2   11/10/2020 12:00:00 AM 3 3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
33375 255389 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 86 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2018 05:25:00 AM 3 5.5x6   5999683 2089300 37.7168014457499 -122.443053440221 (37.7168014457499, -122.443053440221) 9 7 6 28861 25
33401 255388 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 78 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2018 05:25:00 AM 3 5x6   5999719 2089263 37.7167019046917 -122.442926350787 (37.7167019046917, -122.442926350787) 9 7 6 28861 25
115215 255387 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 74 Niagara Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2018 05:25:00 AM 3 5x6   5999738 2089242 37.7166453266888 -122.442859170287 (37.7166453266888, -122.442859170287) 9 7 6 28861 25
172687 255390 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 90 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2018 05:25:00 AM 3 4x7   5999665 2089319 37.7168525891135 -122.443117020954 (37.7168525891135, -122.443117020954) 9 7 6 28861 25
73353 255391 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 53 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2018 05:01:00 AM 3 3x3   5999773 2089094 37.7162409475544 -122.442727572139 (37.7162409475544, -122.442727572139) 9 7 6 28861 25
86548 255392 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 87 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2018 04:56:00 AM 3 3x9   5999611 2089249 37.7166573058325 -122.443298647003 (37.7166573058325, -122.443298647003) 9 7 6 28861 25
57017 255393 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2018 04:52:00 AM 3 3x9   5999596 2089282 37.7167470609644 -122.443352863315 (37.7167470609644, -122.443352863315) 9 7 6 28861 25
19034 114317 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1X 09TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x3 Permit Number 776579 6008059 2111315 37.7777237259209 -122.41565950833 (37.7777237259209, -122.41565950833) 8 2 9 28853 34
80873 99972 Undocumented 4 Tree(s) :: 17 143 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x3 Permit Number 776811 5988622.1 2114374.2 37.7850116539768 -122.483121892919 (37.7850116539768, -122.483121892919) 11 6 2 55 26
92461 113825 Undocumented 4 Arbutus unedo :: Strawberry Tree 106 1599x CASTRO ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/10/2015 12:00:00 AM 8 3x3   6002577 2101074 37.7492947436898 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
170939 113095 Undocumented 4 Tree(s) :: 17 185 MOFFITT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x3 Permit Number 776813 6002386 2097081 37.7383200584746 -122.434266470227 (37.7383200584746, -122.434266470227) 2 7 5 63 7
46946 112740 Undocumented 4 Tree(s) :: 17 2514 CLAY ST 1 Sidewalk: Property side : Cutout Tree Private 2   11/09/2015 12:00:00 AM   3x3 Permit Number 776637 6002696 2116178 37.7907733646004 -122.43455974658 (37.7907733646004, -122.43455974658) 13 9 1 29490 27

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