Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3743 | 3743 | 175363 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 5993226.79298 | 2087801.79474 | 37.71231750501779 | -122.465260429219 | (37.7123175050178, -122.465260429219) | |||
25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
25720 | 25720 | 196053 | Undocumented 2 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 2399 Lane St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6013983.40604 | 2092884.07422 | 37.727447595718395 | -122.393874328035 | (37.7274475957184, -122.393874328035) | ||||
34805 | 34805 | 236092 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000056.44576 | 2105686.72803 | 37.761816809218296 | -122.44293872364099 | (37.7618168092183, -122.442938723641) | |||
35370 | 35370 | 248189 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 216 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | ||||
35448 | 35448 | 176098 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998949.65718 | 2089392.42013 | 37.717013369950706 | -122.44559487852699 | (37.7170133699507, -122.445594878527) | ||||
52509 | 52509 | 177834 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6005075.62014 | 2092583.76802 | 37.7261239546294 | -122.424647248878 | (37.7261239546294, -122.424647248878) | ||||
53743 | 53743 | 118598 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5982022.838269999 | 2112594.06181 | 37.7797376871414 | -122.50582083083799 | (37.7797376871414, -122.505820830838) | ||||
54920 | 54920 | 248118 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010376.970919999 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | ||||
56715 | 56715 | 207986 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999466.52885 | 2095410.65053 | 37.733567534417794 | -122.444240535497 | (37.7335675344178, -122.444240535497) | ||||
60593 | 60593 | 134509 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | Width 4ft | 6008051.61488 | 2112117.95752 | 37.7799280400987 | -122.415741925456 | (37.7799280400987, -122.415741925456) | |||
62115 | 62115 | 247923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.40705826963699 | (37.7432925026595, -122.407058269637) | ||||
63075 | 63075 | 179496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 653 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005058.40423 | 2092646.41058 | 37.726294985004294 | -122.424711217658 | (37.7262949850043, -122.424711217658) | ||||
65505 | 65505 | 248066 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 18 Rutledge St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010646.65948 | 2099397.14706 | 37.7451451051559 | -122.405868130216 | (37.7451451051559, -122.405868130216) | ||||
67816 | 67816 | 250228 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 0ft | 6011211.1715400005 | 2120049.4002099996 | 37.8018829958704 | -122.40537027363101 | (37.8018829958704, -122.405370273631) | |||
73129 | 73129 | 125336 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6008636.03175 | 2118982.55728 | 37.7988093963818 | -122.41420596974702 | (37.7988093963818, -122.414205969747) | ||||
74012 | 74012 | 247935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6010295.56922 | 2098768.42696 | 37.743399135252204 | -122.407037837932 | (37.7433991352522, -122.407037837932) | ||||
115840 | 115840 | 176282 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 35 Tomaso Ct | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6009202.48899 | 2086331.0577900002 | 37.709187518951296 | -122.40993964441401 | (37.7091875189513, -122.409939644414) | |||
130643 | 130643 | 247527 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000059.53834 | 2108484.86365 | 37.769499968379705 | -122.443128995021 | (37.7694999683797, -122.443128995021) | ||||
148916 | 148916 | 188810 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 1499 Rankin St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 5ft | 6012693.20045 | 2096700.71926 | 37.737855526197706 | -122.39860231674801 | (37.7378555261977, -122.398602316748) | |||
151746 | 151746 | 231168 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 198 Corbin Pl | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 3ft | 6000085.93778 | 2105710.50665 | 37.7618837808207 | -122.442838430352 | (37.7618837808207, -122.442838430352) | |||
153778 | 153778 | 248179 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 218 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6007450.1378 | 2098674.92433 | 37.7429827563392 | -122.416870017934 | (37.7429827563392, -122.416870017934) | ||||
166163 | 166163 | 195224 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Phelps St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 7ft | 6014570.35716 | 2097088.14635 | 37.7390237239721 | -122.392139105952 | (37.7390237239721, -122.392139105952) | |||
166855 | 166855 | 129091 | Undocumented 2 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 200 Spruce St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 5997131.25122 | 2115563.65608 | 37.78876907367739 | -122.45376901623399 | (37.7887690736774, -122.453769016234) | |||
167249 | 167249 | 190082 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1700 Armstrong Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6013888.29247 | 2092890.0974700002 | 37.7274588480349 | -122.39420355996401 | (37.7274588480349, -122.394203559964) | ||||
172826 | 172826 | 246658 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009066.3858 | 2099225.83435 | 37.7445862133943 | -122.411320363668 | (37.7445862133943, -122.411320363668) | ||||
173238 | 173238 | 197182 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1750 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6012809.5472800005 | 2103799.82503 | 37.757354633129204 | -122.39869809995501 | (37.7573546331292, -122.398698099955) | ||||
173443 | 173443 | 132298 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2836 Larkin St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6006506.15813 | 2120992.00348 | 37.8042069600397 | -122.42171884046199 | (37.8042069600397, -122.421718840462) | ||||
173508 | 173508 | 247008 | Undocumented 2 | Callistemon 'Jeffers' :: Purple bottlebrush 395 | 401 Valley St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 8ft | 6003270.60035 | 2099185.34055 | 37.74414826155 | -122.43135813298599 | (37.74414826155, -122.431358132986) | |||
173872 | 173872 | 211287 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1549 15th Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5991543.24459 | 2104910.37541 | 37.759196107445796 | -122.472325621056 | (37.7591961074458, -122.472325621056) | ||||
177483 | 177483 | 196062 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 5ft | 6012859.76673 | 2103766.08005 | 37.757264774654395 | -122.398522052264 | (37.7572647746544, -122.398522052264) | |||
180380 | 180380 | 203655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 230 Edna St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | ||||
182532 | 182532 | 247879 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 388 Mayflower St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009924.148030001 | 2098382.32436 | 37.7423181897436 | -122.408294896795 | (37.7423181897436, -122.408294896795) |
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");