trees

9 rows where Neighborhoods (old) = 12 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)
5578 211454 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1478 14th Ave 1 Sidewalk: Property side : Yard Tree Private 2     22 Width 5ft   5991840.401 2105371.22942 37.7604786845549 -122.471331499675 (37.7604786845549, -122.471331499675) 1 8 4 56 12
54992 211457 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1612 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5993723.499 2104492.49464 37.75817465746 -122.464754967966 (37.75817465746, -122.464754967966) 1 8 4 56 12
79451 233984 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1500 Cole St 3 Sidewalk: Curb side : Pot Tree Private 2     15 Width 4ft   5998354.25958 2105273.76497 37.7605857218813 -122.448796136753 (37.7605857218813, -122.448796136753) 15 5 11 29492 12
92478 211453 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1419 16th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5991125.87883 2105721.1672 37.7613981622243 -122.473828208309 (37.7613981622243, -122.473828208309) 1 8 4 56 12
107969 211455 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1380 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5992429.4104 2106070.41105 37.7624325075809 -122.469345298373 (37.7624325075809, -122.469345298373) 1 8 11 56 12
133548 211458 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 627 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992320.27215 2103852.77916 37.7563371653349 -122.469561321795 (37.7563371653349, -122.469561321795) 1 8 4 56 12
139546 211456 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1380 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5992429.06088 2106083.47981 37.7624683707489 -122.469347458517 (37.7624683707489, -122.469347458517) 1 8 11 56 12
168983 83224 Permitted Site 7 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 26 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50883 5994497.41095107 2106022.9855068 37.7624215781256 -122.462189460567 (37.7624215781256, -122.462189460567) 1 5 11 56 12
188532 234008 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 49 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5997051.85672 2106264.04005 37.7632302017241 -122.453372028518 (37.7632302017241, -122.453372028518) 15 5 11 29492 12

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