Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86843 | 86843 | 109377 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 96460 | 96460 | 109375 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 112237 | 112237 | 109378 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 118325 | 118325 | 109374 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 127758 | 127758 | 109376 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 70496 | 70496 | 249782 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 115 Pfeiffer St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6010481.39254 | 2121146.06325 | 37.804853332490296 | -122.40797304381701 | (37.8048533324903, -122.407973043817) | |||
| 129840 | 129840 | 249783 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 115 Pfeiffer St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6010478.38783 | 2121144.55662 | 37.804849027432105 | -122.407983335672 | (37.8048490274321, -122.407983335672) | |||
| 76949 | 76949 | 249781 | Undocumented 2 | Schinus molle :: California Pepper 138 | 119 Pfeiffer St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010443.51385 | 2121141.6092 | 37.804838981984794 | -122.408103813361 | (37.8048389819848, -122.408103813361) | |||
| 57451 | 57451 | 249779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6010421.07006 | 2121139.1053400002 | 37.804830850333204 | -122.408181306135 | (37.8048308503332, -122.408181306135) | |||
| 36138 | 36138 | 249778 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6010409.80858 | 2121137.7854400002 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | |||
| 179054 | 179054 | 249777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010400.427069999 | 2121136.58311 | 37.8048227690275 | -122.40825256571001 | (37.8048227690275, -122.40825256571) | |||
| 46915 | 46915 | 249805 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6010790.25874 | 2121038.89871 | 37.8045763727666 | -122.40689661648099 | (37.8045763727666, -122.406896616481) | |||
| 180980 | 180980 | 249806 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6010784.31321 | 2121039.01987 | 37.804576372755605 | -122.406917200191 | (37.8045763727556, -122.406917200191) | |||
| 24893 | 24893 | 249803 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010797.8681 | 2121034.56269 | 37.8045648929076 | -122.406869977661 | (37.8045648929076, -122.406869977661) | |||
| 41112 | 41112 | 249802 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010800.51699 | 2121027.19165 | 37.804544802067795 | -122.40686029106399 | (37.8045448020678, -122.406860291064) | |||
| 59239 | 59239 | 249804 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010798.41124 | 2121026.88639 | 37.8045438460731 | -122.406867556714 | (37.8045438460731, -122.406867556714) | |||
| 169417 | 169417 | 249809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010708.4562800005 | 2121025.2354099997 | 37.804534279087704 | -122.407178739215 | (37.8045342790877, -122.407178739215) | |||
| 53839 | 53839 | 249807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | |||
| 52205 | 52205 | 249810 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.804517058874396 | -122.407221117962 | (37.8045170588744, -122.407221117962) | |||
| 156801 | 156801 | 249808 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6010714.23144 | 2121016.75548 | 37.80451131849129 | -122.40715815553101 | (37.8045113184913, -122.407158155531) | |||
| 86911 | 86911 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 50135 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||||
| 125077 | 125077 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | |||||
| 188029 | 188029 | 249872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | |||
| 84714 | 84714 | 92484 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85249 | 85249 | 92475 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85668 | 85668 | 92476 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 88491 | 88491 | 92474 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 91344 | 91344 | 87564 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 104140 | 104140 | 92480 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 113154 | 113154 | 87562 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 128270 | 128270 | 92481 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 140175 | 140175 | 87563 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 145573 | 145573 | 92485 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 133552 | 133552 | 249874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 0ft | 6011664.0982800005 | 2120483.35155 | 37.803099833442296 | -122.403833479743 | (37.8030998334423, -122.403833479743) | |||
| 131807 | 131807 | 249873 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | |||
| 171246 | 171246 | 249875 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | Width 0ft | 6011656.00691 | 2120465.5569700003 | 37.803050521838706 | -122.40386022737499 | (37.8030505218387, -122.403860227375) | |||
| 47640 | 47640 | 249876 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 29 | Width 0ft | 6011590.626680001 | 2120460.04582 | 37.8030317367952 | -122.40408609031 | (37.8030317367952, -122.40408609031) | |||
| 27098 | 27098 | 249881 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 230 Greenwich St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.803029388647104 | -122.404350588107 | (37.8030293886471, -122.404350588107) | |||
| 54971 | 54971 | 249878 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 0ft | 6011550.21069 | 2120457.44752 | 37.803022344253705 | -122.40422576851299 | (37.8030223442537, -122.404225768513) | |||
| 171235 | 171235 | 249889 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Greenwich St | 25 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6011472.47528 | 2120454.19881 | 37.8030090801563 | -122.404494546207 | (37.8030090801563, -122.404494546207) | |||
| 133186 | 133186 | 249880 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011523.78476 | 2120446.01272 | 37.8029894704488 | -122.404316411196 | (37.8029894704488, -122.404316411196) | |||
| 33977 | 33977 | 249894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 30 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.802987222140395 | -122.40473187458599 | (37.8029872221404, -122.404731874586) | |||
| 61728 | 61728 | 249895 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 31 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | |||
| 51644 | 51644 | 249877 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 230 Greenwich St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 39 | Width 0ft | 6011569.83125 | 2120441.49442 | 37.802979637259 | -122.404156747344 | (37.802979637259, -122.404156747344) | |||
| 185525 | 185525 | 249893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 29 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 0ft | 6011394.800530001 | 2120441.53452 | 37.8029699659579 | -122.404762450627 | (37.8029699659579, -122.404762450627) | |||
| 76843 | 76843 | 249887 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 Greenwich St | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011491.952269999 | 2120439.55706 | 37.802969965942104 | -122.40442611408399 | (37.8029699659421, -122.404426114084) | |||
| 56133 | 56133 | 249888 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011477.22379 | 2120439.43792 | 37.80296881573079 | -122.404477074154 | (37.8029688157308, -122.404477074154) | |||
| 173534 | 173534 | 249884 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011503.3679 | 2120436.4879799997 | 37.8029621769312 | -122.404386393712 | (37.8029621769312, -122.404386393712) | |||
| 74522 | 74522 | 249896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 32 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | |||
| 171499 | 171499 | 249885 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011498.61175 | 2120434.8744 | 37.8029574806516 | -122.404402738904 | (37.8029574806516, -122.404402738904) | |||
| 133072 | 133072 | 249886 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011494.30214 | 2120434.10693 | 37.8029551325349 | -122.404417598416 | (37.8029551325349, -122.404417598416) | |||
| 74282 | 74282 | 249879 | Undocumented 2 | Salix spp :: Willow 218 | 230 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011548.40111 | 2120431.82846 | 37.8029518994613 | -122.404230226458 | (37.8029518994613, -122.404230226458) | |||
| 114761 | 114761 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1735x GRANT AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010373.0 | 2120454.0 | 37.8029470287696 | -122.40829930674299 | (37.8029470287696, -122.408299306743) | |||||
| 158045 | 158045 | 249890 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 26 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011458.55673 | 2120431.8571900004 | 37.8029469576839 | -122.40454113827101 | (37.8029469576839, -122.404541138271) | |||
| 34978 | 34978 | 249883 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011507.08304 | 2120427.1107900003 | 37.802936637067496 | -122.40437287690901 | (37.8029366370675, -122.404372876909) | |||
| 51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
| 67699 | 67699 | 249892 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 230 Greenwich St | 28 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Width 0ft | 6011427.28959 | 2120425.37078 | 37.80292740013321 | -122.404648882458 | (37.8029274001332, -122.404648882458) | |||
| 37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
| 164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
| 179841 | 179841 | 249924 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6011171.36702 | 2120411.09017 | 37.802873882370896 | -122.405533505089 | (37.8028738823709, -122.405533505089) | |||
| 46680 | 46680 | 249916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011201.85513 | 2120410.11068 | 37.8028728976405 | -122.40542793096901 | (37.8028728976405, -122.405427930969) | |||
| 132547 | 132547 | 249917 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011197.83082 | 2120409.77535 | 37.802871751897 | -122.405441833595 | (37.802871751897, -122.405441833595) | |||
| 176394 | 176394 | 249925 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011155.36985 | 2120409.86411 | 37.802869621408796 | -122.40558877741002 | (37.8028696214088, -122.40558877741) | |||
| 176393 | 176393 | 249926 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011142.49576 | 2120408.96257 | 37.8028664261111 | -122.405633265077 | (37.8028664261111, -122.405633265077) | |||
| 76467 | 76467 | 249921 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011183.71747 | 2120405.40754 | 37.8028589698347 | -122.40549036550101 | (37.8028589698347, -122.405490365501) | |||
| 156630 | 156630 | 249923 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 33 | Width 0ft | 6011163.06331 | 2120405.05222 | 37.8028568393309 | -122.40556181483801 | (37.8028568393309, -122.405561814838) | |||
| 170870 | 170870 | 249922 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011172.25119 | 2120397.10621 | 37.802835535282604 | -122.405529459923 | (37.8028355352826, -122.405529459923) | |||
| 74458 | 74458 | 249919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011190.2403 | 2120395.87946 | 37.8028331727783 | -122.405467121607 | (37.8028331727783, -122.405467121607) | |||
| 51446 | 51446 | 249918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011195.29362 | 2120394.33345 | 37.8028292103611 | -122.405449525493 | (37.8028292103611, -122.405449525493) | |||
| 24155 | 24155 | 249927 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011132.35015 | 2120388.99651 | 37.8028110368738 | -122.40566696715099 | (37.8028110368738, -122.405666967151) | |||
| 147898 | 147898 | 249995 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 41 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6011498.48414 | 2120303.0710299998 | 37.802595573674104 | -122.404393897677 | (37.8025955736741, -122.404393897677) | |||
| 25938 | 25938 | 249996 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 41 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011497.53106 | 2120284.14207 | 37.8025435461134 | -122.40439586268101 | (37.8025435461134, -122.404395862681) | |||
| 130010 | 130010 | 249997 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011507.582230001 | 2120247.7373900004 | 37.802444149427 | -122.40435851653 | (37.802444149427, -122.40435851653) | |||
| 160585 | 160585 | 249998 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011504.54206 | 2120237.90093 | 37.8024169710215 | -122.40436834431699 | (37.8024169710215, -122.404368344317) | |||
| 156890 | 156890 | 249999 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | |||
| 43839 | 43839 | 250000 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 39 Darrell Pl | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011508.04195 | 2120196.77393 | 37.802304241897204 | -122.404353336441 | (37.8023042418972, -122.404353336441) | |||
| 40928 | 40928 | 250002 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011523.15034 | 2120119.58855 | 37.8020931539352 | -122.40429561796499 | (37.8020931539352, -122.404295617965) | |||
| 29592 | 29592 | 249968 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 213 Filbert St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011722.66122 | 2120088.35569 | 37.8020185425825 | -122.403603012281 | (37.8020185425825, -122.403603012281) | |||
| 159363 | 159363 | 249970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011737.037830001 | 2120086.51138 | 37.802014281606205 | -122.403553132272 | (37.8020142816062, -122.403553132272) | |||
| 28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
| 60877 | 60877 | 250194 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 0ft | 6011773.11718 | 2119954.14642 | 37.8016528548612 | -122.403418962409 | (37.8016528548612, -122.403418962409) | |||
| 135843 | 135843 | 250193 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011782.399230001 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | |||
| 24822 | 24822 | 250192 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | |||
| 47761 | 47761 | 250191 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.40334230423099 | (37.8016295579248, -122.403342304231) | |||
| 139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | ||||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 138928 | 138928 | 108171 | Undocumented 2 | Tree(s) :: 17 | 59x MACONDRAY LN | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | Permit Number 774825 | 6008454.0 | 2119149.0 | 37.7992561803015 | -122.414847646907 | (37.7992561803015, -122.414847646907) | |||
| 84088 | 84088 | 103516 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 980 Green St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6008298.0 | 2118971.0 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | |||||
| 93109 | 93109 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 470x Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669828998 | (37.7982025127238, -122.40501669829) | ||||
| 153689 | 153689 | 135873 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1002 Vallejo St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6008628.64799 | 2118672.57502 | 37.7979578472257 | -122.414209576908 | (37.7979578472257, -122.414209576908) | ||||
| 50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
| 101483 | 101483 | 113482 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2839 Pierce St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001345.0 | 2118077.0 | 37.7959107386074 | -122.43937030854799 | (37.7959107386074, -122.439370308548) | ||||||
| 142682 | 142682 | 102752 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 2452 Green St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001313.0 | 2117994.0 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | ||||||
| 124625 | 124625 | 111763 | Landmark tree 9 | Cupressus macrocarpa :: Monterey Cypress 47 | 2626 Vallejo St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | |||||
| 168653 | 168653 | 132412 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 10ft | 6009828.26061 | 2117303.30498 | 37.7942654755313 | -122.40996184507601 | (37.7942654755313, -122.409961845076) | |||
| 43436 | 43436 | 132413 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 10ft | 6009827.38182 | 2117300.98565 | 37.7942590579634 | -122.409964721995 | (37.7942590579634, -122.409964721995) | |||
| 164588 | 164588 | 132414 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 10ft | 6009830.1634599995 | 2117290.7141400003 | 37.794231010794704 | -122.409954371722 | (37.7942310107947, -122.409954371722) | |||
| 161916 | 161916 | 132415 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 10ft | 6009831.3064 | 2117286.6196 | 37.7942198322406 | -122.409950127822 | (37.7942198322406, -122.409950127822) | |||
| 45069 | 45069 | 126561 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 8 Codman Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6009832.93804 | 2117260.0663900003 | 37.7941470150322 | -122.40994260678998 | (37.7941470150322, -122.40994260679) |
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");