Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20322 | 20322 | 2547 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 20 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2014 12:00:00 AM | 3 | 3x3 | 6001218.37586 | 2095964.9326099998 | 37.7351892548769 | -122.43822360245001 | (37.7351892548769, -122.43822360245) | ||
| 18660 | 18660 | 2548 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 26 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2012 12:00:00 AM | 3 | 3x3 | 6001209.41963 | 2095931.6881 | 37.7350974637785 | -122.438252186489 | (37.7350974637785, -122.438252186489) | ||
| 20252 | 20252 | 2549 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 30 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/2012 12:00:00 AM | 3 | 3x3 | 6001196.7389 | 2095889.2850400002 | 37.7349803135805 | -122.438292991438 | (37.7349803135805, -122.438292991438) | ||
| 4739 | 4739 | 3036 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2607 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X2 | 6001811.8813 | 2115314.7838 | 37.7883529667295 | -122.437556903926 | (37.7883529667295, -122.437556903926) | |||
| 20107 | 20107 | 4293 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 4339 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001695.46709 | 2100282.2377 | 37.747070687663204 | -122.436883097284 | (37.7470706876632, -122.436883097284) | |||
| 18577 | 18577 | 5154 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001780.9624 | 2109220.4101 | 37.771617599631604 | -122.43722734206499 | (37.7716175996316, -122.437227342065) | ||
| 20046 | 20046 | 5155 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 265 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/17/2001 12:00:00 AM | 3 | 3X3 | 6001777.3063 | 2109242.3472 | 37.7716776256193 | -122.43724155970399 | (37.7716776256193, -122.437241559704) | |
| 23183 | 23183 | 5156 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 270 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/1990 12:00:00 AM | 2 | 6001844.2525 | 2109252.3731 | 37.7717089596497 | -122.43701070699899 | (37.7717089596497, -122.437010706999) | |||
| 18219 | 18219 | 5158 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 275 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 03/27/1990 12:00:00 AM | 3 | 3X3 | 6001773.6501 | 2109268.6052 | 37.771749515715605 | -122.437256087151 | (37.7717495157156, -122.437256087151) | |
| 17448 | 17448 | 5159 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 280 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 3 | 3x3 | 6001840.8605 | 2109274.7601 | 37.7717702359874 | -122.43702404315799 | (37.7717702359874, -122.437024043158) | ||
| 23271 | 23271 | 5162 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 286 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6001830.0062 | 2109354.1323 | 37.7719875553506 | -122.43706727247 | (37.7719875553506, -122.43706727247) | |||
| 22107 | 22107 | 5173 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 341 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/15/2016 12:00:00 AM | 3 | 3x3 | 6001719.8045 | 2109652.5045 | 37.7728005464855 | -122.437469837978 | (37.7728005464855, -122.437469837978) | ||
| 17572 | 17572 | 5174 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 350 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/28/2006 12:00:00 AM | 3 | 3x4 | 6001785.2321 | 2109677.0482 | 37.7728716568906 | -122.437245274575 | (37.7728716568906, -122.437245274575) | |
| 20938 | 20938 | 5183 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 444 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1997 12:00:00 AM | 8 | 3X3 | 6001739.9704 | 2109977.4732 | 37.773693975909296 | -122.437423356744 | (37.7736939759093, -122.437423356744) | ||
| 5886 | 5886 | 5187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 505 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3 | 3X3 | 6001641.6836 | 2110218.0701 | 37.7743490065847 | -122.43778058071699 | (37.7743490065847, -122.437780580717) | ||
| 2484 | 2484 | 5197 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 631 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 3X3 | 6001585.1623 | 2110622.5519999997 | 37.7754563984119 | -122.438005076955 | (37.7754563984119, -122.438005076955) | |
| 3798 | 3798 | 5199 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 643 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001573.1748 | 2110709.1284 | 37.7756934337528 | -122.43805274745701 | (37.7756934337528, -122.438052747457) | |
| 8085 | 8085 | 5202 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 740 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/15/2005 12:00:00 AM | 3 | 3X4 | 6001595.2588 | 2111007.3853 | 37.7765136281427 | -122.437997722367 | (37.7765136281427, -122.437997722367) | |
| 8311 | 8311 | 5206 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 793 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/10/1993 12:00:00 AM | 3 | 4X4 | 6001519.3329 | 2111090.328 | 37.7767370498578 | -122.438266314655 | (37.7767370498578, -122.438266314655) | |
| 657 | 657 | 5214 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 835 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 12/09/2001 12:00:00 AM | 3 | 3X3 | 6001489.0793 | 2111327.2763 | 37.7773859294292 | -122.438387950593 | (37.7773859294292, -122.438387950593) | |
| 9356 | 9356 | 5932 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1355 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6004005.8425 | 2112845.6747 | 37.781697906038 | -122.429789972847 | (37.781697906038, -122.429789972847) | |||
| 3626 | 3626 | 5935 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1357 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6003980.6032 | 2112841.5446 | 37.7816851365454 | -122.429876994211 | (37.7816851365454, -122.429876994211) | |||
| 18181 | 18181 | 7048 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6001113.3036400005 | 2110008.37363 | 37.7737431739315 | -122.43959330500601 | (37.7737431739315, -122.439593305006) | ||||
| 1040 | 1040 | 7083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1790 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998868.4415 | 2109744.0912 | 37.772889499766606 | -122.447339580133 | (37.7728894997666, -122.447339580133) | |||
| 2634 | 2634 | 7336 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002905.15105 | 2115557.99031 | 37.789082847149 | -122.43379176139601 | (37.789082847149, -122.433791761396) | |
| 23238 | 23238 | 7352 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2261 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 4 | 3X3 | 6002787.84589 | 2116061.09761 | 37.79045759399 | -122.434233603703 | (37.79045759399, -122.434233603703) | ||
| 6693 | 6693 | 7357 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2306 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002807.95732 | 2116239.44488 | 37.7909484313614 | -122.43417677466499 | (37.7909484313614, -122.434176774665) | |||
| 3054 | 3054 | 7358 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2318 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6002802.77917 | 2116286.9525200003 | 37.791078581270106 | -122.434198088572 | (37.7910785812701, -122.434198088572) | ||
| 8276 | 8276 | 7371 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2430 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6002752.41216 | 2116639.2393 | 37.7920430115354 | -122.43439755460501 | (37.7920430115354, -122.434397554605) | ||
| 99 | 99 | 7992 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2247 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2007 12:00:00 AM | 3 | 3X3 | 6005467.69382 | 2117725.44397 | 37.7951792074025 | -122.42507996488001 | (37.7951792074025, -122.42507996488) | ||
| 6544 | 6544 | 8114 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1991 12:00:00 AM | 24 | 3X3 | 6003807.6781 | 2111475.048 | 37.7779232822146 | -122.430377706699 | (37.7779232822146, -122.430377706699) | ||
| 22377 | 22377 | 9193 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 6137 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5987931.1239 | 2112533.881 | 37.77991842635 | -122.485377329982 | (37.77991842635, -122.485377329982) | ||
| 88196 | 88196 | 9861 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1350X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2009 12:00:00 AM | 3 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | ||
| 20726 | 20726 | 10242 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 80X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6005765.1512 | 2109670.3256 | 37.77307863760571 | -122.423477773641 | (37.7730786376057, -122.423477773641) | |||
| 19198 | 19198 | 10243 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 80X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/2000 12:00:00 AM | 8 | 3X3 | 6005750.7633 | 2109671.0107 | 37.7730797066295 | -122.423527591987 | (37.7730797066295, -122.423527591987) | ||
| 89922 | 89922 | 10245 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 99X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2008 12:00:00 AM | 6 | 3X3 | Permit Number 769626 | 6005669.1162393 | 2109600.6288971 | 37.7728818463732 | -122.42380501439399 | (37.7728818463732, -122.423805014394) | |
| 14658 | 14658 | 10994 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1520 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2013 12:00:00 AM | 3 | 3X3 | 6016116.07134 | 2097158.9292099997 | 37.7393037809554 | -122.38679962052099 | (37.7393037809554, -122.386799620521) | ||
| 6239 | 6239 | 11016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 6007002.01732 | 2121033.5199 | 37.804348902732 | -122.42000582623301 | (37.804348902732, -122.420005826233) | |||
| 6089 | 6089 | 11017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2540 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007000.76456 | 2121055.6377 | 37.8044095620003 | -122.420011732067 | (37.8044095620003, -122.420011732067) | |||
| 7081 | 7081 | 11436 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2100X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1998 12:00:00 AM | 3 | 3X3 | 6005581.912830001 | 2117259.85377 | 37.793907265665496 | -122.424651612384 | (37.7939072656655, -122.424651612384) | ||
| 23308 | 23308 | 14725 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 875 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 3 | 4x4 | 6001473.8635 | 2111422.6287 | 37.7776468775862 | -122.43844742023799 | (37.7776468775862, -122.438447420238) | ||
| 21458 | 21458 | 15303 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1640 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006940.6411 | 2109195.4029 | 37.771840890188706 | -122.41937789844299 | (37.7718408901887, -122.419377898443) | |||
| 21472 | 21472 | 15304 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006931.2074 | 2109169.6745 | 37.7717697147956 | -122.41940870477801 | (37.7717697147956, -122.419408704778) | |||
| 18069 | 18069 | 15305 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006919.2009 | 2109139.6581 | 37.7716866206556 | -122.41944810628799 | (37.7716866206556, -122.419448106288) | |||
| 17219 | 17219 | 15306 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1650 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2012 12:00:00 AM | 12 | 4X4 | 6006908.0519 | 2109118.2179 | 37.7716271230049 | -122.41948515010701 | (37.7716271230049, -122.419485150107) | ||
| 23198 | 23198 | 16002 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3 | 6001503.91519 | 2094647.64932 | 37.7315885348642 | -122.43714210651699 | (37.7315885348642, -122.437142106517) | |||
| 21898 | 21898 | 16003 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/1991 12:00:00 AM | 6 | 8 | 6001466.12546 | 2094649.0700400001 | 37.731590287660204 | -122.437272854464 | (37.7315902876602, -122.437272854464) | ||
| 22999 | 22999 | 16007 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 8 | 6001364.53052 | 2094649.25854 | 37.7315850293086 | -122.43762410089799 | (37.7315850293086, -122.437624100898) | |||
| 17206 | 17206 | 16009 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001288.3370900005 | 2094653.38984 | 37.731592040430705 | -122.43788781177099 | (37.7315920404307, -122.437887811771) | ||
| 19708 | 19708 | 16012 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001201.17189 | 2094653.91848 | 37.7315885348835 | -122.43818919619301 | (37.7315885348835, -122.438189196193) | ||
| 18176 | 18176 | 16013 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6001154.39221 | 2094654.56847 | 37.731587658935396 | -122.43835096892201 | (37.7315876589354, -122.438350968922) | |||
| 21150 | 21150 | 16014 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000994.83808 | 2094657.2357700001 | 37.731585906153605 | -122.438902768653 | (37.7315859061536, -122.438902768653) | |||
| 17507 | 17507 | 16015 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000956.04768 | 2094656.76286 | 37.731582400588294 | -122.43903684047899 | (37.7315824005883, -122.439036840479) | |||
| 17516 | 17516 | 16016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000925.306059999 | 2094658.03828 | 37.7315841533775 | -122.43914321141001 | (37.7315841533775, -122.43914321141) | |||
| 20419 | 20419 | 16017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000892.30856 | 2094658.72213 | 37.7315841533843 | -122.43925733896002 | (37.7315841533843, -122.43925733896) | |||
| 20950 | 20950 | 16018 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/17/1999 12:00:00 AM | 3 | 4 | 6000862.51501 | 2094659.33961 | 37.7315841533767 | -122.439360385099 | (37.7315841533767, -122.439360385099) | ||
| 20041 | 20041 | 16019 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2003 12:00:00 AM | 3 | 3x3 | 6001362.879269999 | 2094609.69043 | 37.7314762904984 | -122.43762697692301 | (37.7314762904984, -122.437626976923) | ||
| 22125 | 22125 | 16043 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 6000692.70251 | 2094661.9023 | 37.731581524671995 | -122.43994764238701 | (37.731581524672, -122.439947642387) | |||
| 22159 | 22159 | 16044 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000655.54054 | 2094662.67277 | 37.7315815246572 | -122.44007617349399 | (37.7315815246572, -122.440076173494) | |||
| 22122 | 22122 | 16045 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5x250 | 6000618.04474 | 2094662.8118599998 | 37.731579771873 | -122.440205813454 | (37.731579771873, -122.440205813454) | |||
| 20214 | 20214 | 16047 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6000544.66834 | 2094663.6950599998 | 37.731578019092396 | -122.440459552683 | (37.7315780190924, -122.440459552683) | ||||
| 18343 | 18343 | 16048 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 200X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 4 | 6000504.30929 | 2094664.8510599998 | 37.7315788950381 | -122.440599164328 | (37.7315788950381, -122.440599164328) | ||
| 18764 | 18764 | 16103 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/18/2012 12:00:00 AM | 2 | 5 | 6000043.907980001 | 2094672.48858 | 37.7315736376005 | -122.44219140500799 | (37.7315736376005, -122.442191405008) | ||
| 22058 | 22058 | 16104 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 6000001.946959999 | 2094673.6785799998 | 37.7315745135446 | -122.44233655741199 | (37.7315745135446, -122.442336557412) | |||
| 21018 | 21018 | 16105 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999954.50012 | 2094673.06778 | 37.731570132038605 | -122.44250054607001 | (37.7315701320386, -122.44250054607) | |||
| 20512 | 20512 | 16106 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999928.25024 | 2094674.5701 | 37.731572760761104 | -122.44259140457599 | (37.7315727607611, -122.442591404576) | |||
| 21825 | 21825 | 16108 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999847.20496 | 2094676.5721 | 37.73157363759471 | -122.442871736768 | (37.7315736375947, -122.442871736768) | ||
| 20576 | 20576 | 16110 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999765.47289 | 2094676.3542 | 37.731568379273604 | -122.44315428395299 | (37.7315683792736, -122.443154283953) | |||
| 19414 | 19414 | 16111 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999725.13349 | 2094678.46865 | 37.7315718848268 | -122.443293896493 | (37.7315718848268, -122.443293896493) | |||
| 20443 | 20443 | 16112 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999693.39114 | 2094677.85118 | 37.7315683792706 | -122.443403591302 | (37.7315683792706, -122.443403591302) | |||
| 17126 | 17126 | 16113 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999657.47743 | 2094677.0013700002 | 37.7315639977654 | -122.443527690574 | (37.7315639977654, -122.443527690574) | ||
| 22037 | 22037 | 16114 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999608.79533 | 2094678.6509200002 | 37.731565750540206 | -122.44369611198299 | (37.7315657505402, -122.443696111983) | ||
| 17393 | 17393 | 16115 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999569.73094 | 2094680.4197799999 | 37.7315683792686 | -122.44383129178101 | (37.7315683792686, -122.443831291781) | ||
| 20825 | 20825 | 16116 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999533.21631 | 2094681.49769 | 37.7315692561025 | -122.443957606973 | (37.7315692561025, -122.443957606973) | |||
| 20548 | 20548 | 16117 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999494.77273 | 2094682.2963900003 | 37.7315692561142 | -122.444090570848 | (37.7315692561142, -122.444090570848) | |||
| 19610 | 19610 | 16184 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999406.634869999 | 2094682.7033 | 37.7315653449635 | -122.444395308802 | (37.7315653449635, -122.444395308802) | |||
| 21731 | 21731 | 16185 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999375.230880001 | 2094682.54623 | 37.7315631218391 | -122.444503866854 | (37.7315631218391, -122.444503866854) | |||
| 18929 | 18929 | 16187 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999317.5789 | 2094684.3827099998 | 37.731564874619 | -122.44470331222901 | (37.731564874619, -122.444703312229) | |||
| 23328 | 23328 | 16189 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 9 | 5 | 5999260.86144 | 2094684.92317 | 37.73156312182861 | -122.444899433678 | (37.7315631218286, -122.444899433678) | ||
| 21947 | 21947 | 16332 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996671.90319 | 2094716.4869400002 | 37.7315016936337 | -122.45385219544599 | (37.7315016936337, -122.453852195446) | ||
| 20748 | 20748 | 16333 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996646.10828 | 2094717.76023 | 37.73150371082821 | -122.45394146482501 | (37.7315037108282, -122.453941464825) | ||
| 19005 | 19005 | 16334 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996621.72685 | 2094716.0654099998 | 37.731497659285104 | -122.45402563328001 | (37.7314976592851, -122.45402563328) | ||
| 16929 | 16929 | 16335 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996588.55754 | 2094717.49275 | 37.7314996764704 | -122.454140408353 | (37.7314996764704, -122.454140408353) | ||
| 19907 | 19907 | 16336 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996559.751619999 | 2094715.89038 | 37.7314936249086 | -122.454239879686 | (37.7314936249086, -122.454239879686) | ||
| 21442 | 21442 | 16337 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996530.991719999 | 2094716.49105 | 37.7314936249203 | -122.45433935097799 | (37.7314936249203, -122.454339350978) | ||
| 17099 | 17099 | 16338 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 862X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996505.10477 | 2094713.35848 | 37.7314835390346 | -122.454428620411 | (37.7314835390346, -122.454428620411) | ||
| 23159 | 23159 | 16339 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 2 | 5 | 5996276.20802 | 2094704.1816900002 | 37.7314452117282 | -122.45521929265 | (37.7314452117282, -122.45521929265) | ||
| 23095 | 23095 | 16341 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 2 | 5 | 5996216.96756 | 2094693.6651599999 | 37.7314129368354 | -122.45542333713999 | (37.7314129368354, -122.45542333714) | ||
| 17060 | 17060 | 16342 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 890X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5996198.48565 | 2094691.8474400002 | 37.731406885306704 | -122.455487100866 | (37.7314068853067, -122.455487100866) | |||
| 20585 | 20585 | 16345 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 946X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5995755.81545 | 2094589.49777 | 37.731100446724206 | -122.457010084748 | (37.7311004467242, -122.457010084748) | ||
| 21903 | 21903 | 16349 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 946X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995791.20776 | 2094597.86 | 37.731125439778204 | -122.45688833275699 | (37.7311254397782, -122.456888332757) | ||
| 80782 | 80782 | 16487 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 220 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2000 12:00:00 AM | 2 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | ||
| 82782 | 82782 | 17826 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1928 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3X3 | 6004701.289884401 | 2115414.9947817 | 37.7887919749393 | -122.42756715703501 | (37.7887919749393, -122.427567157035) | |||
| 94118 | 94118 | 18248 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1820 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2014 12:00:00 AM | 3 | 4x4 | 6003464.0885233 | 2114201.9619764998 | 37.7853912373247 | -122.43176105203999 | (37.7853912373247, -122.43176105204) | ||
| 126270 | 126270 | 18249 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1820 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2014 12:00:00 AM | 3 | 4x4 | 6003464.0885233 | 2114201.9619764998 | 37.7853912373247 | -122.43176105203999 | (37.7853912373247, -122.43176105204) | ||
| 114049 | 114049 | 18252 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1830 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2014 12:00:00 AM | 3 | 4X4 | 6003416.3649635 | 2114195.205569 | 37.785369980601395 | -122.431925678527 | (37.7853699806014, -122.431925678527) | ||
| 8237 | 8237 | 18921 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 2657 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002082.518999999 | 2115701.12329 | 37.789429139198 | -122.43664820785101 | (37.789429139198, -122.436648207851) | ||
| 145713 | 145713 | 19310 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 375 07th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6010658.6989499 | 2110585.1273498 | 37.7758654588782 | -122.406614766861 | (37.7758654588782, -122.406614766861) | |||
| 15092 | 15092 | 22219 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4301 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1996 12:00:00 AM | 6 | 3x3 | 6015377.5406 | 2096805.4325 | 37.7382922337956 | -122.389328474573 | (37.7382922337956, -122.389328474573) | ||
| 15273 | 15273 | 22220 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4301 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015388.4053 | 2096841.333 | 37.7383914115765 | -122.389293415685 | (37.7383914115765, -122.389293415685) |
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");