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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23291 | 23291 | 27166 | DPW Maintained 3 | Lagerstroemia indica :: Crape Myrtle 199 | 1950 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 5 | 2X3 | 6011856.11621 | 2095630.9787 | 37.7348715720666 | -122.401421384693 | (37.7348715720666, -122.401421384693) | ||
| 33847 | 33847 | 176866 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 205 Seneca Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999819.10608 | 2090379.3923 | 37.7197729711124 | -122.442660448227 | (37.7197729711124, -122.442660448227) | |||
| 36088 | 36088 | 176871 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 466 Paris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6001962.84798 | 2090902.89386 | 37.721332361375204 | -122.43528772696399 | (37.7213323613752, -122.435287726964) | |||
| 41562 | 41562 | 227057 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 36 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006024.56272 | 2102894.52743 | 37.754488532433705 | -122.422098977597 | (37.7544885324337, -122.422098977597) | |||
| 43241 | 43241 | 217760 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 460 West Portal Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991734.77197 | 2096495.4361599998 | 37.736101939940205 | -122.471050195332 | (37.7361019399402, -122.471050195332) | |||
| 56476 | 56476 | 227063 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 310 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008808.10283 | 2097327.49228 | 37.739359293383 | -122.412079324914 | (37.739359293383, -122.412079324914) | |||
| 155764 | 155764 | 227052 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 16 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005980.22404 | 2105419.0145400004 | 37.761417684710494 | -122.422431677274 | (37.7614176847105, -122.422431677274) | |||
| 160027 | 160027 | 227050 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 295 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004692.50509 | 2109376.8502700003 | 37.772212224749204 | -122.42716728596001 | (37.7722122247492, -122.42716728596) | |||
| 179378 | 179378 | 227055 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 1523 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009607.86585 | 2100388.33634 | 37.7478085427258 | -122.40953005626899 | (37.7478085427258, -122.409530056269) | |||
| 181800 | 181800 | 55612 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 620 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1973 12:00:00 AM | 5 | Permit Number 11589 | 6008867.71291 | 2091224.31143 | 37.722604610692294 | -122.41144215434099 | (37.7226046106923, -122.411442154341) | ||
| 183140 | 183140 | 227054 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 16 Lapidge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005981.42855 | 2105394.22422 | 37.761349684260104 | -122.422425749859 | (37.7613496842601, -122.422425749859) |
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");