Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98696 | 98696 | 11137 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 118702 | 118702 | 11141 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 121329 | 121329 | 11140 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 122047 | 122047 | 11138 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 50090 | 50090 | 13071 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
| 81488 | 81488 | 13074 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 91375 | 91375 | 13073 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 96845 | 96845 | 13075 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |
| 107446 | 107446 | 13077 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 645X Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 125041 | 125041 | 13072 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
| 83060 | 83060 | 116290 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 84099 | 84099 | 116291 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 88440 | 88440 | 116286 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 92543 | 92543 | 116287 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 94547 | 94547 | 116285 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 108909 | 108909 | 116293 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 111444 | 111444 | 116288 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 123347 | 123347 | 116289 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 139446 | 139446 | 116292 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 96202 | 96202 | 112131 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 106111 | 106111 | 112128 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 141984 | 141984 | 112129 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 144403 | 144403 | 112127 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 145495 | 145495 | 112130 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 80868 | 80868 | 116284 | Undocumented 2 | :: 54 | 700X Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 82559 | 82559 | 116276 | Undocumented 2 | :: 54 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 84777 | 84777 | 116279 | Undocumented 2 | :: 54 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 92470 | 92470 | 116283 | Undocumented 2 | :: 54 | 700X Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 98757 | 98757 | 116282 | Undocumented 2 | :: 54 | 700X Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 116105 | 116105 | 116281 | Undocumented 2 | :: 54 | 700X Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 117089 | 117089 | 116277 | Undocumented 2 | :: 54 | 700X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138269 | 138269 | 116274 | Undocumented 2 | :: 54 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138579 | 138579 | 116278 | Undocumented 2 | :: 54 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 140188 | 140188 | 116280 | Undocumented 2 | :: 54 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 141239 | 141239 | 116275 | Undocumented 2 | :: 54 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 93919 | 93919 | 96976 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 390X Filbert St | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 28 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 3904 | 3904 | 4665 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | |||
| 5145 | 5145 | 4664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009692.467999999 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | |||
| 7037 | 7037 | 4663 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | |||
| 8289 | 8289 | 4662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.41047535239099 | (37.8006133797513, -122.410475352391) | |||
| 6968 | 6968 | 4661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.41043136381901 | (37.8005811155969, -122.410431363819) | |||
| 7939 | 7939 | 4660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | |||
| 4255 | 4255 | 4659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.800489575353104 | -122.410288343699 | (37.8004895753531, -122.410288343699) | |||
| 7851 | 7851 | 4658 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 34 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | |||
| 7109 | 7109 | 18519 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.800340927010296 | -122.410812809398 | (37.8003409270103, -122.410812809398) | |||
| 81016 | 81016 | 27773 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 84542 | 84542 | 27772 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 88004 | 88004 | 27771 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 89735 | 89735 | 27770 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 105834 | 105834 | 27768 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 117568 | 117568 | 27769 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 7403 | 7403 | 107472 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1464 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6007706.0171300005 | 2117181.73808 | 37.793812512193604 | -122.417296448573 | (37.7938125121936, -122.417296448573) | |||
| 152223 | 152223 | 115560 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1464 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 9 | 3x3 | 6007697.45646 | 2117180.95447 | 37.793809878961895 | -122.417326013802 | (37.7938098789619, -122.417326013802) | |||
| 113933 | 113933 | 100787 | Permitted Site 1 | Tree(s) :: 17 | 2001 Washington St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | |||||
| 1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
| 79670 | 79670 | 100784 | Permitted Site 1 | Tree(s) :: 17 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | |||||
| 115457 | 115457 | 100785 | Permitted Site 1 | Tree(s) :: 17 | 2101 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | |||||
| 121557 | 121557 | 100783 | Permitted Site 1 | Tree(s) :: 17 | 2101X Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | |||||
| 123011 | 123011 | 100786 | Permitted Site 1 | Tree(s) :: 17 | 2101 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | |||||
| 81054 | 81054 | 2804 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 88529 | 88529 | 2808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3x3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 109159 | 109159 | 2806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 115677 | 115677 | 2805 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 65 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 126954 | 126954 | 2807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 139043 | 139043 | 2809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 35 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 87999 | 87999 | 9918 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1905X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | Permit Number 768908 | 6005198.982724099 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | ||
| 92525 | 92525 | 9919 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1905X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | Permit Number 768908 | 6005198.982724099 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | ||
| 97157 | 97157 | 9917 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1905X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3x3 | Permit Number 768908 | 6005198.982724099 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | ||
| 81330 | 81330 | 116229 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 98431 | 98431 | 116227 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 110949 | 110949 | 116228 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 145449 | 145449 | 20228 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1699 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002579.480222 | 2114044.5496622 | 37.784908839203204 | -122.43481026677 | (37.7849088392032, -122.43481026677) | |||
| 84242 | 84242 | 99240 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 4x4 | 6008281.0 | 2113828.0 | 37.784636297853105 | -122.415069452341 | (37.7846362978531, -122.415069452341) | |||
| 7636 | 7636 | 99241 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 4x4 | 6008235.1228 | 2113825.75072 | 37.7846275436788 | -122.415228013286 | (37.7846275436788, -122.415228013286) | |||
| 7647 | 7647 | 99242 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 8 | 4x4 | 6008195.716580001 | 2113819.71845 | 37.7846087658129 | -122.415363918808 | (37.7846087658129, -122.415363918808) | |||
| 91001 | 91001 | 99244 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 570 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 4x4 | 6008204.0 | 2113818.0 | 37.784604512923 | -122.41533513918002 | (37.784604512923, -122.41533513918) | |||
| 122770 | 122770 | 99243 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 570 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 9 | 4x4 | 6008204.0 | 2113818.0 | 37.784604512923 | -122.41533513918002 | (37.784604512923, -122.41533513918) | |||
| 79113 | 79113 | 24925 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2099X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/09/1996 12:00:00 AM | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 79616 | 79616 | 24935 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 82591 | 82591 | 24927 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 83248 | 83248 | 24932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 93328 | 93328 | 24934 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 93902 | 93902 | 26750 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2099X Post St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/05/2003 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 96268 | 96268 | 26751 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2099X Post St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/05/2003 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 97103 | 97103 | 24936 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2099X Post St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/21/2007 12:00:00 AM | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 106916 | 106916 | 26749 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2099X Post St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/28/1999 12:00:00 AM | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) |
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");