trees

10 rows where qSpecies_id = 314

✎ 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)
7479 187564 DPW Maintained 1 Quercus robur :: English Oak 314 136 Alpha St 6 Sidewalk: Property side : Yard Tree Private 2     22 Width 10ft   6010919.98964 2088121.04642 37.7141985764644 -122.404129556331 (37.7141985764644, -122.404129556331) 9 7 8 309 39
16276 72905 DPW Maintained 1 Quercus robur :: English Oak 314 130 Alpha St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   30     6010919.95523 2088121.9 37.7142009182997 -122.404129735303 (37.7142009182997, -122.404129735303) 9 7 8 309 39
35795 196101 DPW Maintained 1 Quercus robur :: English Oak 314 1450 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3 Width 3ft   6012953.20684 2106619.03082 37.7651035542995 -122.398399073582 (37.7651035542995, -122.398399073582) 14 3 8 28856 20
43403 196102 DPW Maintained 1 Quercus robur :: English Oak 314 1450 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3 Width 3ft   6012934.09251 2106619.03803 37.7651025092855 -122.398465186321 (37.7651025092855, -122.398465186321) 14 3 8 28856 20
110409 240343 DPW Maintained 1 Quercus robur :: English Oak 314 1863 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004606.58052 2097868.50381 37.7406081531503 -122.426644851783 (37.7406081531503, -122.426644851783) 2 7 5 63 7
139988 196099 DPW Maintained 1 Quercus robur :: English Oak 314 1450 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3 Width 3ft   6013002.22044 2106622.98544 37.7651171430623 -122.398229823867 (37.7651171430623, -122.398229823867) 14 3 8 28856 20
145964 187563 DPW Maintained 1 Quercus robur :: English Oak 314 136 Alpha St 5 Sidewalk: Property side : Yard Tree Private 2     28 Width 10ft   6010919.60376 2088126.49253 37.7142135088197 -122.404131273144 (37.7142135088197, -122.404131273144) 9 7 8 309 39
160897 142735 DPW Maintained 1 Quercus robur :: English Oak 314 445 FRANCISCO ST 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6009218.9181 2121136.9898 37.8047576559929 -122.412341345899 (37.8047576559929, -122.412341345899) 3 1 10 308 23
177458 196103 DPW Maintained 1 Quercus robur :: English Oak 314 1450 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3 Width 3ft   6012915.68824 2106616.36575 37.765094146508 -122.398528655081 (37.765094146508, -122.398528655081) 14 3 8 28856 20
179802 142734 DPW Maintained 1 Quercus robur :: English Oak 314 445 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6009180.1294 2121131.5594 37.8047405687624 -122.412475194566 (37.8047405687624, -122.412475194566) 3 1 10 308 23

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