Street_Tree_List

Data source: data.sfgov.org

18 rows where qAddress = "199 Franconia St" and qSiteInfo = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, DBH

qAddress ✖

  • 199 Franconia St · 18 ✖
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)
31996 31996 237002 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 11 : Yard 23 Tree 1 Private 1     12 Width 3ft   6010115.457330001 2099644.6115099997 37.745794866235 -122.40772238927 (37.745794866235, -122.40772238927)
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)
37555 37555 237003 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 14 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010106.165469999 2099668.32603 37.7458594609566 -122.40775619120001 (37.7458594609566, -122.4077561912)
37605 37605 237004 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 15 : Yard 23 Tree 1 Private 1     8 Width 3ft   6010095.49496 2099684.36191 37.7459028946219 -122.40779421904101 (37.7459028946219, -122.407794219041)
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)
73122 73122 225894 Undocumented 2 Fremontodendron spp :: Flannel Bush Tree 331 199 Franconia St 17 : Yard 23 Tree 1 Private 1     7 Width 3ft   6010105.1921 2099680.51389 37.7458928716644 -122.407760416232 (37.7458928716644, -122.407760416232)
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)
151779 151779 241988 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 199 Franconia St 18 : Yard 23 Tree 1 Private 1     5 Width 3ft   6010085.85388 2099710.92257 37.745975284649 -122.40782942930299 (37.745975284649, -122.407829429303)
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)
154821 154821 237005 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 16 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010090.49979 2099699.0653 37.7459429872721 -122.40781252834101 (37.7459429872721, -122.407812528341)
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)
161704 161704 225066 Undocumented 2 Ceratonia siliqua :: Carob 97 199 Franconia St 13 : Yard 23 Tree 1 Private 1     5 Width 3ft   6010116.17854 2099660.00965 37.745837186534295 -122.407720980957 (37.7458371865343, -122.407720980957)
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 51.098ms · Data source: data.sfgov.org