Street_Tree_List

Data source: data.sfgov.org

14 rows where qCareAssistant = 2 and qSpecies = 41

✎ View and edit SQL

This data as json, CSV (advanced)

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

qCareAssistant ✖

  • DPW for City Agency · 14 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
12969 12969 76641 DPW Maintained 3 Olea europaea :: Olive Tree 41 148X Paris St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/08/1992 12:00:00 AM 10 3x3   6002952.722159999 2092480.7640200001 37.7257210052939 -122.43197862653 (37.7257210052939, -122.43197862653)
84790 84790 76728 DPW Maintained 3 Olea europaea :: Olive Tree 41 200X Farallones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
86703 86703 95460 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986585.7747 2111417.7398 37.77677535046679 -122.489949313769 (37.7767753504668, -122.489949313769)
87154 87154 95463 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986592.12306 2111264.12941 37.7763539505765 -122.489916052727 (37.7763539505765, -122.489916052727)
89093 89093 116527 DPW Maintained 3 Olea europaea :: Olive Tree 41 5732 GEARY BLVD 1 Sidewalk: Curb side : Yard 2 Tree 1 MTA 6 DPW for City Agency 2     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
99793 99793 98885 DPW Maintained 3 Olea europaea :: Olive Tree 41 200X Farallones St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5994871.8 2088553.5 37.714476238810704 -122.459629241673 (37.7144762388107, -122.459629241673)
107741 107741 95468 Undocumented 2 Olea europaea :: Olive Tree 41 535X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3 53267 5986556.7 2112284.6 37.7791538043677 -122.49011366804301 (37.7791538043677, -122.490113668043)
108493 108493 76768 DPW Maintained 3 Olea europaea :: Olive Tree 41 200X Farallones St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
109410 109410 76771 DPW Maintained 3 Olea europaea :: Olive Tree 41 200X Farallones St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
112829 112829 76757 DPW Maintained 3 Olea europaea :: Olive Tree 41 200X Farallones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
115273 115273 95481 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986568.37611 2111910.32722 37.778126839673 -122.490045739805 (37.778126839673, -122.490045739805)
127043 127043 95458 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986582.44659 2111474.61787 37.7769313271764 -122.48996501092199 (37.7769313271764, -122.489965010922)
127891 127891 95465 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   8 3x3   5986594.5418 2111220.3413400003 37.7762338621769 -122.489904464478 (37.7762338621769, -122.489904464478)
142922 142922 95471 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   4 3x3   5986558.17112 2112222.9767400003 37.778984690357 -122.49010404497 (37.778984690357, -122.49010404497)

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