Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3723 | 3723 | 253167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 3733 | 3733 | 175357 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992890.63105 | 2087809.5806900002 | 37.7123194916216 | -122.466422861444 | (37.7123194916216, -122.466422861444) | |||
| 3738 | 3738 | 175361 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5993097.02114 | 2087813.9243700001 | 37.7123433254574 | -122.465709836634 | (37.7123433254574, -122.465709836634) | |||
| 3740 | 3740 | 175359 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 5993023.53483 | 2087808.23472 | 37.7123234639353 | -122.465963412176 | (37.7123234639353, -122.465963412176) | |||
| 3747 | 3747 | 175360 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 5993054.1062900005 | 2087811.2090200002 | 37.7123333942521 | -122.46585796488002 | (37.7123333942521, -122.46585796488) | |||
| 3748 | 3748 | 175358 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992915.27224 | 2087806.8926400002 | 37.7123135327144 | -122.466337499576 | (37.7123135327144, -122.466337499576) | |||
| 26929 | 26929 | 219589 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 San Jose Ave | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004392.47127 | 2096007.06435 | 37.7354849555631 | -122.42725259745 | (37.7354849555631, -122.42725259745) | ||||
| 27984 | 27984 | 204834 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1676 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 5993429.17197 | 2104103.8615599996 | 37.7570905984748 | -122.465744634126 | (37.7570905984748, -122.465744634126) | |||
| 34432 | 34432 | 175331 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 96 Alpha St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6011045.645819999 | 2088262.3941099998 | 37.7145937089056 | -122.40370517707 | (37.7145937089056, -122.40370517707) | ||||
| 36272 | 36272 | 188010 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1301 Minnesota St | 67 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015365.19065 | 2102314.31194 | 37.7534177870144 | -122.389755844955 | (37.7534177870144, -122.389755844955) | ||||
| 39118 | 39118 | 175330 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 96 Alpha St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011072.40293 | 2088273.4746599998 | 37.7146256285428 | -122.403613472283 | (37.7146256285428, -122.403613472283) | ||||
| 41972 | 41972 | 221043 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 290 States St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6000286.81681 | 2106864.0855799997 | 37.765062672917104 | -122.44222648486601 | (37.7650626729171, -122.442226484866) | |||
| 46454 | 46454 | 249718 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2500 Broderick St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 7ft | 6000151.18545 | 2117398.2576599997 | 37.793979081021206 | -122.443452341757 | (37.7939790810212, -122.443452341757) | |||
| 60437 | 60437 | 188011 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1301 Minnesota St | 68 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6015362.17662 | 2102309.48184 | 37.753404357443706 | -122.389765930854 | (37.7534043574437, -122.389765930854) | ||||
| 63733 | 63733 | 204835 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1676 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 5993429.377119999 | 2104096.19821 | 37.757069568735105 | -122.46574336787901 | (37.7570695687351, -122.465743367879) | |||
| 71645 | 71645 | 175280 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Tocoloma Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012813.92638 | 2087567.88235 | 37.7127853395403 | -122.397544560234 | (37.7127853395403, -122.397544560234) | ||||
| 72899 | 72899 | 219591 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004442.021000001 | 2096044.89637 | 37.7355916358349 | -122.427083979057 | (37.7355916358349, -122.427083979057) | ||||
| 84656 | 84656 | 92048 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 125951 | 125951 | 87199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 71 Mansfield St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/31/2008 12:00:00 AM | 3x3 | Permit Number 50216 | 6005338.0 | 2091826.0 | 37.7240581044071 | -122.423686361989 | (37.7240581044071, -122.423686361989) | |||
| 147792 | 147792 | 188009 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1301 Minnesota St | 63 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015359.2445 | 2102354.25155 | 37.7535271230016 | -122.38977919765 | (37.7535271230016, -122.38977919765) | ||||
| 161447 | 161447 | 204836 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1676 09th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 6ft | 5993428.81967 | 2104087.09171 | 37.7570445324907 | -122.465744634123 | (37.7570445324907, -122.465744634123) | |||
| 162192 | 162192 | 175281 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Tocoloma Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012823.449990001 | 2087568.74091 | 37.7127882272645 | -122.39751170352699 | (37.7127882272645, -122.397511703527) | ||||
| 163973 | 163973 | 221047 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 671 Church St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 3ft | 6004330.52793 | 2104879.46065 | 37.759842997882 | -122.4280988388 | (37.759842997882, -122.4280988388) | |||
| 164264 | 164264 | 219590 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004431.32479 | 2096032.9751400002 | 37.7355582979675 | -122.42712011110399 | (37.7355582979675, -122.427120111104) | ||||
| 168236 | 168236 | 175282 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Tocoloma Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6012855.522000001 | 2087574.6646599998 | 37.7128062784591 | -122.397401266752 | (37.7128062784591, -122.397401266752) | ||||
| 169389 | 169389 | 221095 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 148 Beacon St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 5ft | 6003325.71953 | 2097312.8686 | 37.7390100093118 | -122.431033927377 | (37.7390100093118, -122.431033927377) | |||
| 178748 | 178748 | 188008 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1301 Minnesota St | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015360.85476 | 2102358.97833 | 37.7535401910343 | -122.389773959104 | (37.7535401910343, -122.389773959104) |
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");