Street_Tree_List

Data source: data.sfgov.org

6 rows where qSpecies = 347

View and edit SQL

Suggested facets: qAddress, SiteOrder, qSiteInfo

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25490 225139 Undocumented 2 Chamaecyparis species :: 347 701 Church St 41 Front Yard : Yard 7 Tree 1 Private 1     13     6004346.6017 2104631.68872 37.759163584356706 -122.428025590809 (37.7591635843567, -122.428025590809)
33728 123881 Undocumented 2 Chamaecyparis species :: 347 50 Loraine Ct 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   5996189.27707 2112301.17631 37.7797571256007 -122.456792042067 (37.7797571256007, -122.456792042067)
65092 225138 Undocumented 2 Chamaecyparis species :: 347 701 Church St 40 Front Yard : Yard 7 Tree 1 Private 1     10     6004343.21577 2104606.16981 37.759093323917796 -122.428035482463 (37.7590933239178, -122.428035482463)
68614 120485 Undocumented 2 Chamaecyparis species :: 347 2315 Lake St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   5988245.85859 2114625.01959 37.7856784318046 -122.484441955632 (37.7856784318046, -122.484441955632)
72069 225140 Undocumented 2 Chamaecyparis species :: 347 701 Church St 42 Front Yard : Yard 7 Tree 1 Private 1     24     6004343.37266 2104649.92765 37.759213481447794 -122.428038058114 (37.7592134814478, -122.428038058114)
169547 185067 Undocumented 2 Chamaecyparis species :: 347 2835 34th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 0ft   5985849.5929 2096173.2953 37.734875280779704 -122.491373660397 (37.7348752807797, -122.491373660397)

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