203 rows where qSpecies_id = 39 sorted by TreeID

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)
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
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
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
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
89830 102104 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 705X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52427 6009386 2110546 37.7756867379095 -122.411014612047 (37.7756867379095, -122.411014612047) 8 2 9 28853 34
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
176681 102170 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 270 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 3 3x3   6001983.1 2104294.8 37.7581045689631 -122.436175590041 (37.7581045689631, -122.436175590041) 2 4 5 28862 3
140365 102175 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 484 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769767 5999426.4 2104189.2 37.7576690270565 -122.445010134311 (37.7576690270565, -122.445010134311) 2 5 5 28862 3
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
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
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
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
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
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
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
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
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
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
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
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
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
7169 114201 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 310 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012278.4302 2106502.4698 37.7647458912325 -122.40072478603 (37.7647458912325, -122.40072478603) 14 3 8 28856 29
108073 114202 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 310 Carolina St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6012278.21126 2106491.69166 37.7647162846561 -122.400724786045 (37.7647162846561, -122.400724786045) 14 3 8 28856 29
127840 114203 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 310 Carolina St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6012282.10678 2106442.32004 37.7645809384837 -122.400707843686 (37.7645809384837, -122.400707843686) 14 3 8 28856 29
38627 114204 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 310 Carolina St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012281.59873 2106430.00707 37.764547101481 -122.400708735836 (37.764547101481, -122.400708735836) 14 3 8 28856 29
84108 114205 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 310 Carolina St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012283.24048 2106396.5985 37.7644554605731 -122.400700710264 (37.7644554605731, -122.400700710264) 14 3 8 28856 29
97965 116523 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2486 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5995798 2110374 37.7744431335528 -122.458006125331 (37.7744431335528, -122.458006125331) 11 6 2 54 16
51753 136188 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3598 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002648.6286 2120880.08452 37.8036813773578 -122.435060090577 (37.8036813773578, -122.435060090577) 13 9 1 57 17
89986 173654 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 118 06th St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010152 2112318 37.7805951592946 -122.408489839314 (37.7805951592946, -122.408489839314) 14 2 9 28853 34
32072 197024 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2 Waterloo St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6010624.95454 2097233.34103 37.7392025469594 -122.405790793937 (37.7392025469594, -122.405790793937) 10 3 8 58 1
136407 197025 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2 Waterloo St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6010590.71236 2097235.47599 37.7392064940954 -122.405909338939 (37.7392064940954, -122.405909338939) 10 3 8 58 1
62409 197026 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2 Waterloo St 3 : Tree Private 2     3 Width 4ft   6010467.19371 2097248.77404 37.7392360988707 -122.406337349712 (37.7392360988707, -122.406337349712) 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
154733 197028 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2 Waterloo St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010376.04785 2097256.74048 37.7392528739127 -122.406653054018 (37.7392528739127, -122.406653054018) 10 3 8 58 1
109559 197029 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1601 Kirkwood Ave 1 : Tree Private 2     4 Width 4ft   6015115.28126 2096786.01211 37.7382243660701 -122.390233889493 (37.7382243660701, -122.390233889493) 10 3 8 58 1
90422 197030 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1601 Kirkwood Ave 2 : Tree Private 2     4 Width 4ft   6015124.98776 2096779.46594 37.7382069300149 -122.390199871734 (37.7382069300149, -122.390199871734) 10 3 8 58 1
136712 197031 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1950 Donner Ave 1 : Tree Private 2     5 Width 3ft   6011564.47329 2093570.84173 37.729198590121 -122.402284901123 (37.729198590121, -122.402284901123) 10 3 8 58 1
89400 197032 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2425 Mendell St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6013410.89228 2092904.94236 37.7274730618297 -122.395854985916 (37.7274730618297, -122.395854985916) 10 3 8 58 1
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
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
158340 197035 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1751 Armstrong Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6013551.1098 2093063.74117 37.7279168907351 -122.395381369648 (37.7279168907351, -122.395381369648) 10 3 8 58 1
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
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
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
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
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
134355 22306 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 5015 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6014803.86419 2094824.41992 37.7328209559263 -122.39117354906 (37.7328209559263, -122.39117354906) 10 3 8 58 1
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
113549 239142 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 N Off Ramp 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6005875.43102 2109171.08438 37.7717140650818 -122.423060809714 (37.7717140650818, -122.423060809714) 8 2 9 28853 19
158390 239143 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 N Off Ramp 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6005870.17252 2109182.68749 37.771745627697 -122.423079824091 (37.771745627697, -122.423079824091) 8 2 9 28853 19
92434 239144 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 N Off Ramp 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6005864.04497 2109192.11891 37.7717711783282 -122.423101690202 (37.7717711783282, -122.423101690202) 8 2 9 28853 19
147541 239145 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 N Off Ramp 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6005859.0162 2109201.52808 37.7717967298683 -122.423119753987 (37.7717967298683, -122.423119753987) 8 2 9 28853 19
64177 239146 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 N Off Ramp 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6005853.9818 2109210.66322 37.7718215286672 -122.423137817777 (37.7718215286672, -122.423137817777) 8 2 9 28853 19
79147 239147 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Octavia St 11 : Tree Private 2     5 Width 6ft   6005750.76035 2109550.79453 37.7727496218289 -122.423519053867 (37.7727496218289, -122.423519053867) 7 9 11 28852 10
8531 239148 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Octavia St 12 : Tree Private 2     3 Width 6ft   6005748.59719 2109565.89201 37.7727909537754 -122.423527610038 (37.7727909537754, -122.423527610038) 7 9 11 28852 10
151092 239149 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Octavia St 13 : Tree Private 2     3 Width 6ft   6005748.02057 2109577.94621 37.7728240191579 -122.423530461786 (37.7728240191579, -122.423530461786) 7 9 11 28852 10
66871 239150 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 4ft   6005732.39027 2109686.64828 37.7731216065951 -122.4235922587 (37.7731216065951, -122.4235922587) 7 9 11 28852 10
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
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
160035 239155 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 150 Octavia St 7 : Tree Private 2     7 Width 4ft   6005700.01949 2109925.21059 37.7737748138817 -122.423721198991 (37.7737748138817, -122.423721198991) 7 9 11 28852 10
95826 239156 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Octavia St 4 : Tree Private 2     5 Width 4ft   6005612.49957 2109700.10187 37.7731517788755 -122.42400793342 (37.7731517788755, -122.42400793342) 7 9 11 28852 10
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
145499 239158 Undocumented 4 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Octavia St 6 : Tree Private 2     4 Width 4ft   6005617.18186 2109670.50026 37.7730707643493 -122.423989631326 (37.7730707643493, -122.423989631326) 7 9 11 28852 10
146783 239159 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6010593.731 2101386.95157 37.7506057130911 -122.406191312392 (37.7506057130911, -122.406191312392) 10 4 7 28859 19
50302 239160 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010602.41193 2101365.81223 37.7505481546786 -122.406159803726 (37.7505481546786, -122.406159803726) 10 4 7 28859 19
108064 239161 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010627.47447 2101300.53615 37.7503703227358 -122.406068536926 (37.7503703227358, -122.406068536926) 10 4 7 28859 19
5839 239162 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010646.64467 2101254.46555 37.7502448951922 -122.405998999548 (37.7502448951922, -122.405998999548) 10 4 7 28859 19
148467 239163 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010654.95431 2101230.51738 37.7501796035287 -122.405968577287 (37.7501796035287, -122.405968577287) 10 4 7 28859 19
122690 239164 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010663.94961 2101209.37133 37.7501220442103 -122.405935981386 (37.7501220442103, -122.405935981386) 10 4 7 28859 19
93804 239165 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010673.44533 2101181.95766 37.7500473033606 -122.405901213588 (37.7500473033606, -122.405901213588) 10 4 7 28859 19
40978 239166 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010684.29962 2101159.52227 37.749986307743 -122.405862098468 (37.749986307743, -122.405862098468) 10 4 7 28859 19
50006 239167 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010693.26923 2101137.12494 37.7499253112163 -122.405829503442 (37.7499253112163, -122.405829503442) 10 4 7 28859 19
120944 239168 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010702.84807 2101113.77684 37.7498617381444 -122.40579473475 (37.7498617381444, -122.40579473475) 10 4 7 28859 19
104140 239169 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010720.15958 2101068.99531 37.7497397459909 -122.405731716554 (37.7497397459909, -122.405731716554) 10 4 7 28859 19
55996 239170 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010748.55016 2100997.3935 37.7495447307243 -122.405628497759 (37.7495447307243, -122.405628497759) 10 4 7 28859 19
69789 239171 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 20 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010775.13287 2100929.58266 37.7493600234457 -122.405531798154 (37.7493600234457, -122.405531798154) 10 4 7 28859 19
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
76680 239173 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3705 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005734.96606 2101372.66505 37.7502935116564 -122.422992320041 (37.7502935116564, -122.422992320041) 2 4 5 28859 19
68141 239174 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1714 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005940.64905 2107290.54233 37.7665542255162 -122.422701553932 (37.7665542255162, -122.422701553932) 8 4 5 28853 19
128429 239175 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1742 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005792.61573 2107282.25816 37.7665231260736 -122.423212986701 (37.7665231260736, -122.423212986701) 8 4 5 28853 19
110773 239176 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1748 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005773.30835 2107281.96849 37.7665212410869 -122.423279746972 (37.7665212410869, -122.423279746972) 8 4 5 28853 19
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
100905 239178 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 370 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006302.56864 2107899.15692 37.7682457495759 -122.421492964039 (37.7682457495759, -122.421492964039) 8 4 7 28853 19
44677 239179 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 370 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006290.70185 2107898.44552 37.7682431271357 -122.421533959636 (37.7682431271357, -122.421533959636) 8 4 7 28853 19
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
75767 239181 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 380 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006215.67613 2107893.94566 37.7682265409602 -122.42179314696 (37.7682265409602, -122.42179314696) 8 4 7 28853 19
72149 239182 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3599 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005021.22782 2106010.41037 37.7629873721785 -122.425790544398 (37.7629873721785, -122.425790544398) 8 4 5 28859 19
130061 239183 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 720 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007476.35772 2105397.09343 37.761441780224 -122.41725560676 (37.761441780224, -122.41725560676) 2 4 7 28859 19
142290 239184 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 754 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007487.61608 2105246.87358 37.7610299446873 -122.417206023563 (37.7610299446873, -122.417206023563) 2 4 7 28859 19
19695 239185 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 483 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007463.11739 2106828.6922 37.7653718724361 -122.417402858182 (37.7653718724361, -122.417402858182) 8 4 7 28853 19
92109 239186 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 483 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007463.67946 2106844.52399 37.7654153744566 -122.417402036177 (37.7654153744566, -122.417402036177) 8 4 7 28853 19
101161 239187 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 483 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007459.99284 2106907.97241 37.7655893815639 -122.417419284297 (37.7655893815639, -122.417419284297) 8 4 7 28853 19
140596 239188 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1300 San Jose Ave 40 Sidewalk: Property side : Yard Tree Private 2     1     6003390.53226 2095588.92552 37.7342801275185 -122.430686848418 (37.7342801275185, -122.430686848418) 2 7 5 63 7
155722 239189 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 1 Back Yard : Yard Tree Private 2     3     6005983.85034 2108958.28367 37.7711358828561 -122.422670655046 (37.7711358828561, -122.422670655046) 8 2 9 28853 19
82493 239190 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 2 Back Yard : Yard Tree Private 2     4     6005977.0875 2108970.19311 37.7711682017725 -122.422694894458 (37.7711682017725, -122.422694894458) 8 2 9 28853 19
158561 239191 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 3 Back Yard : Yard Tree Private 2     6     6005967.76325 2108980.83852 37.7711969054453 -122.422727904078 (37.7711969054453, -122.422727904078) 8 2 9 28853 19

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