Street_Tree_List

Data source: data.sfgov.org

29 rows where PlotSize = "Width 10ft" and qSpecies = 86

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 10ft · 19 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
65477 65477 196046 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017076.84536 2097020.9862799998 37.7389781652152 -122.383468058608 (37.7389781652152, -122.383468058608)
65821 65821 196027 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   6017034.20589 2097061.6668900002 37.739087509266604 -122.383618319135 (37.7390875092666, -122.383618319135)
69044 69044 196048 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 10ft   6017086.8639400005 2097032.1625700002 37.7390094067689 -122.383434196434 (37.7390094067689, -122.383434196434)
73353 73353 196047 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 10ft   6017083.0987599995 2097027.5652 37.7389965752218 -122.383446894874 (37.7389965752218, -122.383446894874)
74651 74651 196034 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 10ft   6017038.2356199995 2096967.92235 37.738830328350794 -122.38359786136002 (37.7388303283508, -122.38359786136)
102782 102782 196025 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 10ft   6017042.181609999 2097072.1185299999 37.7391166482065 -122.38359146989201 (37.7391166482065, -122.383591469892)
146435 146435 196026 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 10ft   6017039.21913 2097067.45785 37.7391036871735 -122.383601388517 (37.7391036871735, -122.383601388517)
147185 147185 196028 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   6017030.6363699995 2097056.65947 37.7390735625998 -122.383630312507 (37.7390735625998, -122.383630312507)
148840 148840 196044 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   6017074.4672 2097014.32935 37.7389597551859 -122.38347581797701 (37.7389597551859, -122.383475817977)
149400 149400 196040 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6017061.14337 2096999.0636099998 37.738917102131204 -122.383520823632 (37.7389171021312, -122.383520823632)
150116 150116 196042 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   6017068.02223 2097008.3641400002 37.7389430197102 -122.383497686772 (37.7389430197102, -122.383497686772)
152860 152860 196043 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   6017069.89025 2097009.95172 37.7389474821301 -122.38349133844801 (37.7389474821301, -122.383491338448)
155952 155952 196030 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   6017023.70578 2097046.84349 37.739046226814 -122.38365359234601 (37.739046226814, -122.383653592346)
162017 162017 196037 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017049.14343 2096982.7375599998 37.7388716108342 -122.383561177999 (37.7388716108342, -122.383561177999)
166201 166201 196038 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017052.09274 2096987.35134 37.7388844423585 -122.38355130167 (37.7388844423585, -122.38355130167)
168448 168448 196039 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 10ft   6017058.78761 2096996.2330599998 37.7389091998064 -122.38352877183998 (37.7389091998064, -122.38352877184)
172242 172242 234908 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 10ft   6009679.550530001 2096368.23252 37.73677422993671 -122.408998565949 (37.7367742299367, -122.408998565949)
187036 187036 196032 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   6017018.892530001 2097040.8451099999 37.7390294904202 -122.383669817022 (37.7390294904202, -122.383669817022)
188309 188309 234896 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 10ft   6007240.7393 2101963.9408299997 37.7520018736867 -122.41782715109501 (37.7520018736867, -122.417827151095)

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