Street_Tree_List

Data source: data.sfgov.org

14 rows where PlotSize = "Width 5ft" and qSpecies = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 5ft · 14 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
38034 38034 188335 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1490 19th St 2 : 4 Tree 1 Private 1     12 Width 5ft   6013335.43042 2105239.42727 37.761336752 -122.396980309397 (37.761336752, -122.396980309397)
64408 64408 188294 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1582 12th St 2 : 4 Tree 1 Private 1     12 Width 5ft   6008162.78535 2108877.84718 37.771037714636705 -122.415127922313 (37.7710377146367, -122.415127922313)
67719 67719 222596 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 73 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   6002296.29369 2096683.33913 37.73722308157 -122.43454820456002 (37.73722308157, -122.43454820456)
68710 68710 188336 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1490 19th St 3 : 4 Tree 1 Private 1     11 Width 5ft   6013315.97127 2105238.81397 37.7613339848017 -122.39704756789101 (37.7613339848017, -122.397047567891)
74635 74635 188296 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1582 12th St 4 : 4 Tree 1 Private 1     13 Width 5ft   6008131.8967699995 2108889.4185900004 37.7710677511061 -122.41523558646601 (37.7710677511061, -122.415235586466)
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)
135399 135399 221340 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1370 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   6003881.33957 2100275.34472 37.747175754559706 -122.42932404278099 (37.7471757545597, -122.429324042781)
146750 146750 188337 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1578 Newhall St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6014186.2862599995 2095457.7275599998 37.7345255974821 -122.393352991941 (37.7345255974821, -122.393352991941)
150539 150539 188297 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1582 12th St 5 : 4 Tree 1 Private 1     7 Width 5ft   6008118.01492 2108896.99552 37.771087775398705 -122.415284140848 (37.7710877753987, -122.415284140848)
161999 161999 218270 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1456 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   5992782.12061 2097251.65776 37.73823885594471 -122.46748409202 (37.7382388559447, -122.46748409202)
174395 174395 188293 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1582 12th St 1 : 4 Tree 1 Private 1     19 Width 5ft   6008175.899180001 2108871.2472900003 37.771020329842294 -122.415082093787 (37.7710203298423, -122.415082093787)
175317 175317 188295 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1582 12th St 3 : 4 Tree 1 Private 1     26 Width 5ft   6008148.21893 2108881.79172 37.771047726812604 -122.41517858743799 (37.7710477268126, -122.415178587438)
180450 180450 218271 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1456 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   5992773.33281 2097243.56743 37.738216134576795 -122.467513887457 (37.7382161345768, -122.467513887457)
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)

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