Street_Tree_List

Data source: data.sfgov.org

22 rows where qSiteInfo = 9 and qSpecies = 131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28103 28103 247599 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 900 Tompkins Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   6009183.00439 2096409.33052 37.7368592482464 -122.410718251366 (37.7368592482464, -122.410718251366)
30801 30801 241283 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6011469.095480001 2101944.7688700003 37.7521862823701 -122.403203448894 (37.7521862823701, -122.403203448894)
34027 34027 196983 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097)
46541 46541 196984 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295)
49190 49190 241285 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6011473.17853 2101977.48291 37.752276335990004 -122.40319162999901 (37.75227633599, -122.403191629999)
56981 56981 196988 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6011818.89895 2100809.64818 37.749089017243904 -122.401913980245 (37.7490890172439, -122.401913980245)
57849 57849 241284 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6011470.02474 2101959.91095 37.752227911103894 -122.403201300403 (37.7522279111039, -122.403201300403)
58092 58092 196987 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805)
124111 124111 241288 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   6011465.27105 2102063.55943 37.7525122416483 -122.403225029932 (37.7525122416483, -122.403225029932)
131868 131868 213854 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 494 Mangels Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     5998170.4747 2095280.37565 37.7331358031646 -122.44871196830799 (37.7331358031646, -122.448711968308)
135531 135531 124090 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 601 Funston Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     5991893.39709 2111137.1044099997 37.776313297478204 -122.471568380763 (37.7763132974782, -122.471568380763)
146690 146690 241281 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6011465.9993 2101906.42682 37.7520808305785 -122.403211459137 (37.7520808305785, -122.403211459137)
149354 149354 241287 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 8ft   6011467.38591 2102056.94062 37.7524941859569 -122.403217250793 (37.7524941859569, -122.403217250793)
154968 154968 196989 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6011818.89895 2100809.64818 37.749089017243904 -122.401913980245 (37.7490890172439, -122.401913980245)
158188 158188 196985 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295)
161686 161686 241282 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6011466.587590001 2101921.66983 37.7521227174025 -122.403210496885 (37.7521227174025, -122.403210496885)
163725 163725 196982 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097)
164075 164075 241289 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 9ft   6011466.52977 2102070.65758 37.7525318019104 -122.403221176312 (37.7525318019104, -122.403221176312)
175807 175807 247600 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 900 Tompkins Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   6009197.59612 2096407.4718900002 37.7368549629719 -122.410667669902 (37.7368549629719, -122.410667669902)
186450 186450 196986 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1601 Kansas St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805)
187478 187478 247601 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 900 Tompkins Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   6009211.63365 2096404.0635900002 37.7368463915456 -122.410618895163 (37.7368463915456, -122.410618895163)
188901 188901 241286 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6011463.91629 2102032.72658 37.7524275057351 -122.403227546213 (37.7524275057351, -122.403227546213)

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