Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37252 | 37252 | 234917 | Undocumented 2 | Prunus spp :: Cherry 84 | 1341 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011175.62775 | 2102086.9904099996 | 37.7525603976539 | -122.40422831989599 | (37.7525603976539, -122.404228319896) | |||
| 38547 | 38547 | 196063 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 6012868.1198 | 2103766.18767 | 37.757265535503 | -122.39849317144501 | (37.757265535503, -122.398493171445) | |||
| 137994 | 137994 | 196067 | Undocumented 2 | Prunus spp :: Cherry 84 | 2338 Lane St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 5ft | 6013920.54146 | 2092873.2671400001 | 37.727414427818395 | -122.394090896496 | (37.7274144278184, -122.394090896496) | |||
| 147685 | 147685 | 196064 | Undocumented 2 | Prunus spp :: Cherry 84 | 1800 Illinois St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6016257.27394 | 2100629.7145700003 | 37.7488416623195 | -122.386553348372 | (37.7488416623195, -122.386553348372) | |||
| 148091 | 148091 | 234924 | Undocumented 2 | Prunus spp :: Cherry 84 | 323 Mullen Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 6010626.29866 | 2099830.99271 | 37.7463352122137 | -122.4059690917 | (37.7463352122137, -122.4059690917) | |||
| 177483 | 177483 | 196062 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 5ft | 6012859.76673 | 2103766.08005 | 37.757264774654395 | -122.398522052264 | (37.7572647746544, -122.398522052264) |
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");