trees

203 rows where qSpecies_id = 39 sorted by Supervisor Districts descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
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
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
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
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
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
32860 239195 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 7 Back Yard : Yard Tree Private 2     3     6005938.2626 2109031.33623 37.7713338955718 -122.422833537536 (37.7713338955718, -122.422833537536) 8 2 9 28853 19
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
34587 239198 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 10 Back Yard : Yard Tree Private 2     3     6005918.91365 2109064.99496 37.7714252226197 -122.422902859103 (37.7714252226197, -122.422902859103) 8 2 9 28853 19
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
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
59502 239192 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 4 Back Yard : Yard Tree Private 2     6     6005960.35629 2108991.91912 37.7712269122118 -122.422754312663 (37.7712269122118, -122.422754312663) 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
68296 239193 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 5 Back Yard : Yard Tree Private 2     5     6005953.87409 2109001.55564 37.7712530060513 -122.422777419838 (37.7712530060513, -122.422777419838) 8 2 9 28853 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
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
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
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
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
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
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
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
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
96285 239196 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 8 Back Yard : Yard Tree Private 2     3     6005930.84591 2109041.94212 37.771362598325 -122.422859946125 (37.771362598325, -122.422859946125) 8 2 9 28853 19
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
99552 239197 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 9 Back Yard : Yard Tree Private 2     4     6005924.85036 2109052.04357 37.7713899961886 -122.42288140308 (37.7713899961886, -122.42288140308) 8 2 9 28853 19
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
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
108986 249356 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 625 Leavenworth St 2 : Tree Private 2     2 Width 3ft   6008325.07213 2114654.93665 37.7869093422284 -122.414975526796 (37.7869093422284, -122.414975526796) 13 1 9 28858 36
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
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
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
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
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
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
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
145625 249388 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 301 Eddy St 3 : Tree Private 2     5 Width 3ft   6008934.66326 2113525.78003 37.7838431855658 -122.412786614726 (37.7838431855658, -122.412786614726) 7 10 9 28852 36
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
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
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
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
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
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
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
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
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
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
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
32072 197024 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2 Waterloo St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6010624.95454 2097233.34103 37.7392025469594 -122.405790793937 (37.7392025469594, -122.405790793937) 10 3 8 58 1
37418 92866 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 4800 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6014889.77806 2095498.93005 37.7346777911521 -122.390923645427 (37.7346777911521, -122.390923645427) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
118616 95059 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 5115X 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6014711.63884 2094587.79956 37.7321661259618 -122.391475861678 (37.7321661259618, -122.391475861678) 10 3 8 58 1
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
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
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
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
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
156139 95060 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 5033 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6014806.53085 2094754.47288 37.7326290435242 -122.391159442188 (37.7326290435242, -122.391159442188) 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
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
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
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
162569 197034 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1777 Armstrong Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6013492.1426 2093105.49396 37.7280282555765 -122.395588146293 (37.7280282555765, -122.395588146293) 10 3 8 58 1
162768 197037 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 176 Maddux Ave 1 : Tree Private 2     2 Width 3ft   6012326.10159 2094826.65316 37.7326892735933 -122.399740013104 (37.7326892735933, -122.399740013104) 10 3 8 58 1
167251 95064 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 4849X 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6014989.6 2095442.3 37.734527834908 -122.390574568357 (37.734527834908, -122.390574568357) 10 3 8 58 1
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
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
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
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
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
19695 239185 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 483 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007463.11739 2106828.6922 37.7653718724361 -122.417402858182 (37.7653718724361, -122.417402858182) 8 4 7 28853 19
20785 239226 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2851 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010136.75438 2101030.89604 37.7496024914637 -122.407746478521 (37.7496024914637, -122.407746478521) 2 4 7 28859 19
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
29978 239221 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2810 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6010295.22869 2101085.95879 37.7497625519161 -122.407202347334 (37.7497625519161, -122.407202347334) 2 4 7 28859 19
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
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
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
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
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
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
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
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
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

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