trees
8,298 rows where qLegalStatus_id = 4 sorted by PlantDate descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );