Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186618 | 186618 | 115552 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 15x7 | 6015276.56251 | 2104229.2059299997 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | ||
| 183769 | 183769 | 95151 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988720.99449 | 2113605.53219 | 37.7829068638151 | -122.482723403965 | (37.7829068638151, -122.482723403965) | |||
| 183247 | 183247 | 98791 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) | |
| 180919 | 180919 | 115549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | ||
| 174085 | 174085 | 43304 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 19 | Permit Number 43072 | 6011287.96925 | 2105166.37556 | 37.7610219838923 | -122.404056515205 | (37.7610219838923, -122.404056515205) | |
| 172027 | 172027 | 116857 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 950x Clay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6010080.350930001 | 2117187.65635 | 37.793962057763 | -122.409081415981 | (37.793962057763, -122.409081415981) | ||
| 172003 | 172003 | 98805 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950x Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010143.10639 | 2117195.10642 | 37.793986029186 | -122.408864800763 | (37.793986029186, -122.408864800763) |
| 170121 | 170121 | 116065 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 8x7 | 6011274.01561 | 2105377.63125 | 37.761601265113896 | -122.404119643106 | (37.7616012651139, -122.404119643106) | ||
| 168957 | 168957 | 116048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4x4 | 6011498.51602 | 2105372.79225 | 37.7616005195649 | -122.403342842915 | (37.7616005195649, -122.403342842915) | ||
| 166938 | 166938 | 116059 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011431.5308 | 2105131.75607 | 37.760934946603605 | -122.40355755965099 | (37.7609349466036, -122.403557559651) | ||
| 166820 | 166820 | 110958 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x5 | 6008447.06762 | 2119689.6105 | 37.8007401724743 | -122.414909918573 | (37.8007401724743, -122.414909918573) | ||
| 163336 | 163336 | 95153 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 5988721.4522400005 | 2113658.22406 | 37.783051567455004 | -122.482725682991 | (37.783051567455, -122.482725682991) | |||
| 163065 | 163065 | 116050 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011499.79329 | 2105331.08163 | 37.76148606285779 | -122.403335490949 | (37.7614860628578, -122.403335490949) | ||
| 159681 | 159681 | 73495 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | ||
| 158398 | 158398 | 116058 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011458.59484 | 2105134.56728 | 37.760944177262004 | -122.403464154268 | (37.760944177262, -122.403464154268) | ||
| 158318 | 158318 | 116046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 5x15 | 6011495.20108 | 2105434.8979700003 | 37.761770862847705 | -122.40335867726002 | (37.7617708628477, -122.40335867726) | ||
| 156514 | 156514 | 122751 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 6011280.99043 | 2105260.13165 | 37.7612790272197 | -122.40408725043301 | (37.7612790272197, -122.404087250433) | |||
| 155253 | 155253 | 115550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.39018178636199 | (37.7584697654838, -122.390181786362) | ||
| 152078 | 152078 | 110955 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008486.881990001 | 2119694.39066 | 37.8007555347125 | -122.41477248237699 | (37.8007555347125, -122.414772482377) | ||
| 151441 | 151441 | 70932 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 14 | 5988727.46903 | 2113517.2675099997 | 37.7826648905872 | -122.48269453478301 | (37.7826648905872, -122.482694534783) | ||
| 146991 | 146991 | 95155 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 5988718.098730001 | 2113738.3311400004 | 37.7832713237769 | -122.482743157022 | (37.7832713237769, -122.482743157022) | |||
| 146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 145918 | 145918 | 47257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52469 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 145909 | 145909 | 42986 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 3 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 145720 | 145720 | 98741 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
| 145659 | 145659 | 99685 | DPW Maintained 3 | Tree(s) :: 17 | 165 Grattan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 145524 | 145524 | 96494 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2500X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5x5 | 6008744.0 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | |||
| 145453 | 145453 | 95270 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2245 Jones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/23/2016 02:41:00 PM | 3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||
| 145283 | 145283 | 76112 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) | |
| 145208 | 145208 | 95259 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 145137 | 145137 | 77213 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 145003 | 145003 | 99547 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | ||
| 144911 | 144911 | 76325 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 5 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 144736 | 144736 | 96510 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 144482 | 144482 | 98742 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
| 144409 | 144409 | 42358 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 4x4 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 144344 | 144344 | 99682 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 144331 | 144331 | 99257 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 151X Palm Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5995884.6314900005 | 2113369.4177200003 | 37.782672735096504 | -122.457923263549 | (37.7826727350965, -122.457923263549) | ||
| 143933 | 143933 | 113572 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
| 143508 | 143508 | 95265 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 143471 | 143471 | 99669 | DPW Maintained 3 | Tree(s) :: 17 | 150X Alma St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x6 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 143233 | 143233 | 76675 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 8 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 143137 | 143137 | 76749 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 143015 | 143015 | 75386 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 163X London St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 142922 | 142922 | 95471 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986558.17112 | 2112222.9767400003 | 37.778984690357 | -122.49010404497 | (37.778984690357, -122.49010404497) | ||
| 142799 | 142799 | 99688 | DPW Maintained 3 | Tree(s) :: 17 | 165 Grattan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 142763 | 142763 | 98802 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.0 | 2117472.0 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | |
| 142748 | 142748 | 37835 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 142732 | 142732 | 76271 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 142731 | 142731 | 102192 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 142697 | 142697 | 99369 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x3 | 5986847.81361 | 2112672.3215799998 | 37.7802353734381 | -122.489135113122 | (37.7802353734381, -122.489135113122) | ||
| 142663 | 142663 | 42642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 5 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 142592 | 142592 | 96085 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 142587 | 142587 | 102023 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 142357 | 142357 | 42987 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 8 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 142333 | 142333 | 99366 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5986848.25067 | 2112734.65735 | 37.7804065552175 | -122.48913818535101 | (37.7804065552175, -122.489138185351) | ||
| 141932 | 141932 | 107886 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 941 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) |
| 141821 | 141821 | 99680 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 165 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 141815 | 141815 | 98973 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 141772 | 141772 | 98748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 141689 | 141689 | 75040 | DPW Maintained 3 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 141465 | 141465 | 97247 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003399.0 | 2092092.0 | 37.7246788362927 | -122.43040815339701 | (37.7246788362927, -122.430408153397) |
| 141315 | 141315 | 98560 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 141095 | 141095 | 112061 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 140800 | 140800 | 47197 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2899X Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 3 | 3x3 | 5986581.22601267 | 2112881.07204474 | 37.7807929786872 | -122.490072708464 | (37.7807929786872, -122.490072708464) | |
| 140600 | 140600 | 113574 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6007968.0 | 2120121.0 | 37.8018977290678 | -122.41659827224701 | (37.8018977290678, -122.416598272247) | |||
| 140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 140357 | 140357 | 73285 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 13 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 140326 | 140326 | 102026 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
| 140274 | 140274 | 99024 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006571.0 | 2102346.4 | 37.753014305467794 | -122.420170352411 | (37.7530143054678, -122.420170352411) | ||
| 140146 | 140146 | 42356 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 140135 | 140135 | 112060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 140063 | 140063 | 74108 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 139987 | 139987 | 77634 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
| 139761 | 139761 | 97062 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 139596 | 139596 | 73288 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 139544 | 139544 | 47198 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 8 | 4x4 | Permit Number 45157 | 5986584.00139 | 2112756.95832 | 37.780452359911706 | -122.490053975567 | (37.7804523599117, -122.490053975567) |
| 139482 | 139482 | 97079 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 139365 | 139365 | 98751 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 139322 | 139322 | 37829 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 139260 | 139260 | 99329 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 5986584.84396 | 2112715.96758 | 37.7803398602424 | -122.49004804489701 | (37.7803398602424, -122.490048044897) | ||
| 139199 | 139199 | 77209 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 138890 | 138890 | 98565 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301X Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 138862 | 138862 | 47202 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45157 | 5986698.68199 | 2113217.08014 | 37.7817224192006 | -122.489691093913 | (37.7817224192006, -122.489691093913) |
| 138703 | 138703 | 95262 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 138574 | 138574 | 98575 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 138394 | 138394 | 99673 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 4x4 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 138385 | 138385 | 76170 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/16/1996 12:00:00 AM | 5 | 3x3 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | |
| 138350 | 138350 | 98747 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 138342 | 138342 | 99556 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Henry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | ||
| 138303 | 138303 | 99357 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986839.06552 | 2112970.96623 | 37.7810548559101 | -122.489187339385 | (37.7810548559101, -122.489187339385) | ||
| 136374 | 136374 | 116064 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 693 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 8x7 | 6011272.30638 | 2105412.17877 | 37.761696029365794 | -122.404127986133 | (37.7616960293658, -122.404127986133) | ||
| 136322 | 136322 | 98804 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950x Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010297.358630001 | 2117215.00262 | 37.794049298296706 | -122.408332474088 | (37.7940492982967, -122.408332474088) |
| 132178 | 132178 | 116054 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011511.93551 | 2105220.59815 | 37.761183378041395 | -122.403285723377 | (37.7611833780414, -122.403285723377) | ||
| 130071 | 130071 | 116057 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011480.97635 | 2105135.37266 | 37.760947638753 | -122.40338680266001 | (37.760947638753, -122.40338680266) | ||
| 129870 | 129870 | 116056 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x Kansas St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011515.191980001 | 2105171.68257 | 37.7610492486475 | -122.40327101944901 | (37.7610492486475, -122.403271019449) | ||
| 129440 | 129440 | 99676 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 129289 | 129289 | 30741 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 129243 | 129243 | 47256 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 129053 | 129053 | 99029 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) |
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");