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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
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) | |||||
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) | |||
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) | |||||
117524 | 117524 | 116126 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
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) | |||
118898 | 118898 | 116327 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
119057 | 119057 | 106282 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 3 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
119252 | 119252 | 116340 | Undocumented 2 | :: 54 | 201X Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
120223 | 120223 | 116140 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
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) | |||
121543 | 121543 | 116331 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
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) | |||||
122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
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) | |||||
123205 | 123205 | 94297 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
123293 | 123293 | 102368 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4 | Permit Number 769895 | 5984151.13176 | 2110133.93549 | 37.7731079279349 | -122.49827649972 | (37.7731079279349, -122.49827649972) | |||
123341 | 123341 | 117622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 890x VERMONT ST | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6011292.0 | 2104239.0 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | |||||
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) | |||||
124407 | 124407 | 116322 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
125361 | 125361 | 116323 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
125773 | 125773 | 116135 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
128318 | 128318 | 116151 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
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) | |||||
139364 | 139364 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
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) | |||||
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) | |||||
140572 | 140572 | 116137 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
140734 | 140734 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 1820X Palou Ave | : Cutout 24 | Tree 1 | Rec/Park 3 | FUF 1 | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | ||||
141081 | 141081 | 116127 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
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) | |||||
143572 | 143572 | 116337 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
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) | |||
144301 | 144301 | 116336 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
146211 | 146211 | 116150 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
150039 | 150039 | 102376 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 5984157.512069999 | 2109978.36457 | 37.7726811489417 | -122.498242937742 | (37.7726811489417, -122.498242937742) | ||||
156733 | 156733 | 102371 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.68011 | 2110075.48808 | 37.7729475975471 | -122.49826336723801 | (37.7729475975471, -122.498263367238) | |||
166717 | 166717 | 102372 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984152.563490001 | 2110057.09296 | 37.7728970243511 | -122.49826587084299 | (37.7728970243511, -122.498265870843) | |||
182049 | 182049 | 102370 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | Permit Number 769895 | 5984153.18727 | 2110032.649 | 37.7728299448261 | -122.49826190746201 | (37.7728299448261, -122.498261907462) | |||
34305 | 34305 | 20466 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
80523 | 80523 | 20465 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
80842 | 80842 | 20504 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/1991 12:00:00 AM | 18 | 10 | 5984781.8902056 | 2107224.2505442 | 37.7651557239541 | -122.495879974111 | (37.7651557239541, -122.495879974111) | ||
100327 | 100327 | 20463 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
105704 | 105704 | 20464 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/05/1997 12:00:00 AM | 3 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | ||
112463 | 112463 | 20462 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
94686 | 94686 | 25454 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 595X Geneva Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/28/1996 12:00:00 AM | 12 | 2X3 | 5999113.4172 | 2090550.32647 | 37.720202063668 | -122.445112038783 | (37.720202063668, -122.445112038783) | ||
122160 | 122160 | 114736 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 435 LILY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2x2 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
124537 | 124537 | 114733 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 435 LILY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2x2 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
104399 | 104399 | 765 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 1200X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3 | 5984609.996333099 | 2107018.7644647 | 37.764581448379396 | -122.496459340328 | (37.7645814483794, -122.496459340328) | |||
126787 | 126787 | 23612 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | |||
589 | 589 | 26916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002555.1851 | 2113680.9302 | 37.783909052953 | -122.43486830704398 | (37.783909052953, -122.434868307044) | |||
1080 | 1080 | 9610 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1388X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/01/2017 01:42:00 PM | 3 | 3X3 | 6002958.1886 | 2112049.4711 | 37.7794523489738 | -122.433357444963 | (37.7794523489738, -122.433357444963) | ||
1593 | 1593 | 9458 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005390.9525 | 2112398.9001 | 37.780549510570204 | -122.424966344778 | (37.7805495105702, -122.424966344778) | ||
2279 | 2279 | 9454 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005489.5152 | 2112411.3558 | 37.7805892777689 | -122.424626255587 | (37.7805892777689, -122.424626255587) | ||
2525 | 2525 | 9534 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 6 | 3X3 | Permit Number 771276 | 6004154.8546 | 2112220.8365 | 37.779990692526 | -122.42922989330201 | (37.779990692526, -122.429229893302) | |
2696 | 2696 | 9611 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1390X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6002925.8908 | 2112046.6002 | 37.7794426338279 | -122.43346897140499 | (37.7794426338279, -122.433468971405) | ||
3190 | 3190 | 9537 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.779960357201205 | -122.429417251502 | (37.7799603572012, -122.429417251502) | ||
3252 | 3252 | 9455 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005466.2284 | 2112408.648 | 37.7805805276453 | -122.424706623116 | (37.7805805276453, -122.424706623116) | ||
3483 | 3483 | 9453 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005504.6787 | 2112415.6882 | 37.7806020298362 | -122.42457410603201 | (37.7806020298362, -122.424574106032) | ||
3688 | 3688 | 9457 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005414.2393 | 2112401.6078 | 37.7805582605963 | -122.424885977306 | (37.7805582605963, -122.424885977306) | |||
5025 | 5025 | 9541 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856000001 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | |
5378 | 5378 | 9456 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005442.4 | 2112406.4818 | 37.780573233977705 | -122.424788902821 | (37.7805732339777, -122.424788902821) | ||
5555 | 5555 | 8527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002529.8149 | 2113677.2092 | 37.7838973955703 | -122.434955812258 | (37.7838973955703, -122.434955812258) | |||
5863 | 5863 | 9461 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005331.3816 | 2112388.6106 | 37.780517893039395 | -122.425171696602 | (37.7805178930394, -122.425171696602) | ||
6101 | 6101 | 9452 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005518.2175 | 2112416.7713 | 37.780605768348295 | -122.424527345883 | (37.7806057683483, -122.424527345883) | ||
6304 | 6304 | 9451 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005532.2979 | 2112418.9375 | 37.7806125113537 | -122.424478789137 | (37.7806125113537, -122.424478789137) | ||
6893 | 6893 | 8489 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002220.6585 | 2113766.2282 | 37.7841242607304 | -122.436031749589 | (37.7841242607304, -122.436031749589) | |||
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) | |||
7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
7440 | 7440 | 9542 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | ||
7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
7635 | 7635 | 8487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002304.7836 | 2113777.2973 | 37.7841594324943 | -122.43574149958401 | (37.7841594324943, -122.435741499584) | |||
7676 | 7676 | 9450 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 6 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.780617614602896 | -122.424439561439 | (37.7806176146029, -122.424439561439) | |||
7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
7827 | 7827 | 9544 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6003937.8747 | 2112189.6367 | 37.7798927397998 | -122.429978297745 | (37.7798927397998, -122.429978297745) | |||
7831 | 7831 | 9536 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544491999 | (37.779974353933, -122.42935544492) | ||
8608 | 8608 | 9533 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | |||
8706 | 8706 | 9539 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004035.7284 | 2112200.9821 | 37.779929432705 | -122.429640587781 | (37.779929432705, -122.429640587781) | ||
8794 | 8794 | 8525 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002439.1587 | 2113663.3402 | 37.7838541670365 | -122.43526845642201 | (37.7838541670365, -122.435268456422) | |||
8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
13832 | 13832 | 27154 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011126.61874 | 2095085.7194599998 | 37.7333336755986 | -122.403905168305 | (37.7333336755986, -122.403905168305) | ||
14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
15604 | 15604 | 7382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | |||
15693 | 15693 | 7378 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | |||
15856 | 15856 | 27155 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/29/2000 12:00:00 AM | 6 | 3X3 | 6011143.89147 | 2095098.83858 | 37.733370662922795 | -122.403846374205 | (37.7333706629228, -122.403846374205) | ||
15973 | 15973 | 22420 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6013860.9167 | 2092056.0916 | 37.725167314492104 | -122.39423983281799 | (37.7251673144921, -122.394239832818) | ||
16026 | 16026 | 27153 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011109.96837 | 2095074.7045 | 37.7333025005961 | -122.403961958687 | (37.7333025005961, -122.403961958687) | ||
16764 | 16764 | 7379 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010870.4412 | 2111489.3325 | 37.7783600402028 | -122.40594600363998 | (37.7783600402028, -122.40594600364) | |||
17563 | 17563 | 687 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010636.022580001 | 2101844.6913400004 | 37.75186493122229 | -122.40607730804199 | (37.7518649312223, -122.406077308042) | |||
18045 | 18045 | 24537 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6007586.10322 | 2097213.8581 | 37.738978639151505 | -122.416296424042 | (37.7389786391515, -122.416296424042) | |||
18163 | 18163 | 24539 | Landmark tree 9 | Celtis occidentalis :: Common Hackberry 292 | 500X Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6007622.1254900005 | 2097206.54003 | 37.738960570878795 | -122.41617135711999 | (37.7389605708788, -122.41617135712) | |||
19639 | 19639 | 9777 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
19899 | 19899 | 24538 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6007606.23219 | 2097211.71423 | 37.7389738844263 | -122.416226675338 | (37.7389738844263, -122.416226675338) | |||
19927 | 19927 | 10223 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296966999 | (37.7491888788632, -122.42249296967) | |||
21449 | 21449 | 24540 | Landmark tree 9 | Celtis occidentalis :: Common Hackberry 292 | 500X Cortland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6007652.968230001 | 2097201.05938 | 37.7389472564055 | -122.416064328819 | (37.7389472564055, -122.416064328819) | |||
21616 | 21616 | 25457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | ||
21634 | 21634 | 24542 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500X Cortland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/29/1999 12:00:00 AM | 18 | 3X3 | 6007686.223540001 | 2097194.49045 | 37.7389310892969 | -122.41594888193701 | (37.7389310892969, -122.415948881937) |
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");