trees
416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
84393 | 116534 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 3 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
105492 | 116536 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 5 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
143694 | 116535 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 4 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
124365 | 116951 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 299 Tara St | 1 | Front Yard : Yard | Tree | Private 2 | 5997754 | 2090179.6 | 37.7191064490611 | -122.449784366221 | (37.7191064490611, -122.449784366221) | 9 | 8 | 6 | 28861 | 24 | |||||
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 | |||||
15657 | 259657 | Significant Tree 6 | Tree(s) :: 17 | 132 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995545 | 2087474 | 37.7115508726991 | -122.457224363425 | (37.7115508726991, -122.457224363425) | 9 | 8 | 6 | 28861 | 24 | ||||
48765 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878 | (37.7199132334677, -122.45865940878) | 9 | 8 | 6 | 28861 | 24 | |||||
6370 | 261832 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 16 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995265 | 2100184 | 37.7464333732005 | -122.459111852123 | (37.7464333732005, -122.459111852123) | 1 | 8 | 4 | 59 | 40 | ||||
24927 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 276 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5995080.66446 | 2095640.15746 | 37.7339465073544 | -122.459420244296 | (37.7339465073544, -122.459420244296) | 9 | 8 | 4 | 59 | 40 | ||||
12287 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Vasquez Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | 1 | 8 | 4 | 59 | 40 | |||||
12152 | 255704 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 201X Hernandez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995122 | 2099706 | 37.7451126829106 | -122.459571712369 | (37.7451126829106, -122.459571712369) | 1 | 8 | 4 | 59 | 40 | ||||
9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
137083 | 106962 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 218 SADOWA ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 5994814 | 2087793.9 | 37.7123872323548 | -122.459774032106 | (37.7123872323548, -122.459774032106) | 9 | 8 | 6 | 28861 | 24 | ||||
81780 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288 | (37.712360795684, -122.45981072288) | 9 | 8 | 6 | 28861 | 24 | |
107229 | 255805 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 333 | 2 Sola Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994994 | 2100719 | 37.7478867659483 | -122.460087684856 | (37.7478867659483, -122.460087684856) | 1 | 8 | 4 | 29491 | 40 | ||||
103685 | 248958 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 98x Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2017 12:00:00 AM | 3 | 3x3 | 5994824 | 2095658 | 37.7339807377795 | -122.460308897898 | (37.7339807377795, -122.460308897898) | 9 | 8 | 4 | 59 | 40 | ||
4567 | 261551 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 135 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994788 | 2095004 | 37.7321829429526 | -122.460385989231 | (37.7321829429526, -122.460385989231) | 9 | 8 | 4 | 59 | 40 | ||||
2657 | 260570 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
5792 | 260568 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
8040 | 260572 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
11442 | 260571 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
11875 | 260569 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
13149 | 260567 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
13972 | 260573 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 129 Edgehill Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994858 | 2098970 | 37.7430766268484 | -122.460431252252 | (37.7430766268484, -122.460431252252) | 1 | 8 | 4 | 59 | 40 | ||||
21096 | 253953 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 11X Ravenwood Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x10 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | ||||
110540 | 253952 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 11X Ravenwood Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x10 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | ||||
8007 | 261753 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 3 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
11628 | 261752 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 2 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
19112 | 261751 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 1 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||
194270 | 264977 | Significant Tree 6 | Tree(s) :: 17 | 188 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787864 | 5994639 | 2096200 | 37.7354582929988 | -122.460987765625 | (37.7354582929988, -122.460987765625) | 9 | 8 | 4 | 59 | 40 | |
59764 | 105504 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 39 MAGELLAN AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5994694.1 | 2101166.3 | 37.7490976851152 | -122.461157135733 | (37.7490976851152, -122.461157135733) | 1 | 8 | 4 | 29491 | 40 | ||||
84029 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 273 Magellan Ave | 5 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
95583 | 102077 | Significant Tree 6 | Ulmus glabra :: Scotch Elm 531 | 273 Magellan Ave | 7 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
106522 | 102073 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 273 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
110154 | 102074 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 273 Magellan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
125509 | 254393 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 150 Granville Way | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994538 | 2098550 | 37.7419049979895 | -122.461507275162 | (37.7419049979895, -122.461507275162) | 1 | 8 | 4 | 59 | 40 | ||||
20150 | 256573 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 145 Castenada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5994569 | 2100949 | 37.74849383418 | -122.461573977381 | (37.74849383418, -122.461573977381) | 1 | 8 | 4 | 29491 | 40 | ||||
22895 | 256572 | Significant Tree 6 | Ilex aquifolium :: European Holly 390 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994536 | 2100823 | 37.748145970457 | -122.461678955671 | (37.748145970457, -122.461678955671) | 1 | 8 | 4 | 29491 | 40 | ||||
15671 | 104278 | Significant Tree 6 | Acacia spp :: Acacia Spp 105 | 2 Allston Way | 1 | Back Yard : Yard | Tree | Private 2 | 5994445.1 | 2098202.2 | 37.7409446783355 | -122.461803277974 | (37.7409446783355, -122.461803277974) | 1 | 8 | 4 | 59 | 40 | |||||
137836 | 208971 | Significant Tree 6 | Tree(s) :: 17 | 150 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/18/2018 12:00:00 AM | 3 | Width 6ft | Permit Number 782070 | 5994318.90627 | 2096521.25566 | 37.7363219572757 | -122.462117732164 | (37.7363219572757, -122.462117732164) | 9 | 8 | 4 | 59 | 40 | |
10229 | 264894 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 56 Keystone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5994156 | 2093086 | 37.7268802074189 | -122.462431871086 | (37.7268802074189, -122.462431871086) | 9 | 8 | 4 | 28861 | 40 | ||||
52558 | 255280 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
107089 | 255281 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
111294 | 255282 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
168382 | 255283 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
187303 | 118359 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 8 Keystone Way | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 5994105 | 2092664 | 37.7257185609933 | -122.46257757783 | (37.7257185609933, -122.46257757783) | 9 | 8 | 4 | 59 | 40 | |||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
27831 | 98834 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 | |||
116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
179237 | 115750 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 100 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | |||||
188246 | 115749 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 100 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | |||||
46153 | 209002 | Significant Tree 6 | Tree(s) :: 17 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781950 | 5994125 | 2096751 | 37.7369416119865 | -122.462804803775 | (37.7369416119865, -122.462804803775) | 9 | 8 | 4 | 59 | 40 | |
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
23427 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 4 | Back Yard : Yard | Tree | Private 2 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||||
26477 | 253808 | Significant Tree 6 | Tree(s) :: 17 | 2 Garfield St | 2 | Side Yard : Yard | Tree | Private 2 | 09/14/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |
69528 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Garfield St | 1 | Side Yard : Yard | Tree | Private 2 | 10x2 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |||
120070 | 253809 | Significant Tree 6 | Tree(s) :: 17 | 2 Garfield St | 3 | Side Yard : Yard | Tree | Private 2 | 09/14/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |
157181 | 101138 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5994035.6 | 2097938.3 | 37.7401964926879 | -122.463200022957 | (37.7401964926879, -122.463200022957) | 1 | 8 | 4 | 59 | 40 | |||||
144728 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035 | 2097938 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | 1 | 8 | 4 | 59 | 40 | ||
192391 | 253097 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | DPW | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035 | 2097938 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | 1 | 8 | 4 | 59 | 40 | |
82975 | 255461 | Significant Tree 6 | Tree(s) :: 17 | 37 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 10x6 | Permit Number 777804 | 5994021.13024 | 2097608.02637 | 37.7392888101295 | -122.463226093964 | (37.7392888101295, -122.463226093964) | 1 | 8 | 4 | 59 | 40 | |
40307 | 86910 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49875 | 5993901 | 2092133 | 37.7242488135215 | -122.463244271267 | (37.7242488135215, -122.463244271267) | 9 | 8 | 4 | 59 | 40 | |||
62177 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | 9 | 8 | 4 | 59 | 40 | |||||
92153 | 117518 | Significant Tree 6 | Ulmus americana :: American Elm 74 | 30 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | Permit Number 777803 | 5993995.8 | 2097679.6 | 37.7394838741894 | -122.463318866351 | (37.7394838741894, -122.463318866351) | 1 | 8 | 4 | 59 | 40 | ||
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
6296 | 260461 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
66926 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
94784 | 253250 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99X Lopez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
102553 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 270 Castenada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
144280 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 270 Castenada Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 40 | ||
154838 | 102479 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 760 Victoria St | 5 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
187809 | 99099 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65X Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768467 | 5993743.4 | 2097365.9 | 37.7386079879791 | -122.464168780849 | (37.7386079879791, -122.464168780849) | 1 | 8 | 4 | 59 | 40 | |||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
146154 | 99098 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 66 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768466 | 5993736.6 | 2097303.5 | 37.7384362612216 | -122.464187762983 | (37.7384362612216, -122.464187762983) | 1 | 8 | 4 | 59 | 40 | |||
75453 | 100529 | Significant Tree 6 | Tree(s) :: 17 | 720 Victoria St | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2012 12:00:00 AM | Permit Number 769203 | 5993611.6 | 2091925.6 | 37.723662667106 | -122.464229627127 | (37.723662667106, -122.464229627127) | 9 | 8 | 4 | 59 | 40 | |||
45348 | 93222 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788 | 2100441 | 37.7470540096767 | -122.464237765204 | (37.7470540096767, -122.464237765204) | 1 | 8 | 4 | 29491 | 40 | |||
67970 | 93221 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788 | 2100441 | 37.7470540096767 | -122.464237765204 | (37.7470540096767, -122.464237765204) | 1 | 8 | 4 | 29491 | 40 | |||
139444 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969 | 37.7375153061033 | -122.464313539267 | (37.7375153061033, -122.464313539267) | 1 | 8 | 4 | 59 | 40 | ||
60308 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993700.7 | 2097327 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | 1 | 8 | 4 | 59 | 40 | |||||
150390 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.7393969918941 | -122.464361897304 | (37.7393969918941, -122.464361897304) | 1 | 8 | 4 | 59 | 40 | |||
43207 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
75962 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1836 08TH AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | |||
97746 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
71364 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
73267 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||
83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
180538 | 116957 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 10x Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||||
182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
120316 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 URBANO DR | 1 | Front Yard : Yard | Tree | Private 2 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | 9 | 8 | 4 | 59 | 40 | ||||
76823 | 255913 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 121 San Marcos Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5993694 | 2100263 | 37.7465598483618 | -122.464549884035 | (37.7465598483618, -122.464549884035) | 1 | 8 | 4 | 29491 | 40 |
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) );