trees

7 rows where Neighborhoods (old) = 6 and qLegalStatus_id = 10

✎ 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)
20128 103466 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
22900 103469 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 799X Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012272.7 2118721.6 37.7982964705447 -122.401603488036 (37.7982964705447, -122.401603488036) 3 1 10 28860 6
43905 103465 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
55082 108822 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
62944 108821 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3 5x5 Permit Number 774616 6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
169034 103467 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
193590 108823 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6

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