Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35360 | 35360 | 190656 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 358 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012906.49923 | 2105280.1318200002 | 37.7614246319699 | -122.39846666842101 | (37.7614246319699, -122.398466668421) | |||
| 70920 | 70920 | 219180 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | |||
| 73706 | 73706 | 120866 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 701 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990027.965580001 | 2110538.28947 | 37.774561018937796 | -122.477977567474 | (37.7745610189378, -122.477977567474) | |||
| 135498 | 135498 | 228476 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 427 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003772.71447 | 2098922.9201 | 37.7434561594686 | -122.42960322110599 | (37.7434561594686, -122.429603221106) | |||
| 136455 | 136455 | 228479 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998955.25722 | 2107101.1921200003 | 37.7656377291263 | -122.446849065839 | (37.7656377291263, -122.446849065839) | |||
| 146693 | 146693 | 190665 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013152.15167 | 2111293.3784 | 37.777949341814 | -122.398038913074 | (37.777949341814, -122.398038913074) | |||
| 178475 | 178475 | 219179 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994014.03321 | 2103382.75983 | 37.7551443576498 | -122.46366964095199 | (37.7551443576498, -122.463669640952) |
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");