Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65300 | 65300 | 111749 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 4124 23rd St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002319.4 | 2102413.2 | 37.752957247271 | -122.434877962118 | (37.752957247271, -122.434877962118) | |||||
| 90443 | 90443 | 111748 | Landmark tree 9 | Aesculus californica :: California Buckeye 338 | 730 28th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987294.2 | 2110946.4 | 37.7755225253955 | -122.48746405921301 | (37.7755225253955, -122.487464059213) | |||||
| 114869 | 114869 | 111205 | Landmark tree 9 | Araucaria heterophylla :: Norfolk Island Pine 24 | 46 COOK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514.0 | 2113392.0 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | ||||
| 124625 | 124625 | 111763 | Landmark tree 9 | Cupressus macrocarpa :: Monterey Cypress 47 | 2626 Vallejo St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | |||||
| 126137 | 126137 | 105444 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005075.5 | 2108088.5 | 37.768696376708895 | -122.425750755404 | (37.7686963767089, -122.425750755404) |
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");