trees

10 rows where PlotSize = "Width 3ft" and qSpecies_id = 129

✎ 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)
62857 123067 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 604 12th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5992249.44693 2111276.49592 37.7767166209192 -122.470346870506 (37.7767166209192, -122.470346870506) 11 6 2 54 11
70242 234820 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3400 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006896.08338 2100607.87267 37.7482590167614 -122.418922854526 (37.7482590167614, -122.418922854526) 2 4 7 28859 19
79873 124285 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 4201 California St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5994493.43638 2114295.92728 37.7851366537527 -122.462803405372 (37.7851366537527, -122.462803405372) 11 6 2 54 11
111508 234821 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3400 Cesar Chavez St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006874.27762 2100608.63035 37.7482598692981 -122.418998312118 (37.7482598692981, -122.418998312118) 2 4 7 28859 19
117857 231172 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2968 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2016 12:00:00 AM 3 Width 3ft   6009727.404 2100624.81411 37.7484645559129 -122.409133381503 (37.7484645559129, -122.409133381503) 2 4 7 28859 19
119242 120364 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 6102 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5988623.48291 2114024.14495 37.7840505824045 -122.483091441937 (37.7840505824045, -122.483091441937) 11 6 2 55 26
147068 120830 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 5751 California St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5989723.47799 2114007.40969 37.7840685806486 -122.479284675494 (37.7840685806486, -122.479284675494) 11 6 2 55 26
154752 135631 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3450 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5998366.80455 2115231.89384 37.7879289000462 -122.449470282934 (37.7879289000462, -122.449470282934) 13 6 1 54 31
155974 120829 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 5751 California St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5989740.28285 2114007.05422 37.7840685806306 -122.479226511391 (37.7840685806306, -122.479226511391) 11 6 2 55 26
177275 234819 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3400 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006915.71417 2100607.47009 37.7482590167352 -122.418854943117 (37.7482590167352, -122.418854943117) 2 4 7 28859 19

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