trees
1,732 rows where qLegalStatus_id = 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15674 | 258702 | Significant Tree 6 | Tree(s) :: 17 | 131X Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783241 | 5989556 | 2089774 | 37.7175203194228 | -122.478091750656 | (37.7175203194228, -122.478091750656) | 1 | 8 | 4 | 64 | 14 | |
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 | |||
15723 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | ||
15795 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
15911 | 105081 | Significant Tree 6 | :: 45 | 344 Fulton St | 1 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
15941 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 1 | unknown : Cutout | Tree | Private 2 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | ||||
15969 | 261831 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 1507 Cole St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5998279 | 2105297 | 37.7606452154312 | -122.449058098094 | (37.7606452154312, -122.449058098094) | 15 | 5 | 11 | 29492 | 12 | ||||
15980 | 262426 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
16010 | 260965 | Significant Tree 6 | Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 | 1100x Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
16021 | 260481 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
16043 | 260472 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 7 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
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 | ||||
16055 | 260578 | Significant Tree 6 | Tree(s) :: 17 | 1879 Funston Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 784834 | 5992075.37659 | 2102679.56742 | 37.7531016753032 | -122.470322812874 | (37.7531016753032, -122.470322812874) | 1 | 8 | 4 | 56 | 12 | |
16142 | 94943 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 | 2525 Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.7196157592662 | -122.38561332474 | (37.7196157592662, -122.38561332474) | 10 | 3 | 8 | 58 | 1 | ||||
16147 | 260471 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Masonic Ave | 6 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
16207 | 254459 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 4 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
16256 | 260911 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2035 15th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 5991575 | 2101572 | 37.7500316406912 | -122.471972478281 | (37.7500316406912, -122.471972478281) | 1 | 8 | 4 | 29491 | 12 | ||||
16260 | 260650 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
16292 | 262198 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 801 Sanchez St | 2 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003778 | 2103544 | 37.7561448640021 | -122.429914501498 | (37.7561448640021, -122.429914501498) | 2 | 4 | 5 | 28862 | 22 | ||||
16309 | 259807 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
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 | ||||
16536 | 259816 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
16652 | 258405 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 15 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
16717 | 262293 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002408 | 2117119 | 37.7933407549318 | -122.435623560602 | (37.7933407549318, -122.435623560602) | 13 | 9 | 1 | 29490 | 27 | ||||
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 | ||
17108 | 105086 | Significant Tree 6 | :: 45 | 344 Fulton St | 6 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
17188 | 260389 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 101 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x6 | 5993303.46118 | 2096918.61416 | 37.7373544866644 | -122.465657379584 | (37.7373544866644, -122.465657379584) | 1 | 8 | 4 | 59 | 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 | |
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
17264 | 260645 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3905 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
17369 | 260483 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
17429 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | 1 | 5 | 4 | 63 | 38 | |||
17502 | 260902 | Significant Tree 6 | Populus alba :: White Poplar 184 | 1901 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
17557 | 261982 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
17604 | 261710 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3555 16th St | 1 | Front Yard : Yard | Tree | Public Library 12 | 8x8 | 6003221.95473 | 2106496.25325 | 37.7642195378276 | -122.432048304209 | (37.7642195378276, -122.432048304209) | 15 | 4 | 5 | 28862 | 3 | ||||
17656 | 261984 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557 Bancroft Ave | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014517 | 2091967 | 37.7249591332222 | -122.391965574806 | (37.7249591332222, -122.391965574806) | 10 | 3 | 8 | 58 | 1 | |||||
17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
17902 | 113640 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
17941 | 258800 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 566 29th Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
17949 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
18002 | 261423 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2400x 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011254 | 2102764 | 37.7544236960072 | -122.404004933004 | (37.7544236960072, -122.404004933004) | 10 | 4 | 8 | 28859 | 19 | ||||
18011 | 262289 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1601 Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015383 | 2097256 | 37.7395297026764 | -122.389341053483 | (37.7395297026764, -122.389341053483) | 10 | 3 | 8 | 58 | 1 | ||||
18171 | 260058 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 6007818.52804 | 2111871.98583 | 37.7792395550969 | -122.416530850318 | (37.7792395550969, -122.416530850318) | 7 | 9 | 9 | 28852 | 36 | ||||
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 | ||||
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 | ||||
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 | ||||
18482 | 260468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 3 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
18519 | 260473 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 520 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
18601 | 262329 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
18661 | 259820 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
18680 | 262301 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2117 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000330 | 2116040 | 37.7902598573453 | -122.44273605224 | (37.7902598573453, -122.44273605224) | 13 | 6 | 1 | 29490 | 27 | ||||
18707 | 259811 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
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 | |||
18868 | 260249 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 260 | 10 Crestline Dr | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5999247 | 2101231 | 37.7495362941779 | -122.445417868856 | (37.7495362941779, -122.445417868856) | 2 | 5 | 5 | 63 | 38 | ||||
18899 | 261161 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 2452 Green St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001304 | 2118013 | 37.7957326780501 | -122.439507585878 | (37.7957326780501, -122.439507585878) | 13 | 9 | 1 | 57 | 17 | ||||
18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
18988 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
19027 | 260904 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4228 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 5993841 | 2112866 | 37.7811728620679 | -122.464956727678 | (37.7811728620679, -122.464956727678) | 11 | 6 | 2 | 54 | 11 | ||||
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 | |||||
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 | |||
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 | |||
19367 | 254458 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 3 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
19388 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
19453 | 261628 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3930 21st St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002255 | 2103579 | 37.7561545985327 | -122.435184046951 | (37.7561545985327, -122.435184046951) | 2 | 4 | 5 | 28862 | 3 | ||||
19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
19958 | 104685 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 7 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
20021 | 88145 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
20037 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 47 | 155 Winston Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990788 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | 9 | 8 | 4 | 64 | 40 | |||||
20043 | 116577 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 30 | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 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 | ||||
20184 | 108109 | Significant Tree 6 | Tree(s) :: 17 | 952 CAPP ST | 1 | Front Yard : Yard | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774355 | 6007364.7 | 2101732.3 | 37.7513728159016 | -122.417382061559 | (37.7513728159016, -122.417382061559) | 2 | 4 | 7 | 28859 | 19 | |
20207 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
20228 | 251632 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 14R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999202 | 2100044 | 37.7462745109784 | -122.445488137723 | (37.7462745109784, -122.445488137723) | 2 | 7 | 5 | 63 | 22 | |||||
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 | ||
20298 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 7 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
20385 | 251602 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 44R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999509 | 2100035 | 37.7462673204657 | -122.444425925791 | (37.7462673204657, -122.444425925791) | 2 | 7 | 5 | 63 | 22 | |||||
20461 | 104283 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 5 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | ||||
21303 | 115100 | Significant Tree 6 | Tree(s) :: 17 | 710 PACHECO ST | 1 | Front Yard : Cutout | Tree | Private 2 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777305 | 5992727 | 2102215 | 37.7518637464828 | -122.468035600741 | (37.7518637464828, -122.468035600741) | 1 | 8 | 4 | 29491 | 12 | |
21449 | 255662 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | Permit Number 782137 | 5998119 | 2105007 | 37.759839795982 | -122.44959056596 | (37.759839795982, -122.44959056596) | 15 | 5 | 11 | 29492 | 12 | |||
21577 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
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 | |||||
22018 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
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 | ||||
22296 | 113639 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
22312 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 2 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
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 | |||||
22679 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 862 Kansas St | Front Yard : Yard | Tree | Private 2 | Permit Number 774734 | 6011570 | 2104296 | 37.7586478799274 | -122.403019866682 | (37.7586478799274, -122.403019866682) | 10 | 3 | 8 | 28856 | 29 | |||||
22688 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
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 | |||||
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 |
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) );