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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30563 | 30563 | 197865 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012061.31156 | 2091075.0392200002 | 37.7223733500335 | -122.400392044067 | (37.7223733500335, -122.400392044067) | |||
| 32658 | 32658 | 197832 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011977.7440599995 | 2091356.8323099997 | 37.7231424358482 | -122.400700705798 | (37.7231424358482, -122.400700705798) | |||
| 33445 | 33445 | 197872 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1999 Revere Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6013000.33309 | 2095912.9511400003 | 37.735709585525896 | -122.397485169905 | (37.7357095855259, -122.397485169905) | ||||
| 36868 | 36868 | 197828 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011973.2449 | 2091368.8338900001 | 37.7231751387972 | -122.40071710133002 | (37.7231751387972, -122.40071710133) | |||
| 54601 | 54601 | 197897 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1951 Revere Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6013050.0772 | 2095880.3855299999 | 37.735622936752 | -122.397310901072 | (37.735622936752, -122.397310901072) | ||||
| 136507 | 136507 | 241008 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1900 Bryant St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009482.3011 | 2105844.67305 | 37.762783381658295 | -122.410349456486 | (37.7627833816583, -122.410349456486) | |||
| 150558 | 150558 | 197829 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011975.02506 | 2091365.10159 | 37.7231649899516 | -122.400710685553 | (37.7231649899516, -122.400710685553) | |||
| 152312 | 152312 | 136583 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 28 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001595.11288 | 2121567.19805 | 37.805508131569795 | -122.438755095494 | (37.8055081315698, -122.438755095494) | |||
| 167052 | 167052 | 197871 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 2 Vesta St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6012144.97896 | 2094320.5909799999 | 37.731289633510706 | -122.40033067072599 | (37.7312896335107, -122.400330670726) | |||
| 167198 | 167198 | 197830 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011976.224330001 | 2091363.229 | 37.723159915090704 | -122.40070640839701 | (37.7231599150907, -122.400706408397) | |||
| 170715 | 170715 | 197838 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6011994.83884 | 2091294.88087 | 37.722973283274605 | -122.40063726222701 | (37.7229732832746, -122.400637262227) | |||
| 177376 | 177376 | 197859 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012044.049980001 | 2091128.7806099998 | 37.7225199503291 | -122.400455486754 | (37.7225199503291, -122.400455486754) |
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");