Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20782 | 20782 | 5368 | DPW Maintained 3 | Brugmansia spp :: Angel trumpet 137 | 254 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004803.994630001 | 2106877.36791 | 37.76535555244661 | -122.42660361788 | (37.7653555524466, -122.42660361788) | |||
| 36357 | 36357 | 188842 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1689 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6014873.05165 | 2097305.05057 | 37.739636100214895 | -122.391107675301 | (37.7396361002149, -122.391107675301) | |||
| 40318 | 40318 | 249851 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 6011475.66665 | 2120406.51075 | 37.8028783187521 | -122.40448014355101 | (37.8028783187521, -122.404480143551) | |||
| 41718 | 41718 | 220739 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 112 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006641.651869999 | 2105417.60595 | 37.761451107091396 | -122.420143969269 | (37.7614511070914, -122.420143969269) | |||
| 43738 | 43738 | 188843 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1689 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6014878.742190001 | 2097300.92271 | 37.739625081743704 | -122.391087711252 | (37.7396250817437, -122.391087711252) | |||
| 63924 | 63924 | 220746 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 804 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007928.5496 | 2103189.4230299997 | 37.755405453309 | -122.41553535119499 | (37.755405453309, -122.415535351195) | |||
| 69587 | 69587 | 175572 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1785 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5997902.91361 | 2088443.5284099998 | 37.7143481157506 | -122.449144629432 | (37.7143481157506, -122.449144629432) | |||
| 74183 | 74183 | 220747 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 804 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007928.36679 | 2103202.3547 | 37.7554409504533 | -122.41553689892 | (37.7554409504533, -122.41553689892) | |||
| 169252 | 169252 | 125733 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 400 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011529.836730001 | 2119068.83076 | 37.7992084021962 | -122.40419848399799 | (37.7992084021962, -122.404198483998) | ||||
| 169459 | 169459 | 249955 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011505.97031 | 2120064.83328 | 37.801941849301 | -122.404351213161 | (37.801941849301, -122.404351213161) | |||
| 175155 | 175155 | 220740 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 104 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004285.19288 | 2109146.5879 | 37.771556938230205 | -122.428559798021 | (37.7715569382302, -122.428559798021) | |||
| 177677 | 177677 | 220748 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 2498 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008830.89382 | 2103969.50732 | 37.757598067002 | -122.41246989777001 | (37.757598067002, -122.41246989777) |
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");