trees
27,746 rows where qCaretaker_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1202 | 254563 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 98x High St | 1 | unknown : Yard | Tree | DPW 1 | 3x3 | 5999731 | 2100707 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | 2 | 4 | 5 | 63 | 22 | ||||
| 14544 | 105135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X ESMERALDA AVE | 1 | unknown : Yard | Tree | DPW 1 | 26 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 21600 | 105136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175X ESMERALDA AVE | 2 | unknown : Yard | Tree | DPW 1 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | |||||
| 75714 | 114950 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 2 | unknown : Yard | Tree | DPW 1 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | ||||
| 113568 | 105140 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 125X ESMERALDA AVE | 1 | unknown : Yard | Tree | DPW 1 | 12 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 128515 | 105137 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 175X ESMERALDA AVE | 3 | unknown : Yard | Tree | DPW 1 | 18 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 133884 | 114949 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 1 | unknown : Yard | Tree | DPW 1 | 30 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | |||
| 168147 | 107817 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X BROTHERHOOD WAY | unknown : Yard | Tree | DPW 1 | 5991892 | 2087849 | 37.7123700531512 | -122.469877266524 | (37.7123700531512, -122.469877266524) | 9 | 8 | 4 | 64 | 24 | ||||||
| 172129 | 105139 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 175X ESMERALDA AVE | 4 | unknown : Yard | Tree | DPW 1 | 25 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 186602 | 105138 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 175X ESMERALDA AVE | 4 | unknown : Yard | Tree | DPW 1 | 25 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 74264 | 89023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Hollywood Ct | 1 | unknown : Cutout | Tree | DPW 1 | 6000329 | 2088600 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | 9 | 7 | 6 | 28861 | 5 | |||||
| 96062 | 108035 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 945 Market St | unknown : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774370 | 6010085.91267 | 2113154.0076 | 37.7828869372518 | -122.408777465126 | (37.7828869372518, -122.408777465126) | 14 | 2 | 9 | 28853 | 34 | ||||
| 444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
| 822 | 112248 | DPW Maintained 1 | Acer spp :: Maple 88 | 1799X TAYLOR ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 15 | 6008739 | 2118839 | 37.7984210068607 | -122.413839504702 | (37.7984210068607, -122.413839504702) | 5 | 1 | 10 | 308 | 21 | ||||
| 844 | 254210 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | |||||
| 3617 | 116648 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 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 | |||||
| 4881 | 259031 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 5158 | 116663 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 199x Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 5342 | 260946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
| 5343 | 259035 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 7 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 6781 | 259030 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 6957 | 259032 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
| 7702 | 262097 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
| 11116 | 253792 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1698X 08th Ave | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5993765 | 2103990 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | 1 | 8 | 4 | 56 | 12 | ||||
| 11415 | 260944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
| 11644 | 259033 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 12504 | 253674 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 600 x Sanchez St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 6003598 | 2104743 | 37.7594268373878 | -122.430622555907 | (37.7594268373878, -122.430622555907) | 2 | 4 | 5 | 28862 | 3 | ||||
| 12682 | 260425 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 508 Dwight St | Unaccepted Street : Yard | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010099.90949 | 2091269.80828 | 37.7227985719868 | -122.407185909529 | (37.7227985719868, -122.407185909529) | 10 | 3 | 7 | 309 | 28 | |||
| 13646 | 259034 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 14474 | 260945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
| 14634 | 259029 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 15519 | 262098 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
| 15701 | 254211 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300X Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
| 19084 | 255469 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
| 29224 | 116662 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 15 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 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 | |||||
| 34392 | 116650 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 37358 | 247943 | Planning Code 138.1 required 2 | Maytenus boaria :: Mayten 58 | 29 Joy St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | 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 | |||||
| 46465 | 253979 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 10x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
| 48753 | 116652 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 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 | |||||
| 50056 | 116646 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | ||||
| 50881 | 255163 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1599X Shotwell St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 6008036 | 2099273 | 37.744657875903 | -122.414886580728 | (37.744657875903, -122.414886580728) | 2 | 7 | 7 | 28859 | 2 | ||||
| 51208 | 255164 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1599X Shotwell St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 6008036 | 2099273 | 37.744657875903 | -122.414886580728 | (37.744657875903, -122.414886580728) | 2 | 7 | 7 | 28859 | 2 | ||||
| 51589 | 253791 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1698X 08th Ave | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5993765 | 2103990 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | 1 | 8 | 4 | 56 | 12 | ||||
| 51865 | 253673 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 600 x Sanchez St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 6003598 | 2104743 | 37.7594268373878 | -122.430622555907 | (37.7594268373878, -122.430622555907) | 2 | 4 | 5 | 28862 | 3 | ||||
| 60942 | 247939 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 29 Joy St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 12 | Permit Number 775404 | 6010258.29977 | 2098917.51569 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | 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 | |||||
| 61249 | 255468 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 6 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
| 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 | ||||
| 78182 | 113478 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6006917 | 2098966 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | 2 | 7 | 7 | 28859 | 2 | ||||
| 79127 | 253977 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 10x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
| 82049 | 116660 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | ||||
| 82654 | 116655 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 84538 | 256609 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Gatun Aly | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 10x10 | 5998560 | 2096991 | 37.7378550371804 | -122.447488368884 | (37.7378550371804, -122.447488368884) | 9 | 7 | 4 | 59 | 40 | ||||
| 85861 | 116668 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100x Esmeralda Ave | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 87228 | 116653 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 199x Esmeralda Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 87869 | 116654 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 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 | |||||
| 89775 | 116666 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Esmeralda Ave | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 91728 | 106979 | DPW Maintained 1 | Prunus domestica 'Green Gage' :: Green Gage Plum 524 | 801X Clipper St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 24 | 5999765.50041 | 2100345.59515 | 37.7471347718267 | -122.443561289165 | (37.7471347718267, -122.443561289165) | 2 | 4 | 5 | 63 | 22 | ||||
| 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 | |||||
| 104230 | 116661 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 14 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 107363 | 253795 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1698X 08th Ave | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5993765 | 2103990 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | 1 | 8 | 4 | 56 | 12 | ||||
| 110013 | 255471 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
| 117021 | 116658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 12 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 119278 | 116656 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 10 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 121978 | 255456 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 5 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
| 126738 | 247941 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.407074570729 | (37.743786764646, -122.407074570729) | 2 | 7 | 7 | 28859 | 2 | |||
| 128791 | 247940 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.28814 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | 2 | 7 | 7 | 28859 | 2 | |||
| 136498 | 116665 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 25 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
| 136862 | 105901 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
| 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 | ||||
| 143240 | 116664 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 199x Esmeralda Ave | 18 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 144056 | 109200 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2401x CASTRO ST | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
| 147519 | 116647 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 161643 | 253794 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1698X 08th Ave | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5993765 | 2103990 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | 1 | 8 | 4 | 56 | 12 | ||||
| 162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 | |||
| 162602 | 116651 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 170196 | 255470 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
| 171826 | 116667 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100x Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 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 | |||||
| 177441 | 253793 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1698X 08th Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5993765 | 2103990 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | 1 | 8 | 4 | 56 | 12 | ||||
| 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 | |||||
| 180287 | 116659 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 12 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 180982 | 113477 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Esmeralda Ave | 10 | Unaccepted Street : Yard | Tree | DPW 1 | 24 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
| 189511 | 105902 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 40 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
| 190684 | 253976 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 10x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
| 190766 | 116649 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 199x Esmeralda Ave | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 192771 | 116657 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 11 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 6239 | 261665 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 401X Greenwich St | 1 | Unaccepted Street : Cutout | Tree | DPW 1 | |||||||||||||||
| 127698 | 257930 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000X Hudson Ave | Unaccepted Street : Cutout | Tree | DPW 1 | 3x3 | 6018755 | 2095128 | 37.7338730033489 | -122.377534379141 | (37.7338730033489, -122.377534379141) | 10 | 3 | 8 | 58 | 1 | |||||
| 100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 187 | 112917 | DPW Maintained 1 | Shrub :: Shrub 66 | 480X BEACON ST | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6002571 | 2098077 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | 2 | 7 | 5 | 63 | 7 | |||||
| 485 | 251655 | DPW Maintained 1 | Shrub :: Shrub 66 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5991691 | 2087193 | 37.7105572148468 | -122.470524229297 | (37.7105572148468, -122.470524229297) | 9 | 8 | 4 | 64 | 24 |
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) );