Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4701 | 4701 | 253665 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4707 | 4707 | 253664 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4708 | 4708 | 253663 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 14134 | 14134 | 104461 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1601X Kansas St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011834.442419999 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | |||
| 36317 | 36317 | 108395 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 311 Ordway St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6011028.372719999 | 2090050.89786 | 37.7195036115824 | -122.403890660433 | (37.7195036115824, -122.403890660433) | ||
| 49113 | 49113 | 119630 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave West | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | 5999876.8122 | 2107852.06726 | 37.7677520478965 | -122.443715568345 | (37.7677520478965, -122.443715568345) | |||
| 86292 | 86292 | 119628 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave West | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | 5999876.8122 | 2107852.06726 | 37.7677520478965 | -122.443715568345 | (37.7677520478965, -122.443715568345) | |||
| 86783 | 86783 | 48615 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 201 Ulloa St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.45586132044201 | (37.7434052350482, -122.455861320442) | ||
| 90836 | 90836 | 112429 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Arguello Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | 5995478.7 | 2115781.3 | 37.789271784254495 | -122.45950233827601 | (37.7892717842545, -122.459502338276) | |||
| 99781 | 99781 | 112425 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Arguello Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | Permit Number 774100 | 5995478.7 | 2115781.3 | 37.789271784254495 | -122.45950233827601 | (37.7892717842545, -122.459502338276) | ||
| 106657 | 106657 | 112430 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 17 Arguello Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3x3 | 5995478.7 | 2115781.3 | 37.789271784254495 | -122.45950233827601 | (37.7892717842545, -122.459502338276) | |||
| 107498 | 107498 | 48618 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 201 Ulloa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.45586132044201 | (37.7434052350482, -122.455861320442) | ||
| 109370 | 109370 | 1414 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3X5 | 5995457.5707 | 2115860.24617 | 37.7894873341044 | -122.459581162818 | (37.7894873341044, -122.459581162818) | |||
| 110265 | 110265 | 112433 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 774101 | 5995479.0 | 2115773.8 | 37.7892512085361 | -122.45950075691601 | (37.7892512085361, -122.459500756916) | |||
| 141795 | 141795 | 119629 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave West | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | 5999876.8122 | 2107852.06726 | 37.7677520478965 | -122.443715568345 | (37.7677520478965, -122.443715568345) |
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");