Street_Tree_List

Data source: data.sfgov.org

23 rows where PlotSize = "Width 5ft" and qSpecies = 85

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25127 25127 200366 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1300 Phelps St 8 : 4 Tree 1 Private 1     12 Width 5ft   6014047.106269999 2096372.4575200002 37.7370295240776 -122.393898196954 (37.7370295240776, -122.393898196954)
45529 45529 200360 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1150 Phelps St 5 : 4 Tree 1 Private 1     6 Width 5ft   6014196.6239 2096573.2462900002 37.737589156904995 -122.393395290662 (37.737589156905, -122.393395290662)
46141 46141 200359 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1150 Phelps St 4 : 4 Tree 1 Private 1     9 Width 5ft   6014213.143619999 2096595.32013 37.737650684936796 -122.393339717964 (37.7376506849368, -122.393339717964)
46833 46833 227936 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 167 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 5ft   6004844.7517 2099277.52267 37.7444904598682 -122.42592162061001 (37.7444904598682, -122.42592162061)
55636 55636 129757 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 2315 Buchanan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 5ft   6003704.65718 2116456.32668 37.7915947858084 -122.431089717742 (37.7915947858084, -122.431089717742)
55664 55664 129767 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1375 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6006477.1660400005 2118669.59087 37.7978285696796 -122.421654118939 (37.7978285696796, -122.421654118939)
57768 57768 200357 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6014316.3111 2096732.3588400001 37.73803269625021 -122.392992601233 (37.7380326962502, -122.392992601233)
57963 57963 200352 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 16 : 4 Tree 1 Private 1     14 Width 5ft   6014405.80816 2096853.92235 37.7383714555731 -122.392691664697 (37.7383714555731, -122.392691664697)
63351 63351 200365 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1300 Phelps St 7 : 4 Tree 1 Private 1     6 Width 5ft   6014060.81183 2096393.5404700001 37.7370881751809 -122.39385228564801 (37.7370881751809, -122.393852285648)
70036 70036 129756 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 2315 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6003701.89513 2116476.8237099997 37.7916509089176 -122.43110073801 (37.7916509089176, -122.43110073801)
74895 74895 200358 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1150 Phelps St 3 : 4 Tree 1 Private 1     12 Width 5ft   6014239.8641 2096632.70057 37.7377548084229 -122.393249946754 (37.7377548084229, -122.393249946754)
112760 112760 200367 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1300 Phelps St 9 : 4 Tree 1 Private 1     17 Width 5ft   6014030.85339 2096351.6806400002 37.7369715717905 -122.393952936896 (37.7369715717905, -122.393952936896)
133126 133126 200353 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 17 : 4 Tree 1 Private 1     11 Width 5ft   6014392.43301 2096834.63166 37.738317744462 -122.392736560653 (37.738317744462, -122.392736560653)
134636 134636 200355 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 19 : 4 Tree 1 Private 1     11 Width 5ft   6014345.08354 2096773.3910700001 37.7381469605042 -122.392895989784 (37.7381469605042, -122.392895989784)
135542 135542 200351 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6014421.213330001 2096874.8296 37.73842971815 -122.39263986285 (37.73842971815, -122.39263986285)
136918 136918 200356 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6014331.3129900005 2096752.73935 37.7380894902424 -122.39294215736601 (37.7380894902424, -122.392942157366)
157215 157215 200364 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1300 Phelps St 6 : 4 Tree 1 Private 1     13 Width 5ft   6014077.799769999 2096412.7772 37.7371419393345 -122.393794896313 (37.7371419393345, -122.393794896313)
157370 157370 129766 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1375 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6006461.42741 2118668.07402 37.797823517302206 -122.42170847129199 (37.7978235173022, -122.421708471292)
161074 161074 129768 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 489 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6011131.656690001 2118977.1984099997 37.7989345451634 -122.40556987367201 (37.7989345451634, -122.405569873672)
164517 164517 200354 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014359.7983 2096791.80766 37.7381983459865 -122.392846401168 (37.7381983459865, -122.392846401168)
167176 167176 200363 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1300 Phelps St 5 : 4 Tree 1 Private 1     8 Width 5ft   6014137.38405 2096492.6896799998 37.7373646735385 -122.393594476122 (37.7373646735385, -122.393594476122)
169282 169282 200361 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1300 Phelps St 1 : 4 Tree 1 Private 1     7 Width 5ft   6014182.02229 2096553.32448 37.7375336444497 -122.39344438196699 (37.7375336444497, -122.393444381967)
186583 186583 200362 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1300 Phelps St 3 : 4 Tree 1 Private 1     7 Width 5ft   6014166.7855 2096532.27247 37.7374749933851 -122.39349559025801 (37.7374749933851, -122.393495590258)

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