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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24297 | 24297 | 248119 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.40680643699301 | (37.7451368817742, -122.406806436993) | ||||
25897 | 25897 | 134510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6008017.687530001 | 2112101.62184 | 37.7798812789472 | -122.415858138542 | (37.7798812789472, -122.415858138542) | |||
27927 | 27927 | 247528 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Waller St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | ||||
30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
38547 | 38547 | 196063 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 6012868.1198 | 2103766.18767 | 37.757265535503 | -122.39849317144501 | (37.757265535503, -122.398493171445) | |||
46836 | 46836 | 136715 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 7ft | 6003190.857480001 | 2120979.91426 | 37.803986257417 | -122.43319081820499 | (37.803986257417, -122.433190818205) | |||
49010 | 49010 | 227460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | |||
55107 | 55107 | 208887 | Undocumented 2 | Malus :: Crab Apple 235 | 747 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999422.56432 | 2095411.3960400003 | 37.733567073059895 | -122.44439258657302 | (37.7335670730599, -122.444392586573) | ||||
64330 | 64330 | 236093 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 3ft | 6000063.11815 | 2105682.66467 | 37.7618060326498 | -122.44291535476201 | (37.7618060326498, -122.442915354762) | |||
70150 | 70150 | 248180 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007468.18996 | 2098662.76578 | 37.7429503870626 | -122.416806737143 | (37.7429503870626, -122.416806737143) | ||||
70995 | 70995 | 246659 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009067.50483 | 2099233.3158299997 | 37.74460681865239 | -122.411317022686 | (37.7446068186524, -122.411317022686) | ||||
77276 | 77276 | 176283 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 35 Tomaso Ct | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 6009206.42472 | 2086339.2337599997 | 37.7092101890802 | -122.40992661863999 | (37.7092101890802, -122.40992661864) | |||
131189 | 131189 | 179497 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 653 Peru Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6005046.66321 | 2092646.92983 | 37.7262957476241 | -122.424751842734 | (37.7262957476241, -122.424751842734) | ||||
133323 | 133323 | 132438 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008636.9513 | 2118981.46679 | 37.798806453817896 | -122.414202710601 | (37.7988064538179, -122.414202710601) | ||||
147259 | 147259 | 132299 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2836 Larkin St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006506.76363 | 2120995.98891 | 37.8042179371566 | -122.421717028328 | (37.8042179371566, -122.421717028328) | ||||
154255 | 154255 | 247009 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Valley St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 8ft | 6003278.48209 | 2099193.13161 | 37.744170100676996 | -122.431331435716 | (37.744170100677, -122.431331435716) | |||
166394 | 166394 | 250229 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011206.629819999 | 2120043.6184099996 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | |||
174997 | 174997 | 176989 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998947.7718 | 2089388.6360799999 | 37.717002872174504 | -122.445601123393 | (37.7170028721745, -122.445601123393) | ||||
179689 | 179689 | 176336 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6012249.60162 | 2087766.47281 | 37.713299190589794 | -122.39950899437001 | (37.7132991905898, -122.39950899437) | ||||
186195 | 186195 | 196068 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013885.20395 | 2092887.6121599998 | 37.727451852204204 | -122.39421406314399 | (37.7274518522042, -122.394214063144) | ||||
186431 | 186431 | 211852 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 714 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 5999466.29609 | 2095415.22212 | 37.7335800736498 | -122.44424166861602 | (37.7335800736498, -122.444241668616) | ||||
188928 | 188928 | 248190 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 216 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6007395.06383 | 2098734.36623 | 37.7431428725527 | -122.41706466002701 | (37.7431428725527, -122.417064660027) |
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");