Street_Tree_List

Data source: data.sfgov.org

21 rows where PlotSize = "Width 3ft" and qSpecies = 78

✎ View and edit SQL

This data as json, CSV (advanced)

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

PlotSize ✖

  • Width 3ft · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4930 4930 197650 DPW Maintained 3 Quercus ilex :: Holly Oak 78 351 Cargo Way 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/03/2017 10:31:00 AM 3 Width 3ft   6017512.77369 2098485.85809 37.7430244920913 -122.38206267634399 (37.7430244920913, -122.382062676344)
4937 4937 203013 DPW Maintained 3 Quercus ilex :: Holly Oak 78 351 Cargo Way 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/07/1996 12:00:00 AM 2 Width 3ft   6017575.06427 2098435.51559 37.742889701702794 -122.381843789478 (37.7428897017028, -122.381843789478)
4938 4938 203012 DPW Maintained 3 Quercus ilex :: Holly Oak 78 351 Cargo Way 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:41:00 AM 3 Width 3ft   6017482.43996 2098513.81637 37.743099584575795 -122.382169507733 (37.7430995845758, -122.382169507733)
5047 5047 197215 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6017388.82526 2098597.46987 37.743324109317 -122.38249902473 (37.743324109317, -122.38249902473)
5060 5060 197214 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6017373.601009999 2098611.9970400003 37.743363156981104 -122.382552677381 (37.7433631569811, -122.382552677381)
35082 35082 214006 DPW Maintained 3 Quercus ilex :: Holly Oak 78 200x Lawton St 1 Median : Cutout 11 Tree 1 DPW 2     4 Width 3ft   5993658.67007 2104606.16817 37.7584830376791 -122.464987428342 (37.7584830376791, -122.464987428342)
35223 35223 197213 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 4 : 4 Tree 1 Private 1     3 Width 3ft   6017295.11492 2098681.7702099998 37.74355040393579 -122.382828919425 (37.7435504039358, -122.382828919425)
45802 45802 240331 Undocumented 2 Quercus ilex :: Holly Oak 78 60 Sharon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6003844.61217 2106805.37047 37.7651035803891 -122.42991676164499 (37.7651035803891, -122.429916761645)
46884 46884 119232 Undocumented 2 Quercus ilex :: Holly Oak 78 4333 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5982116.59434 2110285.8700900003 37.773405587282 -122.505325367756 (37.773405587282, -122.505325367756)
55323 55323 214007 DPW Maintained 3 Quercus ilex :: Holly Oak 78 100x Lawton St 1 Median : Cutout 11 Tree 1 DPW 2     4 Width 3ft   5993739.83569 2104610.7544299997 37.7585003100564 -122.464707056595 (37.7585003100564, -122.464707056595)
58085 58085 197219 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 20 : 4 Tree 1 Private 1     4 Width 3ft   6017546.94281 2098457.41264 37.7429482736446 -122.38194254943599 (37.7429482736446, -122.381942549436)
72978 72978 117659 Undocumented 2 Quercus ilex :: Holly Oak 78 5048 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5982955.71016 2111732.11037 37.777425883386705 -122.502529858177 (37.7774258833867, -122.502529858177)
136158 136158 197211 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 1 : 4 Tree 1 Private 1     8 Width 3ft   6017250.2855 2098720.3657 37.7436539023979 -122.382986615562 (37.7436539023979, -122.382986615562)
136839 136839 240332 Undocumented 2 Quercus ilex :: Holly Oak 78 60 Sharon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6003844.27978 2106789.2546 37.765059311271294 -122.429916761647 (37.7650593112713, -122.429916761647)
147091 147091 122175 Undocumented 2 Quercus ilex :: Holly Oak 78 200 14th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5991544.95469 2113582.84567 37.7830084672106 -122.47295211599199 (37.7830084672106, -122.472952115992)
152030 152030 197217 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 12 : 4 Tree 1 Private 1     6 Width 3ft   6017418.77475 2098570.88696 37.7432527723975 -122.382393616971 (37.7432527723975, -122.382393616971)
155446 155446 122173 Undocumented 2 Quercus ilex :: Holly Oak 78 200 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5991547.68728 2113548.29768 37.7829137661673 -122.472940142363 (37.7829137661673, -122.472940142363)
156588 156588 197216 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 11 : 4 Tree 1 Private 1     3 Width 3ft   6017405.29347 2098583.32775 37.7432861876121 -122.38244109758499 (37.7432861876121, -122.382441097585)
161598 161598 117655 Undocumented 2 Quercus ilex :: Holly Oak 78 4945 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5983271.78514 2111690.7442400004 37.7773308720147 -122.501433407785 (37.7773308720147, -122.501433407785)
164348 164348 197218 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 13 : 4 Tree 1 Private 1     3 Width 3ft   6017435.50351 2098556.05574 37.743212972902704 -122.38233474108101 (37.7432129729027, -122.382334741081)
171037 171037 197212 Undocumented 2 Quercus ilex :: Holly Oak 78 351 Cargo Way 2 : 4 Tree 1 Private 1     4 Width 3ft   6017263.91913 2098709.4149599997 37.74362458719779 -122.38293871135099 (37.7436245871978, -122.382938711351)

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