Street_Tree_List

Data source: data.sfgov.org

4 rows where DBH = 17 and qSpecies = 110

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
57273 233963 Undocumented 2 Pittosporum eugenioides :: Tarata 110 16 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   5998658.62775 2106938.30224 37.7651735242683 -122.447863309551 (37.7651735242683, -122.447863309551)
64368 249601 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2200 Golden Gate Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   5998898.09787 2111497.4092 37.777705355751294 -122.447363215433 (37.7777053557513, -122.447363215433)
72084 132393 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2833 Larkin St 4 Side Yard : Yard 17 Tree 1 Private 1     17     6006475.56322 2120927.38496 37.8040278087899 -122.42182012391001 (37.8040278087899, -122.42182012391)
188984 132403 Undocumented 2 Pittosporum eugenioides :: Tarata 110 93 MacOndray Ln 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6008160.59399 2119098.20458 37.799100218256704 -122.415859337341 (37.7991002182567, -122.415859337341)

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