Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64275 | 64275 | 38887 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 316 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998129.6596099995 | 2115308.75845 | 37.788126381265705 | -122.45029630035101 | (37.7881263812657, -122.450296300351) | |
| 175626 | 175626 | 38888 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 316 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998132.12011 | 2115294.26521 | 37.788086727476504 | -122.45028674235 | (37.7880867274765, -122.45028674235) | |
| 131868 | 131868 | 213854 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 494 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5998170.4747 | 2095280.37565 | 37.7331358031646 | -122.44871196830799 | (37.7331358031646, -122.448711968308) | ||||
| 112015 | 112015 | 88138 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 181 Marietta Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804.0 | 2097893.0 | 37.740345654378096 | -122.44670962705798 | (37.7403456543781, -122.446709627058) | |||
| 100297 | 100297 | 46139 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 206 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51613 | 5998984.25754118 | 2106980.434825 | 37.7653078166494 | -122.44674007091601 | (37.7653078166494, -122.446740070916) | ||
| 54443 | 54443 | 136182 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999403.041730001 | 2119664.02877 | 37.800157590747105 | -122.446204044176 | (37.8001575907471, -122.446204044176) | |||
| 60055 | 60055 | 136181 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3140 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999405.9068599995 | 2119644.67772 | 37.8001046215781 | -122.44619273701299 | (37.8001046215781, -122.446192737013) | |||
| 63143 | 63143 | 136180 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.44618771161699 | (37.8000790286731, -122.446187711617) | |||
| 59685 | 59685 | 49557 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Arco Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 7 | Permit Number 46446 | 5999409.77309 | 2093045.0994900002 | 37.7270690458815 | -122.444266822659 | (37.7270690458815, -122.444266822659) | ||
| 33736 | 33736 | 65937 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2826 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1990 12:00:00 AM | 7 | Permit Number 28956 | 5999433.3119 | 2118083.73409 | 37.7958202522453 | -122.44598557278401 | (37.7958202522453, -122.445985572784) | ||
| 113778 | 113778 | 87939 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4489 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50962 | 5999451.0 | 2105708.0 | 37.761840679686706 | -122.44503424165501 | (37.7618406796867, -122.445034241655) | ||
| 113219 | 113219 | 62429 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4475 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50961 | 5999555.98449793 | 2105708.06247977 | 37.7618468426508 | -122.44467114765301 | (37.7618468426508, -122.444671147653) | ||
| 37753 | 37753 | 71351 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 118 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50915 | 5999898.11886666 | 2105092.21291824 | 37.7601753897516 | -122.44344360556002 | (37.7601753897516, -122.44344360556) | ||
| 19735 | 19735 | 96580 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 118145 | 118145 | 96581 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 124009 | 124009 | 96578 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 128212 | 128212 | 96579 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 141032 | 141032 | 96584 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 143214 | 143214 | 96582 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 12107 | 12107 | 26278 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/1998 12:00:00 AM | 3 | 6000476.90225 | 2093497.19967 | 37.728371233643706 | -122.44061019542801 | (37.7283712336437, -122.440610195428) | |||
| 156225 | 156225 | 50665 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 5 | Permit Number 47244 | 6000927.33064 | 2091848.9350299998 | 37.7238711151562 | -122.43893497427901 | (37.7238711151562, -122.438934974279) | ||
| 134822 | 134822 | 246838 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 399 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001188.47767 | 2109990.61312 | 37.7736986862745 | -122.43933199347201 | (37.7736986862745, -122.439331993472) | |||
| 78968 | 78968 | 87763 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1303 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6001194.0 | 2110018.0 | 37.7737741980345 | -122.439314854348 | (37.7737741980345, -122.439314854348) | |||
| 82544 | 82544 | 87968 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
| 121116 | 121116 | 87971 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
| 139567 | 139567 | 87970 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
| 142071 | 142071 | 87969 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
| 139240 | 139240 | 87977 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1372 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51013 | 6001285.0 | 2110422.0 | 37.7748886587191 | -122.43902903105 | (37.7748886587191, -122.43902903105) | ||
| 137614 | 137614 | 136179 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2400 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001333.810430001 | 2119043.17386 | 37.79856296146029 | -122.43947832036501 | (37.7985629614603, -122.439478320365) | |||
| 120951 | 120951 | 85249 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1335 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/19/2007 12:00:00 AM | 3 | 3x3 | under 3 yr maintenance agreement. expires 7/19/2010 | 6001350.124369999 | 2111060.02557 | 37.7766442216524 | -122.43884948393499 | (37.7766442216524, -122.438849483935) | |
| 145363 | 145363 | 85250 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.124369999 | 2111060.02557 | 37.7766442216524 | -122.43884948393499 | (37.7766442216524, -122.438849483935) | |
| 131144 | 131144 | 136178 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2400 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001367.93231 | 2119047.53981 | 37.798576891075 | -122.439360561339 | (37.798576891075, -122.439360561339) | |||
| 81908 | 81908 | 89201 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1627 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51818 | 6001371.0 | 2111438.0 | 37.7776832317385 | -122.43880436100599 | (37.7776832317385, -122.438804361006) | |||
| 146924 | 146924 | 33134 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3107 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | 10 | Permit Number 37364 | 6001390.00916 | 2119109.09622 | 37.798747165093296 | -122.439288583214 | (37.7987471650933, -122.439288583214) | |
| 183575 | 183575 | 136175 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3103 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001391.85411 | 2119087.81282 | 37.7986888314695 | -122.439280672761 | (37.7986888314695, -122.439280672761) | |||
| 18677 | 18677 | 88330 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 544 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.720635228492206 | -122.437157897339 | (37.7206352284922, -122.437157897339) | |||
| 84737 | 84737 | 52663 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 772 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50440 | 6001423.61779826 | 2102059.9147838 | 37.751936310385204 | -122.43795043808201 | (37.7519363103852, -122.437950438082) | |
| 173275 | 173275 | 246856 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 425 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6001680.71036 | 2109929.19364 | 37.773558043107 | -122.43762488777901 | (37.773558043107, -122.437624887779) | |||
| 98815 | 98815 | 43561 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 598 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50500 | 6002046.37252319 | 2099459.05244765 | 37.7448303525831 | -122.435610815213 | (37.7448303525831, -122.435610815213) | ||
| 143812 | 143812 | 88317 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 670 Edinburg St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51308 | 6002238.5 | 2089937.8 | 37.7186980790536 | -122.434265915388 | (37.7186980790536, -122.434265915388) | |||
| 162522 | 162522 | 30565 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | ||
| 91560 | 91560 | 88337 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 686 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51324 | 6002465.0 | 2089669.0 | 37.717972867232795 | -122.43346379852699 | (37.7179728672328, -122.433463798527) | |||
| 46221 | 46221 | 241389 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 47 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002625.8998300005 | 2096003.5312299998 | 37.7353751906151 | -122.43336004273 | (37.7353751906151, -122.43336004273) | |||
| 59733 | 59733 | 78256 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 754 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6002680.72455 | 2088998.08405 | 37.7161429170478 | -122.432670234864 | (37.7161429170478, -122.432670234864) | ||
| 27023 | 27023 | 59880 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.7450599996 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | |
| 89917 | 89917 | 91130 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 52020 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | ||
| 103422 | 103422 | 88738 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 218 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51672 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | ||
| 72431 | 72431 | 136176 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2134 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002833.9768 | 2118210.69092 | 37.7963624418193 | -122.434227733841 | (37.7963624418193, -122.434227733841) | |||
| 166315 | 166315 | 136177 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003216.31619 | 2118958.4665599996 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | |||
| 28335 | 28335 | 241388 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003420.97531 | 2097978.6003400004 | 37.7408433528415 | -122.430752071748 | (37.7408433528415, -122.430752071748) | |||
| 161791 | 161791 | 246445 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 457 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6003558.45361 | 2099788.20108 | 37.7458198862793 | -122.43040580490101 | (37.7458198862793, -122.430405804901) | |||
| 81820 | 81820 | 84105 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3909 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.753073006911706 | -122.430037470862 | (37.7530730069117, -122.430037470862) | ||
| 105018 | 105018 | 84100 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3909 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.753073006911706 | -122.430037470862 | (37.7530730069117, -122.430037470862) | ||
| 91307 | 91307 | 86800 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 71 Miguel St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2007 12:00:00 AM | 3x3 | Permit Number 49752 | 6003860.0 | 2097292.0 | 37.738982969029706 | -122.429185143196 | (37.7389829690297, -122.429185143196) | |||
| 92263 | 92263 | 88346 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 351 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51331 | 6003903.0 | 2091384.0 | 37.722763361623294 | -122.428615443614 | (37.7227633616233, -122.428615443614) | |||
| 29042 | 29042 | 241390 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004068.125469999 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | |||
| 140242 | 140242 | 88315 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 157 Edinburg St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51306 | 6004192.4 | 2092727.9 | 37.7264697879052 | -122.427710754996 | (37.7264697879052, -122.427710754996) | |||
| 33708 | 33708 | 80092 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.798896010091205 | -122.429310324527 | (37.7988960100912, -122.429310324527) | |
| 40771 | 40771 | 241272 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 67 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004275.92505 | 2108860.93687 | 37.770772085482605 | -122.428571490982 | (37.7707720854826, -122.428571490982) | |||
| 40712 | 40712 | 65755 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3036 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 14 | Permit Number 28718 | 6004280.733630001 | 2119630.96227 | 37.80034414971529 | -122.429322978897 | (37.8003441497153, -122.429322978897) | |
| 135539 | 135539 | 83336 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1800-1804 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004282.92403 | 2119104.69719 | 37.798899285440605 | -122.429277851819 | (37.7988992854406, -122.429277851819) | |
| 52439 | 52439 | 241387 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 43 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004298.9077699995 | 2098020.68858 | 37.7410086185538 | -122.42771950655 | (37.7410086185538, -122.42771950655) | |||
| 188471 | 188471 | 241372 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004512.71197 | 2101888.89737 | 37.7516419200596 | -122.427255725271 | (37.7516419200596, -122.427255725271) | |||
| 162285 | 162285 | 241373 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004532.87463 | 2101890.40961 | 37.751647212562204 | -122.427186107874 | (37.7516472125622, -122.427186107874) | |||
| 159534 | 159534 | 241374 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004551.11836 | 2101892.73239 | 37.751654622063604 | -122.427123184105 | (37.7516546220636, -122.427123184105) | |||
| 131083 | 131083 | 241375 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004575.52977 | 2101893.7716599996 | 37.75165885607711 | -122.427038840268 | (37.7516588560771, -122.427038840268) | |||
| 74100 | 74100 | 241376 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3777 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004606.4364 | 2101890.62925 | 37.7516519753774 | -122.426931737306 | (37.7516519753774, -122.426931737306) | |||
| 188859 | 188859 | 241377 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 281 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004660.79755 | 2100144.09881 | 37.7468594809746 | -122.42661939287301 | (37.7468594809746, -122.426619392873) | |||
| 154012 | 154012 | 241378 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 273 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004715.159630001 | 2100148.28162 | 37.746874039199 | -122.426431711567 | (37.746874039199, -122.426431711567) | |||
| 174484 | 174484 | 40680 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 227 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 11 | Permit Number 41663 | 6004891.014880001 | 2093810.36977 | 37.7294815042584 | -122.42537266900601 | (37.7294815042584, -122.425372669006) | |
| 101858 | 101858 | 35784 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51612 | 6004919.48722825 | 2106038.70275083 | 37.7630593064236 | -122.42614444470101 | (37.7630593064236, -122.426144444701) | ||
| 115335 | 115335 | 88018 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3926 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51046 | 6004957.7 | 2095821.3 | 37.735006837707296 | -122.42528517225901 | (37.7350068377073, -122.425285172259) | |||
| 31761 | 31761 | 179275 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 716 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005245.16074 | 2092477.2139400002 | 37.725840954193295 | -122.424053582122 | (37.7258409541933, -122.424053582122) | |||
| 149303 | 149303 | 179276 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 716 Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6005258.78381 | 2092467.95462 | 37.7258162992748 | -122.424005829932 | (37.7258162992748, -122.424005829932) | |||
| 165408 | 165408 | 179277 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 716 Peru Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005276.23831 | 2092458.42558 | 37.725791120054396 | -122.423944813618 | (37.7257911200544, -122.423944813618) | |||
| 59998 | 59998 | 241367 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3747 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005339.63853 | 2104274.22686 | 37.7582382098444 | -122.42456576311199 | (37.7582382098444, -122.424565763112) | |||
| 39431 | 39431 | 241273 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 55 Haight St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005874.88911 | 2109629.37494 | 37.7729723901943 | -122.423095264536 | (37.7729723901943, -122.423095264536) | |||
| 112103 | 112103 | 87451 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 345 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6005911.17036 | 2110956.31285 | 37.7766178884522 | -122.42306409647699 | (37.7766178884522, -122.423064096477) | ||
| 154422 | 154422 | 70110 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 79 Stoneyford Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1999 12:00:00 AM | 9 | 6006114.15907 | 2093862.3893900001 | 37.7296933683514 | -122.42114782490499 | (37.7296933683514, -122.421147824905) | ||
| 74848 | 74848 | 179278 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 223 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006228.66725 | 2093396.90262 | 37.7284216981869 | -122.420718924746 | (37.7284216981869, -122.420718924746) | |||
| 181885 | 181885 | 179279 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 223 Pioche St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006275.12702 | 2093408.7720700002 | 37.7284569075468 | -122.420559152977 | (37.7284569075468, -122.420559152977) | |||
| 185439 | 185439 | 136184 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | |||
| 131604 | 131604 | 136183 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1100 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006523.02231 | 2120459.93681 | 37.8027469916359 | -122.421622667864 | (37.8027469916359, -122.421622667864) | |||
| 77453 | 77453 | 63489 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 319 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50934 | 6006645.5795297995 | 2096080.30995427 | 37.7358132351331 | -122.419467931102 | (37.7358132351331, -122.419467931102) | ||
| 54629 | 54629 | 82125 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 317 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50070 | 6006739.55759841 | 2104266.9934198 | 37.758297308509995 | -122.41972370977 | (37.75829730851, -122.41972370977) |
| 160242 | 160242 | 241335 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007049.61155 | 2099992.5386 | 37.7465780921238 | -122.418348334311 | (37.7465780921238, -122.418348334311) | |||
| 34793 | 34793 | 241297 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1534 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007142.6566 | 2107359.7842099997 | 37.7668120908263 | -122.41854892359899 | (37.7668120908263, -122.418548923599) | |||
| 37202 | 37202 | 241295 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1350 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007154.425919999 | 2107655.79566 | 37.7676255312226 | -122.418529207767 | (37.7676255312226, -122.418529207767) | |||
| 73801 | 73801 | 241296 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1350 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007156.61283 | 2107616.82741 | 37.767518656696794 | -122.41851887996 | (37.7675186566968, -122.41851887996) | |||
| 117680 | 117680 | 95622 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 201 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767388 | 6007162.9 | 2106147.3 | 37.763484032741204 | -122.418392924595 | (37.7634840327412, -122.418392924595) | |
| 126455 | 126455 | 95623 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 201 Capp St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767388 | 6007162.9 | 2106147.3 | 37.763484032741204 | -122.418392924595 | (37.7634840327412, -122.418392924595) | |
| 173220 | 173220 | 241336 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | |||
| 46602 | 46602 | 91707 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
| 81786 | 81786 | 91705 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
| 100657 | 100657 | 91706 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
| 111041 | 111041 | 91703 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
| 128680 | 128680 | 91704 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
| 142533 | 142533 | 91702 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
| 93249 | 93249 | 91701 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 101x South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007269.02291 | 2109328.047293 | 37.7722235898389 | -122.41825140648001 | (37.7722235898389, -122.41825140648) | |||
| 115561 | 115561 | 91578 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2013 01:03:00 PM | 4 | 3x3 | 6007300.496664 | 2108846.846012 | 37.7709040967706 | -122.41810841516799 | (37.7709040967706, -122.418108415168) |
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");