trees

11 rows where qSpecies_id = 318

✎ 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)
8304 56694 DPW Maintained 1 Psidium guajava :: Guava tree 318 1150 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     5     6007476.46464 2118864.51402 37.7984200780943 -122.418210085122 (37.7984200780943, -122.418210085122) 5 1 10 28858 32
9546 52625 DPW Maintained 1 Psidium guajava :: Guava tree 318 535@ SILLIMAN Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2006 12:00:00 AM 4   Permit Number 48708 6008839.1199 2093513.5179 37.7288886828681 -122.41170266546 (37.7288886828681, -122.41170266546) 9 3 7 309 28
32739 213744 DPW Maintained 1 Psidium guajava :: Guava tree 318 10 Ventura Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5994038.82895 2102036.5455 37.7514494264635 -122.463486199038 (37.7514494264635, -122.463486199038) 1 8 4 29491 40
36505 213745 DPW Maintained 1 Psidium guajava :: Guava tree 318 98 Lurline St 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5991840.41055 2105148.54995 37.7598672660797 -122.471315241723 (37.7598672660797, -122.471315241723) 1 8 4 56 12
66868 179180 DPW Maintained 1 Psidium guajava :: Guava tree 318 126 Havelock St 1 Sidewalk: Property side : Yard Tree Private 2     21 Width 8ft   5999437.64226 2092952.264 37.7268157311392 -122.444163811612 (37.7268157311392, -122.444163811612) 9 7 6 28861 25
68914 96031 DPW Maintained 1 Psidium guajava :: Guava tree 318 1116 Greenwich St 1 : Tree Private 2   04/05/2011 12:00:00 AM 20   Permit Number 767346 6007512.84317 2119899.46213 37.8012638333238 -122.418157616905 (37.8012638333238, -122.418157616905) 5 1 1 28858 32
79819 213743 DPW Maintained 1 Psidium guajava :: Guava tree 318 10 Ventura Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5994035.9352 2102024.34895 37.751415771121 -122.46349532086 (37.751415771121, -122.46349532086) 1 8 4 29491 40
98274 110603 DPW Maintained 1 Psidium guajava :: Guava tree 318 1150 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     5     6007457.84014 2118861.88547 37.7984118124117 -122.4182743453 (37.7984118124117, -122.4182743453) 5 1 10 28858 32
118054 248197 DPW Maintained 1 Psidium guajava :: Guava tree 318 59 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006907.03161 2099048.75238 37.7439786404094 -122.418774440315 (37.7439786404094, -122.418774440315) 2 7 7 28859 2
147910 196554 DPW Maintained 1 Psidium guajava :: Guava tree 318 651 Indiana St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   6014943.02961 2105380.00605 37.7618121066615 -122.391430081331 (37.7618121066615, -122.391430081331) 10 3 8 28856 29
181675 196555 DPW Maintained 1 Psidium guajava :: Guava tree 318 800 19th St 12 Sidewalk: Property side : Yard Tree Private 2     2 Width 10ft   6015031.61703 2105339.79088 37.7617066008872 -122.391120879124 (37.7617066008872, -122.391120879124) 10 3 8 28856 29

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