Street_Tree_List

Data source: data.sfgov.org

10 rows where qSiteInfo = 7 and qSpecies = 353

View and edit SQL

Suggested facets: qAddress, DBH

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)
68337 196343 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 31 Front Yard : Yard 7 Tree 1 Private 1     18     6015689.423719999 2099879.91957 37.7467514292439 -122.388464663129 (37.7467514292439, -122.388464663129)
70989 196341 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 10 Front Yard : Yard 7 Tree 1 Private 1     5     6015838.55119 2099899.27486 37.7468128376585 -122.387950340845 (37.7468128376585, -122.387950340845)
131586 196344 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 33 Front Yard : Yard 7 Tree 1 Private 1     5     6015666.28786 2099877.42762 37.7467433047611 -122.38854449143801 (37.7467433047611, -122.388544491438)
161815 196342 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 13 Front Yard : Yard 7 Tree 1 Private 1     5     6015828.19689 2099862.61894 37.7467116144672 -122.38798358786501 (37.7467116144672, -122.387983587865)
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)
186723 196338 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 602 Arthur Ave 2 Front Yard : Yard 7 Tree 1 Private 1     2     6015971.97004 2099951.82403 37.7469645173129 -122.387492652478 (37.7469645173129, -122.387492652478)
187204 237951 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 200 Eugenia Ave 5 Front Yard : Yard 7 Tree 1 Private 1     1     6006574.718780001 2098103.54318 37.7413645918137 -122.419856447043 (37.7413645918137, -122.419856447043)

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