trees

9 rows where Zip Codes = 56 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Zip Codes

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)
25989 101973 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1695 21st Ave 1 Sidewalk: Property side : Cutout Tree Private 2       4x4 Permit Number 769633 5989621.7 2103844.4 37.7561578263999 -122.478893204843 (37.7561578263999, -122.478893204843) 1 8 3 56 35
85795 215323 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1222 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5993013.20867 2107124.46318 37.7653603763971 -122.467402823005 (37.7653603763971, -122.467402823005) 11 8 11 56 12
94688 215286 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1642 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5992803.42046 2104269.10188 37.757508190571 -122.467920721889 (37.757508190571, -122.467920721889) 1 8 4 56 12
112978 215283 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1448 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   5993067.04344 2105615.39 37.7612199660593 -122.467106895686 (37.7612199660593, -122.467106895686) 1 8 4 56 12
129935 215324 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1288 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   5993647.63812 2106753.81902 37.764379290687 -122.465181573075 (37.764379290687, -122.465181573075) 11 8 11 56 12
136982 215322 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1546 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993091.78936 2104948.86266 37.7593912846005 -122.466972852608 (37.7593912846005, -122.466972852608) 1 8 4 56 12
152699 215321 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1546 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5993089.7363 2104935.14056 37.7593534887954 -122.466978955425 (37.7593534887954, -122.466978955425) 1 8 4 56 12
183558 215284 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1442 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993065.75738 2105645.52263 37.7613026281332 -122.467113534456 (37.7613026281332, -122.467113534456) 1 8 4 56 12
192633 215285 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1536 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993707.75608 2105010.81191 37.7595969145732 -122.464847054052 (37.7595969145732, -122.464847054052) 1 8 4 56 12

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