trees

9 rows where Neighborhoods (old) = 3 and qSpecies_id = 151

✎ 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)
28265 231979 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 478 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002951.2565 2105388.22536 37.7611618104807 -122.43290540667 (37.7611618104807, -122.43290540667) 15 4 5 28862 3
45973 231978 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 3813 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004168.45878 2105381.57202 37.7612125052624 -122.428695150486 (37.7612125052624, -122.428695150486) 2 4 5 28862 3
64919 65535 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 3811 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1996 12:00:00 AM     Permit Number 28426 6004188.15426377 2105377.14964975 37.7612014771427 -122.428626716937 (37.7612014771427, -122.428626716937) 2 4 5 28862 3
105022 231981 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 91 Clover Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6000469.66557 2104934.36895 37.7597745666642 -122.441455575241 (37.7597745666642, -122.441455575241) 2 4 5 28862 3
124678 231980 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 48 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002629.60405 2105594.78534 37.7617107251998 -122.434032629514 (37.7617107251998, -122.434032629514) 15 4 5 28862 3
137787 104161 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 138 ALPINE TER 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2013 12:00:00 AM 12 3x3 Permit Number 770750 6001664 2107990 37.7682325491861 -122.437543793089 (37.7682325491861, -122.437543793089) 15 5 5 29492 3
151858 231977 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 20 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003286.06563 2105669.78053 37.7619538776004 -122.431767549352 (37.7619538776004, -122.431767549352) 15 4 5 28862 3
158729 55509 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 4500 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50811 6001116.15615012 2104674.38897878 37.7590975343523 -122.439201053877 (37.7590975343523, -122.439201053877) 2 4 5 28862 3
171959 83375 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 248 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50822 5999884.09113954 2104832.45906966 37.7594613698021 -122.44347346176 (37.7594613698021, -122.44347346176) 2 4 5 28862 3

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