Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25980 | 25980 | 143091 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 620 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009899.7854 | 2120236.6745 | 37.802323796980296 | -122.409921530777 | (37.8023237969803, -122.409921530777) | |||
| 56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
| 136211 | 136211 | 183297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1279 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5983033.5705 | 2106401.2294 | 37.762793394201005 | -122.501865989484 | (37.762793394201, -122.501865989484) | |||
| 147970 | 147970 | 73456 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 11 | 6009946.950619999 | 2110955.66255 | 37.776843015637 | -122.409103049163 | (37.776843015637, -122.409103049163) | ||
| 149931 | 149931 | 214390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 291 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992218.0613400005 | 2097396.8798 | 37.738605017595404 | -122.469444880296 | (37.7386050175954, -122.469444880296) | |||
| 157140 | 157140 | 214435 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 320 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5993233.77766 | 2104623.70866 | 37.758506690737 | -122.46645815892201 | (37.758506690737, -122.466458158922) | |||
| 158371 | 158371 | 178951 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1485 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007220.074 | 2091773.1745900002 | 37.7240191183805 | -122.417176564472 | (37.7240191183805, -122.417176564472) | |||
| 175403 | 175403 | 178952 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1485 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007251.31205 | 2091779.98256 | 37.7240395689419 | -122.41706906129 | (37.7240395689419, -122.41706906129) | |||
| 177635 | 177635 | 118425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981790.15899 | 2111638.01027 | 37.7770989536906 | -122.506554832582 | (37.7770989536906, -122.506554832582) | |||
| 187343 | 187343 | 214392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 185 Granville Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994371.91106 | 2098648.34768 | 37.7421654749467 | -122.46208868315 | (37.7421654749467, -122.46208868315) | |||
| 160610 | 160610 | 67707 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 31 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 11 | Permit Number 31318 | 6014113.9587900005 | 2113076.60421 | 37.7828991959845 | -122.39483657655 | (37.7828991959845, -122.39483657655) |
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");