Street_Tree_List

Data source: data.sfgov.org

201 rows where qSpecies = 147 sorted by Longitude

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
137006 92251 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1422 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 0 3x3 Permit Number 52700 5985614.2 2105517.7 37.7605187222406 -122.492875546543 (37.7605187222406, -122.492875546543)
83586 82094 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 356 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/2008 12:00:00 AM   3x3 Permit Number 50622 5991881.95379836 2113031.51992267 37.7815141826847 -122.471746056837 (37.7815141826847, -122.471746056837)
77703 92591 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 445 Wawona St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
88388 92590 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 445 Wawona St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
92650 92593 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 445 Wawona St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
94797 92592 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 445 Wawona St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
64157 65681 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 345 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/03/2011 12:00:00 AM 3   Permit Number 767215 5993370.6959 2113311.72647 37.782369577363 -122.466616141073 (37.782369577363, -122.466616141073)
160537 95602 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 345 08th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/27/2012 12:00:00 AM 2 3x3 Permit Number 769429 5993373.11205 2113255.69639 37.782215873424605 -122.46660370840799 (37.7822158734246, -122.466603708408)
116134 95702 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 231 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2011 12:00:00 AM   3x3 Permit Number 767451 5995312.0 2091520.8 37.7226490447139 -122.45832239069401 (37.7226490447139, -122.458322390694)
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)
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)
111579 102175 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 484 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769767 5999426.4 2104189.2 37.7576690270565 -122.445010134311 (37.7576690270565, -122.445010134311)
88534 87950 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 263a States St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50972 6000485.0 2106698.0 37.764617936044104 -122.441529100685 (37.7646179360441, -122.441529100685)
87027 95700 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Arbor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805.0 2096722.0 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043)
124327 95701 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Arbor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805.0 2096722.0 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043)
143949 102170 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 270 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/31/2012 12:00:00 AM 3 3x3   6001983.1 2104294.8 37.758104568963105 -122.436175590041 (37.7581045689631, -122.436175590041)
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)
92280 84670 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 4089 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6002616.95424138 2101785.02656585 37.7512493217958 -122.433804069341 (37.7512493217958, -122.433804069341)
115213 61801 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 564 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/2009 12:00:00 AM   3x3 Permit Number 52595 6003001.78864481 2108933.54346304 37.77089925742521 -122.43298393769501 (37.7708992574252, -122.432983937695)
86443 84663 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 4023 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003022.50968447 2101807.41144942 37.7513337904703 -122.43240321347 (37.7513337904703, -122.43240321347)
86387 87768 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 200 Beacon St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50472 6003134.0 2097619.0 37.739839710176895 -122.431718656253 (37.7398397101769, -122.431718656253)
101642 87767 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 200 Beacon St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50472 6003134.0 2097619.0 37.739839710176895 -122.431718656253 (37.7398397101769, -122.431718656253)
93008 84571 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3991 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003245.44934651 2101819.71675357 37.7513802170554 -122.43163314148701 (37.7513802170554, -122.431633141487)
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)
144224 102120 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3906 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003747.7 2101944.5 37.751751298202 -122.429905200436 (37.751751298202, -122.429905200436)
141229 61618 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3904 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003796.89718088 2101902.23350187 37.7516380302781 -122.42973205570101 (37.7516380302781, -122.429732055701)
155009 239231 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 391 Church St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004225.7038199995 2106680.81705 37.764783160934 -122.42858977959699 (37.764783160934, -122.428589779597)
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)
176100 239229 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 391 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004228.5151 2106643.84143 37.764681793855 -122.42857742022899 (37.764681793855, -122.428577420229)
100212 80773 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 317 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767266 6004338.6764807 2102152.37621846 37.7523555276075 -122.427876335011 (37.7523555276075, -122.427876335011)
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)
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)
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)
176214 239157 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Octavia St 5 : 4 Tree 1 Private 1     3 Width 4ft   6005616.09638 2109686.3289099997 37.7731141647188 -122.423994511963 (37.7731141647188, -122.423994511963)
163715 239158 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Octavia St 6 : 4 Tree 1 Private 1     4 Width 4ft   6005617.18186 2109670.5002599997 37.7730707643493 -122.42398963132601 (37.7730707643493, -122.423989631326)
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)
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)
176639 239153 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 150 Octavia St 5 : 4 Tree 1 Private 1     3 Width 4ft   6005703.32038 2109897.0428299997 37.773697658347395 -122.423707777507 (37.7736976583474, -122.423707777507)
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)
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)
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)
175455 239148 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 8 Octavia St 12 : 4 Tree 1 Private 1     3 Width 6ft   6005748.59719 2109565.89201 37.7727909537754 -122.423527610038 (37.7727909537754, -122.423527610038)
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)
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)
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)
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)
163838 239218 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 1 Back Yard : Yard 13 Tree 1 Private 1     3 Width 10ft   6005833.18575 2109028.0269 37.771318879598105 -122.423196768328 (37.7713188795981, -122.423196768328)
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)
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)
165954 239146 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 N Off Ramp 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6005853.9818 2109210.66322 37.7718215286672 -122.423137817777 (37.7718215286672, -122.423137817777)
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)
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)
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)
164504 239144 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 N Off Ramp 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6005864.044969999 2109192.1189099997 37.7717711783282 -122.423101690202 (37.7717711783282, -122.423101690202)
149080 239213 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 8 Back Yard : Yard 13 Tree 1 Private 1     5     6005865.35862 2108965.54677 37.771149139741 -122.423081039068 (37.771149139741, -122.423081039068)
168071 239143 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 N Off Ramp 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6005870.17252 2109182.68749 37.771745627697 -122.42307982409099 (37.771745627697, -122.423079824091)
137308 239142 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 N Off Ramp 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6005875.43102 2109171.08438 37.771714065081795 -122.42306080971399 (37.7717140650818, -122.423060809714)
152126 239212 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 9 Back Yard : Yard 13 Tree 1 Private 1     6     6005873.5433 2108954.58543 37.7711195043932 -122.42305194869301 (37.7711195043932, -122.423051948693)
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)
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)
170487 239210 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 13 Back Yard : Yard 13 Tree 1 Private 1     3     6005891.00584 2108925.69957 37.771041176138795 -122.422989491673 (37.7710411761388, -122.422989491673)
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)
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)
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)
166869 239197 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 9 Back Yard : Yard 13 Tree 1 Private 1     4     6005924.85036 2109052.04357 37.7713899961886 -122.42288140308001 (37.7713899961886, -122.42288140308)
186175 239207 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 18 Back Yard : Yard 13 Tree 1 Private 1     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387)
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)
183663 239206 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 19 Back Yard : Yard 13 Tree 1 Private 1     3     6005929.117819999 2108865.00797 37.7708766820544 -122.42285334689899 (37.7708766820544, -122.422853346899)
133557 239195 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 7 Back Yard : Yard 13 Tree 1 Private 1     3     6005938.2626 2109031.33623 37.77133389557179 -122.422833537536 (37.7713338955718, -122.422833537536)
158664 239205 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 20 Back Yard : Yard 13 Tree 1 Private 1     2     6005934.94283 2108857.8407799997 37.7708573313359 -122.422832688574 (37.7708573313359, -122.422832688574)
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)
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)
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)
168811 239193 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 5 Back Yard : Yard 13 Tree 1 Private 1     5     6005953.87409 2109001.5556400004 37.771253006051296 -122.42277741983801 (37.7712530060513, -122.422777419838)
180826 239202 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 24 Back Yard : Yard 13 Tree 1 Private 1     2     6005953.73874 2108834.81297 37.7707951629947 -122.422766036225 (37.7707951629947, -122.422766036225)
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)
133851 239201 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 25 Back Yard : Yard 13 Tree 1 Private 1     3     6005958.49088 2108828.3343599997 37.7707776424043 -122.422749137971 (37.7707776424043, -122.422749137971)
160902 239191 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 3 Back Yard : Yard 13 Tree 1 Private 1     6     6005967.76325 2108980.83852 37.7711969054453 -122.422727904078 (37.7711969054453, -122.422727904078)
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)
154336 239174 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1714 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6005940.64905 2107290.54233 37.7665542255162 -122.422701553932 (37.7665542255162, -122.422701553932)
187735 239190 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 2 Back Yard : Yard 13 Tree 1 Private 1     4     6005977.0875 2108970.19311 37.7711682017725 -122.422694894458 (37.7711682017725, -122.422694894458)
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)
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)
144980 102100 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 234 Linden St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     6   6006253.0 2110945.0 37.776606109637896 -122.42188080245899 (37.7766061096379, -122.421880802459)
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)
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)
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)
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)
82949 55657 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 349 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2009 12:00:00 AM   3x3 Permit Number 52575 6006153.21523754 2098012.87204699 37.7410918742968 -122.421307424196 (37.7410918742968, -122.421307424196)
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)
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)
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)
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)
141400 43127 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 8 Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/14/2009 12:00:00 AM   3x3 Permit Number 52578 6007298.20406204 2099606.09068899 37.745530983588296 -122.417461342572 (37.7455309835883, -122.417461342572)
81444 101926 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1099X Hyde St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
143550 101925 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1099X Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
144056 101924 Section 143 8 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1099X Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
167071 239187 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 483 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007459.99284 2106907.97241 37.7655893815639 -122.41741928429701 (37.7655893815639, -122.417419284297)
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)
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)

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 91.715ms · Data source: data.sfgov.org