Street_Tree_List

Data source: data.sfgov.org

11 rows where DBH = 1 and qSpecies = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
33936 33936 207369 DPW Maintained 3 Ligustrum japonicum :: Japanese Privet 4 501x Ortega St 6 Median : Cutout 11 Tree 1 DPW 2     1 Width 2ft   5992541.8863 2103083.6869900003 37.7542382439023 -122.468738948444 (37.7542382439023, -122.468738948444)
48397 48397 35353 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 1023 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/2013 12:00:00 AM 1   Permit Number 770231 6011656.23225 2103580.2473299997 37.7566873964196 -122.40267130024999 (37.7566873964196, -122.40267130025)
66325 66325 249500 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1765 California St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6005972.54693 2115883.04317 37.7901489421804 -122.42320206534401 (37.7901489421804, -122.423202065344)
133672 133672 249499 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1765 California St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6005919.33859 2115875.5653 37.7901254069127 -122.423385630445 (37.7901254069127, -122.423385630445)
138207 138207 123058 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 500 Funston Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991916.77661 2111982.4939599996 37.778635859363206 -122.471549122693 (37.7786358593632, -122.471549122693)
159256 159256 249501 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1765 California St 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6006000.97948 2115886.86804 37.790161048840794 -122.42310396280001 (37.7901610488408, -122.4231039628)
164863 164863 129537 DPW Maintained 3 Ligustrum japonicum :: Japanese Privet 4 1306x Montgomery St 22 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011446.5417 2119990.51434 37.801734466528 -122.404551630663 (37.801734466528, -122.404551630663)
168981 168981 123060 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 500 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991917.4637 2111957.21563 37.7785664917216 -122.47154490330601 (37.7785664917216, -122.471544903306)
170003 170003 123059 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 500 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991916.7341 2111968.89129 37.7785985076866 -122.47154827826901 (37.7785985076866, -122.471548278269)
180697 180697 129556 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 216 Post St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6011025.30596 2115257.2463 37.7887145046082 -122.405675728365 (37.7887145046082, -122.405675728365)
182512 182512 129555 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 216 Post St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6011031.64459 2115258.30549 37.7887177673445 -122.40565387214599 (37.7887177673445, -122.405653872146)

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