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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90534 | 90534 | 87858 | Koelreuteria paniculata :: Golden Rain Tree 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000340.49747 | 2104887.90927 | 37.7596396402708 | -122.441898968169 | (37.7596396402708, -122.441898968169) | |||||||
| 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) | ||||
| 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) | |||
| 107516 | 107516 | 52168 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1064 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | Permit Number 48361 | 6009419.47710262 | 2102976.82289251 | 37.754905392409604 | -122.41036423903601 | (37.7549053924096, -122.410364239036) | ||
| 124248 | 124248 | 115879 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1125X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015016.8 | 2096457.8 | 37.737317699837206 | -122.390551463966 | (37.7373176998372, -122.390551463966) | ||
| 67423 | 67423 | 49806 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1164SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46601 | 6014134.35886 | 2105751.7151200003 | 37.762787822535 | -122.394252998377 | (37.762787822535, -122.394252998377) | ||
| 90850 | 90850 | 95804 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767548 | 6012200.0 | 2102946.0 | 37.7549762368602 | -122.400746185712 | (37.7549762368602, -122.400746185712) | |
| 166468 | 166468 | 78586 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | 6012194.44084 | 2102964.2828 | 37.755026127363 | -122.400766695348 | (37.755026127363, -122.400766695348) | ||
| 28628 | 28628 | 95805 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1180 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767549 | 6012197.65812 | 2102892.33506 | 37.754828754052504 | -122.40075051472701 | (37.7548287540525, -122.400750514727) |
| 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) | |||
| 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) | |||
| 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) | |||
| 145134 | 145134 | 39190 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1435 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | Permit Number 40843 | 6007766.05804405 | 2101299.52134892 | 37.7502070771658 | -122.415963470624 | (37.7502070771658, -122.415963470624) | ||
| 107091 | 107091 | 82106 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1442 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767418 | 6003903.93114879 | 2099873.27169394 | 37.746073034264604 | -122.42921725762 | (37.7460730342646, -122.42921725762) | |
| 32951 | 32951 | 190852 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014650.447319999 | 2110654.39937 | 37.7762781838256 | -122.392811023636 | (37.7762781838256, -122.392811023636) | |||
| 37869 | 37869 | 190854 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014595.17181 | 2110600.5682900003 | 37.7761273054628 | -122.392998471116 | (37.7761273054628, -122.392998471116) | |||
| 43094 | 43094 | 190850 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014687.44789 | 2110689.54127 | 37.776376730637395 | -122.39268548637101 | (37.7763767306374, -122.392685486371) | |||
| 44763 | 44763 | 190844 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6014850.8812 | 2110843.4101 | 37.776808295508104 | -122.392130883449 | (37.7768082955081, -122.392130883449) | |||
| 48280 | 48280 | 190838 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015067.58857 | 2111050.6554 | 37.7773893744695 | -122.39139571284599 | (37.7773893744695, -122.391395712846) | |||
| 50709 | 50709 | 190843 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6014866.38244 | 2110860.17534 | 37.7768551897557 | -122.39207843228901 | (37.7768551897557, -122.392078432289) | |||
| 50770 | 50770 | 190848 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014724.19019 | 2110724.1932200002 | 37.7764739176778 | -122.39256080793001 | (37.7764739176778, -122.39256080793) | |||
| 62300 | 62300 | 190845 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014811.37622 | 2110807.32883 | 37.7767070309344 | -122.39226502002899 | (37.7767070309344, -122.392265020029) | |||
| 67747 | 67747 | 190846 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014778.17275 | 2110775.57556 | 37.776617999847204 | -122.39237766009899 | (37.7766179998472, -122.392377660099) | |||
| 129961 | 129961 | 190839 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015047.6106 | 2111033.73325 | 37.7773418012199 | -122.391463640434 | (37.7773418012199, -122.391463640434) | |||
| 132876 | 132876 | 190847 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014760.45028 | 2110759.5978 | 37.77657314436011 | -122.392437849936 | (37.7765731443601, -122.392437849936) | |||
| 156038 | 156038 | 190851 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6014668.67654 | 2110670.86203 | 37.7763243990775 | -122.39274911519101 | (37.7763243990775, -122.392749115191) | |||
| 161462 | 161462 | 190849 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014705.4339 | 2110706.25649 | 37.776423625788496 | -122.392624436776 | (37.7764236257885, -122.392624436776) | |||
| 162379 | 162379 | 190856 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6014544.19003 | 2110550.11571 | 37.77598594193179 | -122.393171301041 | (37.7759859419318, -122.393171301041) | |||
| 164974 | 164974 | 190853 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6014612.67081 | 2110617.7882 | 37.7761755594921 | -122.392939141955 | (37.7761755594921, -122.392939141955) | |||
| 170689 | 170689 | 190840 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014957.07587 | 2110944.72485 | 37.777092378742104 | -122.391770606946 | (37.7770923787421, -122.391770606946) | |||
| 173251 | 173251 | 190841 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014902.59214 | 2110893.10566 | 37.776947619367206 | -122.39195547427299 | (37.7769476193672, -122.391955474273) | |||
| 184238 | 184238 | 190855 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6014580.4909 | 2110587.4994799998 | 37.776090605936496 | -122.39304834211201 | (37.7760906059365, -122.393048342112) | |||
| 188200 | 188200 | 190842 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014886.13724 | 2110878.3396 | 37.776906161529205 | -122.39201136443998 | (37.7769061615292, -122.39201136444) | |||
| 97429 | 97429 | 45173 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1528 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44021 | 6010431.85887632 | 2100611.56059168 | 37.748467604177705 | -122.40669644419201 | (37.7484676041777, -122.406696444192) | ||
| 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) | |||
| 14820 | 14820 | 96729 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1531 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015669.53931 | 2096721.84355 | 37.738078899822995 | -122.388313045518 | (37.738078899823, -122.388313045518) | |||
| 143417 | 143417 | 96730 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1531 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015658.7 | 2096702.1 | 37.738024087431995 | -122.38834914513201 | (37.738024087432, -122.388349145132) | |||
| 51695 | 51695 | 49809 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1546ARKANSAS 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46602 | 6012971.722709999 | 2105685.57554 | 37.762541524281204 | -122.398269533421 | (37.7625415242812, -122.398269533421) | |
| 162675 | 162675 | 88046 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51057 | 6015682.046 | 2096712.9906400002 | 37.738055284531896 | -122.388269185596 | (37.7380552845319, -122.388269185596) | |
| 69135 | 69135 | 32234 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1598 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 2 | Permit Number 35550 | 6008744.76884 | 2099374.8804200003 | 37.744977417571796 | -122.41244298828 | (37.7449774175718, -122.41244298828) | ||
| 81996 | 81996 | 95589 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767379 | 6008735.1 | 2099385.7 | 37.7450065831384 | -122.412477186149 | (37.7450065831384, -122.412477186149) | |
| 183890 | 183890 | 83155 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1714 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52368 | 6014530.43704 | 2094836.5062099998 | 37.7328389648403 | -122.392119708481 | (37.7328389648403, -122.392119708481) | |
| 25676 | 25676 | 190858 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6014397.96473 | 2110413.8287400003 | 37.7756036041681 | -122.393667595499 | (37.7756036041681, -122.393667595499) | |||
| 28982 | 28982 | 190860 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014325.82728 | 2110344.39106 | 37.7754089351207 | -122.393912276726 | (37.7754089351207, -122.393912276726) | |||
| 29122 | 29122 | 190859 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014379.08951 | 2110393.29962 | 37.7755461869437 | -122.39373145277 | (37.7755461869437, -122.39373145277) | |||
| 33793 | 33793 | 190857 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014414.04572 | 2110429.2067 | 37.775646722164204 | -122.393613043529 | (37.7756467221642, -122.393613043529) | |||
| 49243 | 49243 | 190866 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014217.98901 | 2110241.26669 | 37.77511978508729 | -122.39427809576799 | (37.7751197850873, -122.394278095768) | |||
| 58070 | 58070 | 190867 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014182.028630001 | 2110206.1993400003 | 37.775021499078704 | -122.394400035746 | (37.7750214990787, -122.394400035746) | |||
| 67668 | 67668 | 190863 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014272.3812 | 2110293.28106 | 37.775265628138705 | -122.394093581849 | (37.7752656281387, -122.394093581849) | |||
| 76978 | 76978 | 190864 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014254.38486 | 2110274.9394900003 | 37.7752142660511 | -122.39415455141399 | (37.7752142660511, -122.394154551414) | |||
| 132030 | 132030 | 190861 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014308.34576 | 2110328.57935 | 37.77536454816779 | -122.393971642775 | (37.7753645481678, -122.393971642775) | |||
| 133485 | 133485 | 190865 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014236.68547 | 2110259.82497 | 37.7751717811919 | -122.39421471965099 | (37.7751717811919, -122.394214719651) | |||
| 166787 | 166787 | 190868 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014162.65537 | 2110188.5784299998 | 37.7749720390567 | -122.39446581847 | (37.7749720390567, -122.39446581847) | |||
| 169870 | 169870 | 190862 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014289.87185 | 2110309.5547 | 37.7753112840173 | -122.394034216714 | (37.7753112840173, -122.394034216714) | |||
| 26926 | 26926 | 190879 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013947.21695 | 2109982.7867400004 | 37.7743950025592 | -122.395196653408 | (37.7743950025592, -122.395196653408) | |||
| 30958 | 30958 | 190870 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6014109.92279 | 2110138.37794 | 37.7748312681904 | -122.394644716998 | (37.7748312681904, -122.394644716998) | |||
| 31442 | 31442 | 190876 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014000.4231 | 2110033.4394799997 | 37.7745370423846 | -122.395016150475 | (37.7745370423846, -122.395016150475) | |||
| 37435 | 37435 | 190880 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013928.84356 | 2109965.19356 | 37.7743456738347 | -122.395258978227 | (37.7743456738347, -122.395258978227) | |||
| 39775 | 39775 | 190883 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013873.47298 | 2109914.30542 | 37.774202866892296 | -122.39544695094101 | (37.7742028668923, -122.395446950941) | |||
| 44408 | 44408 | 190872 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014072.10328 | 2110103.11714 | 37.7747323472599 | -122.39477307362499 | (37.7747323472599, -122.394773073625) | |||
| 53359 | 53359 | 190869 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014125.99477 | 2110153.29442 | 37.774873119023205 | -122.394590165008 | (37.7748731190232, -122.394590165008) | |||
| 131734 | 131734 | 190878 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013965.63522 | 2109999.0413900004 | 37.7744406584436 | -122.395134079478 | (37.7744406584436, -122.395134079478) | |||
| 147486 | 147486 | 190873 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6014053.92137 | 2110087.08887 | 37.7746873263001 | -122.394834846256 | (37.7746873263001, -122.394834846256) | |||
| 149634 | 149634 | 190877 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6013984.28553 | 2110015.29135 | 37.7744863143202 | -122.39507070246701 | (37.7744863143202, -122.395070702467) | |||
| 152299 | 152299 | 190875 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014019.10116 | 2110051.07468 | 37.7745865032978 | -122.394952774356 | (37.7745865032978, -122.394952774356) | |||
| 181313 | 181313 | 190871 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014091.22615 | 2110119.81942 | 37.7747792711826 | -122.39470809312999 | (37.7747792711826, -122.39470809313) | |||
| 183392 | 183392 | 190874 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014038.01567 | 2110068.93569 | 37.774636597347495 | -122.394888596037 | (37.7746365973475, -122.394888596037) | |||
| 187257 | 187257 | 190881 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6013910.78759 | 2109947.4980099997 | 37.774296081645396 | -122.395320197769 | (37.7742960816454, -122.395320197769) | |||
| 187963 | 187963 | 190882 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6013891.89628 | 2109930.79083 | 37.774249156806 | -122.395384376097 | (37.774249156806, -122.395384376097) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 114721 | 114721 | 47290 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2100 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2002 12:00:00 AM | 3x3 | Permit Number 45232 | 6009541.72996085 | 2104990.45798185 | 37.7604412326322 | -122.41008360325701 | (37.7604412326322, -122.410083603257) | |
| 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) | |||
| 16167 | 16167 | 107773 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772845 | 6014155.30561 | 2110125.53241 | 37.7747985202595 | -122.394486827531 | (37.7747985202595, -122.394486827531) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 133682 | 133682 | 51482 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 47794 | 6014137.24495 | 2110108.95335 | 37.77475199384529 | -122.39454814238199 | (37.7747519938453, -122.394548142382) | |||
| 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) | |||
| 176278 | 176278 | 51483 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 47794 | 6014118.18221 | 2110089.57063 | 37.774697713467 | -122.39461272721 | (37.774697713467, -122.39461272721) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 167270 | 167270 | 190884 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6013920.56849 | 2109899.42755 | 37.774164634934394 | -122.395282995516 | (37.7741646349344, -122.395282995516) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 99753 | 99753 | 92865 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 260 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 4x4 | Permit Number 774771 | 6004247.0 | 2098697.0 | 37.7428626784389 | -122.42794716566601 | (37.7428626784389, -122.427947165666) |
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");