trees

10 rows where Neighborhoods (old) = 3 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)
20522 234012 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 671 Church St 44 Front Yard : Yard Tree Private 2     12 Width 3ft   6004318.00864 2105152.47097 37.7605919110103 -122.428161593486 (37.7605919110103, -122.428161593486) 2 4 5 28862 3
40225 99859 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4443 19th St 1 Front Yard : Yard Tree Private 2     12     6001193.1 2104609.9 37.7589248414166 -122.438930324474 (37.7589248414166, -122.438930324474) 2 4 5 28862 3
47243 234014 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 671 Church St 46 Front Yard : Yard Tree Private 2     10 Width 3ft   6004316.35459 2105177.02697 37.7606592423591 -122.428169064147 (37.7606592423591, -122.428169064147) 2 4 5 28862 3
66170 234011 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 671 Church St 40 Front Yard : Yard Tree Private 2     12 Width 3ft   6004316.16134 2105104.75601 37.7604607925581 -122.428164581925 (37.7604607925581, -122.428164581925) 2 4 5 28862 3
66345 100552 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4443 19th St 4 Front Yard : Yard Tree Private 2           6001193.1 2104609.9 37.7589248414166 -122.438930324474 (37.7589248414166, -122.438930324474) 2 4 5 28862 3
98276 234010 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 10 Museum Way 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 2ft   6000617.50699 2106869.96003 37.7650976439762 -122.441083133593 (37.7650976439762, -122.441083133593) 15 5 5 28862 3
99693 237733 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4084 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001754.97283 2105879.14802 37.7624418398492 -122.437077981268 (37.7624418398492, -122.437077981268) 15 5 5 28862 3
121953 100550 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4443 19th St 2 Front Yard : Yard Tree Private 2           6001193.1 2104609.9 37.7589248414166 -122.438930324474 (37.7589248414166, -122.438930324474) 2 4 5 28862 3
168587 234013 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 671 Church St 45 Front Yard : Yard Tree Private 2     9 Width 3ft   6004317.78072 2105162.37038 37.7606190795398 -122.428163087265 (37.7606190795398, -122.428163087265) 2 4 5 28862 3
171061 100551 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4443 19th St 3 Front Yard : Yard Tree Private 2           6001193.1 2104609.9 37.7589248414166 -122.438930324474 (37.7589248414166, -122.438930324474) 2 4 5 28862 3

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