Street_Tree_List

Data source: data.sfgov.org

238 rows where qSpecies = 56

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 63.229ms · Data source: data.sfgov.org