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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
168 | 168 | 179480 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5989599.0 | 2090767.0 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | ||||
2567 | 2567 | 252819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 407 Miguel St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780051 | 6004479.0 | 2096413.0 | 37.736604456337105 | -122.426982337456 | (37.7366044563371, -122.426982337456) | ||
3028 | 3028 | 191362 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 999 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6013336.3333 | 2089743.8780099999 | 37.718789267498295 | -122.39589132571999 | (37.7187892674983, -122.39589132572) | ||||
3029 | 3029 | 193472 | Undocumented 2 | Prunus persica nectarina :: Flowering Nectarine Tree 196 | 1059 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013665.43892 | 2089838.8488900003 | 37.719068342415596 | -122.39476037791599 | (37.7190683424156, -122.394760377916) | ||||
3033 | 3033 | 253285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 5981372.0 | 2112274.0 | 37.7788205636315 | -122.50804856364901 | (37.7788205636315, -122.508048563649) | |||
3040 | 3040 | 189089 | Undocumented 2 | Acer negundo :: Box Elder 74 | 1033 Le Conte Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6012956.43123 | 2089677.63232 | 37.718586227543504 | -122.397199861797 | (37.7185862275435, -122.397199861797) | ||||
4004 | 4004 | 251722 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 18 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:08:00 PM | 3 | 5996685.56427 | 2088703.70423 | 37.7149927956564 | -122.45337101855101 | (37.7149927956564, -122.453371018551) | |||
4008 | 4008 | 216051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 48 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:54:00 PM | 3 | 5996419.4156599995 | 2088710.03455 | 37.7149949180514 | -122.454291392827 | (37.7149949180514, -122.454291392827) | |||
4014 | 4014 | 216033 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:13:00 PM | 3 | 5996833.19651 | 2088697.5304900003 | 37.7149843051513 | -122.452860296276 | (37.7149843051513, -122.452860296276) | |||
4026 | 4026 | 216034 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 8 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:11:00 PM | 3 | 5996778.28459 | 2088695.06883 | 37.714974399131705 | -122.45304991653099 | (37.7149743991317, -122.453049916531) | |||
4030 | 4030 | 216055 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 52 Lobos St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:49:00 PM | 3 | 5996381.618969999 | 2088696.9088599999 | 37.714956710372 | -122.454421085891 | (37.714956710372, -122.454421085891) | |||
4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
4092 | 4092 | 216045 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 36 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:04:00 PM | 3 | 5996513.0629 | 2088696.2251900001 | 37.7149623706927 | -122.45396671331999 | (37.7149623706927, -122.45396671332) | |||
4097 | 4097 | 216058 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 58 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:35:00 PM | 3 | 5996320.31527 | 2088710.5585599998 | 37.7149906732676 | -122.45463396169599 | (37.7149906732676, -122.454633961696) | |||
4103 | 4103 | 216046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 38 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:02:00 PM | 3 | 5996487.74032 | 2088710.41168 | 37.7149998715299 | -122.454055262356 | (37.7149998715299, -122.454055262356) | |||
4117 | 4117 | 216048 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 02:58:00 PM | 3 | 5996463.1782599995 | 2088711.43982 | 37.7150012861457 | -122.45414023299999 | (37.7150012861457, -122.454140233) | |||
9572 | 9572 | 100227 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 542 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Permit Number 769993 | 6002426.0 | 2099190.0 | 37.7441131524814 | -122.434278904907 | (37.7441131524814, -122.434278904907) | |||
9934 | 9934 | 102961 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9935 | 9935 | 102960 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9936 | 9936 | 102965 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9937 | 9937 | 102966 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9939 | 9939 | 102963 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9940 | 9940 | 102969 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9941 | 9941 | 102968 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9943 | 9943 | 102967 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9945 | 9945 | 102971 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
10103 | 10103 | 173844 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2X Crestline Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5999319.0 | 2101169.0 | 37.7493701671822 | -122.445164434644 | (37.7493701671822, -122.445164434644) | |||||
10370 | 10370 | 107580 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.709603859212706 | -122.468025367885 | (37.7096038592127, -122.468025367885) | ||
10524 | 10524 | 107581 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.946819999 | 2086830.9956900002 | 37.7096038591978 | -122.46806839775299 | (37.7096038591978, -122.468068397753) | ||
11417 | 11417 | 117425 | Permitted Site 1 | Magnolia champaca :: Champa 170 | 218 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775470 | 6004576.76699 | 2091985.7103900001 | 37.724453633907 | -122.426329194258 | (37.724453633907, -122.426329194258) | ||
11907 | 11907 | 107582 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.4734200002 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | ||
12169 | 12169 | 107579 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | ||
12904 | 12904 | 117426 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 395 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.920059999 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | ||
16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
18835 | 18835 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
19238 | 19238 | 104509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 DICHIERA CT | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5998620.0 | 2088043.0 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | |||||
19268 | 19268 | 104883 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990322.1 | 2090011.1 | 37.718215776001294 | -122.475461023549 | (37.7182157760013, -122.475461023549) | |||||
20076 | 20076 | 98360 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | ||||
22821 | 22821 | 197331 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6014124.123369999 | 2101967.77095 | 37.752397360459 | -122.39402349321199 | (37.752397360459, -122.394023493212) | ||||
22882 | 22882 | 176369 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990491.08034 | 2089186.3269 | 37.7159609464097 | -122.47481676917101 | (37.7159609464097, -122.474816769171) | ||||
23514 | 23514 | 190971 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.40405043579099 | (37.7586620081736, -122.404050435791) | ||||
23735 | 23735 | 213223 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5996685.56427 | 2088703.70423 | 37.7149927956564 | -122.45337101855101 | (37.7149927956564, -122.453371018551) | ||||
23763 | 23763 | 194461 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2000 25th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012563.257130001 | 2101880.94422 | 37.7520720792617 | -122.399415164477 | (37.7520720792617, -122.399415164477) | ||||
23936 | 23936 | 211142 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5993344.399119999 | 2096880.05499 | 37.7372509740365 | -122.465513038912 | (37.7372509740365, -122.465513038912) | ||||
24035 | 24035 | 178607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.47543773036101 | (37.7180635775375, -122.475437730361) | ||||
24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
24106 | 24106 | 246790 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 175 Brewster St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010136.6415 | 2098750.10917 | 37.74333994367979 | -122.40758608083901 | (37.7433399436798, -122.407586080839) | ||||
24170 | 24170 | 206058 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 95 Marston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5998836.80822 | 2093173.9716299998 | 37.727390192897 | -122.44625681279899 | (37.727390192897, -122.446256812799) | ||||
24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
24210 | 24210 | 243997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 483 Valley St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6002856.13849 | 2099166.37305 | 37.7440726834043 | -122.432789895044 | (37.7440726834043, -122.432789895044) | ||||
24565 | 24565 | 176109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6005252.95246 | 2086362.20208 | 37.7090508894465 | -122.42359208063299 | (37.7090508894465, -122.423592080633) | ||||
24621 | 24621 | 205635 | Undocumented 2 | Betula spp :: Birch 95 | 20 Belmont Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5996782.71205 | 2106151.6508299997 | 37.762906178688105 | -122.454294786868 | (37.7629061786881, -122.454294786868) | ||||
24748 | 24748 | 210946 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5996128.662169999 | 2088702.9665 | 37.714958832754 | -122.455295843853 | (37.714958832754, -122.455295843853) | ||||
24760 | 24760 | 188680 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6018245.47476 | 2096448.1212400002 | 37.7374697107694 | -122.37938765012501 | (37.7374697107694, -122.379387650125) | ||||
24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
24880 | 24880 | 178117 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988789.573419999 | 2089765.1297400002 | 37.717451446800204 | -122.480740256365 | (37.7174514468002, -122.480740256365) | ||||
24979 | 24979 | 177920 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Juan Bautista Cir | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989764.376630001 | 2089755.55448 | 37.7174817656499 | -122.477370148614 | (37.7174817656499, -122.477370148614) | ||||
25162 | 25162 | 120283 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 139 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988317.15466 | 2115062.63745 | 37.786884157218 | -122.484227400222 | (37.786884157218, -122.484227400222) | ||||
25205 | 25205 | 195981 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6018524.13374 | 2099557.3325900002 | 37.746022348857295 | -122.37864001312799 | (37.7460223488573, -122.378640013128) | ||||
25277 | 25277 | 210945 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5996140.80305 | 2088701.9398299998 | 37.7149567103495 | -122.455253805936 | (37.7149567103495, -122.455253805936) | ||||
25292 | 25292 | 177947 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | ||||
25340 | 25340 | 199360 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1451 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012046.6036 | 2101626.2388 | 37.7513439035983 | -122.401183943899 | (37.7513439035983, -122.401183943899) | ||||
25485 | 25485 | 198641 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015975.52657 | 2108754.29642 | 37.7711344286414 | -122.388094538146 | (37.7711344286414, -122.388094538146) | ||||
25637 | 25637 | 190976 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6011280.21235 | 2104227.17617 | 37.758442718371704 | -122.404017246303 | (37.7584427183717, -122.404017246303) | ||||
25716 | 25716 | 135893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6001843.597519999 | 2121830.48703 | 37.806245186226505 | -122.437914052191 | (37.8062451862265, -122.437914052191) | ||||
25725 | 25725 | 178308 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5990210.12045 | 2089417.27348 | 37.716578783365605 | -122.47580474370501 | (37.7165787833656, -122.475804743705) | ||||
25734 | 25734 | 237874 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 160 Coso Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6007471.906690001 | 2099585.1841700003 | 37.74548335098721 | -122.41685922338301 | (37.7454833509872, -122.416859223383) | ||||
25771 | 25771 | 198601 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016359.83761 | 2108655.37305 | 37.770884091558706 | -122.386758280474 | (37.7708840915587, -122.386758280474) | ||||
25878 | 25878 | 207430 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991564.83032 | 2104929.84825 | 37.759250823982605 | -122.47225238743601 | (37.7592508239826, -122.472252387436) | ||||
26083 | 26083 | 123491 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5995674.45752 | 2111730.9534 | 37.77816187055421 | -122.458531727532 | (37.7781618705542, -122.458531727532) | ||||
26454 | 26454 | 188657 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6016750.167669999 | 2099204.87087 | 37.744956608177205 | -122.38474966268801 | (37.7449566081772, -122.384749662688) | ||||
26455 | 26455 | 250503 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 27 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5987219.4973 | 2115634.05688 | 37.7883891388944 | -122.488066995303 | (37.7883891388944, -122.488066995303) | ||||
26514 | 26514 | 193470 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 981 Le Conte Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013233.09279 | 2089478.4366400002 | 37.7180546742753 | -122.396229595828 | (37.7180546742753, -122.396229595828) | ||||
26554 | 26554 | 178310 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5989465.34816 | 2090743.3229599998 | 37.7201765760646 | -122.478475931633 | (37.7201765760646, -122.478475931633) | ||||
26589 | 26589 | 196520 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1100 Pennsylvania Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6014495.9358 | 2101776.59314 | 37.751893084516894 | -122.392724321763 | (37.7518930845169, -122.392724321763) | ||||
26599 | 26599 | 176373 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Higuera Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5987816.39494 | 2090204.8052400001 | 37.7186020727071 | -122.484136269073 | (37.7186020727071, -122.484136269073) | ||||
26910 | 26910 | 195984 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018485.16554 | 2099556.70792 | 37.7460184853642 | -122.378774718093 | (37.7460184853642, -122.378774718093) | ||||
27096 | 27096 | 240267 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 517 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6008465.29724 | 2098131.45059 | 37.7415475462934 | -122.413321437934 | (37.7415475462934, -122.413321437934) | ||||
27126 | 27126 | 177939 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | ||||
27306 | 27306 | 178328 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 5990317.34225 | 2090043.8786900002 | 37.718305502374704 | -122.47547986090599 | (37.7183055023747, -122.475479860906) | ||||
27342 | 27342 | 197873 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1798 Revere Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6014074.97715 | 2095177.8626700002 | 37.7337509610296 | -122.39371824532101 | (37.7337509610296, -122.393718245321) | ||||
27377 | 27377 | 211177 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Lobos St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5996889.59605 | 2088696.8686799998 | 37.714985719781 | -122.45266530885799 | (37.714985719781, -122.452665308858) | ||||
27493 | 27493 | 136046 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 20 Cherry St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5996087.67176 | 2116001.0032200003 | 37.789910026470004 | -122.45741128312001 | (37.78991002647, -122.45741128312) | ||||
27677 | 27677 | 118507 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5981701.912719999 | 2112329.1151099997 | 37.7789913275143 | -122.506911374832 | (37.7789913275143, -122.506911374832) | ||||
27686 | 27686 | 118503 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5981708.0026 | 2112322.43934 | 37.7789733564528 | -122.506889812546 | (37.7789733564528, -122.506889812546) | ||||
28068 | 28068 | 126421 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 6008400.762999999 | 2118955.03362 | 37.7987206054154 | -122.415018129477 | (37.7987206054154, -122.415018129477) | ||||
28275 | 28275 | 198639 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015936.8101699995 | 2108752.54325 | 37.7711274696967 | -122.38822833839 | (37.7711274696967, -122.38822833839) | ||||
28294 | 28294 | 188658 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | ||||
28431 | 28431 | 246705 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 Bonview St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6007711.520280001 | 2099134.96568 | 37.7442606264379 | -122.41599879791201 | (37.7442606264379, -122.415998797912) | ||||
28635 | 28635 | 213024 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Belmont Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5996733.15757 | 2106189.67252 | 37.7630077346534 | -122.454468924419 | (37.7630077346534, -122.454468924419) | ||||
28834 | 28834 | 188557 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013310.23031 | 2102900.17201 | 37.7549122641975 | -122.39690345423 | (37.7549122641975, -122.39690345423) | ||||
28874 | 28874 | 218292 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5991223.38049 | 2095418.74528 | 37.73311602796429 | -122.472739784911 | (37.7331160279643, -122.472739784911) | ||||
29157 | 29157 | 175654 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989491.89044 | 2089216.44658 | 37.7159856948481 | -122.478272601196 | (37.7159856948481, -122.478272601196) | ||||
29194 | 29194 | 188256 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013789.26124 | 2089763.6189299999 | 37.7188686596462 | -122.39432710432301 | (37.7188686596462, -122.394327104323) | ||||
29206 | 29206 | 195983 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6018491.3513 | 2099573.26629 | 37.7460642923356 | -122.378754477939 | (37.7460642923356, -122.378754477939) | ||||
29240 | 29240 | 177953 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989426.93386 | 2089569.48868 | 37.7169512897353 | -122.47852292122101 | (37.7169512897353, -122.478522921221) | ||||
29386 | 29386 | 177222 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989183.517969999 | 2089355.54971 | 37.7163497314364 | -122.479348640047 | (37.7163497314364, -122.479348640047) | ||||
29568 | 29568 | 247533 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6000119.08328 | 2108491.6907099998 | 37.769522108775 | -122.44292352241501 | (37.769522108775, -122.442923522415) | ||||
29723 | 29723 | 177927 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5988959.91996 | 2089504.3338 | 37.716745265857 | -122.48013237763 | (37.716745265857, -122.48013237763) | ||||
29891 | 29891 | 250356 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 25 Scenic Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987583.59597 | 2115669.67297 | 37.7885081641679 | -122.48680990495701 | (37.7885081641679, -122.486809904957) |
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");