trees

12 rows where Police Districts = 7 and qSpecies_id = 182

✎ View and edit SQL

This data as json, CSV (advanced)

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)
65605 248250 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 100 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006838.53158 2098969.7693 37.7437579135047 -122.419005697381 (37.7437579135047, -122.419005697381) 2 7 7 28859 2
80607 98485 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
87491 98483 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
110866 246820 DPW Maintained 1 Gleditsia triacanthos :: Honey Locust 182 198 Brewster St 2 Sidewalk: Property side : Yard Tree Private 2     2     6010060.69624 2098737.22367 37.7433003114761 -122.407847772774 (37.7433003114761, -122.407847772774) 2 7 7 28859 2
119773 36542 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 190 Gates St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39415 6008260.22671845 2097736.01770388 37.7404502589313 -122.414002536769 (37.7404502589313, -122.414002536769) 2 7 7 28859 2
120084 41701 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 34 Natick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42151 6003036.29664011 2095600.66365718 37.734292282497 -122.431912391757 (37.734292282497, -122.431912391757) 2 7 5 63 7
145228 173889 Significant Tree 6 Gleditsia triacanthos :: Honey Locust 182 190 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779949 6010824 2099939 37.7466428319545 -122.405293064953 (37.7466428319545, -122.405293064953) 2 7 7 28859 2
172228 98475 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
180790 98479 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
181260 98481 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
190499 98487 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 531X Franconia St 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
193640 55969 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 35 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2000 12:00:00 AM     Permit Number 770524 6007464.012592 2099914.14210495 37.7463861516938 -122.416909822502 (37.7463861516938, -122.416909822502) 2 7 7 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)
);