Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25681 | 25681 | 196512 | Undocumented 2 | Prunus spp :: Cherry 84 | 625 King St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6011914.18479 | 2108425.06588 | 37.770004584260704 | -122.402119799109 | (37.7700045842607, -122.402119799109) | |||
| 42127 | 42127 | 234920 | Undocumented 2 | Prunus spp :: Cherry 84 | 501 York St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6009827.75137 | 2105874.2614 | 37.7628839834388 | -122.409156748587 | (37.7628839834388, -122.409156748587) | |||
| 75325 | 75325 | 196511 | Undocumented 2 | Prunus spp :: Cherry 84 | 625 King St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6011918.6881 | 2108412.1194599997 | 37.7699692876805 | -122.402103311835 | (37.7699692876805, -122.402103311835) | |||
| 76569 | 76569 | 136021 | Undocumented 2 | Prunus spp :: Cherry 84 | 1010 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007482.49892 | 2120248.47345 | 37.802220422406705 | -122.418287380977 | (37.8022204224067, -122.418287380977) | ||||
| 131317 | 131317 | 117739 | Undocumented 2 | Prunus spp :: Cherry 84 | 475 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5983746.16527 | 2112679.78018 | 37.7800743257794 | -122.49986552243 | (37.7800743257794, -122.49986552243) | |||
| 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) | |||
| 170723 | 170723 | 196513 | Undocumented 2 | Prunus spp :: Cherry 84 | 625 King St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6011917.55402 | 2108434.4901900003 | 37.770030649334295 | -122.402108807587 | (37.7700306493343, -122.402108807587) | |||
| 174227 | 174227 | 181930 | Undocumented 2 | Prunus spp :: Cherry 84 | 2431 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5986090.3717 | 2098682.4704 | 37.741778875367295 | -122.49072577603 | (37.7417788753673, -122.49072577603) | |||
| 175156 | 175156 | 179165 | Undocumented 2 | Prunus spp :: Cherry 84 | 671 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6001067.99101 | 2089902.67343 | 37.7185351226768 | -122.438309369006 | (37.7185351226768, -122.438309369006) | ||||
| 189034 | 189034 | 122230 | Undocumented 2 | Prunus spp :: Cherry 84 | 700 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991662.29598 | 2110580.8797299997 | 37.774772683199394 | -122.472327258665 | (37.7747726831994, -122.472327258665) |
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");