trees
501 rows where PlotSize = "3x3" and 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
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 | ||||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
115 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000333 | 2099683 | 37.7453477932295 | -122.441551386161 | (37.7453477932295, -122.441551386161) | 2 | 7 | 5 | 63 | 22 | ||||
180 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 | |||
256 | 254254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
419 | 78519 | Significant Tree 6 | Tree(s) :: 17 | 12 Sumner St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | 6009421 | 2110873 | 37.7765865656959 | -122.410916638665 | (37.7765865656959, -122.410916638665) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||||
523 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | 1 | 8 | 3 | 29491 | 35 | ||
684 | 260585 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
703 | 262210 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2011 Bay Shore Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012422 | 2088364 | 37.7149494891568 | -122.398955034798 | (37.7149494891568, -122.398955034798) | 10 | 3 | 8 | 309 | 1 | ||||
748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | 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 | |||
821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | 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 | |||
1467 | 259815 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
1533 | 120590 | Significant Tree 6 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 | 52 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003308 | 2106220 | 37.7634658909933 | -122.43173097309 | (37.7634658909933, -122.43173097309) | 15 | 4 | 5 | 28862 | 3 | ||||
1697 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988223 | (37.7356241060746, -122.49141988223) | 1 | 8 | 3 | 29491 | 35 | ||
1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
1790 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 4187 26th St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 3x3 | 6002700 | 2100625 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | 2 | 4 | 5 | 63 | 22 | |||
1871 | 261422 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1110x Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
1901 | 262254 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 4210 Ocean Ave | 7 | 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 | |||
2175 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999834 | 2099740 | 37.7454758595085 | -122.443280934089 | (37.7454758595085, -122.443280934089) | 2 | 7 | 5 | 63 | 22 | |||
2183 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 5990450 | 2089482 | 37.7167704112637 | -122.474980331165 | (37.7167704112637, -122.474980331165) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||
2313 | 260963 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1100x Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
2591 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | 1 | 8 | 3 | 64 | 35 | ||
2657 | 260570 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
2713 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
2862 | 261320 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 872 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014869 | 2089377 | 37.7178670406836 | -122.390567842363 | (37.7178670406836, -122.390567842363) | 10 | 3 | 8 | 58 | 1 | |||||
3188 | 260646 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
3205 | 259817 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
3287 | 259814 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
3313 | 262482 | Significant Tree 6 | Tree(s) :: 17 | 45 Delta St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010254 | 2089941 | 37.7191585615903 | -122.406559656354 | (37.7191585615903, -122.406559656354) | 10 | 7 | 8 | 309 | 39 | ||||
3578 | 261993 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
3581 | 255621 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785157 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||||
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 | |||
4089 | 260964 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
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 | ||||
4567 | 261551 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 135 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994788 | 2095004 | 37.7321829429526 | -122.460385989231 | (37.7321829429526, -122.460385989231) | 9 | 8 | 4 | 59 | 40 | ||||
4630 | 261689 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
4938 | 260583 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
5239 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
5246 | 262331 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 2140 Wawona St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5986390 | 2097232 | 37.7378137677629 | -122.489583137449 | (37.7378137677629, -122.489583137449) | 1 | 8 | 3 | 29491 | 35 | ||||
5414 | 261208 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1131 Sutter St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2115019 | 37.7878442781586 | -122.418980353142 | (37.7878442781586, -122.418980353142) | 13 | 9 | 10 | 28858 | 21 | ||||
5577 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | 1 | 8 | 3 | 29491 | 35 | ||
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 | ||||
5792 | 260568 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
5905 | 261162 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 595 Newhall St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 6016024 | 2097656 | 37.7406635379999 | -122.387152626875 | (37.7406635379999, -122.387152626875) | 10 | 3 | 8 | 58 | 1 | |||
5928 | 260423 | Significant Tree 6 | Juniperus californica :: California juniper 295 | 237 Glenview Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998907 | 2100812 | 37.7483664070673 | -122.446563453195 | (37.7483664070673, -122.446563453195) | 2 | 5 | 5 | 63 | 38 | ||||
6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | 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 | |||
6111 | 260586 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
6121 | 260584 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 397 05th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
6370 | 261832 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 16 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995265 | 2100184 | 37.7464333732005 | -122.459111852123 | (37.7464333732005, -122.459111852123) | 1 | 8 | 4 | 59 | 40 | ||||
6413 | 259813 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
6430 | 260967 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
6519 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
6580 | 261206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Leavenworth St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
6612 | 259812 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
6691 | 256248 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 199x Clinton Park | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005490 | 2108162 | 37.7689216043545 | -122.424322258789 | (37.7689216043545, -122.424322258789) | 8 | 4 | 5 | 28853 | 19 | ||||
6915 | 116579 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
6931 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.7357012036342 | -122.491429290175 | (37.7357012036342, -122.491429290175) | 1 | 8 | 3 | 29491 | 35 | ||
7026 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150 Raccoon Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 36 | 3x3 | 5998776 | 2103987 | 37.7570766935068 | -122.447244922317 | (37.7570766935068, -122.447244922317) | 15 | 5 | 5 | 63 | 3 | |||
7245 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
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 | ||||
7698 | 259819 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
7767 | 262288 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1601 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015383 | 2097256 | 37.7395297026764 | -122.389341053483 | (37.7395297026764, -122.389341053483) | 10 | 3 | 8 | 58 | 1 | ||||
7835 | 258799 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 566 29th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
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 | ||||
8040 | 260572 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
8183 | 261995 | Significant Tree 6 | Phoenix spp :: Date palm (species unknown) 255 | 2727 Pierce St | 2 | Front Yard : Yard | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785198 | 6001553 | 2117834 | 37.7952553588401 | -122.438633170174 | (37.7952553588401, -122.438633170174) | 13 | 9 | 1 | 57 | 27 | |
8316 | 260638 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3140 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008726.17419 | 2101580.94088 | 37.7510337250786 | -122.412663209658 | (37.7510337250786, -122.412663209658) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
8580 | 261010 | Significant Tree 6 | Tree(s) :: 17 | 91 Parkridge Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784979 | 5998980 | 2102204 | 37.7521926688144 | -122.446411148664 | (37.7521926688144, -122.446411148664) | 2 | 5 | 5 | 63 | 38 | |
8743 | 261207 | Significant Tree 6 | Umbellularia californica :: California Bay 326 | 2301 Leavenworth St | 3 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
8751 | 262427 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
8787 | 260968 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2400x 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
8974 | 260925 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 1900 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5987961.4849 | 2103092.5821 | 37.7539969916819 | -122.484579575666 | (37.7539969916819, -122.484579575666) | 1 | 8 | 3 | 56 | 35 | ||||
9066 | 260960 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1001 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
9069 | 255620 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785157 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
9200 | 259821 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
9216 | 261431 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1110x Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
9303 | 259269 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
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 | ||||
9478 | 260514 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3025 22nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5989750.29916 | 2095052.76589 | 37.7320257582668 | -122.477805820702 | (37.7320257582668, -122.477805820702) | 1 | 8 | 4 | 64 | 35 | ||||
9510 | 260587 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 890x Harrison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6012019 | 2111820 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | 6 | 2 | 9 | 28856 | 34 | ||||
9703 | 264868 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 145 Guerrero St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6005490 | 2108162 | 37.7689216043545 | -122.424322258789 | (37.7689216043545, -122.424322258789) | 8 | 4 | 5 | 28853 | 19 | ||||
10025 | 264885 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1279 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 787806 | 5982392 | 2106415 | 37.7627934961857 | -122.504085938563 | (37.7627934961857, -122.504085938563) | 1 | 8 | 3 | 56 | 35 | |||
10119 | 261688 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1100x Vermont St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
10213 | 260647 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
10229 | 264894 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 56 Keystone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5994156 | 2093086 | 37.7268802074189 | -122.462431871086 | (37.7268802074189, -122.462431871086) | 9 | 8 | 4 | 28861 | 40 | ||||
10260 | 261386 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 31 Abbey St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6004642 | 2106187 | 37.7634508076606 | -122.427114742536 | (37.7634508076606, -122.427114742536) | 8 | 4 | 5 | 28862 | 3 | ||||
10271 | 262199 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 801 Sanchez St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003778 | 2103544 | 37.7561448640021 | -122.429914501498 | (37.7561448640021, -122.429914501498) | 2 | 4 | 5 | 28862 | 22 | ||||
10388 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
10910 | 120918 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305 | 2100249 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | 2 | 7 | 7 | 28859 | 2 | |
11014 | 262425 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
11254 | 259267 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
11442 | 260571 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
11444 | 261994 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 |
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) );