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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29018 | 29018 | 247759 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 75 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | |||
| 39742 | 39742 | 192410 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011779.1081300005 | 2105360.6424 | 37.761582826304604 | -122.402371529224 | (37.7615828263046, -122.402371529224) | |||
| 40705 | 40705 | 192411 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.40236942660499 | (37.7615462436837, -122.402369426605) | |||
| 41412 | 41412 | 192412 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011780.95507 | 2105331.83928 | 37.761503842456605 | -122.402363116082 | (37.7615038424566, -122.402363116082) | |||
| 60881 | 60881 | 192409 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | |||
| 67076 | 67076 | 192420 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013708.5618199995 | 2104154.58233 | 37.7583787675789 | -122.395613785069 | (37.7583787675789, -122.395613785069) | |||
| 70499 | 70499 | 192417 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | |||
| 136191 | 136191 | 192416 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1400 20th St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013651.01145 | 2104790.61421 | 37.760121971170896 | -122.395857388933 | (37.7601219711709, -122.395857388933) | |||
| 146753 | 146753 | 192418 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 5ft | 6013740.02795 | 2104156.2297400003 | 37.7583850412574 | -122.39550507589199 | (37.7583850412574, -122.395505075892) | |||
| 153603 | 153603 | 128862 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | |||
| 154338 | 154338 | 192414 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.76041492892529 | -122.40224581930799 | (37.7604149289253, -122.402245819308) | |||
| 156793 | 156793 | 192413 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011782.001 | 2105308.50285 | 37.7614398242054 | -122.402357857724 | (37.7614398242054, -122.402357857724) | |||
| 168685 | 168685 | 192421 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 53 Pomona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6014148.288919999 | 2094395.14028 | 37.731605838737295 | -122.39341002514799 | (37.7316058387373, -122.393410025148) | |||
| 173461 | 173461 | 192419 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013725.780809999 | 2104155.14731 | 37.7583812766799 | -122.39555427333299 | (37.7583812766799, -122.395554273333) | |||
| 184565 | 184565 | 192415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1400 20th St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013731.20085 | 2104795.9240599996 | 37.760141011629706 | -122.39558042201 | (37.7601410116297, -122.39558042201) |
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");