Street_Tree_List

Data source: data.sfgov.org

5 rows where SiteOrder = 3 and qSpecies = 137

View and edit SQL

Suggested facets: qSiteInfo, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29325 220762 Undocumented 2 Brugmansia spp :: Angel trumpet 137 610 Waller St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6002755.41611 2108896.6334700002 37.7707839340556 -122.433833507015 (37.7707839340556, -122.433833507015)
42111 249852 Undocumented 2 Brugmansia spp :: Angel trumpet 137 285 Greenwich St 3 Front Yard : Yard 7 Tree 1 Private 1     7 Width 0ft   6011471.43471 2120405.6011799998 37.8028755847944 -122.404494724258 (37.8028755847944, -122.404494724258)
136160 220749 Undocumented 2 Brugmansia spp :: Angel trumpet 137 4165 23rd St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6002130.38932 2102336.43505 37.7527357357851 -122.435526104843 (37.7527357357851, -122.435526104843)
157825 125731 Undocumented 2 Brugmansia spp :: Angel trumpet 137 1590 Larkin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 3ft   6007145.64127 2116497.28043 37.791901618321 -122.41918683072399 (37.791901618321, -122.419186830724)
171621 175576 Undocumented 2 Brugmansia spp :: Angel trumpet 137 120 Farragut Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   5997371.298769999 2087352.6593099998 37.7113224195784 -122.45090347943199 (37.7113224195784, -122.450903479432)

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