trees

203 rows where qSpecies_id = 39 sorted by Zip Codes

✎ 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)
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                    
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
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
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
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
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
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
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
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
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
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
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
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
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
2114 239212 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 9 Back Yard : Yard Tree Private 2     6     6005873.5433 2108954.58543 37.7711195043932 -122.423051948693 (37.7711195043932, -122.423051948693) 8 2 5 28853 19
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
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
20572 239214 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 7 Back Yard : Yard Tree Private 2     6     6005859.14445 2108978.35649 37.7711839614881 -122.423103444792 (37.7711839614881, -122.423103444792) 8 2 5 28853 19
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
37443 239209 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 14 Back Yard : Yard Tree Private 2     2     6005896.87599 2108918.25042 37.7710210537973 -122.422968657083 (37.7710210537973, -122.422968657083) 8 2 5 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
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
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
62925 239202 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 24 Back Yard : Yard Tree Private 2     2     6005953.73874 2108834.81297 37.7707951629947 -122.422766036225 (37.7707951629947, -122.422766036225) 8 2 5 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
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
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
75236 239200 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 26 Back Yard : Yard Tree Private 2     2     6005967.71166 2108818.2564 37.7707504909794 -122.422716526767 (37.7707504909794, -122.422716526767) 8 2 5 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
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
82233 239207 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 18 Back Yard : Yard Tree Private 2     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387) 8 2 5 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
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
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
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
93180 239210 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 13 Back Yard : Yard Tree Private 2     3     6005891.00584 2108925.69957 37.7710411761388 -122.422989491673 (37.7710411761388, -122.422989491673) 8 2 5 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
97127 239204 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 21 Back Yard : Yard Tree Private 2     4     6005940.87649 2108850.78599 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426) 8 2 5 28853 19
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
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
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
104718 239205 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 20 Back Yard : Yard Tree Private 2     2     6005934.94283 2108857.84078 37.7708573313359 -122.422832688574 (37.7708573313359, -122.422832688574) 8 2 5 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
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
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
125140 239208 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 17 Back Yard : Yard Tree Private 2     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484) 8 2 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
131784 239206 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 19 Back Yard : Yard Tree Private 2     3     6005929.11782 2108865.00797 37.7708766820544 -122.422853346899 (37.7708766820544, -122.422853346899) 8 2 5 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
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
146007 239211 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 11 Back Yard : Yard Tree Private 2     5     6005882.93751 2108938.64172 37.7710762568972 -122.423018320345 (37.7710762568972, -122.423018320345) 8 2 5 28853 19
147055 239199 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 27 Back Yard : Yard Tree Private 2     2     6005974.4493 2108807.19348 37.7707204949845 -122.422692434815 (37.7707204949845, -122.422692434815) 8 2 5 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
149090 239201 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 25 Back Yard : Yard Tree Private 2     3     6005958.49088 2108828.33436 37.7707776424043 -122.422749137971 (37.7707776424043, -122.422749137971) 8 2 5 28853 19
155107 239215 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 5 Back Yard : Yard Tree Private 2     2     6005849.76837 2108994.27004 37.77122712717 -122.423137008381 (37.77122712717, -122.423137008381) 8 2 5 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
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
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
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
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
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
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
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
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
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
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
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
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
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

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