trees
8,298 rows where qLegalStatus_id = 4 sorted by qSiteInfo descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120666 | 110647 | Undocumented 4 | Pittosporum spp :: Pittosporum spp 170 | 300x NAGLEE AVE | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 12 | 3x3 | 5997872 | 2088397 | 37.7142185912398 | -122.449248128432 | (37.7142185912398, -122.449248128432) | 9 | 7 | 6 | 28861 | 25 | |||
169265 | 110630 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991857 | 2101850 | 37.7508112705894 | -122.471017566011 | (37.7508112705894, -122.471017566011) | 1 | 8 | 4 | 29491 | 12 | |||||
180807 | 116778 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 398x GAVEN ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 30 | 3x3 | 6008462 | 2094745 | 37.7322489055387 | -122.413093441799 | (37.7322489055387, -122.413093441799) | 9 | 3 | 7 | 309 | 28 | |||
187045 | 112794 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21x JOICE ST | 5 | Unaccepted Street : Cutout | Tree | Private 2 | 6010276 | 2116206 | 37.7912776248382 | -122.408335175586 | (37.7912776248382, -122.408335175586) | 5 | 1 | 10 | 28857 | 21 | |||||
350 | 119661 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
501 | 108350 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
515 | 262251 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
3197 | 261564 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
3790 | 262255 | Undocumented 4 | Tree(s) :: 17 | 4210 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
3872 | 262252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
6639 | 261563 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1801 25th St | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
6686 | 113093 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 598x ARBOR ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000747 | 2096921 | 37.7377875715629 | -122.439921844785 | (37.7377875715629, -122.439921844785) | 2 | 7 | 5 | 63 | 7 | ||||
7275 | 261458 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 701X Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
7536 | 262249 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
7598 | 114708 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 500X CONGO ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x10 | 6000185 | 2095264 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | 9 | 7 | 5 | 63 | 40 | ||||
7781 | 102468 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5998217.7 | 2104179.8 | 37.7575741573713 | -122.449189617767 | (37.7575741573713, -122.449189617767) | 15 | 5 | 4 | 28862 | 38 | |||||
8318 | 98543 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
8597 | 262037 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1002x Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995668 | 2098205 | 37.7410226892773 | -122.45757517033 | (37.7410226892773, -122.45757517033) | 1 | 7 | 4 | 59 | 40 | ||||
8887 | 261586 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 20 Aptos Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5993103 | 2094790 | 37.7314982775013 | -122.466195816439 | (37.7314982775013, -122.466195816439) | 9 | 8 | 4 | 59 | 40 | |||||
9803 | 262258 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
10060 | 262273 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2470 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 6002133 | 2097220 | 37.738687356955 | -122.435151157914 | (37.738687356955, -122.435151157914) | 2 | 7 | 5 | 63 | 7 | ||||
10159 | 262253 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
10489 | 102839 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10808 | 262250 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
11479 | 110887 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 800 INDIANA ST | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
12194 | 261567 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1299 Wisconsin St | 12 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
12393 | 261459 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 701X Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
12759 | 113115 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
13318 | 262248 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
14324 | 100848 | Undocumented 4 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
15033 | 261569 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1299x Wisconsin St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
15037 | 262257 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
15050 | 106111 | Undocumented 4 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | ||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15525 | 261460 | Undocumented 4 | Tree(s) :: 17 | 701X Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
15991 | 262259 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
16700 | 262531 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 23X Knollview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5997470 | 2101306 | 37.7496406233362 | -122.451568168016 | (37.7496406233362, -122.451568168016) | 1 | 5 | 4 | 63 | 38 | ||||
16989 | 106642 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5999139 | 2105833 | 37.7621660862312 | -122.446122313424 | (37.7621660862312, -122.446122313424) | 15 | 5 | 5 | 29492 | 3 | ||||
17244 | 112890 | Undocumented 4 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 | 1X WEBSTER ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 3x3 | 6004219 | 2108568 | 37.7699645303419 | -122.428747509741 | (37.7699645303419, -122.428747509741) | 7 | 9 | 5 | 28862 | 10 | |||
17686 | 261568 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1299 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
18337 | 113889 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 90 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
19491 | 260088 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 1100 Oakdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15x5 | 6017813 | 2093492 | 37.7293289240284 | -122.380677509991 | (37.7293289240284, -122.380677509991) | 10 | 3 | 8 | 58 | 1 | ||||
19564 | 264882 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2801 Lawton St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5985570 | 2104278 | 37.7571122644181 | -122.49293709397 | (37.7571122644181, -122.49293709397) | 1 | 8 | 3 | 56 | 35 | ||||
20737 | 114465 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 404 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||||
22418 | 100843 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
23703 | 108349 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
23862 | 102476 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 760 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
24864 | 112008 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
26601 | 258075 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1300X Wawona St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5988924 | 2097013 | 37.7373600650942 | -122.480805942066 | (37.7373600650942, -122.480805942066) | 1 | 8 | 3 | 29491 | 35 | ||||
27633 | 113114 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
28156 | 114119 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
28217 | 258038 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 55 Mercedes Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5991909 | 2093425 | 37.7276813664439 | -122.470224302167 | (37.7276813664439, -122.470224302167) | 9 | 8 | 4 | 59 | 40 | ||||
28927 | 105423 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/28/2014 12:00:00 AM | 28 | 3x20 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||
29145 | 121591 | Undocumented 4 | :: 45 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000339 | 2095263 | 37.7332118579221 | -122.441213569672 | (37.7332118579221, -122.441213569672) | 9 | 7 | 5 | 63 | 40 | ||||
29963 | 106965 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 63 BELLE AVE | Sidewalk: Property side : Yard | Tree | Private 2 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516 | (37.7085786821221, -122.47025464516) | 9 | 8 | 4 | 64 | 24 | ||||||
30007 | 114128 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
32562 | 110175 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 901 MONTEREY BLVD | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | 9 | 7 | 4 | 28861 | 40 | ||||
32748 | 108347 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
33262 | 116307 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | |||
33969 | 103647 | Undocumented 4 | Tree(s) :: 17 | 500X Oak Park Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 3x10 | 5994983.3 | 2103652.8 | 37.7559416221353 | -122.460337221652 | (37.7559416221353, -122.460337221652) | 1 | 5 | 4 | 63 | 12 | |||
34066 | 100190 | Undocumented 4 | Tree(s) :: 17 | 404 Noriega St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/07/2016 12:00:00 AM | Permit Number 776979 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||
34203 | 120900 | Undocumented 4 | Cercis occidentalis :: Western Redbud 136 | 250 States St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6000595 | 2106681 | 37.7645775245529 | -122.441147421326 | (37.7645775245529, -122.441147421326) | 15 | 5 | 5 | 28862 | 3 | ||||
35059 | 116297 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
35165 | 114121 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
35887 | 100199 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 739 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5998111 | 2095813 | 37.7345948616995 | -122.448955941335 | (37.7345948616995, -122.448955941335) | 9 | 7 | 4 | 59 | 40 | |||||
38004 | 108351 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
39243 | 110886 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
39547 | 114133 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
39549 | 101657 | Undocumented 4 | Ilex aquifolium :: European Holly 390 | 320 Santa Ana Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992576.9 | 2094712.8 | 37.7312559376124 | -122.46800901581 | (37.7312559376124, -122.46800901581) | 9 | 8 | 4 | 59 | 40 | |||||
40326 | 112011 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
40697 | 108348 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 3x3 | 5988501 | 2100296 | 37.7463497260509 | -122.482508921927 | (37.7463497260509, -122.482508921927) | 1 | 8 | 3 | 29491 | 35 | |||
41763 | 114139 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
42100 | 114131 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
42182 | 112014 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
42255 | 113119 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
42934 | 114111 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
43129 | 100849 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
44245 | 110874 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 800 INDIANA ST | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
44377 | 116296 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
46536 | 110171 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 901 MONTEREY BLVD | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | 9 | 7 | 4 | 28861 | 40 | ||||
46668 | 112015 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
46911 | 113122 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
47222 | 113141 | Undocumented 4 | Tree(s) :: 17 | 140 BROADMOOR DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/09/2015 12:00:00 AM | 3x10 | Permit Number 776484 | 5990979 | 2092893 | 37.7261668163813 | -122.473400506865 | (37.7261668163813, -122.473400506865) | 9 | 8 | 4 | 64 | 40 | ||
48775 | 100847 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
50533 | 113121 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
51148 | 105904 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 700X BROTHERHOOD WAY | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772491 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.472357697274 | (37.7129229890255, -122.472357697274) | 1 | 8 | 4 | 64 | 14 | |||||
51999 | 112013 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
52382 | 113126 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
52665 | 254470 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1601 Evans Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
53226 | 114118 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
53341 | 255638 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
53564 | 114125 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
54065 | 112009 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
54349 | 114115 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
55537 | 110897 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
55743 | 102128 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 79 Starview Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769583 | 5997451.3 | 2101874.2 | 37.7511996890852 | -122.451673814863 | (37.7511996890852, -122.451673814863) | 1 | 5 | 4 | 63 | 38 |
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) );