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) | ||||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 40737 | 40737 | 88768 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51687 | 6013512.4253 | 2109511.33019 | 37.7730762996632 | -122.39666763312701 | (37.7730762996632, -122.396667633127) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) |
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");