Street_Tree_List

Data source: data.sfgov.org

9 rows where qCaretaker = 3 and qSpecies = 25

View and edit SQL

Suggested facets: qAddress, SiteOrder, PlantDate, DBH, PlotSize, 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
3190 9537 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1100X Golden Gate Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   05/14/1992 12:00:00 AM 3 3X3   6004100.4915 2112210.9093 37.779960357201205 -122.429417251502 (37.7799603572012, -122.429417251502)
7831 9536 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1100X Golden Gate Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   10/14/1994 12:00:00 AM 3 3X3   6004118.455 2112215.6365 37.779974353933 -122.42935544491999 (37.779974353933, -122.42935544492)
8608 9533 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1100X Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     6 3X3   6004176.1272 2112221.7819 37.7799944925987 -122.429156369266 (37.7799944925987, -122.429156369266)
14374 26131 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1500 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     12 3x3   6015558.456 2095125.3192 37.7336890117673 -122.388585707606 (37.7336890117673, -122.388585707606)
15206 26133 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1504 Oakdale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     18 5x5   6015522.1816 2095153.8991 37.7337654760523 -122.388713114387 (37.7337654760523, -122.388713114387)
19927 10223 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1377X Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     12 3X3   6005871.04446 2100967.56548 37.7491888788632 -122.42249296966999 (37.7491888788632, -122.42249296967)
88492 5486 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 700X Dolores St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   04/28/2008 12:00:00 AM 12 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
95365 5484 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 700X Dolores St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     35 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166)
139901 9540 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1100X Golden Gate Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   10/14/1994 12:00:00 AM 3 3X3   6004321.7721315995 2112240.3684222 37.7800537702914 -122.428653843346 (37.7800537702914, -122.428653843346)

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