Street_Tree_List

Data source: data.sfgov.org

12 rows where PlotSize = "Width 4ft", qSiteInfo = 4 and qSpecies = 60

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
38225 38225 189444 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 201 Mendell St 7 : 4 Tree 1 Private 1     18 Width 4ft   6017009.92172 2098163.28563 37.7421109895326 -122.383778964147 (37.7421109895326, -122.383778964147)
45014 45014 189429 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2100 23rd St 1 : 4 Tree 1 Private 1     10 Width 4ft   6012179.482000001 2102842.19969 37.7546900794894 -122.40080985110001 (37.7546900794894, -122.4008098511)
52497 52497 189438 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 301 Mendell St 10 : 4 Tree 1 Private 1     16 Width 4ft   6016944.89383 2097963.47475 37.7415587545458 -122.383989901933 (37.7415587545458, -122.383989901933)
57860 57860 189448 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 151 Mendell St 5 : 4 Tree 1 Private 1     27 Width 4ft   6017089.46767 2098534.02953 37.7431333739056 -122.383529720639 (37.7431333739056, -122.383529720639)
69226 69226 189412 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1088 Rhode Island St 1 : 4 Tree 1 Private 1     15 Width 4ft   6011892.64219 2103317.4691 37.755979061610105 -122.401835232927 (37.7559790616101, -122.401835232927)
75074 75074 245825 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2 McCoppin St 2 : 4 Tree 1 Private 1     18 Width 4ft   6006460.60937 2109175.25024 37.7717585077816 -122.421036933125 (37.7717585077816, -122.421036933125)
75086 75086 189437 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 301 Mendell St 9 : 4 Tree 1 Private 1     13 Width 4ft   6016936.32054 2097949.4923099997 37.7415198876289 -122.384018572307 (37.7415198876289, -122.384018572307)
131898 131898 189410 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 501 Rhode Island St 1 : 4 Tree 1 Private 1     19 Width 4ft   6011803.92975 2106016.10898 37.7633839768015 -122.40233176930401 (37.7633839768015, -122.402331769304)
151898 151898 245826 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2 McCoppin St 3 : 4 Tree 1 Private 1     33 Width 4ft   6006425.97269 2109173.2697 37.7717511171398 -122.421156603211 (37.7717511171398, -122.421156603211)
155518 155518 245827 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2 McCoppin St 4 : 4 Tree 1 Private 1     19 Width 4ft   6006397.79792 2109170.0802700003 37.77174077135871 -122.421253835213 (37.7717407713587, -122.421253835213)
156059 156059 189442 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 201 Mendell St 5 : 4 Tree 1 Private 1     18 Width 4ft   6016996.79512 2098099.65565 37.741935548886104 -122.38381992286502 (37.7419355488861, -122.383819922865)
170188 170188 189446 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 175 Mendell St 3 : 4 Tree 1 Private 1     28 Width 4ft   6017051.6761 2098373.0405099997 37.7426892419063 -122.383649189252 (37.7426892419063, -122.383649189252)

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