Street_Tree_List

Data source: data.sfgov.org

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, 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
27884 27884 225899 Undocumented 2 Geijera parviflora :: Australian Willow 68 1398 Bryant St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6009375.43724 2107898.5512099997 37.7684168680618 -122.41086412858 (37.7684168680618, -122.41086412858)
32129 32129 225911 Undocumented 2 Geijera parviflora :: Australian Willow 68 886 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6005643.7507 2103817.72642 37.75700193611971 -122.42348155572999 (37.7570019361197, -122.42348155573)
36653 36653 225927 Undocumented 2 Geijera parviflora :: Australian Willow 68 172 Day St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6004830.8864400005 2098735.49496 37.7430013921091 -122.425930987935 (37.7430013921091, -122.425930987935)
39266 39266 225908 Undocumented 2 Geijera parviflora :: Australian Willow 68 3772 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6005343.316000001 2101393.98229 37.7503299359862 -122.424348189214 (37.7503299359862, -122.424348189214)
43658 43658 123212 Undocumented 2 Geijera parviflora :: Australian Willow 68 462 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5993143.5323 2112325.5219 37.7796486158053 -122.467330287378 (37.7796486158053, -122.467330287378)
58473 58473 225900 Undocumented 2 Geijera parviflora :: Australian Willow 68 1398 Bryant St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6009378.42208 2107868.1744 37.768333627729504 -122.410851658572 (37.7683336277295, -122.410851658572)
59849 59849 128863 Undocumented 2 Geijera parviflora :: Australian Willow 68 628 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6004545.79116 2110745.60377 37.7759621899439 -122.42777232553499 (37.7759621899439, -122.427772325535)
134868 134868 225912 Undocumented 2 Geijera parviflora :: Australian Willow 68 1048 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   6005698.159659999 2102902.03106 37.7544907204839 -122.423228299447 (37.7544907204839, -122.423228299447)
153007 153007 192422 Undocumented 2 Geijera parviflora :: Australian Willow 68 80 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   6012207.07921 2107722.19142 37.768090993327704 -122.401057281578 (37.7680909933277, -122.401057281578)
153251 153251 192405 Undocumented 2 Geijera parviflora :: Australian Willow 68 1900 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6012343.89644 2104716.4470599997 37.759845520476205 -122.40037289568899 (37.7598455204762, -122.400372895689)
159645 159645 225939 Undocumented 2 Geijera parviflora :: Australian Willow 68 1037 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6009456.84269 2103117.56685 37.75529393828 -122.410244954342 (37.75529393828, -122.410244954342)
168988 168988 192423 Undocumented 2 Geijera parviflora :: Australian Willow 68 80 Carolina St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   6012208.345290001 2107668.53767 37.76794374283679 -122.401049131921 (37.7679437428368, -122.401049131921)
171362 171362 192424 Undocumented 2 Geijera parviflora :: Australian Willow 68 80 Carolina St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   6012214.215580001 2107593.00345 37.767736670334 -122.40102351921401 (37.767736670334, -122.401023519214)
175971 175971 225905 Undocumented 2 Geijera parviflora :: Australian Willow 68 3620 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006092.03845 2100850.85024 37.7488808700704 -122.421720479039 (37.7488808700704, -122.421720479039)
183419 183419 128864 Undocumented 2 Geijera parviflora :: Australian Willow 68 628 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6004541.11924 2110775.90598 37.7760451281037 -122.42779064652599 (37.7760451281037, -122.427790646526)
184254 184254 225897 Undocumented 2 Geijera parviflora :: Australian Willow 68 2770 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6009476.04285 2103963.05006 37.7576165210915 -122.410238245413 (37.7576165210915, -122.410238245413)

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