trees

10 rows where qSpecies_id = 370

✎ View and edit SQL

This data as json, CSV (advanced)

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)
16588 119052 DPW Maintained 1 Hakea laurina :: Sea Urchin Tree 370 539 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5982216.76848 2112075.96454 37.7783265569214 -122.505111546234 (37.7783265569214, -122.505111546234) 11 6 2 55 26
20578 44813 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 2700x Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43905 5986474 2105095 37.7594083467555 -122.489870843925 (37.7594083467555, -122.489870843925) 1 8 3 56 35
41226 46968 DPW Maintained 1 Hakea laurina :: Sea Urchin Tree 370 1639 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM 7   Permit Number 47056 5982801.55118104 2103964.20108888 37.7560883724857 -122.502488068941 (37.7560883724857, -122.502488068941) 1 8 3 56 35
53158 52072 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 1180 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2008 12:00:00 AM   3x3 Permit Number 48266 6007369.565674 2118849.33698482 37.7983723881125 -122.418578912423 (37.7983723881125, -122.418578912423) 5 1 10 28858 32
82978 43238 DPW Maintained 1 Hakea laurina :: Sea Urchin Tree 370 1778 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2000 12:00:00 AM 8   Permit Number 43025 5989707.34479458 2103262.12213674 37.7545640192976 -122.478554440022 (37.7545640192976, -122.478554440022) 1 8 3 56 35
83481 12696 DPW Maintained 1 Hakea laurina :: Sea Urchin Tree 370 1352 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   5991211.41269 2114825.51279 37.7864011704317 -122.474196725991 (37.7864011704317, -122.474196725991) 11 6 1 54 33
89220 44812 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 2700x Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43905 5986474 2105095 37.7594083467555 -122.489870843925 (37.7594083467555, -122.489870843925) 1 8 3 56 35
115673 46572 DPW Maintained 1 Hakea laurina :: Sea Urchin Tree 370 1462 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2007 12:00:00 AM 4 3x3 Permit Number 49801 5982191.72837627 2105150.75558806 37.759310462223 -122.504684918161 (37.759310462223, -122.504684918161) 1 8 3 56 35
121630 45680 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 215 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/18/2001 12:00:00 AM     Permit Number 44367 6004811.33845947 2097114.51665019 37.7385494492977 -122.425883220193 (37.7385494492977, -122.425883220193) 2 7 5 63 7
181636 34948 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 2746 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1997 12:00:00 AM     Permit Number 38546 5984041.36569537 2096474.98661901 37.7355978151008 -122.497647503936 (37.7355978151008, -122.497647503936) 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)
);