trees

16 rows where Police Districts = "" and qSpecies_id = 25

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Police Districts

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)
1940 43017 Permitted Site 7 Geijera parviflora :: Australian Willow 25   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
2319 34069 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
3439 43015 Permitted Site 7 Geijera parviflora :: Australian Willow 25   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
5259 45154 Permitted Site 7 Geijera parviflora :: Australian Willow 25 1683 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2001 12:00:00 AM     Permit Number 44007                    
5523 38232 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
6572 34068 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
6767 38234 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
7060 38233 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
7097 34072 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
7436 43016 Permitted Site 7 Geijera parviflora :: Australian Willow 25   4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
9043 43018 Permitted Site 7 Geijera parviflora :: Australian Willow 25   3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
9398 264655 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 1099 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/08/2020 04:53:00 PM   3x3                      
12809 38231 Permitted Site 7 Geijera parviflora :: Australian Willow 25 0 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM     Permit Number 40352                    
14576 34071 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
16742 34070 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
17098 34067 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    

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