trees
336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
177119 | 114191 | Significant Tree 6 | Tree(s) :: 17 | 201 Delano Ave | 7 | Back Yard : Yard | Tree | Private 2 | 20 | Permit Number 776814 | 6000172.52130735 | 2092388.14283689 | 37.7253086814057 | -122.44158289611 | (37.7253086814057, -122.44158289611) | 9 | 7 | 6 | 28861 | 25 | |||
24668 | 97534 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 203 Surrey St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768282 | 6002070 | 2096079.6 | 37.7355525046422 | -122.435287431957 | (37.7355525046422, -122.435287431957) | 2 | 7 | 5 | 63 | 7 | ||||
429 | 259715 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 210 Gold Mine Dr | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000723 | 2098465 | 37.7420256658379 | -122.440115509428 | (37.7420256658379, -122.440115509428) | 2 | 7 | 5 | 63 | 7 | ||||
184053 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X STILLINGS AVE | 1 | Back Yard : Yard | Tree | Private 2 | 60 | 6000417 | 2095694 | 37.7343997262189 | -122.44097481224 | (37.7343997262189, -122.44097481224) | 9 | 7 | 5 | 63 | 40 | ||||
7906 | 262219 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000348 | 2095645 | 37.7342612534616 | -122.441209852629 | (37.7342612534616, -122.441209852629) | 9 | 7 | 5 | 63 | 40 | ||||
182728 | 102583 | Significant Tree 6 | Tree(s) :: 17 | 22 Gennessee St | 1 | Front Yard : Yard | Tree | Private 2 | 02/27/2013 12:00:00 AM | Permit Number 769949 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | 9 | 7 | 4 | 28861 | 40 | |||
3842 | 109772 | Significant Tree 6 | Yucca elephantipes :: Giant Yucca 268 | 2200x SAN JOSE AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | |||
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
73655 | 253718 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 227 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | Permit Number 780760 | 6005690 | 2092595 | 37.7261894743752 | -122.422524168298 | (37.7261894743752, -122.422524168298) | 9 | 7 | 7 | 309 | 5 | ||
34428 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 22R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999148 | 2100052 | 37.7462933941297 | -122.445675437709 | (37.7462933941297, -122.445675437709) | 2 | 7 | 5 | 63 | 22 | |||||
149078 | 117438 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 230 AMBER DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999593 | 2099199 | 37.7439766577846 | -122.444075405191 | (37.7439766577846, -122.444075405191) | 2 | 7 | 5 | 63 | 22 | |||
62334 | 87240 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330 | 2096776 | 37.7374226054152 | -122.437895752709 | (37.7374226054152, -122.437895752709) | 2 | 7 | 5 | 63 | 7 | |||
71176 | 87239 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330 | 2096776 | 37.7374226054152 | -122.437895752709 | (37.7374226054152, -122.437895752709) | 2 | 7 | 5 | 63 | 7 | |||
90315 | 112398 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 246 CRESCENT AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6006552 | 2095759 | 37.7349257177289 | -122.419768681192 | (37.7349257177289, -122.419768681192) | 2 | 7 | 7 | 28859 | 2 | |||||
16429 | 262110 | Significant Tree 6 | Phoenix dactylifera :: Date Palm 87 | 25 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002200 | 2092574 | 37.7259343081174 | -122.434587389509 | (37.7259343081174, -122.434587389509) | 9 | 7 | 6 | 28861 | 25 | ||||
41386 | 121194 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 255x Red Rock Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999917 | 2099808 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | 2 | 7 | 5 | 63 | 22 | |||
116253 | 121195 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 255x Red Rock Way | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999917 | 2099808 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | 2 | 7 | 5 | 63 | 22 | |||
171448 | 121196 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 255x Red Rock Way | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999917 | 2099808 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | 2 | 7 | 5 | 63 | 22 | |||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
152685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
59436 | 117588 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 261 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778127 | 6009622.3 | 2099176 | 37.7444805424074 | -122.409394598776 | (37.7444805424074, -122.409394598776) | 2 | 7 | 7 | 28859 | 2 | ||
95118 | 257896 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 266 Moreland St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001949 | 2097289 | 37.7388663647576 | -122.435792277212 | (37.7388663647576, -122.435792277212) | 2 | 7 | 5 | 63 | 7 | ||||
142556 | 256880 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2701 Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5997600 | 2087902 | 37.7128438731446 | -122.450152604107 | (37.7128438731446, -122.450152604107) | 9 | 7 | 6 | 28861 | 25 | ||||
10162 | 230434 | Significant Tree 6 | Magnolia x soulangiana :: Saucer Magnolia 147 | 272 Anderson St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | Width 3ft | 6007874.82314 | 2097362.07469 | 37.7394018403099 | -122.415308650074 | (37.7394018403099, -122.415308650074) | 2 | 7 | 7 | 28859 | 2 | |||
78510 | 256521 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2783X Diamond St | 3 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 782107 | 6002654 | 2095945 | 37.7352160714264 | -122.433258709098 | (37.7352160714264, -122.433258709098) | 2 | 7 | 5 | 63 | 7 | |||
138786 | 255536 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2783X Diamond St | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 782107 | 6002654 | 2095945 | 37.7352160714264 | -122.433258709098 | (37.7352160714264, -122.433258709098) | 2 | 7 | 5 | 63 | 7 | |||
188029 | 256520 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 2783X Diamond St | 2 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 782107 | 6002654 | 2095945 | 37.7352160714264 | -122.433258709098 | (37.7352160714264, -122.433258709098) | 2 | 7 | 5 | 63 | 7 | |||
4207 | 247626 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6009494.96271 | 2096975.40444 | 37.7384310509429 | -122.409679612625 | (37.7384310509429, -122.409679612625) | 10 | 7 | 7 | 28859 | 2 | ||||
6178 | 247627 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6009494.82009 | 2096968.41626 | 37.7384118549208 | -122.409679612627 | (37.7384118549208, -122.409679612627) | 10 | 7 | 7 | 28859 | 2 | ||||
8454 | 247630 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6009492.89578 | 2096949.07994 | 37.7383586537362 | -122.409684901541 | (37.7383586537362, -122.409684901541) | 10 | 7 | 7 | 28859 | 2 | ||||
12344 | 247628 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6009493.85882 | 2096962.27736 | 37.7383949449624 | -122.409682503062 | (37.7383949449624, -122.409682503062) | 10 | 7 | 7 | 28859 | 2 | ||||
16054 | 247629 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 286 Bradford St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | 6009493.3855 | 2096955.46231 | 37.7383762057861 | -122.409683658684 | (37.7383762057861, -122.409683658684) | 10 | 7 | 7 | 28859 | 2 | ||||
16372 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
162530 | 96328 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
111349 | 251628 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2R Amethyst Way | 3 | Back Yard : Yard | Tree | Private 2 | 5999263 | 2100016 | 37.7462011119367 | -122.44527519505 | (37.7462011119367, -122.44527519505) | 2 | 7 | 5 | 63 | 22 | |||||
145363 | 251626 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999263 | 2100016 | 37.7462011119367 | -122.44527519505 | (37.7462011119367, -122.44527519505) | 2 | 7 | 5 | 63 | 22 | |||||
61064 | 253428 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3 Valletta Ct | 1 | Side Yard : Cutout | Tree | Private 2 | 6x10 | Permit Number 780575 | 5999319 | 2096479 | 37.7364925519579 | -122.444827352142 | (37.7364925519579, -122.444827352142) | 9 | 7 | 4 | 63 | 40 | |||
71228 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3 Valletta Ct | 2 | Side Yard : Cutout | Tree | Private 2 | 6x10 | 5999319 | 2096479 | 37.7364925519579 | -122.444827352142 | (37.7364925519579, -122.444827352142) | 9 | 7 | 4 | 63 | 40 | ||||
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 | ||||
37139 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
143852 | 98290 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
165161 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
119122 | 251575 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Sussex St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/02/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780395 | 6001194 | 2096647 | 37.7370606668352 | -122.438356728037 | (37.7370606668352, -122.438356728037) | 2 | 7 | 5 | 63 | 7 | |
29607 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
78343 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 301 Hazelwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
156524 | 101468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
177640 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 30X Zircon Pl | 1 | Back Yard : Yard | Tree | Private 2 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.434652757436 | (37.7430068656447, -122.434652757436) | 2 | 7 | 5 | 63 | 7 | |||||
18320 | 261763 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 315 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009577 | 2099558 | 37.7455268923792 | -122.409578193595 | (37.7455268923792, -122.409578193595) | 2 | 7 | 7 | 28859 | 2 | ||||
12676 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 50 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 782183 | 6009049 | 2099828 | 37.7462386522881 | -122.411423013741 | (37.7462386522881, -122.411423013741) | 2 | 7 | 7 | 28859 | 2 | |||
194504 | 265143 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995416 | 2096422 | 37.7361125310636 | -122.458317465478 | (37.7361125310636, -122.458317465478) | 9 | 7 | 4 | 59 | 40 | ||||
94002 | 113187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3340 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008444 | 2099179 | 37.7444226899799 | -122.413469145285 | (37.7444226899799, -122.413469145285) | 2 | 7 | 7 | 28859 | 2 | |||
36038 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5996066 | 2095432 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | 9 | 7 | 4 | 59 | 40 | |||
4898 | 211279 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.443209289192 | (37.7324367835174, -122.443209289192) | 9 | 7 | 4 | 63 | 40 | |||
84220 | 104654 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 352-354 Coleridge St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768244 | 6006091.8 | 2098091.1 | 37.7413032079582 | -122.421525330669 | (37.7413032079582, -122.421525330669) | 2 | 7 | 7 | 28859 | 2 | ||||
61885 | 105866 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 3555 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
73380 | 105869 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
76185 | 105867 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
145596 | 105870 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
178545 | 105871 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
186539 | 105868 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||||
23740 | 255978 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
30833 | 258289 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
82626 | 258290 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 7 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
104555 | 258287 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
128772 | 258286 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
134246 | 258292 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
145770 | 258288 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
147696 | 258285 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
159425 | 258291 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 8 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
108135 | 108305 | Significant Tree 6 | Tree(s) :: 17 | 360 GAMBIER ST | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | Permit Number 774454 | 6006059.9 | 2092154.5 | 37.725000818071 | -122.421214176486 | (37.725000818071, -122.421214176486) | 9 | 7 | 7 | 309 | 5 | ||
22846 | 105861 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
23771 | 105863 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
35675 | 105864 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
75419 | 105862 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
126862 | 105865 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
182948 | 105860 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3615-3623X Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | |||||
18860 | 229626 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 3658 Folsom St | 1 | Side Yard : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008459.0571 | 2097864.523 | 37.7408142714666 | -122.413324142211 | (37.7408142714666, -122.413324142211) | 2 | 7 | 7 | 28859 | 2 | |||
170923 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | ||||
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 | |
7631 | 256540 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
143508 | 256539 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
126350 | 101810 | Significant Tree 6 | Tree(s) :: 17 | 38 Nebraska St | 1 | Front Yard : | Tree | Private 2 | 11/22/2012 12:00:00 AM | Permit Number 769374 | 6009268.6 | 2097830.3 | 37.740765720819 | -122.41052261909 | (37.740765720819, -122.41052261909) | 10 | 7 | 7 | 28859 | 2 | |||
135306 | 253899 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | Permit Number 780835 | 5999528 | 2094735 | 37.7317158633652 | -122.443979483467 | (37.7317158633652, -122.443979483467) | 9 | 7 | 4 | 63 | 40 | |||
161712 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Valdez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | 9 | 7 | 4 | 59 | 40 | ||||
106382 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000586 | 2086414 | 37.7089285790833 | -122.439725431133 | (37.7089285790833, -122.439725431133) | 9 | 7 | 6 | 28861 | 5 | ||||
181560 | 256493 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 400 Rolph St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002004 | 2087744 | 37.7126610773499 | -122.434919679914 | (37.7126610773499, -122.434919679914) | 9 | 7 | 6 | 28861 | 5 | ||||
32937 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | MTA 3 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.7228470175482 | -122.44673211619 | (37.7228470175482, -122.44673211619) | 9 | 7 | 6 | 28861 | 25 | |||
36628 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.7228516427597 | -122.445718558684 | (37.7228516427597, -122.445718558684) | 9 | 7 | 6 | 28861 | 25 | |||
47041 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998978.57855 | 2091518.53644 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | 9 | 7 | 6 | 28861 | 25 | |||
49633 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998924.5969 | 2091518.78116 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | 9 | 7 | 6 | 28861 | 25 | |||
54303 | 178335 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | MTA 3 | 33 | Width 8ft | 5998656.04486 | 2091523.12147 | 37.7228470175503 | -122.446762975526 | (37.7228470175503, -122.446762975526) | 9 | 7 | 6 | 28861 | 25 | |||
57339 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard | Tree | MTA 3 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369564 | (37.7228504376851, -122.44574369564) | 9 | 7 | 6 | 28861 | 25 | |||
63382 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | MTA 3 | 37 | 5998700.41574 | 2091522.98281 | 37.7228491714484 | -122.446609585371 | (37.7228491714484, -122.446609585371) | 9 | 7 | 6 | 28861 | 25 | ||||
114550 | 178337 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | MTA 3 | 29 | 5998676.28102 | 2091524.00797 | 37.7228506076618 | -122.446693087413 | (37.7228506076618, -122.446693087413) | 9 | 7 | 6 | 28861 | 25 | ||||
173815 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998921.08183 | 2091519.29315 | 37.7228516427808 | -122.445846526795 | (37.7228516427808, -122.445846526795) | 9 | 7 | 6 | 28861 | 25 | |||
176521 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard | Tree | MTA 3 | 7 | Width 5ft | 5998933.17773 | 2091518.16383 | 37.7228492325857 | -122.445804632792 | (37.7228492325857, -122.445804632792) | 9 | 7 | 6 | 28861 | 25 | |||
21762 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 394 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5995635 | 2092781 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | 9 | 7 | 4 | 28861 | 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) );