trees

29 rows where PlotSize = "Width 3ft" and qSpecies_id = 39

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 3ft · 29 ✖
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)
12941 241265 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 140 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2020 12:00:00 AM 3 Width 3ft Permit Number 785238 6007219.93489 2109165.8023 37.7717753403805 -122.418409700468 (37.7717753403805, -122.418409700468) 8 2 9 28853 19
19695 239185 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 483 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007463.11739 2106828.6922 37.7653718724361 -122.417402858182 (37.7653718724361, -122.417402858182) 8 4 7 28853 19
20785 239226 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2851 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010136.75438 2101030.89604 37.7496024914637 -122.407746478521 (37.7496024914637, -122.407746478521) 2 4 7 28859 19
25897 239229 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 391 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004228.5151 2106643.84143 37.764681793855 -122.428577420229 (37.764681793855, -122.428577420229) 8 4 5 28862 3
29978 239221 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2810 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6010295.22869 2101085.95879 37.7497625519161 -122.407202347334 (37.7497625519161, -122.407202347334) 2 4 7 28859 19
30634 239231 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 391 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004225.70382 2106680.81705 37.764783160934 -122.428589779597 (37.764783160934, -122.428589779597) 8 4 5 28862 3
44677 239179 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 370 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006290.70185 2107898.44552 37.7682431271357 -122.421533959636 (37.7682431271357, -122.421533959636) 8 4 7 28853 19
51753 136188 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3598 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002648.6286 2120880.08452 37.8036813773578 -122.435060090577 (37.8036813773578, -122.435060090577) 13 9 1 57 17
58529 239230 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 391 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004227.15082 2106664.32977 37.7647379727106 -122.428583599467 (37.7647379727106, -122.428583599467) 8 4 5 28862 3
61224 239222 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2830 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010232.06115 2101082.77231 37.749750267174 -122.407420559713 (37.749750267174, -122.407420559713) 2 4 7 28859 19
62633 239227 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2851 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6010159.00691 2101032.65482 37.7496085663777 -122.407669652152 (37.7496085663777, -122.407669652152) 2 4 7 28859 19
69432 239228 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 819 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009935.7806 2104272.52927 37.7584920407792 -122.408670110163 (37.7584920407792, -122.408670110163) 2 4 7 28859 19
72149 239182 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3599 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005021.22782 2106010.41037 37.7629873721785 -122.425790544398 (37.7629873721785, -122.425790544398) 8 4 5 28859 19
74646 239223 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2850 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010195.06778 2101081.2894 37.7497441247919 -122.407548380357 (37.7497441247919, -122.407548380357) 2 4 7 28859 19
75767 239181 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 380 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006215.67613 2107893.94566 37.7682265409602 -122.42179314696 (37.7682265409602, -122.42179314696) 8 4 7 28853 19
76680 239173 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3705 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005734.96606 2101372.66505 37.7502935116564 -122.422992320041 (37.7502935116564, -122.422992320041) 2 4 5 28859 19
92109 239186 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 483 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007463.67946 2106844.52399 37.7654153744566 -122.417402036177 (37.7654153744566, -122.417402036177) 8 4 7 28853 19
98663 239224 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2850 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010131.27143 2101077.30272 37.7497296070346 -122.407768710669 (37.7497296070346, -122.407768710669) 2 4 7 28859 19
100905 239178 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 370 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006302.56864 2107899.15692 37.7682457495759 -122.421492964039 (37.7682457495759, -122.421492964039) 8 4 7 28853 19
101161 239187 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 483 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007459.99284 2106907.97241 37.7655893815639 -122.417419284297 (37.7655893815639, -122.417419284297) 8 4 7 28853 19
108986 249356 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 625 Leavenworth St 2 : Tree Private 2     2 Width 3ft   6008325.07213 2114654.93665 37.7869093422284 -122.414975526796 (37.7869093422284, -122.414975526796) 13 1 9 28858 36
130061 239183 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 720 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007476.35772 2105397.09343 37.761441780224 -122.41725560676 (37.761441780224, -122.41725560676) 2 4 7 28859 19
136712 197031 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1950 Donner Ave 1 : Tree Private 2     5 Width 3ft   6011564.47329 2093570.84173 37.729198590121 -122.402284901123 (37.729198590121, -122.402284901123) 10 3 8 58 1
142290 239184 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 754 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007487.61608 2105246.87358 37.7610299446873 -122.417206023563 (37.7610299446873, -122.417206023563) 2 4 7 28859 19
145625 249388 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 301 Eddy St 3 : Tree Private 2     5 Width 3ft   6008934.66326 2113525.78003 37.7838431855658 -122.412786614726 (37.7838431855658, -122.412786614726) 7 10 9 28852 36
161495 239172 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 66 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005143.16857 2105759.69419 37.7623058551435 -122.425350950383 (37.7623058551435, -122.425350950383) 8 4 5 28859 19
162768 197037 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 176 Maddux Ave 1 : Tree Private 2     2 Width 3ft   6012326.10159 2094826.65316 37.7326892735933 -122.399740013104 (37.7326892735933, -122.399740013104) 10 3 8 58 1
164569 239180 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 370 14th St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006264.72566 2107896.23328 37.7682355881421 -122.421623651723 (37.7682355881421, -122.421623651723) 8 4 7 28853 19
179552 217747 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 625 Frederick St 1 : Tree Private 2     4 Width 3ft   5996570.53056 2107292.29818 37.7660259340648 -122.455111074526 (37.7660259340648, -122.455111074526) 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)
);