Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35928 | 35928 | 194284 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014504.15008 | 2095180.2076400002 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | ||||
| 39870 | 39870 | 194287 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014435.322380001 | 2095233.3766599998 | 37.733923408722795 | -122.392476296866 | (37.7339234087228, -122.392476296866) | ||||
| 47801 | 47801 | 234359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x Dolores St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6005116.63925 | 2102018.48994 | 37.752031886768705 | -122.42517648553302 | (37.7520318867687, -122.425176485533) | ||||
| 51725 | 51725 | 194333 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | Width 8ft | 6015903.377169999 | 2112286.3418900003 | 37.78082864545979 | -122.38859069771999 | (37.7808286454598, -122.38859069772) | |||
| 130277 | 130277 | 194351 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | Width 8ft | 6016097.15673 | 2113420.59165 | 37.7839537779004 | -122.387999487006 | (37.7839537779004, -122.387999487006) | |||
| 137727 | 137727 | 246536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1x Octavia St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | Width 8ft | 6005696.49055 | 2109344.97624 | 37.7721814310539 | -122.42369214280501 | (37.7721814310539, -122.423692142805) |
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");