Street_Tree_List

Data source: data.sfgov.org

11 rows where PlotSize = "Width 6ft" and qSpecies = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 6ft · 11 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
22356 22356 223022 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 6ft   6006257.519669999 2099541.04409 37.745293770294104 -122.42105525588998 (37.7452937702941, -122.42105525589)
26518 26518 206504 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1959 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5993136.05327 2102151.01657 37.7517116786758 -122.46661639913602 (37.7517116786758, -122.466616399136)
28309 28309 206505 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1965 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5993138.76599 2102124.2403700002 37.7516383146611 -122.46660507218701 (37.7516383146611, -122.466605072187)
29329 29329 206551 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 308 Pacheco St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994320.14066 2100781.15308 37.74801864146029 -122.462422349606 (37.7480186414603, -122.462422349606)
33381 33381 206506 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1985 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5993143.71774 2101970.98373 37.7512177970674 -122.46657681008301 (37.7512177970674, -122.466576810083)
34642 34642 223020 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 125 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6006199.74889 2099432.38497 37.7449921601655 -122.421247303447 (37.7449921601655, -122.421247303447)
52949 52949 206549 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 308 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994338.43004 2100748.81738 37.7479309089808 -122.462356761175 (37.7479309089808, -122.462356761175)
114401 114401 206552 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 308 Pacheco St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5994313.1172 2100803.87721 37.7480806317257 -122.462448284279 (37.7480806317257, -122.462448284279)
137122 137122 206507 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1985 10th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5993144.62205 2101960.97627 37.751190371338 -122.46657295558599 (37.751190371338, -122.466572955586)
167733 167733 206503 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1957 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5993135.46016 2102179.05998 37.751788644440495 -122.46662048837 (37.7517886444405, -122.46662048837)
182763 182763 206550 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 308 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5994328.73662 2100761.78102 37.7479659456765 -122.46239122047199 (37.7479659456765, -122.462391220472)

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 156.708ms · Data source: data.sfgov.org