Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20943 | 20943 | 6386 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 205 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6006831.93965 | 2097911.00568 | 37.7408504143285 | -122.418953412568 | (37.7408504143285, -122.418953412568) | ||
| 122385 | 122385 | 24782 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 11:32:00 AM | 3 | 3X3 | 5982618.00441 | 2112505.45131 | 37.7795294010781 | -122.503755361445 | (37.7795294010781, -122.503755361445) | ||
| 115333 | 115333 | 30525 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.41362414398701 | (37.7811193385199, -122.413624143987) | |
| 142724 | 142724 | 30896 | Undocumented 2 | Tree(s) :: 17 | 269 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | Permit Number 769507 | 6007561.84389721 | 2097402.01234102 | 37.7394939049755 | -122.416393625431 | (37.7394939049755, -122.416393625431) | |||
| 145205 | 145205 | 34955 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38552 | 5990784.0 | 2114938.0 | 37.786685259506996 | -122.475683667555 | (37.786685259507, -122.475683667555) | ||||
| 89642 | 89642 | 34959 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 29 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 38552 | 5990777.0 | 2114840.0 | 37.7864157730855 | -122.475700726719 | (37.7864157730855, -122.475700726719) | |||
| 42870 | 42870 | 34960 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 30 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 38552 | 5990852.38524 | 2114893.77417 | 37.7865677920504 | -122.47544384317699 | (37.7865677920504, -122.475443843177) | ||
| 120209 | 120209 | 37756 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1233 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40103 | 6010069.75990931 | 2102022.02439605 | 37.75232016005229 | -122.40804803696501 | (37.7523201600523, -122.408048036965) | ||
| 13737 | 13737 | 38759 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 325 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | Permit Number 40631 | 6011796.14841 | 2112034.18458 | 37.7799078071241 | -122.40278194745399 | (37.7799078071241, -122.402781947454) | |||
| 169075 | 169075 | 56603 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4199@43rd Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 5982724.27515302 | 2106932.91664164 | 37.764235082111895 | -122.50297507862801 | (37.7642350821119, -122.502975078628) | ||||
| 97394 | 97394 | 58598 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/19/1979 12:00:00 AM | Permit Number 17804 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||
| 152682 | 152682 | 64515 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 720 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 6 | 3x3 | Permit Number 25396 | 6000553.55593738 | 2111421.0223091 | 37.7775900754915 | -122.44163095230499 | (37.7775900754915, -122.441630952305) |
| 119964 | 119964 | 68048 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2000 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 31785 | 5993199.49138674 | 2101849.51717042 | 37.7508874994446 | -122.46637511328501 | (37.7508874994446, -122.466375113285) | ||
| 135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
| 23201 | 23201 | 69744 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1855X Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/2002 12:00:00 AM | 8 | 3x3 | 6014390.51341 | 2099418.69013 | 37.7454129250631 | -122.392923937985 | (37.7454129250631, -122.392923937985) | |
| 132672 | 132672 | 69750 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 805 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 10 | 6008877.581730001 | 2090316.9331 | 37.720113693661496 | -122.411343969962 | (37.7201136936615, -122.411343969962) | ||
| 134601 | 134601 | 69761 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3621 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | 5981890.0592 | 2100093.2822 | 37.7454063146777 | -122.50535336411001 | (37.7454063146777, -122.50535336411) | ||
| 27369 | 27369 | 69766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6014547.15395 | 2096165.5632900002 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | ||
| 157408 | 157408 | 69788 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1526 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2001 12:00:00 AM | 1 | 5982204.5216 | 2104686.309 | 37.758035976388896 | -122.50460626225299 | (37.7580359763889, -122.504606262253) | ||
| 10582 | 10582 | 69800 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 3x3 | 5999779.7835 | 2091764.7216900003 | 37.7235745268131 | -122.442895800812 | (37.7235745268131, -122.442895800812) | |
| 181521 | 181521 | 69802 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 627 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 5 | 5985028.72707 | 2111563.88652 | 37.7770855845831 | -122.495346307533 | (37.7770855845831, -122.495346307533) | ||
| 26277 | 26277 | 69804 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 510 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | 3 | 6010631.84232 | 2105884.1713400004 | 37.7629562079975 | -122.406376362283 | (37.7629562079975, -122.406376362283) | ||
| 152509 | 152509 | 69819 | Undocumented 2 | Tristania conferta :: 79 | 3521 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/04/2001 12:00:00 AM | 5 | 5983899.4988 | 2104926.7311 | 37.7587956653789 | -122.49876216104799 | (37.7587956653789, -122.498762161048) | ||
| 10248 | 10248 | 69823 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2017 12:00:00 AM | 3 | 5985346.30869 | 2112623.83377 | 37.7800144848575 | -122.49432585822201 | (37.7800144848575, -122.494325858222) | ||
| 148045 | 148045 | 69848 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 731 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 14 | 6001876.2487699995 | 2089667.3369599998 | 37.7179348800801 | -122.43549873219 | (37.7179348800801, -122.43549873219) | ||
| 28586 | 28586 | 69849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Bernice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 6 | 6008480.655259999 | 2108494.13228 | 37.7700019816405 | -122.414001247166 | (37.7700019816405, -122.414001247166) | ||
| 59691 | 59691 | 69869 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2075 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | 5982287.0182 | 2100994.7374 | 37.747904810916 | -122.50404752601101 | (37.747904810916, -122.504047526011) | ||
| 45084 | 45084 | 69872 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 6 | 3x3 | 5985114.18885 | 2110476.07325 | 37.774103764151896 | -122.49497044343599 | (37.7741037641519, -122.494970443436) | |
| 61684 | 61684 | 69888 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1094 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 10 | 6012175.72633 | 2103309.76161 | 37.755973692659396 | -122.40085568686101 | (37.7559736926594, -122.400855686861) | ||
| 47604 | 47604 | 69898 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277004 | -122.401657284058 | (37.756311243277, -122.401657284058) | ||
| 150828 | 150828 | 69901 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 8 | 6002511.3219099995 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | ||
| 46846 | 46846 | 69918 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1285 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5986443.4748 | 2106504.0514 | 37.7632754302753 | -122.490080055854 | (37.7632754302753, -122.490080055854) | ||
| 52984 | 52984 | 69922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | ||
| 159745 | 159745 | 69952 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 565 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 8 | 5997087.15611 | 2114145.30542 | 37.7848721322932 | -122.453819112066 | (37.7848721322932, -122.453819112066) | ||
| 109420 | 109420 | 69960 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1084 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1991 12:00:00 AM | 9 | 6007591.27933 | 2109447.46349 | 37.772569612617396 | -122.417145153823 | (37.7725696126174, -122.417145153823) | ||
| 167899 | 167899 | 69965 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/1992 12:00:00 AM | 1 | 5992352.5387699995 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | ||
| 177768 | 177768 | 69981 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 484 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1992 12:00:00 AM | 6 | 5989401.882680001 | 2112073.46426 | 37.77873982444579 | -122.480255670786 | (37.7787398244458, -122.480255670786) | ||
| 176350 | 176350 | 70009 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1815 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1992 12:00:00 AM | 7 | 6005608.75345 | 2092244.69483 | 37.725223029103 | -122.422780149308 | (37.725223029103, -122.422780149308) | ||
| 34835 | 34835 | 70020 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 6 | 5999648.4798 | 2110952.3759 | 37.7762516842269 | -122.44472821069598 | (37.7762516842269, -122.444728210696) | ||
| 60617 | 60617 | 70028 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 555 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/11/1992 12:00:00 AM | 5 | 5983452.32231 | 2112030.7596400003 | 37.7782750565666 | -122.500834032057 | (37.7782750565666, -122.500834032057) | ||
| 76042 | 76042 | 70030 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 66 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 12 | 5998160.61879 | 2114184.40287 | 37.7850409692213 | -122.450108115392 | (37.7850409692213, -122.450108115392) | ||
| 76707 | 76707 | 70037 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 8 | 5997501.9549 | 2113240.3611 | 37.7824111665106 | -122.452318727664 | (37.7824111665106, -122.452318727664) | ||
| 106376 | 106376 | 70051 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 41 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004919.1 | 2098072.4 | 37.7411856692636 | -122.425578786628 | (37.7411856692636, -122.425578786628) | |||
| 188342 | 188342 | 70057 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014037.2583099995 | 2095146.8497099997 | 37.7336637097057 | -122.393846481427 | (37.7336637097057, -122.393846481427) | ||
| 162427 | 162427 | 70065 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 370 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1992 12:00:00 AM | 12 | 6014415.94114 | 2112258.2554200003 | 37.780668982520105 | -122.393734537439 | (37.7806689825201, -122.393734537439) | ||
| 150226 | 150226 | 70072 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 460-462 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1992 12:00:00 AM | 2 | 6014075.24964 | 2112803.80145 | 37.782147989586704 | -122.39495138219802 | (37.7821479895867, -122.394951382198) | ||
| 155367 | 155367 | 70074 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 91 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1992 12:00:00 AM | 10 | 6013768.5355 | 2112749.30227 | 37.781981287647206 | -122.396008662095 | (37.7819812876472, -122.396008662095) | ||
| 164965 | 164965 | 70083 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 224 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 11 | 6006483.02411 | 2092857.70117 | 37.7269555010695 | -122.41980135455 | (37.7269555010695, -122.41980135455) | ||
| 175192 | 175192 | 70089 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3226 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 8 | 5988610.07597 | 2111937.01448 | 37.778319129444604 | -122.482984802914 | (37.7783191294446, -122.482984802914) | ||
| 172917 | 172917 | 70102 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 3016 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 5 | 5989286.3225 | 2111962.37495 | 37.778428088511795 | -122.48064729942301 | (37.7784280885118, -122.480647299423) | ||
| 60789 | 60789 | 70103 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 235 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/1993 12:00:00 AM | 9 | 6000491.71169 | 2091975.9188 | 37.7241949888819 | -122.440449937109 | (37.7241949888819, -122.440449937109) | ||
| 183539 | 183539 | 70108 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2059 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 14 | 5987239.8218 | 2101265.4744 | 37.7489381940905 | -122.486941055856 | (37.7489381940905, -122.486941055856) | ||
| 154422 | 154422 | 70110 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 79 Stoneyford Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1999 12:00:00 AM | 9 | 6006114.15907 | 2093862.3893900001 | 37.7296933683514 | -122.42114782490499 | (37.7296933683514, -122.421147824905) | ||
| 171645 | 171645 | 70112 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1370 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 2 | 6001294.7984 | 2110430.7519 | 37.774913246746294 | -122.438995763743 | (37.7749132467463, -122.438995763743) | ||
| 135911 | 135911 | 70116 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 14 | 6006256.51205 | 2117265.43085 | 37.793960654804295 | -122.422317826729 | (37.7939606548043, -122.422317826729) | ||
| 45829 | 45829 | 70117 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 6000875.3973900005 | 2088278.84235 | 37.714065490318106 | -122.438858781914 | (37.7140654903181, -122.438858781914) | ||
| 46270 | 46270 | 70119 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1590 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 11 | 3x3 | 6006574.99187 | 2117356.21064 | 37.7942278730643 | -122.421222302288 | (37.7942278730643, -122.421222302288) | |
| 62331 | 62331 | 70121 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | 5988662.200680001 | 2110577.24438 | 37.7745886129839 | -122.48270481422199 | (37.7745886129839, -122.482704814222) | ||
| 179705 | 179705 | 70127 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 236 Avalon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 9 | 6003416.21624 | 2092787.3454599997 | 37.726589075011894 | -122.430398228113 | (37.7265890750119, -122.430398228113) | ||
| 161889 | 161889 | 70130 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2614 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 3 | 5990525.20475 | 2112006.61125 | 37.7786214745109 | -122.476364817556 | (37.7786214745109, -122.476364817556) | ||
| 181725 | 181725 | 70134 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 342-344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010584.92199 | 2106684.72003 | 37.7651517084965 | -122.40659506122499 | (37.7651517084965, -122.406595061225) | ||
| 45067 | 45067 | 70144 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1993 12:00:00 AM | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | ||
| 164270 | 164270 | 70145 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 32 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1993 12:00:00 AM | 4 | 5991181.63526 | 2114912.21638 | 37.786637509270705 | -122.47430607653901 | (37.7866375092707, -122.474306076539) | ||
| 130895 | 130895 | 70147 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2927 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 10 | 5989529.51616 | 2111917.79074 | 37.7783198039619 | -122.479802747413 | (37.7783198039619, -122.479802747413) | ||
| 161848 | 161848 | 70149 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 754 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 8 | 5989468.1167 | 2110177.57013 | 37.773538072981204 | -122.479887770247 | (37.7735380729812, -122.479887770247) | ||
| 31581 | 31581 | 70151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 846 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1993 12:00:00 AM | 7 | 6007647.41454 | 2114440.4952 | 37.786282435643 | -122.41730487074699 | (37.786282435643, -122.417304870747) | ||
| 45066 | 45066 | 70152 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 7 | 5993349.447480001 | 2113931.04039 | 37.78406881848979 | -122.46673468365299 | (37.7840688184898, -122.466734683653) | ||
| 185667 | 185667 | 70154 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | ||
| 29232 | 29232 | 70157 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 146 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 4 | 5991828.15451 | 2114449.0887700003 | 37.7854033229881 | -122.472035528968 | (37.7854033229881, -122.472035528968) | ||
| 70828 | 70828 | 70160 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 500X 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 10 | 5989407.07315 | 2111876.85603 | 37.778200294585794 | -122.480223321553 | (37.7782002945858, -122.480223321553) | ||
| 125226 | 125226 | 70167 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 831 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | Permit Number 773700 | 5981976.78091 | 2110066.45395 | 37.772794906459 | -122.505792724366 | (37.772794906459, -122.505792724366) | |
| 46613 | 46613 | 70168 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5129 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 6 | 5982718.93125 | 2111668.1719299997 | 37.7772364107813 | -122.50334420523399 | (37.7772364107813, -122.503344205234) | ||
| 26055 | 26055 | 70169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 3 | 5982394.507019999 | 2111657.31782 | 37.777187531817496 | -122.504465669217 | (37.7771875318175, -122.504465669217) | ||
| 77101 | 77101 | 70171 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 6 | 5990355.07569 | 2110118.2458599997 | 37.7734266747554 | -122.476815345127 | (37.7734266747554, -122.476815345127) | ||
| 174959 | 174959 | 70172 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 3027 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 8 | 5989237.11171 | 2111905.73167 | 37.7782697016213 | -122.48081338803101 | (37.7782697016213, -122.480813388031) | ||
| 64885 | 64885 | 70173 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 246 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 10 | 5992471.1879 | 2113801.97828 | 37.783663724759705 | -122.469763717453 | (37.7836637247597, -122.469763717453) | ||
| 63088 | 63088 | 70176 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.5320099997 | 37.7230227297861 | -122.42729139328999 | (37.7230227297861, -122.42729139329) | |
| 26197 | 26197 | 70177 | Undocumented 2 | Melaleuca styphelliodes :: Paperbark Tree 239 | 775 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 11 | 5994102.47966 | 2110307.2614 | 37.7741623246726 | -122.463866362064 | (37.7741623246726, -122.463866362064) | ||
| 156474 | 156474 | 70178 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2773 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 13 | 5995856.05211 | 2110667.73929 | 37.775252999682706 | -122.45782657339399 | (37.7752529996827, -122.457826573394) | ||
| 142311 | 142311 | 70188 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3935 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1993 12:00:00 AM | 12 | 3x3 | 6002726.78145239 | 2105880.26827571 | 37.762500106808 | -122.433716936937 | (37.762500106808, -122.433716936937) | ||
| 75467 | 75467 | 70196 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1446 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 3 | 5983732.7598 | 2105312.8211 | 37.759845979145105 | -122.499367343386 | (37.7598459791451, -122.499367343386) | ||
| 45060 | 45060 | 70199 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 479-481 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 5990281.69585 | 2112130.11385 | 37.778946453452896 | -122.477216227307 | (37.7789464534529, -122.477216227307) | ||
| 59852 | 59852 | 70200 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 651 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 9 | 6002623.55844 | 2089844.48662 | 37.7184637093015 | -122.432928262055 | (37.7184637093015, -122.432928262055) | ||
| 32765 | 32765 | 70201 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | ||
| 37064 | 37064 | 70204 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1466 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 2 | 5983116.0005 | 2105270.034 | 37.7596922939576 | -122.501497212024 | (37.7596922939576, -122.501497212024) | ||
| 126113 | 126113 | 70206 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 399X NOE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1993 12:00:00 AM | 18 | 4x4 | 6002980.0 | 2105940.0 | 37.7626784807523 | -122.432845414735 | (37.7626784807523, -122.432845414735) | ||
| 169753 | 169753 | 70219 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2519 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1993 12:00:00 AM | 2 | 5999766.96115 | 2119470.2848900002 | 37.7996463981067 | -122.444930811031 | (37.7996463981067, -122.444930811031) | ||
| 71924 | 71924 | 70223 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 2011 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 7 | 5989310.46344 | 2111227.07993 | 37.776410575875 | -122.480509949706 | (37.776410575875, -122.480509949706) | ||
| 137670 | 137670 | 70224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 774 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 9 | 5991346.67049 | 2110134.70461 | 37.7735293356805 | -122.473386511602 | (37.7735293356805, -122.473386511602) | ||
| 135519 | 135519 | 70226 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1466 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 10 | 5982190.0408 | 2105127.5478 | 37.759246640966 | -122.504689034952 | (37.759246640966, -122.504689034952) | ||
| 37880 | 37880 | 70231 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | ||
| 27399 | 27399 | 70234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983192.21244 | 2110893.91815 | 37.775138345619396 | -122.501649705941 | (37.7751383456194, -122.501649705941) | ||
| 48912 | 48912 | 70236 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2028 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 5 | 5998104.2899 | 2110331.105 | 37.7744575935246 | -122.450025174657 | (37.7744575935246, -122.450025174657) | ||
| 137136 | 137136 | 70242 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 534 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 10 | 6002535.969769999 | 2090796.29844 | 37.7210722045999 | -122.43329899495701 | (37.7210722045999, -122.433298994957) | ||
| 65152 | 65152 | 70244 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 322 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 2 | 6005809.1541 | 2110870.1551 | 37.776375562865205 | -122.423410874448 | (37.7763755628652, -122.423410874448) | ||
| 163200 | 163200 | 70250 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1475 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 10 | 5982457.955 | 2105055.9033 | 37.759065681929 | -122.503757167883 | (37.759065681929, -122.503757167883) | ||
| 47374 | 47374 | 70252 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1993 12:00:00 AM | 10 | 6001164.2534 | 2110490.0118 | 37.7750685309709 | -122.43945159440399 | (37.7750685309709, -122.439451594404) | ||
| 184733 | 184733 | 70261 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3828 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 7 | 5996527.35216 | 2114976.8204799998 | 37.787123139867795 | -122.455815970326 | (37.7871231398678, -122.455815970326) | ||
| 66578 | 66578 | 70266 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 8 | 5988762.33088 | 2112478.2196299997 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | ||
| 50558 | 50558 | 70268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 656 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 11 | 6002561.31186 | 2089826.6998700001 | 37.71841134000321 | -122.43314215230801 | (37.7184113400032, -122.433142152308) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");