Street_Tree_List

Data source: data.sfgov.org

17 rows where PlotSize = "Width 8ft" and qSiteInfo = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, qAddress, SiteOrder, DBH

PlotSize ✖

  • Width 8ft · 17 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29484 29484 190646 Undocumented 2 Heteromeles arbutifolia :: Toyon 322 230 Middle Point Rd 4 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   6018218.4425 2096359.44868 37.7372247426365 -122.379474956329 (37.7372247426365, -122.379474956329)
33505 33505 193829 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 900 Phelps St 13 Side Yard : Yard 17 Tree 1 Private 1     27 Width 8ft   6014453.31745 2096931.20635 37.738586300018504 -122.392532803946 (37.7385863000185, -122.392532803946)
39127 39127 247002 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 401 Valley St 2 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   6003223.72191 2099183.9093400002 37.7441416748926 -122.431520126078 (37.7441416748926, -122.431520126078)
41147 41147 247005 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 401 Valley St 5 Side Yard : Yard 17 Tree 1 Private 1     2 Width 8ft   6003245.1291 2099189.5781900003 37.7441584535423 -122.431446509373 (37.7441584535423, -122.431446509373)
48630 48630 247006 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 401 Valley St 6 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   6003253.92203 2099189.92697 37.7441599095582 -122.43141613026 (37.7441599095582, -122.43141613026)
50991 50991 203317 Undocumented 2 Acer palmatum :: Japanese Maple 175 1515 16th Ave 1 Side Yard : Yard 17 Tree 1 Private 1     6 Width 8ft   5991175.14948 2105039.99944 37.759530710094296 -122.47360811363899 (37.7595307100943, -122.473608113639)
57193 57193 247001 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 401 Valley St 1 Side Yard : Yard 17 Tree 1 Private 1     5 Width 8ft   6003204.32988 2099186.4435 37.744147533977795 -122.431587360294 (37.7441475339778, -122.431587360294)
62478 62478 247003 Undocumented 2 Juniperus chinensis :: Juniper 19 401 Valley St 3 Side Yard : Yard 17 Tree 1 Private 1     6 Width 8ft   6003236.004319999 2099186.05464 37.744148261529006 -122.431477809352 (37.744148261529, -122.431477809352)
137129 137129 203318 Undocumented 2 Acer palmatum :: Japanese Maple 175 1515 16th Ave 2 Side Yard : Yard 17 Tree 1 Private 1     4 Width 8ft   5991179.11324 2105030.95188 37.7595060974465 -122.473593745149 (37.7595060974465, -122.473593745149)
154255 154255 247009 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 401 Valley St 9 Side Yard : Yard 17 Tree 1 Private 1     13 Width 8ft   6003278.48209 2099193.13161 37.744170100676996 -122.431331435716 (37.744170100677, -122.431331435716)
157854 157854 203451 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 1515 16th Ave 4 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   5991183.11857 2105012.94014 37.7594568739424 -122.473578579008 (37.7594568739424, -122.473578579008)
170593 170593 247004 Undocumented 2 Aesculus californica :: California Buckeye 338 401 Valley St 4 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   6003237.98739 2099191.84637 37.7441642766696 -122.43147136571501 (37.7441642766696, -122.431471365715)
173419 173419 203452 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 1515 16th Ave 5 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   5991186.2272 2105007.12865 37.7594410971589 -122.473567404026 (37.7594410971589, -122.473567404026)
173508 173508 247008 Undocumented 2 Callistemon 'Jeffers' :: Purple bottlebrush 395 401 Valley St 8 Side Yard : Yard 17 Tree 1 Private 1     5 Width 8ft   6003270.60035 2099185.34055 37.74414826155 -122.43135813298599 (37.74414826155, -122.431358132986)
175990 175990 203450 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 1515 16th Ave 3 Side Yard : Yard 17 Tree 1 Private 1     9 Width 8ft   5991181.21192 2105021.0246 37.7594789613077 -122.47358576280001 (37.7594789613077, -122.4735857628)
179168 179168 247007 Undocumented 2 Callistemon salignus :: White flowering bottlebrush 557 401 Valley St 7 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   6003259.67301 2099184.77085 37.744146077987 -122.431395876644 (37.744146077987, -122.431395876644)
185796 185796 214455 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 449 Baden St 1 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   6000738.084840001 2095503.40232 37.733894671806 -122.439851058803 (37.733894671806, -122.439851058803)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 251.137ms · Data source: data.sfgov.org