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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 64986 | 64986 | 241353 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6009702.25291 | 2105928.94008 | 37.76302708714471 | -122.40959466535801 | (37.7630270871447, -122.409594665358) | |||
| 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) | |
| 65557 | 65557 | 241352 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6009685.74216 | 2105928.63246 | 37.7630253172965 | -122.409651748936 | (37.7630253172965, -122.409651748936) | |||
| 65765 | 65765 | 241386 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2169 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008144.96622 | 2105963.39406 | 37.763034304202 | -122.414983243884 | (37.763034304202, -122.414983243884) | |||
| 66138 | 66138 | 241291 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1225 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011156.6405 | 2102469.67171 | 37.75361009534021 | -122.404320914102 | (37.7536100953402, -122.404320914102) | |||
| 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) | ||
| 68372 | 68372 | 196977 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 209 Mississippi St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014040.95878 | 2106120.30389 | 37.763794694494706 | -122.39460185080799 | (37.7637946944947, -122.394601850808) | |||
| 69881 | 69881 | 91641 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216001 | 2101489.31094 | 37.750727267460604 | -122.416034053567 | (37.7507272674606, -122.416034053567) | |||
| 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) | |||
| 71707 | 71707 | 241385 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2169 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6008146.20784 | 2105935.07496 | 37.7629566162671 | -122.41497694503 | (37.7629566162671, -122.41497694503) | |||
| 71771 | 71771 | 241341 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2701 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009762.27519 | 2105459.58065 | 37.7617416960496 | -122.409353942929 | (37.7617416960496, -122.409353942929) | |||
| 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) | |
| 72151 | 72151 | 91659 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1015 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007624.666917 | 2103742.941155 | 37.7569082017019 | -122.4166254819 | (37.7569082017019, -122.4166254819) | |||
| 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) | |||
| 72636 | 72636 | 197004 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 503 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6015943.643630001 | 2113959.00175 | 37.7854236244348 | -122.388568185881 | (37.7854236244348, -122.388568185881) | |||
| 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) | |||
| 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) | |||
| 74291 | 74291 | 241309 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007486.87936 | 2106417.71309 | 37.7642447566068 | -122.41729154457799 | (37.7642447566068, -122.417291544578) | |||
| 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) | ||
| 75922 | 75922 | 136186 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 800 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010043.141009999 | 2116645.97985 | 37.7924726608324 | -122.40917192556999 | (37.7924726608324, -122.40917192557) | |||
| 75960 | 75960 | 36966 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.520930001 | 2112981.13075 | 37.781516271518505 | -122.463326949801 | (37.7815162715185, -122.463326949801) | |
| 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) | |
| 76557 | 76557 | 123210 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | |||
| 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) | ||
| 77431 | 77431 | 91612 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1108 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007615.164408 | 2103191.40433 | 37.755393273338 | -122.41661927573799 | (37.755393273338, -122.416619275738) | |||
| 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) | ||
| 78043 | 78043 | 88136 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690.0 | 2096237.0 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) | |||
| 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) | ||
| 78890 | 78890 | 91625 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1434 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007720.12849 | 2101296.976541 | 37.7501975073399 | -122.41612211811501 | (37.7501975073399, -122.416122118115) | |||
| 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) | |||
| 79028 | 79028 | 91619 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1286 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007670.444381 | 2102173.036115 | 37.7526001749043 | -122.416355973027 | (37.7526001749043, -122.416355973027) | |||
| 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) | ||
| 80121 | 80121 | 91624 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) | |||
| 80241 | 80241 | 91582 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 270x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007359.0 | 2108191.0 | 37.76910659118089 | -122.417859552844 | (37.7691065911809, -122.417859552844) | ||
| 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) | ||
| 81296 | 81296 | 91645 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1300X South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007675.941296 | 2102071.044433 | 37.7523204379956 | -122.41632974036501 | (37.7523204379956, -122.416329740365) | |||
| 81470 | 81470 | 83567 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | ||
| 81498 | 81498 | 88509 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 81712 | 81712 | 88507 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 82418 | 82418 | 91638 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1453 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007765.644065 | 2101198.5368439998 | 37.7499297732176 | -122.415957751819 | (37.7499297732176, -122.415957751819) | |||
| 82435 | 82435 | 88162 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 365 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51185 | 6011732.3 | 2112447.5 | 37.7810391100489 | -122.40303190844999 | (37.7810391100489, -122.40303190845) | |||
| 82540 | 82540 | 91660 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | ||
| 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) | ||
| 82630 | 82630 | 8913 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4455X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5993194.92162 | 2112721.50101 | 37.780738833580706 | -122.46718130985201 | (37.7807388335807, -122.467181309852) | |||
| 82747 | 82747 | 84204 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 82969 | 82969 | 22263 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4655X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1997 12:00:00 AM | 6 | 3X3 | 6015123.968669999 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | ||
| 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) | ||
| 83911 | 83911 | 91617 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1200X South Van Ness Ave | 2 | 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) | ||
| 84040 | 84040 | 91682 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 425 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007432.064539 | 2107206.199481 | 37.766406671896 | -122.41753702057301 | (37.766406671896, -122.417537020573) | |||
| 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) | ||
| 84319 | 84319 | 91601 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 746 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007497.69689 | 2105311.9357669996 | 37.7612091575166 | -122.417175768763 | (37.7612091575166, -122.417175768763) | |||
| 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) | ||
| 84590 | 84590 | 101631 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 5 | 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) | ||
| 84625 | 84625 | 91618 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1240 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007656.818859 | 2102429.616316 | 37.753303919629396 | -122.41642126514 | (37.7533039196294, -122.41642126514) | |||
| 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) | |
| 85554 | 85554 | 91631 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1500 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007741.508083 | 2100911.11035 | 37.7491392078361 | -122.41602086316601 | (37.7491392078361, -122.416020863166) | |||
| 85635 | 85635 | 91684 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 387 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007418.830408 | 2107437.729103 | 37.7670416532981 | -122.41759920657 | (37.7670416532981, -122.41759920657) | ||
| 85750 | 85750 | 88508 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 85801 | 85801 | 3776 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 6 Carpenter Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.259790401 | 2095536.4485417 | 37.7348782815847 | -122.38484307413 | (37.7348782815847, -122.38484307413) | ||
| 86093 | 86093 | 84203 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 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) | ||
| 86876 | 86876 | 88243 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2745 Turk Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51229 | 5997744.2 | 2111601.2 | 37.7779243335514 | -122.451362410862 | (37.7779243335514, -122.451362410862) | |||
| 87078 | 87078 | 90864 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | ||
| 87505 | 87505 | 91656 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1141 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007665.027497 | 2103014.499609 | 37.7549103375799 | -122.416434303552 | (37.7549103375799, -122.416434303552) | |||
| 87922 | 87922 | 91679 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007478.430249 | 2106383.2495009997 | 37.7641496522652 | -122.41731832527799 | (37.7641496522652, -122.417318325278) | ||
| 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) | ||
| 88201 | 88201 | 22267 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4655X 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 6 | 3X3 | 6015123.968669999 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | ||
| 88209 | 88209 | 95296 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4517 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015219.416180001 | 2096207.7645900003 | 37.736642391950795 | -122.389833460403 | (37.7366423919508, -122.389833460403) | |||
| 88528 | 88528 | 89323 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 18 Hale St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2008 12:00:00 AM | 3x3 | Permit Number 51913 | 6010478.7 | 2094954.8 | 37.7329379790561 | -122.406135993698 | (37.7329379790561, -122.406135993698) | |||
| 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) | ||
| 89164 | 89164 | 88499 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1599@ Lane Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 89955 | 89955 | 91579 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 170 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2013 01:09:00 PM | 3 | 3x3 | 6007322.882921 | 2108766.7829919998 | 37.770685522642104 | -122.41802530365601 | (37.7706855226421, -122.418025303656) | |||
| 90023 | 90023 | 91687 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 373 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007414.352337999 | 2107516.0725080003 | 37.767256513925204 | -122.417620248867 | (37.7672565139252, -122.417620248867) | |||
| 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) | ||
| 90256 | 90256 | 91630 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1490x South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007737.478632 | 2100983.83524 | 37.7493386674544 | -122.41603994665 | (37.7493386674544, -122.41603994665) |
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");