Data source: data.sfgov.org
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 92348 | 92348 | 690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 108331 | 108331 | 1688 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1993 12:00:00 AM | 6 | 3X3 | 6017679.592279 | 2093598.3775556 | 37.7296136527509 | -122.381146110708 | (37.7296136527509, -122.381146110708) | ||
| 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) | ||
| 122622 | 122622 | 1699 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1999 12:00:00 AM | 3 | 3X3 | 6017775.3254178 | 2093648.0174938 | 37.7297552383916 | -122.380818597255 | (37.7297552383916, -122.380818597255) | ||
| 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) | ||
| 9202 | 9202 | 1709 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 7X Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2006 12:00:00 AM | 5 | 3x3 | 6016610.521033701 | 2095134.7434862 | 37.7337731370994 | -122.384949031469 | (37.7337731370994, -122.384949031469) | ||
| 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) | ||
| 139387 | 139387 | 3372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 5951 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5989085.57316 | 2113985.01381 | 37.7839700180526 | -122.48148992901301 | (37.7839700180526, -122.481489929013) | |||
| 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) | |||
| 17348 | 17348 | 4322 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 752 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002136.242880001 | 2095781.1252 | 37.7347367232032 | -122.435037065224 | (37.7347367232032, -122.435037065224) | |||
| 20207 | 20207 | 4337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.188490001 | 2095960.05903 | 37.735191840439896 | -122.437252384095 | (37.7351918404399, -122.437252384095) | ||
| 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) | |||
| 7900 | 7900 | 4617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | ||
| 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) | ||
| 14424 | 14424 | 6845 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6015936.9719 | 2097716.00593 | 37.7408234823092 | -122.38745772460899 | (37.7408234823092, -122.387457724609) | ||
| 16542 | 16542 | 6847 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2002 12:00:00 AM | 3 | 3x3 | 6015962.97666 | 2097752.7883599997 | 37.7409259196071 | -122.38737037433701 | (37.7409259196071, -122.387370374337) | ||
| 3392 | 3392 | 7175 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 814 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 6 | 3X3 | 6003515.4229999995 | 2111193.7442 | 37.7771343327183 | -122.43136863367201 | (37.7771343327183, -122.431368633672) | ||
| 128038 | 128038 | 7193 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 898 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6003489.5579699995 | 2111353.68492 | 37.7775720243799 | -122.431469529604 | (37.7775720243799, -122.431469529604) | ||
| 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) | ||
| 6172 | 6172 | 7253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1701 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1991 12:00:00 AM | 6 | 4X4 | 6003034.749 | 2114248.1919 | 37.7854938264749 | -122.433249741154 | (37.7854938264749, -122.433249741154) | ||
| 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) | |||
| 91783 | 91783 | 7289 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1870X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2003 12:00:00 AM | 4 | 3X3 | 6003014.51409 | 2114705.35035 | 37.7867479198171 | -122.433352427121 | (37.7867479198171, -122.433352427121) | ||
| 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) | |||
| 111741 | 111741 | 7293 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003023.6659699995 | 2114860.30144 | 37.7871738953822 | -122.43333184030399 | (37.7871738953822, -122.433331840304) | |||
| 9522 | 9522 | 7294 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003037.0806 | 2114087.5866 | 37.7850529772079 | -122.43323019463499 | (37.7850529772079, -122.433230194635) | |||
| 121594 | 121594 | 7298 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1902 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1996 12:00:00 AM | 4 | 3X3 | 6003023.00685 | 2114884.3509299997 | 37.7872398917823 | -122.43333583987699 | (37.7872398917823, -122.433335839877) | ||
| 82604 | 82604 | 7299 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1905 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002897.81582 | 2114891.63011 | 37.7872527755124 | -122.433769494093 | (37.7872527755124, -122.433769494093) | |||
| 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) | |||
| 7656 | 7656 | 7301 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1996 12:00:00 AM | 3 | 3X3 | 6002935.9259 | 2114953.2976 | 37.787424261211704 | -122.43364205043699 | (37.7874242612117, -122.433642050437) | ||
| 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) | |||
| 114751 | 114751 | 7303 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1911 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002897.81123 | 2114891.63011 | 37.787252775252 | -122.43376950997299 | (37.787252775252, -122.433769509973) | |||
| 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) | |||
| 111258 | 111258 | 7305 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1913 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002897.81123 | 2114891.63011 | 37.787252775252 | -122.43376950997299 | (37.787252775252, -122.433769509973) | |||
| 94428 | 94428 | 7306 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1913 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002897.81123 | 2114891.63011 | 37.787252775252 | -122.43376950997299 | (37.787252775252, -122.433769509973) | |||
| 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) | ||
| 96762 | 96762 | 7309 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1928 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003003.5 | 2115005.5 | 37.7875714296796 | -122.433411989954 | (37.7875714296796, -122.433411989954) | |||
| 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) | ||
| 8286 | 8286 | 7311 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1932 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | 6002980.7419 | 2115020.0739 | 37.787610154730004 | -122.433491770285 | (37.78761015473, -122.433491770285) | |||
| 6697 | 6697 | 7312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002968.6362 | 2115073.8773 | 37.7877571983499 | -122.433537500112 | (37.7877571983499, -122.433537500112) | |||
| 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) | |||
| 124995 | 124995 | 7316 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2000 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002972.254319999 | 2115230.97031 | 37.788188741068204 | -122.433536213059 | (37.7881887410682, -122.433536213059) | |||
| 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) | ||
| 7823 | 7823 | 7319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2011 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002893.06 | 2115234.5275 | 37.7881940146245 | -122.433810466039 | (37.7881940146245, -122.433810466039) | |||
| 92012 | 92012 | 7320 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2016 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 7 | 3X3 | 6003001.73917 | 2115232.48409 | 37.7881945703662 | -122.433434308795 | (37.7881945703662, -122.433434308795) | ||
| 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) | |||
| 120754 | 120754 | 7326 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2033 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002897.31453 | 2115259.18608 | 37.7882619622277 | -122.433797509249 | (37.7882619622277, -122.433797509249) | ||
| 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) | ||
| 44571 | 44571 | 7356 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.79079460631979 | -122.434307574482 | (37.7907946063198, -122.434307574482) | ||
| 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) | ||
| 96942 | 96942 | 8083 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004278.93609 | 2111494.4180400004 | 37.7780031505288 | -122.428748840382 | (37.7780031505288, -122.428748840382) | ||
| 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) | ||
| 106361 | 106361 | 8086 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2001 12:00:00 AM | 6 | 3X3 | 6004351.32927 | 2111504.25977 | 37.7780342704524 | -122.428499108252 | (37.7780342704524, -122.428499108252) | ||
| 7365 | 7365 | 8095 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 762 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 04/14/1998 12:00:00 AM | 24 | 3X3 | 6004129.5547 | 2111522.3059 | 37.778071268059996 | -122.42926759287201 | (37.77807126806, -122.429267592872) | ||
| 5687 | 5687 | 8096 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 762 Fulton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 04/14/1998 12:00:00 AM | 18 | 3X3 | 6004110.3708 | 2111520.4613 | 37.7780651171853 | -122.429333825297 | (37.7780651171853, -122.429333825297) | ||
| 111645 | 111645 | 8098 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004145.13907 | 2111463.64591 | 37.7779110844604 | -122.42920949713002 | (37.7779110844604, -122.42920949713) | ||
| 109687 | 109687 | 8099 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004167.348119999 | 2111468.4499 | 37.7779255322683 | -122.429133010837 | (37.7779255322683, -122.429133010837) | ||
| 115190 | 115190 | 8101 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 7 | 3X3 | 6004218.15362 | 2111478.37785 | 37.777955667841795 | -122.428957964704 | (37.7779556678418, -122.428957964704) | ||
| 80017 | 80017 | 8107 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 785 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 3 | 4X4 | 6004040.717119999 | 2111448.77193 | 37.7778643322695 | -122.429569668288 | (37.7778643322695, -122.429569668288) | ||
| 112178 | 112178 | 8108 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 785 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 4 | 3X3 | 6004054.06089 | 2111452.3407900003 | 37.777874887005 | -122.429523762111 | (37.777874887005, -122.429523762111) | ||
| 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) |
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");