Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24234 | 24234 | 103219 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987198.2105 | 2103866.2266 | 37.7560767305116 | -122.48727594694401 | (37.7560767305116, -122.487275946944) | |||
| 27576 | 27576 | 103186 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 28004 | 28004 | 103180 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987448.1702 | 2104354.2995 | 37.757431419068496 | -122.486447346513 | (37.7574314190685, -122.486447346513) | |||
| 30617 | 30617 | 103185 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 32299 | 32299 | 103222 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987186.3641 | 2104162.3873 | 37.7568892163494 | -122.487338668246 | (37.7568892163494, -122.487338668246) | |||
| 38128 | 38128 | 88409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | |
| 40373 | 40373 | 37238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.755729192821704 | -122.48675431687 | (37.7557291928217, -122.48675431687) | ||
| 43434 | 43434 | 103190 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987454.6857 | 2104172.4568 | 37.7569325082599 | -122.486411463243 | (37.7569325082599, -122.486411463243) | |||
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 44221 | 44221 | 103193 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987467.1245 | 2103820.0255 | 37.755965552668705 | -122.486342572342 | (37.7559655526687, -122.486342572342) | |||
| 45897 | 45897 | 103220 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987192.8796 | 2103980.5446 | 37.756390305765706 | -122.48730277925199 | (37.7563903057657, -122.487302779252) | |||
| 46034 | 46034 | 103206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987202.3567 | 2103753.0931 | 37.7557663384655 | -122.487253298879 | (37.7557663384655, -122.487253298879) | |||
| 46862 | 46862 | 103223 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987183.9948 | 2104224.5811 | 37.7570598454095 | -122.487351430278 | (37.7570598454095, -122.487351430278) | |||
| 50310 | 50310 | 103191 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987457.055 | 2104097.8243 | 37.7567277258047 | -122.48639779019199 | (37.7567277258047, -122.486397790192) | |||
| 61312 | 61312 | 103208 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987188.7333 | 2104102.5628 | 37.7567250927297 | -122.487326080643 | (37.7567250927297, -122.487326080643) | |||
| 66520 | 66520 | 100031 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | |
| 68744 | 68744 | 103184 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987458.2396 | 2104042.7384 | 37.75657654394 | -122.48638964930001 | (37.75657654394, -122.4863896493) | |||
| 71729 | 71729 | 103221 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 11 | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |
| 74287 | 74287 | 103218 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987199.9875 | 2103809.956 | 37.755922330371796 | -122.48726566863701 | (37.7559223303718, -122.487265668637) | |||
| 77584 | 77584 | 103197 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 77843 | 77843 | 98421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 81037 | 81037 | 101512 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 81945 | 81945 | 98430 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||||
| 82149 | 82149 | 98423 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1501X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||
| 83356 | 83356 | 98424 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||||
| 83617 | 83617 | 103231 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 22 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 84664 | 84664 | 103228 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 87182 | 87182 | 103211 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 87206 | 87206 | 103229 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 88615 | 88615 | 100034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 90017 | 90017 | 103176 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 90745 | 90745 | 98428 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||||
| 92516 | 92516 | 101511 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 92526 | 92526 | 98417 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 92761 | 92761 | 103201 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 95184 | 95184 | 103170 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 95247 | 95247 | 103226 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 95392 | 95392 | 37236 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 98449 | 98449 | 103215 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 99261 | 99261 | 98426 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 99569 | 99569 | 98434 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
| 101074 | 101074 | 102516 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x4 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
| 101146 | 101146 | 103209 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987181.0332 | 2104341.2684 | 37.757380064215795 | -122.487370243421 | (37.7573800642158, -122.487370243421) | |||
| 101321 | 101321 | 103169 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 101740 | 101740 | 103168 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 9 | 3x4 | 5987451.7241 | 2103743.616 | 37.7557548552633 | -122.486390221731 | (37.7557548552633, -122.486390221731) | |||
| 103219 | 103219 | 103173 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 104711 | 104711 | 103230 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 106245 | 106245 | 98420 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||||
| 106827 | 106827 | 98419 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||||
| 107221 | 107221 | 103214 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 107523 | 107523 | 103198 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 108101 | 108101 | 103227 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 108349 | 108349 | 103203 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 109331 | 109331 | 103194 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 109942 | 109942 | 101514 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 240X DRUMM ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11/30/2012 12:00:00 AM | 3x3 | Permit Number 769442 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||
| 110740 | 110740 | 103217 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 111672 | 111672 | 103212 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 112616 | 112616 | 100037 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 113064 | 113064 | 103225 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 116126 | 116126 | 100035 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 117106 | 117106 | 98432 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
| 117327 | 117327 | 98429 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||||
| 118532 | 118532 | 98422 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1501X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | ||
| 118881 | 118881 | 103195 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 119345 | 119345 | 103179 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 120980 | 120980 | 100033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 121523 | 121523 | 103172 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987326.2 | 2104050.0 | 37.7565887850833 | -122.48684681689801 | (37.7565887850833, -122.486846816898) | ||||
| 123156 | 123156 | 98435 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1401X Steiner St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | ||
| 123574 | 123574 | 98418 | DPW Maintained 3 | Tree(s) :: 17 | 1501X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 124487 | 124487 | 100032 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | ||
| 124567 | 124567 | 103199 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 124904 | 124904 | 103177 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 125042 | 125042 | 98427 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | |||
| 126040 | 126040 | 103213 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 128867 | 128867 | 101513 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 133698 | 133698 | 103182 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987451.7241 | 2104232.2812 | 37.757096597166296 | -122.48642609757201 | (37.7570965971663, -122.486426097572) | |||
| 139442 | 139442 | 98425 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 140247 | 140247 | 103204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 140434 | 140434 | 103232 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 141545 | 141545 | 98431 | DPW Maintained 3 | Tree(s) :: 17 | 1401X Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | |||
| 142111 | 142111 | 103178 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142495 | 142495 | 103187 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 142733 | 142733 | 103174 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 144094 | 144094 | 100036 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 146286 | 146286 | 103200 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 165655 | 165655 | 103189 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987449.3548 | 2104293.8827 | 37.7572656000244 | -122.48643881405899 | (37.7572656000244, -122.486438814059) | |||
| 182553 | 182553 | 88408 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.794287243625604 | -122.411401815264 | (37.7942872436256, -122.411401815264) | |
| 182999 | 182999 | 103192 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 183697 | 183697 | 103183 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987454.6857 | 2104156.4641 | 37.756888596653496 | -122.486410289114 | (37.7568885966535, -122.486410289114) | |||
| 186533 | 186533 | 103207 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987194.6566 | 2103923.6817 | 37.756234279341896 | -122.487292457342 | (37.7562342793419, -122.487292457342) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");