Street_Tree_List

Data source: data.sfgov.org

16 rows where SiteOrder = 11 and qSpecies = 109

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, PlantDate, DBH, PlotSize

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4316 4316 221478 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 05:18:00 AM 1 Width 3ft   6005544.06849 2106215.1538 37.763579081143604 -122.423996776447 (37.7635790811436, -122.423996776447)
4319 4319 221466 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:17:00 AM 2 Width 3ft   6005511.21858 2106780.74139 37.7651301958204 -122.42415061986601 (37.7651301958204, -122.424150619866)
4362 4362 221445 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 10:50:00 AM 1 Width 3ft   6005479.31495 2107369.2041700003 37.7667441731271 -122.424302823815 (37.7667441731271, -122.424302823815)
4487 4487 221504 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 11:05:00 PM 2 Width 3ft   6005611.75297 2105011.45268 37.7602778227802 -122.42367708812901 (37.7602778227802, -122.423677088129)
5168 5168 152422 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005644.9376300005 2104427.7274700003 37.7586769234173 -122.423520817442 (37.7586769234173, -122.423520817442)
32093 32093 221522 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     18 Width 3ft   6005804.6365 2101559.54048 37.750810559762705 -122.42276467376999 (37.7508105597627, -122.42276467377)
68227 68227 221553 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005734.111409999 2102791.4847 37.7541892146839 -122.42309611170799 (37.7541892146839, -122.423096111708)
75610 75610 221438 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005446.19377 2108068.2932700003 37.7686618344154 -122.42446711555901 (37.7686618344154, -122.424467115559)
86005 86005 110628 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400X GUERRERO ST 11 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 05:18:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
94270 94270 110769 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 11 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:17:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
97329 97329 115520 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 10:50:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
106423 106423 109703 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 11 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 11:05:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
121580 121580 110782 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 11 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 02:21:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
150449 150449 221531 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005769.92765 2102140.767 37.7524045154572 -122.422926004956 (37.7524045154572, -122.422926004956)
179323 179323 221491 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005578.642000001 2105634.14294 37.7619857144891 -122.423835881448 (37.7619857144891, -122.423835881448)
185178 185178 221511 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005835.54562 2100976.57743 37.749211620932606 -122.422616365666 (37.7492116209326, -122.422616365666)

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