Street_Tree_List

Data source: data.sfgov.org

11 rows where DBH = 8 and qSpecies = 109

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
44886 44886 221418 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005666.2176 2103986.40391 37.757466353200996 -122.423415847665 (37.757466353201, -122.423415847665)
47639 47639 221528 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005788.731319999 2101828.76193 37.7515488824818 -122.422838806667 (37.7515488824818, -122.422838806667)
51201 51201 221569 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 616 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003001.08037 2104529.5167 37.7588068286936 -122.432671745707 (37.7588068286936, -122.432671745707)
54972 54972 221524 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005795.8556 2101693.96335 37.7511791585977 -122.42280459107401 (37.7511791585977, -122.422804591074)
61658 61658 221543 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005707.0284 2103306.91954 37.7556029507207 -122.42322640818999 (37.7556029507207, -122.42322640819)
73212 73212 221514 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005830.22915 2101083.18072 37.7495040291878 -122.42264232458 (37.7495040291878, -122.42264232458)
73681 73681 221526 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005792.85635 2101748.62489 37.7513290773756 -122.42281884712601 (37.7513290773756, -122.422818847126)
149575 149575 221542 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005709.18006 2103278.9471400003 37.7555262664424 -122.423216978787 (37.7555262664424, -122.423216978787)
159464 159464 221532 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005770.103999999 2102168.30473 37.7524801376575 -122.42292735211201 (37.7524801376575, -122.422927352112)
161335 161335 201715 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 726 Jamestown Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6015296.606380001 2088393.85947 37.715191240972 -122.38902117888901 (37.715191240972, -122.389021178889)
188083 188083 221533 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005767.42939 2102227.70946 37.75264309841 -122.422940823082 (37.75264309841, -122.422940823082)

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