trees
8,298 rows where qLegalStatus_id = 4 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47222 | 113141 | Undocumented 4 | Tree(s) :: 17 | 140 BROADMOOR DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/09/2015 12:00:00 AM | 3x10 | Permit Number 776484 | 5990979 | 2092893 | 37.7261668163813 | -122.473400506865 | (37.7261668163813, -122.473400506865) | 9 | 8 | 4 | 64 | 40 | ||
120884 | 113311 | Undocumented 4 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 1001x Alemany Blvd | 10 | Front Yard : Yard | Tree | Private 2 | 11/09/2015 12:00:00 AM | 20 | Permit Number 776808 | 6003491.75626 | 2094313.44879 | 37.7307836910976 | -122.430245918511 | (37.7307836910976, -122.430245918511) | 9 | 7 | 6 | 28861 | 25 | ||
118132 | 114815 | Undocumented 4 | Tree(s) :: 17 | 160 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/08/2016 12:00:00 AM | 3 | 4x15 | Permit Number 778944 | 5995496 | 2095622 | 37.7339205232551 | -122.457982998117 | (37.7339205232551, -122.457982998117) | 9 | 7 | 4 | 59 | 40 | |
23205 | 81367 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.419830397182 | (37.7858955407321, -122.419830397182) | 13 | 9 | 9 | 28858 | 36 | |||
74696 | 81381 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.416883582419 | (37.7863320683098, -122.416883582419) | 13 | 1 | 9 | 28858 | 36 | ||
123482 | 112954 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 245 HYDE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776672 | 6008003 | 2113318 | 37.7832203349453 | -122.415995113119 | (37.7832203349453, -122.415995113119) | 7 | 10 | 9 | 28852 | 36 | |
87708 | 107363 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774080 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168 | (37.776492606048, -122.41850920168) | 7 | 9 | 9 | 28852 | 36 | |
95595 | 107364 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774080 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168 | (37.776492606048, -122.41850920168) | 7 | 9 | 9 | 28852 | 36 | |
119065 | 107361 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774080 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168 | (37.776492606048, -122.41850920168) | 7 | 9 | 9 | 28852 | 36 | |
131101 | 107360 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 80X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774080 | 6007226.39147 | 2110883.6872 | 37.776492606048 | -122.41850920168 | (37.776492606048, -122.41850920168) | 7 | 9 | 9 | 28852 | 36 | |
182518 | 78083 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 123 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2001 12:00:00 AM | 6 | 3x3 | 6007329.23459824 | 2109169.01236868 | 37.77179030673 | -122.418031852256 | (37.77179030673, -122.418031852256) | 8 | 2 | 9 | 28853 | 19 | ||
121516 | 109320 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 3110 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2015 12:00:00 AM | 7 | 3x3 | 6008224.7 | 2102742.2 | 37.7541941223175 | -122.414479525681 | (37.7541941223175, -122.414479525681) | 2 | 4 | 7 | 28859 | 19 | ||
127501 | 112899 | Undocumented 4 | Tree(s) :: 17 | 1558 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2015 12:00:00 AM | 3x3 | Permit Number 776673 | 6003283 | 2099119 | 37.7439668085187 | -122.431310523144 | (37.7439668085187, -122.431310523144) | 2 | 7 | 5 | 63 | 22 | ||
185196 | 97303 | Undocumented 4 | Tree(s) :: 17 | 671 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2015 12:00:00 AM | Permit Number 776719 | 5995291.2 | 2110994.9 | 37.7761188295556 | -122.459804215447 | (37.7761188295556, -122.459804215447) | 11 | 6 | 2 | 54 | 11 | |||
104620 | 101606 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 585X Mission Rock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2012 12:00:00 AM | 5x5 | Permit Number 769133 | 6015120.3 | 2109375.5 | 37.7727926961448 | -122.391096249158 | (37.7727926961448, -122.391096249158) | 14 | 3 | 9 | 310 | 20 | ||
162825 | 101608 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 585X Mission Rock St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2012 12:00:00 AM | 5x5 | Permit Number 769133 | 6015120.3 | 2109375.5 | 37.7727926961448 | -122.391096249158 | (37.7727926961448, -122.391096249158) | 14 | 3 | 9 | 310 | 20 | ||
174206 | 101607 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 585X Mission Rock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2012 12:00:00 AM | 5x5 | Permit Number 769133 | 6015120.3 | 2109375.5 | 37.7727926961448 | -122.391096249158 | (37.7727926961448, -122.391096249158) | 14 | 3 | 9 | 310 | 20 | ||
183209 | 101609 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 585X Mission Rock St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2012 12:00:00 AM | 5x5 | Permit Number 769133 | 6015120.3 | 2109375.5 | 37.7727926961448 | -122.391096249158 | (37.7727926961448, -122.391096249158) | 14 | 3 | 9 | 310 | 20 | ||
10 | 264794 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | 6011433 | 2091603 | 37.7237879639177 | -122.40260109208 | (37.7237879639177, -122.40260109208) | 10 | 3 | 7 | 309 | 28 | ||
61136 | 101619 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 896X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2013 12:00:00 AM | 7 | 3x3 | Permit Number 771029 | 6007773.9 | 2115454.2 | 37.7890729368167 | -122.416939111253 | (37.7890729368167, -122.416939111253) | 13 | 1 | 10 | 28858 | 21 | |
78451 | 255635 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 230 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2018 12:00:00 AM | 3 | 3x3 | 6008617 | 2109671 | 37.7732410413415 | -122.413612881642 | (37.7732410413415, -122.413612881642) | 8 | 2 | 9 | 28853 | 34 | ||
178575 | 96914 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | 2 | 4 | 5 | 28862 | 22 | |
52952 | 79881 | Undocumented 4 | Tree(s) :: 17 | 1607-1609 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2014 12:00:00 AM | 3 | Permit Number 773600 | 5997890.57004251 | 2108169.19987562 | 37.768509325571 | -122.450608572711 | (37.768509325571, -122.450608572711) | 15 | 5 | 11 | 29492 | 9 | ||
4231 | 261663 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1099x Broadway | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | 3x3 | 6008393 | 2118190 | 37.7966195766837 | -122.414990814528 | (37.7966195766837, -122.414990814528) | 5 | 1 | 10 | 308 | 21 | |||
24992 | 121225 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 217 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 2.5x2.5 | 5998931 | 2106888 | 37.7650509713906 | -122.446917623402 | (37.7650509713906, -122.446917623402) | 15 | 5 | 11 | 29492 | 9 | ||
62107 | 112956 | Undocumented 4 | Tree(s) :: 17 | 601x TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776687 | 6007104 | 2112858 | 37.7819067016043 | -122.419072660933 | (37.7819067016043, -122.419072660933) | 7 | 9 | 9 | 28852 | 36 | |
111878 | 113362 | Undocumented 4 | Tree(s) :: 17 | 115 CHESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2015 12:00:00 AM | 3x3 | Permit Number 776486 | 5991771 | 2088401 | 37.713878716515 | -122.470335649187 | (37.713878716515, -122.470335649187) | 9 | 8 | 6 | 64 | 24 | ||
192657 | 73935 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 98x LANDERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1984 12:00:00 AM | 13 | 3x3 | 6004473 | 2107480 | 37.7669915173508 | -122.427791394155 | (37.7669915173508, -122.427791394155) | 8 | 4 | 5 | 28862 | 3 | |
96558 | 256312 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 130x Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2018 12:00:00 AM | 3 | 3x3 | 6012090 | 2112540 | 37.781313061878 | -122.401800942778 | (37.781313061878, -122.401800942778) | 6 | 2 | 9 | 28856 | 34 | ||
148086 | 256313 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 130x Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2018 12:00:00 AM | 3 | 3x3 | 6012090 | 2112540 | 37.781313061878 | -122.401800942778 | (37.781313061878, -122.401800942778) | 6 | 2 | 9 | 28856 | 34 | ||
17663 | 101489 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 59X Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769087 | 6005416.7 | 2109221 | 37.7718252244657 | -122.424651142233 | (37.7718252244657, -122.424651142233) | 7 | 9 | 5 | 28852 | 10 | |
95736 | 95218 | Undocumented 4 | Tree(s) :: 17 | 165 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2013 12:00:00 AM | 3x3 | Permit Number 768358 | 6005920 | 2106290 | 37.7638058081441 | -122.422701865406 | (37.7638058081441, -122.422701865406) | 8 | 4 | 5 | 28859 | 19 | ||
128706 | 95219 | Undocumented 4 | Tree(s) :: 17 | 165 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2013 12:00:00 AM | 16 | 3x3 | Permit Number 768358 | 6005920 | 2106290 | 37.7638058081441 | -122.422701865406 | (37.7638058081441, -122.422701865406) | 8 | 4 | 5 | 28859 | 19 | |
159742 | 102303 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 767 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770010 | 6000230.9 | 2103020.8 | 37.7545067693378 | -122.442143982636 | (37.7545067693378, -122.442143982636) | 2 | 5 | 5 | 63 | 38 | |
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
155548 | 115216 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 3x3 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | ||
137787 | 104161 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 ALPINE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770750 | 6001664 | 2107990 | 37.7682325491861 | -122.437543793089 | (37.7682325491861, -122.437543793089) | 15 | 5 | 5 | 29492 | 3 | |
53906 | 98510 | Undocumented 4 | Tree(s) :: 17 | 1209 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 3x3 | Permit Number 775766 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||
98565 | 98512 | Undocumented 4 | Tree(s) :: 17 | 100 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.7238693046984 | -122.459376132933 | (37.7238693046984, -122.459376132933) | 9 | 8 | 4 | 28861 | 24 | |
99466 | 113974 | Undocumented 4 | Robinia pseudoacacia :: Black Locust 286 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 27 | 3x3 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||
164708 | 107122 | Undocumented 4 | Tree(s) :: 17 | 176 BOCANA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 30 | 5x5 | Permit Number 776353 | 6007240.7 | 2097996.8 | 37.7411089951967 | -122.417546147411 | (37.7411089951967, -122.417546147411) | 2 | 7 | 7 | 28859 | 2 | |
187968 | 98511 | Undocumented 4 | Tree(s) :: 17 | 1209 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2015 12:00:00 AM | 3x3 | Permit Number 775766 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||
72182 | 112670 | Undocumented 4 | Tree(s) :: 17 | 550 LAIDLEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | 32 | 3x3 | Permit Number 776473 | 6003040 | 2096024 | 37.735454877438 | -122.431929806462 | (37.735454877438, -122.431929806462) | 2 | 7 | 5 | 63 | 7 | |
116479 | 99752 | Undocumented 4 | Tree(s) :: 17 | 526 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | 3x3 | Permit Number 776170 | 6001772 | 2100900 | 37.748771266015 | -122.436662665796 | (37.748771266015, -122.436662665796) | 2 | 4 | 5 | 28862 | 22 | ||
18062 | 264811 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1420 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2020 12:00:00 AM | 3 | 3x3 | 6008504 | 2117376 | 37.7943907703496 | -122.414549098287 | (37.7943907703496, -122.414549098287) | 5 | 1 | 10 | 28857 | 21 | ||
3569 | 261071 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 58 Latona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014335 | 2094330 | 37.7314373487466 | -122.392759967745 | (37.7314373487466, -122.392759967745) | 10 | 3 | 8 | 58 | 1 | |
7364 | 261070 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 58 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014335 | 2094330 | 37.7314373487466 | -122.392759967745 | (37.7314373487466, -122.392759967745) | 10 | 3 | 8 | 58 | 1 | |
97245 | 232472 | Undocumented 4 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 2750 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2017 09:47:00 AM | 3 | Width 3ft | 6009625.91688 | 2105498.46406 | 37.7618408202315 | -122.409828298434 | (37.7618408202315, -122.409828298434) | 8 | 4 | 8 | 28859 | 19 | ||
140034 | 95413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523 | 2095666 | 37.7344425689427 | -122.433691689524 | (37.7344425689427, -122.433691689524) | 2 | 7 | 5 | 63 | 7 | |
12392 | 97505 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
172121 | 97504 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
57563 | 104225 | Undocumented 4 | Tree(s) :: 17 | 177-181 FREMONT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770360 | 6013988 | 2115552 | 37.7896890574628 | -122.395445819371 | (37.7896890574628, -122.395445819371) | 12 | 2 | 9 | 28855 | 6 | |
100053 | 104222 | Undocumented 4 | Tree(s) :: 17 | 177-181 FREMONT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770360 | 6013988 | 2115552 | 37.7896890574628 | -122.395445819371 | (37.7896890574628, -122.395445819371) | 12 | 2 | 9 | 28855 | 6 | |
108387 | 104221 | Undocumented 4 | Tree(s) :: 17 | 177-181 FREMONT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770360 | 6013988 | 2115552 | 37.7896890574628 | -122.395445819371 | (37.7896890574628, -122.395445819371) | 12 | 2 | 9 | 28855 | 6 | |
125181 | 104223 | Undocumented 4 | Tree(s) :: 17 | 177-181 FREMONT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770360 | 6013988 | 2115552 | 37.7896890574628 | -122.395445819371 | (37.7896890574628, -122.395445819371) | 12 | 2 | 9 | 28855 | 6 | |
146041 | 104224 | Undocumented 4 | Tree(s) :: 17 | 177-181 FREMONT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770360 | 6013988 | 2115552 | 37.7896890574628 | -122.395445819371 | (37.7896890574628, -122.395445819371) | 12 | 2 | 9 | 28855 | 6 | |
193894 | 107703 | Undocumented 4 | Tree(s) :: 17 | 41 Hill St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773950 | 6006079.45841 | 2103417.96835 | 37.7559288760699 | -122.421946314733 | (37.7559288760699, -122.421946314733) | 2 | 4 | 5 | 28859 | 19 | ||
182969 | 97491 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Miramar Ave | 6 | Median : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 30 | 15x280 | Permit Number 768370 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.458022688068 | (37.7258701708071, -122.458022688068) | 9 | 7 | 4 | 28861 | 40 | |
119767 | 84504 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 650X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.7755755804602 | -122.410668559049 | (37.7755755804602, -122.410668559049) | 8 | 2 | 9 | 28853 | 34 | |
128208 | 84505 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 650 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.7755755804602 | -122.410668559049 | (37.7755755804602, -122.410668559049) | 8 | 2 | 9 | 28853 | 34 | |
25561 | 101710 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
95460 | 118310 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
91161 | 79439 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 4 | 2x3 | Permit Number 49769 | 6004809.08231089 | 2110052.92705889 | 37.7740751590965 | -122.426812191246 | (37.7740751590965, -122.426812191246) | 7 | 9 | 11 | 28852 | 10 | |
168177 | 181059 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | 9 | 7 | 6 | 28861 | 25 | ||
142546 | 121226 | Undocumented 4 | Tree(s) :: 17 | 485 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778977 | 5995193 | 2098174 | 37.7409102741074 | -122.4592152915 | (37.7409102741074, -122.4592152915) | 1 | 8 | 4 | 59 | 40 | |
33811 | 102328 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3201X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | 2 | 4 | 7 | 28859 | 19 | |
87209 | 102349 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
90268 | 102346 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
114787 | 102331 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3201X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | 2 | 4 | 7 | 28859 | 19 | |
145183 | 102351 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
150325 | 102339 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
163235 | 102320 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3200X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6008156.4 | 2105059 | 37.760551689018 | -122.414879686077 | (37.760551689018, -122.414879686077) | 2 | 4 | 7 | 28859 | 19 | |
165592 | 102350 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
84284 | 74526 | Undocumented 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1190X Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1995 12:00:00 AM | 6011188.26118785 | 2118621.30079081 | 37.7979605016561 | -122.405348925503 | (37.7979605016561, -122.405348925503) | 3 | 1 | 10 | 308 | 23 | ||||
9014 | 261225 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2111 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | 4x6 | 5982897 | 2100735 | 37.7472274959484 | -122.501919055433 | (37.7472274959484, -122.501919055433) | 1 | 8 | 3 | 29491 | 35 | ||
2168 | 254831 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
15387 | 254816 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2687 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5997223 | 2088538 | 37.7145686012354 | -122.451501477097 | (37.7145686012354, -122.451501477097) | 9 | 8 | 6 | 28861 | 24 | ||
16017 | 254863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
17023 | 254832 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
17824 | 254830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
5119 | 254683 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:28:00 PM | 3 | 3x3 | 5999858 | 2092352 | 37.7251915169836 | -122.442667568748 | (37.7251915169836, -122.442667568748) | 9 | 7 | 6 | 28861 | 25 | ||
5077 | 254635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5330 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:21:00 PM | 3 | 3x3 | 5999632 | 2088389 | 37.7142971380253 | -122.443164330284 | (37.7142971380253, -122.443164330284) | 9 | 7 | 6 | 28861 | 25 | ||
107536 | 254913 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4650 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:11:00 PM | 3 | 4x4 | 6001829 | 2091729 | 37.7235930609595 | -122.435809477936 | (37.7235930609595, -122.435809477936) | 9 | 7 | 6 | 28861 | 25 | ||
93852 | 110586 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 151 EDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x10 | 5996558 | 2106132 | 37.7628393335165 | -122.45507056335 | (37.7628393335165, -122.45507056335) | 15 | 5 | 11 | 29492 | 12 | |||
49173 | 94915 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1922 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2010 12:00:00 AM | 16 | 5993509.6 | 2102385.8 | 37.752377883346 | -122.465341688659 | (37.752377883346, -122.465341688659) | 1 | 8 | 4 | 29491 | 12 | |||
184452 | 255734 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301x Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2018 11:59:00 AM | 3 | 3x5 | 6004745 | 2093607 | 37.7289148453459 | -122.425862986743 | (37.7289148453459, -122.425862986743) | 9 | 7 | 6 | 28861 | 5 | ||
6616 | 116997 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 ROSEMONT PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778206 | 6005158 | 2108058 | 37.7686172926755 | -122.425463223206 | (37.7686172926755, -122.425463223206) | 8 | 4 | 5 | 28853 | 19 | |
153868 | 102841 | Undocumented 4 | Tree(s) :: 17 | 5 Canyon Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2013 12:00:00 AM | Permit Number 770737 | 6003515 | 2086316 | 37.7088257745465 | -122.429595407579 | (37.7088257745465, -122.429595407579) | 9 | 7 | 6 | 28861 | 5 | |||
110296 | 113585 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 536 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2015 12:00:00 AM | 15x6 | 5998642 | 2106082 | 37.7628213832292 | -122.447859166975 | (37.7628213832292, -122.447859166975) | 15 | 5 | 11 | 29492 | 9 | |||
120336 | 113147 | Undocumented 4 | Tree(s) :: 17 | 400X KENWOOD WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2015 12:00:00 AM | 3x2 | Permit Number 776488 | 5993487 | 2093680 | 37.7284726384367 | -122.464787687548 | (37.7284726384367, -122.464787687548) | 9 | 8 | 4 | 59 | 40 | ||
108657 | 107074 | Undocumented 4 | Tree(s) :: 17 | 1861X 03RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 60x3 | Permit Number 773144 | 6015696 | 2106749 | 37.7656128312083 | -122.388921414698 | (37.7656128312083, -122.388921414698) | 14 | 3 | 9 | 310 | 29 | |
126168 | 107073 | Undocumented 4 | Tree(s) :: 17 | 1861X 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x60 | Permit Number 773144 | 6015696 | 2106749 | 37.7656128312083 | -122.388921414698 | (37.7656128312083, -122.388921414698) | 14 | 3 | 9 | 310 | 29 | |
172772 | 107071 | Undocumented 4 | Tree(s) :: 17 | 400X MARIPOSA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 20x6 | Permit Number 773144 | 6015842 | 2106286 | 37.7643496247585 | -122.38838411004 | (37.7643496247585, -122.38838411004) | 14 | 3 | 8 | 28856 | 29 | |
188742 | 107075 | Undocumented 4 | Tree(s) :: 17 | 1861 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 60x3 | Permit Number 773144 | 6015696 | 2106749 | 37.7656128312083 | -122.388921414698 | (37.7656128312083, -122.388921414698) | 14 | 3 | 9 | 310 | 29 | |
151553 | 117101 | Undocumented 4 | Tree(s) :: 17 | 677 ULLOA ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778379 | 5994251 | 2098113 | 37.7406885817292 | -122.462467930722 | (37.7406885817292, -122.462467930722) | 1 | 8 | 4 | 59 | 40 | |
30592 | 113545 | Undocumented 4 | Tree(s) :: 17 | 506 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776372 | 6003243 | 2098954.2 | 37.7435120389705 | -122.431437071725 | (37.7435120389705, -122.431437071725) | 2 | 7 | 5 | 63 | 22 | ||
99897 | 113549 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4500X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776494 | 6001307.45082 | 2104071.52181 | 37.7574530911412 | -122.438496273023 | (37.7574530911412, -122.438496273023) | 2 | 4 | 5 | 28862 | 3 | ||
137877 | 112158 | Undocumented 4 | Tree(s) :: 17 | 506 29TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776372 | 6003242 | 2098975 | 37.7435690942717 | -122.431442014019 | (37.7435690942717, -122.431442014019) | 2 | 7 | 5 | 63 | 22 | ||
150097 | 113550 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4500X 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776494 | 6001307.45082 | 2104071.52181 | 37.7574530911412 | -122.438496273023 | (37.7574530911412, -122.438496273023) | 2 | 4 | 5 | 28862 | 3 | ||
139874 | 97392 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 907 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936 | 2101462 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | 2 | 4 | 5 | 28862 | 22 |
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) );