Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52035 | 52035 | 62426 | Permitted Site 1 | Caryota maxima 'Himalaya' :: Himalayan Fishtail Palm 420 | 2100 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1985 12:00:00 AM | 5 | Permit Number 22583 | 6000700.6144199995 | 2120341.37908 | 37.8020914317467 | -122.441762591174 | (37.8020914317467, -122.441762591174) | ||
| 122952 | 122952 | 88563 | Permitted Site 1 | Caryota maxima 'Himalaya' :: Himalayan Fishtail Palm 420 | 2100 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2008 12:00:00 AM | 14 | 3x3 | Permit Number 51509 | 6000679.20483 | 2120339.64887 | 37.802085461143896 | -122.44183655413201 | (37.8020854611439, -122.441836554132) | |
| 137002 | 137002 | 125932 | Undocumented 2 | Caryota maxima 'Himalaya' :: Himalayan Fishtail Palm 420 | 3501 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6000730.20198 | 2120378.8878099998 | 37.8021961065304 | -122.441662897727 | (37.8021961065304, -122.441662897727) | |||
| 165419 | 165419 | 125933 | Undocumented 2 | Caryota maxima 'Himalaya' :: Himalayan Fishtail Palm 420 | 2100 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000655.19151 | 2120337.49517 | 37.802078179336 | -122.441919496789 | (37.802078179336, -122.441919496789) |
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");