trees
27,746 rows where qCaretaker_id = 1 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
166830 | 5327 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004755.67064 | 2107733.77413 | 37.7677043064343 | -122.426831755188 | (37.7677043064343, -122.426831755188) | 8 | 4 | 5 | 28862 | 3 | |||
185165 | 24961 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.7677089127708 | -122.42667516164 | (37.7677089127708, -122.42667516164) | 8 | 4 | 5 | 28862 | 3 | ||
848 | 116677 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
3986 | 116680 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 100 Esmeralda Ave | 19 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
29923 | 116678 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 100 Esmeralda Ave | 17 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
30357 | 116670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
43548 | 116682 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 21 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
49756 | 116671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
61216 | 116672 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
63486 | 116675 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 14 | Unaccepted Street : Yard | Tree | DPW 1 | 14 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
88904 | 116681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
94926 | 116679 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 100 Esmeralda Ave | 18 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
142056 | 116669 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Esmeralda Ave | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 20 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
173825 | 116683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 22 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
178686 | 116676 | DPW Maintained 1 | Aesculus californica :: California Buckeye 168 | 100 Esmeralda Ave | 15 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
128557 | 130176 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:36:00 AM | 2 | Width 4ft | 6006738.15532 | 2110843.36545 | 37.7763543941826 | -122.420195290907 | (37.7763543941826, -122.420195290907) | 7 | 9 | 11 | 28852 | 10 | ||
139011 | 130174 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2015 09:39:00 AM | 3 | Width 4ft | 6006789.90912 | 2110850.47929 | 37.7763768430541 | -122.420016764658 | (37.7763768430541, -122.420016764658) | 7 | 9 | 11 | 28852 | 10 | ||
35987 | 8295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Garcia Ave | 5 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.459939898511 | (37.743936899881, -122.459939898511) | 1 | 8 | 4 | 59 | 40 | |||
65518 | 8293 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Garcia Ave | 3 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.459939898511 | (37.743936899881, -122.459939898511) | 1 | 8 | 4 | 59 | 40 | |||
73811 | 8291 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Garcia Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.459939898511 | (37.743936899881, -122.459939898511) | 1 | 8 | 4 | 59 | 40 | |||
78424 | 8292 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Garcia Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.459939898511 | (37.743936899881, -122.459939898511) | 1 | 8 | 4 | 59 | 40 | |||
166232 | 8294 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Garcia Ave | 4 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.459939898511 | (37.743936899881, -122.459939898511) | 1 | 8 | 4 | 59 | 40 | |||
45104 | 253527 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | 7 | 9 | 11 | 28852 | 10 | ||
131796 | 10246 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | 7 | 9 | 11 | 28852 | 10 | |||
6620 | 258386 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 100 Hamilton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009028.92475 | 2093781.29726 | 37.7296345936181 | -122.411065400912 | (37.7296345936181, -122.411065400912) | 9 | 3 | 7 | 309 | 28 | ||||
15188 | 180603 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6009034.51206 | 2093748.44623 | 37.7295447050207 | -122.411043765455 | (37.7295447050207, -122.411043765455) | 9 | 3 | 7 | 309 | 28 | ||
62448 | 11188 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995291.08877 | 2099424.10153 | 37.7443483813689 | -122.458966630003 | (37.7443483813689, -122.458966630003) | 1 | 8 | 4 | 59 | 40 | |||
69762 | 11201 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 Idora Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995318.65927 | 2099418.1217 | 37.7443335470614 | -122.458870864793 | (37.7443335470614, -122.458870864793) | 1 | 8 | 4 | 59 | 40 | |||
83697 | 11186 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100 Idora Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | 1 | 8 | 4 | 59 | 40 | |||
135905 | 11187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5995309.2253 | 2099420.08132 | 37.7443383854121 | -122.458903627104 | (37.7443383854121, -122.458903627104) | 1 | 8 | 4 | 59 | 40 | |||
185955 | 11202 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 100 Idora Ave | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995328.17404 | 2099416.28223 | 37.744329043248 | -122.458837831796 | (37.744329043248, -122.458837831796) | 1 | 8 | 4 | 59 | 40 | |||
25790 | 11503 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
29472 | 11507 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
42740 | 11506 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
44850 | 11492 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | ||
57743 | 11504 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | ||
72950 | 11491 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | ||
80987 | 11508 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
80994 | 11505 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
97265 | 11502 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
105875 | 11493 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | ||
116033 | 11500 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
118138 | 11501 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
155270 | 11490 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 100 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | ||
155683 | 11510 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
175115 | 11509 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
185466 | 11495 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 100 Jennings St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | ||
190601 | 11488 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/1993 12:00:00 AM | 6 | 4X4 | 6018872.157 | 2097296.32677 | 37.7398332567899 | -122.377279727371 | (37.7398332567899, -122.377279727371) | 10 | 3 | 8 | 58 | 1 | ||
193780 | 11487 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018880.35523 | 2097308.40588 | 37.7398668752499 | -122.37725221891 | (37.7398668752499, -122.37725221891) | 10 | 3 | 8 | 58 | 1 | |||
80497 | 12527 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5995151.97418 | 2114942.29811 | 37.7869493206202 | -122.460571940769 | (37.7869493206202, -122.460571940769) | 11 | 6 | 1 | 54 | 11 | |||
45578 | 14449 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.7810981763644 | -122.447431561272 | (37.7810981763644, -122.447431561272) | 15 | 5 | 1 | 54 | 16 | ||
107558 | 14448 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5998955.83191 | 2112569.63115 | 37.7806526990906 | -122.447240682868 | (37.7806526990906, -122.447240682868) | 15 | 5 | 1 | 54 | 16 | |||
114734 | 14451 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.7810981763644 | -122.447431561272 | (37.7810981763644, -122.447431561272) | 15 | 5 | 1 | 54 | 16 | ||
136553 | 14447 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2012 12:00:00 AM | 3 | 3x3 | 5998904.0552777 | 2112732.9517082 | 37.7810981763644 | -122.447431561272 | (37.7810981763644, -122.447431561272) | 15 | 5 | 1 | 54 | 16 | ||
146929 | 14445 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.447285529358 | (37.7803730113246, -122.447285529358) | 15 | 5 | 1 | 54 | 16 | |||
151088 | 14450 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.447330326113 | (37.7806967093816, -122.447330326113) | 15 | 5 | 1 | 54 | 16 | |||
78905 | 179323 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Merrill St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6009520.85663 | 2094768.87857 | 37.7323738561678 | -122.409434403484 | (37.7323738561678, -122.409434403484) | 10 | 3 | 7 | 309 | 28 | |||
139013 | 179324 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Merrill St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6009528.37304 | 2094747.88556 | 37.7323166349901 | -122.409406936389 | (37.7323166349901, -122.409406936389) | 10 | 3 | 7 | 309 | 28 | |||
51483 | 187609 | DPW Maintained 1 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 100 Northridge Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018548 | 2094208 | 37.7313354560629 | -122.378186204537 | (37.7313354560629, -122.378186204537) | 10 | 3 | 8 | 58 | 1 | ||||
154670 | 187610 | DPW Maintained 1 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 100 Northridge Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018548 | 2094208 | 37.7313354560629 | -122.378186204537 | (37.7313354560629, -122.378186204537) | 10 | 3 | 8 | 58 | 1 | ||||
172245 | 187611 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 100 Northridge Rd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018548 | 2094208 | 37.7313354560629 | -122.378186204537 | (37.7313354560629, -122.378186204537) | 10 | 3 | 8 | 58 | 1 | ||||
66871 | 239150 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 100 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 4ft | 6005732.39027 | 2109686.64828 | 37.7731216065951 | -122.4235922587 | (37.7731216065951, -122.4235922587) | 7 | 9 | 11 | 28852 | 10 | |||
78950 | 237033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 7 | : | Tree | DPW 1 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | 7 | 9 | 11 | 28852 | 10 | |||
131106 | 237030 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Octavia St | 4 | : | Tree | DPW 1 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.7732508616652 | -122.423617927146 | (37.7732508616652, -122.423617927146) | 7 | 9 | 11 | 28852 | 10 | |||
136697 | 239151 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Octavia St | 2 | : | Tree | DPW 1 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | 7 | 9 | 11 | 28852 | 10 | ||
32505 | 90441 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6006647.189885 | 2109151.603655 | 37.7717040957938 | -122.420389859033 | (37.7717040957938, -122.420389859033) | 8 | 2 | 9 | 28853 | 19 | ||
42584 | 90443 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6006647.189885 | 2109151.603655 | 37.7717040957938 | -122.420389859033 | (37.7717040957938, -122.420389859033) | 8 | 2 | 9 | 28853 | 19 | ||
49107 | 90442 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6006647.189885 | 2109151.603655 | 37.7717040957938 | -122.420389859033 | (37.7717040957938, -122.420389859033) | 8 | 2 | 9 | 28853 | 19 | ||
97426 | 17495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002027.05349 | 2091378.72089 | 37.722642521628 | -122.43509980193 | (37.722642521628, -122.43509980193) | 9 | 7 | 6 | 28861 | 5 | |||
47161 | 18304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
75232 | 18306 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
161918 | 18305 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010224.24414 | 2107746.60355 | 37.7680472125438 | -122.407917452249 | (37.7680472125438, -122.407917452249) | 8 | 4 | 8 | 28853 | 19 | |||
795 | 19570 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
3078 | 19568 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
3191 | 19565 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
4099 | 19572 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
4242 | 19575 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
7644 | 19569 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
9166 | 19571 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
13069 | 19574 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
16816 | 19567 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
17526 | 19573 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
19615 | 19566 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
8411 | 19699 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40ST | |||||||||||||
13223 | 19700 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 40ST | |||||||||||||
9280 | 19702 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY12 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10150 | 19701 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY12 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
874 | 19715 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
1935 | 19720 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY13 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
3083 | 19706 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY13 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
3284 | 19710 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY13 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
4806 | 19711 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 100 STAIRWAY13 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
5828 | 19721 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY13 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
6212 | 19719 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
6354 | 19722 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY13 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
8265 | 19714 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY13 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
8390 | 19708 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY13 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
8562 | 19709 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY13 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
10206 | 19713 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 100 STAIRWAY13 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
10647 | 19707 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY13 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST |
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) );