Street_Tree_List

Data source: data.sfgov.org

17 rows where PlotSize = "Width 4ft" and qSpecies = 168

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 4ft · 17 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25462 25462 250940 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 237 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5987097.72783 2114420.3103099996 37.7850494354169 -122.488399056469 (37.7850494354169, -122.488399056469)
29398 29398 212839 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 310 Orizaba Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 4ft   5994040.72446 2088804.9905 37.7151189471444 -122.46251998093 (37.7151189471444, -122.46251998093)
35036 35036 212841 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 310 Orizaba Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   5994040.99289 2088811.375 37.7151364929198 -122.46251951595801 (37.7151364929198, -122.462519515958)
46924 46924 212844 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 310 Orizaba Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 4ft   5994040.98422 2088821.4693599998 37.7151642091297 -122.462520277695 (37.7151642091297, -122.462520277695)
53633 53633 250941 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 237 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987099.00691 2114408.0109900003 37.785015739640606 -122.48839372709699 (37.7850157396406, -122.488393727097)
60963 60963 212843 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 310 Orizaba Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5994040.90601 2088817.74043 37.7151539658718 -122.46252027770001 (37.7151539658718, -122.4625202777)
63346 63346 234845 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 452 Oak St 2 : 4 Tree 1 Private 1     8 Width 4ft   6004779.43654 2110228.96496 37.7745568400539 -122.426927281183 (37.7745568400539, -122.426927281183)
64254 64254 212842 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 310 Orizaba Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   5994041.05729 2088814.44589 37.715144928561294 -122.462519515984 (37.7151449285613, -122.462519515984)
69116 69116 250942 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 237 28th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5987099.1476 2114396.50261 37.7849841491372 -122.48839239429199 (37.7849841491372, -122.488392394292)
72379 72379 250724 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2701 Lake St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5987063.6250599995 2114433.2112 37.7850828677123 -122.488517988217 (37.7850828677123, -122.488517988217)
125568 125568 250943 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 237 28th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5987098.9521 2114387.30266 37.784958877305 -122.488392394293 (37.784958877305, -122.488392394293)
132650 132650 212840 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 310 Orizaba Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   5994040.889169999 2088808.5139 37.7151286310473 -122.462519667047 (37.7151286310473, -122.462519667047)
136460 136460 250723 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2701 Lake St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987051.3666 2114432.8618400004 37.7850811931768 -122.48856037238501 (37.7850811931768, -122.488560372385)
157808 157808 234844 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 471 Oak St 1 : 4 Tree 1 Private 1     5 Width 4ft   6004727.493290001 2110160.10241 37.7743648231001 -122.427102057227 (37.7743648231001, -122.427102057227)
159891 159891 234861 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 60 Zircon Pl 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   6002321.72608 2098705.6175700002 37.7427772324719 -122.434604832164 (37.7427772324719, -122.434604832164)
166626 166626 250938 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 239 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5987099.7017 2114350.08641 37.7848567358866 -122.48838706491101 (37.7848567358866, -122.488387064911)
174475 174475 250944 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 237 28th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987098.95404 2114369.2776099998 37.784909385797796 -122.48839106242501 (37.7849093857978, -122.488391062425)

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