Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36611 | 36611 | 207332 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 139 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6000483.56606 | 2095198.0934400002 | 37.7330418734682 | -122.44070911276 | (37.7330418734682, -122.44070911276) | |||
| 37207 | 37207 | 207145 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1418 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991828.31268 | 2105750.01462 | 37.7615180292623 | -122.471400907553 | (37.7615180292623, -122.471400907553) | |||
| 47592 | 47592 | 207190 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999972.7522599995 | 2094392.56954 | 37.7308009895699 | -122.44241731471399 | (37.7308009895699, -122.442417314714) | ||||
| 70030 | 70030 | 177026 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Sweeny St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6008206.81715 | 2094351.9900900002 | 37.7311554564421 | -122.41394787781601 | (37.7311554564421, -122.413947877816) | |||
| 73643 | 73643 | 207345 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 628 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998591.38299 | 2094890.7633 | 37.732090079596794 | -122.44722875061399 | (37.7320900795968, -122.447228750614) | |||
| 133764 | 133764 | 207351 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 662 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5997053.67683 | 2095305.7853299999 | 37.7331416469589 | -122.45257485054701 | (37.7331416469589, -122.452574850547) | |||
| 135933 | 135933 | 176997 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 131 Farragut Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5997268.75573 | 2087384.8014900002 | 37.7114048037631 | -122.451260209013 | (37.7114048037631, -122.451260209013) | |||
| 162797 | 162797 | 207229 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1162 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 5995089.6840699995 | 2091648.0085099998 | 37.7229855509323 | -122.459100089412 | (37.7229855509323, -122.459100089412) | |||
| 182796 | 182796 | 207336 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999335.46736 | 2095537.54616 | 37.7339084817781 | -122.444702769016 | (37.7339084817781, -122.444702769016) | |||
| 185209 | 185209 | 207231 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 250 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994770.3606900005 | 2090247.29491 | 37.7191211640843 | -122.46010248996099 | (37.7191211640843, -122.460102489961) | |||
| 188039 | 188039 | 207335 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999338.03809 | 2095537.4927400001 | 37.7339084817987 | -122.444693877414 | (37.7339084817987, -122.444693877414) |
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");