Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2231 | 2231 | 122750 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 6011285.1392 | 2105241.4016400003 | 37.761227830607204 | -122.40407158333299 | (37.7612278306072, -122.404071583333) | |||
2667 | 2667 | 37820 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003945.80086 | 2090498.97809 | 37.7203357084188 | -122.428404441018 | (37.7203357084188, -122.428404441018) |
4752 | 4752 | 95757 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/25/2017 04:33:00 PM | 3 | 3x3 | Permit Number 767495 | 6003435.4103 | 2092233.1677400002 | 37.725068513899295 | -122.430292354528 | (37.7250685138993, -122.430292354528) |
5294 | 5294 | 97730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | |
5300 | 5300 | 42638 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:49:00 PM | 3 | 5x5 | Permit Number 42688 | 6005231.45083 | 2118842.40752 | 37.7982327574016 | -122.425976953174 | (37.7982327574016, -122.425976953174) |
6975 | 6975 | 98619 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005336.89801 | 2118653.3555400004 | 37.7977196276222 | -122.425598612003 | (37.7977196276222, -122.425598612003) | ||
8022 | 8022 | 98629 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002271.7566599995 | 2120123.5232700002 | 37.8015826528763 | -122.43631009602801 | (37.8015826528763, -122.436310096028) | ||
10418 | 10418 | 77647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | |
10658 | 10658 | 75132 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6002992.1034699995 | 2092540.72564 | 37.725887878997504 | -122.431846767938 | (37.7258878789975, -122.431846767938) | |
12864 | 12864 | 77657 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006712.15653 | 2093290.62233 | 37.7281571140509 | -122.41903993995001 | (37.7281571140509, -122.41903993995) | |
14428 | 14428 | 51357 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.6145900001 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) |
20531 | 20531 | 30747 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 496X Page St | 8 | 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 | 6004231.9845 | 2109799.7949 | 37.77334747404829 | -122.42879042330799 | (37.7733474740483, -122.428790423308) |
23240 | 23240 | 76785 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 24 | 3x12 | 5983097.8243 | 2104541.5546 | 37.757691027540005 | -122.501506182606 | (37.75769102754, -122.501506182606) | |
77312 | 77312 | 96772 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | ||
77433 | 77433 | 31711 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1250X Shrader St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35211 | 5997882.313818 | 2106467.94501531 | 37.763837639523395 | -122.450514467435 | (37.7638376395234, -122.450514467435) |
79218 | 79218 | 99026 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 41415 | 6006571.0 | 2102346.4 | 37.753014305467794 | -122.420170352411 | (37.7530143054678, -122.420170352411) | |
87708 | 87708 | 32729 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
89109 | 89109 | 46955 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 4 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
91293 | 91293 | 99354 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986839.805509999 | 2113026.66255 | 37.7812078253097 | -122.489188875507 | (37.7812078253097, -122.489188875507) | ||
93584 | 93584 | 97074 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1551 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/20/2015 05:52:00 PM | 3 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | |
95663 | 95663 | 76252 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 8 | 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) | |
98549 | 98549 | 99034 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 8 | 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) | ||
99342 | 99342 | 95260 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 8 | 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) | ||||
100102 | 100102 | 42349 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 8 | 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) |
100783 | 100783 | 73287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 8 | 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) | |
103689 | 103689 | 42990 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
106182 | 106182 | 96506 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 8 | 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) | ||
106303 | 106303 | 99670 | DPW Maintained 3 | Tree(s) :: 17 | 150X Alma St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
107003 | 107003 | 102193 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
109088 | 109088 | 98806 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950x CLAY ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | Permit Number 768771 | 6010160.0 | 2117472.0 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | ||
109574 | 109574 | 99554 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Henry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | ||
113689 | 113689 | 98609 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003008.4 | 2116877.5 | 37.7927117414369 | -122.433528869724 | (37.7927117414369, -122.433528869724) | ||
116963 | 116963 | 98570 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |
117184 | 117184 | 98682 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
117343 | 117343 | 98974 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 8 | 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) | ||
117863 | 117863 | 99686 | DPW Maintained 3 | Tree(s) :: 17 | 165 Grattan St | 8 | 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) | ||
119293 | 119293 | 99330 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 4x4 | 5986582.509190001 | 2112777.47658 | 37.780508610058 | -122.490060647344 | (37.780508610058, -122.490060647344) | ||
120054 | 120054 | 95152 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5988720.65561 | 2113620.6282200003 | 37.7829482935383 | -122.482725682965 | (37.7829482935383, -122.482725682965) | |||
120132 | 120132 | 93105 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 151X Palm Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53160 | 5995888.42271 | 2113224.45495 | 37.7822749237882 | -122.45789965405301 | (37.7822749237882, -122.457899654053) |
122189 | 122189 | 95269 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2245 Jones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | |||
122693 | 122693 | 96497 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2500X Harrison St | 8 | 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) | |||
126295 | 126295 | 102028 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 8 | 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) | ||
126306 | 126306 | 70470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
127791 | 127791 | 76027 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/16/1996 12:00:00 AM | 6 | 4x4 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | |
128247 | 128247 | 116052 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x KANSAS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6011530.0 | 2105347.0 | 37.761531458187 | -122.403232137637 | (37.761531458187, -122.403232137637) | |||
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) | ||||
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) | |
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) |
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");