Street_Tree_List

Data source: data.sfgov.org

27 rows where qSiteInfo = 2 and qSpecies = 71

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, DBH, YCoord, Latitude, Longitude, Location

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 27 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1103 1103 211013 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 500 Junipero Serra Blvd 44 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5991332.59313 2093509.69784 37.727880584217 -122.47222310103399 (37.727880584217, -122.472223101034)
4769 4769 194422 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 199X Kissling St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     52 Width 5ft   6007901.53326 2109054.5781799997 37.771508291196 -122.41604412194401 (37.771508291196, -122.416044121944)
39232 39232 132164 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 150 Lombard St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   6011515.19186 2120799.8495099996 37.8039605395195 -122.404371067467 (37.8039605395195, -122.404371067467)
40111 40111 178175 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5989026.35056 2089515.5020599999 37.7167797908382 -122.47990357931002 (37.7167797908382, -122.47990357931)
47480 47480 194424 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 132 Kissling St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 5ft   6007931.050980001 2109095.29996 37.77162176316789 -122.41594490245599 (37.7716217631679, -122.415944902456)
56811 56811 178172 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988133.68649 2089845.1312099998 37.7176329668754 -122.483013187625 (37.7176329668754, -122.483013187625)
61627 61627 211032 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 297 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5993259.54182 2099680.27875 37.7449347888095 -122.46600984507799 (37.7449347888095, -122.466009845078)
65528 65528 132163 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 150 Lombard St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   6011528.08163 2120803.5748799997 37.8039714887622 -122.40432672370399 (37.8039714887622, -122.404326723704)
65779 65779 194426 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 132 Kissling St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 5ft   6007946.83693 2109121.1094299997 37.77169351738029 -122.415892125715 (37.7716935173803, -122.415892125715)
80132 80132 105261 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 619 GONZALEZ DR   Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5988914.8 2089258.8 37.716068469533205 -122.48027037241002 (37.7160684695332, -122.48027037241)
80939 80939 114377 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 842X GONZALEZ DR 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302)
92410 92410 98278 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 900 Brotherhood Way 500 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.48041912379101 (37.7146559434524, -122.480419123791)
96125 96125 114371 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 821 GONZALEZ DR 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061)
104763 104763 105268 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 842X GONZALEZ DR 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302)
110779 110779 98279 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 900 Brotherhood Way 501 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.48041912379101 (37.7146559434524, -122.480419123791)
119505 119505 114372 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 821 GONZALEZ DR 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061)
120617 120617 114370 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 821 GONZALEZ DR 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061)
125758 125758 114378 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 842X GONZALEZ DR 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302)
127115 127115 178176 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325)
132856 132856 178174 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988358.3694 2089791.63303 37.717499145949 -122.48223265254101 (37.717499145949, -122.482232652541)
135899 135899 211034 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 417 Dewey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   5995115.077769999 2100328.51022 37.746821542199996 -122.45964072765 (37.7468215422, -122.45964072765)
155635 155635 194423 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 132 Kissling St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 5ft   6007917.867000001 2109077.33792 37.771571702413 -122.41598923453002 (37.771571702413, -122.41598923453)
157213 157213 211033 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 417 Dewey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5995123.84893 2100332.4468799997 37.746832855650396 -122.459610683101 (37.7468328556504, -122.459610683101)
159159 159159 178170 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Serrano Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     5989035.58475 2090454.3423900001 37.719358148051796 -122.479940326497 (37.7193581480518, -122.479940326497)
169232 169232 178173 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364)
175007 175007 194425 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 132 Kissling St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   6007938.01013 2109107.31213 37.771655137004 -122.41592168104799 (37.771655137004, -122.415921681048)
184043 184043 178171 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 0 Gonzalez Dr 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988123.04078 2089845.83927 37.71763429155529 -122.483050036443 (37.7176342915553, -122.483050036443)

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