Street_Tree_List

Data source: data.sfgov.org

17 rows where DBH = 6 and qSiteInfo = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, qAddress, SiteOrder

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24928 24928 223320 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 5 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003607.3788 2104219.57182 37.7579901597246 -122.430552770305 (37.7579901597246, -122.430552770305)
25729 25729 233231 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 4 : Yard 23 Tree 1 Private 1     6 Width 3ft   6010116.17645 2099679.88413 37.7458917573937 -122.407722389299 (37.7458917573937, -122.407722389299)
33649 33649 196072 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 4 : Yard 23 Tree 1 Private 1     6     6014990.91174 2102121.65719 37.7528680359305 -122.391036726872 (37.7528680359305, -122.391036726872)
38165 38165 223321 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 6 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003607.59341 2104210.2360400003 37.757964538052796 -122.430551361954 (37.7579645380528, -122.430551361954)
44764 44764 205937 Undocumented 2 Ceanothus Sps :: California lilac 270 50 Circular Ave 1 : Yard 23 Tree 1 Private 1     6     6000127.5419 2093913.2935099998 37.7294938303644 -122.44184779835501 (37.7294938303644, -122.441847798355)
68242 68242 223322 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 7 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003609.4958 2104203.70513 37.757946713498704 -122.430544316686 (37.7579467134987, -122.430544316686)
130498 130498 196075 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 17 : Yard 23 Tree 1 Private 1     6     6014963.469190001 2102214.24517 37.753120740043705 -122.391138100256 (37.7531207400437, -122.391138100256)
130707 130707 190965 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 24th St 17 : Yard 23 Tree 1 Private 1     6     6017293.94065 2102634.4333599997 37.754403540203796 -122.38310803210899 (37.7544035402038, -122.383108032109)
133863 133863 196076 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 18 : Yard 23 Tree 1 Private 1     6     6014971.87416 2102223.03647 37.753145345506795 -122.39110964840401 (37.7531453455068, -122.391109648404)
134356 134356 233602 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 8 : Yard 23 Tree 1 Private 1     6 Width 3ft   6010143.5997 2099646.47131 37.7458015482156 -122.40762520763701 (37.7458015482156, -122.407625207637)
150305 150305 234860 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 160 Carnelian Way 2 : Yard 23 Tree 1 Private 1     6     6000574.359 2100517.55086 37.7476530184698 -122.44077666170799 (37.7476530184698, -122.440776661708)
151585 151585 196077 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 19 : Yard 23 Tree 1 Private 1     6     6014960.28506 2102234.79181 37.7531769800583 -122.391150547759 (37.7531769800583, -122.391150547759)
154537 154537 233603 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 9 : Yard 23 Tree 1 Private 1     6 Width 3ft   6010152.72418 2099634.5230799997 37.7457692517475 -122.40759281407101 (37.7457692517475, -122.407592814071)
156226 156226 223318 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 3 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003637.291809999 2104227.88023 37.75801466716629 -122.43044991126101 (37.7580146671663, -122.430449911261)
158856 158856 177486 Undocumented 2 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 601 La Grande Ave 1 : Yard 23 Tree 1 Private 1     6     6004368.23495 2089081.7920799998 37.7164683196427 -122.42684334834999 (37.7164683196427, -122.42684334835)
169576 169576 233228 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 1 : Yard 23 Tree 1 Private 1     6 Width 3ft   6010113.61596 2099694.13241 37.7459307367175 -122.407732247644 (37.7459307367175, -122.407732247644)
188821 188821 192368 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 7 : Yard 23 Tree 1 Private 1     6     6014962.221059999 2102496.55555 37.753895835135104 -122.39116214813801 (37.7538958351351, -122.391162148138)

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