trees
336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||||
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 | |||
178454 | 96779 | Significant Tree 6 | Tree(s) :: 17 | 555 Melrose Ave | 1 | Back Yard : Yard | Tree | Private 2 | 07/18/2011 12:00:00 AM | Permit Number 767966 | 5996882.6 | 2095364.1 | 37.7332919614683 | -122.45317051412 | (37.7332919614683, -122.45317051412) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 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 | ||||
47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
9495 | 261033 | Significant Tree 6 | Tree(s) :: 17 | 551 Los Palmos Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784596 | 5996615 | 2095626 | 37.7339957349096 | -122.454114584985 | (37.7339957349096, -122.454114584985) | 9 | 7 | 4 | 59 | 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 | ||||
3054 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 95 Nordhoff St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.7342629464917 | -122.441207129815 | (37.7342629464917, -122.441207129815) | 9 | 7 | 5 | 63 | 40 | ||||
68299 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 86 Nordhoff St | 1 | Front Yard : Yard | Tree | Private 2 | 6000395 | 2095652 | 37.7342831509698 | -122.441047861045 | (37.7342831509698, -122.441047861045) | 9 | 7 | 5 | 63 | 40 | |||||
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 | ||||
104704 | 256850 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 100 Brentwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | 5995843 | 2095739 | 37.7342617075966 | -122.456791779994 | (37.7342617075966, -122.456791779994) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||||
160307 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x8 | 5997298 | 2095759 | 37.7344000615683 | -122.451762846846 | (37.7344000615683, -122.451762846846) | 9 | 7 | 4 | 59 | 40 | ||||
63394 | 106833 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 174 STILLINGS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | 9 | 7 | 4 | 63 | 40 | |||||
13663 | 258677 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 607 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 6000094 | 2095817 | 37.7347190533418 | -122.442100351643 | (37.7347190533418, -122.442100351643) | 9 | 7 | 4 | 63 | 40 | ||||
17239 | 32497 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 665 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 16 | Permit Number 37002 | 6007442.30694 | 2095863.10154 | 37.7352616718948 | -122.416697941676 | (37.7352616718948, -122.416697941676) | 2 | 7 | 7 | 28859 | 2 | |
80243 | 255324 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 852 Chenery St | 2 | Front Yard : Yard | Tree | Private 2 | 3X3 | 6001755.94767 | 2095865.71194 | 37.7349473777015 | -122.436357925586 | (37.7349473777015, -122.436357925586) | 2 | 7 | 5 | 63 | 7 | ||||
104067 | 255325 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 42 Lippard Ave | 1 | Front Yard : Yard | Tree | Private 2 | Width 0ft | Permit Number 781812 | 6002006.02273 | 2095939.48888 | 37.7351641583954 | -122.435498605394 | (37.7351641583954, -122.435498605394) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
59778 | 112374 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1247 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | Permit Number 775819 | 6000424.11007 | 2096055.79143 | 37.7353935258967 | -122.440976176652 | (37.7353935258967, -122.440976176652) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||||
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 | ||||||
184595 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 100x OGDEN AVE | 4 | Back Yard : Yard | Tree | Private 2 | 6007659 | 2096105 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | 2 | 7 | 7 | 28859 | 2 | |||||
110740 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 484 Chenery St | 1 | Front Yard : Yard | Tree | Private 2 | 6003566 | 2096120 | 37.7357482768139 | -122.430118073632 | (37.7357482768139, -122.430118073632) | 2 | 7 | 5 | 63 | 7 | |||||
159697 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 998 Chenery St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 1ft | 6001140.61217 | 2096125.61153 | 37.7356260187109 | -122.438503967885 | (37.7356260187109, -122.438503967885) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
45212 | 254126 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1291 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000129 | 2096323 | 37.7361104052088 | -122.44201565285 | (37.7361104052088, -122.44201565285) | 2 | 7 | 5 | 63 | 7 | ||||
77320 | 116457 | Significant Tree 6 | Tree(s) :: 17 | 412 Nevada St | 1 | Front Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | Permit Number 777591 | 6008890.4 | 2096365.2 | 37.736721665261 | -122.41172680033 | (37.736721665261, -122.41172680033) | 10 | 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 | ||||
12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||
39514 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 Conrad St | 1 | Back Yard : Cutout | Tree | Private 2 | 20 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |
89812 | 107834 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 100X SUSSEX ST | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002188 | 2096682 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | 2 | 7 | 5 | 63 | 7 | ||||
170160 | 107835 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 100X SUSSEX ST | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002188 | 2096682 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | 2 | 7 | 5 | 63 | 7 | ||||
134585 | 24480 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 108X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780363 | 6002195.08262 | 2096706.93645 | 37.737282128351 | -122.434899824187 | (37.737282128351, -122.434899824187) | 2 | 7 | 5 | 63 | 7 | |
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 | |||
169778 | 255656 | Significant Tree 6 | Tree(s) :: 17 | 5827 Diamond Heights Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 12/28/2018 12:00:00 AM | 3 | 12x12 | Permit Number 781981 | 6000844 | 2096795 | 37.7374471263095 | -122.439577439508 | (37.7374471263095, -122.439577439508) | 2 | 7 | 5 | 63 | 7 | |
30591 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | 2 | 7 | 5 | 63 | 7 | ||||
42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
8573 | 264725 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 136 Addison St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002996 | 2096937 | 37.7379592717499 | -122.432147110586 | (37.7379592717499, -122.432147110586) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
11129 | 236516 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 63 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6009359.84862 | 2097078.24448 | 37.7387058549889 | -122.410154031979 | (37.7387058549889, -122.410154031979) | 10 | 7 | 7 | 28859 | 2 | |||
15717 | 221238 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 55 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6009363.02974 | 2097125.97708 | 37.7388370966643 | -122.41014640214 | (37.7388370966643, -122.41014640214) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||||
190141 | 100043 | Significant Tree 6 | Tree(s) :: 17 | 50 Bronte St | 1 | Front Yard : Yard | Tree | Private 2 | 07/12/2012 12:00:00 AM | Permit Number 769001 | 6009337 | 2097155 | 37.7389153282678 | -122.410238449764 | (37.7389153282678, -122.410238449764) | 10 | 7 | 7 | 28859 | 2 | |||
155030 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6009384 | 2097185 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | 10 | 7 | 7 | 28859 | 2 | |||
92509 | 87216 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 | 500 Cortland Ave | 2 | Back Yard : Yard | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007640.7 | 2097187.4 | 37.7389090609704 | -122.416105779709 | (37.7389090609704, -122.416105779709) | 2 | 7 | 7 | 28859 | 2 | ||
110002 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 | 500 Cortland Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | 2 | 7 | 7 | 28859 | 2 | ||
23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
116509 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
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 | ||||
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 | |||
149707 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 MIGUEL ST | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6003334.2 | 2097391.9 | 37.7392274919289 | -122.431010244874 | (37.7392274919289, -122.431010244874) | 2 | 7 | 5 | 63 | 7 | ||||
50525 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 190 Beacon St | 1 | Front Yard : Yard | Tree | Private 2 | 6003193 | 2097540 | 37.7396261385587 | -122.431509020833 | (37.7396261385587, -122.431509020833) | 2 | 7 | 5 | 63 | 7 | |||||
551 | 234021 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6009064.54563 | 2097789.74594 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |||
4813 | 223765 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009530.59471 | 2097856.4038 | 37.7408520807582 | -122.409618578357 | (37.7408520807582, -122.409618578357) | 10 | 7 | 7 | 28859 | 2 | |||
50063 | 105765 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 95 ORA WAY | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6001454.9 | 2097857 | 37.7403978808149 | -122.437541306682 | (37.7403978808149, -122.437541306682) | 2 | 7 | 5 | 63 | 7 | ||||
3385 | 223764 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.409618578359 | (37.7408634922583, -122.409618578359) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
7930 | 223763 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.7408787078943 | -122.409618578334 | (37.7408787078943, -122.409618578334) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||||
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 | ||||
86813 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1753 Noe St | 1 | Hanging basket : Yard | Tree | Private 2 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | 2 | 7 | 5 | 63 | 7 | |||
27545 | 115090 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 1 | Front Yard : Yard | Tree | Private 2 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050 | 37.7409500647868 | -122.436201464472 | (37.7409500647868, -122.436201464472) | 2 | 7 | 5 | 63 | 7 | |||
166995 | 115091 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 2 | Front Yard : Yard | Tree | Private 2 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050 | 37.7409500647868 | -122.436201464472 | (37.7409500647868, -122.436201464472) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
32139 | 112726 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
42938 | 112725 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
51717 | 115446 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 2 | Back Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931 | 2098208 | 37.7418399166086 | -122.408258912238 | (37.7418399166086, -122.408258912238) | 10 | 7 | 7 | 28859 | 2 | |
74590 | 115445 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 1 | Back Yard : Yard | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931 | 2098208 | 37.7418399166086 | -122.408258912238 | (37.7418399166086, -122.408258912238) | 10 | 7 | 7 | 28859 | 2 | |
178584 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 140x TOPAZ WAY | 2 | Front Yard : Yard | Tree | Private 2 | 30 | Permit Number 775551 | 6001767 | 2098265 | 37.7415358930081 | -122.436491384585 | (37.7415358930081, -122.436491384585) | 2 | 7 | 5 | 63 | 7 | |||
92659 | 85428 | Significant Tree 6 | Tree(s) :: 17 | 43 Ora Way | 1 | Front Yard : Cutout | Tree | Private 2 | 08/23/2007 12:00:00 AM | Permit Number 49665 | 6001553.3 | 2098294.6 | 37.7416050219872 | -122.437232403771 | (37.7416050219872, -122.437232403771) | 2 | 7 | 5 | 63 | 7 | |||
85195 | 98151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 850 Rockdale Dr | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | 9 | 7 | 4 | 59 | 40 | ||||
151159 | 107322 | Significant Tree 6 | Tree(s) :: 17 | 68 ROSENKRANZ ST | 1 | Front Yard : Yard | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773942 | 6009212 | 2098349 | 37.7421867844178 | -122.410754944355 | (37.7421867844178, -122.410754944355) | 10 | 7 | 7 | 28859 | 2 | ||
89599 | 98156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 149x Chaves Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | 9 | 7 | 4 | 59 | 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) );