Street_Tree_List

Data source: data.sfgov.org

8 rows where PlotSize = "Width 3ft", qSiteInfo = 9 and qSpecies = 48

View and edit SQL

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
44951 227560 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 84 Seward St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   6000737.03493 2104555.7602 37.758750228049294 -122.44050372379101 (37.7587502280493, -122.440503723791)
55628 227559 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 84 Seward St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   6000741.2761699995 2104538.3206 37.758702584674204 -122.44048780488001 (37.7587025846742, -122.44048780488)
63496 227556 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Seward St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6000674.34081 2104608.13246 37.7588904593411 -122.440724304978 (37.7588904593411, -122.440724304978)
68691 176904 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 68 Cambridge St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6006443.50632 2094472.10137 37.7313860651023 -122.42005248574499 (37.7313860651023, -122.420052485745)
68947 176905 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 68 Cambridge St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6006453.00873 2094472.53688 37.731387796298705 -122.420019664972 (37.7313877962987, -122.420019664972)
129668 207044 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 755 Foerster St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5998014.32968 2095894.50831 37.7348131350024 -122.44929603208 (37.7348131350024, -122.44929603208)
133941 227561 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 84 Seward St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   6000738.66154 2104570.78605 37.7587915779822 -122.44049917592 (37.7587915779822, -122.44049917592)
164734 120000 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 818 30th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5986676.70436 2110336.5469299997 37.7738120096448 -122.489555240793 (37.7738120096448, -122.489555240793)

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