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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37617 | 37617 | 241293 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1300 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011113.70254 | 2102244.2434799997 | 37.7529887195714 | -122.404453537112 | (37.7529887195714, -122.404453537112) | |||
| 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) | ||
| 38113 | 38113 | 196990 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014143.12746 | 2100151.41021 | 37.7474110756645 | -122.39383064437901 | (37.7474110756645, -122.393830644379) | |||
| 38294 | 38294 | 241369 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2877 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 7ft | 6009515.68514 | 2102750.48038 | 37.7542892993236 | -122.410015545387 | (37.7542892993236, -122.410015545387) | |||
| 39737 | 39737 | 241337 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2711 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009686.38177 | 2105455.07073 | 37.761725060389 | -122.409616110618 | (37.761725060389, -122.409616110618) | |||
| 40217 | 40217 | 196963 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015947.26389 | 2105849.11258 | 37.7631558583726 | -122.38798953960101 | (37.7631558583726, -122.387989539601) | |||
| 40314 | 40314 | 241327 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 377 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007424.50403 | 2107516.88319 | 37.7672593111026 | -122.41758519300501 | (37.7672593111026, -122.417585193005) | |||
| 40491 | 40491 | 241321 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 356 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007355.9869099995 | 2107612.7207 | 37.7675186027402 | -122.417828978541 | (37.7675186027402, -122.417828978541) | |||
| 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) | |
| 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) | |||
| 42090 | 42090 | 241379 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3702 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008438.87775 | 2097614.97452 | 37.7401279331501 | -122.41337627141701 | (37.7401279331501, -122.413376271417) | |||
| 42244 | 42244 | 241274 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2616 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010311.63301 | 2104008.02665 | 37.75778681942779 | -122.40735159161501 | (37.7577868194278, -122.407351591615) | |||
| 42273 | 42273 | 31514 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2537 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 13 | Permit Number 35072 | 6010934.2499 | 2102257.13766 | 37.7530140939364 | -122.405075029795 | (37.7530140939364, -122.405075029795) | |
| 42415 | 42415 | 122016 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.774725954752796 | -122.47639488146099 | (37.7747259547528, -122.476394881461) | |||
| 44456 | 44456 | 241338 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2709 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009715.56008 | 2105456.2423 | 37.7617299122363 | -122.409515276828 | (37.7617299122363, -122.409515276828) | |||
| 45678 | 45678 | 70389 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.47967027105899 | (37.7747342353889, -122.479670271059) | ||
| 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) | |||
| 47101 | 47101 | 67973 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 3 | Permit Number 31694 | 5988948.22001 | 2110531.76438 | 37.7744803739464 | -122.48171209676799 | (37.7744803739464, -122.481712096768) | |
| 47790 | 47790 | 32353 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2180 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36907 | 6009556.94604 | 2104659.06953 | 37.759532167893 | -122.410007582777 | (37.759532167893, -122.410007582777) | |
| 47818 | 47818 | 47653 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 245 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 5 | Permit Number 45457 | 6013208.50894 | 2105918.56319 | 37.7631944437823 | -122.39746691096701 | (37.7631944437823, -122.397466910967) | |
| 47952 | 47952 | 241313 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 720 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007476.612269999 | 2105442.18225 | 37.7615655979969 | -122.417257921613 | (37.7615655979969, -122.417257921613) | |||
| 47985 | 47985 | 83223 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1446-48 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50888 | 5993687.91761966 | 2105648.90031529 | 37.7613477954461 | -122.464962006978 | (37.7613477954461, -122.464962006978) | |
| 48206 | 48206 | 241329 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 349 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007417.325069999 | 2107664.8176700003 | 37.767665100494206 | -122.417620510295 | (37.7676651004942, -122.417620510295) | |||
| 48775 | 48775 | 37999 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 725 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40211 | 6012746.31439 | 2104130.05474 | 37.758257848348705 | -122.39893996271401 | (37.7582578483487, -122.398939962714) | |
| 49905 | 49905 | 43686 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 162 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 4 | Permit Number 43330 | 5993378.798359999 | 2114426.59889 | 37.785431180637005 | -122.46666917491999 | (37.785431180637, -122.46666917492) | |
| 51144 | 51144 | 241330 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 335 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007413.91501 | 2107730.15032 | 37.7678442967163 | -122.417636936423 | (37.7678442967163, -122.417636936423) | |||
| 52341 | 52341 | 241334 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007405.72375 | 2108268.9659 | 37.7693232965496 | -122.417703464652 | (37.7693232965496, -122.417703464652) | |||
| 52365 | 52365 | 34963 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 13 | Permit Number 38553 | 6014444.86373 | 2102867.97159 | 37.754886940207705 | -122.392977289379 | (37.7548869402077, -122.392977289379) | ||
| 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) | |||
| 54246 | 54246 | 241340 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2701 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009746.5481 | 2105459.14432 | 37.7617396168174 | -122.409408306065 | (37.7617396168174, -122.409408306065) | |||
| 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) |
| 56244 | 56244 | 65529 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1990 12:00:00 AM | 3 | Permit Number 28417 | 5989796.43775 | 2110560.03757 | 37.7746072923506 | -122.47878004958 | (37.7746072923506, -122.47878004958) | ||
| 58557 | 58557 | 241361 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 608 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009795.10344 | 2105420.22693 | 37.761635478912396 | -122.409237625525 | (37.7616354789124, -122.409237625525) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 59999 | 59999 | 241359 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 707 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 8ft | 6008539.21153 | 2104376.13627 | 37.7586982040894 | -122.41350741506099 | (37.7586982040894, -122.413507415061) | |||
| 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) | |||
| 60529 | 60529 | 94081 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1355 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53468 | 6007606.52221 | 2117796.21393 | 37.7954941122185 | -122.41768428480101 | (37.7954941122185, -122.417684284801) | |
| 61098 | 61098 | 241339 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2707 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009729.7818599995 | 2105457.4669 | 37.761734071584 | -122.409466175622 | (37.761734071584, -122.409466175622) | |||
| 62629 | 62629 | 123211 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993134.492000001 | 2112639.5046599996 | 37.780510205416704 | -122.46738439918501 | (37.7805102054167, -122.467384399185) | |||
| 63494 | 63494 | 241360 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 600 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009793.68997 | 2105435.76266 | 37.7616780573116 | -122.40924361051201 | (37.7616780573116, -122.409243610512) | |||
| 64650 | 64650 | 213853 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 339 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996569.29854 | 2106950.5997200003 | 37.7650876471008 | -122.455090641935 | (37.7650876471008, -122.455090641935) | |||
| 65036 | 65036 | 39270 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 800 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1998 12:00:00 AM | 3 | Permit Number 40882 | 6010056.25648 | 2116573.77784 | 37.7922751463304 | -122.40912144840901 | (37.7922751463304, -122.409121448409) | |
| 66253 | 66253 | 241332 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 263 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007398.28361 | 2108137.64954 | 37.768962314089606 | -122.41771989078501 | (37.7689623140896, -122.417719890785) | |||
| 66365 | 66365 | 241356 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3041 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009354.55363 | 2100986.01535 | 37.749435439707 | -122.410448197535 | (37.749435439707, -122.410448197535) | |||
| 68102 | 68102 | 32320 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3337 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1996 12:00:00 AM | 4 | Permit Number 36887 | 6009057.019230001 | 2099240.26466 | 37.744625310511104 | -122.411353770753 | (37.7446253105111, -122.411353770753) | ||
| 70189 | 70189 | 44257 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 122 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2001 12:00:00 AM | 9 | Permit Number 43690 | 5993988.26127 | 2114691.75826 | 37.7861943888941 | -122.464579892109 | (37.7861943888941, -122.464579892109) | ||
| 70502 | 70502 | 241331 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 315 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007407.0994 | 2107837.8785599996 | 37.768139709617294 | -122.417668147376 | (37.7681397096173, -122.417668147376) | |||
| 71908 | 71908 | 241381 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2169 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6008153.508640001 | 2105811.23118 | 37.7626169800981 | -122.414942928177 | (37.7626169800981, -122.414942928177) | |||
| 72018 | 72018 | 41933 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 610 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 6 | Permit Number 42292 | 5994729.714980001 | 2111330.05881 | 37.7770067806052 | -122.461770835952 | (37.7770067806052, -122.461770835952) | |
| 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) | |||
| 73978 | 73978 | 196978 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6013296.03231 | 2104723.49575 | 37.7599179239891 | -122.397080394946 | (37.7599179239891, -122.397080394946) | |||
| 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) | |||
| 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) | |||
| 74974 | 74974 | 179281 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 18 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010435.48171 | 2094947.68687 | 37.7329160304499 | -122.406284910247 | (37.7329160304499, -122.406284910247) | |||
| 75229 | 75229 | 196974 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 223 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6014047.89224 | 2106015.09524 | 37.763506200065706 | -122.394570502234 | (37.7635062000657, -122.394570502234) | |||
| 75789 | 75789 | 90892 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1543 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990781.4854 | 2110598.61863 | 37.774770372701504 | -122.475375427468 | (37.7747703727015, -122.475375427468) | ||
| 75975 | 75975 | 82510 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 162 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52478 | 6009746.4088 | 2094920.9823200002 | 37.7328041358849 | -122.40866534015301 | (37.7328041358849, -122.408665340153) | |
| 76873 | 76873 | 241280 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1334 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010312.03054 | 2101467.09279 | 37.7508100021879 | -122.40717110848 | (37.7508100021879, -122.40717110848) | |||
| 76956 | 76956 | 241298 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 793 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007561.5863 | 2105063.9781299997 | 37.760531917228 | -122.416937233294 | (37.760531917228, -122.416937233294) | |||
| 77383 | 77383 | 87991 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 222 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51029 | 6008096.0 | 2113166.0 | 37.7828082078679 | -122.41566260373001 | (37.7828082078679, -122.41566260373) | ||
| 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) | ||
| 77832 | 77832 | 91607 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 882 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007541.210677 | 2104526.1862959997 | 37.759054118783 | -122.416969598799 | (37.759054118783, -122.416969598799) | ||
| 78334 | 78334 | 90576 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2020 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989294.17784 | 2110601.6564700003 | 37.7746923899334 | -122.48052049321001 | (37.7746923899334, -122.48052049321) | ||
| 78575 | 78575 | 88011 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 144 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51041 | 6008609.0 | 2112967.0 | 37.7822906254359 | -122.413873752004 | (37.7822906254359, -122.413873752004) | ||
| 79054 | 79054 | 100424 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 79723 | 79723 | 91616 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1200X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007645.0 | 2102652.0 | 37.7539138699857 | -122.416477888477 | (37.7539138699857, -122.416477888477) | ||
| 80397 | 80397 | 90572 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989583.92326 | 2110610.46088 | 37.774733398944704 | -122.479518860914 | (37.7747333989447, -122.479518860914) | ||
| 80461 | 80461 | 91672 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.41706129314801 | (37.7614631059869, -122.417061293148) | ||
| 82124 | 82124 | 37985 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 570 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 11 | Permit Number 40207 | 6013793.631580001 | 2104435.25023 | 37.75915415226579 | -122.395339235527 | (37.7591541522658, -122.395339235527) | |
| 82384 | 82384 | 91599 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007449.0 | 2105508.0 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | ||
| 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) | ||
| 83294 | 83294 | 37711 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 720 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 6 | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.761607056161296 | -122.417234652367 | (37.7616070561613, -122.417234652367) | |
| 83303 | 83303 | 90571 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989655.61233 | 2110613.51621 | 37.7747459519392 | -122.47927110015301 | (37.7747459519392, -122.479271100153) | ||
| 84186 | 84186 | 91694 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007404.295323 | 2108246.270012 | 37.7692608986091 | -122.41770679662399 | (37.7692608986091, -122.417706796624) | ||
| 84441 | 84441 | 90554 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1150 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992007.5751 | 2110699.64473 | 37.7751187568292 | -122.47114153279199 | (37.7751187568292, -122.471141532792) | ||
| 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) | |
| 86181 | 86181 | 88027 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 121 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51050 | 6008492.3 | 2112899.8 | 37.782099555755295 | -122.41427272738599 | (37.7820995557553, -122.414272727386) | ||
| 86262 | 86262 | 90896 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992053.33041 | 2110644.47867 | 37.7749699321879 | -122.47097923688 | (37.7749699321879, -122.47097923688) | ||
| 88030 | 88030 | 52826 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3063 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52281 | 6009164.51309648 | 2101559.46503951 | 37.750999349300606 | -122.411145866905 | (37.7509993493006, -122.411145866905) | ||
| 88775 | 88775 | 82759 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 49 Samoset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.40833270178899 | (37.744466098795, -122.408332701789) | ||
| 88819 | 88819 | 29771 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 501X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008832.60809 | 2121061.07086 | 37.804527516201894 | -122.413672842682 | (37.8045275162019, -122.413672842682) | |||
| 89007 | 89007 | 81225 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 225 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49728 | 5994438.42452426 | 2091412.78636228 | 37.7223022264954 | -122.46133430098699 | (37.7223022264954, -122.461334300987) | ||
| 89493 | 89493 | 22261 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4655X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015123.968669999 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | |||
| 89938 | 89938 | 88017 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 601 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51044 | 6008420.0 | 2114150.0 | 37.7855282422492 | -122.41461135167101 | (37.7855282422492, -122.414611351671) | ||
| 90125 | 90125 | 87988 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 233 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741.0 | 2113986.0 | 37.785152065252 | -122.41002947845502 | (37.785152065252, -122.410029478455) | ||
| 90507 | 90507 | 90570 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1830 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989885.34607 | 2110621.45957 | 37.7747811022825 | -122.478476993955 | (37.7747811022825, -122.478476993955) | ||
| 90981 | 90981 | 79256 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 627 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50884 | 5996581.50943321 | 2107294.3742688 | 37.7660322643278 | -122.455073251071 | (37.7660322643278, -122.455073251071) | ||
| 91907 | 91907 | 90879 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1917 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989637.04672 | 2110556.0238099997 | 37.7745870153825 | -122.479331114808 | (37.7745870153825, -122.479331114808) | ||
| 91978 | 91978 | 91604 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 802 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007516.377022 | 2104974.620116 | 37.7602840176254 | -122.417087260164 | (37.7602840176254, -122.417087260164) | ||
| 92412 | 92412 | 91663 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 859 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007573.699386 | 2104662.928197 | 37.75943140801971 | -122.41686692513399 | (37.7594314080197, -122.416866925134) | ||
| 92753 | 92753 | 85063 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4532 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6015094.5224 | 2096297.78902 | 37.736882653829795 | -122.390271563398 | (37.7368826538298, -122.390271563398) | ||
| 93019 | 93019 | 88014 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 77 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | ||
| 93945 | 93945 | 22277 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4755X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | ||
| 94254 | 94254 | 101627 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
| 94538 | 94538 | 90894 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1527 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990818.866169999 | 2110597.98209 | 37.7747707916372 | -122.475246074555 | (37.7747707916372, -122.475246074555) | ||
| 95196 | 95196 | 83512 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49725 | 5994714.51593994 | 2090381.39140811 | 37.719486148882 | -122.460305233079 | (37.719486148882, -122.460305233079) | ||
| 95330 | 95330 | 90569 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1818 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989920.282380001 | 2110623.46415 | 37.7747886345028 | -122.47835629000099 | (37.7747886345028, -122.478356290001) | ||
| 95423 | 95423 | 90884 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1751 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990130.69935 | 2110573.9065900003 | 37.774664776015705 | -122.477624799049 | (37.7746647760157, -122.477624799049) |
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");