trees

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

✎ 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)
15126 121049 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
22799 101714 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 1240 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006918 2119116 37.7990791449181 -122.420160405591 (37.7990791449181, -122.420160405591) 5 1 1 28858 32
24703 121054 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
37383 121052 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
74510 121050 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
82588 66076 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1830 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM     Permit Number 29120 6008716.78878742 2119192.91553026 37.7993915237126 -122.413941412032 (37.7993915237126, -122.413941412032) 3 1 10 308 32
100503 121051 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
156905 66086 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 895 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM     Permit Number 29130 6008704.72380049 2119330.26525123 37.7997679743153 -122.413992883013 (37.7997679743153, -122.413992883013) 3 1 10 308 32
160327 121053 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32

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