203 rows where qSpecies_id = 39 sorted by PlantDate

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)
160955 22295 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 4910 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6014801.71028 2095185.44595 37.7338121405587 -122.391206222681 (37.7338121405587, -122.391206222681) 10 3 8 58 1
161495 239172 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 66 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005143.16857 2105759.69419 37.7623058551435 -122.425350950383 (37.7623058551435, -122.425350950383) 8 4 5 28859 19
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
164043 239217 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 2 Back Yard : Yard Tree Private 2     4     6005837.81281 2109017.0594 37.7712890265976 -122.423179983379 (37.7712890265976, -122.423179983379) 8 2 5 28853 19
164569 239180 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 370 14th St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006264.72566 2107896.23328 37.7682355881421 -122.421623651723 (37.7682355881421, -122.421623651723) 8 4 7 28853 19
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
167653 239153 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 150 Octavia St 5 : Tree Private 2     3 Width 4ft   6005703.32038 2109897.04283 37.7736976583474 -122.423707777507 (37.7736976583474, -122.423707777507) 7 9 11 28852 10
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
168668 22304 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 5012X 03rd St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6014702.6472 2094891.22359 37.7329987676998 -122.391528153423 (37.7329987676998, -122.391528153423) 10 3 8 58 1
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
171926 197027 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2 Waterloo St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6010417.49048 2097253.73995 37.7392469536854 -122.406509551872 (37.7392469536854, -122.406509551872) 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
177062 239213 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 8 Back Yard : Yard Tree Private 2     5     6005865.35862 2108965.54677 37.771149139741 -122.423081039068 (37.771149139741, -122.423081039068) 8 2 5 28853 19
179552 217747 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 625 Frederick St 1 : Tree Private 2     4 Width 3ft   5996570.53056 2107292.29818 37.7660259340648 -122.455111074526 (37.7660259340648, -122.455111074526) 15 5 11 29492 12
181021 239152 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Octavia St 3 : Tree Private 2     4 Width 4ft   6005729.11778 2109714.63204 37.7731982585339 -122.423605568636 (37.7731982585339, -122.423605568636) 7 9 11 28852 10
181276 239216 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 3 Back Yard : Yard Tree Private 2     5     6005843.54322 2109006.73444 37.7712610001205 -122.423159427585 (37.7712610001205, -122.423159427585) 8 2 5 28853 19
183553 239194 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 6 Back Yard : Yard Tree Private 2     3     6005943.75173 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768) 8 2 9 28853 19
185872 239203 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 22 Back Yard : Yard Tree Private 2     3     6005946.44181 2108844.1649 37.7708204294492 -122.422791941214 (37.7708204294492, -122.422791941214) 8 2 5 28853 19
186345 239157 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Octavia St 5 : Tree Private 2     3 Width 4ft   6005616.09638 2109686.32891 37.7731141647188 -122.423994511963 (37.7731141647188, -122.423994511963) 7 9 11 28852 10
189710 102100 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 234 Linden St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     6   6006253 2110945 37.7766061096379 -122.421880802459 (37.7766061096379, -122.421880802459) 7 9 11 28852 10
190063 197036 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1751 Armstrong Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6013567.34491 2093051.01085 37.7278828388179 -122.395324352636 (37.7278828388179, -122.395324352636) 10 3 8 58 1
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                    
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
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
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
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
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
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
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
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
41644 109948 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 8 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
86051 109944 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 4 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
86412 109945 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 5 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
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
108791 109943 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 3 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
118512 109946 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 6 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
145260 109947 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 7 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
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
192360 109949 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 9 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
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
84045 22308 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 5033 03rd St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2000 12:00:00 AM 3 3x3   6014806.84876 2094754.47288 37.7326290611665 -122.391158343086 (37.7326290611665, -122.391158343086) 10 3 8 58 1
160735 22383 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1799X Armstrong Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM 2 4x15   6013476.603 2093118.78047 37.7280638732384 -122.395642798073 (37.7280638732384, -122.395642798073) 10 3 8 58 1
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
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
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
75 74661 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 3 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
33330 74507 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 4 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
45170 82942 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 236 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52427 6009386 2110546 37.7756867379095 -122.411014612047 (37.7756867379095, -122.411014612047) 8 2 9 28853 34
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
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
77415 82832 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 4 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
90304 82833 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 3 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
107619 82834 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
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
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
189471 51377 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 356 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52402 6008497.808835 2108622.2239572 37.7703546548295 -122.413950975697 (37.7703546548295, -122.413950975697) 8 2 9 28853 19
11021 82786 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1910-12 Keith St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52461 6015243.83790646 2093539.28137109 37.7293166303851 -122.389562713545 (37.7293166303851, -122.389562713545) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
26213 94767 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 10X Waterloo St 5 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
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
78671 94764 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 10X Waterloo St 3 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
169431 94765 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 10X Waterloo St 4 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
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
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
28633 91022 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 140 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317) 8 2 9 28853 19
43599 91027 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 722 South Van Ness Ave 3 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
68681 91025 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 140 South Van Ness Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317) 8 2 9 28853 19
114763 91023 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 140 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317) 8 2 9 28853 19
138365 91024 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 140 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317) 8 2 9 28853 19
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
146320 91028 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 722 South Van Ness Ave 4 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
2327 108056 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 535X Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.398292953274 (37.7889890532579, -122.398292953274) 12 2 9 28855 6
99478 108058 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 535X Mission St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.398292953274 (37.7889890532579, -122.398292953274) 12 2 9 28855 6
122986 108055 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 535X Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.398292953274 (37.7889890532579, -122.398292953274) 12 2 9 28855 6
128643 108057 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 535X Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.398292953274 (37.7889890532579, -122.398292953274) 12 2 9 28855 6
157456 95602 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 345 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2012 12:00:00 AM 2 3x3 Permit Number 769429 5993373.11205 2113255.69639 37.7822158734246 -122.466603708408 (37.7822158734246, -122.466603708408) 11 6 2 54 11
41083 101926 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 3 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
184745 101925 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 2 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
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
119193 39176 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 754 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2009 12:00:00 AM     Permit Number 53085 6007474 2105260 37.7610652207705 -122.417254045994 (37.7610652207705, -122.417254045994) 2 4 7 28859 19
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
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
117785 82259 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 850 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2011 12:00:00 AM 3 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.7595448304107 -122.417037358657 (37.7595448304107, -122.417037358657) 2 4 7 28859 19
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
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
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
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

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