trees
64 rows where Zip Codes = 28856 and qSpecies_id = 148
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
920 | 91853 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 601x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6014039.760938 | 2113573.418065 | 37.7842592071543 | -122.395128082808 | (37.7842592071543, -122.395128082808) | 6 | 2 | 9 | 28856 | 6 | ||
14266 | 104341 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2013 12:00:00 AM | 3x3 | Permit Number 770725 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | ||
19974 | 28151 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
28859 | 91843 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 9 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
29692 | 91848 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 7 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
31583 | 91851 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
34463 | 28181 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
35185 | 103088 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 256 SHIPLEY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011387 | 2111652 | 37.7788355638527 | -122.404170475964 | (37.7788355638527, -122.404170475964) | 14 | 2 | 9 | 28856 | 34 | ||||
35228 | 28154 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
36837 | 117955 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | |||
37977 | 91856 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 601x Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6014039.760938 | 2113573.418065 | 37.7842592071543 | -122.395128082808 | (37.7842592071543, -122.395128082808) | 6 | 2 | 9 | 28856 | 6 | ||
38534 | 91845 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 9 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
39391 | 28180 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
39483 | 28169 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
42580 | 28156 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
42673 | 28160 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
45913 | 28158 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
48060 | 91855 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 601x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6014039.760938 | 2113573.418065 | 37.7842592071543 | -122.395128082808 | (37.7842592071543, -122.395128082808) | 6 | 2 | 9 | 28856 | 6 | ||
49387 | 91787 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 974 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011579.201291 | 2111277.19318 | 37.7778171686355 | -122.403479195946 | (37.7778171686355, -122.403479195946) | 14 | 2 | 9 | 28856 | 34 | |||
53109 | 91850 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 7 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
55209 | 28153 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
55995 | 28163 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
60140 | 28161 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
64239 | 28155 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
68393 | 117958 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 851X HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012435 | 2111995 | 37.7798358648386 | -122.400569108585 | (37.7798358648386, -122.400569108585) | 6 | 2 | 9 | 28856 | 34 | |||
71285 | 28167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
73894 | 91794 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 700x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6013352.664153 | 2112972.090127 | 37.7825698655965 | -122.397463025411 | (37.7825698655965, -122.397463025411) | 6 | 2 | 9 | 28856 | 34 | ||
96005 | 28164 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
96202 | 28166 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
101235 | 28171 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
102046 | 28170 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
102329 | 91788 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 830X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012494.965717 | 2112152.388469 | 37.7802713613915 | -122.400372717325 | (37.7802713613915, -122.400372717325) | 6 | 2 | 9 | 28856 | 34 | ||
102486 | 91854 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 601x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6014039.760938 | 2113573.418065 | 37.7842592071543 | -122.395128082808 | (37.7842592071543, -122.395128082808) | 6 | 2 | 9 | 28856 | 6 | ||
104372 | 28148 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
105963 | 28174 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
106049 | 28162 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
107246 | 91840 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 895x Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012119.593271 | 2111738.315629 | 37.7791134735728 | -122.401642199835 | (37.7791134735728, -122.401642199835) | 6 | 2 | 9 | 28856 | 34 | |||
114306 | 28159 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
115901 | 91849 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 8 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
121480 | 91847 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
125080 | 28176 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
127194 | 91844 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
128110 | 28149 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
131734 | 91846 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
132236 | 91790 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 850 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 12 | 3x3 | 6012369.025423 | 2112032.027439 | 37.7799338540171 | -122.400799947263 | (37.7799338540171, -122.400799947263) | 6 | 2 | 9 | 28856 | 34 | ||
133379 | 28173 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
135328 | 91841 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 861X HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 10 | 3x3 | 6012389 | 2112023 | 37.7799101808503 | -122.400730211489 | (37.7799101808503, -122.400730211489) | 6 | 2 | 9 | 28856 | 34 | ||
137227 | 28179 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
139441 | 28175 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
139466 | 28152 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
139771 | 28165 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
144049 | 91791 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 850 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012369.025423 | 2112032.027439 | 37.7799338540171 | -122.400799947263 | (37.7799338540171, -122.400799947263) | 6 | 2 | 9 | 28856 | 34 | ||
146903 | 28150 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
153578 | 117959 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 851X HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012435 | 2111995 | 37.7798358648386 | -122.400569108585 | (37.7798358648386, -122.400569108585) | 6 | 2 | 9 | 28856 | 34 | |||
158393 | 91842 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 10 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | ||
159971 | 28168 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
165481 | 91792 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 880 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012180.114989 | 2111851.485898 | 37.7794275900263 | -122.401440784868 | (37.7794275900263, -122.401440784868) | 6 | 2 | 9 | 28856 | 34 | ||
166547 | 91852 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 699X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6013398.68241 | 2112960.74002 | 37.78254126295 | -122.397303024799 | (37.78254126295, -122.397303024799) | 6 | 2 | 9 | 28856 | 6 | ||
181552 | 91786 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 966 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2010 12:00:00 AM | 3 | 3x3 | 6011627.673411 | 2111323.517939 | 37.7779470730221 | -122.403314772772 | (37.7779470730221, -122.403314772772) | 14 | 2 | 9 | 28856 | 34 | |||
184248 | 28172 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
185510 | 28177 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
185588 | 28157 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
188561 | 28178 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
191802 | 28182 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 |
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) );