6 rows where qSpecies_id = 46

View and edit SQL

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)
92 260521 DPW Maintained 1 Leucodendron argenteum :: Silver Tree 46 3519x Kirkham St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
5209 260520 DPW Maintained 1 Leucodendron argenteum :: Silver Tree 46 3519x Kirkham St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
8530 260519 DPW Maintained 1 Leucodendron argenteum :: Silver Tree 46 3519x Kirkham St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
15224 264691 Significant Tree 6 Leucodendron argenteum :: Silver Tree 46 1560 Plymouth Ave 1 Front Yard : Yard Tree Private 2       10x10   5995798 2094356 37.730461740667 -122.45684736471 (37.730461740667, -122.45684736471) 9 7 4 28861 40
132956 207364 DPW Maintained 1 Leucodendron argenteum :: Silver Tree 46 1937 17th Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5990925.3128 2102192.11895 37.7516967094532 -122.474264353419 (37.7516967094532, -122.474264353419) 1 8 4 29491 12
139961 226632 DPW Maintained 1 Leucodendron argenteum :: Silver Tree 46 116 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 7ft   6006177.69412 2099475.66722 37.745109760015 -122.421326638028 (37.745109760015, -122.421326638028) 2 7 5 28859 2

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