Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47982 | 47982 | 212845 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 459 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993232.298140001 | 2090226.8914 | 37.7189765558014 | -122.465417457153 | (37.7189765558014, -122.465417457153) | |||
| 63346 | 63346 | 234845 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 452 Oak St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004779.43654 | 2110228.96496 | 37.7745568400539 | -122.426927281183 | (37.7745568400539, -122.426927281183) | |||
| 71229 | 71229 | 234851 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6009775.07981 | 2105635.7822 | 37.7622262228849 | -122.409322091662 | (37.7622262228849, -122.409322091662) | |||
| 73108 | 73108 | 234850 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2700 18th St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 2ft | 6009776.57488 | 2105514.32334 | 37.7618928082166 | -122.40930834911998 | (37.7618928082166, -122.40930834912) | |||
| 136606 | 136606 | 212846 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 375 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993227.98035 | 2089685.02025 | 37.7174884593132 | -122.465393040574 | (37.7174884593132, -122.465393040574) | |||
| 157808 | 157808 | 234844 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 471 Oak St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004727.493290001 | 2110160.10241 | 37.7743648231001 | -122.427102057227 | (37.7743648231001, -122.427102057227) | |||
| 181414 | 181414 | 234853 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 9 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6009779.5176 | 2105520.26331 | 37.7619092828952 | -122.40929859056101 | (37.7619092828952, -122.409298590561) | |||
| 188863 | 188863 | 234852 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009778.46002 | 2105547.1996400002 | 37.7619831846864 | -122.40930414927799 | (37.7619831846864, -122.409304149278) |
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");