Street_Tree_List

Data source: data.sfgov.org

13 rows where qSiteInfo = 23 and qSpecies = 41

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • : Yard · 13 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
32348 32348 233229 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 2 : Yard 23 Tree 1 Private 1     5 Width 3ft   6010110.29265 2099690.9553400003 37.745921827136996 -122.407743515268 (37.745921827137, -122.407743515268)
38615 38615 177876 Undocumented 2 Olea europaea :: Olive Tree 41 4117 San Bruno Ave 1 : Yard 23 Tree 1 Private 1     37 Width 10ft   6011467.53014 2087476.31968 37.7124588649577 -122.40219173226299 (37.7124588649577, -122.402191732263)
40295 40295 233234 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 7 : Yard 23 Tree 1 Private 1     4 Width 3ft   6010136.86006 2099655.53222 37.7458260502241 -122.40764915121099 (37.7458260502241, -122.407649151211)
70403 70403 233232 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 5 : Yard 23 Tree 1 Private 1     10 Width 3ft   6010129.8045 2099669.06085 37.7458628019252 -122.407674502171 (37.7458628019252, -122.407674502171)
75041 75041 194131 Undocumented 2 Olea europaea :: Olive Tree 41 1310 Indiana St 4 : Yard 23 Tree 1 Private 1     37     6014985.85621 2102536.5970099997 37.754007092062004 -122.391083210127 (37.754007092062, -122.391083210127)
76157 76157 233604 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 10 : Yard 23 Tree 1 Private 1     3 Width 3ft   6010160.0797 2099615.7154599996 37.7457180218657 -122.40756605383301 (37.7457180218657, -122.407566053833)
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)
152462 152462 233605 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 12 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010122.88511 2099649.32748 37.745808231063705 -122.407697037414 (37.7458082310637, -122.407697037414)
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)
156957 156957 233233 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 6 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010125.251569999 2099665.5030400003 37.745852778088 -122.407689994823 (37.745852778088, -122.407689994823)
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)
173331 173331 233230 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 3 : Yard 23 Tree 1 Private 1     5 Width 3ft   6010120.38838 2099686.6934 37.745910689944104 -122.407708305 (37.7459106899441, -122.407708305)

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