trees

13 rows where PlotSize = "Width 3ft" and qSpecies_id = 177 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 3ft · 13 ✖
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)
10503 233771 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 35 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2019 03:11:00 PM 3 Width 3ft   6003168.16978 2108097.17278 37.7686122241979 -122.432348677773 (37.7686122241979, -122.432348677773) 15 5 5 28862 3
17835 146870 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 747 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 12:07:00 PM 0 Width 3ft   5983198.23429 2110712.37785 37.7746402422966 -122.501615441996 (37.7746402422966, -122.501615441996) 11 6 2 55 26
4599 172187 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 721 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 3ft   6003854.60179 2091058.27085 37.7218662421102 -122.428759536545 (37.7218662421102, -122.428759536545) 9 7 6 28861 5
8112 172239 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 285 London St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 3ft   6002395.65434 2092018.35321 37.7244197321571 -122.433871328009 (37.7244197321571, -122.433871328009) 9 7 6 28861 5
9697 172238 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 285 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 3ft   6002385.64302 2092003.99063 37.7243797276157 -122.433904909592 (37.7243797276157, -122.433904909592) 9 7 6 28861 5
5376 203267 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2 Garcia Ave 2 Sidewalk: Curb side : Yard Tree Private 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 781591 5995210.8831 2099639.94271 37.7449364165845 -122.45925958957 (37.7449364165845, -122.45925958957) 1 8 4 59 40
11531 203268 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2 Garcia Ave 3 Sidewalk: Curb side : Yard Tree Private 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 781591 5995209.06254 2099610.1708 37.7448545656781 -122.459263729153 (37.7448545656781, -122.459263729153) 1 8 4 59 40
14369 203266 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2 Garcia Ave 1 Sidewalk: Curb side : Yard Tree Private 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 781591 5995196 2099610 37.7448533456978 -122.459308884303 (37.7448533456978, -122.459308884303) 1 8 4 59 40
35798 210473 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 855 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2016 12:00:00 AM 14 Width 3ft Permit Number 41828 5993066.85825 2107284.57434 37.765803096459 -122.467228905809 (37.765803096459, -122.467228905809) 11 8 11 56 12
102162 216685 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 111 Ashton Ave 2 Sidewalk: Curb side : Yard Tree Private 2   10/06/2017 08:11:00 AM 3 Width 3ft   5994133.1609 2090669.87199 37.7202447887441 -122.462335661261 (37.7202447887441, -122.462335661261) 9 8 6 28861 24
11136 131782 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2646 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft Permit Number 779549 6000337.27442 2118211.39807 37.7962223607332 -122.442866875924 (37.7962223607332, -122.442866875924) 13 9 1 57 17
16011 131781 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2758 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2020 12:00:00 AM 3 Width 3ft   5999580.2108 2118368.89391 37.7966116124855 -122.445497792185 (37.7966116124855, -122.445497792185) 13 9 1 57 17
120674 124797 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 2898 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2017 12:00:00 AM 3 Width 3ft Permit Number 780062 5999308.846 2118065.45598 37.7957629573367 -122.446414930702 (37.7957629573367, -122.446414930702) 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)
);