Street_Tree_List

Data source: data.sfgov.org

116 rows where qCaretaker = 2 and qSpecies = 16

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker ✖

  • DPW · 16 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
126393 126393 89073 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 574 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/03/2008 12:00:00 AM 3 3x3   5990364.51379 2111466.25843 37.77712849442079 -122.47688121138901 (37.7771284944208, -122.476881211389)
127211 127211 5818 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 959 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6000256.5254907 2099603.3351939 37.7451246954454 -122.441810105191 (37.7451246954454, -122.441810105191)
127444 127444 12766 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1816 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   5989782.53842 2114745.3914099997 37.7860983011374 -122.479134351427 (37.7860983011374, -122.479134351427)
135968 135968 139119 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1501 LAGUNA ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2005 12:00:00 AM 4 Width 0ft   6004503.5822 2114180.7007 37.7853917281698 -122.42816319919201 (37.7853917281698, -122.428163199192)
138849 138849 28652 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1600X Webster St 14 Median : Cutout 11 Tree 1 DPW 2     20 6   6003605.147696201 2114190.7261663 37.785368381567004 -122.431272227533 (37.785368381567, -122.431272227533)
141587 141587 12438 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1595X Laguna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2005 12:00:00 AM 3 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765)
142975 142975 28653 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1600X Webster St 15 Median : Cutout 11 Tree 1 DPW 2     12 6   6003605.147696201 2114190.7261663 37.785368381567004 -122.431272227533 (37.785368381567, -122.431272227533)
143219 143219 21220 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 2392X Sunset Blvd 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60   5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
145891 145891 10119 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 850 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/06/1992 12:00:00 AM 18 3X3   6005631.880167 2104012.3184419 37.757535570368 -122.423536442741 (37.757535570368, -122.423536442741)
148511 148511 212576 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100x Idora Ave 7 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995353.74805 2099410.49817 37.74431463161879 -122.458748984199 (37.7443146316188, -122.458748984199)
157716 157716 139120 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1501 LAGUNA ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 Width 0ft   6004505.7981 2114155.2180000003 37.7853218844175 -122.428153716152 (37.7853218844175, -122.428153716152)
163567 163567 212376 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 350x Kensington Way 3 Median : Cutout 11 Tree 1 DPW 2     9 Width 6ft   5994225.30573 2099058.0744 37.743282039932794 -122.462625309526 (37.7432820399328, -122.462625309526)
165194 165194 212538 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 200x Terrace Dr 38 Median : Yard 3 Tree 1 DPW 2     6     5993893.90506 2096479.6500900001 37.736183239558 -122.463584108238 (37.736183239558, -122.463584108238)
175620 175620 117840 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 600x 39th Ave 2 Median : Cutout 11 Tree 1 DPW 2     2 Width 6ft   5983808.599090001 2111637.58628 37.777216427782896 -122.499572493795 (37.7772164277829, -122.499572493795)
177543 177543 214300 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 200x Terrace Dr 42 Median : Yard 3 Tree 1 DPW 2     17     5993888.01583 2096515.6983900003 37.7362818799091 -122.46360708499701 (37.7362818799091, -122.463607084997)
187999 187999 140339 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1300x WEBSTER ST 7 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6003689.95 2113371.7397 37.7831244557567 -122.430920367043 (37.7831244557567, -122.430920367043)

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