Street_Tree_List

Data source: data.sfgov.org

6 rows where qLegalStatus = 7 and qSpecies = 54

View and edit SQL

Suggested facets: qSiteInfo, PlantType, qCaretaker

qLegalStatus

  • Property Tree · 6
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
631 251294 Property Tree 7 :: 54 7126 Geary Blvd 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
92954 97034 Property Tree 7 :: 54 195B Kiska Rd   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
98644 106968 Property Tree 7 :: 54 351 26th Ave   Back Yard : Yard 13 Tree 1 Private 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
110212 110320 Property Tree 7 :: 54 9 Imperial Aly   Back Yard : Yard 13 Landscaping 2 Private 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
125761 108576 Property Tree 7 :: 54 2479 Diamond St 1 Front Yard : Yard 7 Landscaping 2 Private 1           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338)
141787 103673 Property Tree 7 :: 54 64 Henry St   Back Yard : Yard 13 Tree 1 Private 1           6003097.0 2107420.0 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662)

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