Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 56470 | 56470 | 129438 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.790027121797294 | -122.409114812309 | (37.7900271217973, -122.409114812309) | |||
| 65596 | 65596 | 129426 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | |||
| 151998 | 151998 | 129437 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010035.0094 | 2115756.1647799998 | 37.790028987884895 | -122.409137245009 | (37.7900289878849, -122.409137245009) | |||
| 163894 | 163894 | 129427 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.794451121666604 | -122.43271221522 | (37.7944511216666, -122.43271221522) | |||
| 171961 | 171961 | 129439 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010043.54378 | 2115756.3306400003 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | |||
| 182481 | 182481 | 129436 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) |
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");