Street_Tree_List

Data source: data.sfgov.org

46 rows where PlotSize = "Width 3ft" and qSiteInfo = 23

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 3ft · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
146754 146754 240351 Undocumented 2 Quercus suber :: Cork Oak 76 4090 20th St 1 : Yard 23 Tree 1 Private 1     22 Width 3ft   6003153.88022 2104182.56452 37.7578628454134 -122.432118516979 (37.7578628454134, -122.432118516979)
151521 151521 223316 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 1 : Yard 23 Tree 1 Private 1     3 Width 3ft   6003622.06269 2104228.7754599997 37.7580162625599 -122.430502643895 (37.7580162625599, -122.430502643895)
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)
152563 152563 234500 Undocumented 2 Pinus muricata :: Bishop Pine 302 4090 20th St 8 : Yard 23 Tree 1 Private 1     9 Width 3ft   6003098.9698 2104154.51537 37.757782715804204 -122.43230641682699 (37.7577827158042, -122.432306416827)
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)
156226 156226 223318 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 3 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003637.291809999 2104227.88023 37.75801466716629 -122.43044991126101 (37.7580146671663, -122.430449911261)
156510 156510 233334 Undocumented 2 Pinus radiata :: Monterey Pine 3 91 Stanton St 1 : Yard 23 Tree 1 Private 1     15 Width 3ft   6000284.24588 2103856.40307 37.7568041715962 -122.442019473547 (37.7568041715962, -122.442019473547)
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)
157410 157410 233500 Undocumented 2 Pistacia chinensis :: Chinese Pistache 150 4090 20th St 10 : Yard 23 Tree 1 Private 1     3 Width 3ft   6003098.24212 2104183.0577 37.7578610449587 -122.43231097188601 (37.7578610449587, -122.432310971886)
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)
164374 164374 222115 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 4090 20th St 9 : Yard 23 Tree 1 Private 1     15 Width 3ft   6003100.58415 2104168.90978 37.757822330949004 -122.432301861758 (37.757822330949, -122.432301861758)
167772 167772 245705 Undocumented 2 Cordyline australis :: Dracena Palm 141 4001 20th St 1 : Yard 23 Tree 1 Private 1     16 Width 3ft   6003616.02573 2104184.50188 37.757894355861396 -122.430520363245 (37.7578943558614, -122.430520363245)
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)
171294 171294 223319 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 4 : Yard 23 Tree 1 Private 1     3 Width 3ft   6003647.0575 2104227.27295 37.7580135529116 -122.43041609403299 (37.7580135529116, -122.430416094033)
172054 172054 222663 Undocumented 2 Ceanothus Sps :: California lilac 270 4090 20th St 2 : Yard 23 Tree 1 Private 1     9 Width 3ft   6003162.223809999 2104187.96649 37.7578781509761 -122.43209004713002 (37.7578781509761, -122.43209004713)
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)
178126 178126 224454 Undocumented 2 Eucalyptus Spp :: Eucalyptus 40 4090 20th St 6 : Yard 23 Tree 1 Private 1     12 Width 3ft   6003124.6046 2104168.08557 37.7578214298263 -122.432218730236 (37.7578214298263, -122.432218730236)
179643 179643 222664 Undocumented 2 Ceanothus Sps :: California lilac 270 4090 20th St 3 : Yard 23 Tree 1 Private 1     9 Width 3ft   6003149.42788 2104190.19818 37.7578835531891 -122.432134460156 (37.7578835531891, -122.432134460156)
186405 186405 224262 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 91 Stanton St 2 : Yard 23 Tree 1 Private 1     22 Width 3ft   6000293.691000001 2103856.2070400002 37.7568041715846 -122.44198679486 (37.7568041715846, -122.44198679486)

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