trees
1,732 rows where qLegalStatus_id = 6 sorted by SiteOrder
This data as json, CSV (advanced)
PlantDate ✖
- - 1,279
- 04/04/2009 12:00:00 AM 18
- 08/27/2015 12:00:00 AM 12
- 09/17/2013 12:00:00 AM 12
- 06/07/2013 12:00:00 AM 11
- 02/24/2016 12:00:00 AM 10
- 09/05/2012 12:00:00 AM 8
- 07/31/2014 12:00:00 AM 7
- 02/27/2018 12:00:00 AM 6
- 05/12/2015 12:00:00 AM 6
- 07/30/2008 12:00:00 AM 6
- 01/20/2017 12:00:00 AM 5
- 08/03/2015 12:00:00 AM 5
- 11/12/2014 12:00:00 AM 5
- 01/06/2014 12:00:00 AM 4
- 02/24/2010 12:00:00 AM 4
- 05/01/2018 12:00:00 AM 4
- 05/13/2016 12:00:00 AM 4
- 05/22/2020 12:00:00 AM 4
- 07/07/2000 12:00:00 AM 4
- 07/23/2014 12:00:00 AM 4
- 08/13/2008 12:00:00 AM 4
- 11/25/2019 12:00:00 AM 4
- 12/21/2012 12:00:00 AM 4
- 01/17/2018 12:00:00 AM 3
- 01/24/2012 12:00:00 AM 3
- 02/25/2020 12:00:00 AM 3
- 03/12/2015 12:00:00 AM 3
- 04/01/2016 12:00:00 AM 3
- 04/07/2012 12:00:00 AM 3
- ...
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2862 | 261320 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 872 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014869 | 2089377 | 37.7178670406836 | -122.390567842363 | (37.7178670406836, -122.390567842363) | 10 | 3 | 8 | 58 | 1 | |||||
3726 | 94934 | Significant Tree 6 | Ficus carica 'Black Mission' :: Black Mission Fig 265 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | ||||
3798 | 262575 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 141 Topaz Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001722 | 2097902 | 37.7405366227001 | -122.436621002014 | (37.7405366227001, -122.436621002014) | 2 | 7 | 5 | 63 | 7 | |||||
5239 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
5747 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
6097 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2721 Pacific Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||||
6758 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 180 Yukon St | Back Yard : Cutout | Tree | Private 2 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.442406920559 | (37.7570738455347, -122.442406920559) | 2 | 4 | 5 | 28862 | 3 | ||||
7291 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard | Tree | Private 2 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | 1 | 8 | 3 | 56 | 35 | ||||||
7310 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 185 Chilton Ave | Front Yard : Yard | Tree | Private 2 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251 | -122.436889661497 | (37.732941575251, -122.436889661497) | 9 | 7 | 5 | 63 | 40 | ||||
7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
10379 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard | Tree | Private 2 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177 | 2107098 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | 15 | 5 | 5 | 29492 | 3 | |||
12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
12244 | 261985 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500x Bancroft Ave | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||||
13082 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
14736 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
16142 | 94943 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
22679 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 862 Kansas St | Front Yard : Yard | Tree | Private 2 | Permit Number 774734 | 6011570 | 2104296 | 37.7586478799274 | -122.403019866682 | (37.7586478799274, -122.403019866682) | 10 | 3 | 8 | 28856 | 29 | |||||
23199 | 112923 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
23401 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | 15 | 5 | 5 | 29492 | 3 | ||||||
24634 | 111770 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 707 Douglass St | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775627 | 6001281 | 2102187.2 | 37.7522776937422 | -122.438452748375 | (37.7522776937422, -122.438452748375) | 2 | 4 | 5 | 28862 | 22 | ||||
34293 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150x FONT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976 | 2089133 | 37.7158426125161 | -122.473136789074 | (37.7158426125161, -122.473136789074) | 1 | 8 | 4 | 64 | 14 | ||
35918 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 ARBOR ST | Front Yard : Yard | Tree | Private 2 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | 2 | 7 | 5 | 63 | 7 | |||||
36007 | 107047 | Significant Tree 6 | Tree(s) :: 17 | 1933 15TH ST | Front Yard : Yard | Tree | Private 2 | 6004592.7 | 2107127.1 | 37.7660293092823 | -122.427352228532 | (37.7660293092823, -122.427352228532) | 8 | 4 | 5 | 28862 | 3 | ||||||
38051 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | 5998985.48572 | 2105240.3128 | 37.7605299471227 | -122.446610614338 | (37.7605299471227, -122.446610614338) | 15 | 5 | 5 | 28862 | 12 | ||||||
39757 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 Gonzalez Dr | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
41336 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
44150 | 105208 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2694 47TH AVE | Front Yard : Yard | Tree | Private 2 | 5981878.3 | 2096771.8 | 37.7362857499502 | -122.505147911282 | (37.7362857499502, -122.505147911282) | 1 | 8 | 3 | 29491 | 35 | ||||||
45541 | 92053 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1001 Potrero Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
45754 | 94935 | Significant Tree 6 | Ficus carica 'Brown Turkey' :: Brown Turkey Fig 463 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | ||||
49649 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||
50522 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
53110 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
54868 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
55458 | 255165 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 371 Prospect Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781717 | 6006352.58239 | 2097791.19314 | 37.7404944317648 | -122.420602351048 | (37.7404944317648, -122.420602351048) | 2 | 7 | 7 | 28859 | 2 | |
56286 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
57862 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 1486 Innes Ave | Front Yard : Yard | Tree | Private 2 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | 10 | 3 | 8 | 58 | 1 | ||||||
57870 | 96483 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
60629 | 106612 | Significant Tree 6 | Schinus molle :: California Pepper 91 | 1189 TENNESSEE ST | Front Yard : Yard | Tree | Private 2 | 55 | 6015654.1 | 2103577.3 | 37.7569017014681 | -122.388844893024 | (37.7569017014681, -122.388844893024) | 10 | 3 | 8 | 28856 | 29 | |||||
61387 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2455x HYDE ST | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 6006980 | 2120877 | 37.8039178984324 | -122.420070904619 | (37.8039178984324, -122.420070904619) | 5 | 1 | 1 | 28858 | 32 | ||||
62475 | 107113 | Significant Tree 6 | Brahea edulis :: Guadalupe Palm 218 | 2100 MARKET ST | Front Yard : Cutout | Tree | Private 2 | 6004034 | 2107672.1 | 37.7674941340109 | -122.429323526179 | (37.7674941340109, -122.429323526179) | 7 | 9 | 5 | 28862 | 3 | ||||||
65651 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
68149 | 94937 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 504 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
72268 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
74096 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
77157 | 112924 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||||
78450 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
79851 | 94940 | Significant Tree 6 | Morus alba :: White Mulberry 246 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
81747 | 107245 | Significant Tree 6 | Tree(s) :: 17 | 140 CEDRO AVE | Front Yard : Yard | Tree | Private 2 | 5991993.7 | 2093259.3 | 37.7272312918526 | -122.469919436342 | (37.7272312918526, -122.469919436342) | 9 | 8 | 4 | 59 | 40 | ||||||
81784 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 32 | 2614 Sacramento St | Front Yard : | Tree | Private 2 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291 | 2115777 | 37.7896493226209 | -122.435932319436 | (37.7896493226209, -122.435932319436) | 13 | 6 | 1 | 29490 | 27 | ||||
83112 | 93724 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 415 Belvedere St | Front Yard : Yard | Tree | Private 2 | 5998488 | 2106798 | 37.7647785355325 | -122.448443362436 | (37.7647785355325, -122.448443362436) | 15 | 5 | 11 | 29492 | 9 | ||||||
83943 | 118327 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 109 ALPINE TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x7 | 6001716.4 | 2108199.1 | 37.7688096651516 | -122.43737752181 | (37.7688096651516, -122.43737752181) | 15 | 5 | 5 | 29492 | 3 | ||||
85997 | 111996 | Significant Tree 6 | Tree(s) :: 17 | 501 Point Lobos Ave | Front Yard : Yard | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775626 | 5981249.6 | 2112592.5 | 37.7796878572283 | -122.508495636007 | (37.7796878572283, -122.508495636007) | 11 | 6 | 2 | 55 | 26 | ||
87462 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826 | 2110084 | 37.7744428576765 | -122.409459923405 | (37.7744428576765, -122.409459923405) | 8 | 2 | 9 | 28853 | 34 | |||
93094 | 106927 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 4150 24th St | Sidewalk: Property side : Cutout | Tree | Private 2 | 1.5X1.5 | Permit Number 772519 | 6002207.56819 | 2101805.30097 | 37.7512817512061 | -122.435221219626 | (37.7512817512061, -122.435221219626) | 2 | 4 | 5 | 28862 | 22 | ||||
95953 | 95234 | Significant Tree 6 | Tree(s) :: 17 | 7 Almaden Ct | Front Yard : Yard | Tree | Private 2 | 01/25/2011 12:00:00 AM | Permit Number 767129 | 5995849 | 2112535 | 37.7803795989447 | -122.457986127959 | (37.7803795989447, -122.457986127959) | 11 | 6 | 2 | 54 | 16 | ||||
99609 | 96481 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
100702 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 654 Precita Ave | Front Yard : Yard | Tree | Private 2 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | 2 | 7 | 7 | 28859 | 2 | |||||
101013 | 94947 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
101112 | 110321 | Significant Tree 6 | Ilex opaca :: American Holly 473 | 1x SAN PABLO AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774750 | 5994773 | 2097898 | 37.740128291439 | -122.460647489756 | (37.740128291439, -122.460647489756) | 9 | 8 | 4 | 59 | 40 | ||
102859 | 87188 | Significant Tree 6 | Tree(s) :: 17 | 2119 Bush St | Front Yard : Yard | Tree | Private 2 | 01/29/2008 12:00:00 AM | Permit Number 50204 | 6002998 | 2114831 | 37.7870919849741 | -122.433418544226 | (37.7870919849741, -122.433418544226) | 13 | 9 | 11 | 29490 | 27 | ||||
103318 | 115673 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 86 Stanton St | Front Yard : Yard | Tree | Private 2 | 6000281.6 | 2103909.8 | 37.7569506357303 | -122.442032456595 | (37.7569506357303, -122.442032456595) | 2 | 4 | 5 | 28862 | 38 | ||||||
103743 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
105498 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
106523 | 112930 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
108660 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.445678167683 | (37.7642451591147, -122.445678167683) | 15 | 5 | 5 | 29492 | 9 | ||||||
109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
116546 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2620 Larkin St | Front Yard : Yard | Tree | Private 2 | 37 | Permit Number 56959 | 6006630 | 2120172 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | 5 | 9 | 1 | 28858 | 32 | ||||
121235 | 86895 | Significant Tree 6 | Tree(s) :: 17 | 321 Haight St | Front Yard : Yard | Tree | Private 2 | 10/26/2007 12:00:00 AM | Permit Number 49844 | 6004599.9 | 2109420.1 | 37.7723257406977 | -122.427490696784 | (37.7723257406977, -122.427490696784) | 7 | 9 | 11 | 28852 | 10 | ||||
124067 | 96482 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
125248 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 230 Lakeview Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | 9 | 8 | 6 | 28861 | 24 | |||||
129267 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 600 Front St | Front Yard : Yard | Tree | Private 2 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.399449857041 | (37.7974274520849, -122.399449857041) | 3 | 1 | 10 | 28860 | 6 | ||||
129276 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 546 Page St | Front Yard : | Tree | Private 2 | 6003947 | 2109752 | 37.7732001072566 | -122.429772814549 | (37.7732001072566, -122.429772814549) | 7 | 9 | 11 | 29492 | 10 | ||||||
129559 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 766 Anderson St | Front Yard : Yard | Tree | Private 2 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723 | 2095324 | 37.7337971999422 | -122.415689321062 | (37.7337971999422, -122.415689321062) | 2 | 7 | 7 | 28859 | 2 | |||
130983 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
133191 | 94939 | Significant Tree 6 | Morus alba :: White Mulberry 246 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
135218 | 94946 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
135340 | 96571 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
138259 | 94938 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 504 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
139381 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 96 CRESTA VISTA DR | Back Yard : Cutout | Tree | Private 2 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.457651008037 | (37.7352487002973, -122.457651008037) | 9 | 7 | 4 | 59 | 40 | ||||||
143770 | 110950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 342 HILL ST | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | Permit Number 778799 | 6004048 | 2103384 | 37.7557208285242 | -122.428969343229 | (37.7557208285242, -122.428969343229) | 2 | 4 | 5 | 28862 | 22 | |||
144050 | 94941 | Significant Tree 6 | Morus alba :: White Mulberry 246 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
144070 | 97894 | Significant Tree 6 | Tree(s) :: 17 | 2927 Folsom St | Front Yard : Yard | Tree | Private 2 | 02/29/2012 12:00:00 AM | 30 | Permit Number 768566 | 6008395 | 2101384 | 37.7504743768844 | -122.413794517972 | (37.7504743768844, -122.413794517972) | 2 | 4 | 7 | 28859 | 19 | |||
147409 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2203 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 | ||||||
148103 | 112925 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
151632 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
156168 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 184 | 55 BRONTE ST | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6009403 | 2097128 | 37.7388448914729 | -122.410008345842 | (37.7388448914729, -122.410008345842) | 10 | 7 | 7 | 28859 | 2 | ||||
157045 | 105845 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 | ||||||
157806 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 | 30 Onondaga Ave | Front Yard : Yard | Tree | Private 2 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.7218615356817 | -122.437972107548 | (37.7218615356817, -122.437972107548) | 9 | 7 | 6 | 28861 | 25 | ||||
158642 | 94066 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 548 Page St | Front Yard : | Tree | Private 2 | 06/02/2010 12:00:00 AM | Permit Number 53460 | 6003937 | 2109751 | 37.7731967952272 | -122.429807334526 | (37.7731967952272, -122.429807334526) | 7 | 9 | 11 | 29492 | 10 | ||||
161427 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
162331 | 97175 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
166722 | 112928 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
167754 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 ESMERALDA AVE | Front Yard : Yard | Tree | Private 2 | 6009839 | 2098688 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | 10 | 7 | 7 | 28859 | 2 | ||||||
170438 | 96480 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
171763 | 106405 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4849X 19th St | Front Yard : Yard | Tree | Private 2 | Permit Number 772769 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
172566 | 94942 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
173273 | 94868 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6007547 | 2093670 | 37.729245779959 | -122.416180705349 | (37.729245779959, -122.416180705349) | 9 | 3 | 7 | 309 | 28 |
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) );