Street_Tree_List

Data source: data.sfgov.org

17 rows where PlotSize = "Width 6ft" and qSpecies = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 6ft · 17 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23452 23452 207071 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5993749.481269999 2102344.6615 37.752278758765605 -122.464509159894 (37.7522787587656, -122.464509159894)
33222 33222 207070 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5993749.21516 2102356.41341 37.752311011160295 -122.464510933358 (37.7523110111603, -122.464510933358)
35185 35185 129454 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 855 Chestnut St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6007720.06236 2120575.53372 37.8031318169374 -122.41748848713002 (37.8031318169374, -122.41748848713)
42271 42271 207076 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994497.66006 2100431.13069 37.7470677891411 -122.461783123205 (37.7470677891411, -122.461783123205)
45787 45787 207074 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994502.2451599995 2100385.66213 37.7469432078786 -122.46176397213301 (37.7469432078786, -122.461763972133)
46195 46195 207077 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994500.88494 2100452.87217 37.74712767141 -122.461773548104 (37.74712767141, -122.461773548104)
46474 46474 129453 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 855 Chestnut St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6007720.64474 2120576.4205400003 37.8031342846895 -122.417486534671 (37.8031342846895, -122.417486534671)
49285 49285 129456 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 855 Chestnut St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   6007719.74229 2120576.43903 37.803134284681 -122.41748965894199 (37.803134284681, -122.417489658942)
65391 65391 129455 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 855 Chestnut St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6007721.09596 2120576.41129 37.8031342846798 -122.41748497255199 (37.8031342846798, -122.417484972552)
76720 76720 129452 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 855 Chestnut St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6007720.96455 2120575.51523 37.803131816931206 -122.41748536375799 (37.8031318169312, -122.417485363758)
133413 133413 250533 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 69 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5987683.92995 2115503.12844 37.7880567296852 -122.48645053678601 (37.7880567296852, -122.486450536786)
136250 136250 250532 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 79 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5987685.24066 2115481.63254 37.787997784513294 -122.486444423174 (37.7879977845133, -122.486444423174)
152638 152638 129450 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1257 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 6ft   6006338.43207 2120038.90392 37.8015805322681 -122.42223151426799 (37.8015805322681, -122.422231514268)
154095 154095 248214 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 67 Fair Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 6ft   6006956.2223 2099478.83098 37.7451623091856 -122.41863484214 (37.7451623091856, -122.41863484214)
171953 171953 207069 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 6ft   5993748.4844 2102370.47272 37.752349572298606 -122.46451448116999 (37.7523495722986, -122.46451448117)
175597 175597 207073 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5994505.45248 2100370.5542599997 37.746901910105 -122.46175178633601 (37.746901910105, -122.461751786336)
182340 182340 207075 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 230 Pacheco St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5994498.162330001 2100407.0553599996 37.7470017132656 -122.461779641027 (37.7470017132656, -122.461779641027)

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