trees

7 rows where Neighborhoods (old) = 35 and qSpecies_id = 91

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: 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)
11956 72875 DPW Maintained 1 Schinus molle :: California Pepper 91 2506 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5989254.9412 2098243.205 37.7407571191622 -122.47975172868 (37.7407571191622, -122.47975172868) 1 8 3 29491 35
59190 183549 DPW Maintained 1 Schinus molle :: California Pepper 91 2593 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5989226.3762 2097721.7265 37.7393236152619 -122.479812344828 (37.7393236152619, -122.479812344828) 1 8 3 29491 35
59784 45068 DPW Maintained 1 Schinus molle :: California Pepper 91 2227 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2001 12:00:00 AM 4   Permit Number 43949 5987902.9352 2100130.6194 37.7458608246267 -122.4845648054 (37.7458608246267, -122.4845648054) 1 8 3 29491 35
76751 49937 DPW Maintained 1 Schinus molle :: California Pepper 91 2591 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2003 12:00:00 AM 4   Permit Number 46696 5988296.2269 2097703.198 37.7392186595719 -122.483026991295 (37.7392186595719, -122.483026991295) 1 8 3 29491 35
101688 50158 DPW Maintained 1 Schinus molle :: California Pepper 91 1863@ ORTEGA 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2003 12:00:00 AM 4   Permit Number 46871 5985958.4054 2102559.7986 37.7524172606528 -122.491467392102 (37.7524172606528, -122.491467392102) 1 8 3 56 35
147452 183550 DPW Maintained 1 Schinus molle :: California Pepper 91 2593 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5989227.3726 2097702.4617 37.7392707770079 -122.479807490437 (37.7392707770079, -122.479807490437) 1 8 3 29491 35
159362 68308 DPW Maintained 1 Schinus molle :: California Pepper 91 2178 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 0   Permit Number 32119 5981736.58109187 2100266.85539552 37.7458738657157 -122.505896923616 (37.7458738657157, -122.505896923616) 1 8 3 29491 35

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