trees

10 rows where Neighborhoods (old) = 20 and qSpecies_id = 50 sorted by PlantDate

✎ 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)
28655 116872 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1250 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6013499.86788 2106650.27714 37.7652197871992 -122.396510483775 (37.7652197871992, -122.396510483775) 14 3 8 28856 20
28919 190699 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6013438.17718 2106819.03274 37.7656797193792 -122.3967356902 (37.7656797193792, -122.3967356902) 14 3 8 28856 20
32204 116873 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1250 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013484.98836 2106649.50082 37.7652168275233 -122.396561894417 (37.7652168275233, -122.396561894417) 14 3 8 28856 20
32924 190747 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 200 Kansas St 7 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   6011390.12769 2107238.80287 37.7667181107881 -122.403849027209 (37.7667181107881, -122.403849027209) 8 2 8 28853 20
69954 190696 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6013444.35032 2106714.41309 37.7653928005592 -122.396707003628 (37.7653928005592, -122.396707003628) 14 3 8 28856 20
109658 190748 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 200 Kansas St 8 Sidewalk: Property side : Yard Tree Private 2     18 Width 4ft   6011391.69355 2107207.84436 37.7666331931997 -122.403841432442 (37.7666331931997, -122.403841432442) 8 2 8 28853 20
113872 190697 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013439.7362 2106789.19698 37.7655978837597 -122.396728206045 (37.7655978837597, -122.396728206045) 14 3 8 28856 20
130744 190698 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013440.07088 2106805.70814 37.7656432383768 -122.396728206061 (37.7656432383768, -122.396728206061) 14 3 8 28856 20
153794 190695 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013444.76571 2106699.32295 37.7653513894931 -122.396704508917 (37.7653513894931, -122.396704508917) 14 3 8 28856 20
171733 190694 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013445.19565 2106684.95045 37.7653119497171 -122.396702014197 (37.7653119497171, -122.396702014197) 14 3 8 28856 20

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