Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 652 | 652 | 237023 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | ||
| 661 | 661 | 237024 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 5 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334130994 | -122.423466764586 | (37.772478334131, -122.423466764586) | ||
| 663 | 663 | 237022 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 3 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.133230001 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | ||
| 665 | 665 | 239151 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | ||
| 666 | 666 | 237028 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 9 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | ||
| 1093 | 1093 | 244319 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 331 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:00:00 PM | 3 | Width 0ft | 6005497.6412 | 2110517.1934 | 37.7753888290162 | -122.424463374134 | (37.7753888290162, -122.424463374134) | ||
| 1105 | 1105 | 244414 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 261 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:17:00 PM | 3 | Width 0ft | 6005541.7456 | 2110219.4552 | 37.7745738026307 | -122.424289625835 | (37.7745738026307, -122.424289625835) | ||
| 1108 | 1108 | 244318 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 331 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:08:00 PM | 3 | Width 0ft | 6005494.8083 | 2110541.2729 | 37.7754547855001 | -122.424474886956 | (37.7754547855001, -122.424474886956) | ||
| 1966 | 1966 | 138440 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2014 12:00:00 AM | 6 | Width 0ft | 6003498.0109 | 2114207.9928 | 37.7854097192823 | -122.431644121578 | (37.7854097192823, -122.431644121578) | ||
| 3763 | 3763 | 18277 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002776.9831 | 2114109.0569 | 37.7850971709049 | -122.434131584258 | (37.7850971709049, -122.434131584258) | ||
| 4615 | 4615 | 137866 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2044 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/03/2012 12:00:00 AM | 1 | Width 0ft | 6002931.7599 | 2115390.6101 | 37.7886247736431 | -122.43368773072201 | (37.7886247736431, -122.433687730722) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 9603 | 9603 | 19972 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 36 | ||||||||
| 10059 | 10059 | 24572 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2122 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2013 12:00:00 AM | 3 | 3x3 | 6002889.00041 | 2115679.48805 | 37.7894155324538 | -122.433856328234 | (37.7894155324538, -122.433856328234) | ||
| 10418 | 10418 | 77647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | |
| 10895 | 10895 | 27085 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 747 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6006317.37103 | 2093607.15152 | 37.729003994832 | -122.420427188268 | (37.729003994832, -122.420427188268) | |||
| 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) | |||
| 13142 | 13142 | 27250 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 747 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6006299.28886 | 2093605.00165 | 37.728997072755206 | -122.420489547272 | (37.7289970727552, -122.420489547272) | |||
| 13396 | 13396 | 85628 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1470 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015957.8963 | 2094137.5833 | 37.730999015226104 | -122.387135841638 | (37.7309990152261, -122.387135841638) | ||
| 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) | |||
| 13415 | 13415 | 85617 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | ||
| 13512 | 13512 | 85658 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.39047467450001 | (37.7326823614983, -122.3904746745) | ||
| 13554 | 13554 | 85620 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | ||
| 13600 | 13600 | 85619 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1338 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016653.5768 | 2093624.593 | 37.729628945087704 | -122.384695012523 | (37.7296289450877, -122.384695012523) | ||
| 13802 | 13802 | 85643 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.38287210620199 | (37.7283695937915, -122.382872106202) | ||
| 13961 | 13961 | 85647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1351 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016557.1838 | 2093613.7118 | 37.7295937360014 | -122.385027498588 | (37.7295937360014, -122.385027498588) | ||
| 14061 | 14061 | 24180 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6016621.33395 | 2095295.74377 | 37.7342158098126 | -122.384922860422 | (37.7342158098126, -122.384922860422) | |||
| 14120 | 14120 | 85653 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1541 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015555.708 | 2094360.5338 | 37.731588912651404 | -122.388541843069 | (37.7315889126514, -122.388541843069) | ||
| 14131 | 14131 | 85613 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | ||
| 14162 | 14162 | 85622 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016552.9396 | 2093696.0654 | 37.729819627930105 | -122.385047906896 | (37.7298196279301, -122.385047906896) | ||
| 14204 | 14204 | 85646 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1321 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016609.4363 | 2093572.233 | 37.7294827335965 | -122.38484396608999 | (37.7294827335965, -122.38484396609) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 72557 | 72557 | 138536 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1840 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2015 12:00:00 AM | 5 | Width 0ft | 6003152.9747 | 2114161.9926 | 37.7852638510753 | -122.432834555298 | (37.7852638510753, -122.432834555298) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 78764 | 78764 | 111862 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
| 79081 | 79081 | 85656 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1699X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.7735630001 | 37.7331505648623 | -122.39123539488199 | (37.7331505648623, -122.391235394882) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) |
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");