Street_Tree_List

Data source: data.sfgov.org

15 rows where DBH = 8 and qSpecies = 110

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
21025 28135 DPW Maintained 3 Pittosporum eugenioides :: Tarata 110 412 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 3X4   6006927.15214 2097902.80661 37.740833262445996 -122.418623621291 (37.740833262446, -122.418623621291)
44666 211448 Undocumented 2 Pittosporum eugenioides :: Tarata 110 4140 19th Ave 2 : 4 Tree 1 Private 1     8 Width 3ft   5992076.26551 2088333.24605 37.7137103255345 -122.46927561890101 (37.7137103255345, -122.469275618901)
45134 132383 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1713 Taylor St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6008731.67478 2118716.1773200002 37.7980833548266 -122.41385615953301 (37.7980833548266, -122.413856159533)
48017 178395 Undocumented 2 Pittosporum eugenioides :: Tarata 110 61 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003678.4559 2093041.21797 37.727301003537505 -122.429509772582 (37.7273010035375, -122.429509772582)
62614 178399 Undocumented 2 Pittosporum eugenioides :: Tarata 110 339 Athens St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 2ft   6004188.88481 2091298.12563 37.7225437445683 -122.42762108566002 (37.7225437445683, -122.42762108566)
89513 132372 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6008211.08199 2117028.50784 37.793420182046 -122.41553801857401 (37.793420182046, -122.415538018574)
130704 132394 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2833 Larkin St 5 Side Yard : Yard 17 Tree 1 Private 1     8     6006476.08021 2120921.35396 37.804011278359205 -122.42181790617599 (37.8040112783592, -122.421817906176)
160795 211447 Undocumented 2 Pittosporum eugenioides :: Tarata 110 4140 19th Ave 1 : 4 Tree 1 Private 1     8 Width 3ft   5992076.98829 2088316.96105 37.7136656526261 -122.46927193614599 (37.7136656526261, -122.469271936146)
163158 132375 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6008208.36982 2117045.10307 37.793465596010996 -122.41554857839701 (37.793465596011, -122.415548578397)
174727 120791 Undocumented 2 Pittosporum eugenioides :: Tarata 110 539 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5989368.66682 2111666.19394 37.7776196433358 -122.48034075829901 (37.7776196433358, -122.480340758299)
174774 247626 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 1 Front Yard : Yard 7 Tree 1 Private 1     8     6009494.96271 2096975.4044400002 37.7384310509429 -122.40967961262501 (37.7384310509429, -122.409679612625)
176993 132379 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1680 Taylor St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6008770.01559 2118776.57909 37.7982513562644 -122.41372776333401 (37.7982513562644, -122.413727763334)
179658 211444 Undocumented 2 Pittosporum eugenioides :: Tarata 110 230 Terrace Walk 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5993933.81499 2096496.4597200002 37.7362316941337 -122.46344734382299 (37.7362316941337, -122.463447343823)
183127 132384 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6005841.24215 2119667.51872 37.80053274655629 -122.4239255951 (37.8005327465563, -122.4239255951)
184440 247639 Undocumented 2 Pittosporum eugenioides :: Tarata 110 360 Bradford St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 8ft   6009456.29127 2096556.43991 37.7372784977969 -122.409783755028 (37.7372784977969, -122.409783755028)

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