Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28971 | 28971 | 192361 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 10 | : Yard 23 | Tree 1 | Private 1 | 10 | 6015010.08641 | 2102185.10422 | 37.7530433120206 | -122.390974850809 | (37.7530433120206, -122.390974850809) | ||||
| 49572 | 49572 | 189393 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 24th St | 15 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017282.75412 | 2102644.41979 | 37.7544303427117 | -122.38314741343201 | (37.7544303427117, -122.383147413432) | ||||
| 63729 | 63729 | 190751 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1 24th St | 4 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017101.49687 | 2102687.7625599997 | 37.7545393351402 | -122.38377727163 | (37.7545393351402, -122.38377727163) | ||||
| 70403 | 70403 | 233232 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 5 | : Yard 23 | Tree 1 | Private 1 | 10 | Width 3ft | 6010129.8045 | 2099669.06085 | 37.7458628019252 | -122.407674502171 | (37.7458628019252, -122.407674502171) | |||
| 132015 | 132015 | 196092 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 24 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014425.82588 | 2105887.0502299997 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | ||||
| 147367 | 147367 | 194594 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 22 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014433.28496 | 2105898.16367 | 37.7632065495547 | -122.393229358544 | (37.7632065495547, -122.393229358544) | ||||
| 163548 | 163548 | 189289 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 20 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014461.84726 | 2105889.9963 | 37.76318571047079 | -122.393129998769 | (37.7631857104708, -122.393129998769) |
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");