Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14222 | 14222 | 16526 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 375 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016351.58796 | 2098272.95822 | 37.7423757148758 | -122.386062939968 | (37.7423757148758, -122.386062939968) | ||
| 14255 | 14255 | 85641 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017274.7558 | 2093081.4055 | 37.72817179324429 | -122.382509730509 | (37.7281717932443, -122.382509730509) | ||
| 14406 | 14406 | 120561 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 245 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014054.5814 | 2105863.37396 | 37.7630899785332 | -122.394536741704 | (37.7630899785332, -122.394536741704) | |||
| 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) | ||
| 14505 | 14505 | 85632 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1582 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015365.5421 | 2094575.4322 | 37.7321684400373 | -122.38921428964 | (37.7321684400373, -122.38921428964) | ||
| 14570 | 14570 | 16549 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015994.10911 | 2097882.11034 | 37.7412827355083 | -122.38727174751001 | (37.7412827355083, -122.38727174751) | |||
| 14632 | 14632 | 85652 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1519 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015655.7374 | 2094284.1377 | 37.7313846871586 | -122.388190689138 | (37.7313846871586, -122.388190689138) | ||
| 14634 | 14634 | 24178 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 4 | 4x3 | 6016619.186290001 | 2095310.93644 | 37.7342574070589 | -122.384931343733 | (37.7342574070589, -122.384931343733) | ||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 14774 | 14774 | 85650 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1419 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016182.7975 | 2093891.6734 | 37.730336247224706 | -122.386341174586 | (37.7303362472247, -122.386341174586) | ||
| 14882 | 14882 | 85659 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1623 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015103.6745 | 2094694.6627 | 37.7324813021879 | -122.390127958436 | (37.7324813021879, -122.390127958436) | ||
| 14888 | 14888 | 24090 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 125X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016342.364159999 | 2095991.2568 | 37.736110114791 | -122.3859358217 | (37.736110114791, -122.3859358217) | ||
| 14904 | 14904 | 24147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | |||
| 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) | ||
| 14960 | 14960 | 85627 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1466 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015977.8277 | 2094121.4228 | 37.730955745426606 | -122.387065808076 | (37.7309557454266, -122.387065808076) | ||
| 15002 | 15002 | 85644 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1275 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016975.0441 | 2093297.8038 | 37.728749419657 | -122.383560914081 | (37.728749419657, -122.383560914081) | ||
| 15012 | 15012 | 85551 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 288 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 3 | 6008109.65239 | 2108844.36385 | 37.7709427912139 | -122.41530934075199 | (37.7709427912139, -122.415309340752) | |||
| 15041 | 15041 | 24179 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 5x3 | 6016625.58798 | 2095312.02915 | 37.7342607615082 | -122.38490928693199 | (37.7342607615082, -122.384909286932) | ||
| 15074 | 15074 | 11468 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 6 | 3X3 | 6016817.53474 | 2095601.45988 | 37.735066095427705 | -122.384265809434 | (37.7350660954277, -122.384265809434) | ||
| 15196 | 15196 | 85648 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1357 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016534.0204 | 2093632.0271 | 37.7296427448929 | -122.38510885322701 | (37.7296427448929, -122.385108853227) | ||
| 15328 | 15328 | 85611 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1150 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017700.249 | 2092841.4739 | 37.7275364831055 | -122.381022095395 | (37.7275364831055, -122.381022095395) | ||
| 15360 | 15360 | 85624 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016199.7661 | 2093954.969 | 37.7305109836044 | -122.38628692243 | (37.7305109836044, -122.38628692243) | ||
| 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) | |||
| 15458 | 15458 | 85621 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1356 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016575.2959 | 2093679.014 | 37.7297740447744 | -122.38496943038601 | (37.7297740447744, -122.384969430386) | ||
| 15537 | 15537 | 85657 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1651 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014964.3549 | 2094799.3159999999 | 37.7327609307407 | -122.39061693379999 | (37.7327609307407, -122.3906169338) | ||
| 15644 | 15644 | 16542 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016097.47551 | 2098025.0219 | 37.741680865376 | -122.386924304309 | (37.741680865376, -122.386924304309) | |||
| 15649 | 15649 | 85651 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1467 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015942.8131 | 2094070.7863 | 37.730814768733396 | -122.387183329829 | (37.7308147687334, -122.387183329829) | ||
| 15797 | 15797 | 101777 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1700 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014038.07825 | 2093123.5904299999 | 37.72810829704029 | -122.39370208181101 | (37.7281082970403, -122.393702081811) | |||
| 15814 | 15814 | 85630 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1518 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015608.4708 | 2094395.709 | 37.7316884205401 | -122.388361884277 | (37.7316884205401, -122.388361884277) | ||
| 15847 | 15847 | 11469 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 9 | 3X3 | 6016835.012019999 | 2095606.77415 | 37.735081653692 | -122.38420575361401 | (37.735081653692, -122.384205753614) | ||
| 15931 | 15931 | 85649 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1399 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016350.3286 | 2093764.5437 | 37.7299964462298 | -122.385753133703 | (37.7299964462298, -122.385753133703) | ||
| 15934 | 15934 | 85623 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1404 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016275.7207 | 2093898.407 | 37.7303598794973 | -122.38602039250401 | (37.7303598794973, -122.386020392504) | ||
| 15981 | 15981 | 16561 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 702X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6015590.528940001 | 2097333.28077 | 37.739753403296206 | -122.388628895503 | (37.7397534032962, -122.388628895503) | ||
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 16109 | 16109 | 85626 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1454 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016038.1604 | 2094077.7893 | 37.7308392772335 | -122.38685418415001 | (37.7308392772335, -122.38685418415) | ||
| 16244 | 16244 | 85633 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1590 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015320.4739 | 2094608.4089 | 37.732256488847106 | -122.38937240380899 | (37.7322564888471, -122.389372403809) | ||
| 16295 | 16295 | 27141 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1775 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011398.088769999 | 2095346.30396 | 37.7340643486912 | -122.402984937921 | (37.7340643486912, -122.402984937921) | |||
| 16358 | 16358 | 85616 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1258 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017082.7023 | 2093297.2628 | 37.7287538840188 | -122.383188691469 | (37.7287538840188, -122.383188691469) | ||
| 16510 | 16510 | 85610 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1132 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017745.1516 | 2092811.7191 | 37.727457260594704 | -122.38086479752899 | (37.7274572605947, -122.380864797529) | ||
| 16538 | 16538 | 85640 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017322.9044 | 2093043.5358 | 37.7280704700942 | -122.382340643729 | (37.7280704700942, -122.382340643729) | ||
| 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) | ||
| 16554 | 16554 | 85618 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1314 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016773.2527 | 2093530.9730000002 | 37.729378500955896 | -122.384274758873 | (37.7293785009559, -122.384274758873) | ||
| 16579 | 16579 | 85638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017293.1497 | 2093067.8806 | 37.728135672587904 | -122.382445200849 | (37.7281356725879, -122.382445200849) | ||
| 16642 | 16642 | 85639 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017307.7565 | 2093058.1427 | 37.7281097410693 | -122.382394026885 | (37.7281097410693, -122.382394026885) | ||
| 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) | |||
| 16855 | 16855 | 85645 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1313 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016677.8494 | 2093524.29 | 37.7293548752151 | -122.384604114815 | (37.7293548752151, -122.384604114815) | ||
| 16955 | 16955 | 15610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1995 12:00:00 AM | 3 | 3x3 | 6006029.1794 | 2098644.8095 | 37.742820038399 | -122.421781171739 | (37.742820038399, -122.421781171739) | ||
| 17097 | 17097 | 15580 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006815.4591 | 2099977.9757 | 37.746524922000205 | -122.41915697739401 | (37.7465249220002, -122.419156977394) | ||
| 17233 | 17233 | 16673 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 244 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002873.2969 | 2106860.8212200003 | 37.7652007800214 | -122.43328026297701 | (37.7652007800214, -122.433280262977) | |||
| 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) | |||
| 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) | |||
| 17704 | 17704 | 15609 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3350 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1995 12:00:00 AM | 3 | 3x3 | 6006037.9197 | 2098666.6602 | 37.742880528375395 | -122.42175250189501 | (37.7428805283754, -122.421752501895) | ||
| 17939 | 17939 | 26869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | ||
| 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) | ||
| 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) | ||
| 18752 | 18752 | 10423 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1401 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999371.8264 | 2108722.9096 | 37.7701143458549 | -122.44552487423 | (37.7701143458549, -122.44552487423) | |||
| 18926 | 18926 | 15619 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005685.7885 | 2097881.8817 | 37.7407058402708 | -122.422914311238 | (37.7407058402708, -122.422914311238) | ||
| 19015 | 19015 | 23089 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1992 12:00:00 AM | 3 | 3X3 | 6006386.45124 | 2101639.17827 | 37.751062036612 | -122.420758355385 | (37.751062036612, -122.420758355385) | ||
| 19418 | 19418 | 90383 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.42000143597099 | (37.7740948433326, -122.420001435971) | ||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 19876 | 19876 | 10381 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1324 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X3 | 5999783.9663 | 2108832.8405 | 37.770439708466604 | -122.44410719203998 | (37.7704397084666, -122.44410719204) | |||
| 19877 | 19877 | 22862 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 151 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X2 | 5999932.75509 | 2099167.18309 | 37.7439086722544 | -122.442898328797 | (37.7439086722544, -122.442898328797) | |||
| 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) | ||
| 20253 | 20253 | 28342 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 3101 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007042.9194 | 2100397.9596 | 37.747690909992706 | -122.418400216794 | (37.7476909099927, -122.418400216794) | ||
| 20482 | 20482 | 15620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3529 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005636.1083 | 2097793.1908 | 37.740459511674 | -122.423079784271 | (37.740459511674, -122.423079784271) | ||
| 20547 | 20547 | 15616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3461 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005827.515 | 2098142.9917 | 37.741430785549205 | -122.422442822684 | (37.7414307855492, -122.422442822684) | ||
| 20573 | 20573 | 15605 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3349 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 6006192.9166 | 2098824.6926 | 37.743323189063 | -122.42122778433998 | (37.743323189063, -122.42122778434) | ||
| 20863 | 20863 | 112866 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 21028 | 21028 | 15622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3535 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005607.2671 | 2097740.6765 | 37.7403136916677 | -122.423175774097 | (37.7403136916677, -122.423175774097) | ||
| 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) | ||
| 21266 | 21266 | 15611 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3361 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2001 12:00:00 AM | 7 | 3X3 | 6006103.7046 | 2098658.8645 | 37.7428628326579 | -122.421524482148 | (37.7428628326579, -122.421524482148) | ||
| 21620 | 21620 | 16672 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002863.164369999 | 2106910.32472 | 37.765336129770105 | -122.43331884658001 | (37.7653361297701, -122.43331884658) | |||
| 21828 | 21828 | 15579 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006811.7424 | 2099968.3124 | 37.7464981794513 | -122.419169144026 | (37.7464981794513, -122.419169144026) | ||
| 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) | |||
| 21886 | 21886 | 15583 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3177 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1999 12:00:00 AM | 3 | 3X3 | 6006726.259 | 2099810.7255 | 37.7460606669612 | -122.419453558792 | (37.7460606669612, -122.419453558792) | ||
| 21940 | 21940 | 10478 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998139.6149 | 2108553.6282 | 37.7695791194599 | -122.44977485921801 | (37.7695791194599, -122.449774859218) | |||
| 21988 | 21988 | 15585 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3181 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6006711.3923 | 2099783.2222 | 37.7459843117401 | -122.419503015091 | (37.7459843117401, -122.419503015091) | ||
| 22361 | 22361 | 213977 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994717.86147 | 2090376.1855099997 | 37.719472047173205 | -122.460293291905 | (37.7194720471732, -122.460293291905) | |||
| 22370 | 22370 | 244046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998376.5126 | 2109253.6935 | 37.771514871030995 | -122.44900587960699 | (37.771514871031, -122.449005879607) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 23398 | 23398 | 138455 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002947.3238 | 2114874.0081 | 37.787207199109204 | -122.433596947338 | (37.7872071991092, -122.433596947338) | |||
| 23424 | 23424 | 197132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016788.78445 | 2098277.43468 | 37.742412193171795 | -122.384551543811 | (37.7424121931718, -122.384551543811) | |||
| 23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
| 23669 | 23669 | 138324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2492 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001634.5236 | 2114647.8572 | 37.7865116723619 | -122.438122738022 | (37.7865116723619, -122.438122738022) | |||
| 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) | |||
| 23815 | 23815 | 239298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1475 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 10ft | 6010135.52625 | 2100699.74587 | 37.7486931572616 | -122.407727378721 | (37.7486931572616, -122.407727378721) | |||
| 23839 | 23839 | 239303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 827 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009943.30832 | 2104181.7840400003 | 37.7582432964097 | -122.408637674287 | (37.7582432964097, -122.408637674287) | |||
| 23855 | 23855 | 213936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992721.86042 | 2099019.1696099997 | 37.7430885175375 | -122.46782095827801 | (37.7430885175375, -122.467820958278) | |||
| 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) | |||
| 24461 | 24461 | 138424 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003330.8547 | 2114478.3784 | 37.786142653739 | -122.432241748584 | (37.786142653739, -122.432241748584) | |||
| 24603 | 24603 | 239251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3741 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005376.329919999 | 2100765.1364700003 | 37.748605134322794 | -122.42418930690901 | (37.7486051343228, -122.424189306909) | |||
| 24904 | 24904 | 136239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | |||
| 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) |
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");