Street_Tree_List

Data source: data.sfgov.org

1,925 rows where qSpecies = 82 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
166225 166225 197126 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 31 Apparel Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   6011547.9677099995 2097644.33103 37.7403826130582 -122.402628305469 (37.7403826130582, -122.402628305469)
176735 176735 197125 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 31 Apparel Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   6011537.38847 2097577.661 37.7401989607078 -122.402660197209 (37.7401989607078, -122.402660197209)
652 652 237023 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 8 Octavia St 4 : 4 Tree 1 DPW 2   04/15/2017 01:44:00 PM 3 Width 6ft   6005765.01716 2109438.39176 37.7724417955802 -122.423461745458 (37.7724417955802, -122.423461745458)
661 661 237024 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 8 Octavia St 5 : 4 Tree 1 DPW 2   04/15/2017 01:48:00 PM 3 Width 6ft   6005763.84021 2109451.72322 37.772478334130994 -122.423466764586 (37.772478334131, -122.423466764586)
663 663 237022 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 8 Octavia St 3 : 4 Tree 1 DPW 2   04/15/2017 01:40:00 PM 3 Width 6ft   6005770.133230001 2109412.50366 37.772371001847 -122.423442207693 (37.772371001847, -122.423442207693)
666 666 237028 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 8 Octavia St 9 : 4 Tree 1 DPW 2   04/15/2017 01:55:00 PM 3 Width 6ft   6005756.39315 2109517.28856 37.7726579404383 -122.423497186858 (37.7726579404383, -122.423497186858)
23930 23930 246508 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 241 Duncan St 1 : 4 Tree 1 Private 1     8 Width 6ft   6004932.15845 2099866.5422 37.7461127118493 -122.425661300149 (37.7461127118493, -122.425661300149)
28239 28239 120254 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 150 24th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988369.36546 2114920.76145 37.7864976459369 -122.4840363573 (37.7864976459369, -122.4840363573)
35422 35422 239293 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 936 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 6ft   6009925.69316 2103743.6378599997 37.757039258881 -122.40866768648199 (37.757039258881, -122.408667686482)
39213 39213 239316 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1100 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6010239.40016 2102763.26328 37.7543649341213 -122.407513645861 (37.7543649341213, -122.407513645861)
44437 44437 120251 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 160 24th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5988366.40775 2114885.43189 37.7864004688283 -122.48404399839899 (37.7864004688283, -122.484043998399)
46583 46583 246509 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 241 Duncan St 2 : 4 Tree 1 Private 1     7 Width 6ft   6004948.2324 2099866.59265 37.7461137586439 -122.425605722044 (37.7461137586439, -122.425605722044)
47047 47047 120253 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 150 24th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988369.64092 2114933.75275 37.7865333323848 -122.48403635730499 (37.7865333323848, -122.484036357305)
49709 49709 120248 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 164 24th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5988365.09621 2114861.46484 37.786334585774604 -122.484046777757 (37.7863345857746, -122.484046777757)
57808 57808 239297 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1444 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6010087.66472 2100841.4451200003 37.7490795527833 -122.407902875125 (37.7490795527833, -122.407902875125)
63345 63345 120250 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 164 24th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5988365.5517 2114845.05893 37.7862895663335 -122.484043998391 (37.7862895663335, -122.484043998391)
67599 67599 239294 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 936 York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6009927.4277099995 2103728.71332 37.756998376592 -122.408660634893 (37.756998376592, -122.408660634893)
77045 77045 120249 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 164 24th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5988365.91336 2114852.64965 37.786310429345704 -122.48404330399599 (37.7863104293457, -122.484043303996)
150852 150852 197141 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 502 Beale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6015667.2078 2114177.54158 37.786008361852396 -122.38953984758801 (37.7860083618524, -122.389539847588)
152901 152901 239239 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 101 Scott St 1 : 4 Tree 1 Private 1     20 Width 6ft   6002329.06188 2108869.34471 37.7706848027038 -122.435306320439 (37.7706848027038, -122.435306320439)
153635 153635 120255 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 150 24th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988367.99594 2114912.99225 37.7864762341937 -122.484040525506 (37.7864762341937, -122.484040525506)
165666 165666 179334 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1119 Athens St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   6001947.96661 2087712.00011 37.7125700310481 -122.43511106143801 (37.7125700310481, -122.435111061438)
166469 166469 239248 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 16 Tiffany Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 6ft   6006371.4941 2099835.91554 37.746109844791704 -122.420682079532 (37.7461098447917, -122.420682079532)
167538 167538 179336 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 225 Naylor St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   6002643.14283 2086748.99011 37.709965266168105 -122.43263957156 (37.7099652661681, -122.43263957156)
171035 171035 179335 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1119 Athens St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6001959.57443 2087726.76645 37.7126112352992 -122.435071996701 (37.7126112352992, -122.435071996701)
176550 176550 120252 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 160 24th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5988365.81555 2114876.44647 37.7863757629455 -122.484045388081 (37.7863757629455, -122.484045388081)
182440 182440 239295 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 942 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6009930.36914 2103706.31975 37.7569370536161 -122.408648882561 (37.7569370536161, -122.408648882561)
185144 185144 239317 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1100 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6010240.72628 2102744.15996 37.7543125548829 -122.407507713025 (37.7543125548829, -122.407507713025)
3810 3810 193325 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1398 Tennessee St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015584.15702 2102639.39931 37.754322548171395 -122.389021302106 (37.7543225481714, -122.389021302106)
3814 3814 193324 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1398 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015583.67362 2102658.4010900003 37.7543746962452 -122.38902430045499 (37.7543746962452, -122.389024300455)
3820 3820 193326 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1398 Tennessee St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015584.3745800005 2102621.5534900003 37.754273559383 -122.389019303814 (37.754273559383, -122.389019303814)
3825 3825 253557 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1398 Tennessee St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 5ft   6015583.67362 2102658.4010900003 37.7543746962452 -122.38902430045499 (37.7543746962452, -122.389024300455)
27161 27161 197088 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6014473.69906 2102184.6927400003 37.753012404101 -122.39282976818998 (37.753012404101, -122.39282976819)
30381 30381 197107 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1468 25th St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014386.38736 2102037.52751 37.7526034697945 -122.393121414743 (37.7526034697945, -122.393121414743)
36178 36178 197095 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6014479.30677 2102077.89395 37.7527194688438 -122.39280290452601 (37.7527194688438, -122.392802904526)
41596 41596 197086 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014471.44073 2102209.38753 37.7530800852958 -122.39283930551599 (37.7530800852958, -122.392839305516)
45418 45418 197094 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6014478.47867 2102089.9100099998 37.7527524163908 -122.392806608832 (37.7527524163908, -122.392806608832)
54800 54800 213913 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1205 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   5994820.88687 2107315.71116 37.7659896869053 -122.46116439324899 (37.7659896869053, -122.461164393249)
55248 55248 197103 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1468 25th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014438.05571 2102040.91433 37.7526156394141 -122.392942972153 (37.7526156394141, -122.392942972153)
62833 62833 197084 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014468.76337 2102245.03022 37.753177803814 -122.39285105782801 (37.753177803814, -122.392851057828)
68861 68861 197140 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 53 Pomona St 2 : 4 Tree 1 Private 1     3 Width 5ft   6014151.58684 2094423.9633799999 37.7316851643341 -122.39340063984 (37.7316851643341, -122.39340063984)
76745 76745 197102 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1468 25th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014466.67746 2102042.06403 37.752620386043205 -122.392844072804 (37.7526203860432, -122.392844072804)
134469 134469 197089 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6014473.51573 2102162.27258 37.7529508329366 -122.39282883379101 (37.7529508329366, -122.392828833791)
135920 135920 239291 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 876 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6009903.2471199995 2104137.06349 37.7581182600559 -122.408773069018 (37.7581182600559, -122.408773069018)
149097 149097 197092 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6014476.97343 2102121.40509 37.752838811567 -122.392814017467 (37.752838811567, -122.392814017467)
150197 150197 239308 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 8 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6005350.87512 2103602.95194 37.756395680627996 -122.42447915479099 (37.756395680628, -122.424479154791)
157085 157085 197085 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6014468.858580001 2102236.49554 37.7531543746906 -122.392850131521 (37.7531543746906, -122.392850131521)
157309 157309 197105 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1468 25th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6014414.64892 2102038.8947099997 37.752608793773796 -122.393023776248 (37.7526087937738, -122.393023776248)
160169 160169 197087 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6014472.10243 2102198.29911 37.753049675611 -122.39283624152 (37.753049675611, -122.39283624152)
160675 160675 213914 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1205 04th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   5994821.63869 2107263.01718 37.7658450462296 -122.46115797296999 (37.7658450462296, -122.46115797297)
168763 168763 213992 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 20 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6001188.39506 2095218.69175 37.733138545197704 -122.43827381338801 (37.7331385451977, -122.438273813388)
170402 170402 197083 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014468.24915 2102256.69833 37.7532098133945 -122.392853652369 (37.7532098133945, -122.392853652369)
171068 171068 197090 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6014474.311480001 2102148.65752 37.752913493081294 -122.39282512948 (37.7529134930813, -122.39282512948)
173902 173902 239309 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 8 Fair Oaks St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6005351.1495900005 2103566.74632 37.7562962839536 -122.42447563036801 (37.7562962839536, -122.424475630368)
178466 178466 197104 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1468 25th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014428.85484 2102039.8538900004 37.752612216591004 -122.392974716426 (37.752612216591, -122.392974716426)
178725 178725 197106 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1468 25th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6014394.04215 2102037.78794 37.752604610114005 -122.393094961165 (37.752604610114, -122.393094961165)
181135 181135 197093 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6014477.98301 2102105.11898 37.7527941494528 -122.392809386851 (37.7527941494528, -122.392809386851)
181973 181973 197091 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1098 Pennsylvania Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6014475.63706 2102134.7648099996 37.7528754202862 -122.39281957348601 (37.7528754202862, -122.392819573486)
185794 185794 239255 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 3445 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6006854.967180001 2100851.4733 37.7489255735681 -122.419082309695 (37.7489255735681, -122.419082309695)
665 665 239151 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 100 Octavia St 2 : 4 Tree 1 DPW 2   04/15/2017 01:58:00 PM 3 Width 4ft   6005731.03459 2109700.90805 37.7731606839629 -122.423597962203 (37.7731606839629, -122.423597962203)
22887 22887 120259 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 130 24th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5988369.32629 2115004.14379 37.7867265878172 -122.484042609601 (37.7867265878172, -122.484042609601)
23795 23795 239276 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 313 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6007404.6677 2107881.43658 37.768259172860105 -122.41767964611 (37.7682591728601, -122.41767964611)
25009 25009 197076 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1101 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6014915.77906 2102946.7050400004 37.7551292724085 -122.39135422264098 (37.7551292724085, -122.391354222641)
27334 27334 240136 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 277 27th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6004700.17371 2100146.19558 37.7468674642611 -122.426483383002 (37.7468674642611, -122.426483383002)
27916 27916 197079 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 690 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6015561.72583 2105828.91514 37.763079033783605 -122.389321587544 (37.7630790337836, -122.389321587544)
28029 28029 124413 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 3900 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5996133.62205 2115253.7929599998 37.787861027515895 -122.45719822521299 (37.7878610275159, -122.457198225213)
28183 28183 246963 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 238 Noe St 2 : 4 Tree 1 Private 1     8 Width 4ft   6002871.51875 2106887.2406200003 37.765273220394796 -122.433288301134 (37.7652732203948, -122.433288301134)
29178 29178 197081 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 690 18th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6015537.3565 2105827.07749 37.7630726369229 -122.389405745189 (37.7630726369229, -122.389405745189)
30856 30856 197169 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 2 Baldwin Ct 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6017690.0216 2093651.3665 37.7297597257339 -122.38111373781 (37.7297597257339, -122.38111373781)
31164 31164 240161 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 504 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5998591.56873 2106281.83073 37.7633671855679 -122.448047979048 (37.7633671855679, -122.448047979048)
32581 32581 197122 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 2 Napoleon St 4 : 4 Tree 1 Private 1     5 Width 4ft   6013973.73168 2100142.08459 37.747376054258105 -122.394415755007 (37.7473760542581, -122.394415755007)
34091 34091 197124 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 2 Napoleon St 12 : 4 Tree 1 Private 1     3 Width 4ft   6013733.0286 2100130.5529400003 37.747331007214896 -122.395247287949 (37.7473310072149, -122.395247287949)
35019 35019 239374 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 3517 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6004914.04474 2103668.95392 37.7565522283139 -122.425994566404 (37.7565522283139, -122.425994566404)
36045 36045 213990 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 380 Kingston St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5994010.049330001 2099244.86467 37.743782519860794 -122.46338315652099 (37.7437825198608, -122.463383156521)
38003 38003 136244 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1747 Clay St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006363.52762 2116626.5882200003 37.7922125885856 -122.42190214028099 (37.7922125885856, -122.421902140281)
39329 39329 213917 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1651 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5992756.585530001 2104219.0263799997 37.7573679916487 -122.46807905201 (37.7573679916487, -122.46807905201)
40754 40754 247569 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 326 Alemany Blvd 1 : 4 Tree 1 Private 1     4 Width 4ft   6008658.24946 2095385.97007 37.7340198862064 -122.41246025166299 (37.7340198862064, -122.412460251663)
41009 41009 239260 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 455 Fair Oaks St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6005530.51021 2101066.0904 37.7494401890135 -122.42367754770001 (37.7494401890135, -122.4236775477)
44044 44044 197100 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 372 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6014303.71981 2105387.22588 37.7617964269902 -122.393641721993 (37.7617964269902, -122.393641721993)
44172 44172 247564 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 316 Alemany Blvd 2 : 4 Tree 1 Private 1     7 Width 4ft   6008777.64172 2095456.26862 37.7342196103425 -122.412052440585 (37.7342196103425, -122.412052440585)
44291 44291 247563 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 316 Alemany Blvd 1 : 4 Tree 1 Private 1     5 Width 4ft   6008788.9631 2095462.99791 37.734238722726495 -122.41201377422199 (37.7342387227265, -122.412013774222)
45516 45516 117917 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 767 41st Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   5983194.46177 2110567.54263 37.7742423451733 -122.501617774429 (37.7742423451733, -122.501617774429)
49555 49555 120257 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 140 24th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5988368.87318 2114954.3645200003 37.786589881739104 -122.484040525506 (37.7865898817391, -122.484040525506)
50543 50543 239266 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 181 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6007450.5138 2107918.2957099997 37.7683629591168 -122.417523681168 (37.7683629591168, -122.417523681168)
51939 51939 240155 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 505 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5998561.12995 2106238.99269 37.7632478230497 -122.448150171714 (37.7632478230497, -122.448150171714)
52692 52692 240154 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 568 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   5998646.15561 2105899.30537 37.76231998711071 -122.44783164083799 (37.7623199871107, -122.447831640838)
53362 53362 136246 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1723 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6006533.72276 2116650.00017 37.7922864687885 -122.421314924346 (37.7922864687885, -122.421314924346)
54424 54424 197151 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 99 Whitney Young Cir 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6016637.91847 2095129.63156 37.7337606161438 -122.384853953468 (37.7337606161438, -122.384853953468)
55551 55551 197118 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 301 Texas St 1 : 4 Tree 1 Private 1     16 Width 4ft   6013784.73559 2105658.04133 37.7625111748734 -122.39545566804199 (37.7625111748734, -122.395455668042)
56601 56601 240163 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 499 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5998551.61498 2106310.67674 37.7634441054949 -122.448188242691 (37.7634441054949, -122.448188242691)
57487 57487 240150 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1537 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998310.40334 2105182.48783 37.760332589688 -122.448941239673 (37.760332589688, -122.448941239673)
59141 59141 240169 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 204 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5998975.98045 2106976.10403 37.7652954525443 -122.446768387673 (37.7652954525443, -122.446768387673)
59697 59697 240149 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1515 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998302.63561 2105242.38335 37.7604966035517 -122.448972419165 (37.7604966035517, -122.448972419165)
60831 60831 247567 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 320 Alemany Blvd 1 : 4 Tree 1 Private 1     6 Width 4ft   6008730.40268 2095427.8255 37.7341388611064 -122.412213751984 (37.7341388611064, -122.412213751984)
63053 63053 240137 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 466 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6003486.65901 2100127.7633700003 37.7467481782042 -122.43067828687201 (37.7467481782042, -122.430678286872)
63717 63717 240167 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 955 Clayton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998784.85204 2106603.32437 37.764260973182395 -122.44740261924 (37.7642609731824, -122.44740261924)
64389 64389 197077 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1101 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6014934.55258 2102947.77391 37.7551332492083 -122.391289372524 (37.7551332492083, -122.391289372524)
65075 65075 240148 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1407 Cole St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5998258.05957 2105587.56322 37.761441831488 -122.44915145438601 (37.761441831488, -122.449151454386)
65474 65474 239267 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 174 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6007529.81177 2107967.97324 37.7685038235247 -122.417252916882 (37.7685038235247, -122.417252916882)
67554 67554 240166 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 955 Clayton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5998780.1300099995 2106624.27042 37.7643182159335 -122.44742045909099 (37.7643182159335, -122.447420459091)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 1427.892ms · Data source: data.sfgov.org