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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 11793 | 11793 | 120892 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Leland Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6009904.76 | 2087542.3079 | 37.7125527002168 | -122.407597819442 | (37.7125527002168, -122.407597819442) | |||
| 128075 | 128075 | 120885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6009830.0 | 2087548.0 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | ||||
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 149958 | 149958 | 120890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118267999 | -122.40771591213999 | (37.71259118268, -122.40771591214) | |||
| 74957 | 74957 | 120889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.71260369432971 | -122.407774785999 | (37.7126036943297, -122.407774785999) | |||
| 61322 | 61322 | 120888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.40787112709101 | (37.7126351844606, -122.407871127091) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 187851 | 187851 | 120886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.712660357001795 | -122.40797963340599 | (37.7126603570018, -122.407979633406) | |||
| 82737 | 82737 | 106281 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
| 95834 | 95834 | 106280 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
| 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) | ||||
| 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) | ||
| 21638 | 21638 | 18577 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.46363640417201 | (37.7143856696584, -122.463636404172) | ||
| 98945 | 98945 | 116341 | Undocumented 2 | :: 54 | 201X Bright St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
| 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) | |||||
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 18684 | 18684 | 109456 | Permitted Site 1 | Tree(s) :: 17 | 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) | ||
| 85033 | 85033 | 109457 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 951 GILMAN AVE | 43 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 23 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||||
| 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) | ||
| 51128 | 51128 | 25415 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 99275 | 99275 | 25419 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/19/1996 12:00:00 AM | 3 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 106691 | 106691 | 25411 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 110546 | 110546 | 25416 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 112727 | 112727 | 25417 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 116369 | 116369 | 25413 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/28/1996 12:00:00 AM | 3 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 138721 | 138721 | 25414 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 895X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | ||
| 78664 | 78664 | 13380 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 86895 | 86895 | 13384 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 92208 | 92208 | 13378 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/13/2000 12:00:00 AM | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | ||
| 108952 | 108952 | 13376 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 109944 | 109944 | 13381 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 113947 | 113947 | 13383 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 119188 | 119188 | 13379 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 126625 | 126625 | 13385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 181298 | 181298 | 97892 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 401x Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/2010 12:00:00 AM | 8 | 3x3 | Permit Number 55034 | 6002514.74306 | 2090342.41745 | 37.7198247442045 | -122.433339952791 | (37.7198247442045, -122.433339952791) | |
| 95903 | 95903 | 97893 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 401x Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/2010 12:00:00 AM | 3x3 | Permit Number 55034 | 6002347.5 | 2090445.5 | 37.72009829646 | -122.433925417029 | (37.72009829646, -122.433925417029) | ||
| 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) | ||
| 12296 | 12296 | 19104 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011705.43586 | 2090789.4617400002 | 37.721569360619604 | -122.40160216911 | (37.7215693606196, -122.40160216911) | ||
| 15567 | 15567 | 22419 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | ||
| 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) | ||
| 79426 | 79426 | 116125 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 92983 | 92983 | 116128 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 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) | |||||
| 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) | |||||
| 78103 | 78103 | 22400 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 4X4 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 78217 | 78217 | 22401 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 105626 | 105626 | 22399 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 124786 | 124786 | 22398 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 38305 | 38305 | 116138 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.39238857399599 | (37.7262356791342, -122.392388573996) | ||||
| 20862 | 20862 | 116132 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 77747 | 77747 | 116129 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 81024 | 81024 | 116130 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 84841 | 84841 | 116134 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 93581 | 93581 | 116133 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 102302 | 102302 | 116136 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 105094 | 105094 | 116131 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 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) | |||||
| 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) | |||||
| 78609 | 78609 | 26824 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 79265 | 79265 | 26306 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 79960 | 79960 | 26313 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 80056 | 80056 | 26299 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 81506 | 81506 | 26304 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 85891 | 85891 | 26298 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 92206 | 92206 | 26303 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 95883 | 95883 | 26312 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 96826 | 96826 | 26300 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 99814 | 99814 | 26311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 106413 | 106413 | 26302 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 107389 | 107389 | 26297 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 111375 | 111375 | 26308 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 114344 | 114344 | 26310 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 115681 | 115681 | 26309 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 122107 | 122107 | 26305 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 141627 | 141627 | 26301 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 146124 | 146124 | 26307 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 07/06/1998 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 80819 | 80819 | 12055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | |||
| 105682 | 105682 | 12051 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 117183 | 117183 | 12054 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | |||
| 120398 | 120398 | 12053 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/1993 12:00:00 AM | 6 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 139264 | 139264 | 12049 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/17/2007 12:00:00 AM | 3 | 3x3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 78767 | 78767 | 12056 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 92477 | 92477 | 12059 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 93198 | 93198 | 12058 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 109212 | 109212 | 12062 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 110400 | 110400 | 12057 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 115282 | 115282 | 12063 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1330X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | ||
| 117052 | 117052 | 12065 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 121136 | 121136 | 12060 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 95395 | 95395 | 27160 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6011020.5092245005 | 2095004.7366116 | 37.733105385033795 | -122.40426632243 | (37.7331053850338, -122.40426632243) | |||
| 140654 | 140654 | 27152 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011020.5092245005 | 2095004.7366116 | 37.733105385033795 | -122.40426632243 | (37.7331053850338, -122.40426632243) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 80275 | 80275 | 26143 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 88734 | 88734 | 26148 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 89501 | 89501 | 26142 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 93843 | 93843 | 26146 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 96605 | 96605 | 26144 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 Oakdale Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) |
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");