Street_Tree_List

Data source: data.sfgov.org

12 rows where PlotSize = "Width 0ft", SiteOrder = 2 and qSpecies = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSiteInfo, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26432 26432 141346 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 463 BRODERICK ST 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   6001145.1037 2110334.7664 37.774641176317104 -122.439506706044 (37.7746411763171, -122.439506706044)
29223 29223 183217 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3150 Rivera St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983341.801 2100199.14 37.7457822914528 -122.50034138058201 (37.7457822914528, -122.500341380582)
31223 31223 184437 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2115 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5982295.3096 2100678.1438 37.7470360206297 -122.50399540910401 (37.7470360206297, -122.503995409104)
40074 40074 181349 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2254 29th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5987333.026000001 2099936.24 37.745293905616705 -122.48652117681601 (37.7452939056167, -122.486521176816)
50906 50906 200055 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800 Lane St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014871.4407 2094140.9637 37.7309480732984 -122.390892168964 (37.7309480732984, -122.390892168964)
54123 54123 140855 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 621 Euclid Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5996425.9427 2113796.2189 37.7838757026194 -122.45608143549101 (37.7838757026194, -122.456081435491)
130949 130949 181350 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2270 25th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5988575.9018 2099879.6972 37.745211025577895 -122.48221942866999 (37.7452110255779, -122.48221942867)
149259 149259 181332 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1458 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5988697.9248 2105396.3508 37.760365379214605 -122.482201591019 (37.7603653792146, -122.482201591019)
153152 153152 141053 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 196 PARKER AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5996969.9558 2113061.6744 37.781890048327206 -122.45414629097999 (37.7818900483272, -122.45414629098)
173420 173420 184400 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2087 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5982288.7103 2100911.824 37.747677253327 -122.504035534429 (37.747677253327, -122.504035534429)
185994 185994 181319 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1283 22nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5989233.7879 2106609.7025 37.7637280687606 -122.48043712751101 (37.7637280687606, -122.480437127511)
188758 188758 217581 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 500 Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5992611.7697 2088555.8456 37.714352460703104 -122.467440914144 (37.7143524607031, -122.467440914144)

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