16 rows where Police Districts = "" and qSpecies_id = 63 sorted by qSpecies_id

View and edit SQL

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)
954 20324 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2047 20346 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 32 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
3556 20340 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     48 40                      
5800 98837 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 9 Sidewalk: Property side : Yard Tree DPW 1                              
5956 98839 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 4 Sidewalk: Property side : Yard Tree DPW 1                              
7308 20330 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
7987 20066 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 100 STAIRWAY54 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 15ST                      
8061 20397 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 262X Sunset Blvd 42 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
8532 19778 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 100 STAIRWAY18 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
9886 20336 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1                              
10520 20335 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
12952 20300 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
13465 20460 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 495X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
14475 20345 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree DPW 1     42 40                      
16263 20326 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      

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