trees

8 rows where PlotSize = "Width 10ft" and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 10ft · 8 ✖
rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
20238 197904 DPW Maintained 1 Taxus baccata :: Irish Yew 86 654 Minnesota St 7 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   6015148.99162 2105385.9246 37.761839786886 -122.390718148347 (37.761839786886, -122.390718148347) 10 3 8 28856 29
23212 179853 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   5998760.78346 2089904.78247 37.7184094145512 -122.446284557804 (37.7184094145512, -122.446284557804) 9 7 6 28861 25
26893 241069 DPW Maintained 1 Taxus baccata :: Irish Yew 86 415 Collingwood St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 10ft   6002146.1874 2103426.00537 37.7557283324003 -122.435549412575 (37.7557283324003, -122.435549412575) 2 4 5 28862 22
81813 241070 DPW Maintained 1 Taxus baccata :: Irish Yew 86 415 Collingwood St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6002148.82258 2103426.21289 37.7557290518693 -122.43554031414 (37.7557290518693, -122.43554031414) 2 4 5 28862 22
114841 179851 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 10ft   5998773.25514 2089930.66617 37.718481197523 -122.44624330948 (37.718481197523, -122.44624330948) 9 7 6 28861 25
125098 179852 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 10ft   5998768.26163 2089920.0752 37.7184518319668 -122.446259808467 (37.7184518319668, -122.446259808467) 9 7 6 28861 25
149332 179850 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   5998778.24395 2089941.01946 37.7185099101936 -122.446226809638 (37.7185099101936, -122.446226809638) 9 7 6 28861 25
157281 197905 DPW Maintained 1 Taxus baccata :: Irish Yew 86 654 Minnesota St 11 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   6015150.56239 2105371.17571 37.7617993767681 -122.390711684909 (37.7617993767681, -122.390711684909) 10 3 8 28856 29

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);