Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6505 | 6505 | 20152 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 12 | 3X3 | 6002876.4729 | 2111952.9425 | 37.7791826693541 | -122.433633233262 | (37.7791826693541, -122.433633233262) | ||
| 22144 | 22144 | 2049 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 701X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001977.73953 | 2095412.31759 | 37.733715061000204 | -122.43555868909901 | (37.7337150610002, -122.435558689099) | |||
| 25419 | 25419 | 205555 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 18 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996627.05055 | 2093785.0930599999 | 37.7289417374555 | -122.45394001961701 | (37.7289417374555, -122.453940019617) | |||
| 40682 | 40682 | 221167 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1511 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002614.763119999 | 2100979.87159 | 37.749038432187206 | -122.433754105874 | (37.7490384321872, -122.433754105874) | |||
| 45091 | 45091 | 221126 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 229 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6009794.39876 | 2099562.54978 | 37.745551564551704 | -122.40882678015801 | (37.7455515645517, -122.408826780158) | |||
| 58169 | 58169 | 204336 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 519 Wildwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994961.78561 | 2093308.98405 | 37.727538836434796 | -122.45966245167101 | (37.7275388364348, -122.459662451671) | |||
| 59553 | 59553 | 204275 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1786 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5993146.69898 | 2103337.92624 | 37.754971240842096 | -122.46666585194299 | (37.7549712408421, -122.466665851943) | |||
| 68716 | 68716 | 205548 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 224 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996065.7726 | 2094328.00595 | 37.730400248067795 | -122.455919619 | (37.7304002480678, -122.455919619) | |||
| 91717 | 91717 | 107012 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
| 112697 | 112697 | 114520 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 199x WESTWOOD DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5995156.0 | 2093967.0 | 37.7293567553632 | -122.45903868041599 | (37.7293567553632, -122.459038680416) | |||
| 134774 | 134774 | 205535 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 521 Wildwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994784.86804 | 2093312.06258 | 37.7275371142209 | -122.460274275733 | (37.7275371142209, -122.460274275733) | |||
| 138118 | 138118 | 221098 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6009314.5684 | 2105431.86525 | 37.7616405016156 | -122.410900429722 | (37.7616405016156, -122.410900429722) | |||
| 149960 | 149960 | 175554 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 751 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002038.05484 | 2089420.5116400002 | 37.7172663411433 | -122.434921798223 | (37.7172663411433, -122.434921798223) | |||
| 154211 | 154211 | 204227 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1773 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993405.2188 | 2103425.86061 | 37.7552276015825 | -122.46577821299101 | (37.7552276015825, -122.465778212991) | |||
| 174297 | 174297 | 205545 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 216 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996085.57996 | 2094275.5517900002 | 37.7302573583846 | -122.455847352172 | (37.7302573583846, -122.455847352172) | |||
| 175599 | 175599 | 204349 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1270 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995862.70656 | 2092545.2519599998 | 37.7254935766644 | -122.45649277584299 | (37.7254935766644, -122.456492775843) | |||
| 180309 | 180309 | 205538 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Montecito Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5995944.06447 | 2094085.5653900001 | 37.7297275785675 | -122.45632285521799 | (37.7297275785675, -122.456322855218) |
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");