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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 146179 | 146179 | 92223 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 715 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52658 | 6009316.0 | 2104920.0 | 37.7602351164227 | -122.410859325784 | (37.7602351164227, -122.410859325784) | ||
| 62893 | 62893 | 190833 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 703 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011016.09695 | 2105008.53851 | 37.760573404768294 | -122.404985694736 | (37.7605734047683, -122.404985694736) | |||
| 166088 | 166088 | 190834 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 703 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011015.81631 | 2105024.6924 | 37.760617744045206 | -122.40498780276 | (37.7606177440452, -122.40498780276) | |||
| 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) | |||
| 4800 | 4800 | 161279 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 594 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:18:00 PM | 3 | Width 0ft | 6002806.05279 | 2090211.99508 | 37.7194831555901 | -122.43232368828998 | (37.7194831555901, -122.43232368829) | |
| 175327 | 175327 | 32981 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 558 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 7 | Permit Number 37294 | 6013791.869419999 | 2104484.1784 | 37.759288400371204 | -122.39534875755699 | (37.7592884003712, -122.395348757557) | |
| 65354 | 65354 | 190835 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6011143.20834 | 2097895.22742 | 37.7410489144739 | -122.404045463449 | (37.7410489144739, -122.404045463449) | |||
| 149364 | 149364 | 190837 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6011137.802619999 | 2097880.16304 | 37.7410072488818 | -122.404063094656 | (37.7410072488818, -122.404063094656) | |||
| 168558 | 168558 | 190836 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6011141.49126 | 2097886.93529 | 37.7410260501239 | -122.404050817101 | (37.7410260501239, -122.404050817101) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 13389 | 13389 | 51110 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 13713 | 13713 | 51108 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 13716 | 13716 | 51121 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 13728 | 13728 | 51141 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14126 | 14126 | 51109 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14238 | 14238 | 51140 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14577 | 14577 | 51113 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14578 | 14578 | 51138 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14592 | 14592 | 51137 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14704 | 14704 | 51135 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14767 | 14767 | 51143 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14792 | 14792 | 51119 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14983 | 14983 | 51112 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 15160 | 15160 | 51107 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 15612 | 15612 | 51105 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 15627 | 15627 | 51133 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 15630 | 15630 | 51136 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 15821 | 15821 | 51134 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16019 | 16019 | 51104 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16051 | 16051 | 51139 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16237 | 16237 | 51111 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16258 | 16258 | 51114 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16598 | 16598 | 51103 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16609 | 16609 | 51142 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16649 | 16649 | 51116 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16691 | 16691 | 51118 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16726 | 16726 | 51106 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16795 | 16795 | 51115 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 29071 | 29071 | 51117 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 7 | Permit Number 47557 | 6012851.53345 | 2108941.1546099996 | 37.7714739218185 | -122.398913731299 | (37.7714739218185, -122.398913731299) | ||
| 29546 | 29546 | 51129 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 11 | Permit Number 47557 | 6012752.45555 | 2108845.8204 | 37.771206634319604 | -122.399249755781 | (37.7712066343196, -122.399249755781) | ||
| 41881 | 41881 | 51123 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 10 | Permit Number 47557 | 6012907.31344 | 2108994.69031 | 37.7716240267703 | -122.39872454180401 | (37.7716240267703, -122.398724541804) | ||
| 45373 | 45373 | 51122 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 9 | Permit Number 47557 | 6012812.37793 | 2108902.32047 | 37.7713651101465 | -122.399046446937 | (37.7713651101465, -122.399046446937) | ||
| 48888 | 48888 | 51131 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 1 | Permit Number 47557 | 6012714.573530001 | 2108809.39867 | 37.771104517176596 | -122.39937823472499 | (37.7711045171766, -122.399378234725) | ||
| 60290 | 60290 | 51124 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012694.61425 | 2108791.31053 | 37.7710537387716 | -122.399446004933 | (37.7710537387716, -122.399446004933) | ||
| 73527 | 73527 | 51132 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 9 | Permit Number 47557 | 6012926.67664 | 2109013.60395 | 37.7716770381823 | -122.39865889041401 | (37.7716770381823, -122.398658890414) | ||
| 123439 | 123439 | 51120 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012887.75032 | 2108975.98412 | 37.771571573793004 | -122.398790899202 | (37.771571573793, -122.398790899202) | ||
| 163998 | 163998 | 51126 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012833.17756 | 2108921.6110400003 | 37.771419236747704 | -122.39897585375 | (37.7714192367477, -122.39897585375) | ||
| 168732 | 168732 | 51127 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 10 | Permit Number 47557 | 6012791.79876 | 2108883.8380400003 | 37.77131321475821 | -122.39911633417 | (37.7713132147582, -122.39911633417) | ||
| 186041 | 186041 | 51128 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012773.055380001 | 2108865.31837 | 37.7712613193831 | -122.399179868575 | (37.7712613193831, -122.399179868575) | ||
| 186208 | 186208 | 51125 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012869.40685 | 2108957.05013 | 37.7715185632492 | -122.398853021653 | (37.7715185632492, -122.398853021653) | ||
| 187058 | 187058 | 51130 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012734.14513 | 2108828.51136 | 37.7711580871187 | -122.399311877367 | (37.7711580871187, -122.399311877367) | ||
| 183780 | 183780 | 119659 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401X Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012884.61917 | 2108905.3838400003 | 37.7713775468798 | -122.398796774473 | (37.7713775468798, -122.398796774473) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 139275 | 139275 | 62892 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 399X 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2012 12:00:00 AM | Permit Number 768779 | 5994971.59272291 | 2112865.01973596 | 37.7812352946386 | -122.461045394767 | (37.7812352946386, -122.461045394767) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 26196 | 26196 | 85226 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013258.86916 | 2109269.0895 | 37.772397046220604 | -122.39752772943599 | (37.7723970462206, -122.397527729436) | ||
| 31504 | 31504 | 85233 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 12 | Permit Number 49539 | 6013385.079919999 | 2109389.55863 | 37.7727348540654 | -122.397099599979 | (37.7727348540654, -122.397099599979) | ||
| 42670 | 42670 | 85223 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 1 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013205.26566 | 2109218.0492700003 | 37.7722539164092 | -122.397709569661 | (37.7722539164092, -122.397709569661) | ||
| 43589 | 43589 | 85228 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013295.28168 | 2109303.69122 | 37.7724940821684 | -122.397404201236 | (37.7724940821684, -122.397404201236) | ||
| 68398 | 68398 | 85225 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013241.67832 | 2109252.65125 | 37.772350953271605 | -122.39758604146999 | (37.7723509532716, -122.39758604147) | ||
| 71158 | 71158 | 85234 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 7 | Permit Number 49539 | 6013403.64119 | 2109407.9569599996 | 37.772786404996296 | -122.397036684295 | (37.7727864049963, -122.397036684295) | ||
| 76681 | 76681 | 85235 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 5 | Permit Number 49539 | 6013421.95811 | 2109425.2555 | 37.7728349225156 | -122.39697453664 | (37.7728349225156, -122.39697453664) | ||
| 160105 | 160105 | 85230 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013331.92947 | 2109338.95114 | 37.772592938352396 | -122.397279905049 | (37.7725929383524, -122.397279905049) | ||
| 160449 | 160449 | 85227 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 10 | Permit Number 49539 | 6013279.22191 | 2109288.33477 | 37.7724510226373 | -122.39745867679702 | (37.7724510226373, -122.397458676797) | ||
| 172546 | 172546 | 85229 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013312.02436 | 2109319.91751 | 37.7725395680802 | -122.39734742435199 | (37.7725395680802, -122.397347424352) | ||
| 180028 | 180028 | 85232 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 13 | Permit Number 49539 | 6013368.7851599995 | 2109373.5443 | 37.7726899752046 | -122.397154842615 | (37.7726899752046, -122.397154842615) | ||
| 180030 | 180030 | 85224 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 13 | Permit Number 49539 | 6013220.65574 | 2109233.19851 | 37.77229636981421 | -122.39765739638901 | (37.7722963698142, -122.397657396389) | ||
| 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) | |||
| 187426 | 187426 | 85231 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49539 | 6013350.68536 | 2109356.01998 | 37.772640849735396 | -122.39721622315001 | (37.7726408497354, -122.39721622315) | ||
| 112386 | 112386 | 61427 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 3514 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767543 | 6006340.52913524 | 2100870.00155072 | 37.7489474646868 | -122.42086255612301 | (37.7489474646868, -122.420862556123) |
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");