Street_Tree_List

Data source: data.sfgov.org

16 rows where PlotSize = "Width 4ft" and qSpecies = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 4ft · 16 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
40391 40391 129467 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1331 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   6006504.317480001 2119710.78815 37.8006889650949 -122.42163415671301 (37.8006889650949, -122.421634156713)
54198 54198 129465 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1974 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6005261.30695 2116522.05783 37.791863352156 -122.425708403014 (37.791863352156, -122.425708403014)
57626 57626 129464 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1974 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6005282.18317 2116523.47353 37.7918684189526 -122.425636272008 (37.7918684189526, -122.425636272008)
69239 69239 191385 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 37 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6011271.65755 2104161.44484 37.7582617567794 -122.404042206986 (37.7582617567794, -122.404042206986)
130724 130724 227681 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 145 Alma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5997959.25406 2106183.4369900003 37.7630608557823 -122.450227846644 (37.7630608557823, -122.450227846644)
136036 136036 129466 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1974 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6005243.67184 2116520.57545 37.791858285382105 -122.425769315008 (37.7918582853821, -122.425769315008)
136406 136406 191382 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 33 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6011269.0108900005 2104184.59965 37.758325186865896 -122.404052989848 (37.7583251868659, -122.404052989848)
147326 147326 191386 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 38 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6011275.5914199995 2104157.94605 37.758252369672604 -122.40402835564899 (37.7582523696726, -122.404028355649)
152713 152713 129469 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1085 Vallejo St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   6008359.28826 2118585.88506 37.7977046844857 -122.415135501808 (37.7977046844857, -122.415135501808)
159286 159286 191372 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2220 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6011446.77315 2104664.6622599997 37.7596532625069 -122.403471980161 (37.7596532625069, -122.403471980161)
164118 164118 191384 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 35 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   6011268.81564 2104171.75859 37.7582899172605 -122.40405276143 (37.7582899172605, -122.40405276143)
169449 169449 191383 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 34 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   6011269.17641 2104180.10815 37.7583128634534 -122.404052101317 (37.7583128634534, -122.404052101317)
172179 172179 191388 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 40 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6011282.56063 2104153.62595 37.7582408970175 -122.40400394893 (37.7582408970175, -122.40400394893)
173683 173683 191381 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6011271.17001 2104191.3624299997 37.7583438765916 -122.40404599854601 (37.7583438765916, -122.404045998546)
177045 177045 191387 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 39 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   6011279.1597 2104155.2145599998 37.7582450689735 -122.40401582268801 (37.7582450689735, -122.404015822688)
179206 179206 176986 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 745 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6002864.08823 2089338.03726 37.7170867510327 -122.43206070495899 (37.7170867510327, -122.432060704959)

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