Street_Tree_List

Data source: data.sfgov.org

4 rows where DBH = 4 and qSpecies = 353

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27051 196337 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 1 Front Yard : Yard 7 Tree 1 Private 1     4     6015979.32592 2099953.2392599997 37.7469688106565 -122.38746731498199 (37.7469688106565, -122.387467314982)
36595 196340 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 4 Front Yard : Yard 7 Tree 1 Private 1     4 Width 8ft   6015958.58897 2099937.15281 37.7469234920398 -122.387537900079 (37.7469234920398, -122.387537900079)
51189 196345 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 34 Front Yard : Yard 7 Tree 1 Private 1     4     6015663.1317300005 2099868.27306 37.7467179933348 -122.388554766215 (37.7467179933348, -122.388554766215)
179258 196339 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 3 Front Yard : Yard 7 Tree 1 Private 1     4 Width 8ft   6015967.11689 2099936.1121799997 37.7469211070262 -122.387508338452 (37.7469211070262, -122.387508338452)

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