Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25721 | 25721 | 190755 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1999 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6012974.9721800005 | 2095942.04055 | 37.7357880468688 | -122.397574892566 | (37.7357880468688, -122.397574892566) | ||||
| 28933 | 28933 | 190753 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1150 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014508.91197 | 2104838.28593 | 37.7603005567523 | -122.392893631745 | (37.7603005567523, -122.392893631745) | |||
| 33535 | 33535 | 226834 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 246 Bemis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6003051.73266 | 2096339.9722099998 | 37.7363231300074 | -122.431911797003 | (37.7363231300074, -122.431911797003) | ||||
| 38122 | 38122 | 190754 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 373 Arkansas St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 6012960.2346 | 2105313.22845 | 37.7615185013946 | -122.398283141072 | (37.7615185013946, -122.398283141072) | |||
| 63729 | 63729 | 190751 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1 24th St | 4 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017101.49687 | 2102687.7625599997 | 37.7545393351402 | -122.38377727163 | (37.7545393351402, -122.38377727163) | ||||
| 64270 | 64270 | 190756 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1998 Revere Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013013.81387 | 2095974.7976 | 37.7358801536468 | -122.397442897286 | (37.7358801536468, -122.397442897286) | ||||
| 75745 | 75745 | 121584 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1190X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014447.0 | 2104828.0 | 37.7602688747214 | -122.393107038214 | (37.7602688747214, -122.393107038214) | |||
| 125019 | 125019 | 104828 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 22 FOREST SIDE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x3 | 5992639.6 | 2098939.5 | 37.7428650146746 | -122.468099596108 | (37.7428650146746, -122.468099596108) | |||
| 132724 | 132724 | 219237 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 22 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992647.808999999 | 2098925.42446 | 37.7428268408965 | -122.468070188284 | (37.7428268408965, -122.468070188284) | |||
| 150675 | 150675 | 190752 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1 24th St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6017117.58441 | 2102700.05767 | 37.7545739842169 | -122.383722492107 | (37.7545739842169, -122.383722492107) | ||||
| 180684 | 180684 | 226835 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 27 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002073.33297 | 2096755.10087 | 37.7374074632877 | -122.43532421245199 | (37.7374074632877, -122.435324212452) | |||
| 185475 | 185475 | 226833 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 383 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6005502.418819999 | 2101516.8939799997 | 37.7506764060913 | -122.423806738884 | (37.7506764060913, -122.423806738884) |
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");