trees
720 rows where qCaretaker_id = 5 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87213 | 100031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | 3 | 1 | 10 | 28857 | 21 | |
| 30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
| 153256 | 100033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 71695 | 100034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 143356 | 100035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 178352 | 100036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 151278 | 100037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 | |
| 167918 | 100783 | Permitted Site 7 | Tree(s) :: 17 | 2101X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 41196 | 100784 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 136224 | 100785 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 168525 | 100786 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
| 140698 | 100787 | Permitted Site 7 | Tree(s) :: 17 | 2001 Washington St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | |||||
| 97304 | 101311 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4244X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3x3 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
| 125985 | 101312 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 4244X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 4x4 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
| 163561 | 101313 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244X 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 14 | 5x6 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
| 116765 | 101314 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 4244X 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 4x4 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
| 83453 | 101511 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
| 44854 | 101512 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
| 29082 | 101513 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
| 114609 | 101514 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 240X DRUMM ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/30/2012 12:00:00 AM | 3x3 | Permit Number 769442 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||
| 55728 | 102159 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4300X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 34 | 6x6 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 | |||
| 51368 | 102161 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4300X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 5x5 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 | |||
| 50831 | 102162 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4300X 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 5x5 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 | |||
| 85542 | 10223 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296967 | (37.7491888788632, -122.42249296967) | 2 | 4 | 5 | 28859 | 19 | |||
| 68892 | 102368 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4 | Permit Number 769895 | 5984151.13176 | 2110133.93549 | 37.7731079279349 | -122.49827649972 | (37.7731079279349, -122.49827649972) | 11 | 6 | 2 | 55 | 26 | |||
| 46680 | 102369 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | Permit Number 769895 | 5984151.59861 | 2110096.53732 | 37.773005270668 | -122.498272122211 | (37.773005270668, -122.498272122211) | 11 | 6 | 2 | 55 | 26 | |||
| 123981 | 102370 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | Permit Number 769895 | 5984153.18727 | 2110032.649 | 37.7728299448261 | -122.498261907462 | (37.7728299448261, -122.498261907462) | 11 | 6 | 2 | 55 | 26 | |||
| 56700 | 102371 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | Permit Number 769895 | 5984153.68011 | 2110075.48808 | 37.7729475975471 | -122.498263367238 | (37.7729475975471, -122.498263367238) | 11 | 6 | 2 | 55 | 26 | |||
| 86758 | 102372 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | Permit Number 769895 | 5984152.56349 | 2110057.09296 | 37.7728970243511 | -122.498265870843 | (37.7728970243511, -122.498265870843) | 11 | 6 | 2 | 55 | 26 | |||
| 12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
| 165276 | 102374 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | 11 | 6 | 2 | 55 | 26 | ||||
| 156162 | 102375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983887.37527 | 2110050.49294 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | 11 | 6 | 2 | 55 | 26 | ||||
| 25869 | 102376 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 5984157.51207 | 2109978.36457 | 37.7726811489417 | -122.498242937742 | (37.7726811489417, -122.498242937742) | 11 | 6 | 2 | 55 | 26 | ||||
| 72745 | 102377 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 5983889.8768 | 2109995.31333 | 37.7727119887219 | -122.499169955109 | (37.7727119887219, -122.499169955109) | 11 | 6 | 2 | 55 | 26 | ||||
| 120564 | 102378 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 5983886.84831 | 2110037.48525 | 37.7728276030319 | -122.499183547509 | (37.7728276030319, -122.499183547509) | 11 | 6 | 2 | 55 | 26 | ||||
| 164210 | 102379 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 5984156.57881 | 2110013.67242 | 37.7727780394481 | -122.49824877412 | (37.7727780394481, -122.49824877412) | 11 | 6 | 2 | 55 | 26 | ||||
| 101404 | 102516 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 4x4 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
| 109436 | 103168 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2200X Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 9 | 3x4 | 5987451.7241 | 2103743.616 | 37.7557548552633 | -122.486390221731 | (37.7557548552633, -122.486390221731) | 1 | 8 | 3 | 56 | 35 | |||
| 102250 | 103169 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2200X Moraga St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987326.2 | 2104050 | 37.7565887850833 | -122.486846816898 | (37.7565887850833, -122.486846816898) | 1 | 8 | 3 | 56 | 35 | ||||
| 84204 | 103170 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2200X Moraga St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987326.2 | 2104050 | 37.7565887850833 | -122.486846816898 | (37.7565887850833, -122.486846816898) | 1 | 8 | 3 | 56 | 35 | ||||
| 163628 | 103172 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2200X Moraga St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987326.2 | 2104050 | 37.7565887850833 | -122.486846816898 | (37.7565887850833, -122.486846816898) | 1 | 8 | 3 | 56 | 35 | ||||
| 104141 | 103173 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2200X Moraga St | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987326.2 | 2104050 | 37.7565887850833 | -122.486846816898 | (37.7565887850833, -122.486846816898) | 1 | 8 | 3 | 56 | 35 | ||||
| 184911 | 103174 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 66533 | 103176 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 28941 | 103177 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 182930 | 103178 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 160451 | 103179 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 3181 | 103180 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987448.1702 | 2104354.2995 | 37.7574314190685 | -122.486447346513 | (37.7574314190685, -122.486447346513) | 1 | 8 | 3 | 56 | 35 | |||
| 109051 | 103182 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987451.7241 | 2104232.2812 | 37.7570965971663 | -122.486426097572 | (37.7570965971663, -122.486426097572) | 1 | 8 | 3 | 56 | 35 | |||
| 189458 | 103183 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987454.6857 | 2104156.4641 | 37.7568885966535 | -122.486410289114 | (37.7568885966535, -122.486410289114) | 1 | 8 | 3 | 56 | 35 | |||
| 95010 | 103184 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987458.2396 | 2104042.7384 | 37.75657654394 | -122.4863896493 | (37.75657654394, -122.4863896493) | 1 | 8 | 3 | 56 | 35 | |||
| 34134 | 103185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
| 11538 | 103186 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
| 182547 | 103187 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 161814 | 103189 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987449.3548 | 2104293.8827 | 37.7572656000244 | -122.486438814059 | (37.7572656000244, -122.486438814059) | 1 | 8 | 3 | 56 | 35 | |||
| 48907 | 103190 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 4 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987454.6857 | 2104172.4568 | 37.7569325082599 | -122.486411463243 | (37.7569325082599, -122.486411463243) | 1 | 8 | 3 | 56 | 35 | |||
| 50955 | 103191 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 6 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 10 | 3x4 | 5987457.055 | 2104097.8243 | 37.7567277258047 | -122.486397790192 | (37.7567277258047, -122.486397790192) | 1 | 8 | 3 | 56 | 35 | |||
| 176040 | 103192 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 9 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
| 51939 | 103193 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 11 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 10 | 3x4 | 5987467.1245 | 2103820.0255 | 37.7559655526687 | -122.486342572342 | (37.7559655526687, -122.486342572342) | 1 | 8 | 3 | 56 | 35 | |||
| 116119 | 103194 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 13 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 154020 | 103195 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 14 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 34971 | 103197 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 15 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 130942 | 103198 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 17 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 20308 | 103199 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 19 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 193276 | 103200 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 21 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 80269 | 103201 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 132568 | 103203 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 176401 | 103204 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 47944 | 103206 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 3x4 | 5987202.3567 | 2103753.0931 | 37.7557663384655 | -122.487253298879 | (37.7557663384655, -122.487253298879) | 1 | 8 | 3 | 56 | 35 | |||
| 183895 | 103207 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987194.6566 | 2103923.6817 | 37.7562342793419 | -122.487292457342 | (37.7562342793419, -122.487292457342) | 1 | 8 | 3 | 56 | 35 | |||
| 66825 | 103208 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987188.7333 | 2104102.5628 | 37.7567250927297 | -122.487326080643 | (37.7567250927297, -122.487326080643) | 1 | 8 | 3 | 56 | 35 | |||
| 108426 | 103209 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987181.0332 | 2104341.2684 | 37.7573800642158 | -122.487370243421 | (37.7573800642158, -122.487370243421) | 1 | 8 | 3 | 56 | 35 | |||
| 63301 | 103211 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 147279 | 103212 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 26553 | 103213 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 114864 | 103214 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 110769 | 103215 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 148065 | 103217 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 111600 | 103218 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987199.9875 | 2103809.956 | 37.7559223303718 | -122.487265668637 | (37.7559223303718, -122.487265668637) | 1 | 8 | 3 | 56 | 35 | |||
| 9629 | 103219 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987198.2105 | 2103866.2266 | 37.7560767305116 | -122.487275946944 | (37.7560767305116, -122.487275946944) | 1 | 8 | 3 | 56 | 35 | |||
| 56794 | 103220 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 5 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987192.8796 | 2103980.5446 | 37.7563903057657 | -122.487302779252 | (37.7563903057657, -122.487302779252) | 1 | 8 | 3 | 56 | 35 | |||
| 78037 | 103221 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 6 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |
| 27281 | 103222 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987186.3641 | 2104162.3873 | 37.7568892163494 | -122.487338668246 | (37.7568892163494, -122.487338668246) | 1 | 8 | 3 | 56 | 35 | |||
| 46999 | 103223 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 9 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987183.9948 | 2104224.5811 | 37.7570598454095 | -122.487351430278 | (37.7570598454095, -122.487351430278) | 1 | 8 | 3 | 56 | 35 | |||
| 133374 | 103225 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 11 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 83945 | 103226 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 12 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 129527 | 103227 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 14 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 60944 | 103228 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 16 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 68153 | 103229 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 18 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 121935 | 103230 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 20 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 44827 | 103231 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 22 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 176118 | 103232 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 23 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 108854 | 104446 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 34779 | 104448 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 91676 | 104449 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 68698 | 104451 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 180626 | 105143 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | DPW for City Agency | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.7763091228737 | -122.424285011933 | (37.7763091228737, -122.424285011933) | 7 | 9 | 11 | 28852 | 10 | ||
| 24565 | 10586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.405321269139 | (37.7763811461579, -122.405321269139) | 14 | 2 | 9 | 28853 | 34 | |||
| 165495 | 105909 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1864X 14TH AVE | 1 | Median : Yard | Tree | Rec/Park 5 | 14 | 5991829 | 2102804 | 37.7534290869332 | -122.47118388852 | (37.7534290869332, -122.47118388852) | 1 | 8 | 4 | 56 | 12 |
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) );