Street_Tree_List

Data source: data.sfgov.org

10 rows where qSiteInfo = 10 and qSpecies = 59

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
24601 138420 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1819 STEINER ST 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 0ft   6002521.5979 2114452.899 37.786026776312596 -122.435039736101 (37.7860267763126, -122.435039736101)
36580 142827 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1714 POLK ST 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 0ft   6006619.3625 2116773.8493 37.7926313555217 -122.421027406021 (37.7926313555217, -122.421027406021)
64396 98493 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1703 Polk St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5     6006578.8967 2116733.3834 37.7925179651008 -122.421164544764 (37.7925179651008, -122.421164544764)
68638 138418 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1819 STEINER ST 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 0ft   6002514.5891 2114496.0302 37.7861448056429 -122.435067070541 (37.7861448056429, -122.435067070541)
132506 143556 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 848 KEARNY ST 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 0ft   6011275.0549 2117918.4465 37.796035485985705 -122.40499907891301 (37.7960354859857, -122.404999078913)
167934 138421 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1819 STEINER ST 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 0ft   6002523.7545 2114441.5771 37.7859958117094 -122.435031464821 (37.7859958117094, -122.435031464821)
168674 138419 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1819 STEINER ST 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 0ft   6002518.3631 2114471.7689 37.7860784045808 -122.435052277699 (37.7860784045808, -122.435052277699)
169665 143557 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 848 KEARNY ST 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 0ft   6011271.7921 2117938.489 37.7960903354635 -122.405011780806 (37.7960903354635, -122.405011780806)
176087 137986 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1826 WEBSTER ST 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 0ft   6003453.629 2115096.2902 37.7878462437049 -122.431861119013 (37.7878462437049, -122.431861119013)
184932 142820 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1754 POLK ST 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 0ft   6006598.3556 2116937.7026 37.793080071640894 -122.42111173056101 (37.7930800716409, -122.421111730561)

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