Street_Tree_List

Data source: data.sfgov.org

23 rows where qSiteInfo = 2 and qSpecies = 116

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
31261 31261 215028 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5993755.12546 2096561.9752 37.7364012864951 -122.464069896803 (37.7364012864951, -122.464069896803)
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)
35570 35570 240617 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 685 Sanchez St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 5ft   6003712.72581 2104261.51662 37.7581112975082 -122.43019142809099 (37.7581112975082, -122.430191428091)
38586 38586 246713 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1 Bonview St 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     6007763.89494 2099225.75212 37.7445128502976 -122.415824124379 (37.7445128502976, -122.415824124379)
39748 39748 240597 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 523 Powhattan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29     6008567.55649 2098119.2319799997 37.741519737445294 -122.412966995358 (37.7415197374453, -122.412966995358)
54404 54404 215029 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 24 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5993749.23334 2096552.6449799999 37.736375328444296 -122.464089591065 (37.7363753284443, -122.464089591065)
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)
60028 60028 215024 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5993634.34816 2096702.85203 37.7367811376468 -122.46449769711201 (37.7367811376468, -122.464497697112)
60441 60441 215023 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5993620.60867 2096711.6491200002 37.736804500228 -122.464545838734 (37.736804500228, -122.464545838734)
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)
69856 69856 136428 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 7 Kimball Pl 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 0ft   6007991.83691 2116437.43612 37.791784918695 -122.41625474228901 (37.791784918695, -122.416254742289)
135178 135178 215025 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     5993646.76934 2096691.5619299999 37.7367508538673 -122.464453932502 (37.7367508538673, -122.464453932502)
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)
154175 154175 246775 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 925 Esmeralda Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6009505.54739 2098718.43829 37.743217635879205 -122.409766015896 (37.7432176358792, -122.409766015896)
159093 159093 179494 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 861 Lisbon St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6001008.19959 2088780.1734200001 37.715449588312104 -122.43843566438998 (37.7154495883121, -122.43843566439)
164614 164614 215027 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5993761.26762 2096568.1489799998 37.7364185921533 -122.464049108976 (37.7364185921533, -122.464049108976)
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)
166697 166697 136434 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 12 Greenwich St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6012298.4076 2120549.33954 37.8033164360554 -122.401643063984 (37.8033164360554, -122.401643063984)
168319 168319 215026 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5993767.12006 2096575.58918 37.7364393583851 -122.46402941471901 (37.7364393583851, -122.464029414719)
175766 175766 215022 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 100 Terrace Dr 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5993608.12799 2096720.10438 37.7368269967784 -122.464589603347 (37.7368269967784, -122.464589603347)
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)
186205 186205 240616 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 685 Sanchez St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 5ft   6003715.87711 2104249.40994 37.758078233932096 -122.430179665856 (37.7580782339321, -122.430179665856)

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