Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29648 | 29648 | 196372 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013890.9677099995 | 2092887.97335 | 37.7274531643304 | -122.394194162931 | (37.7274531643304, -122.394194162931) | ||||
| 31357 | 31357 | 237945 | Undocumented 2 | Prunus spp :: Cherry 84 | 99 Aztec St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007968.29609 | 2099608.22097 | 37.7455745134701 | -122.415144412305 | (37.7455745134701, -122.415144412305) | ||||
| 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) | |||
| 63837 | 63837 | 234919 | Undocumented 2 | Prunus spp :: Cherry 84 | 200 Saint Marys Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6003932.02563 | 2095971.19882 | 37.735360426449105 | -122.428841975603 | (37.7353604264491, -122.428841975603) | |||
| 162408 | 162408 | 213702 | Undocumented 2 | Prunus spp :: Cherry 84 | 714 Detroit St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5999450.30082 | 2095402.17977 | 37.7335433498509 | -122.444296031758 | (37.7335433498509, -122.444296031758) | ||||
| 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) | |||
| 186195 | 186195 | 196068 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013885.20395 | 2092887.6121599998 | 37.727451852204204 | -122.39421406314399 | (37.7274518522042, -122.394214063144) |
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");