Street_Tree_List

Data source: data.sfgov.org

16 rows where DBH = 7 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
3467 123897 Undocumented 2 Pittosporum eugenioides :: Tarata 110 107 11th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992391.187940001 2114716.46428 37.7861700272505 -122.47010709580299 (37.7861700272505, -122.470107095803)
26572 132381 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1713 Taylor St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6008727.871259999 2118754.69526 37.7981889019448 -122.413872046978 (37.7981889019448, -122.413872046978)
33012 211434 Undocumented 2 Pittosporum eugenioides :: Tarata 110 910 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 1ft   5992028.493840001 2105269.75757 37.760210948307794 -122.47067358802299 (37.7602109483078, -122.470673588023)
33032 247630 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 5 Front Yard : Yard 7 Tree 1 Private 1     7     6009492.89578 2096949.07994 37.738358653736206 -122.409684901541 (37.7383586537362, -122.409684901541)
36060 132385 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   6005829.912880001 2119675.1182 37.8005529731893 -122.423965339721 (37.8005529731893, -122.423965339721)
48906 211441 DPW Maintained 3 Pittosporum eugenioides :: Tarata 110 200x Terrace Dr 27 Median : Yard 3 Tree 1 DPW 2     7     5993812.00301 2096546.48985 37.7363620454614 -122.463872125093 (37.7363620454614, -122.463872125093)
61763 132373 Undocumented 2 Pittosporum eugenioides :: Tarata 110 20 Reed St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6008208.92851 2117034.44521 37.793436363556204 -122.415545890356 (37.7934363635562, -122.415545890356)
66218 233975 Undocumented 2 Pittosporum eugenioides :: Tarata 110 3786 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001886.12679 2106432.54375 37.76396878345871 -122.43666398285299 (37.7639687834587, -122.436663982853)
133226 122244 Undocumented 2 Pittosporum eugenioides :: Tarata 110 47 Lake St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5990784.64686 2114787.2699700003 37.7862714344765 -122.475670418927 (37.7862714344765, -122.475670418927)
136421 211445 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1313 Bosworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6000197.7982 2096452.6133 37.736470213222 -122.441787089628 (37.736470213222, -122.441787089628)
147937 30820 DPW Maintained 3 Pittosporum eugenioides :: Tarata 110 151 Lippard Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/06/1995 12:00:00 AM 7   Permit Number 34679 6001842.2487 2095205.8891900002 37.7331405596841 -122.43601235390601 (37.7331405596841, -122.436012353906)
162959 132382 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1713 Taylor St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6008728.03476 2118737.75818 37.798142406100396 -122.413870282493 (37.7981424061004, -122.413870282493)
170663 178394 Undocumented 2 Pittosporum eugenioides :: Tarata 110 25 Capistrano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001248.99944 2093921.6644099997 37.7295806536223 -122.437971416359 (37.7295806536223, -122.437971416359)
172452 132380 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1680 Taylor St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6008764.121730001 2118820.69014 37.7983721433051 -122.4137512797 (37.7983721433051, -122.4137512797)
182363 178396 Undocumented 2 Pittosporum eugenioides :: Tarata 110 55 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003704.97004 2093083.05909 37.7274173910959 -122.42942109582899 (37.7274173910959, -122.429421095829)
185912 178400 Undocumented 2 Pittosporum eugenioides :: Tarata 110 802 Excelsior Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6004451.61665 2091406.41613 37.7228559442383 -122.426720588195 (37.7228559442383, -122.426720588195)

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