trees

5 rows where Neighborhoods (old) = 11 and qSpecies_id = 160

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

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)
60479 124659 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 199 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 8ft   5995478.86593 2115238.56038 37.7877815776324 -122.459462441459 (37.7877815776324, -122.459462441459) 11 6 1 54 11
82936 124656 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 1 Presidio Ter 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 7ft   5995441.43994 2115441.36584 37.7883362746058 -122.459606621954 (37.7883362746058, -122.459606621954) 11 6 1 54 11
137220 124657 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 30 Presidio Ter 1 Sidewalk: Curb side : Yard Tree Private 2     30 Width 7ft   5995444.46973 2115398.79213 37.7882195529326 -122.459593054716 (37.7882195529326, -122.459593054716) 11 6 1 54 11
167307 67033 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 174 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1992 12:00:00 AM 30 5x5 Permit Number 30405 5992451.37715 2114312.24159 37.7850636224737 -122.469869417746 (37.7850636224737, -122.469869417746) 11 6 2 54 11
187379 1443 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 151X Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X5   5995492.27499 2115135.20138 37.7874985527143 -122.459408560713 (37.7874985527143, -122.459408560713) 11 6 1 54 11

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