trees
8,298 rows where qLegalStatus_id = 4 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11428 | 122390 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x2 | 5991007 | 2102078 | 37.7513881006776 | -122.473973545995 | (37.7513881006776, -122.473973545995) | 1 | 8 | 4 | 29491 | 12 | |||
11756 | 108765 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
12031 | 262472 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
16427 | 262473 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
17025 | 262527 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
18953 | 103670 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 4428-4430 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 770987 | 6000065 | 2105781 | 37.7620761444221 | -122.442915908064 | (37.7620761444221, -122.442915908064) | 15 | 5 | 5 | 28862 | 3 | |
22885 | 81254 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | 11 | 6 | 2 | 55 | 26 | |
27329 | 98505 | Undocumented 4 | Tree(s) :: 17 | 135 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042 | 2096528 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | 2 | 7 | 5 | 63 | 7 | |
30889 | 254841 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 71 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5993910 | 2115089 | 37.7872805943627 | -122.464879512834 | (37.7872805943627, -122.464879512834) | 11 | 6 | 1 | 54 | 11 | |
34794 | 83038 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | 10 | 3 | 8 | 58 | 1 | |||
42029 | 254843 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1814 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5993025 | 2112122 | 37.7790829564028 | -122.467725532477 | (37.7790829564028, -122.467725532477) | 11 | 6 | 2 | 54 | 11 | |||
44767 | 111955 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 49 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5987872.34655427 | 2115783.06288074 | 37.7888363303163 | -122.485819211038 | (37.7888363303163, -122.485819211038) | 11 | 6 | 1 | 55 | 33 | |||
48117 | 254837 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5992465 | 2114587 | 37.7858188208387 | -122.469842298582 | (37.7858188208387, -122.469842298582) | 11 | 6 | 2 | 54 | 11 | |||
48539 | 121582 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6013716 | 2106401 | 37.7645473527506 | -122.395745461209 | (37.7645473527506, -122.395745461209) | 14 | 3 | 8 | 28856 | 29 | |||
50203 | 98247 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | I think these were planted in 2010 by FUF. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | 7 | 9 | 9 | 28858 | 36 | ||
51515 | 84511 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 670 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6002290 | 2089910 | 37.7186246694004 | -122.434085914673 | (37.7186246694004, -122.434085914673) | 9 | 7 | 6 | 28861 | 5 | ||
53715 | 108962 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
55800 | 108629 | Undocumented 4 | :: 45 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | 15 | 5 | 5 | 29492 | 9 | |||
59154 | 85056 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 461 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2015 12:00:00 AM | 3 | 3x3 | 6014316 | 2113315 | 37.7835650081482 | -122.394154287965 | (37.7835650081482, -122.394154287965) | 6 | 2 | 9 | 28856 | 6 | |
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 | |||
65411 | 82956 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
66135 | 256157 | Undocumented 4 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 147 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010099 | 2100108 | 37.7470663082642 | -122.407811966192 | (37.7470663082642, -122.407811966192) | 2 | 7 | 7 | 28859 | 2 | |||
66329 | 108965 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
68588 | 101001 | Undocumented 4 | Tree(s) :: 17 | 500X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2012 12:00:00 AM | Permit Number 769389 | 6008398.5 | 2096033.1 | 37.7357821841588 | -122.413404038925 | (37.7357821841588, -122.413404038925) | 10 | 7 | 7 | 28859 | 2 | ||
70739 | 83691 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 201 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/2005 12:00:00 AM | 8 | 6004196.42852 | 2092337.1873 | 37.7253972052947 | -122.427669003321 | (37.7253972052947, -122.427669003321) | 9 | 7 | 6 | 28861 | 5 | ||
74696 | 81381 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.416883582419 | (37.7863320683098, -122.416883582419) | 13 | 1 | 9 | 28858 | 36 | ||
77895 | 82955 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
78649 | 109077 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 360 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5993247.8 | 2113128.2 | 37.7818585707794 | -122.467027956142 | (37.7818585707794, -122.467027956142) | 11 | 6 | 2 | 54 | 11 | ||||
84636 | 82952 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
87888 | 83699 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 52 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769773 | 6002629 | 2105596 | 37.7617140260812 | -122.434034805509 | (37.7617140260812, -122.434034805509) | 15 | 4 | 5 | 28862 | 3 |
88661 | 122385 | Undocumented 4 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 778904 | 5990935 | 2104213 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | 1 | 8 | 4 | 56 | 12 | ||
91014 | 74195 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1035 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1995 12:00:00 AM | 9 | 6007605.80977 | 2115075.33872 | 37.7880232200293 | -122.417493821895 | (37.7880232200293, -122.417493821895) | 13 | 1 | 10 | 28858 | 21 | ||
92726 | 98506 | Undocumented 4 | Tree(s) :: 17 | 135 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042 | 2096528 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | 2 | 7 | 5 | 63 | 7 | |
95952 | 98507 | Undocumented 4 | Tree(s) :: 17 | 135 Sussex St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042 | 2096528 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | 2 | 7 | 5 | 63 | 7 | |
109358 | 254808 | Undocumented 4 | Zelkova serrata :: Sawleaf Zelkova 302 | 478 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5992861 | 2112216 | 37.7793315841081 | -122.468299710441 | (37.7793315841081, -122.468299710441) | 11 | 6 | 2 | 54 | 11 | |||
110125 | 108826 | Undocumented 4 | :: 45 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | ||||
112891 | 82953 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
113567 | 110268 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 282 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3x3 | 6004065.51901322 | 2099574.2006491 | 37.7452610006153 | -122.428637192649 | (37.7452610006153, -122.428637192649) | 2 | 7 | 5 | 63 | 22 | ||
117024 | 96891 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 202 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | 3x3 | 6000536.2 | 2102231.9 | 37.7523580354324 | -122.441031584455 | (37.7523580354324, -122.441031584455) | 2 | 4 | 5 | 28862 | 22 | ||
119767 | 84504 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 650X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.7755755804602 | -122.410668559049 | (37.7755755804602, -122.410668559049) | 8 | 2 | 9 | 28853 | 34 | |
119923 | 254807 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 174 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 5992784 | 2114325 | 37.7851178746206 | -122.468719586357 | (37.7851178746206, -122.468719586357) | 11 | 6 | 2 | 54 | 11 | |||
123948 | 75029 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
127070 | 254844 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 475 Arkansas St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6013011 | 2104854 | 37.7602603887437 | -122.398075345371 | (37.7602603887437, -122.398075345371) | 10 | 3 | 8 | 28856 | 29 | ||
128208 | 84505 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 650 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.7755755804602 | -122.410668559049 | (37.7755755804602, -122.410668559049) | 8 | 2 | 9 | 28853 | 34 | |
132603 | 74892 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
133039 | 97497 | Undocumented 4 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1520 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2010 12:00:00 AM | 3 | 3x3 | 6015724.7 | 2096772.7 | 37.7382215976335 | -122.388125873954 | (37.7382215976335, -122.388125873954) | 10 | 3 | 8 | 58 | 1 | |
135270 | 254842 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 145 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5993002 | 2114530 | 37.7856933397401 | -122.467980297479 | (37.7856933397401, -122.467980297479) | 11 | 6 | 2 | 54 | 11 | |
140003 | 30525 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.413624143987 | (37.7811193385199, -122.413624143987) | 7 | 10 | 9 | 28852 | 36 | |
142114 | 108771 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
143633 | 121421 | Undocumented 4 | Tree(s) :: 17 | 301 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2016 12:00:00 AM | 3 | Permit Number 779128 | 6001229.40575975 | 2096509.00524046 | 37.7366837791531 | -122.438224431893 | (37.7366837791531, -122.438224431893) | 2 | 7 | 5 | 63 | 7 | |
151439 | 108964 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
155686 | 37756 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 1233 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40103 | 6010069.75990931 | 2102022.02439605 | 37.7523201600523 | -122.408048036965 | (37.7523201600523, -122.408048036965) | 2 | 4 | 7 | 28859 | 19 | ||
159934 | 68048 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2000 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2004 12:00:00 AM | Permit Number 31785 | 5993199.49138674 | 2101849.51717042 | 37.7508874994446 | -122.466375113285 | (37.7508874994446, -122.466375113285) | 1 | 8 | 4 | 29491 | 40 | ||
166767 | 82302 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 852 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2005 12:00:00 AM | 6010413.10633886 | 2104268.77797616 | 37.7585084630291 | -122.407019031742 | (37.7585084630291, -122.407019031742) | 10 | 4 | 7 | 28859 | 19 | |||
166900 | 103694 | Undocumented 4 | Tree(s) :: 17 | 1867 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5993101.5 | 2102776.7 | 37.7534276501093 | -122.46678136639 | (37.7534276501093, -122.46678136639) | 1 | 8 | 4 | 56 | 12 | ||
167164 | 82954 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
171072 | 99251 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1999X Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 5998316.3 | 2109969.5 | 37.7734768483436 | -122.44926573694 | (37.7734768483436, -122.44926573694) | 15 | 5 | 11 | 29492 | 16 | ||
178575 | 96914 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4396X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | 3x3 | Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. | 6000641.3 | 2102303.1 | 37.7525595190983 | -122.440673239158 | (37.7525595190983, -122.440673239158) | 2 | 4 | 5 | 28862 | 22 | |
178663 | 73430 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 657 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1994 12:00:00 AM | 8 | 6001050.4616 | 2111002.9975 | 37.776470583651 | -122.439882012858 | (37.776470583651, -122.439882012858) | 15 | 5 | 11 | 29492 | 10 | ||
182222 | 98246 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | I think these were planted by FUF in 2010. C.Buck | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | 7 | 9 | 9 | 28858 | 36 | ||
183789 | 255426 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1634 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5986904 | 2104124 | 37.756767344902 | -122.488312354714 | (37.756767344902, -122.488312354714) | 1 | 8 | 3 | 56 | 35 | |||
191343 | 254839 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 673 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5994992 | 2110964 | 37.776016775414 | -122.460836981253 | (37.776016775414, -122.460836981253) | 11 | 6 | 2 | 54 | 11 | |
192657 | 73935 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 98x LANDERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1984 12:00:00 AM | 13 | 3x3 | 6004473 | 2107480 | 37.7669915173508 | -122.427791394155 | (37.7669915173508, -122.427791394155) | 8 | 4 | 5 | 28862 | 3 | |
19907 | 102028 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
20806 | 102022 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
24545 | 70470 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
24943 | 98739 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
25379 | 70471 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 450X Banks St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 32 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
29904 | 98737 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 24 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
33305 | 102189 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
35858 | 102033 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
38321 | 102024 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
38711 | 116976 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 7 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
46093 | 95466 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 529X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986555.1 | 2112324.8 | 37.7792640886788 | -122.490122160768 | (37.7792640886788, -122.490122160768) | 11 | 6 | 2 | 55 | 26 | ||
46177 | 73875 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 450X Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 8 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
48405 | 102030 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
51914 | 95459 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 657X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 5986588.2 | 2111449.2 | 37.776861872872 | -122.489943238472 | (37.776861872872, -122.489943238472) | 11 | 6 | 2 | 55 | 26 | ||
52882 | 102190 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
56850 | 98746 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
57036 | 98749 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
57109 | 102194 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
61217 | 98752 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
69126 | 102186 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3999X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
70160 | 95470 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 539X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986557.7 | 2112257.8 | 37.7790802775989 | -122.490108236864 | (37.7790802775989, -122.490108236864) | 11 | 6 | 2 | 55 | 26 | ||
73387 | 113573 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 901 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007813 | 2120272 | 37.8023036186348 | -122.417145352251 | (37.8023036186348, -122.417145352251) | 5 | 1 | 10 | 308 | 32 | |||
76443 | 102025 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
78897 | 102155 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
84100 | 77325 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/18/1988 12:00:00 AM | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | |
84673 | 98750 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
88151 | 98756 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
90910 | 98754 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
92461 | 113825 | Undocumented 4 | Arbutus unedo :: Strawberry Tree 106 | 1599x CASTRO ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/10/2015 12:00:00 AM | 8 | 3x3 | 6002577 | 2101074 | 37.7492947436898 | -122.433891418078 | (37.7492947436898, -122.433891418078) | 2 | 4 | 5 | 28862 | 22 | |
97154 | 70472 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
100826 | 78999 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 555 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
103551 | 102191 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
104727 | 78992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
108397 | 102154 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
113529 | 102032 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
115066 | 113570 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 901 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 |
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) );