trees
1,732 rows where qLegalStatus_id = 6 sorted by Neighborhoods (old) descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18711 | 262449 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 155 Baker St | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | 15 | 5 | 11 | 29492 | 9 | ||||
| 20293 | 254534 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 737 Buena Vista Ave West | 6 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 32791 | 254539 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 5 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 34533 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 7X CASTRO ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002014.1 | 2108690 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | 15 | 5 | 5 | 29492 | 9 | ||||
| 35186 | 100579 | Significant Tree 6 | Tree(s) :: 17 | 35 Lloyd St | 2 | Front Yard : Yard | Tree | Private 2 | 6002279.7 | 2108550 | 37.7698051576272 | -122.435454215606 | (37.7698051576272, -122.435454215606) | 15 | 5 | 5 | 29492 | 9 | |||||
| 35924 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399 | 2109002 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | 15 | 5 | 11 | 29492 | 9 | |
| 36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
| 43728 | 254538 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 4 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 67290 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
| 73911 | 254536 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 737 Buena Vista Ave West | 2 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 74277 | 251372 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 Masonic Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779800 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | |
| 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 | ||||||
| 88761 | 111358 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1637 OAK ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x15 | 5999143 | 2109364 | 37.7718615511814 | -122.446362505197 | (37.7718615511814, -122.446362505197) | 15 | 5 | 11 | 29492 | 9 | ||||
| 89139 | 111359 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1637 OAK ST | 2 | Front Yard : Yard | Tree | Private 2 | 3x15 | 5999143 | 2109364 | 37.7718615511814 | -122.446362505197 | (37.7718615511814, -122.446362505197) | 15 | 5 | 11 | 29492 | 9 | ||||
| 103639 | 254535 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 737 Buena Vista Ave West | 1 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 107510 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | Front Yard : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399 | 2109002 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | 15 | 5 | 11 | 29492 | 9 | |
| 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 | ||||||
| 109929 | 254537 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 737 Buena Vista Ave West | 3 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
| 111048 | 113744 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 909 ASHBURY ST | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5999156 | 2107025 | 37.7654399906909 | -122.44614926226 | (37.7654399906909, -122.44614926226) | 15 | 5 | 11 | 29492 | 9 | ||||
| 123285 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1060 Clayton St | 1 | Front Yard : Yard | Tree | Private 2 | 99 | 5998985 | 2106259 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | 15 | 5 | 5 | 29492 | 9 | ||||
| 124217 | 109412 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 24 DELMAR ST | 1 | Front Yard : Yard | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774367 | 5999307.7 | 2108197.1 | 37.7686669444558 | -122.445708866914 | (37.7686669444558, -122.445708866914) | 15 | 5 | 11 | 29492 | 9 | |
| 125726 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 63 Potomac St | 1 | Front Yard : Yard | Tree | Private 2 | 4x4 | Permit Number 776311 | 6003081 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | 15 | 5 | 5 | 29492 | 9 | |||
| 145352 | 100578 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 35 Lloyd St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 56924 | 6002279.7 | 2108550 | 37.7698051576272 | -122.435454215606 | (37.7698051576272, -122.435454215606) | 15 | 5 | 5 | 29492 | 9 | ||||
| 160978 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 MASONIC AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | ||||
| 164452 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 731 CLAYTON ST | 1 | Front Yard : Cutout | Tree | Private 2 | 5998515 | 2108057 | 37.7682369747157 | -122.448440651351 | (37.7682369747157, -122.448440651351) | 15 | 5 | 11 | 29492 | 9 | |||||
| 172555 | 120560 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 76 | 17X Castro St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002113 | 2108564 | 37.7698341292575 | -122.436031827668 | (37.7698341292575, -122.436031827668) | 15 | 5 | 5 | 29492 | 9 | ||||
| 193192 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768767 | 5998994 | 2106195 | 37.7631517661679 | -122.446649857914 | (37.7631517661679, -122.446649857914) | 15 | 5 | 5 | 29492 | 9 | ||||
| 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 | ||||
| 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 | |||||
| 5702 | 121171 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 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 | ||||
| 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 | ||||
| 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 | ||||
| 25399 | 252916 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001472 | 2098865 | 37.7431665844065 | -122.437554349716 | (37.7431665844065, -122.437554349716) | 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 | |||
| 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 | ||||
| 32555 | 121168 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 95045 | 121170 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||||
| 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 | |
| 125742 | 121169 | Significant Tree 6 | Acacia spp :: Acacia Spp 105 | 900x Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 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 | |
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |
| 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 | ||||
| 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 | |||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 2213 | 261044 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
| 4419 | 260950 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
| 5983 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 131X Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.7962664536588 | -122.397554954018 | (37.7962664536588, -122.397554954018) | 3 | 1 | 10 | 28860 | 6 | |
| 9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
| 9433 | 261043 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||||
| 12731 | 107057 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 601X Davis St | 2 | Front Yard : Yard | Tree | Private 2 | 07/23/2014 12:00:00 AM | 9 | Permit Number 771755 | 6013145.32204 | 2118507.86888 | 37.7977582696821 | -122.398568926718 | (37.7977582696821, -122.398568926718) | 3 | 1 | 10 | 28860 | 6 | ||
| 13002 | 260949 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
| 16781 | 260951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 190 Jackson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6013038 | 2118237 | 37.7970085486816 | -122.398921272101 | (37.7970085486816, -122.398921272101) | 3 | 1 | 10 | 28860 | 6 | ||||
| 16794 | 261146 | Significant Tree 6 | Ficus Spp. :: 101 | 375x Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 3x3 | 6014494 | 2112212 | 37.780546313007 | -122.393461254196 | (37.780546313007, -122.393461254196) | 6 | 2 | 9 | 28856 | 6 | ||
| 16799 | 261042 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
| 18276 | 119614 | Significant Tree 6 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 2X Sutter St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012582 | 2115890 | 37.7905388243453 | -122.400334219916 | (37.7905388243453, -122.400334219916) | 4 | 1 | 10 | 28854 | 6 | ||||
| 18324 | 109414 | Significant Tree 6 | Persea americana :: Avocado 34 | 4 GUY PL | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6014378.1 | 2114502.6 | 37.7868293368446 | -122.394022608955 | (37.7868293368446, -122.394022608955) | 6 | 2 | 9 | 28855 | 6 | ||||
| 19052 | 260948 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 370 Drumm St | 1 | Side Yard : Yard | Tree | Private 2 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | |||||
| 40244 | 115123 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
| 45878 | 173675 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 464 | 299x Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 46337 | 115125 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
| 47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
| 48723 | 96186 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 3 | Sidewalk: Property side : | Tree | Private 2 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | 6 | 2 | 9 | 28855 | 6 | ||||
| 50152 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 54776 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | |
| 62378 | 173676 | Significant Tree 6 | Populus trichocarpa :: Black Cottonwood Poplar 464 | 299x Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 64053 | 96906 | Significant Tree 6 | Ulmus 'Frontier' :: Frontier Elm 115 | 1155@Sansome Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 08/05/2011 12:00:00 AM | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | ||
| 65204 | 100696 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 3 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 67051 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 2 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
| 67391 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 68704 | 173596 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 300 Howard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 779179 | 6014439 | 2115766 | 37.7903017260092 | -122.393900378517 | (37.7903017260092, -122.393900378517) | 12 | 2 | 9 | 28855 | 6 | |||
| 68737 | 104228 | Significant Tree 6 | Tree(s) :: 17 | 183 FREMONT ST | 1 | Front Yard : Yard | Tree | Private 2 | 4 | Permit Number 770922 | 6014038 | 2115456 | 37.7894282446126 | -122.395266095466 | (37.7894282446126, -122.395266095466) | 12 | 2 | 9 | 28855 | 6 | |||
| 70762 | 100699 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 6 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 73225 | 100695 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 2 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 76886 | 106942 | Significant Tree 6 | Tree(s) :: 17 | 1300@ Embarcadero Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 07/02/2014 12:00:00 AM | Permit Number 772680 | 6012231.9986 | 2120618.97397 | 37.8035039293343 | -122.401877773891 | (37.8035039293343, -122.401877773891) | 3 | 1 | 10 | 28860 | 6 | |||
| 84386 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1155@Sansome Battery St | 3 | Front Yard : Yard | Tree | Private 2 | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | |||
| 85061 | 255144 | Significant Tree 6 | Cupressus sempervirens :: Italian Cypress 204 | 101x Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013362 | 2113756 | 37.7847228211314 | -122.3974857221 | (37.7847228211314, -122.3974857221) | 6 | 2 | 9 | 28856 | 6 |
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) );