Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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 | ||||||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
48328 | 48328 | 117078 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1506 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 5x5 | 6003016.0 | 2114040.0 | 37.7849211205465 | -122.433299725252 | (37.7849211205465, -122.433299725252) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
87312 | 87312 | 24482 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 103X Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002240.5138934 | 2096668.0977393002 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | |||
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) | |||
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) | |||
91163 | 91163 | 16010 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | 4 | 6001411.931226401 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | |||
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) | |||
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) | |||
98801 | 98801 | 14783 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1037 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004216.0719046 | 2111827.8420520998 | 37.7789150924062 | -122.42899008807801 | (37.7789150924062, -122.428990088078) | |||
99327 | 99327 | 16156 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
99658 | 99658 | 23701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2119X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005103.6033 | 2116867.2333400003 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | |||
100117 | 100117 | 8939 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5992577.29346 | 2112701.40564 | 37.7806479856044 | -122.469316501972 | (37.7806479856044, -122.469316501972) | |||
101812 | 101812 | 16753 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1785 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002792.36489 | 2113361.8294900004 | 37.783046346317796 | -122.434024935538 | (37.7830463463178, -122.434024935538) | |||
109207 | 109207 | 21209 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2392X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
113103 | 113103 | 16159 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
114141 | 114141 | 27681 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
117899 | 117899 | 16668 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 226 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002868.0131043 | 2106963.7207257 | 37.7654830172848 | -122.43330589175501 | (37.7654830172848, -122.433305891755) | |||
118130 | 118130 | 21727 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1945 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003269.495209999 | 2114473.35544 | 37.786125382734 | -122.432453677113 | (37.786125382734, -122.432453677113) | |||
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) | |||
125824 | 125824 | 21211 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
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) | |||
138897 | 138897 | 110940 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1944X FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6003020.0 | 2115096.0 | 37.7878208557656 | -122.433361372735 | (37.7878208557656, -122.433361372735) | |||
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) | |||
142134 | 142134 | 8915 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5993265.0042 | 2112726.545 | 37.7807567282341 | -122.466939229172 | (37.7807567282341, -122.466939229172) | |||
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) | |||
143816 | 143816 | 21208 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2392X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
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) | |||
105931 | 105931 | 24194 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 55X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
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) | ||
144934 | 144934 | 24470 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 50X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6006161.54315 | 2109606.56692 | 37.7729259368552 | -122.42210207116699 | (37.7729259368552, -122.422102071167) | ||
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) | ||
100658 | 100658 | 112504 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2016 10:27:00 AM | 3 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | ||
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) | ||
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) | ||
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) | ||
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) | ||
97346 | 97346 | 16494 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016769.452380001 | 2098282.55627 | 37.7424251869258 | -122.384618745617 | (37.7424251869258, -122.384618745617) | ||
107005 | 107005 | 16495 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016789.27845 | 2098277.7028 | 37.7424129566932 | -122.384549854363 | (37.7424129566932, -122.384549854363) | ||
144773 | 144773 | 16496 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016807.79285 | 2098273.5495599997 | 37.7424025765764 | -122.384485547297 | (37.7424025765764, -122.384485547297) | ||
104613 | 104613 | 18637 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/1998 12:00:00 AM | 3 | 3X4 | 6017121.136185501 | 2096199.8633465 | 37.736725974033604 | -122.383257779638 | (37.7367259740336, -122.383257779638) | ||
83510 | 83510 | 18634 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017078.2420673 | 2096202.8624203 | 37.736731838359795 | -122.383406293435 | (37.7367318383598, -122.383406293435) | ||
113449 | 113449 | 18638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017121.136185501 | 2096199.8633465 | 37.736725974033604 | -122.383257779638 | (37.7367259740336, -122.383257779638) | ||
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) | ||
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) | ||
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) | ||
143372 | 143372 | 91610 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1068 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2016 08:13:00 AM | 3 | 3x3 | 6007601.453035 | 2103438.871938 | 37.7560719916571 | -122.416684224173 | (37.7560719916571, -122.416684224173) | |||
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) | ||
102226 | 102226 | 22817 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 2X2 | 5999134.8661569 | 2099418.6659097997 | 37.7445536617332 | -122.445675315466 | (37.7445536617332, -122.445675315466) | ||
106511 | 106511 | 90384 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 12th St | 4 | 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) | ||
88462 | 88462 | 18260 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1870 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1990 12:00:00 AM | 6 | 4X4 | 6003225.470724501 | 2114168.1799394 | 37.7852849514104 | -122.43258418353399 | (37.7852849514104, -122.432584183534) | ||
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) | ||
111606 | 111606 | 90387 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 12th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2014 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.42000143597099 | (37.7740948433326, -122.420001435971) | ||
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) | ||
114982 | 114982 | 90392 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 98 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6007146.175112001 | 2109626.370927 | 37.77303579982821 | -122.418697508419 | (37.7730357998282, -122.418697508419) | ||
97965 | 97965 | 24186 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 55X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 4x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
98467 | 98467 | 24177 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 95X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 4 | 3X3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
103685 | 103685 | 24094 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
106905 | 106905 | 24171 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 95X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
109191 | 109191 | 24106 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
128586 | 128586 | 18635 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 0 | 3X3 | 6017095.3922155 | 2096110.4018038001 | 37.736478907812 | -122.38334056309999 | (37.736478907812, -122.3833405631) | ||
139566 | 139566 | 24098 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
85261 | 85261 | 16550 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 500X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1998 12:00:00 AM | 3 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | ||
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) | ||
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) | ||
83194 | 83194 | 87400 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
96662 | 96662 | 87399 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
117485 | 117485 | 87401 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | |||
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) | ||
82718 | 82718 | 90488 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 125 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 6 | 3x3 | 5987997.512680001 | 2115126.89685 | 37.7870419790043 | -122.485337990995 | (37.7870419790043, -122.485337990995) | ||
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) | ||
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) | ||
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) | ||
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) |
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");