trees

208 rows where qLegalStatus_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

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)
194396 265058 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194400 265055 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1085 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590 6009500.70465 2117396.93811 37.794504205778 -122.41110184732 (37.794504205778, -122.41110184732) 3 1 10 28857 21
194401 265056 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1085 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590 6009500.70465 2117396.93811 37.794504205778 -122.41110184732 (37.794504205778, -122.41110184732) 3 1 10 28857 21
194403 265059 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194410 265060 Section 806 (d) 5 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 48 Miraloma Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/28/2020 12:00:00 AM 3 6x6 Permit Number 782253 5994833.01253 2097558.21258 37.7391987718964 -122.46041537824 (37.7391987718964, -122.46041537824) 9 7 4 59 40
194417 265061 Section 806 (d) 5 Prunus serrulata :: Ornamental Cherry 84 48 Miraloma Dr 2 Sidewalk: Property side : Yard Tree Private 2       6x6   5994833.01253 2097558.21258 37.7391987718964 -122.46041537824 (37.7391987718964, -122.46041537824) 9 7 4 59 40
194448 265090 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 215 Montana St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 784731 5994883.78198 2089306.03852 37.7165432206381 -122.459642300713 (37.7165432206381, -122.459642300713) 9 8 6 28861 24
194494 264749 Section 806 (d) 5 Quercus suber :: Cork Oak 78 1339 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2021 12:00:00 AM 3 3x3 Permit Number 785207 5991088 2106284 37.7629413570223 -122.474000279679 (37.7629413570223, -122.474000279679) 1 8 11 56 12

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)
);