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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188941 | 188941 | 196738 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 700 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6013717.49862 | 2109926.74166 | 37.7742283375105 | -122.395987369746 | (37.7742283375105, -122.395987369746) | |||
| 188910 | 188910 | 239118 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005833.23887 | 2097623.0492 | 37.7400034633796 | -122.422386096966 | (37.7400034633796, -122.422386096966) | |||
| 188833 | 188833 | 196639 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013190.96727 | 2115199.73755 | 37.7886774642349 | -122.39817876753901 | (37.7886774642349, -122.398178767539) | |||
| 188697 | 188697 | 71536 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1159 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1995 12:00:00 AM | 8 | 3x3 | 6007487.54298 | 2118815.04438 | 37.798284870413205 | -122.41816824147499 | (37.7982848704132, -122.418168241475) | ||
| 188687 | 188687 | 68019 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2927 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 7 | Permit Number 31750 | 6000097.9398 | 2116409.89837 | 37.7912622695816 | -122.443565543936 | (37.7912622695816, -122.443565543936) | ||
| 188667 | 188667 | 196903 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 573 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009901.61118 | 2111689.82279 | 37.7788563072197 | -122.409311714366 | (37.7788563072197, -122.409311714366) | |||
| 188656 | 188656 | 196698 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 65 Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015525.89304 | 2112525.10676 | 37.7814633132332 | -122.389913293768 | (37.7814633132332, -122.389913293768) | |||
| 188643 | 188643 | 196919 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 53 Moss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010276.638280001 | 2111289.5019799997 | 37.7777781243999 | -122.407986102881 | (37.7777781243999, -122.407986102881) | |||
| 188588 | 188588 | 31462 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 682 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35028 | 6001206.44142 | 2102402.15102 | 37.7528636562457 | -122.438725984431 | (37.7528636562457, -122.438725984431) | |
| 188567 | 188567 | 136091 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1916 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999479.5114 | 2115623.26075 | 37.7890670802258 | -122.44564868855801 | (37.7890670802258, -122.445648688558) | |||
| 188505 | 188505 | 196928 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 667 Natoma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009246.27006 | 2111064.44839 | 37.7771024385604 | -122.411534611859 | (37.7771024385604, -122.411534611859) | |||
| 188405 | 188405 | 196894 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 550 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009917.78835 | 2112002.5605900004 | 37.7797159179018 | -122.409277826124 | (37.7797159179018, -122.409277826124) | |||
| 188341 | 188341 | 179203 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 145 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6005739.90981 | 2087176.84104 | 37.711315190823996 | -122.42196691216101 | (37.711315190824, -122.421966912161) | |||
| 188292 | 188292 | 244395 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 250 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005640.2215 | 2110270.1555 | 37.7747185734329 | -122.42395258406201 | (37.7747185734329, -122.423952584062) | |||
| 188069 | 188069 | 238998 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 237 Murray St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6005671.29421 | 2095363.94691 | 37.7337913369956 | -122.42278552813801 | (37.7337913369956, -122.422785528138) | |||
| 187831 | 187831 | 196814 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 33 El Dorado St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014435.70341 | 2109328.09234 | 37.7726245117464 | -122.393461046391 | (37.7726245117464, -122.393461046391) | |||
| 187815 | 187815 | 239082 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 317 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004381.044840001 | 2098955.92162 | 37.743581200324705 | -122.427502117952 | (37.7435812003247, -122.427502117952) | |||
| 187805 | 187805 | 196753 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 487 Irwin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012689.78544 | 2107249.47273 | 37.766819929316796 | -122.399354451245 | (37.7668199293168, -122.399354451245) | |||
| 187757 | 187757 | 87922 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1395 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50946 | 5999715.0612 | 2113582.0975 | 37.78347602281 | -122.44468694783998 | (37.78347602281, -122.44468694784) | |
| 187728 | 187728 | 200902 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4416 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015218.1139 | 2096574.2046 | 37.7376484892402 | -122.389863551378 | (37.7376484892402, -122.389863551378) | |||
| 187724 | 187724 | 51378 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 356 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52402 | 6008451.43576 | 2108652.78079 | 37.77043595219121 | -122.414113542812 | (37.7704359521912, -122.414113542812) | |
| 187680 | 187680 | 196796 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014723.95191 | 2109669.16518 | 37.773577033196204 | -122.392487818086 | (37.7735770331962, -122.392487818086) | |||
| 187557 | 187557 | 196786 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014545.78878 | 2109500.25162 | 37.7731033386819 | -122.39309229468799 | (37.7731033386819, -122.393092294688) | |||
| 187556 | 187556 | 38132 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 124 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 11 | Permit Number 40294 | 6010207.56655 | 2094013.9745900002 | 37.7303395024441 | -122.407007086532 | (37.7303395024441, -122.407007086532) | |
| 187475 | 187475 | 239962 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 25 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003740.83006 | 2095504.19178 | 37.7340673074409 | -122.429469715881 | (37.7340673074409, -122.429469715881) | |||
| 187441 | 187441 | 196946 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 99 12th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007246.13961 | 2109512.76585 | 37.7727294949985 | -122.418343661457 | (37.7727294949985, -122.418343661457) | |||
| 187375 | 187375 | 241261 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 486 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003744.66142 | 2095931.40527 | 37.7352405557993 | -122.429486926192 | (37.7352405557993, -122.429486926192) | |||
| 187313 | 187313 | 196839 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014031.56995 | 2108999.22033 | 37.7716990401192 | -122.394835960523 | (37.7716990401192, -122.394835960523) | |||
| 187278 | 187278 | 240087 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4622 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000430.4695 | 2105219.39933 | 37.7605549569544 | -122.441611589629 | (37.7605549569544, -122.441611589629) | |||
| 187161 | 187161 | 240050 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 358 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6001769.88545 | 2103764.57132 | 37.75663657304471 | -122.43687501869499 | (37.7566365730447, -122.436875018695) | |||
| 187067 | 187067 | 183585 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2606 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5989277.5276 | 2097568.6045 | 37.738906153494604 | -122.479624287376 | (37.7389061534946, -122.479624287376) | |||
| 187053 | 187053 | 240120 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 566 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003005.9494900005 | 2108932.50155 | 37.770896632595104 | -122.43296947078899 | (37.7708966325951, -122.432969470789) | |||
| 187023 | 187023 | 200815 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4712 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014972.6287 | 2095744.38 | 37.7353563435844 | -122.39065434665301 | (37.7353563435844, -122.390654346653) | |||
| 186966 | 186966 | 196640 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013174.26856 | 2115217.53007 | 37.7887253882096 | -122.39823779183901 | (37.7887253882096, -122.398237791839) | |||
| 186906 | 186906 | 213815 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Bright St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993752.55241 | 2089797.0379599999 | 37.717826272530296 | -122.46358797533199 | (37.7178262725303, -122.463587975332) | |||
| 186899 | 186899 | 50249 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1379 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 4 | Permit Number 46954 | 5985223.881 | 2105833.3788 | 37.761362655281296 | -122.49424873007 | (37.7613626552813, -122.49424873007) | |
| 186874 | 186874 | 95891 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1691 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767599 | 5989637.9664 | 2103875.5933 | 37.7562444194269 | -122.478839232097 | (37.7562444194269, -122.478839232097) |
| 186862 | 186862 | 196791 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014640.47639 | 2109590.9368 | 37.7733575994987 | -122.39277110091999 | (37.7733575994987, -122.39277110092) | |||
| 186813 | 186813 | 43524 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1664 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 9 | Permit Number 43200 | 5999863.2001 | 2110580.0951 | 37.775241746809 | -122.44395868218001 | (37.775241746809, -122.44395868218) | |
| 186762 | 186762 | 83484 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 901 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 3x3 | 6015527.06927 | 2104778.0236400003 | 37.760191590401895 | -122.389368063579 | (37.7601915904019, -122.389368063579) | |
| 186647 | 186647 | 239811 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 274 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001372.4743099995 | 2096481.92399 | 37.736617556357295 | -122.43772784398199 | (37.7366175563573, -122.437727843982) | |||
| 186610 | 186610 | 196569 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 135 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012302.0736 | 2112487.66932 | 37.7811812066792 | -122.40106358941401 | (37.7811812066792, -122.401063589414) | |||
| 186499 | 186499 | 38042 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1519 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | 12 | Permit Number 40244 | 6000101.0605 | 2114283.5706 | 37.785424105748504 | -122.443401947573 | (37.7854241057485, -122.443401947573) | ||
| 186389 | 186389 | 239095 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 112 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007581.45918 | 2098108.31687 | 37.741434363915296 | -122.416375818915 | (37.7414343639153, -122.416375818915) | |||
| 186265 | 186265 | 239928 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 206 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007140.86262 | 2106037.94985 | 37.7631825421642 | -122.418461390798 | (37.7631825421642, -122.418461390798) | |||
| 186237 | 186237 | 83297 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1275 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52349 | 6014937.0242 | 2090629.5080000001 | 37.7213099551379 | -122.390420176721 | (37.7213099551379, -122.390420176721) | |
| 186134 | 186134 | 239779 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 134 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004850.3334099995 | 2097388.6529200003 | 37.7393043691052 | -122.42576790127501 | (37.7393043691052, -122.425767901275) | |||
| 186022 | 186022 | 179235 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 441 Otsego Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000167.6528 | 2091338.8282700002 | 37.7224272266287 | -122.441524461489 | (37.7224272266287, -122.441524461489) | |||
| 185889 | 185889 | 142577 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 650 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008711.1911 | 2120767.1023 | 37.8037135334497 | -122.414072209035 | (37.8037135334497, -122.414072209035) | |||
| 185866 | 185866 | 179189 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1600 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6007006.17756 | 2087541.64708 | 37.712388206122 | -122.417616198935 | (37.712388206122, -122.417616198935) | |||
| 185850 | 185850 | 179229 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1725 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006523.82481 | 2087658.59053 | 37.712682154019 | -122.41929165028999 | (37.712682154019, -122.41929165029) | |||
| 185798 | 185798 | 136152 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 941 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007813.62095 | 2120247.54124 | 37.8022364959693 | -122.41714146932699 | (37.8022364959693, -122.417141469327) | |||
| 185745 | 185745 | 196845 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014159.82907 | 2109124.9912400004 | 37.7720515096025 | -122.394401108645 | (37.7720515096025, -122.394401108645) | |||
| 185677 | 185677 | 239827 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 633 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007986.739080001 | 2095945.35932 | 37.7355181396477 | -122.41482145406499 | (37.7355181396477, -122.414821454065) | |||
| 185436 | 185436 | 142272 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1711 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999547.2097 | 2110832.0565 | 37.77591553833879 | -122.445069878647 | (37.7759155383388, -122.445069878647) | |||
| 185276 | 185276 | 196732 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6013804.62736 | 2109925.7165900003 | 37.774230369978206 | -122.39568590169901 | (37.7742303699782, -122.395685901699) | |||
| 185266 | 185266 | 213775 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5999015.12983 | 2094689.3935 | 37.731561369058795 | -122.44574929389799 | (37.7315613690588, -122.445749293898) | |||
| 185263 | 185263 | 238873 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1515 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007797.51534 | 2100807.55583 | 37.7488580191957 | -122.415819857105 | (37.7488580191957, -122.415819857105) | |||
| 185193 | 185193 | 179266 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010179.8891900005 | 2094106.5386 | 37.730592114813106 | -122.40710929357401 | (37.7305921148131, -122.407109293574) | |||
| 185184 | 185184 | 87980 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1610 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51017 | 6001351.6536 | 2111477.989 | 37.7777919307589 | -122.43887415306601 | (37.7777919307589, -122.438874153066) | |
| 185180 | 185180 | 239897 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 166 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007503.26191 | 2100211.8679400003 | 37.7472058476779 | -122.41679519163799 | (37.7472058476779, -122.416795191638) | |||
| 185119 | 185119 | 238862 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1745 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6008032.75507 | 2108079.03464 | 37.768837054702296 | -122.41552113829201 | (37.7688370547023, -122.415521138292) | |||
| 185096 | 185096 | 239058 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 20 12th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6006773.25545 | 2110003.70384 | 37.7740508625963 | -122.420014269057 | (37.7740508625963, -122.420014269057) | |||
| 185051 | 185051 | 141463 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2157 Turk Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996786.4976 | 2111559.9106 | 37.7777560788116 | -122.45467243833201 | (37.7777560788116, -122.454672438332) | |||
| 184947 | 184947 | 247393 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 250 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001856.4636 | 2109164.1818 | 37.771467502315105 | -122.436962153303 | (37.7714675023151, -122.436962153303) | |||
| 184935 | 184935 | 196666 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 68 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013613.104830001 | 2114379.58013 | 37.7864490062589 | -122.396660705651 | (37.7864490062589, -122.396660705651) | |||
| 184915 | 184915 | 239875 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 43 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007016.10744 | 2097051.6983 | 37.7385013158886 | -122.41825571763201 | (37.7385013158886, -122.418255717632) | |||
| 184857 | 184857 | 213807 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 235 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992444.29236 | 2089435.87285 | 37.7167591325169 | -122.46808375276501 | (37.7167591325169, -122.468083752765) | |||
| 184765 | 184765 | 40106 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 181 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1999 12:00:00 AM | 7 | Permit Number 41329 | 6012472.734619999 | 2113959.78706 | 37.785232818893796 | -122.400576625419 | (37.7852328188938, -122.400576625419) | ||
| 184720 | 184720 | 239982 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3825 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002902.151190001 | 2103553.52874 | 37.7561213883181 | -122.43294416114401 | (37.7561213883181, -122.432944161144) | |||
| 184647 | 184647 | 196924 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 667 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009138.81566 | 2110960.87293 | 37.7768120168914 | -122.41189901082701 | (37.7768120168914, -122.411899010827) | |||
| 184604 | 184604 | 136106 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2362 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002236.434090001 | 2117779.37436 | 37.7951442255914 | -122.436264471651 | (37.7951442255914, -122.436264471651) | |||
| 184356 | 184356 | 85043 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3130 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | 5 | Permit Number 49389 | 5999168.28904 | 2116653.82857 | 37.7918789742834 | -122.44679965798201 | (37.7918789742834, -122.446799657982) | ||
| 184297 | 184297 | 141329 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 DIVISADERO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001601.6784 | 2110514.3981 | 37.7751603741656 | -122.437940195457 | (37.7751603741656, -122.437940195457) | |||
| 184258 | 184258 | 239759 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 116 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000587.00227 | 2102370.2843299997 | 37.7527408987832 | -122.44086582861401 | (37.7527408987832, -122.440865828614) | |||
| 184252 | 184252 | 136097 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2240 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5999362.2119 | 2116523.51189 | 37.791532235263 | -122.44611930918 | (37.791532235263, -122.44611930918) | |||
| 184209 | 184209 | 239903 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 295 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008110.622880001 | 2100265.18529 | 37.7473863883693 | -122.41469875055701 | (37.7473863883693, -122.414698750557) | |||
| 184195 | 184195 | 179192 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005649.34848 | 2087217.2749299998 | 37.711421105778996 | -122.422282786434 | (37.711421105779, -122.422282786434) | |||
| 184118 | 184118 | 196685 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 5 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015747.42013 | 2114320.2374 | 37.786404619334995 | -122.389272300177 | (37.786404619335, -122.389272300177) | |||
| 184085 | 184085 | 142681 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2345 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008860.4852 | 2121282.3664 | 37.8051367036076 | -122.413592032358 | (37.8051367036076, -122.413592032358) | |||
| 184045 | 184045 | 196606 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1611 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015106.86679 | 2096793.2963 | 37.7382439002338 | -122.39026349157801 | (37.7382439002338, -122.390263491578) | |||
| 183760 | 183760 | 240099 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 147 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001722.97676 | 2107981.90598 | 37.768213677952396 | -122.43733921904 | (37.7682136779524, -122.43733921904) | |||
| 183740 | 183740 | 240033 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 184 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002672.56887 | 2104805.7331 | 37.7595466164104 | -122.433827631758 | (37.7595466164104, -122.433827631758) | |||
| 183599 | 183599 | 38092 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2621 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 5 | Permit Number 40263 | 5999856.623 | 2113995.9469 | 37.7846204232073 | -122.44422694964199 | (37.7846204232073, -122.444226949642) | |
| 183566 | 183566 | 51934 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 329 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48161 | 6009143.0719 | 2121468.7430000002 | 37.8056643107542 | -122.41262728712401 | (37.8056643107542, -122.412627287124) | ||
| 183544 | 183544 | 142273 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1709 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999577.3473 | 2110836.1048 | 37.7759283740152 | -122.44496591634301 | (37.7759283740152, -122.444965916343) | |||
| 183444 | 183444 | 238991 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3637 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006014.8844 | 2100805.0541 | 37.748750773249604 | -122.421984025369 | (37.7487507732496, -122.421984025369) | |||
| 183417 | 183417 | 179267 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010181.968780001 | 2094096.33238 | 37.7305642070683 | -122.407101384948 | (37.7305642070683, -122.407101384948) | |||
| 183343 | 183343 | 238995 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 153 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999955.26399 | 2099194.8588400004 | 37.743985946509106 | -122.442822485391 | (37.7439859465091, -122.442822485391) | |||
| 183336 | 183336 | 247915 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 399 Franconia St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6009998.26355 | 2098850.98079 | 37.7436091683313 | -122.40807167067899 | (37.7436091683313, -122.408071670679) | ||||
| 183331 | 183331 | 239992 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3909 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003720.93642 | 2102429.88349 | 37.7530825314568 | -122.430032373991 | (37.7530825314568, -122.430032373991) | |||
| 183236 | 183236 | 240004 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3652 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004018.74706 | 2103079.19998 | 37.75488226370771 | -122.42904877829399 | (37.7548822637077, -122.429048778294) | |||
| 183217 | 183217 | 179262 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 705 Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005334.00984 | 2092468.15203 | 37.7258210881568 | -122.42374579274299 | (37.7258210881568, -122.423745792743) | |||
| 183121 | 183121 | 196909 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 825 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011661.65594 | 2113037.22926 | 37.782654423891 | -122.403317801301 | (37.782654423891, -122.403317801301) | |||
| 183113 | 183113 | 92639 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 7 Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52933 | 6009235.308999999 | 2121324.4615 | 37.8052733261346 | -122.41229788192499 | (37.8052733261346, -122.412297881925) | |
| 183110 | 183110 | 238888 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1271 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007719.0541900005 | 2102241.91572 | 37.7527920360485 | -122.416192749296 | (37.7527920360485, -122.416192749296) | |||
| 183073 | 183073 | 196731 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 701 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6013816.70358 | 2109911.7759700003 | 37.77419276392529 | -122.395643150631 | (37.7741927639253, -122.395643150631) | |||
| 183026 | 183026 | 123992 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 25 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5993916.63839 | 2115358.1063200003 | 37.788019869485 | -122.46487609629601 | (37.788019869485, -122.464876096296) | |||
| 182968 | 182968 | 52347 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 69 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2005 12:00:00 AM | 2 | Permit Number 48490 | 6013658.27605 | 2114387.0287099998 | 37.7864719722494 | -122.396504945749 | (37.7864719722494, -122.396504945749) | ||
| 182958 | 182958 | 142109 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 740 DIVISADERO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001591.7624 | 2111027.0249 | 37.7765673547102 | -122.43801122451 | (37.7765673547102, -122.43801122451) |
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");