trees
163,064 rows where qCaretaker_id = 2 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
131415 | 116747 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
156017 | 116748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
75289 | 16471 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
81962 | 16476 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
79494 | 102172 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
187812 | 102171 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
184600 | 115801 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 9M CAIRE TER | 1 | Front Yard : Yard | Tree | Private 2 | 6012720 | 2101959 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | 10 | 3 | 8 | 28856 | 29 | |||||
92681 | 115442 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
95648 | 115441 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
137554 | 115443 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
150284 | 115440 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
156023 | 115444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
6306 | 237343 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
9376 | 237344 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
17067 | 223124 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 99x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
102059 | 253188 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
108669 | 253189 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
125960 | 253190 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
144046 | 253187 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
156585 | 253184 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
160059 | 253185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
173231 | 253186 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
27792 | 121374 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
107285 | 121373 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
124117 | 121376 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
155774 | 121375 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 | |
98555 | 242320 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006209.1521 | 2102634.3543 | 37.75378456653 | -122.421442142453 | (37.75378456653, -122.421442142453) | 2 | 4 | 5 | 28859 | 19 | |||
178712 | 33745 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x SAN JOSE AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 10 | 4x4 | Permit Number 37802 | 6006338 | 2102697 | 37.7539638411405 | -122.421001003808 | (37.7539638411405, -122.421001003808) | 2 | 4 | 5 | 28859 | 19 | |
78499 | 255416 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
126056 | 255417 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
35312 | 251230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
116313 | 253374 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
153759 | 251232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
32266 | 108871 | Property Tree 8 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard | Tree | Private 2 | 6005305 | 2104962 | 37.7601247169433 | -122.424734485609 | (37.7601247169433, -122.424734485609) | 2 | 4 | 5 | 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 | ||||
109594 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 2 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
23573 | 60472 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |
157055 | 173704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |||
17186 | 110519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
92925 | 110520 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
136878 | 110521 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
139612 | 110517 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
149801 | 110518 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
150794 | 110522 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
24037 | 108406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.415540737233 | (37.7814172463574, -122.415540737233) | 7 | 10 | 9 | 28852 | 36 | |
47186 | 108408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.415516217226 | (37.7812898924571, -122.415516217226) | 7 | 10 | 9 | 28852 | 36 | |
84973 | 108407 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | 7 | 10 | 9 | 28852 | 36 | |
114952 | 108409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.7812331371452 | -122.415505707716 | (37.7812331371452, -122.415505707716) | 7 | 10 | 9 | 28852 | 36 | |
137011 | 108405 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581 | (37.7814823069089, -122.41555124581) | 7 | 10 | 9 | 28852 | 36 | |
149589 | 108410 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530315 | -122.415496951018 | (37.781198530315, -122.415496951018) | 7 | 10 | 9 | 28852 | 36 | |
59912 | 108412 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
82815 | 108411 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
115122 | 108413 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
135346 | 108414 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
8589 | 111310 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
86119 | 111312 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
89537 | 111311 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
19388 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
21577 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
27121 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
30455 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
44052 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | |||||
44804 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
62078 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 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 | ||||
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 | ||||
128045 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
141272 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
154745 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
173544 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
179418 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
185977 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
79400 | 32464 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | 15 | 5 | 5 | 28862 | 3 | ||
63560 | 254930 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
93694 | 254933 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
107777 | 254932 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3 | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | ||
136261 | 254931 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
122000 | 104507 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5998517 | 2087907 | 37.7129100350962 | -122.446983527065 | (37.7129100350962, -122.446983527065) | 9 | 7 | 6 | 28861 | 25 | |||
12772 | 111858 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
59455 | 111853 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | |||
71655 | 111854 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
94741 | 111857 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
120888 | 111855 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
178196 | 111856 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
139654 | 111669 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
145614 | 111670 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
96453 | 111065 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007219 | 2106804 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | 8 | 4 | 7 | 28853 | 19 | ||||
137179 | 111064 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007219 | 2106804 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | 8 | 4 | 7 | 28853 | 19 | |||
4451 | 209096 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99X Terrace Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 10ft | 5993033 | 2097048 | 37.7376941438167 | -122.466601883437 | (37.7376941438167, -122.466601883437) | 1 | 8 | 4 | 59 | 40 | |||
7800 | 209094 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99X Terrace Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993033 | 2097048 | 37.7376941438167 | -122.466601883437 | (37.7376941438167, -122.466601883437) | 1 | 8 | 4 | 59 | 40 | |||
10495 | 209095 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99X Terrace Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 10ft | 5993033 | 2097048 | 37.7376941438167 | -122.466601883437 | (37.7376941438167, -122.466601883437) | 1 | 8 | 4 | 59 | 40 | |||
52000 | 106170 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99X THOR AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6002346 | 2095994 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | 2 | 7 | 5 | 63 | 7 | |||
62177 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | 9 | 8 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );