Street_Tree_List

Data source: data.sfgov.org

17 rows where qSpecies = 156

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1844 1844 240844 Permitted Site 1 Styphnolobium japonicum :: Chinese scholar tree 156 2512 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/1992 12:00:00 AM 11 Width 4ft Permit Number 30823 6011341.20529 2101862.92497 37.7519544137647 -122.403639957344 (37.7519544137647, -122.403639957344)
23497 23497 197737 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1950 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6015099.56152 2106307.90518 37.764368603152 -122.39095354947399 (37.764368603152, -122.390953549474)
26274 26274 197748 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1975 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015201.44705 2106465.6253 37.764807321236205 -122.390612174905 (37.7648073212362, -122.390612174905)
33087 33087 197746 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1975 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015183.75911 2106426.79652 37.7646997245393 -122.390670639842 (37.7646997245393, -122.390670639842)
36749 36749 197741 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1950 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015114.56396 2106401.37866 37.7646260934509 -122.390908193055 (37.7646260934509, -122.390908193055)
39542 39542 197743 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1975 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015167.69493 2106306.41081 37.7643682802918 -122.390717788601 (37.7643682802918, -122.390717788601)
56896 56896 197734 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1800 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015133.75646 2107117.4975400004 37.766593464749 -122.390891863179 (37.766593464749, -122.390891863179)
61567 61567 197744 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1975 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015167.557580001 2106323.79258 37.764415999235794 -122.39071947842699 (37.7644159992358, -122.390719478427)
67749 67749 197736 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1800 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015134.507999999 2107075.04349 37.766476936898705 -122.390886296359 (37.7664769368987, -122.390886296359)
74828 74828 197742 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1950 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015122.9218 2106424.48754 37.7646900091555 -122.390880900439 (37.7646900091555, -122.390880900439)
137607 137607 197735 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1800 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015134.28315 2107098.29667 37.766540772577294 -122.390888699377 (37.7665407725773, -122.390888699377)
152801 152801 197747 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1975 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015191.97429 2106445.31898 37.7647510389611 -122.390643519901 (37.7647510389611, -122.390643519901)
156921 156921 197739 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1950 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015103.59693 2106351.60043 37.7644888047255 -122.390942646108 (37.7644888047255, -122.390942646108)
179809 179809 197738 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1950 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015098.87065 2106329.98343 37.764429186891796 -122.390957482206 (37.7644291868918, -122.390957482206)
183470 183470 197745 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1975 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015176.56394 2106407.0773 37.764645180658704 -122.390694148136 (37.7646451806587, -122.390694148136)
185703 185703 197740 Undocumented 2 Styphnolobium japonicum :: Chinese scholar tree 156 1950 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015109.43195 2106376.23025 37.764556756626206 -122.39092418570299 (37.7645567566262, -122.390924185703)
186885 186885 66156 Permitted Site 1 Styphnolobium japonicum :: Chinese scholar tree 156 1751 Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/04/1990 12:00:00 AM 13   Permit Number 29227 6013871.1718 2094957.56097 37.7331347302712 -122.394407446159 (37.7331347302712, -122.394407446159)

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