Street_Tree_List

Data source: data.sfgov.org

18 rows where search matches "cherry" and qSiteInfo = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

qSiteInfo ✖

  • : Yard · 18 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29380 29380 196093 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 01st St 25 : Yard 23 Tree 1 Private 1     8     6014406.1146599995 2105887.9731 37.763177058994 -122.39332261913601 (37.763177058994, -122.393322619136)
30029 30029 196074 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 7 : Yard 23 Tree 1 Private 1     8     6014974.36324 2102149.68411 37.7529440736099 -122.391095913948 (37.7529440736099, -122.391095913948)
31996 31996 237002 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 11 : Yard 23 Tree 1 Private 1     12 Width 3ft   6010115.457330001 2099644.6115099997 37.745794866235 -122.40772238927 (37.745794866235, -122.40772238927)
33649 33649 196072 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 4 : Yard 23 Tree 1 Private 1     6     6014990.91174 2102121.65719 37.7528680359305 -122.391036726872 (37.7528680359305, -122.391036726872)
37053 37053 218147 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 33 Ashton Ave 1 : Yard 23 Tree 1 Private 1     8     5994130.90264 2090096.18725 37.7186694580143 -122.462301880921 (37.7186694580143, -122.462301880921)
37555 37555 237003 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 14 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010106.165469999 2099668.32603 37.7458594609566 -122.40775619120001 (37.7458594609566, -122.4077561912)
37605 37605 237004 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 15 : Yard 23 Tree 1 Private 1     8 Width 3ft   6010095.49496 2099684.36191 37.7459028946219 -122.40779421904101 (37.7459028946219, -122.407794219041)
66873 66873 196280 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 11 : Yard 23 Tree 1 Private 1     12     6015022.69172 2102195.1938 37.7530717153135 -122.39093196394501 (37.7530717153135, -122.390931963945)
74692 74692 196073 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 5 : Yard 23 Tree 1 Private 1     9     6014983.580569999 2102134.9117099997 37.752904023218605 -122.391063005979 (37.7529040232186, -122.391063005979)
130300 130300 196281 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 12 : Yard 23 Tree 1 Private 1     12     6015018.372359999 2102200.19302 37.7530852024401 -122.39094725063102 (37.7530852024401, -122.390947250631)
130498 130498 196075 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 17 : Yard 23 Tree 1 Private 1     6     6014963.469190001 2102214.24517 37.753120740043705 -122.391138100256 (37.7531207400437, -122.391138100256)
132015 132015 196092 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 01st St 24 : Yard 23 Tree 1 Private 1     10     6014425.82588 2105887.0502299997 37.7631756200823 -122.393254379501 (37.7631756200823, -122.393254379501)
132022 132022 196279 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 6 : Yard 23 Tree 1 Private 1     5     6014984.46572 2102135.07494 37.7529045205317 -122.39105995634701 (37.7529045205317, -122.391059956347)
133863 133863 196076 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 18 : Yard 23 Tree 1 Private 1     6     6014971.87416 2102223.03647 37.753145345506795 -122.39110964840401 (37.7531453455068, -122.391109648404)
137606 137606 196282 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 13 : Yard 23 Tree 1 Private 1     12     6015015.25562 2102205.64875 37.75310000977571 -122.39095841029499 (37.7531000097757, -122.390958410295)
151585 151585 196077 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 19 : Yard 23 Tree 1 Private 1     6     6014960.28506 2102234.79181 37.7531769800583 -122.391150547759 (37.7531769800583, -122.391150547759)
152443 152443 196094 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 01st St 26 : Yard 23 Tree 1 Private 1     8     6014400.8809 2105882.83985 37.7631626734333 -122.393340361863 (37.7631626734333, -122.393340361863)
154821 154821 237005 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 16 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010090.49979 2099699.0653 37.7459429872721 -122.40781252834101 (37.7459429872721, -122.407812528341)

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