Street_Tree_List

Data source: data.sfgov.org

16 rows where PlotSize = "Width 3ft" and qSpecies = 116

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27359 27359 240611 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 255 Jersey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003497.9531 2101542.75011 37.750634040826796 -122.43074019171699 (37.7506340408268, -122.430740191717)
33291 33291 240614 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 3637 22nd St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003933.5831699995 2103025.57629 37.7547302045579 -122.429339475147 (37.7547302045579, -122.429339475147)
45421 45421 240621 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 219 Upper Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     52 Width 3ft   5999599.462169999 2106267.78648 37.7633861864367 -122.444561006196 (37.7633861864367, -122.444561006196)
50051 50051 120239 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 288 24th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5988397.09206 2114077.36637 37.784183536793705 -122.483878566436 (37.7841835367937, -122.483878566436)
58796 58796 240619 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 104 Saturn St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6000003.92034 2105982.96119 37.762627197305605 -122.443141663776 (37.7626271973056, -122.443141663776)
64230 64230 118443 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 5201 Anza St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5982458.0361 2111659.95745 37.7771985159381 -122.504246101222 (37.7771985159381, -122.504246101222)
74195 74195 240615 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 297 Cumberland St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   6003715.872169999 2104475.4119700002 37.75869878143 -122.430195805998 (37.75869878143, -122.430195805998)
74221 74221 215021 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2624 14th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   5992112.26225 2097456.03758 37.7387613350595 -122.469814985494 (37.7387613350595, -122.469814985494)
147227 147227 240599 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 3229 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   6006780.56286 2103771.69804 37.75693965177221 -122.41954675558 (37.7569396517722, -122.41954675558)
148759 148759 119951 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 300 28th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 3ft   5987162.07649 2113890.44215 37.783598323431 -122.488137483705 (37.783598323431, -122.488137483705)
149664 149664 240613 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 3637 22nd St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6003938.94874 2103022.28304 37.754721465836894 -122.42932068472 (37.7547214658369, -122.42932068472)
164767 164767 240612 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 3637 22nd St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6003932.88521 2103022.72642 37.7547223399723 -122.429341685671 (37.7547223399723, -122.429341685671)
167940 167940 240620 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 272 Corbett Ave 3 Side Yard : Yard 17 Tree 1 Private 1     21 Width 3ft   5999634.90147 2105345.61253 37.7608561480145 -122.44437215754401 (37.7608561480145, -122.444372157544)
176415 176415 118442 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 5201 Anza St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5982468.47607 2111659.73383 37.777198515931794 -122.504209970081 (37.7771985159318, -122.504209970081)
178655 178655 197579 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 428 08th St 1 : 4 Tree 1 Private 1     3 Width 3ft   6010214.98706 2109650.78059 37.773275125388 -122.408083778259 (37.773275125388, -122.408083778259)
180000 180000 240618 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 69 Levant St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     27 Width 3ft   6000370.536280001 2106394.5334900003 37.7637781703576 -122.441903216369 (37.7637781703576, -122.441903216369)

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