Street_Tree_List

Data source: data.sfgov.org

16 rows where PlotSize = "Width 6ft" and qSpecies = 103

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 6ft · 16 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29038 29038 208963 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 6ft   5993939.166669999 2096822.57013 37.7371274206966 -122.463452499655 (37.7371274206966, -122.463452499655)
36761 36761 208976 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Yerba Buena Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   5994151.01662 2096664.6627200001 37.7367060496466 -122.462708592139 (37.7367060496466, -122.462708592139)
44792 44792 208974 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 130 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 6ft   5994229.97779 2096604.2011400003 37.7365445844613 -122.462431207033 (37.7365445844613, -122.462431207033)
47668 47668 208973 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 136 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 6ft   5994259.725980001 2096572.0955299998 37.7364581434207 -122.46232602774799 (37.7364581434207, -122.462326027748)
52363 52363 208968 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 34 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993576.11533 2097077.3704400002 37.737806114757795 -122.46472622025298 (37.7378061147578, -122.464726220253)
65175 65175 208929 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798)
66396 66396 208966 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 44 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     44 Width 6ft   5993666.080159999 2097016.89785 37.7376452584166 -122.46441078125099 (37.7376452584166, -122.464410781251)
75990 75990 208962 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 6ft   5993970.2453 2096804.3744 37.7370792503013 -122.463343727552 (37.7370792503013, -122.463343727552)
114900 114900 208965 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 56 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   5993745.43898 2096960.72106 37.7374955851482 -122.464132325055 (37.7374955851482, -122.464132325055)
154505 154505 208971 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 150 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 6ft   5994318.90627 2096521.2556599998 37.736321957275706 -122.462117732164 (37.7363219572757, -122.462117732164)
156141 156141 208964 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 60 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 6ft   5993779.53053 2096936.1958400002 37.737430209820296 -122.46401267564801 (37.7374302098203, -122.464012675648)
160755 160755 208975 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Yerba Buena Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 6ft   5994177.11325 2096643.32557 37.7366489660835 -122.462616818123 (37.7366489660835, -122.462616818123)
164085 164085 208969 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 30 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 6ft   5993545.78483 2097101.19005 37.737869768775795 -122.46483281598302 (37.7378697687758, -122.464832815983)
187171 187171 208972 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 136 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 6ft   5994281.63654 2096550.25213 37.7363994284866 -122.462248690521 (37.7363994284866, -122.462248690521)
188184 188184 208970 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 20 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 6ft   5993484.40904 2097144.7715200002 37.7379858937365 -122.46504818472499 (37.7379858937365, -122.465048184725)
188785 188785 208967 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 44 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993630.4889400005 2097044.9006700001 37.737720095508706 -122.46453586883001 (37.7377200955087, -122.46453586883)

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