trees

6 rows where Neighborhoods (old) = 27 and qSpecies_id = 143

✎ 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)
30174 18980 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2918 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6000663.17747 2115553.99763 37.788944409101 -122.441548395156 (37.788944409101, -122.441548395156) 13 6 1 29490 27
91050 249674 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2400 Baker St 6 Front Yard : Yard Tree Private 2     6     5999745.99135 2117154.55448 37.7932868206909 -122.444836822859 (37.7932868206909, -122.444836822859) 13 9 1 57 27
103273 137943 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1934 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003936.5354 2115120.5913 37.7879403315763 -122.430192087218 (37.7879403315763, -122.430192087218) 13 9 11 29490 27
154179 249704 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2400 Baker St 36 Front Yard : Yard Tree Private 2     5     5999690.97747 2117209.86424 37.7934355469601 -122.445031151972 (37.7934355469601, -122.445031151972) 13 9 1 57 27
161962 250145 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2550x Lyon St 13 Median : Yard Tree DPW 1     30     5999218.1379 2117651.88833 37.794622229397 -122.446699024758 (37.794622229397, -122.446699024758) 13 9 1 57 27
178985 249702 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2400 Baker St 34 Front Yard : Yard Tree Private 2     8     5999706.07757 2117210.81858 37.7934390291431 -122.444978973317 (37.7934390291431, -122.444978973317) 13 9 1 57 27

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