Street_Tree_List

Data source: data.sfgov.org

13 rows where DBH = 6, qLegalStatus = 1 and qSiteInfo = 11

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
86601 27299 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 7800X Geary Blvd 6 Median : Cutout 11 Tree 1 Fire Dept 11   06/10/1999 12:00:00 AM 6 5X5   5982630.17797 2112395.09735 37.779227117259296 -122.503705073784 (37.7792271172593, -122.503705073784)
92056 27295 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 7800X Geary Blvd 2 Median : Cutout 11 Tree 1 Fire Dept 11   06/10/1999 12:00:00 AM 6 5X5   5982729.47953 2112398.50568 37.779242313567295 -122.50336180684499 (37.7792423135673, -122.503361806845)
104698 27952 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 107X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
106951 27956 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 107X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
108807 27718 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 107X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   09/11/2000 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
111288 27297 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 7800X Geary Blvd 4 Median : Cutout 11 Tree 1 Fire Dept 11   06/10/1999 12:00:00 AM 6 5X5   5982680.863919999 2112396.64212 37.7792343387449 -122.50352984750401 (37.7792343387449, -122.503529847504)
114112 27296 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 7800X Geary Blvd 3 Median : Cutout 11 Tree 1 Fire Dept 11   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.7930900003 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232)
114418 27957 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 107X The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
125546 27294 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 7800X Geary Blvd 1 Median : Cutout 11 Tree 1 Fire Dept 11   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.77924621575129 -122.503283404585 (37.7792462157513, -122.503283404585)
128222 27953 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 107X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
140645 27955 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 107X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
143978 27298 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 7800X Geary Blvd 5 Median : Cutout 11 Tree 1 Fire Dept 11   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413)
145142 27954 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 107X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)

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