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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 3877 | 3877 | 38690 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1529 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2013 12:00:00 AM | 8 | 6x5 | Permit Number 40603 | 6000458.9819 | 2110614.4446 | 37.7753700290705 | -122.441900209231 | (37.7753700290705, -122.441900209231) |
| 7007 | 7007 | 66829 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 142 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 30126 | 5996834.5871 | 2112040.6558 | 37.7790788371058 | -122.45454081935101 | (37.7790788371058, -122.454540819351) | |
| 7441 | 7441 | 66970 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 109 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2016 12:00:00 AM | 3 | Permit Number 30310 | 5996758.1037 | 2112315.4543 | 37.77982897457179 | -122.454825264921 | (37.7798289745718, -122.454825264921) | |
| 9745 | 9745 | 47282 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2810 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45227 | 6010345.86300325 | 2101091.40389861 | 37.7497803366023 | -122.407027634693 | (37.7497803366023, -122.407027634693) | |
| 11740 | 11740 | 108556 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) |
| 13897 | 13897 | 83463 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 6 | 3x3 | 6010416.80991 | 2111846.95811 | 37.77931661531171 | -122.407540511299 | (37.7793166153117, -122.407540511299) | |
| 14900 | 14900 | 42231 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42486 | 6010159.8373 | 2112236.08642 | 37.780370682809 | -122.408456946549 | (37.780370682809, -122.408456946549) | |
| 15079 | 15079 | 42230 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 1 | 5x3 | Permit Number 42486 | 6010185.283980001 | 2112260.71785 | 37.7804397399325 | -122.408370652088 | (37.7804397399325, -122.408370652088) |
| 18421 | 18421 | 32094 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4056 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 16 | 4x4 | Permit Number 35466 | 6002634.735280001 | 2104754.49716 | 37.759403787880004 | -122.43395481658399 | (37.75940378788, -122.433954816584) |
| 20619 | 20619 | 42911 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2900 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42822 | 6008853.88469765 | 2103932.85927525 | 37.7574987299949 | -122.412387795343 | (37.7574987299949, -122.412387795343) | ||
| 21064 | 21064 | 32070 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3684 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 12 | 3x3 | Permit Number 35444 | 6004359.136530001 | 2106017.2411 | 37.7629686905871 | -122.428080978261 | (37.7629686905871, -122.428080978261) |
| 21235 | 21235 | 63156 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.46937656879999 | (37.7605085633711, -122.4693765688) | ||
| 23134 | 23134 | 64386 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 3x3 | Permit Number 25228 | 6014088.71321 | 2113049.44965 | 37.782823232041395 | -122.39492201395299 | (37.7828232320414, -122.394922013953) |
| 23634 | 23634 | 38826 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 35 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | 7 | Permit Number 40661 | 5993919.30733 | 2115313.05171 | 37.7878963157335 | -122.46486358906 | (37.7878963157335, -122.46486358906) | |
| 25636 | 25636 | 67280 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 705 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1992 12:00:00 AM | 7 | Permit Number 30756 | 6005348.882780001 | 2092459.4150200002 | 37.7257979378164 | -122.42369375707399 | (37.7257979378164, -122.423693757074) | |
| 26674 | 26674 | 30678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1035 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34601 | 6007763.45978 | 2109624.69043 | 37.77306592059371 | -122.41656211886499 | (37.7730659205937, -122.416562118865) | |
| 28545 | 28545 | 38090 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2613 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 4 | Permit Number 40262 | 5999952.6506 | 2114003.5175 | 37.784646688105205 | -122.443895271597 | (37.7846466881052, -122.443895271597) | |
| 29323 | 29323 | 73436 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 376 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014381.64402 | 2112223.83347 | 37.7805725617252 | -122.39385077838499 | (37.7805725617252, -122.393850778385) | ||
| 30328 | 30328 | 66823 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1945 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | 12 | Permit Number 30119 | 5998494.0785 | 2110339.7621 | 37.7745036601214 | -122.448677450991 | (37.7745036601214, -122.448677450991) | |
| 33931 | 33931 | 38487 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 663 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1998 12:00:00 AM | 11 | Permit Number 40484 | 6008553.25241 | 2118118.58868 | 37.7964325026095 | -122.414431248111 | (37.7964325026095, -122.414431248111) | |
| 35410 | 35410 | 31403 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4244 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 34994 | 6002175.10963 | 2104146.03155 | 37.757706993800504 | -122.43550089685 | (37.7577069938005, -122.43550089685) | |
| 36577 | 36577 | 47078 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 150 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 6 | Permit Number 45065 | 5996844.0629 | 2111961.8035 | 37.778862872875706 | -122.454502341108 | (37.7788628728757, -122.454502341108) | |
| 36688 | 36688 | 72131 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 975 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2014 12:00:00 AM | 1 | Permit Number 772897 | 6012808.0555 | 2103001.2980400003 | 37.75516196906929 | -122.398647223515 | (37.7551619690693, -122.398647223515) | |
| 37261 | 37261 | 74866 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 7 | 6015612.0948 | 2112518.9573 | 37.7814512083448 | -122.389614645118 | (37.7814512083448, -122.389614645118) | ||
| 39426 | 39426 | 33289 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1250 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 8 | Permit Number 37450 | 6008792.2608 | 2116678.011 | 37.79249045392179 | -122.413502289805 | (37.7924904539218, -122.413502289805) | |
| 39545 | 39545 | 52519 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 52 Navajo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 3 | Permit Number 48620 | 5999464.555919999 | 2090507.1181599998 | 37.7201034593997 | -122.443895170628 | (37.7201034593997, -122.443895170628) | |
| 39709 | 39709 | 38041 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1517 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40243 | 6000105.0251 | 2114271.6766 | 37.7853916739939 | -122.443387376648 | (37.7853916739939, -122.443387376648) |
| 39762 | 39762 | 76392 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 13 | 6015910.963140001 | 2112668.39256 | 37.7818780913398 | -122.3885911303 | (37.7818780913398, -122.3885911303) | ||
| 40209 | 40209 | 80574 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2002 12:00:00 AM | 3 | 5988121.26409 | 2111709.35839 | 37.777665594619 | -122.484659059603 | (37.777665594619, -122.484659059603) | ||
| 40937 | 40937 | 31342 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 240 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34954 | 6006186.23354 | 2111270.37249 | 37.7774957381658 | -122.422134888438 | (37.7774957381658, -122.422134888438) | |
| 42349 | 42349 | 47925 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1793 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | 7 | Permit Number 45661 | 6000638.2577 | 2111331.2873 | 37.777348511449105 | -122.441331500835 | (37.7773485114491, -122.441331500835) | |
| 43080 | 43080 | 79052 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1166 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 4 | 3x3 | 6009403.22119 | 2110965.12543 | 37.776838523512396 | -122.410984649444 | (37.7768385235124, -122.410984649444) | |
| 43261 | 43261 | 73404 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1817 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 11 | 6005442.665019999 | 2092673.3852400002 | 37.726390746633896 | -122.423384762607 | (37.7263907466339, -122.423384762607) | ||
| 44718 | 44718 | 31343 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 240 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34954 | 6006171.37375 | 2111269.23628 | 37.777491780263794 | -122.422186212726 | (37.7774917802638, -122.422186212726) | |
| 46829 | 46829 | 32672 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 52 Gilbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37096 | 6011553.1933699995 | 2109908.84309 | 37.7740585418955 | -122.403472874078 | (37.7740585418955, -122.403472874078) | |
| 46951 | 46951 | 65985 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 659 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1990 12:00:00 AM | 8 | Permit Number 29014 | 6010750.4184 | 2116208.9676 | 37.7913123281025 | -122.40669390128599 | (37.7913123281025, -122.406693901286) | |
| 47909 | 47909 | 31837 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1162 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35293 | 6009869.4904 | 2110535.9885 | 37.77568634927629 | -122.409341384883 | (37.7756863492763, -122.409341384883) | |
| 47987 | 47987 | 68761 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 50 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/1997 12:00:00 AM | Permit Number 32684 | 6003960.97119147 | 2105124.66245865 | 37.7604953479062 | -122.42939444048099 | (37.7604953479062, -122.429394440481) | ||
| 49223 | 49223 | 67218 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 67 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | Permit Number 30674 | 6004275.36148655 | 2108843.45765699 | 37.770724059917605 | -122.428572194222 | (37.7707240599176, -122.428572194222) | ||
| 49909 | 49909 | 31895 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 11 | Permit Number 47709 | 6008447.6164 | 2108708.53583 | 37.770588827951 | -122.41413069917299 | (37.770588827951, -122.414130699173) | |
| 50535 | 50535 | 42232 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 514 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 2 | Permit Number 42486 | 6010147.47945 | 2112226.4024900002 | 37.7803434009533 | -122.408499015011 | (37.7803434009533, -122.408499015011) | |
| 51220 | 51220 | 38673 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 655 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 9 | Permit Number 40591 | 5999617.1558 | 2110820.1364 | 37.7758868007627 | -122.444827060795 | (37.7758868007627, -122.444827060795) | |
| 51390 | 51390 | 30772 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 650 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34651 | 6015119.06429 | 2112403.324 | 37.7811063552192 | -122.39131222069099 | (37.7811063552192, -122.391312220691) | |
| 53012 | 53012 | 72269 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 550 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6003171.66265 | 2090288.8451 | 37.719714892907 | -122.431065391947 | (37.719714892907, -122.431065391947) | ||
| 53599 | 53599 | 39870 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3626 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41421 | 6006079.92775485 | 2101440.50496023 | 37.750499244033705 | -122.421804236007 | (37.7504992440337, -122.421804236007) | ||
| 54501 | 54501 | 71438 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 671 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | 6003019.09073 | 2089456.91868 | 37.717421959831 | -122.43153341803401 | (37.717421959831, -122.431533418034) | ||
| 54814 | 54814 | 95915 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1900 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767613 | 5988090.4089 | 2102404.3375 | 37.7521147639454 | -122.484083263842 | (37.7521147639454, -122.484083263842) |
| 57819 | 57819 | 38091 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2621 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 9 | Permit Number 40263 | 5999871.7643 | 2113997.1422 | 37.7846245690042 | -122.444174651925 | (37.7846245690042, -122.444174651925) | |
| 58575 | 58575 | 38164 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 215 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 7 | Permit Number 41402 | 6010124.1026800005 | 2094106.4490599998 | 37.7305887468511 | -122.40730215048299 | (37.7305887468511, -122.407302150483) | |
| 58704 | 58704 | 34495 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 185 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38218 | 6008672.47995951 | 2097726.39703626 | 37.7404469880804 | -122.4125764416 | (37.7404469880804, -122.4125764416) | ||
| 60185 | 60185 | 31836 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1160 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35292 | 6009898.9199 | 2110564.6005 | 37.7757665599557 | -122.409241600011 | (37.7757665599557, -122.409241600011) | |
| 63230 | 63230 | 71319 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 582 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 10 | 6003518.598180001 | 2089824.0063200002 | 37.7184582009508 | -122.42983302128201 | (37.7184582009508, -122.429833021282) | ||
| 63377 | 63377 | 71449 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 372 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 15 | 6011710.51408 | 2119095.9218900003 | 37.7992928818086 | -122.403575181848 | (37.7992928818086, -122.403575181848) | ||
| 64221 | 64221 | 42846 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2507 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 1 | Permit Number 45197 | 6006200.908969999 | 2119434.24266 | 37.7999125282101 | -122.42266441374399 | (37.7999125282101, -122.422664413744) | |
| 64823 | 64823 | 30771 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 650 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 7 | Permit Number 34651 | 6015110.62905 | 2112413.71767 | 37.781134425744796 | -122.391342129437 | (37.7811344257448, -122.391342129437) | |
| 65340 | 65340 | 33830 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 192 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 6 | Permit Number 40594 | 5998304.033 | 2110110.1695 | 37.7738623889732 | -122.44931830699899 | (37.7738623889732, -122.449318306999) | |
| 65734 | 65734 | 69232 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 371 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 5 | Permit Number 33286 | 6006088.9496 | 2111042.98864 | 37.7768659096682 | -122.42245526559401 | (37.7768659096682, -122.422455265594) | |
| 66311 | 66311 | 66854 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2067 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 10 | Permit Number 30160 | 5997980.4447 | 2109915.2958 | 37.7733088013141 | -122.450423595424 | (37.7733088013141, -122.450423595424) | |
| 66719 | 66719 | 38539 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4517 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40515 | 6015174.5182 | 2096198.2167 | 37.736613685451005 | -122.38998802661699 | (37.736613685451, -122.389988026617) | |
| 66785 | 66785 | 33973 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1519 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 10 | Permit Number 41179 | 6000100.0693 | 2114297.9425 | 37.7854635107362 | -122.44340640951 | (37.7854635107362, -122.44340640951) | |
| 68024 | 68024 | 69158 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1287 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33194 | 5983034.7903 | 2106354.2675 | 37.7626645218276 | -122.501858295829 | (37.7626645218276, -122.501858295829) | |
| 68792 | 68792 | 37771 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1063 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 11 | Permit Number 40109 | 6009536.46227 | 2091239.3466299998 | 37.7226833814051 | -122.40913148662202 | (37.7226833814051, -122.409131486622) | |
| 69147 | 69147 | 36158 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 124 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2011 12:00:00 AM | 5 | Permit Number 768284 | 5996572.4794 | 2113546.8019999997 | 37.7831992799989 | -122.455556442282 | (37.7831992799989, -122.455556442282) | |
| 70563 | 70563 | 78353 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 168 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54052 | 6000350.309830001 | 2091388.3119599998 | 37.722573502235704 | -122.440896607905 | (37.7225735022357, -122.440896607905) |
| 73478 | 73478 | 72254 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 435 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 10 | 6003385.22958 | 2091049.6878799999 | 37.7218160986223 | -122.43038142338101 | (37.7218160986223, -122.430381423381) | ||
| 75075 | 75075 | 35109 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 590 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 13 | Permit Number 38647 | 6001764.58962 | 2090083.07088 | 37.7190700502319 | -122.435914418632 | (37.7190700502319, -122.435914418632) | |
| 75354 | 75354 | 81954 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1361-1363 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2004 12:00:00 AM | 2 | 6003958.5762 | 2112837.8735 | 37.7816738092081 | -122.42995293526 | (37.7816738092081, -122.42995293526) | ||
| 75815 | 75815 | 38825 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 35 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | 9 | Permit Number 40661 | 5993918.856980001 | 2115328.48921 | 37.78793867692 | -122.464866268722 | (37.78793867692, -122.464866268722) | |
| 75982 | 75982 | 38486 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 46 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1998 12:00:00 AM | 12 | Permit Number 40483 | 6008598.7758599995 | 2118126.03004 | 37.79645549199179 | -122.414274253461 | (37.7964554919918, -122.414274253461) | |
| 76814 | 76814 | 67177 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 39 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30623 | 6006917.58798394 | 2097076.37412002 | 37.7385635241286 | -122.418598100484 | (37.7385635241286, -122.418598100484) | ||
| 77102 | 77102 | 74718 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 4 | 6015601.81755 | 2112509.3684400003 | 37.781424309627106 | -122.38964952982501 | (37.7814243096271, -122.389649529825) | ||
| 77421 | 77421 | 39744 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 568 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41111 | 6004231.58576423 | 2105585.83448235 | 37.761776933767706 | -122.428491380996 | (37.7617769337677, -122.428491380996) | ||
| 77647 | 77647 | 47952 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 284 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45682 | 5997872.43575123 | 2096301.72488979 | 37.7359231369177 | -122.44981594322701 | (37.7359231369177, -122.449815943227) | ||
| 77839 | 77839 | 50269 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 287 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46974 | 6006321.20125143 | 2096107.66060659 | 37.7358700580341 | -122.42059137705601 | (37.7358700580341, -122.420591377056) | ||
| 78454 | 78454 | 46709 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1741 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44839 | 5997384.395715901 | 2108098.43118726 | 37.7682860273406 | -122.452354269766 | (37.7682860273406, -122.452354269766) | ||
| 78496 | 78496 | 67777 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31410 | 6002409.66817054 | 2108299.95353081 | 37.7691259721047 | -122.43498677415 | (37.7691259721047, -122.43498677415) | ||
| 79710 | 79710 | 84511 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 670 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002290.0 | 2089910.0 | 37.7186246694004 | -122.434085914673 | (37.7186246694004, -122.434085914673) | ||
| 79779 | 79779 | 47776 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1444 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2002 12:00:00 AM | Permit Number 45552 | 5990868.7531859 | 2105564.91366324 | 37.7609542357008 | -122.474706084902 | (37.7609542357008, -122.474706084902) | ||
| 79838 | 79838 | 43713 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43354 | 5994720.21130865 | 2090709.86528617 | 37.7203883873178 | -122.460309333031 | (37.7203883873178, -122.460309333031) | ||
| 79929 | 79929 | 38131 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 110 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | Permit Number 40293 | 6010183.36335526 | 2094089.0979682 | 37.7305444209455 | -122.40709605392999 | (37.7305444209455, -122.40709605393) | ||
| 80165 | 80165 | 41724 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 69 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2004 12:00:00 AM | Permit Number 42171 | 6006258.9056789 | 2108480.50590198 | 37.7698395335412 | -122.421685286607 | (37.7698395335412, -122.421685286607) | ||
| 80314 | 80314 | 32530 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 40 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37032 | 6006995.40841562 | 2095619.71276472 | 37.7345682345039 | -122.418225786917 | (37.7345682345039, -122.418225786917) | ||
| 80322 | 80322 | 65255 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1040 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28054 | 6009412.00767636 | 2103111.21545962 | 37.755273985498 | -122.410399559399 | (37.755273985498, -122.410399559399) | ||
| 80529 | 80529 | 66914 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 90 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1991 12:00:00 AM | Permit Number 30234 | 6007937.13560289 | 2098197.14787292 | 37.741698268956206 | -122.41515229567499 | (37.7416982689562, -122.415152295675) | ||
| 80898 | 80898 | 37679 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 190 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40073 | 6007090.19177002 | 2106208.83641672 | 37.7636489041282 | -122.418648763754 | (37.7636489041282, -122.418648763754) | ||
| 81229 | 81229 | 43714 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 322 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43355 | 5994772.66402913 | 2090734.25116914 | 37.72045836224321 | -122.460129788058 | (37.7204583622432, -122.460129788058) | ||
| 81267 | 81267 | 40725 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 224 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41704 | 6008980.81051683 | 2097343.97945273 | 37.7394142523581 | -122.411483340406 | (37.7394142523581, -122.411483340406) | ||
| 81704 | 81704 | 67900 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 27 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31602 | 5997414.12131199 | 2093627.0661451 | 37.728552929424296 | -122.451207680238 | (37.7285529294243, -122.451207680238) | ||
| 81896 | 81896 | 33834 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1676 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41872 | 5998550.82095945 | 2109008.11152707 | 37.7708505329816 | -122.448385252011 | (37.7708505329816, -122.448385252011) | ||
| 82294 | 82294 | 46321 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1081 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2003 12:00:00 AM | Permit Number 44575 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | ||
| 82588 | 82588 | 37570 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4000 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40003 | 6002110.61777636 | 2103565.66487621 | 37.7561097835615 | -122.435682414853 | (37.7561097835615, -122.435682414853) | ||
| 82838 | 82838 | 47981 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45715 | 5992041.84966987 | 2097872.86364306 | 37.7399017634935 | -122.470088779952 | (37.7399017634935, -122.470088779952) | ||
| 83005 | 83005 | 67333 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1235 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1992 12:00:00 AM | Permit Number 30817 | 5995136.26209098 | 2107131.84884658 | 37.7655029929244 | -122.46006026088301 | (37.7655029929244, -122.460060260883) | ||
| 83363 | 83363 | 37058 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1578 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39662 | 6003306.67223844 | 2099046.33084545 | 37.7437686174034 | -122.43122348397301 | (37.7437686174034, -122.431223483973) | ||
| 83379 | 83379 | 47276 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 691 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2003 12:00:00 AM | Permit Number 45237 | 6009310.77249327 | 2105041.72338407 | 37.7605690480409 | -122.410886002511 | (37.7605690480409, -122.410886002511) | ||
| 83504 | 83504 | 33073 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1400 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37333 | 6010634.39060918 | 2119281.77515247 | 37.7997430205195 | -122.407312069993 | (37.7997430205195, -122.407312069993) | ||
| 83667 | 83667 | 33135 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3103 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | ||
| 83875 | 83875 | 54283 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1265 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | Permit Number 30566 | 5992973.96848047 | 2106869.50046493 | 37.7646580506375 | -122.46752000191799 | (37.7646580506375, -122.467520001918) | ||
| 83880 | 83880 | 67114 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1537 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30532 | 5998296.84481976 | 2105270.56777275 | 37.7605736597375 | -122.448994477093 | (37.7605736597375, -122.448994477093) |
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");