Street_Tree_List

Data source: data.sfgov.org

18 rows where Location = "(37.7437530336215, -122.41873278304)", qCaretaker = 2 and qSiteInfo = 14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, qAddress

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
19241 19241 116677 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 100 Esmeralda Ave 16 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
78555 78555 116671 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 100 Esmeralda Ave 7 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82247 82247 116682 DPW Maintained 3 Pittosporum crassifolium :: Karo Tree 108 100 Esmeralda Ave 21 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
86166 86166 116675 DPW Maintained 3 Quercus agrifolia :: Coast Live Oak 180 100 Esmeralda Ave 14 Unaccepted Street : Yard 14 Tree 1 DPW 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
89602 89602 116672 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 Esmeralda Ave 9 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
92622 92622 116679 DPW Maintained 3 Yucca elephantipes :: Giant Yucca 211 100 Esmeralda Ave 18 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95360 95360 116668 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 100x Esmeralda Ave 4 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95944 95944 116681 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 100 Esmeralda Ave 20 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
97063 97063 116666 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Esmeralda Ave 2 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
110832 110832 116665 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Esmeralda Ave 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     25     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
113837 113837 116669 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 Esmeralda Ave 6 Unaccepted Street : Yard 14 Tree 1 DPW 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
123800 123800 116680 DPW Maintained 3 Dodonaea viscosa :: Hop Bush 132 100 Esmeralda Ave 19 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
126736 126736 116670 DPW Maintained 3 Quercus agrifolia :: Coast Live Oak 180 100 Esmeralda Ave 8 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127057 127057 116678 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 100 Esmeralda Ave 17 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
138825 138825 116683 DPW Maintained 3 Pittosporum crassifolium :: Karo Tree 108 100 Esmeralda Ave 22 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
143384 143384 116676 DPW Maintained 3 Aesculus californica :: California Buckeye 338 100 Esmeralda Ave 15 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
144028 144028 113477 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Esmeralda Ave 10 Unaccepted Street : Yard 14 Tree 1 DPW 2     24     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
144190 144190 116667 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 100x Esmeralda Ave 3 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)

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