Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7636 | 7636 | 99241 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 4x4 | 6008235.1228 | 2113825.75072 | 37.7846275436788 | -122.415228013286 | (37.7846275436788, -122.415228013286) | |||
7647 | 7647 | 99242 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 8 | 4x4 | 6008195.716580001 | 2113819.71845 | 37.7846087658129 | -122.415363918808 | (37.7846087658129, -122.415363918808) | |||
43693 | 43693 | 111802 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 25 | 3x3 | 6010732.9183 | 2110973.0919 | 37.7769348714848 | -122.406385364505 | (37.7769348714848, -122.406385364505) | |||
55860 | 55860 | 111803 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 26 | 3x3 | 6010715.3243 | 2110993.12608 | 37.7769888964448 | -122.40644763986099 | (37.7769888964448, -122.406447639861) | |||
165859 | 165859 | 111800 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010798.82321 | 2110910.53582 | 37.77676679357771 | -122.40615296978599 | (37.7767667935777, -122.406152969786) | |||
182904 | 182904 | 111801 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55X Sherman St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010771.68914 | 2110936.4486 | 37.7768364262956 | -122.40624866125401 | (37.7768364262956, -122.406248661254) |
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");