Street_Tree_List

Data source: data.sfgov.org

16 rows where DBH = 2 and qSpecies = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
5700 5700 107235 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 786 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6008834.66692 2115296.44284 37.788699385205796 -122.413257820814 (37.7886993852058, -122.413257820814)
28362 28362 222576 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 471 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003000.71138 2105505.41806 37.7614863982993 -122.432742735495 (37.7614863982993, -122.432742735495)
28542 28542 204628 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1901 Monterey Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5992344.57273 2095377.42888 37.733067423224 -122.46886055298701 (37.733067423224, -122.468860552987)
30793 30793 141963 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 841 LAGUNA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6004850.8791 2111736.5633 37.7787003755045 -122.42678753375401 (37.7787003755045, -122.426787533754)
46851 46851 125887 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 277 Willow St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6006289.37196 2113344.7288599997 37.7831972322057 -122.42192548758301 (37.7831972322057, -122.421925487583)
61227 61227 140862 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 100 Jordan Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5996243.3642 2113769.3144 37.783791348572706 -122.456711139169 (37.7837913485727, -122.456711139169)
67938 67938 204649 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 508 Orizaba Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5994044.084530001 2090032.62859 37.7184899416364 -122.46259736577 (37.7184899416364, -122.46259736577)
134983 134983 222556 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 54 Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007284.70429 2099159.83714 37.7443049117519 -122.41747640203 (37.7443049117519, -122.41747640203)
135094 135094 125879 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 2 Emerson St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 5ft   5998729.9299099995 2113444.41319 37.7830417124478 -122.448085187582 (37.7830417124478, -122.448085187582)
149455 149455 188292 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 40 Sheridan St 4 : 4 Tree 1 Private 1     2 Width 3ft   6009353.5292 2109489.65006 37.772784427403 -122.411052306329 (37.772784427403, -122.411052306329)
149741 149741 78348 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 741 30th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2000 12:00:00 AM 2     5986606.5677 2110833.2599299997 37.7751717483754 -122.489834389598 (37.7751717483754, -122.489834389598)
168676 168676 185068 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Crestlake Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5989159.6219 2096046.6038 37.7347202832405 -122.47992059791001 (37.7347202832405, -122.47992059791)
175136 175136 222559 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 30 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007511.95053 2099199.57172 37.7444267977493 -122.416693445056 (37.7444267977493, -122.416693445056)
180337 180337 181742 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1219 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5986119.9697 2106920.2395 37.7643992701936 -122.491229569586 (37.7643992701936, -122.491229569586)
181394 181394 125880 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 2 Emerson St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 5ft   5998726.98974 2113474.62388 37.783124495049 -122.448097535281 (37.783124495049, -122.448097535281)
188719 188719 53084 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 737 8TH & 9TH Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/26/2006 12:00:00 AM 2   Permit Number 49051 6009184.03674 2110393.9636 37.7752579542298 -122.411702510768 (37.7752579542298, -122.411702510768)

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