Street_Tree_List

Data source: data.sfgov.org

14 rows where DBH = 3, PlotSize = "Width 3ft" and qSpecies = 109

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1879 1879 221463 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   06/08/2017 12:00:00 AM 3 Width 3ft   6005505.30672 2106900.54865 37.7654588242817 -122.42417958883301 (37.7654588242817, -122.424179588833)
4381 4381 221459 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:45:00 AM 3 Width 3ft   6005495.536040001 2107056.71588 37.7658870706576 -122.424224491084 (37.7658870706576, -122.424224491084)
55100 55100 221486 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005569.00136 2105791.30468 37.7624166992856 -122.423880400579 (37.7624166992856, -122.423880400579)
66900 66900 221490 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005576.38505 2105666.63585 37.7620748049423 -122.423845997918 (37.7620748049423, -122.423845997918)
67326 67326 221557 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 15 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005743.02813 2102638.73526 37.7537703032837 -122.42305441913099 (37.7537703032837, -122.423054419131)
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)
76927 76927 221546 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005723.96055 2103030.09242 37.7548438033068 -122.423148175257 (37.7548438033068, -122.423148175257)
131374 131374 221548 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005727.072790001 2102965.9789400003 37.7546679382008 -122.42313285530899 (37.7546679382008, -122.423132855309)
135861 135861 221547 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005723.41397 2102999.7023 37.7547603282456 -122.42314790545299 (37.7547603282456, -122.423147905453)
151865 151865 221485 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005566.92978 2105826.00789 37.762511869155105 -122.42389003321101 (37.7625118691551, -122.423890033211)
169550 169550 221558 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005728.5881 2102926.2105099997 37.754558828830106 -122.423124788381 (37.7545588288301, -122.423124788381)
176544 176544 221552 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005734.10722 2102815.94179 37.754256367947704 -122.423097864468 (37.7542563679477, -122.423097864468)
180267 180267 221556 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 14 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005741.57845 2102677.06839 37.753875475376 -122.42306215689501 (37.753875475376, -122.423062156895)
184414 184414 221498 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005599.77613 2105242.7413 37.7609122108583 -122.423734955914 (37.7609122108583, -122.423734955914)

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