trees

18 rows where Fire Prevention Districts = 4 and qSpecies_id = 160 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention 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)
58327 132127 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 5ft   6014286.02329 2117523.57721 37.7951191201157 -122.394552795494 (37.7951191201157, -122.394552795494) 4 2 10 28860 6
65491 132120 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 5ft   6014198.1938 2117703.48543 37.795608222696 -122.394869307388 (37.795608222696, -122.394869307388) 4 2 10 28860 6
87673 132123 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6014232.87879 2117626.20085 37.7953979459112 -122.394743875326 (37.7953979459112, -122.394743875326) 4 2 10 28860 6
113444 132125 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 8 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6014258.52591 2117571.02815 37.79524788055 -122.394651265852 (37.79524788055, -122.394651265852) 4 2 10 28860 6
121091 132122 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6014219.48603 2117650.76237 37.7954646414426 -122.394791937806 (37.7954646414426, -122.394791937806) 4 2 10 28860 6
153930 132118 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 5ft   6014172.89911 2117759.32578 37.7957601406829 -122.394960745056 (37.7957601406829, -122.394960745056) 4 2 10 28860 6
154796 132121 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6014209.141 2117675.2625 37.7955313378499 -122.39482945032 (37.7955313378499, -122.39482945032) 4 2 10 28860 6
165133 132124 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6014245.1809 2117597.95018 37.7953210601821 -122.394699328313 (37.7953210601821, -122.394699328313) 4 2 10 28860 6
177761 132128 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6014303.11413 2117497.5911 37.7950487184753 -122.394491837643 (37.7950487184753, -122.394491837643) 4 2 10 28860 6
192630 132119 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 5ft   6014187.59198 2117732.03905 37.795686034729 -122.394907992625 (37.795686034729, -122.394907992625) 4 2 10 28860 6
193499 132126 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 640 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6014272.27117 2117547.1339 37.7951830367225 -122.394602030674 (37.7951830367225, -122.394602030674) 4 2 10 28860 6
17161 28026 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 6 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014253.80701 2117776.67601 37.795812278914 -122.394682002417 (37.795812278914, -122.394682002417) 4 2 10 28860 6
43793 28030 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 10 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014322.16601 2117689.87001 37.7955777303512 -122.394439384649 (37.7955777303512, -122.394439384649) 4 2 10 28860 6
86437 28032 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 12 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014349.29301 2117643.21201 37.7954511263865 -122.394342251353 (37.7954511263865, -122.394342251353) 4 2 10 28860 6
111729 28027 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 7 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014263.57201 2117754.97501 37.795753235969 -122.394646693031 (37.795753235969, -122.394646693031) 4 2 10 28860 6
132193 28031 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 11 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014334.10201 2117669.25401 37.7955217871698 -122.394396639485 (37.7955217871698, -122.394396639485) 4 2 10 28860 6
187664 28029 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 9 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014304.80501 2117713.74201 37.7956423121436 -122.394501129585 (37.7956423121436, -122.394501129585) 4 2 10 28860 6
191559 28028 Permitted Site 7 Phoenix canariensis :: Canary Island Date Palm 160 100 The Embarcadero 8 Median : Cutout Tree Port 6   02/05/2001 12:00:00 AM 24 4X4   6014289.61401 2117737.61301 37.7957070117951 -122.394555365911 (37.7957070117951, -122.394555365911) 4 2 10 28860 6

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