Street_Tree_List

Data source: data.sfgov.org

8 rows where PlotSize = "3X3" and qSpecies = 13

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
19097 10252 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 124 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3X3   6005490.6368 2109629.255 37.7729503696302 -122.424424432873 (37.7729503696302, -122.424424432873)
19318 10251 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 120 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3X3   6005509.0088 2109632.4226 37.7729601045446 -122.42436110718201 (37.7729601045446, -122.424361107182)
21131 16956 DPW Maintained 3 Podocarpus gracilor :: Fern Pine 13 673 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/14/1992 12:00:00 AM 6 3X3   6003823.5744 2110036.1086 37.773973209785 -122.43022003270201 (37.773973209785, -122.430220032702)
85920 107894 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 230X 11th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)
100439 107897 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 230X 11th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)
102623 107896 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 230X 11th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)
103849 107895 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 230X 11th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)
138319 107893 Permitted Site 1 Podocarpus gracilor :: Fern Pine 13 73X Kissling St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/04/2014 12:00:00 AM 3 3X3 Permit Number 770997 6008153.6101 2109447.48188 37.7726012817916 -122.41519998916999 (37.7726012817916, -122.41519998917)

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