trees

9 rows where Neighborhoods (old) = 17 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)
13583 132411 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 745 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5999434.9133 2121499.2864 37.8051985336487 -122.44622584645 (37.8051985336487, -122.44622584645) 13 9 1 57 17
22716 87875 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 3600 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM 28 3x3 Permit Number 50847 5998892.13962 2121169.83114 37.8042629266417 -122.448080437384 (37.8042629266417, -122.448080437384) 13 9 1 57 17
22930 132410 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 745 Marina Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 2ft   5999410.35977 2121494.73276 37.8051846283209 -122.446310488859 (37.8051846283209, -122.446310488859) 13 9 1 57 17
24767 103146 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2400 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 4x7   6001529.82493 2118035.8425 37.795808247211 -122.438727829835 (37.795808247211, -122.438727829835) 13 9 1 57 17
83618 132407 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2226 Beach St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5999525.00541 2120880.05775 37.8035034437869 -122.445869509882 (37.8035034437869, -122.445869509882) 13 9 1 57 17
119936 132409 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 3600 Lyon St 3 Sidewalk: Property side : Yard Tree Private 2     7     5998888.99949 2121205.10522 37.8043596001851 -122.448093845382 (37.8043596001851, -122.448093845382) 13 9 1 57 17
137414 87876 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 3600 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM 1 3x3 Permit Number 50847 5998889.14339 2121177.12812 37.8042827908914 -122.448091331753 (37.8042827908914, -122.448091331753) 13 9 1 57 17
141004 61065 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2941 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1983 12:00:00 AM 14   Permit Number 20897 5999977.57302 2118701.67418 37.7975480153891 -122.444146759564 (37.7975480153891, -122.444146759564) 13 9 1 57 17
168043 132408 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1900 Jefferson St 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6000027.88392 2121296.89178 37.8046766588582 -122.444159252968 (37.8046766588582, -122.444159252968) 13 9 1 57 17

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