trees
720 rows where qCaretaker_id = 5 sorted by YCoord
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1978 | 87100 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 700 Connecticut St | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x3 | Permit Number 50056 | |||||||||||||
| 135819 | 120892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 201 Leland Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6009904.76 | 2087542.3079 | 37.7125527002168 | -122.407597819442 | (37.7125527002168, -122.407597819442) | 9 | 7 | 8 | 309 | 39 | |||
| 30723 | 120885 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6009830 | 2087548 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | 9 | 7 | 8 | 309 | 39 | ||||
| 166674 | 120891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.7125761244342 | -122.407663136759 | (37.7125761244342, -122.407663136759) | 9 | 7 | 8 | 309 | 39 | |||
| 61236 | 120890 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118268 | -122.40771591214 | (37.71259118268, -122.40771591214) | 9 | 7 | 8 | 309 | 39 | |||
| 61182 | 120889 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.7126036943297 | -122.407774785999 | (37.7126036943297, -122.407774785999) | 9 | 7 | 8 | 309 | 39 | |||
| 177982 | 120888 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.407871127091 | (37.7126351844606, -122.407871127091) | 9 | 7 | 8 | 309 | 39 | |||
| 1809 | 120887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | 9 | 7 | 8 | 309 | 39 | |||
| 37714 | 120886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.7126603570018 | -122.407979633406 | (37.7126603570018, -122.407979633406) | 9 | 7 | 8 | 309 | 39 | |||
| 41809 | 106281 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 2 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
| 85470 | 106280 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 1 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
| 162309 | 106282 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 3 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
| 17219 | 25457 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | 9 | 8 | 6 | 64 | 24 | ||
| 178224 | 18577 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.463636404172 | (37.7143856696584, -122.463636404172) | 9 | 8 | 6 | 64 | 24 | ||
| 111386 | 116341 | Undocumented 4 | :: 45 | 201X Bright St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5993755.0695 | 2088847.02637 | 37.7152179130961 | -122.463510368547 | (37.7152179130961, -122.463510368547) | 9 | 8 | 6 | 64 | 24 | |||||
| 163818 | 116340 | Undocumented 4 | :: 45 | 201X Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5993755.0695 | 2088847.02637 | 37.7152179130961 | -122.463510368547 | (37.7152179130961, -122.463510368547) | 9 | 8 | 6 | 64 | 24 | |||||
| 62684 | 106004 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 695X CAMPBELL AVE | unknown : Yard | Tree | Rec/Park 5 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.410348471622 | (37.716271678506, -122.410348471622) | 9 | 7 | 8 | 309 | 39 | ||||||
| 59108 | 109457 | Undocumented 4 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 951 GILMAN AVE | 43 | Front Yard : Yard | Tree | Rec/Park 5 | 23 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||||
| 82162 | 109453 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 951 GILMAN AVE | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||
| 149701 | 109456 | DPW Maintained 1 | Tree(s) :: 17 | 951 GILMAN AVE | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||
| 1331 | 25415 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 113396 | 25419 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 3 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 125160 | 25411 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 895X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | |||
| 145166 | 25416 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 895X Mansell St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | |||
| 151028 | 25417 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 895X Mansell St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | |||
| 168824 | 25413 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/28/1996 12:00:00 AM | 3 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 180738 | 25414 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 24396 | 13385 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000X Mansell St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 42614 | 13380 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000X Mansell St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 57860 | 13384 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 78443 | 13378 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000X Mansell St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/13/2000 12:00:00 AM | 3 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | ||
| 127941 | 13381 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000X Mansell St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 132349 | 13376 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 147650 | 13383 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000X Mansell St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 165402 | 13379 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
| 55300 | 97892 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401x Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/02/2010 12:00:00 AM | 8 | 3x3 | Permit Number 55034 | 6002514.74306 | 2090342.41745 | 37.7198247442045 | -122.433339952791 | (37.7198247442045, -122.433339952791) | 9 | 7 | 6 | 28861 | 5 | |
| 89016 | 97893 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401x Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/02/2010 12:00:00 AM | 3x3 | Permit Number 55034 | 6002347.5 | 2090445.5 | 37.72009829646 | -122.433925417029 | (37.72009829646, -122.433925417029) | 9 | 7 | 6 | 28861 | 5 | ||
| 77151 | 25454 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 595X Geneva Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/28/1996 12:00:00 AM | 12 | 2X3 | 5999113.4172 | 2090550.32647 | 37.720202063668 | -122.445112038783 | (37.720202063668, -122.445112038783) | 9 | 7 | 6 | 28861 | 25 | ||
| 2745 | 260577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
| 7157 | 260575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
| 8356 | 260576 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
| 9505 | 260574 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
| 118668 | 19104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011705.43586 | 2090789.46174 | 37.7215693606196 | -122.40160216911 | (37.7215693606196, -122.40160216911) | 10 | 3 | 7 | 309 | 28 | ||
| 76512 | 22419 | DPW Maintained 1 | Tristania conferta :: 61 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | 10 | 3 | 8 | 58 | 1 | ||
| 110034 | 22420 | DPW Maintained 1 | Tristania conferta :: 61 | 5815 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6013860.9167 | 2092056.0916 | 37.7251673144921 | -122.394239832818 | (37.7251673144921, -122.394239832818) | 10 | 3 | 8 | 58 | 1 | ||
| 52462 | 116125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 89965 | 116128 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 163580 | 116126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 174144 | 116127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 27261 | 22398 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 30529 | 22400 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 4X4 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 41503 | 22401 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 126295 | 22399 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
| 150449 | 116138 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.392388573996 | (37.7262356791342, -122.392388573996) | 10 | 3 | 8 | 58 | 1 | ||||
| 164 | 116129 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 6361 | 116132 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 31352 | 116135 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 39830 | 116130 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 73464 | 116134 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 93467 | 116133 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 97996 | 116136 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 131000 | 116131 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 184613 | 116137 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
| 41679 | 26313 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 45000 | 26304 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 49202 | 26306 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 55601 | 26299 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 56409 | 26824 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 73072 | 26298 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 84758 | 26303 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 85814 | 26312 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 91648 | 26300 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 102305 | 26311 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 118477 | 26297 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 118982 | 26302 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 137381 | 26309 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 137644 | 26310 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 149098 | 26308 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 154632 | 26305 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 173808 | 26301 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 193329 | 26307 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/06/1998 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
| 45983 | 12055 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | |||
| 122558 | 12051 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
| 157687 | 12054 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | |||
| 170473 | 12053 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/29/1993 12:00:00 AM | 6 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
| 185287 | 12049 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/17/2007 12:00:00 AM | 3 | 3x3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | ||
| 40573 | 12056 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 83000 | 12058 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 93483 | 12059 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 124356 | 12062 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 144965 | 12063 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330X La Salle Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | ||
| 151846 | 12057 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 168152 | 12065 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 168172 | 12060 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
| 84102 | 27160 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6011020.5092245 | 2095004.7366116 | 37.7331053850338 | -122.40426632243 | (37.7331053850338, -122.40426632243) | 10 | 3 | 8 | 58 | 1 | |||
| 186191 | 27152 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011020.5092245 | 2095004.7366116 | 37.7331053850338 | -122.40426632243 | (37.7331053850338, -122.40426632243) | 10 | 3 | 8 | 58 | 1 | ||
| 104732 | 27153 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011109.96837 | 2095074.7045 | 37.7333025005961 | -122.403961958687 | (37.7333025005961, -122.403961958687) | 10 | 3 | 8 | 58 | 1 | ||
| 163720 | 27154 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011126.61874 | 2095085.71946 | 37.7333336755986 | -122.403905168305 | (37.7333336755986, -122.403905168305) | 10 | 3 | 8 | 58 | 1 | ||
| 192526 | 27155 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/29/2000 12:00:00 AM | 6 | 3X3 | 6011143.89147 | 2095098.83858 | 37.7333706629228 | -122.403846374205 | (37.7333706629228, -122.403846374205) | 10 | 3 | 8 | 58 | 1 | ||
| 29445 | 26153 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );