Street_Tree_List

Data source: data.sfgov.org

4 rows where SiteOrder = 5 and qSpecies = 137

View and edit SQL

Suggested facets: qSiteInfo

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
41473 220751 Undocumented 2 Brugmansia spp :: Angel trumpet 137 121 Montcalm St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6010324.2816 2099838.28761 37.7463383463405 -122.407013950129 (37.7463383463405, -122.407013950129)
54204 175575 Undocumented 2 Brugmansia spp :: Angel trumpet 137 120 Farragut Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   5997380.39092 2087342.89408 37.711296126994206 -122.45087135113701 (37.7112961269942, -122.450871351137)
136820 205642 Undocumented 2 Brugmansia spp :: Angel trumpet 137 1209 Capitol Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5995030.50949 2091927.98963 37.7237509099679 -122.459324908227 (37.7237509099679, -122.459324908227)
177677 220748 Undocumented 2 Brugmansia spp :: Angel trumpet 137 2498 Harrison St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008830.89382 2103969.50732 37.757598067002 -122.41246989777001 (37.757598067002, -122.41246989777)

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