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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
| 56432 | 56432 | 227632 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997905.871119999 | 2104612.50701 | 37.758744422044295 | -122.450299233916 | (37.7587444220443, -122.450299233916) | |||
| 56561 | 56561 | 191262 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012676.19431 | 2104276.36771 | 37.7586556841436 | -122.399192740559 | (37.7586556841436, -122.399192740559) | |||
| 58867 | 58867 | 247173 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6001348.76723 | 2108505.96887 | 37.7696313440465 | -122.438671125768 | (37.7696313440465, -122.438671125768) | |||
| 76698 | 76698 | 227631 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997896.0946 | 2104612.71078 | 37.758744422037395 | -122.450333060142 | (37.7587444220374, -122.450333060142) | |||
| 131733 | 131733 | 191263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 728 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012693.0382199995 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | |||
| 136118 | 136118 | 250773 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 259 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | |||
| 156796 | 156796 | 191266 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1721 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.39244165855499 | (37.7328850694924, -122.392441658555) | |||
| 156929 | 156929 | 217749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 445 West Portal Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991783.05973 | 2096405.3403 | 37.7358573522267 | -122.470876685538 | (37.7358573522267, -122.470876685538) | |||
| 159965 | 159965 | 176962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 121 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 5992069.06615 | 2087619.0428799998 | 37.71174887986621 | -122.46924855110301 | (37.7117488798662, -122.469248551103) | |||
| 174454 | 174454 | 227588 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 435 Oak St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004887.16184 | 2110182.76224 | 37.77443606920671 | -122.42655134748001 | (37.7744360692067, -122.42655134748) | |||
| 177184 | 177184 | 191261 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012675.54577 | 2104288.99957 | 37.7586903323146 | -122.399195870217 | (37.7586903323146, -122.399195870217) |
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");