Street_Tree_List

Data source: data.sfgov.org

16 rows where DBH = 7 and qSpecies = 109

✎ View and edit SQL

This data as json, CSV (advanced)

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

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25270 25270 221523 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005797.77147 2101666.82906 37.751104762181 -122.42279603761101 (37.751104762181, -122.422796037611)
32785 32785 221538 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005757.68157 2102409.38047 37.7531413749784 -122.422987443927 (37.7531413749784, -122.422987443927)
41002 41002 221513 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005831.83209 2101056.03846 37.7494295931996 -122.42263485302799 (37.7494295931996, -122.422634853028)
48258 48258 221518 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005823.14172 2101242.96968 37.7499423731511 -122.42267818684799 (37.7499423731511, -122.422678186848)
52769 52769 221515 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005828.19442 2101110.33186 37.7495784651962 -122.42265128992399 (37.7495784651962, -122.422651289924)
59268 59268 187787 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1650 Galvez Ave 2 Side Yard : Yard 17 Tree 1 Private 1     7     6015518.873319999 2097965.1979799997 37.7414845469671 -122.388920758811 (37.7414845469671, -122.388920758811)
65787 65787 221527 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005790.21854 2101800.81566 37.7514722323764 -122.422831677752 (37.7514722323764, -122.422831677752)
74207 74207 221519 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005822.7904900005 2101267.93468 37.7500109014944 -122.422681175305 (37.7500109014944, -122.422681175305)
153605 153605 221517 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005823.4134 2101214.1336 37.7498632112216 -122.422675198428 (37.7498632112216, -122.422675198428)
155282 155282 221421 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005663.971419999 2104121.3615 37.7578367884406 -122.42343320997499 (37.7578367884406, -122.423433209975)
155379 155379 221559 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1306 York St 4 : 4 Tree 1 Private 1     7 Width 3ft   6010039.89073 2101557.1439900002 37.7510420290671 -122.408118546954 (37.7510420290671, -122.408118546954)
163113 163113 221534 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005765.63484 2102254.12398 37.7527155253202 -122.422948906168 (37.7527155253202, -122.422948906168)
168829 168829 221544 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005705.623380001 2103333.32509 37.755675374928295 -122.423233144119 (37.7556753749283, -122.423233144119)
178254 178254 221510 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005838.80296 2100921.0233299998 37.7490592658716 -122.422601154533 (37.7490592658716, -122.422601154533)
182320 182320 221521 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005805.669319999 2101529.55059 37.7507282726947 -122.422758971142 (37.7507282726947, -122.422758971142)
182868 182868 221512 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005835.43443 2101000.02463 37.749275995297296 -122.422618416129 (37.7492759952973, -122.422618416129)

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