Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 144529 | 144529 | 4 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1101X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5992046.40751 | 2114771.53879 | 37.7863013087655 | -122.471303948198 | (37.7863013087655, -122.471303948198) | |||
| 84224 | 84224 | 1689 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 03:07:00 PM | 3 | 3X3 | 6017662.008057199 | 2093645.2163419998 | 37.729741292224205 | -122.381210157278 | (37.7297412922242, -122.381210157278) | ||
| 77627 | 77627 | 1693 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040294999 | 37.7297694248505 | -122.38109767205201 | (37.7297694248505, -122.381097672052) | ||
| 88473 | 88473 | 1698 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 39 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6017750.796090401 | 2093602.6298867 | 37.72962925906 | -122.380900244658 | (37.72962925906, -122.380900244658) | ||
| 97591 | 97591 | 1700 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 43 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 6 | 3X3 | 6017768.2322395 | 2093598.2442303002 | 37.7296181792492 | -122.380839660676 | (37.7296181792492, -122.380839660676) | ||
| 123953 | 123953 | 1701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761566999 | 2093643.6318374001 | 37.7297441585391 | -122.38075801318199 | (37.7297441585391, -122.380758013182) | ||
| 12987 | 12987 | 1848 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011043.028059999 | 2086938.1542099998 | 37.7109574665846 | -122.403621108454 | (37.7109574665846, -122.403621108454) | |||
| 6898 | 6898 | 2436 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004500.111269999 | 2111079.2700799997 | 37.7768757716325 | -122.427954126177 | (37.7768757716325, -122.427954126177) | ||
| 111112 | 111112 | 2464 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1832 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2000 12:00:00 AM | 3 | 4X4 | 6003995.999502901 | 2114715.2873188 | 37.7868308367846 | -122.429957429665 | (37.7868308367846, -122.429957429665) | ||
| 127078 | 127078 | 2465 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1832 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2000 12:00:00 AM | 3 | 4X4 | 6003995.999502901 | 2114715.2873188 | 37.7868308367846 | -122.429957429665 | (37.7868308367846, -122.429957429665) | ||
| 8714 | 8714 | 2466 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1826 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 3 | 4X4 | 6003983.3989 | 2114773.4102 | 37.786989713975295 | -122.43000517250799 | (37.7869897139753, -122.430005172508) | ||
| 96338 | 96338 | 3228 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 3864 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2013 12:00:00 AM | 3 | 3x3 | 5995802.3054 | 2114541.58405 | 37.785886459875 | -122.458292942759 | (37.785886459875, -122.458292942759) | ||
| 17662 | 17662 | 4223 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004059.37365 | 2100401.32602 | 37.7475317476004 | -122.428717394312 | (37.7475317476004, -122.428717394312) | |||
| 96907 | 96907 | 4339 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 07:58:00 AM | 3 | 3X3 | 6001465.6431599995 | 2095917.8806599998 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | ||
| 90769 | 90769 | 4354 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.43847191328899 | (37.7344491599181, -122.438471913289) | ||
| 110737 | 110737 | 4356 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15X Burnside Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2011 12:00:00 AM | 3 | 5x5 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.43847191328899 | (37.7344491599181, -122.438471913289) | ||
| 143349 | 143349 | 4363 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 16X Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2005 12:00:00 AM | 3 | 3x3 | 6001247.5637 | 2095900.9603400002 | 37.7350152618906 | -122.438118108566 | (37.7350152618906, -122.438118108566) | ||
| 100023 | 100023 | 4364 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 16X Burnside Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2012 12:00:00 AM | 3 | 3x3 | 6001221.764219999 | 2095989.4346900003 | 37.7352567246132 | -122.43821364238701 | (37.7352567246132, -122.438213642387) | ||
| 23128 | 23128 | 4406 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1060 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004384.57785 | 2102734.51473 | 37.7539565402887 | -122.42775907492799 | (37.7539565402887, -122.427759074928) | |||
| 124403 | 124403 | 4618 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6010598.00994 | 2118821.5860200003 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | |||
| 97607 | 97607 | 4924 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 195X Newhall St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 117175 | 117175 | 5222 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1010 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2014 12:00:00 AM | 3 | 4x4 | 6001485.7958586 | 2111861.2482698997 | 37.7788518948545 | -122.438437575376 | (37.7788518948545, -122.438437575376) | ||
| 21163 | 21163 | 5709 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1606 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/1991 12:00:00 AM | 3 | 4X4 | 6005243.993869999 | 2098945.2281 | 37.7436006094864 | -122.424517489316 | (37.7436006094864, -122.424517489316) | ||
| 8221 | 8221 | 5902 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1230 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004519.1281 | 2112960.2158 | 37.7820414601118 | -122.428022411289 | (37.7820414601118, -122.428022411289) | |||
| 101580 | 101580 | 5925 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1335 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/2016 12:00:00 AM | 7 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 18626 | 18626 | 5933 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 86817 | 86817 | 5934 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | |||
| 100712 | 100712 | 5936 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1363 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2004 12:00:00 AM | 3 | 4X4 | 6003943.036169999 | 2112815.6910200003 | 37.781612021567796 | -122.43000511355 | (37.7816120215678, -122.43000511355) | ||
| 95939 | 95939 | 5937 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1365 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003934.2066055 | 2112829.5942706 | 37.7816496963753 | -122.43003665173 | (37.7816496963753, -122.43003665173) | |||
| 97745 | 97745 | 6417 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 350X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2016 12:00:00 AM | 6 | 3x3 | 6006767.0052256 | 2097982.925376 | 37.7410442330982 | -122.41918303237 | (37.7410442330982, -122.41918303237) | ||
| 139811 | 139811 | 6418 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 350X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2016 12:00:00 AM | 6 | 3X3 | 6006767.0052256 | 2097982.925376 | 37.7410442330982 | -122.41918303237 | (37.7410442330982, -122.41918303237) | ||
| 87673 | 87673 | 6645 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 495X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
| 103857 | 103857 | 7248 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1880X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2015 12:00:00 AM | 6 | 4X4 | 6003177.7471647 | 2114161.423532 | 37.7852636935379 | -122.43274880955 | (37.7852636935379, -122.43274880955) | ||
| 89187 | 89187 | 7255 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1940X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/2011 12:00:00 AM | 3 | 3x3 | 6002883.203031099 | 2114120.5638209 | 37.785134793903104 | -122.433764919711 | (37.7851347939031, -122.433764919711) | ||
| 8758 | 8758 | 7287 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6003043.7765 | 2114538.1757 | 37.786290560678204 | -122.433239236497 | (37.7862905606782, -122.433239236497) | |||
| 6336 | 6336 | 7291 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1899X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002969.1284 | 2114733.7648 | 37.7868233637677 | -122.433511482074 | (37.7868233637677, -122.433511482074) | |||
| 7747 | 7747 | 7300 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6002999.289 | 2114860.4079 | 37.7871728047294 | -122.433416186864 | (37.7871728047294, -122.433416186864) | |||
| 140070 | 140070 | 7302 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1908 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002991.44687 | 2114925.25661 | 37.787350417898104 | -122.433447954843 | (37.7873504178981, -122.433447954843) | |||
| 5339 | 5339 | 7304 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1908 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6002992.4511 | 2114925.4093 | 37.7873508941206 | -122.433444491336 | (37.7873508941206, -122.433444491336) | |||
| 8083 | 8083 | 7308 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2011 12:00:00 AM | 3 | 3x3 | 6002923.2911 | 2115026.9363 | 37.787625737445204 | -122.433691029207 | (37.7876257374452, -122.433691029207) | ||
| 103412 | 103412 | 7310 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1930 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2011 12:00:00 AM | 10 | 3x3 | 6002973.84302 | 2114998.5825 | 37.7875507533927 | -122.433514102581 | (37.7875507533927, -122.433514102581) | ||
| 89569 | 89569 | 7313 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002971.5982 | 2115063.05298 | 37.7877276455751 | -122.43352647831199 | (37.7877276455751, -122.433526478312) | |||
| 6434 | 6434 | 7318 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 6 | 3x3 | 6002895.5378 | 2115212.2273 | 37.7881329245579 | -122.43380029876002 | (37.7881329245579, -122.43380029876) | ||
| 109881 | 109881 | 7323 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2019 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/15/1989 12:00:00 AM | 3 | 3X3 | 6002894.208190001 | 2115251.15318 | 37.7882397296612 | -122.433807682283 | (37.7882397296612, -122.433807682283) | ||
| 5596 | 5596 | 7325 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2027 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002881.7283 | 2115306.8957 | 37.7883920762372 | -122.433854846414 | (37.7883920762372, -122.433854846414) | |||
| 87994 | 87994 | 7327 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2042 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002940.62895 | 2115331.17345 | 37.7884620789862 | -122.433652795594 | (37.7884620789862, -122.433652795594) | |||
| 142781 | 142781 | 7328 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2042 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002935.65629 | 2115353.59376 | 37.7885233572924 | -122.43367160320801 | (37.7885233572924, -122.433671603208) | |||
| 81094 | 81094 | 7329 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2043 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6002875.62738 | 2115359.09835 | 37.7885350652007 | -122.43387968738199 | (37.7885350652007, -122.433879687382) | ||||
| 102083 | 102083 | 7332 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2056 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/03/2012 12:00:00 AM | 3 | 3X3 | 6002935.732295901 | 2115346.1432336997 | 37.788502904358104 | -122.433670807541 | (37.7885029043581, -122.433670807541) | ||
| 128939 | 128939 | 7333 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2066 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002924.90365 | 2115430.7727099997 | 37.7887346608959 | -122.433714323915 | (37.7887346608959, -122.433714323915) | |||
| 78482 | 78482 | 7334 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2095X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6002864.90775 | 2115441.94118 | 37.7887619221715 | -122.433922699489 | (37.7887619221715, -122.433922699489) | |||
| 97907 | 97907 | 7335 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2095X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002868.54266 | 2115466.62702 | 37.788829909466706 | -122.43391188844801 | (37.7888299094667, -122.433911888448) | |||
| 22899 | 22899 | 7340 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2126 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2017 12:00:00 AM | 3 | 3X3 | 6002883.51227 | 2115702.89267 | 37.7894794841288 | -122.433876990144 | (37.7894794841288, -122.433876990144) | ||
| 106591 | 106591 | 7368 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 7 | 3X3 | 6002726.00787 | 2116542.1867400003 | 37.7917750313387 | -122.43448197129601 | (37.7917750313387, -122.434481971296) | ||
| 82652 | 82652 | 7989 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2148 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/2012 12:00:00 AM | 3 | 3x3 | 6005571.076798901 | 2117355.4773403 | 37.794169211894605 | -122.4246959118 | (37.7941692118946, -122.4246959118) | ||
| 128486 | 128486 | 8049 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 600 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2001 12:00:00 AM | 12 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | ||
| 97888 | 97888 | 8079 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 676 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/1998 12:00:00 AM | 18 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | ||
| 139950 | 139950 | 8082 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1992 12:00:00 AM | 6 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | ||
| 94770 | 94770 | 8084 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | ||
| 8606 | 8606 | 8111 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1993 12:00:00 AM | 20 | 3X3 | 6003847.5569 | 2111477.6208 | 37.7779326053256 | -122.430239935515 | (37.7779326053256, -122.430239935515) | ||
| 140172 | 140172 | 8112 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 1 | 3X3 | 6003674.72306 | 2111615.24723 | 37.778300702455894 | -122.430847652747 | (37.7783007024559, -122.430847652747) | ||
| 23259 | 23259 | 8115 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 830 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1991 12:00:00 AM | 6 | 3X3 | 6003771.0154 | 2111470.5456 | 37.7779088429261 | -122.430504214514 | (37.7779088429261, -122.430504214514) | ||
| 93857 | 93857 | 8232 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1500X Galvez Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 125432 | 125432 | 8257 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1525 GALVEZ AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016246.0 | 2097351.0 | 37.739838361172204 | -122.38636376878901 | (37.7398383611722, -122.386363768789) | ||
| 142134 | 142134 | 8915 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5993265.0042 | 2112726.545 | 37.7807567282341 | -122.466939229172 | (37.7807567282341, -122.466939229172) | |||
| 100117 | 100117 | 8939 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5992577.29346 | 2112701.40564 | 37.7806479856044 | -122.469316501972 | (37.7806479856044, -122.469316501972) | |||
| 101248 | 101248 | 10234 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 47 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2011 12:00:00 AM | 3 | 4x4 | 6005872.37024 | 2109570.63288 | 37.772810956494396 | -122.42309980151501 | (37.7728109564944, -122.423099801515) | ||
| 23213 | 23213 | 10408 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1391 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5999500.982999999 | 2108743.0478 | 37.7701770128525 | -122.445079572577 | (37.7701770128525, -122.445079572577) | |||
| 18749 | 18749 | 10444 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1508 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 6 | 3x3 | 5998873.5099 | 2108710.5533 | 37.770051957545704 | -122.447247648975 | (37.7700519575457, -122.447247648975) | ||
| 105262 | 105262 | 11462 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/1992 12:00:00 AM | 6 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 15393 | 15393 | 11470 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6016849.3995 | 2095607.3792400002 | 37.7350841106266 | -122.38415605258001 | (37.7350841106266, -122.38415605258) | |||
| 128132 | 128132 | 12670 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1128 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1998 12:00:00 AM | 6 | 3X3 | 5991921.00031 | 2114824.3919900004 | 37.786439173997 | -122.47174167386801 | (37.786439173997, -122.471741673868) | ||
| 8100 | 8100 | 14763 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 983 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004471.7203 | 2111860.4178 | 37.7790190047533 | -122.42810802032601 | (37.7790190047533, -122.428108020326) | |||
| 23326 | 23326 | 14782 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1037 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 4X4 | 6004198.5372 | 2111824.0669 | 37.7789037342236 | -122.429050478372 | (37.7789037342236, -122.429050478372) | |||
| 98801 | 98801 | 14783 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1037 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004216.0719046 | 2111827.8420520998 | 37.7789150924062 | -122.42899008807801 | (37.7789150924062, -122.428990088078) | |||
| 23105 | 23105 | 15636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 3620 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005333.6922 | 2097119.1421 | 37.7385916557518 | -122.424077498789 | (37.7385916557518, -122.424077498789) | |||
| 91163 | 91163 | 16010 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | 4 | 6001411.931226401 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | |||
| 99327 | 99327 | 16156 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 113103 | 113103 | 16159 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 121740 | 121740 | 16161 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | G | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | ||
| 120810 | 120810 | 16331 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 800X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996797.9550648 | 2094752.6454838002 | 37.7316082025531 | -122.453419021963 | (37.7316082025531, -122.453419021963) | ||
| 97346 | 97346 | 16494 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016769.452380001 | 2098282.55627 | 37.7424251869258 | -122.384618745617 | (37.7424251869258, -122.384618745617) | ||
| 107005 | 107005 | 16495 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016789.27845 | 2098277.7028 | 37.7424129566932 | -122.384549854363 | (37.7424129566932, -122.384549854363) | ||
| 144773 | 144773 | 16496 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016807.79285 | 2098273.5495599997 | 37.7424025765764 | -122.384485547297 | (37.7424025765764, -122.384485547297) | ||
| 13407 | 13407 | 16508 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | |||
| 80405 | 80405 | 16518 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | ||
| 16831 | 16831 | 16544 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016074.6462900005 | 2097992.47705 | 37.7415902397879 | -122.38700097152399 | (37.7415902397879, -122.387000971524) | |||
| 85261 | 85261 | 16550 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 500X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1998 12:00:00 AM | 3 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | ||
| 89430 | 89430 | 16558 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 500X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/1997 12:00:00 AM | 3 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | ||
| 14937 | 14937 | 16560 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 702X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6015615.61867 | 2097370.07413 | 37.7398558207833 | -122.38854471268299 | (37.7398558207833, -122.388544712683) | ||
| 23298 | 23298 | 16667 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 224 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6002859.4217 | 2106954.1416 | 37.7654562279366 | -122.433334922887 | (37.7654562279366, -122.433334922887) | |||
| 117899 | 117899 | 16668 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 226 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002868.0131043 | 2106963.7207257 | 37.7654830172848 | -122.43330589175501 | (37.7654830172848, -122.433305891755) | |||
| 21863 | 21863 | 16675 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 244 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002863.50303 | 2106836.724 | 37.7651340593044 | -122.433312415546 | (37.7651340593044, -122.433312415546) | |||
| 101812 | 101812 | 16753 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1785 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002792.36489 | 2113361.8294900004 | 37.783046346317796 | -122.434024935538 | (37.7830463463178, -122.434024935538) | |||
| 80384 | 80384 | 16754 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/1992 12:00:00 AM | 6 | 4X4 | 6002743.54981 | 2113352.23837 | 37.783017241069004 | -122.434193129672 | (37.783017241069, -122.434193129672) | ||
| 79895 | 79895 | 16755 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002763.899780001 | 2113354.2774799997 | 37.7830239949229 | -122.434122873023 | (37.7830239949229, -122.434122873023) | |||
| 78191 | 78191 | 18254 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1830 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1998 12:00:00 AM | 12 | 4X4 | 6003416.3649635 | 2114195.205569 | 37.785369980601395 | -122.431925678527 | (37.7853699806014, -122.431925678527) | ||
| 122528 | 122528 | 18255 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1842 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1990 12:00:00 AM | 12 | 4X4 | 6003358.815965001 | 2114187.0581366 | 37.785344347188705 | -122.432124198578 | (37.7853443471887, -122.432124198578) | ||
| 88462 | 88462 | 18260 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1870 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1990 12:00:00 AM | 6 | 4X4 | 6003225.470724501 | 2114168.1799394 | 37.7852849514104 | -122.43258418353399 | (37.7852849514104, -122.432584183534) | ||
| 78063 | 78063 | 18261 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1870 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/1991 12:00:00 AM | 6 | 4X4 | 6003225.470724501 | 2114168.1799394 | 37.7852849514104 | -122.43258418353399 | (37.7852849514104, -122.432584183534) |
JSON shape: default, array, newline-delimited
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");