Street_Tree_List

Data source: data.sfgov.org

201 rows where qSpecies = 147 sorted by PermitNotes

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes ▼ XCoord YCoord Latitude Longitude Location
1489 239150 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 Width 4ft   6005732.390269999 2109686.64828 37.773121606595105 -122.42359225870001 (37.7731216065951, -122.4235922587)
9721 173654 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 118 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6010152.0 2112318.0 37.7805951592946 -122.408489839314 (37.7805951592946, -122.408489839314)
16217 22383 Private 5 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1799X Armstrong Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1997 12:00:00 AM 2 4x15   6013476.602999999 2093118.78047 37.7280638732384 -122.39564279807301 (37.7280638732384, -122.395642798073)
18013 109951 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
20029 10244 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 99X Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/28/2000 12:00:00 AM 6 3X3   6005773.33687 2109613.89968 37.7729241676403 -122.42344544616002 (37.7729241676403, -122.42344544616)
25154 239161 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010627.47447 2101300.53615 37.7503703227358 -122.406068536926 (37.7503703227358, -122.406068536926)
26151 197034 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1777 Armstrong Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6013492.1426 2093105.4939599999 37.728028255576504 -122.395588146293 (37.7280282555765, -122.395588146293)
27616 239170 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010748.55016 2100997.3935 37.749544730724296 -122.405628497759 (37.7495447307243, -122.405628497759)
27650 239211 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 11 Back Yard : Yard 13 Tree 1 Private 1     5     6005882.93751 2108938.64172 37.7710762568972 -122.42301832034501 (37.7710762568972, -122.423018320345)
27893 217747 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 625 Frederick St 1 : 4 Tree 1 Private 1     4 Width 3ft   5996570.53056 2107292.29818 37.7660259340648 -122.455111074526 (37.7660259340648, -122.455111074526)
29865 197031 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1950 Donner Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   6011564.47329 2093570.84173 37.729198590121 -122.40228490112301 (37.729198590121, -122.402284901123)
30621 249356 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 625 Leavenworth St 2 : 4 Tree 1 Private 1     2 Width 3ft   6008325.07213 2114654.93665 37.7869093422284 -122.414975526796 (37.7869093422284, -122.414975526796)
31969 239194 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 6 Back Yard : Yard 13 Tree 1 Private 1     3     6005943.751730001 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768)
32290 239198 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 10 Back Yard : Yard 13 Tree 1 Private 1     3     6005918.91365 2109064.99496 37.771425222619705 -122.42290285910299 (37.7714252226197, -122.422902859103)
33973 239178 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 370 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006302.56864 2107899.15692 37.7682457495759 -122.421492964039 (37.7682457495759, -122.421492964039)
33987 239160 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010602.41193 2101365.81223 37.750548154678604 -122.40615980372601 (37.7505481546786, -122.406159803726)
34563 197036 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1751 Armstrong Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   6013567.3449099995 2093051.01085 37.7278828388179 -122.395324352636 (37.7278828388179, -122.395324352636)
34830 239214 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 7 Back Yard : Yard 13 Tree 1 Private 1     6     6005859.14445 2108978.35649 37.771183961488106 -122.423103444792 (37.7711839614881, -122.423103444792)
35302 239224 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2850 26th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010131.271430001 2101077.30272 37.7497296070346 -122.407768710669 (37.7497296070346, -122.407768710669)
35375 239209 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 14 Back Yard : Yard 13 Tree 1 Private 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
35585 239152 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Octavia St 3 : 4 Tree 1 Private 1     4 Width 4ft   6005729.11778 2109714.63204 37.773198258533895 -122.42360556863599 (37.7731982585339, -122.423605568636)
37803 197027 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2 Waterloo St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6010417.49048 2097253.73995 37.739246953685395 -122.406509551872 (37.7392469536854, -122.406509551872)
38302 239222 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2830 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010232.06115 2101082.77231 37.749750267174 -122.407420559713 (37.749750267174, -122.407420559713)
38308 197032 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2425 Mendell St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6013410.89228 2092904.9423599998 37.727473061829706 -122.395854985916 (37.7274730618297, -122.395854985916)
38314 239164 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6010663.94961 2101209.37133 37.75012204421029 -122.405935981386 (37.7501220442103, -122.405935981386)
38350 239199 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 27 Back Yard : Yard 13 Tree 1 Private 1     2     6005974.4493 2108807.19348 37.770720494984495 -122.422692434815 (37.7707204949845, -122.422692434815)
43810 239167 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6010693.269230001 2101137.12494 37.749925311216295 -122.405829503442 (37.7499253112163, -122.405829503442)
44114 239182 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3599 17th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6005021.22782 2106010.41037 37.7629873721785 -122.425790544398 (37.7629873721785, -122.425790544398)
44635 239192 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 4 Back Yard : Yard 13 Tree 1 Private 1     6     6005960.3562900005 2108991.91912 37.771226912211795 -122.422754312663 (37.7712269122118, -122.422754312663)
45307 239204 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 21 Back Yard : Yard 13 Tree 1 Private 1     4     6005940.87649 2108850.7859900002 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426)
45537 239188 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1300 San Jose Ave 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6003390.53226 2095588.92552 37.7342801275185 -122.430686848418 (37.7342801275185, -122.430686848418)
46484 239176 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1748 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6005773.30835 2107281.9684900003 37.7665212410869 -122.42327974697201 (37.7665212410869, -122.423279746972)
46968 239180 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 370 14th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006264.72566 2107896.23328 37.7682355881421 -122.42162365172301 (37.7682355881421, -122.421623651723)
47447 239172 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 66 Dorland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6005143.16857 2105759.69419 37.7623058551435 -122.42535095038299 (37.7623058551435, -122.425350950383)
50307 239175 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1742 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6005792.615730001 2107282.2581599997 37.7665231260736 -122.42321298670099 (37.7665231260736, -122.423212986701)
52540 239181 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 380 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006215.6761300005 2107893.9456599997 37.7682265409602 -122.42179314696001 (37.7682265409602, -122.42179314696)
52804 239179 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 370 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006290.70185 2107898.44552 37.768243127135705 -122.42153395963601 (37.7682431271357, -122.421533959636)
52838 114202 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 310 Carolina St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6012278.21126 2106491.69166 37.7647162846561 -122.400724786045 (37.7647162846561, -122.400724786045)
53022 239177 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1778 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6005631.82803 2107273.89376 37.7664910841327 -122.42376852849199 (37.7664910841327, -122.423768528492)
53477 239185 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 483 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007463.11739 2106828.6922 37.765371872436106 -122.41740285818199 (37.7653718724361, -122.417402858182)
54298 239149 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 8 Octavia St 13 : 4 Tree 1 Private 1     3 Width 6ft   6005748.02057 2109577.9462099997 37.7728240191579 -122.423530461786 (37.7728240191579, -122.423530461786)
54547 239225 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3041 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6009370.46908 2100985.69041 37.7494354397039 -122.410393138328 (37.7494354397039, -122.410393138328)
56551 239228 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 819 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009935.7806 2104272.5292700003 37.7584920407792 -122.408670110163 (37.7584920407792, -122.408670110163)
56900 239186 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 483 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007463.67946 2106844.52399 37.7654153744566 -122.41740203617701 (37.7654153744566, -122.417402036177)
57531 239159 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6010593.731000001 2101386.95157 37.750605713091105 -122.40619131239201 (37.7506057130911, -122.406191312392)
57803 239223 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2850 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010195.06778 2101081.2894 37.749744124791896 -122.407548380357 (37.7497441247919, -122.407548380357)
59769 239203 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 22 Back Yard : Yard 13 Tree 1 Private 1     3     6005946.44181 2108844.1649 37.7708204294492 -122.42279194121402 (37.7708204294492, -122.422791941214)
60490 239208 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 17 Back Yard : Yard 13 Tree 1 Private 1     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484)
60926 239169 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010720.159580001 2101068.9953099997 37.749739745990894 -122.40573171655399 (37.7497397459909, -122.405731716554)
61124 239165 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6010673.4453300005 2101181.95766 37.7500473033606 -122.40590121358801 (37.7500473033606, -122.405901213588)
61226 239216 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 3 Back Yard : Yard 13 Tree 1 Private 1     5     6005843.543219999 2109006.7344400003 37.771261000120504 -122.42315942758499 (37.7712610001205, -122.423159427585)
61349 239227 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2851 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010159.00691 2101032.6548200003 37.7496085663777 -122.40766965215201 (37.7496085663777, -122.407669652152)
63424 239230 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 391 Church St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004227.15082 2106664.32977 37.7647379727106 -122.42858359946699 (37.7647379727106, -122.428583599467)
63559 136188 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3598 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002648.6286 2120880.08452 37.8036813773578 -122.435060090577 (37.8036813773578, -122.435060090577)
63852 239189 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 1 Back Yard : Yard 13 Tree 1 Private 1     3     6005983.85034 2108958.2836700003 37.7711358828561 -122.422670655046 (37.7711358828561, -122.422670655046)
65016 239173 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3705 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005734.96606 2101372.66505 37.7502935116564 -122.422992320041 (37.7502935116564, -122.422992320041)
68215 239147 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 8 Octavia St 11 : 4 Tree 1 Private 1     5 Width 6ft   6005750.76035 2109550.79453 37.7727496218289 -122.423519053867 (37.7727496218289, -122.423519053867)
68673 249388 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 301 Eddy St 3 : 4 Tree 1 Private 1     5 Width 3ft   6008934.66326 2113525.78003 37.78384318556579 -122.41278661472602 (37.7838431855658, -122.412786614726)
69212 239226 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2851 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6010136.754380001 2101030.89604 37.749602491463705 -122.407746478521 (37.7496024914637, -122.407746478521)
69456 239163 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010654.95431 2101230.51738 37.75017960352871 -122.40596857728701 (37.7501796035287, -122.405968577287)
70626 239155 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 150 Octavia St 7 : 4 Tree 1 Private 1     7 Width 4ft   6005700.01949 2109925.2105900003 37.7737748138817 -122.42372119899099 (37.7737748138817, -122.423721198991)
72607 197026 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2 Waterloo St 3 : 4 Tree 1 Private 1     3 Width 4ft   6010467.19371 2097248.77404 37.7392360988707 -122.406337349712 (37.7392360988707, -122.406337349712)
72859 239145 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 N Off Ramp 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6005859.0162 2109201.52808 37.7717967298683 -122.42311975398701 (37.7717967298683, -122.423119753987)
73553 239217 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 2 Back Yard : Yard 13 Tree 1 Private 1     4     6005837.81281 2109017.0594 37.7712890265976 -122.423179983379 (37.7712890265976, -122.423179983379)
75553 239196 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 8 Back Yard : Yard 13 Tree 1 Private 1     3     6005930.84591 2109041.9421200003 37.771362598325 -122.42285994612499 (37.771362598325, -122.422859946125)
75691 239184 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 754 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007487.61608 2105246.87358 37.761029944687294 -122.417206023563 (37.7610299446873, -122.417206023563)
76455 239162 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6010646.644669999 2101254.46555 37.7502448951922 -122.40599899954799 (37.7502448951922, -122.405998999548)
76599 114205 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 310 Carolina St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6012283.24048 2106396.5985 37.7644554605731 -122.40070071026399 (37.7644554605731, -122.400700710264)
77374 109950 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
80041 91027 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 722 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
80263 94763 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 10X Waterloo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
82275 109948 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
85858 91025 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 140 South Van Ness Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
92212 109944 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93248 109945 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93713 109942 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
94383 94764 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 10X Waterloo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
100892 109943 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
101758 116523 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2486 FULTON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5995798.0 2110374.0 37.7744431335528 -122.458006125331 (37.7744431335528, -122.458006125331)
101764 22308 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 5033 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/24/2000 12:00:00 AM 3 3x3   6014806.8487599995 2094754.47288 37.7326290611665 -122.39115834308599 (37.7326290611665, -122.391158343086)
104369 91023 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 140 South Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
104982 109946 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
105566 239156 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Octavia St 4 : 4 Tree 1 Private 1     5 Width 4ft   6005612.49957 2109700.10187 37.7731517788755 -122.42400793341999 (37.7731517788755, -122.42400793342)
109696 95059 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 5115X 03rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6014711.63884 2094587.79956 37.7321661259618 -122.391475861678 (37.7321661259618, -122.391475861678)
110318 91028 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 722 South Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
110849 91029 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 967 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/2008 12:00:00 AM 5 3x3   6007608.48742 2104034.949256 37.7577090789947 -122.416702122814 (37.7577090789947, -122.416702122814)
110960 91024 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 140 South Van Ness Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
111319 22306 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 5015 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6014803.86419 2094824.41992 37.7328209559263 -122.39117354906 (37.7328209559263, -122.39117354906)
113160 109947 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 400x CLEMENTINA ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
117701 95060 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 5033 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6014806.53085 2094754.47288 37.732629043524206 -122.391159442188 (37.7326290435242, -122.391159442188)
118628 22295 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 4910 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6014801.71028 2095185.44595 37.733812140558705 -122.391206222681 (37.7338121405587, -122.391206222681)
121292 22304 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 5012X 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6014702.6472 2094891.22359 37.7329987676998 -122.39152815342301 (37.7329987676998, -122.391528153423)
121921 95064 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 4849X 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6014989.6 2095442.3 37.734527834908 -122.390574568357 (37.734527834908, -122.390574568357)
124525 92866 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 4800 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6014889.778059999 2095498.93005 37.7346777911521 -122.390923645427 (37.7346777911521, -122.390923645427)
124874 91022 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 140 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
126197 94767 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 10X Waterloo St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
126287 91026 DPW Maintained 3 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 722 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
130200 239200 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 26 Back Yard : Yard 13 Tree 1 Private 1     2     6005967.71166 2108818.2564 37.7707504909794 -122.422716526767 (37.7707504909794, -122.422716526767)
130504 114204 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 310 Carolina St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6012281.598730001 2106430.0070700003 37.764547101481 -122.40070873583599 (37.764547101481, -122.400708735836)
131357 239215 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 5 Back Yard : Yard 13 Tree 1 Private 1     2     6005849.76837 2108994.2700400003 37.77122712717 -122.423137008381 (37.77122712717, -122.423137008381)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 78.416ms · Data source: data.sfgov.org