trees
416 rows where Police Districts = 8 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76029 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5987665 | 2090646 | 37.7198046658936 | -122.484691919383 | (37.7198046658936, -122.484691919383) | 1 | 8 | 4 | 64 | 14 | ||||
76411 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 317 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
76823 | 255913 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 121 San Marcos Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5993694 | 2100263 | 37.7465598483618 | -122.464549884035 | (37.7465598483618, -122.464549884035) | 1 | 8 | 4 | 29491 | 40 | ||||
78664 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 23x PINTO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 5988521 | 2090808 | 37.7202992922588 | -122.481744923362 | (37.7202992922588, -122.481744923362) | 1 | 8 | 4 | 64 | 14 | ||||
81276 | 114097 | Significant Tree 6 | Pinus thunbergii :: Japanese Black Pine 207 | 221x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5987664 | 2090556 | 37.7195574904968 | -122.484688777519 | (37.7195574904968, -122.484688777519) | 1 | 8 | 4 | 64 | 14 | ||||
81747 | 107245 | Significant Tree 6 | Tree(s) :: 17 | 140 CEDRO AVE | Front Yard : Yard | Tree | Private 2 | 5991993.7 | 2093259.3 | 37.7272312918526 | -122.469919436342 | (37.7272312918526, -122.469919436342) | 9 | 8 | 4 | 59 | 40 | ||||||
81780 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288 | (37.712360795684, -122.45981072288) | 9 | 8 | 6 | 28861 | 24 | |
81808 | 114407 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 500X ARBALLO DR | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
81883 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.46484 | 37.7328958169551 | -122.491498163849 | (37.7328958169551, -122.491498163849) | 1 | 8 | 4 | 64 | 35 | |||
81897 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
82758 | 106514 | Significant Tree 6 | Tree(s) :: 17 | 190 EUCALYPTUS DR | 2 | Front Yard : Yard | Tree | Private 2 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | 1 | 8 | 4 | 64 | 40 | |||||
82975 | 255461 | Significant Tree 6 | Tree(s) :: 17 | 37 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 10x6 | Permit Number 777804 | 5994021.13024 | 2097608.02637 | 37.7392888101295 | -122.463226093964 | (37.7392888101295, -122.463226093964) | 1 | 8 | 4 | 59 | 40 | |
83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
83312 | 254136 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1623 47th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x6 | Permit Number 781075 | 5981544 | 2104016 | 37.7561566229771 | -122.506840869024 | (37.7561566229771, -122.506840869024) | 1 | 8 | 3 | 56 | 35 | |||
84029 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 273 Magellan Ave | 5 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
84393 | 116534 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 3 | 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 | |
84826 | 174950 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 309 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987294 | 2096147 | 37.7348873783654 | -122.486377975564 | (37.7348873783654, -122.486377975564) | 1 | 8 | 3 | 64 | 35 | ||||
85339 | 115176 | Significant Tree 6 | Tree(s) :: 17 | 460 Pacheco St | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10x10 | Permit Number 775764 | 5993727.4 | 2101897.6 | 37.7510499693469 | -122.464553061226 | (37.7510499693469, -122.464553061226) | 1 | 8 | 4 | 29491 | 12 | ||
89112 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1327 ULLOA ST | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | 1 | 8 | 4 | 59 | 40 | ||
89539 | 112250 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 243 WINSTON DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990059 | 2093141 | 37.7267944442094 | -122.476598971146 | (37.7267944442094, -122.476598971146) | 1 | 8 | 4 | 64 | 14 | ||||
90582 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 42 | 5993401 | 2098089 | 37.7405736985828 | -122.465405140197 | (37.7405736985828, -122.465405140197) | 1 | 8 | 4 | 59 | 40 | ||||
91742 | 114074 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 18x HIGUERA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
91798 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
92153 | 117518 | Significant Tree 6 | Ulmus americana :: American Elm 74 | 30 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | Permit Number 777803 | 5993995.8 | 2097679.6 | 37.7394838741894 | -122.463318866351 | (37.7394838741894, -122.463318866351) | 1 | 8 | 4 | 59 | 40 | ||
92424 | 254257 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
92766 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 5990818 | 2089012 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | 1 | 8 | 4 | 64 | 14 | |||
92919 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | |
93552 | 104749 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 1 | 8 | 4 | 64 | 14 | ||||
94162 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
94421 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
94784 | 253250 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99X Lopez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
95053 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard | Tree | Private 2 | 19 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
95436 | 104406 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 290 Stonecrest Dr | 1 | Back Yard : Yard | Tree | Private 2 | 36 | Permit Number 770927 | 5990725 | 2092655 | 37.7254986161427 | -122.474261202586 | (37.7254986161427, -122.474261202586) | 9 | 8 | 4 | 64 | 40 | |||
95557 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
95583 | 102077 | Significant Tree 6 | Ulmus glabra :: Scotch Elm 531 | 273 Magellan Ave | 7 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
95967 | 254201 | Significant Tree 6 | Tree(s) :: 17 | 55X Aerial Way | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781191 | 5992360 | 2102538 | 37.7527294198072 | -122.469328234463 | (37.7527294198072, -122.469328234463) | 1 | 8 | 4 | 56 | 12 | |||
96414 | 114394 | Significant Tree 6 | Ficus Spp. :: 101 | 134x TAPIA DR | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
96682 | 115070 | Significant Tree 6 | :: 45 | 401 DARIEN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5992724 | 2094938 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | 9 | 8 | 4 | 59 | 40 | ||||
96718 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | 1 | 8 | 4 | 59 | 40 | ||
97021 | 105907 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 1837 30TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 5986904 | 2102674 | 37.7527860393128 | -122.488205804709 | (37.7527860393128, -122.488205804709) | 1 | 8 | 3 | 56 | 35 | ||||
97746 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
98635 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | 1 | 8 | 4 | 64 | 14 | |||||
98944 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 301X Sargent St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5993018 | 2089140 | 37.7159798527116 | -122.466079257059 | (37.7159798527116, -122.466079257059) | 9 | 8 | 6 | 64 | 24 | ||||
99362 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991942 | 2105939 | 37.7620435090796 | -122.471021481615 | (37.7620435090796, -122.471021481615) | 1 | 8 | 11 | 56 | 12 | |||||
99609 | 96481 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
99854 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 310 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
101005 | 104736 | Significant Tree 6 | Lagunaria patersonii :: Primrose Tree 6 | 1499X 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770763 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.503718978789 | (37.7595862228156, -122.503718978789) | 1 | 8 | 3 | 56 | 35 | ||||
101112 | 110321 | Significant Tree 6 | Ilex opaca :: American Holly 473 | 1x SAN PABLO AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774750 | 5994773 | 2097898 | 37.740128291439 | -122.460647489756 | (37.740128291439, -122.460647489756) | 9 | 8 | 4 | 59 | 40 | ||
101814 | 110427 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1860 09TH AVE | 2 | Front Yard : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775447 | 5993494 | 2102835 | 37.7536103714224 | -122.465428263995 | (37.7536103714224, -122.465428263995) | 1 | 8 | 4 | 56 | 12 | ||
101827 | 173631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99X Everglade Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5986361 | 2095495 | 37.7330427310611 | -122.489555709533 | (37.7330427310611, -122.489555709533) | 1 | 8 | 4 | 64 | 35 | ||||
101899 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
102524 | 258404 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
102526 | 100433 | Significant Tree 6 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 | 200X Stonecrest Dr | 3 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
102553 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 270 Castenada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
103685 | 248958 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 98x Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2017 12:00:00 AM | 3 | 3x3 | 5994824 | 2095658 | 37.7339807377795 | -122.460308897898 | (37.7339807377795, -122.460308897898) | 9 | 8 | 4 | 59 | 40 | ||
103743 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
104010 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 608 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
105349 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 296 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
105492 | 116536 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 5 | 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 | |
105498 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
105921 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.81974 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | 1 | 8 | 4 | 64 | 14 | ||
106522 | 102073 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 273 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
106870 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 2 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
107089 | 255281 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
107229 | 255805 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 333 | 2 Sola Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994994 | 2100719 | 37.7478867659483 | -122.460087684856 | (37.7478867659483, -122.460087684856) | 1 | 8 | 4 | 29491 | 40 | ||||
107818 | 98757 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 340 Castenada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5993579.1 | 2100062.8 | 37.7460035255592 | -122.464932655613 | (37.7460035255592, -122.464932655613) | 1 | 8 | 4 | 29491 | 40 | |||||
109420 | 114102 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 7 ACEVEDO AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
109646 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
109715 | 120932 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
110154 | 102074 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 273 Magellan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
110540 | 253952 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 11X Ravenwood Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x10 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | ||||
111294 | 255282 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
112272 | 105540 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 2694 47TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 5981878.3 | 2096771.8 | 37.7362857499502 | -122.505147911282 | (37.7362857499502, -122.505147911282) | 1 | 8 | 3 | 29491 | 35 | ||||
113390 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 837 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
114129 | 254093 | Significant Tree 6 | Tree(s) :: 17 | 716 Gonzalez Dr | 2 | Front Yard : Yard | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781051 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
114772 | 92311 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2211 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5986022.3 | 2100155.2 | 37.7458186185696 | -122.491069496457 | (37.7458186185696, -122.491069496457) | 1 | 8 | 3 | 29491 | 35 | |
115084 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard | Tree | Private 2 | 5989494 | 2090180 | 37.7186314952818 | -122.47833572412 | (37.7186314952818, -122.47833572412) | 1 | 8 | 4 | 64 | 14 | |||||
116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
117265 | 116346 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 121 SAN BENITO WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777164 | 5992901 | 2095856 | 37.7344135917102 | -122.466971633047 | (37.7344135917102, -122.466971633047) | 9 | 8 | 4 | 59 | 40 | |
117949 | 254767 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900x Moraga St | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5991390 | 2103897 | 37.7564047756354 | -122.47278171886 | (37.7564047756354, -122.47278171886) | 1 | 8 | 4 | 56 | 12 | ||||
119656 | 114409 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 500X ARBALLO DR | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
120070 | 253809 | Significant Tree 6 | Tree(s) :: 17 | 2 Garfield St | 3 | Side Yard : Yard | Tree | Private 2 | 09/14/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |
120116 | 116009 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 199x SAN BUENAVENTURA WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777954 | 5993547 | 2095667 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | 9 | 8 | 4 | 59 | 40 | |
120316 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 URBANO DR | 1 | Front Yard : Yard | Tree | Private 2 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | 9 | 8 | 4 | 59 | 40 | ||||
122278 | 106109 | Significant Tree 6 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | |||
123466 | 254110 | Significant Tree 6 | Tree(s) :: 17 | 100 Cerritos Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781003 | 5992103 | 2092952 | 37.7263938396388 | -122.469519230239 | (37.7263938396388, -122.469519230239) | 9 | 8 | 4 | 59 | 40 | |
124067 | 96482 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
124365 | 116951 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 299 Tara St | 1 | Front Yard : Yard | Tree | Private 2 | 5997754 | 2090179.6 | 37.7191064490611 | -122.449784366221 | (37.7191064490611, -122.449784366221) | 9 | 8 | 6 | 28861 | 24 | |||||
124516 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 24 | 5993401 | 2098089 | 37.7405736985828 | -122.465405140197 | (37.7405736985828, -122.465405140197) | 1 | 8 | 4 | 59 | 40 | ||||
124817 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
125248 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 230 Lakeview Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | 9 | 8 | 6 | 28861 | 24 | |||||
125330 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 717 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990427 | 2090598 | 37.7198333383806 | -122.475141254145 | (37.7198333383806, -122.475141254145) | 1 | 8 | 4 | 64 | 40 | |||||
125509 | 254393 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 150 Granville Way | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994538 | 2098550 | 37.7419049979895 | -122.461507275162 | (37.7419049979895, -122.461507275162) | 1 | 8 | 4 | 59 | 40 | ||||
125570 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 180 San Aleso Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319 | 2094440 | 37.7305497238902 | -122.465423653439 | (37.7305497238902, -122.465423653439) | 9 | 8 | 4 | 59 | 40 | ||
126137 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 839 Gonzalez Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990419 | 2090610 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | 1 | 8 | 4 | 64 | 40 | |||||
126287 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
126819 | 257966 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 98X Clearfield Dr | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 782748 | 5986022 | 2095487 | 37.7330009680725 | -122.490727117227 | (37.7330009680725, -122.490727117227) | 1 | 8 | 4 | 64 | 35 | |||
127076 | 104193 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 122 Arch St | 1 | Front Yard : Yard | Tree | Private 2 | 5992720.4 | 2088013.1 | 37.7128684825751 | -122.467026013031 | (37.7128684825751, -122.467026013031) | 9 | 8 | 6 | 64 | 24 |
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) );