trees
8,298 rows where qLegalStatus_id = 4 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102400 | 254464 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 58 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
126624 | 254469 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
133577 | 254467 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
164775 | 254468 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
170500 | 254460 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
180693 | 254466 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 60 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
186636 | 254465 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 59 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
188898 | 254463 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 57 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
47851 | 108864 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015726.4 | 2115025.3 | 37.7883393953728 | -122.389394280203 | (37.7883393953728, -122.389394280203) | 6 | 2 | 9 | 28855 | 6 | ||||
84924 | 108863 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015726.4 | 2115025.3 | 37.7883393953728 | -122.389394280203 | (37.7883393953728, -122.389394280203) | 6 | 2 | 9 | 28855 | 6 | ||||
85234 | 108861 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015726.4 | 2115025.3 | 37.7883393953728 | -122.389394280203 | (37.7883393953728, -122.389394280203) | 6 | 2 | 9 | 28855 | 6 | ||||
107129 | 108865 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015726.4 | 2115025.3 | 37.7883393953728 | -122.389394280203 | (37.7883393953728, -122.389394280203) | 6 | 2 | 9 | 28855 | 6 | ||||
140369 | 108867 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015726.4 | 2115025.3 | 37.7883393953728 | -122.389394280203 | (37.7883393953728, -122.389394280203) | 6 | 2 | 9 | 28855 | 6 | ||||
180578 | 108868 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015726.4 | 2115025.3 | 37.7883393953728 | -122.389394280203 | (37.7883393953728, -122.389394280203) | 6 | 2 | 9 | 28855 | 6 | ||||
181435 | 108866 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 400 SPEAR ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015726.4 | 2115025.3 | 37.7883393953728 | -122.389394280203 | (37.7883393953728, -122.389394280203) | 6 | 2 | 9 | 28855 | 6 | ||||
73180 | 111309 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 100x GILROY ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015178 | 2088529 | 37.7155557353625 | -122.389440569451 | (37.7155557353625, -122.389440569451) | 10 | 3 | 8 | 58 | 1 | ||||
142895 | 107048 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1478 UNDERWOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015262.9 | 2093276.2 | 37.7285953185109 | -122.389478448264 | (37.7285953185109, -122.389478448264) | 10 | 3 | 8 | 58 | 1 | |||
22774 | 121447 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1251 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015574 | 2109248 | 37.7724677756099 | -122.389517929907 | (37.7724677756099, -122.389517929907) | 14 | 3 | 9 | 310 | 20 | |||||
25651 | 191577 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 20 | : | Tree | Private 2 | 11 | Width 4ft | 6015326.98728 | 2098089.14563 | 37.7418142438421 | -122.38959289501 | (37.7418142438421, -122.38959289501) | 10 | 3 | 8 | 58 | 1 | |||
141508 | 200338 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 21 | : | Tree | Private 2 | 9 | Width 2ft | 6015318.39191 | 2098076.99567 | 37.7417804059521 | -122.389621766852 | (37.7417804059521, -122.389621766852) | 10 | 3 | 8 | 58 | 1 | |||
114788 | 200339 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 22 | : | Tree | Private 2 | 5 | Width 2ft | 6015308.33502 | 2098065.16508 | 37.7417473639376 | -122.389655714464 | (37.7417473639376, -122.389655714464) | 10 | 3 | 8 | 58 | 1 | |||
77597 | 200340 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 23 | : | Tree | Private 2 | 8 | Width 2ft | 6015300.13853 | 2098052.9717 | 37.7417134289277 | -122.389683204014 | (37.7417134289277, -122.389683204014) | 10 | 3 | 8 | 58 | 1 | |||
51401 | 107045 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1622X MCKINNON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015259 | 2096017 | 37.7361207862805 | -122.389683281146 | (37.7361207862805, -122.389683281146) | 10 | 3 | 8 | 58 | 1 | |||
10955 | 116918 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
119280 | 116920 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
119381 | 116919 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
147805 | 116922 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 900x 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
154306 | 116921 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
111689 | 107276 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
112412 | 107273 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
114709 | 107278 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
155792 | 107275 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
167350 | 107279 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
176550 | 107277 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
185235 | 107274 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
186932 | 107280 | Undocumented 4 | Tree(s) :: 17 | 1248X 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015514.05712 | 2109246.9977 | 37.7724616997483 | -122.389725209976 | (37.7724616997483, -122.389725209976) | 14 | 3 | 9 | 310 | 20 | ||||
114103 | 200341 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 24 | : | Tree | Private 2 | 8 | Width 2ft | 6015282.07626 | 2098027.62068 | 37.7416428186622 | -122.389743887597 | (37.7416428186622, -122.389743887597) | 10 | 3 | 8 | 58 | 1 | |||
118051 | 75428 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 75X Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 5 | 3x3 | 6015524 | 2112347 | 37.7809741671498 | -122.389907397894 | (37.7809741671498, -122.389907397894) | 6 | 2 | 9 | 28856 | 20 | ||
157718 | 75828 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 75 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 6015524 | 2112347 | 37.7809741671498 | -122.389907397894 | (37.7809741671498, -122.389907397894) | 6 | 2 | 9 | 28856 | 20 | ||||
96137 | 121759 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1019 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015338 | 2103772 | 37.7574187808175 | -122.389951694408 | (37.7574187808175, -122.389951694408) | 10 | 3 | 8 | 28856 | 29 | ||||
60045 | 256037 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1555 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6x3 | 6015125 | 2093955 | 37.7304515202688 | -122.390002579169 | (37.7304515202688, -122.390002579169) | 10 | 3 | 8 | 58 | 1 | |||
75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
84098 | 105172 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
135817 | 105173 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1601X NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Asian Arts Commission 21 | Arts Commission | 13 | 4x4 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | |
5555 | 256038 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6015087 | 2093984 | 37.7305290408635 | -122.390135976897 | (37.7305290408635, -122.390135976897) | 10 | 3 | 8 | 58 | 1 | ||
50864 | 107995 | Undocumented 4 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 | 907 Minnesota St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | 6x11 | Permit Number 774103 | 6015290.10173 | 2104424.85479 | 37.7592087238569 | -122.390162955696 | (37.7592087238569, -122.390162955696) | 10 | 3 | 8 | 28856 | 29 | ||
89338 | 116900 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 4 BAYSIDE VILLAGE PL | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6015480 | 2114022 | 37.7855708982649 | -122.390176670868 | (37.7855708982649, -122.390176670868) | 6 | 2 | 9 | 28856 | 6 | ||||
62805 | 105992 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 980 MINNESOTA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6015221.1 | 2104017.4 | 37.758086112912 | -122.39037313012 | (37.758086112912, -122.39037313012) | 10 | 3 | 8 | 28856 | 29 | |||
25728 | 96200 | Undocumented 4 | Tree(s) :: 17 | 1640 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
109388 | 96194 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1640 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
135051 | 96196 | Undocumented 4 | Tree(s) :: 17 | 1640 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
162980 | 96193 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1640 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
177237 | 96199 | Undocumented 4 | Tree(s) :: 17 | 1640 Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
181457 | 96198 | Undocumented 4 | Tree(s) :: 17 | 1640 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
183656 | 96195 | Undocumented 4 | Tree(s) :: 17 | 1640 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
67697 | 105676 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 401X BEALE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2014 12:00:00 AM | 10 | 4x4 | Permit Number 770920 | 6015422 | 2114485 | 37.7868389737021 | -122.390409697445 | (37.7868389737021, -122.390409697445) | 6 | 2 | 9 | 28855 | 6 | |
26355 | 256053 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
44865 | 256049 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
78382 | 121470 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 120X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 8 | 4x4 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | |||
91921 | 256047 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
118600 | 256050 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
149616 | 256048 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
181630 | 256051 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
188882 | 256045 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
191873 | 256046 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015452 | 2116243 | 37.7916677028969 | -122.390428783846 | (37.7916677028969, -122.390428783846) | 6 | 2 | 9 | 28855 | 6 | ||||
74082 | 107612 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 599x CHINA BASIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6015291 | 2109063 | 37.7719441112286 | -122.390483933976 | (37.7719441112286, -122.390483933976) | 14 | 3 | 9 | 310 | 20 | |||
162844 | 106009 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1745 LANE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014990.1 | 2094194.5 | 37.7311016564679 | -122.390485679987 | (37.7311016564679, -122.390485679987) | 10 | 3 | 8 | 58 | 1 | |||
88998 | 97048 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | 10 | 3 | 8 | 58 | 1 | |||
123503 | 97047 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | 10 | 3 | 8 | 58 | 1 | |||
87310 | 97046 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X SHAFTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014988 | 2094146 | 37.7309683687499 | -122.390489552503 | (37.7309683687499, -122.390489552503) | 10 | 3 | 8 | 58 | 1 | |||
13473 | 105162 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1600X OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
103033 | 105163 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1600X OAKDALE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 17 | 4x4 | Permit Number 770204 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | ||
22042 | 102557 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
28352 | 102555 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
54279 | 102559 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
131073 | 102554 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
157982 | 102560 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
188829 | 102556 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
192681 | 102558 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
28986 | 97431 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1696@ Newhall St McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | 10 | 3 | 8 | 58 | 1 | ||||
32168 | 97432 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1696@ Newhall St McKinnon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | 10 | 3 | 8 | 58 | 1 | ||||
51154 | 97433 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1696@ Newhall St McKinnon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | 10 | 3 | 8 | 58 | 1 | ||||
142948 | 97430 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1696@ Newhall St McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014941.5 | 2096322.6 | 37.7369422906262 | -122.390802367297 | (37.7369422906262, -122.390802367297) | 10 | 3 | 8 | 58 | 1 | ||||
32862 | 102563 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
36210 | 102562 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
72314 | 102564 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
91278 | 102561 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
104464 | 102565 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
145623 | 102566 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
165931 | 102568 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
184748 | 102567 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||
3845 | 105016 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1099X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Marked for a basin expansion. SB | 6015050.3 | 2102960.5 | 37.755174615412 | -122.390889970266 | (37.755174615412, -122.390889970266) | 10 | 3 | 8 | 28856 | 29 | ||||
35046 | 105019 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1099X 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Marked for a basin expansion. SB | 6015050.3 | 2102960.5 | 37.755174615412 | -122.390889970266 | (37.755174615412, -122.390889970266) | 10 | 3 | 8 | 28856 | 29 | ||||
94408 | 105018 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1099X 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Marked for a basin expansion. SB | 6015050.3 | 2102960.5 | 37.755174615412 | -122.390889970266 | (37.755174615412, -122.390889970266) | 10 | 3 | 8 | 28856 | 29 | ||||
150063 | 105017 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1099X 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Marked for a basin expansion. SB | 6015050.3 | 2102960.5 | 37.755174615412 | -122.390889970266 | (37.755174615412, -122.390889970266) | 10 | 3 | 8 | 28856 | 29 | ||||
155972 | 105015 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1099X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | I MARKED FOR A BSIN EXPANSION | 6015050.3 | 2102960.5 | 37.755174615412 | -122.390889970266 | (37.755174615412, -122.390889970266) | 10 | 3 | 8 | 28856 | 29 | ||||
9919 | 106007 | Undocumented 4 | Tree(s) :: 17 | 1800X LANE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014836 | 2094060 | 37.7307237967737 | -122.391009037699 | (37.7307237967737, -122.391009037699) | 10 | 3 | 8 | 58 | 1 | ||||
47438 | 107155 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
64187 | 107152 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | |||
102686 | 107153 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 |
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) );