trees
720 rows where qCaretaker_id = 5 sorted by Longitude
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 | |||||||||||||
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 | |||
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 | ||
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 | |||
33267 | 26138 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1500 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/05/2005 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
41340 | 26143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
64609 | 26148 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
71289 | 26142 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
78052 | 26146 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
86759 | 26144 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1500 Oakdale Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
98926 | 26147 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
100379 | 26141 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
119557 | 26145 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
120522 | 26151 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1500 Oakdale Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
125711 | 26152 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1500 Oakdale Ave | 22 | 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 | |||
139434 | 26150 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
157261 | 26139 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/05/2005 12:00:00 AM | 4 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
163054 | 26140 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1500 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/21/2006 12:00:00 AM | 2 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
44049 | 26131 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | 10 | 3 | 8 | 58 | 1 | |||
141666 | 26133 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | 10 | 3 | 8 | 58 | 1 | |||
37847 | 26134 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1506 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015502.3956 | 2095169.2882 | 37.7338066348029 | -122.388782595026 | (37.7338066348029, -122.388782595026) | 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 | |||||
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 | |||
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 | ||
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 | ||
185499 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 1820X Palou Ave | : Cutout | Tree | Rec/Park 5 | FUF | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | 10 | 3 | 8 | 58 | 1 | ||||
52303 | 27772 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
57355 | 27773 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
59537 | 27770 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
60570 | 27771 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
118026 | 27768 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
155267 | 27769 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
29082 | 101513 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
44854 | 101512 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
83453 | 101511 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
114609 | 101514 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 240X DRUMM ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/30/2012 12:00:00 AM | 3x3 | Permit Number 769442 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||
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 | ||
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 | ||
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 | ||
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 | ||
7194 | 117622 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
32593 | 23612 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
24565 | 10586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.405321269139 | (37.7763811461579, -122.405321269139) | 14 | 2 | 9 | 28853 | 34 | |||
5722 | 255886 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
20034 | 255882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
22229 | 255887 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
24954 | 255884 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
84101 | 255881 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
186352 | 255883 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
189496 | 255885 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
149555 | 7377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | 14 | 2 | 9 | 28853 | 34 | |||
49590 | 7378 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | 14 | 2 | 9 | 28853 | 34 | |||
113146 | 111793 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55X Sherman St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3x3 | 6010868.84129 | 2110834.34163 | 37.7765614981606 | -122.405905386452 | (37.7765614981606, -122.405905386452) | 14 | 2 | 9 | 28853 | 34 | |||
155217 | 7379 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010870.4412 | 2111489.3325 | 37.7783600402028 | -122.40594600364 | (37.7783600402028, -122.40594600364) | 14 | 2 | 9 | 28853 | 34 | |||
47426 | 693 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
81926 | 690 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1299X Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
83526 | 694 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1299X Potrero Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
173288 | 689 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
770 | 111807 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
6188 | 111792 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
26375 | 111795 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
32372 | 111797 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
55646 | 111811 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
75763 | 111787 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55X SHERMAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
105308 | 111809 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
112427 | 111796 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
119106 | 111799 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
126595 | 111798 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 |
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) );