Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 174 | 174 | 251226 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1 Yukon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13x2.5 | 6000262.0 | 2104839.0 | 37.7595008741196 | -122.442166940047 | (37.7595008741196, -122.442166940047) | ||||
| 130297 | 130297 | 227049 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 53 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002595.33861 | 2096033.4537 | 37.735455616991295 | -122.433467841774 | (37.7354556169913, -122.433467841774) | |||
| 161090 | 161090 | 227048 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 53 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002587.0055599995 | 2096042.99913 | 37.7354813537673 | -122.43349733416099 | (37.7354813537673, -122.433497334161) | |||
| 165727 | 165727 | 227047 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 772 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001525.22764 | 2100011.34301 | 37.7463171978735 | -122.437452374431 | (37.7463171978735, -122.437452374431) | |||
| 1882 | 1882 | 227046 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 715 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009320.74588 | 2104897.8286599996 | 37.760174505071895 | -122.410841346058 | (37.7601745050719, -122.410841346058) | |||
| 73291 | 73291 | 227045 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 691 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009312.22316 | 2105039.82895 | 37.7605639276988 | -122.410880851495 | (37.7605639276988, -122.410880851495) | |||
| 27953 | 27953 | 227044 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 319 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006891.79407 | 2096315.8696700002 | 37.7364738950591 | -122.41863336815399 | (37.7364738950591, -122.418633368154) | |||
| 155090 | 155090 | 227043 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 203 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007125.1333800005 | 2096948.3880099999 | 37.7382237850914 | -122.417871436422 | (37.7382237850914, -122.417871436422) | |||
| 24825 | 24825 | 227042 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 350 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004196.38414 | 2100161.8744900003 | 37.7468820224824 | -122.428226557815 | (37.7468820224824, -122.428226557815) | |||
| 75580 | 75580 | 227041 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 346 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004242.14432 | 2100165.3787599998 | 37.746894233484795 | -122.428068573005 | (37.7468942334848, -122.428068573005) | |||
| 135394 | 135394 | 227040 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 342 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004258.30391 | 2100166.07195 | 37.746897051075 | -122.428012744009 | (37.746897051075, -122.428012744009) | |||
| 72877 | 72877 | 227039 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 260 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004244.3831400005 | 2098703.3043299997 | 37.742879840636895 | -122.427956663177 | (37.7428798406369, -122.427956663177) | |||
| 177426 | 177426 | 227038 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 238 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004360.47421 | 2098709.18899 | 37.7429025656093 | -122.42755567166401 | (37.7429025656093, -122.427555671664) | |||
| 151925 | 151925 | 227037 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1528 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010462.237269999 | 2100563.14483 | 37.7483363647345 | -122.40658798445101 | (37.7483363647345, -122.406587984451) | |||
| 157356 | 157356 | 227036 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 121 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010214.63547 | 2100191.80382 | 37.7473028881185 | -122.40741801374901 | (37.7473028881185, -122.407418013749) | |||
| 188150 | 188150 | 227035 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2801 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009497.84698 | 2104977.4520099997 | 37.7604030614745 | -122.41023445656799 | (37.7604030614745, -122.410234456568) | |||
| 182570 | 182570 | 227034 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2801 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009481.322269999 | 2104976.8585200002 | 37.760400505599 | -122.41029156621201 | (37.760400505599, -122.410291566212) | |||
| 125557 | 125557 | 227033 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2813 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6009433.9529 | 2104976.2744400003 | 37.760396246421706 | -122.41045535432801 | (37.7603962464217, -122.410455354328) | |||
| 26548 | 26548 | 227032 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2851 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009394.98612 | 2104975.20837 | 37.76039113467 | -122.410590047609 | (37.76039113467, -122.410590047609) | |||
| 160907 | 160907 | 227031 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2828 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009344.12011 | 2105016.02091 | 37.7605003447324 | -122.41076885260901 | (37.7605003447324, -122.410768852609) | |||
| 27165 | 27165 | 227030 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2100 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009540.30462 | 2104948.34044 | 37.7603255075284 | -122.410085559401 | (37.7603255075284, -122.410085559401) | |||
| 166698 | 166698 | 227029 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2100 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009538.419980001 | 2104961.20858 | 37.760360734888295 | -122.41009298600201 | (37.7603607348883, -122.410092986002) | |||
| 25074 | 25074 | 227028 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2443 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6011191.55955 | 2102271.08783 | 37.753066778927604 | -122.404186180354 | (37.7530667789276, -122.404186180354) | |||
| 169523 | 169523 | 227027 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1301 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011166.45785 | 2102232.02401 | 37.752958115644105 | -122.404270238186 | (37.7529581156441, -122.404270238186) | |||
| 148540 | 148540 | 227026 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 3514 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006304.15977 | 2100862.8361 | 37.748925739940006 | -122.420987813049 | (37.74892573994, -122.420987813049) | |||
| 28458 | 28458 | 227025 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 104 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 7ft | 6006179.604780001 | 2099480.15543 | 37.7451221913449 | -122.421320349952 | (37.7451221913449, -122.421320349952) | |||
| 52080 | 52080 | 206962 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 443 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5999138.42937 | 2094937.58008 | 37.7322498702318 | -122.445340863193 | (37.7322498702318, -122.445340863193) | |||
| 136333 | 136333 | 191213 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1255 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015066.17853 | 2109333.99267 | 37.7726757227485 | -122.391280560972 | (37.7726757227485, -122.391280560972) | |||
| 168757 | 168757 | 191212 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6013783.16711 | 2109770.0092599997 | 37.7738016388768 | -122.39574922474199 | (37.7738016388768, -122.395749224742) | |||
| 59214 | 59214 | 191211 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013764.85039 | 2109752.7104700003 | 37.7737531213363 | -122.39581137329701 | (37.7737531213363, -122.395811373297) | |||
| 57815 | 57815 | 191210 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013746.53391 | 2109735.41169 | 37.7737046038035 | -122.39587352094101 | (37.7737046038035, -122.395873520941) | |||
| 56670 | 56670 | 191209 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013727.79169 | 2109719.00523 | 37.7736585126619 | -122.395937203756 | (37.7736585126619, -122.395937203756) | |||
| 26800 | 26800 | 191208 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013709.665519999 | 2109700.15636 | 37.7736057494514 | -122.39599858427601 | (37.7736057494514, -122.395998584276) | |||
| 151120 | 151120 | 191207 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013692.93226 | 2109684.3718 | 37.773561477613 | -122.396055361178 | (37.773561477613, -122.396055361178) | |||
| 70938 | 70938 | 191206 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013638.43003 | 2109632.68734 | 37.7734165311832 | -122.396240270786 | (37.7734165311832, -122.396240270786) | |||
| 187758 | 187758 | 191205 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013584.80112 | 2109580.32237 | 37.7732697645312 | -122.396422111011 | (37.7732697645312, -122.396422111011) | |||
| 51814 | 51814 | 191204 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013569.4383 | 2109566.49789 | 37.773230950690106 | -122.396474284254 | (37.7732309506901, -122.396474284254) | |||
| 179861 | 179861 | 191203 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013547.7109 | 2109545.07141 | 37.7731709092433 | -122.39654794053499 | (37.7731709092433, -122.396547940535) | |||
| 28608 | 28608 | 191202 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013529.91648 | 2109527.13301 | 37.773120664119205 | -122.39660823648 | (37.7731206641192, -122.39660823648) | |||
| 186016 | 186016 | 191201 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013477.11276 | 2109476.26405 | 37.772978050528295 | -122.39678732570101 | (37.7729780505283, -122.396787325701) | |||
| 169929 | 169929 | 191200 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013165.39711 | 2109177.11194 | 37.772139291512794 | -122.397844607347 | (37.7721392915128, -122.397844607347) | |||
| 148219 | 148219 | 191199 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013156.13437 | 2109157.86258 | 37.7720859212576 | -122.39787529763201 | (37.7720859212576, -122.397875297632) | |||
| 173223 | 173223 | 191198 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013134.16647 | 2109135.5576299997 | 37.7720234534485 | -122.39794972192499 | (37.7720234534485, -122.397949721925) | |||
| 29946 | 29946 | 191197 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013113.835630001 | 2109117.41613 | 37.771972508664206 | -122.398018775466 | (37.7719725086642, -122.398018775466) | |||
| 40480 | 40480 | 191196 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013094.16111 | 2109098.81981 | 37.771920351561 | -122.39808552672599 | (37.771920351561, -122.398085526726) | |||
| 29519 | 29519 | 191195 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013075.662380001 | 2109083.51263 | 37.7718772911475 | -122.39814844152001 | (37.7718772911475, -122.39814844152) | |||
| 183159 | 183159 | 191194 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013058.71986 | 2109068.39463 | 37.771834836828 | -122.398205986443 | (37.771834836828, -122.398205986443) | |||
| 55879 | 55879 | 191193 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013038.65565 | 2109052.45663 | 37.7717899570585 | -122.398274271964 | (37.7717899570585, -122.398274271964) | |||
| 129638 | 129638 | 191192 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6013013.2029099995 | 2109033.31501 | 37.7717359806621 | -122.398360971982 | (37.7717359806621, -122.398360971982) | |||
| 154201 | 154201 | 191191 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012989.140869999 | 2109006.19311 | 37.7716601696237 | -122.39844230127 | (37.7716601696237, -122.39844230127) | |||
| 153439 | 153439 | 191190 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6012960.16944 | 2108977.62489 | 37.771580113755604 | -122.398540510858 | (37.7715801137556, -122.398540510858) | |||
| 71692 | 71692 | 191189 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6012941.17318 | 2108959.67719 | 37.77152977510529 | -122.398604960769 | (37.7715297751053, -122.398604960769) | |||
| 28830 | 28830 | 191188 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012921.49842 | 2108941.08068 | 37.771477617131 | -122.398671712036 | (37.771477617131, -122.398671712036) | |||
| 75631 | 75631 | 191187 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6012902.28491 | 2108923.3585 | 37.7714278855308 | -122.39873692908199 | (37.7714278855308, -122.398736929082) | |||
| 53437 | 53437 | 191186 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012843.925419999 | 2108867.55559 | 37.7712714115714 | -122.39893488155899 | (37.7712714115714, -122.398934881559) | |||
| 30841 | 30841 | 191185 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6012824.91108 | 2108848.72466 | 37.771218646544796 | -122.398999331472 | (37.7712186465448, -122.398999331472) | |||
| 182000 | 182000 | 191184 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6012805.8880199995 | 2108829.45241 | 37.7711646692314 | -122.399063780475 | (37.7711646692314, -122.399063780475) | |||
| 59282 | 59282 | 191183 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6012786.887069999 | 2108811.28416 | 37.77111372444939 | -122.39912823041 | (37.7711137244494, -122.39912823041) | |||
| 158885 | 158885 | 191182 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6012727.40051 | 2108754.62037 | 37.770954823226205 | -122.399330019374 | (37.7709548232262, -122.399330019374) | |||
| 175266 | 175266 | 191181 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 455 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6012706.66644 | 2108736.31507 | 37.7709034053917 | -122.399400454266 | (37.7709034053917, -122.399400454266) | |||
| 129871 | 129871 | 191180 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013011.10848 | 2109086.96064 | 37.7718831628012 | -122.39837198149598 | (37.7718831628012, -122.398371981496) | |||
| 74586 | 74586 | 191179 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013027.66646 | 2109104.07615 | 37.771931080493204 | -122.39831590696801 | (37.7719310804932, -122.398315906968) | |||
| 29581 | 29581 | 191178 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013045.03802 | 2109118.1209400003 | 37.7719706119713 | -122.398256802631 | (37.7719706119713, -122.398256802631) | |||
| 176646 | 176646 | 191177 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013063.400640001 | 2109137.8178 | 37.7720257179325 | -122.39819466666701 | (37.7720257179325, -122.398194666667) | |||
| 47376 | 47376 | 191176 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013081.89405 | 2109153.9281900004 | 37.7720709835069 | -122.398131826536 | (37.7720709835069, -122.398131826536) | |||
| 69457 | 69457 | 191175 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013105.34974 | 2109176.1616599998 | 37.772133338027004 | -122.39805225091001 | (37.772133338027, -122.39805225091) | |||
| 73784 | 73784 | 191174 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013121.88332 | 2109194.88719 | 37.772185674958 | -122.39799637335399 | (37.772185674958, -122.397996373354) | |||
| 50488 | 50488 | 191173 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013140.435319999 | 2109211.39045 | 37.772232022420894 | -122.39793335786301 | (37.7722320224209, -122.397933357863) | |||
| 118386 | 118386 | 191172 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013502.580709999 | 2109556.6030200003 | 37.7732000607555 | -122.396704861437 | (37.7732000607555, -122.396704861437) | |||
| 181844 | 181844 | 191171 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013538.71499 | 2109592.42944 | 37.773300443093 | -122.39658237917101 | (37.773300443093, -122.396582379171) | |||
| 61508 | 61508 | 191170 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013556.38901 | 2109609.33005 | 37.773347831964 | -122.396522426786 | (37.773347831964, -122.396522426786) | |||
| 177049 | 177049 | 191169 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013574.9944 | 2109626.21147 | 37.773395219943 | -122.39645925121599 | (37.773395219943, -122.396459251216) | |||
| 60606 | 60606 | 191168 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013593.42848 | 2109643.8388799997 | 37.7734446466755 | -122.396396720454 | (37.7734446466755, -122.396396720454) | |||
| 42319 | 42319 | 191167 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013629.16381 | 2109678.37452 | 37.7735414622978 | -122.39627552692 | (37.7735414622978, -122.39627552692) | |||
| 54369 | 54369 | 191166 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013646.66643 | 2109696.02085 | 37.773590889053004 | -122.396216219322 | (37.773590889053, -122.396216219322) | |||
| 162539 | 162539 | 191165 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013664.53417 | 2109713.2886900003 | 37.773639296845005 | -122.396155622099 | (37.773639296845, -122.396155622099) | |||
| 177344 | 177344 | 191164 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013682.57668 | 2109729.99621 | 37.7736861758168 | -122.396094380961 | (37.7736861758168, -122.396094380961) | |||
| 33316 | 33316 | 191163 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013701.02941 | 2109748.55088 | 37.7737381494382 | -122.39603185019101 | (37.7737381494382, -122.396031850191) | |||
| 185795 | 185795 | 191162 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6013718.31553 | 2109764.71694 | 37.773783499535604 | -122.395973187435 | (37.7737834995356, -122.395973187435) | |||
| 127241 | 127241 | 191161 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013755.54468 | 2109799.4078599997 | 37.773880824184296 | -122.39584683627301 | (37.7738808241843, -122.395846836273) | |||
| 158928 | 158928 | 191160 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 300 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013772.476869999 | 2109816.50902 | 37.773928722073705 | -122.395789463138 | (37.7739287220737, -122.395789463138) | |||
| 33739 | 33739 | 191159 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014441.85996 | 2110400.0230099997 | 37.7755681357843 | -122.39351478358 | (37.7755681357843, -122.39351478358) | |||
| 24507 | 24507 | 191158 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014425.7087199995 | 2110384.34677 | 37.775524194919704 | -122.393569557682 | (37.7755241949197, -122.393569557682) | |||
| 72227 | 72227 | 191157 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014408.33325 | 2110366.57718 | 37.7754744381338 | -122.39362842011002 | (37.7754744381338, -122.39362842011) | |||
| 159031 | 159031 | 191156 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014354.13785 | 2110316.1346299998 | 37.7753329226168 | -122.393812364761 | (37.7753329226168, -122.393812364761) | |||
| 159719 | 159719 | 191155 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014334.63154 | 2110298.17271 | 37.7752825191943 | -122.39387858453001 | (37.7752825191943, -122.39387858453) | |||
| 65554 | 65554 | 191154 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014318.22941 | 2110281.7957900004 | 37.7752366403051 | -122.393934177039 | (37.7752366403051, -122.393934177039) | |||
| 118392 | 118392 | 191153 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014300.13588 | 2110263.57014 | 37.7751855911885 | -122.393995491012 | (37.7751855911885, -122.393995491012) | |||
| 60991 | 60991 | 191152 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014282.05159 | 2110245.81497 | 37.7751358343856 | -122.39405680588101 | (37.7751358343856, -122.394056805881) | |||
| 174965 | 174965 | 190895 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014262.57866 | 2110228.29984 | 37.7750866594644 | -122.394122941124 | (37.7750866594644, -122.394122941124) | |||
| 75959 | 75959 | 190894 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014191.20495 | 2110159.4009 | 37.7748935111682 | -122.394365015227 | (37.7748935111682, -122.394365015227) | |||
| 24637 | 24637 | 190893 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014173.13956 | 2110142.58674 | 37.7748463390233 | -122.39442633013 | (37.7748463390233, -122.39442633013) | |||
| 182233 | 182233 | 190892 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6014082.2782 | 2110055.46717 | 37.7746020768646 | -122.39473453857201 | (37.7746020768646, -122.394734538572) | |||
| 165714 | 165714 | 190891 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014064.930869999 | 2110039.10887 | 37.774556196138896 | -122.39479340100401 | (37.7745561961389, -122.394793401004) | |||
| 171100 | 171100 | 190890 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014028.53972 | 2110004.30919 | 37.7744586205966 | -122.394916848253 | (37.7744586205966, -122.394916848253) | |||
| 148369 | 148369 | 190889 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014009.99216 | 2109987.0339200003 | 37.77441015524511 | -122.39497979807301 | (37.7744101552451, -122.394979798073) | |||
| 65636 | 65636 | 190888 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013991.92655 | 2109970.2198799998 | 37.774362983093795 | -122.395041112957 | (37.7743629830938, -122.395041112957) | |||
| 150285 | 150285 | 190887 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013974.07808 | 2109952.45981 | 37.774313225399396 | -122.395101610353 | (37.7743132253994, -122.395101610353) | |||
| 38306 | 38306 | 190886 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6013955.0722900005 | 2109935.90001 | 37.774266698985 | -122.395166195169 | (37.774266698985, -122.395166195169) | |||
| 186155 | 186155 | 190885 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013937.025669999 | 2109920.0269400002 | 37.774222111483795 | -122.395227510053 | (37.7742221114838, -122.395227510053) |
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");