Street_Tree_List

Data source: data.sfgov.org

15 rows where PlotSize = "Width 7ft" and qSpecies = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: DBH

PlotSize ✖

  • Width 7ft · 15 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28694 28694 246559 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 3 Median : Yard 3 Tree 1 DPW 2     6 Width 7ft   6005723.21879 2109372.62983 37.7722588698898 -122.42360165389299 (37.7722588698898, -122.423601653893)
28854 28854 246564 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 8 Median : Yard 3 Tree 1 DPW 2     9 Width 7ft   6005706.72335 2109459.01828 37.7724951406584 -122.423664856449 (37.7724951406584, -122.423664856449)
30102 30102 246567 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 11 Median : Yard 3 Tree 1 DPW 2     10 Width 7ft   6005696.09569 2109523.68249 37.7726720930872 -122.423706217176 (37.7726720930872, -122.423706217176)
32751 32751 246565 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 9 Median : Yard 3 Tree 1 DPW 2     11 Width 7ft   6005706.10974 2109468.40026 37.772520866678796 -122.423667646169 (37.7725208666788, -122.423667646169)
36823 36823 246562 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 6 Median : Yard 3 Tree 1 DPW 2     16 Width 7ft   6005708.50416 2109443.88838 37.7724536981194 -122.423657620518 (37.7724536981194, -122.423657620518)
58148 58148 246560 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 4 Median : Yard 3 Tree 1 DPW 2     5 Width 7ft   6005720.56075 2109380.70244 37.772280885298 -122.423611422347 (37.772280885298, -122.423611422347)
62755 62755 246558 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 2 Median : Yard 3 Tree 1 DPW 2     7 Width 7ft   6005725.55596 2109365.49138 37.772239401347605 -122.423593061791 (37.7722394013476, -122.423593061791)
66652 66652 246571 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 15 Median : Yard 3 Tree 1 DPW 2     10 Width 7ft   6005693.03742 2109551.27371 37.7727476792916 -122.423718758221 (37.7727476792916, -122.423718758221)
69195 69195 246561 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 5 Median : Yard 3 Tree 1 DPW 2     8 Width 7ft   6005718.25772 2109387.68034 37.7722999149342 -122.42361988494801 (37.7722999149342, -122.423619884948)
130105 130105 246569 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 13 Median : Yard 3 Tree 1 DPW 2     9 Width 7ft   6005694.6084199995 2109539.50826 37.772715462883 -122.42371248725401 (37.772715462883, -122.423712487254)
152965 152965 246568 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 12 Median : Yard 3 Tree 1 DPW 2     7 Width 7ft   6005695.27816 2109533.51475 37.7726990439551 -122.423709744321 (37.7726990439551, -122.423709744321)
159619 159619 246563 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 7 Median : Yard 3 Tree 1 DPW 2     14 Width 7ft   6005707.64026 2109451.4652299997 37.7724744535597 -122.42366114764499 (37.7724744535597, -122.423661147645)
164121 164121 246566 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 10 Median : Yard 3 Tree 1 DPW 2     9 Width 7ft   6005705.41603 2109475.54193 37.772540436826 -122.42367055365101 (37.772540436826, -122.423670553651)
171792 171792 246570 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 14 Median : Yard 3 Tree 1 DPW 2     9 Width 7ft   6005693.82305 2109545.39115 37.7727315715478 -122.423715622299 (37.7727315715478, -122.423715622299)
178229 178229 246557 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 2x Octavia St 1 Median : Yard 3 Tree 1 DPW 2     11 Width 7ft   6005728.07536 2109359.1735900003 37.7722221964256 -122.4235838977 (37.7722221964256, -122.4235838977)

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