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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39298 | 39298 | 126628 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | |||
| 41755 | 41755 | 126624 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 801x Greenwich St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.801926529358504 | -122.41279682292401 | (37.8019265293585, -122.412796822924) | |||
| 71439 | 71439 | 126629 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013771.20775 | 2118034.57435 | 37.7964935638782 | -122.396369982705 | (37.7964935638782, -122.396369982705) | |||
| 133542 | 133542 | 126631 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013670.6132 | 2118002.8434900003 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | |||
| 173926 | 173926 | 126630 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | |||
| 174003 | 174003 | 126627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.39598707025499 | (37.796538299751, -122.395987070255) |
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");