Street_Tree_List

Data source: data.sfgov.org

8 rows where PlotSize = "3X3" and qCaretaker = 14

View and edit SQL

Suggested facets: qSpecies, qAddress, SiteOrder, PlantDate, DBH, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
5329 19019 Permitted Site 1 Olea europaea :: Olive Tree 41 3150 Sacramento St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14     18 3X3   5999711.09845 2115422.68298 37.788529565338 -122.444833006162 (37.788529565338, -122.444833006162)
8017 19018 Permitted Site 1 Olea europaea :: Olive Tree 41 3150 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   01/19/2011 12:00:00 AM 3 3X3 Permit Number 767112 5999751.82821 2115426.62042 37.78854270082589 -122.444692371063 (37.7885427008259, -122.444692371063)
8994 19017 Permitted Site 1 Olea europaea :: Olive Tree 41 3150 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   01/19/2011 12:00:00 AM 3 3X3 Permit Number 767112 5999786.663369999 2115431.4160700003 37.7885578562165 -122.444572191968 (37.7885578562165, -122.444572191968)
18165 18592 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 345 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   11/27/2007 12:00:00 AM 3 3X3   5993019.1084 2088489.2823 37.7141932021811 -122.46602816864201 (37.7141932021811, -122.466028168642)
20996 25469 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 345 Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   03/15/2003 12:00:00 AM 3 3X3   5993035.9294 2088489.917 37.7141959153246 -122.465970075328 (37.7141959153246, -122.465970075328)
83830 15728 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 4400 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   04/20/1995 12:00:00 AM 4 3X3   6002668.688838599 2093023.5286977 37.7271952084184 -122.43299926731399 (37.7271952084184, -122.432999267314)
85067 15729 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 4400 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   04/20/1995 12:00:00 AM 6 3X3   6002668.688838599 2093023.5286977 37.7271952084184 -122.43299926731399 (37.7271952084184, -122.432999267314)
122186 15730 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 4400 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14   04/20/1995 12:00:00 AM 7 3X3   6002668.688838599 2093023.5286977 37.7271952084184 -122.43299926731399 (37.7271952084184, -122.432999267314)

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