203 rows where qSpecies_id = 39 sorted by SiteOrder

View and edit SQL

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)
2777 256912 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 26 Lily St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 3x3 Permit Number 782765                    
66647 87768 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 200 Beacon St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50472 6003134 2097619 37.7398397101769 -122.431718656253 (37.7398397101769, -122.431718656253) 2 7 5 63 7
112264 87767 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 200 Beacon St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50472 6003134 2097619 37.7398397101769 -122.431718656253 (37.7398397101769, -122.431718656253) 2 7 5 63 7
7169 114201 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 310 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012278.4302 2106502.4698 37.7647458912325 -122.40072478603 (37.7647458912325, -122.40072478603) 14 3 8 28856 29
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
28722 92251 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1422 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2009 12:00:00 AM 0 3x3 Permit Number 52700 5985614.2 2105517.7 37.7605187222406 -122.492875546543 (37.7605187222406, -122.492875546543) 1 8 3 56 35
32072 197024 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2 Waterloo St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6010624.95454 2097233.34103 37.7392025469594 -122.405790793937 (37.7392025469594, -122.405790793937) 10 3 8 58 1
37418 92866 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 4800 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6014889.77806 2095498.93005 37.7346777911521 -122.390923645427 (37.7346777911521, -122.390923645427) 10 3 8 58 1
38180 65253 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1020 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3 Permit Number 52660 6009405.78315449 2103223.20926555 37.7555811463792 -122.410428993303 (37.7555811463792, -122.410428993303) 2 4 7 28859 19
43730 55657 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 349 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52575 6006153.21523754 2098012.87204699 37.7410918742968 -122.421307424196 (37.7410918742968, -122.421307424196) 2 7 7 28859 2
48163 82751 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 52 Sheridan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52446 6009256.89976445 2109417.42292722 37.772580689338 -122.41138145626 (37.772580689338, -122.41138145626) 8 2 9 28853 34
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
52907 82094 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 356 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 50622 5991881.95379836 2113031.51992267 37.7815141826847 -122.471746056837 (37.7815141826847, -122.471746056837) 11 6 2 54 11
55144 94762 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 10X Waterloo St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2010 12:00:00 AM   3x3 Permit Number 53881 6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
57528 95700 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Arbor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805 2096722 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043) 2 7 5 63 7
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
66871 239150 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 4ft   6005732.39027 2109686.64828 37.7731216065951 -122.4235922587 (37.7731216065951, -122.4235922587) 7 9 11 28852 10
68141 239174 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1714 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005940.64905 2107290.54233 37.7665542255162 -122.422701553932 (37.7665542255162, -122.422701553932) 8 4 5 28853 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
69764 84663 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 4023 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003022.50968447 2101807.41144942 37.7513337904703 -122.43240321347 (37.7513337904703, -122.43240321347) 2 4 5 28862 22
71958 87950 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 263a States St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50972 6000485 2106698 37.7646179360441 -122.441529100685 (37.7646179360441, -122.441529100685) 15 5 5 28862 3
74165 102120 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3906 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003747.7 2101944.5 37.751751298202 -122.429905200436 (37.751751298202, -122.429905200436) 2 4 5 28862 22
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
83615 95066 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1575 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2010 12:00:00 AM   3x3 Permit Number 54019 6007827.1 2100671.6 37.7484863781823 -122.415707927927 (37.7484863781823, -122.415707927927) 2 4 7 28859 19
89400 197032 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2425 Mendell St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6013410.89228 2092904.94236 37.7274730618297 -122.395854985916 (37.7274730618297, -122.395854985916) 10 3 8 58 1
89986 173654 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 118 06th St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010152 2112318 37.7805951592946 -122.408489839314 (37.7805951592946, -122.408489839314) 14 2 9 28853 34
93457 84670 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 4089 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6002616.95424138 2101785.02656585 37.7512493217958 -122.433804069341 (37.7512493217958, -122.433804069341) 2 4 5 28862 22
93516 84571 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3991 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003245.44934651 2101819.71675357 37.7513802170554 -122.431633141487 (37.7513802170554, -122.431633141487) 2 4 5 28862 22
97965 116523 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2486 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5995798 2110374 37.7744431335528 -122.458006125331 (37.7744431335528, -122.458006125331) 11 6 2 54 16
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
103697 94619 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1799X Armstrong Ave 1 Sidewalk: Property side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 2   Permit Number 53777 6013459.79784 2093130.51427 37.7280951570487 -122.395701716272 (37.7280951570487, -122.395701716272) 10 3 8 58 1
103835 10244 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 99X Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/28/2000 12:00:00 AM 6 3X3   6005773.33687 2109613.89968 37.7729241676403 -122.42344544616 (37.7729241676403, -122.42344544616) 7 9 11 28852 10
106471 65681 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 345 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2011 12:00:00 AM 3   Permit Number 767215 5993370.6959 2113311.72647 37.782369577363 -122.466616141073 (37.782369577363, -122.466616141073) 11 6 2 54 11
109559 197029 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1601 Kirkwood Ave 1 : Tree Private 2     4 Width 4ft   6015115.28126 2096786.01211 37.7382243660701 -122.390233889493 (37.7382243660701, -122.390233889493) 10 3 8 58 1
110773 239176 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1748 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005773.30835 2107281.96849 37.7665212410869 -122.423279746972 (37.7665212410869, -122.423279746972) 8 4 5 28853 19
111916 80773 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 317 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767266 6004338.6764807 2102152.37621846 37.7523555276075 -122.427876335011 (37.7523555276075, -122.427876335011) 2 4 5 28862 22
113549 239142 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 N Off Ramp 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6005875.43102 2109171.08438 37.7717140650818 -122.423060809714 (37.7717140650818, -122.423060809714) 8 2 9 28853 19
118584 74954 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
128429 239175 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1742 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005792.61573 2107282.25816 37.7665231260736 -122.423212986701 (37.7665231260736, -122.423212986701) 8 4 5 28853 19
134355 22306 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 5015 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6014803.86419 2094824.41992 37.7328209559263 -122.39117354906 (37.7328209559263, -122.39117354906) 10 3 8 58 1
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
140365 102175 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 484 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769767 5999426.4 2104189.2 37.7576690270565 -122.445010134311 (37.7576690270565, -122.445010134311) 2 5 5 28862 3
142837 91029 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 967 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 5 3x3   6007608.48742 2104034.949256 37.7577090789947 -122.416702122814 (37.7577090789947, -122.416702122814) 2 4 7 28859 19
146723 95702 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 231 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2011 12:00:00 AM   3x3 Permit Number 767451 5995312 2091520.8 37.7226490447139 -122.458322390694 (37.7226490447139, -122.458322390694) 9 8 4 28861 24
146783 239159 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6010593.731 2101386.95157 37.7506057130911 -122.406191312392 (37.7506057130911, -122.406191312392) 10 4 7 28859 19
148854 61801 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 564 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2009 12:00:00 AM   3x3 Permit Number 52595 6003001.78864481 2108933.54346304 37.7708992574252 -122.432983937695 (37.7708992574252, -122.432983937695) 15 5 11 29492 9
155722 239189 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 1 Back Yard : Yard Tree Private 2     3     6005983.85034 2108958.28367 37.7711358828561 -122.422670655046 (37.7711358828561, -122.422670655046) 8 2 9 28853 19
158340 197035 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1751 Armstrong Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6013551.1098 2093063.74117 37.7279168907351 -122.395381369648 (37.7279168907351, -122.395381369648) 10 3 8 58 1
160303 83748 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 235 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 4 3x3 Permit Number 51439 6013723.72454 2094177.53037 37.7309847282642 -122.39486260383 (37.7309847282642, -122.39486260383) 10 3 8 58 1
162569 197034 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1777 Armstrong Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6013492.1426 2093105.49396 37.7280282555765 -122.395588146293 (37.7280282555765, -122.395588146293) 10 3 8 58 1
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
167251 95064 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 4849X 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6014989.6 2095442.3 37.734527834908 -122.390574568357 (37.734527834908, -122.390574568357) 10 3 8 58 1
168474 239177 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1778 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6005631.82803 2107273.89376 37.7664910841327 -122.423768528492 (37.7664910841327, -122.423768528492) 8 4 5 28853 19
170786 197033 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2421 Mendell St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6013404.92157 2092933.78448 37.7275519242636 -122.395877647031 (37.7275519242636, -122.395877647031) 10 3 8 58 1
175297 239218 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 1 Back Yard : Yard Tree Private 2     3 Width 10ft   6005833.18575 2109028.0269 37.7713188795981 -122.423196768328 (37.7713188795981, -122.423196768328) 8 2 5 28853 19
176302 82835 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
176674 43127 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52578 6007298.20406204 2099606.09068899 37.7455309835883 -122.417461342572 (37.7455309835883, -122.417461342572) 2 7 7 28859 2
176681 102170 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 270 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 3 3x3   6001983.1 2104294.8 37.7581045689631 -122.436175590041 (37.7581045689631, -122.436175590041) 2 4 5 28862 3
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
184594 61618 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3904 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003796.89718088 2101902.23350187 37.7516380302781 -122.429732055701 (37.7516380302781, -122.429732055701) 2 4 5 28862 22
188204 101924 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
189987 82263 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 850 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2011 12:00:00 AM 5 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.7595448304107 -122.417037358657 (37.7595448304107, -122.417037358657) 2 4 7 28859 19
191841 109941 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
23235 109950 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 10 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
34587 239198 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 10 Back Yard : Yard Tree Private 2     3     6005918.91365 2109064.99496 37.7714252226197 -122.422902859103 (37.7714252226197, -122.422902859103) 8 2 9 28853 19
40978 239166 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010684.29962 2101159.52227 37.749986307743 -122.405862098468 (37.749986307743, -122.405862098468) 10 4 7 28859 19
13217 109951 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 11 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
50006 239167 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010693.26923 2101137.12494 37.7499253112163 -122.405829503442 (37.7499253112163, -122.405829503442) 10 4 7 28859 19
79147 239147 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Octavia St 11 : Tree Private 2     5 Width 6ft   6005750.76035 2109550.79453 37.7727496218289 -122.423519053867 (37.7727496218289, -122.423519053867) 7 9 11 28852 10
146007 239211 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 11 Back Yard : Yard Tree Private 2     5     6005882.93751 2108938.64172 37.7710762568972 -122.423018320345 (37.7710762568972, -122.423018320345) 8 2 5 28853 19
8531 239148 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Octavia St 12 : Tree Private 2     3 Width 6ft   6005748.59719 2109565.89201 37.7727909537754 -122.423527610038 (37.7727909537754, -122.423527610038) 7 9 11 28852 10
120944 239168 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010702.84807 2101113.77684 37.7498617381444 -122.40579473475 (37.7498617381444, -122.40579473475) 10 4 7 28859 19
69597 92590 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 445 Wawona St 13 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
93180 239210 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 13 Back Yard : Yard Tree Private 2     3     6005891.00584 2108925.69957 37.7710411761388 -122.422989491673 (37.7710411761388, -122.422989491673) 8 2 5 28853 19
151092 239149 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Octavia St 13 : Tree Private 2     3 Width 6ft   6005748.02057 2109577.94621 37.7728240191579 -122.423530461786 (37.7728240191579, -122.423530461786) 7 9 11 28852 10
37443 239209 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 14 Back Yard : Yard Tree Private 2     2     6005896.87599 2108918.25042 37.7710210537973 -122.422968657083 (37.7710210537973, -122.422968657083) 8 2 5 28853 19
37563 92591 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 445 Wawona St 14 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
104140 239169 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010720.15958 2101068.99531 37.7497397459909 -122.405731716554 (37.7497397459909, -122.405731716554) 10 4 7 28859 19
89316 92592 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 445 Wawona St 15 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
87707 92593 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 445 Wawona St 16 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625 2097033 37.7375716044552 -122.471468876287 (37.7375716044552, -122.471468876287) 1 8 4 29491 40
55996 239170 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010748.55016 2100997.3935 37.7495447307243 -122.405628497759 (37.7495447307243, -122.405628497759) 10 4 7 28859 19
125140 239208 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 17 Back Yard : Yard Tree Private 2     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484) 8 2 5 28853 19
82233 239207 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 18 Back Yard : Yard Tree Private 2     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387) 8 2 5 28853 19
131784 239206 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 19 Back Yard : Yard Tree Private 2     3     6005929.11782 2108865.00797 37.7708766820544 -122.422853346899 (37.7708766820544, -122.422853346899) 8 2 5 28853 19
26357 91026 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 722 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.7615776005454 -122.417211018518 (37.7615776005454, -122.417211018518) 2 4 7 28859 19
27446 95701 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Arbor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805 2096722 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043) 2 7 5 63 7
38551 94763 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 10X Waterloo St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
40493 95067 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1575 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2010 12:00:00 AM   3x3 Permit Number 54019 6007827.1 2100671.6 37.7484863781823 -122.415707927927 (37.7484863781823, -122.415707927927) 2 4 7 28859 19
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
50302 239160 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010602.41193 2101365.81223 37.7505481546786 -122.406159803726 (37.7505481546786, -122.406159803726) 10 4 7 28859 19
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
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
74613 74812 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
82493 239190 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 2 Back Yard : Yard Tree Private 2     4     6005977.0875 2108970.19311 37.7711682017725 -122.422694894458 (37.7711682017725, -122.422694894458) 8 2 9 28853 19
90422 197030 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1601 Kirkwood Ave 2 : Tree Private 2     4 Width 4ft   6015124.98776 2096779.46594 37.7382069300149 -122.390199871734 (37.7382069300149, -122.390199871734) 10 3 8 58 1
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
93470 109942 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34

Next page

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