Street_Tree_List

Data source: data.sfgov.org

15 rows where PlotSize = "Width 4ft" and qSpecies = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 4ft · 15 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
30553 30553 240407 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 489 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6003411.63679 2096255.36709 37.7361112200507 -122.430661423705 (37.7361112200507, -122.430661423705)
40291 40291 240392 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1803 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008038.16649 2107910.1392200002 37.768373611578205 -122.415490461517 (37.7683736115782, -122.415490461517)
47391 47391 197344 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 670 Howard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6012519.5716699995 2113947.09446 37.785200579973605 -122.40041369075199 (37.7852005799736, -122.400413690752)
56127 56127 136318 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2431 Jones St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   6007955.59027 2120758.45752 37.803647329033105 -122.416686400679 (37.8036473290331, -122.416686400679)
59339 59339 197337 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 501 Amador St 8 : 4 Tree 1 Private 1     5 Width 4ft   6017571.01278 2099537.71438 37.7459158925037 -122.381934448315 (37.7459158925037, -122.381934448315)
62196 62196 240395 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 37 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6005177.74113 2096695.2803099998 37.7374190204687 -122.42458656083201 (37.7374190204687, -122.424586560832)
132552 132552 136315 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 895 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009067.06929 2119033.92208 37.7989746333364 -122.41271806751001 (37.7989746333364, -122.41271806751)
135840 135840 117962 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4340 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5985111.43248 2111810.6865 37.7777680685843 -122.495078411045 (37.7777680685843, -122.495078411045)
146955 146955 197338 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 501 Amador St 9 : 4 Tree 1 Private 1     4 Width 4ft   6017587.31479 2099538.4559 37.745918828809295 -122.381878129198 (37.7459188288093, -122.381878129198)
149302 149302 136316 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 895 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6009084.75499 2119036.14381 37.798981726274 -122.41265702602502 (37.798981726274, -122.412657026025)
149725 149725 136320 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 99 North Point St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   6010568.43745 2122006.8054400003 37.8072215900736 -122.40773254351801 (37.8072215900736, -122.407732543518)
165341 165341 136319 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 99 North Point St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   6010537.589980001 2122003.14861 37.8072098224406 -122.40783904035901 (37.8072098224406, -122.407839040359)
181218 181218 247182 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 21 Buena Vista Ave East 1 : 4 Tree 1 Private 1     5 Width 4ft   6001135.9574 2108807.3946 37.770446875354295 -122.439428836098 (37.7704468753543, -122.439428836098)
183385 183385 197342 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 670 Howard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6012547.8789099995 2113973.86639 37.785275667977 -122.400317636871 (37.785275667977, -122.400317636871)
188741 188741 197343 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 670 Howard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6012532.19574 2113959.45979 37.7852352362655 -122.40037088392799 (37.7852352362655, -122.400370883928)

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