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) | ||||
| 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) | |||
| 81996 | 81996 | 95589 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767379 | 6008735.1 | 2099385.7 | 37.7450065831384 | -122.412477186149 | (37.7450065831384, -122.412477186149) | |
| 90534 | 90534 | 87858 | Koelreuteria paniculata :: Golden Rain Tree 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000340.49747 | 2104887.90927 | 37.7596396402708 | -122.441898968169 | (37.7596396402708, -122.441898968169) | |||||||
| 90850 | 90850 | 95804 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767548 | 6012200.0 | 2102946.0 | 37.7549762368602 | -122.400746185712 | (37.7549762368602, -122.400746185712) | |
| 95721 | 95721 | 49921 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325@ 20th ST San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46679 | 6006742.01796068 | 2104222.31382085 | 37.7581747672784 | -122.419712030585 | (37.7581747672784, -122.419712030585) | ||
| 97429 | 97429 | 45173 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1528 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44021 | 6010431.85887632 | 2100611.56059168 | 37.748467604177705 | -122.40669644419201 | (37.7484676041777, -122.406696444192) | ||
| 99753 | 99753 | 92865 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 260 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 4x4 | Permit Number 774771 | 6004247.0 | 2098697.0 | 37.7428626784389 | -122.42794716566601 | (37.7428626784389, -122.427947165666) | ||
| 107091 | 107091 | 82106 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1442 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767418 | 6003903.93114879 | 2099873.27169394 | 37.746073034264604 | -122.42921725762 | (37.7460730342646, -122.42921725762) | |
| 107516 | 107516 | 52168 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1064 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | Permit Number 48361 | 6009419.47710262 | 2102976.82289251 | 37.754905392409604 | -122.41036423903601 | (37.7549053924096, -122.410364239036) | ||
| 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) | |
| 114721 | 114721 | 47290 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2100 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2002 12:00:00 AM | 3x3 | Permit Number 45232 | 6009541.72996085 | 2104990.45798185 | 37.7604412326322 | -122.41008360325701 | (37.7604412326322, -122.410083603257) | |
| 115743 | 115743 | 49813 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 279 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | Permit Number 46605 | 6012936.15174933 | 2105762.41112227 | 37.7627505163476 | -122.398397952764 | (37.7627505163476, -122.398397952764) | |||
| 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) | |||
| 145134 | 145134 | 39190 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1435 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | Permit Number 40843 | 6007766.05804405 | 2101299.52134892 | 37.7502070771658 | -122.415963470624 | (37.7502070771658, -122.415963470624) | ||
| 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) | ||
| 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) | ||
| 72877 | 72877 | 227039 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 260 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004244.3831400005 | 2098703.3043299997 | 37.742879840636895 | -122.427956663177 | (37.7428798406369, -122.427956663177) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 69135 | 69135 | 32234 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1598 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 2 | Permit Number 35550 | 6008744.76884 | 2099374.8804200003 | 37.744977417571796 | -122.41244298828 | (37.7449774175718, -122.41244298828) | ||
| 132030 | 132030 | 190861 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014308.34576 | 2110328.57935 | 37.77536454816779 | -122.393971642775 | (37.7753645481678, -122.393971642775) | |||
| 136333 | 136333 | 191213 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1255 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015066.17853 | 2109333.99267 | 37.7726757227485 | -122.391280560972 | (37.7726757227485, -122.391280560972) | |||
| 152299 | 152299 | 190875 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014019.10116 | 2110051.07468 | 37.7745865032978 | -122.394952774356 | (37.7745865032978, -122.394952774356) | |||
| 177426 | 177426 | 227038 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 238 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004360.47421 | 2098709.18899 | 37.7429025656093 | -122.42755567166401 | (37.7429025656093, -122.427555671664) | |||
| 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) | |
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 75959 | 75959 | 190894 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014191.20495 | 2110159.4009 | 37.7748935111682 | -122.394365015227 | (37.7748935111682, -122.394365015227) | |||
| 124248 | 124248 | 115879 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1125X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015016.8 | 2096457.8 | 37.737317699837206 | -122.390551463966 | (37.7373176998372, -122.390551463966) | ||
| 132876 | 132876 | 190847 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014760.45028 | 2110759.5978 | 37.77657314436011 | -122.392437849936 | (37.7765731443601, -122.392437849936) | |||
| 143417 | 143417 | 96730 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1531 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015658.7 | 2096702.1 | 37.738024087431995 | -122.38834914513201 | (37.738024087432, -122.388349145132) | |||
| 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) | |||
| 162675 | 162675 | 88046 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51057 | 6015682.046 | 2096712.9906400002 | 37.738055284531896 | -122.388269185596 | (37.7380552845319, -122.388269185596) | |
| 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) | |||
| 183392 | 183392 | 190874 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014038.01567 | 2110068.93569 | 37.774636597347495 | -122.394888596037 | (37.7746365973475, -122.394888596037) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 72227 | 72227 | 191157 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014408.33325 | 2110366.57718 | 37.7754744381338 | -122.39362842011002 | (37.7754744381338, -122.39362842011) | |||
| 148540 | 148540 | 227026 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 3514 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006304.15977 | 2100862.8361 | 37.748925739940006 | -122.420987813049 | (37.74892573994, -122.420987813049) | |||
| 166468 | 166468 | 78586 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | 6012194.44084 | 2102964.2828 | 37.755026127363 | -122.400766695348 | (37.755026127363, -122.400766695348) | ||
| 166698 | 166698 | 227029 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2100 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009538.419980001 | 2104961.20858 | 37.760360734888295 | -122.41009298600201 | (37.7603607348883, -122.410092986002) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 159031 | 159031 | 191156 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014354.13785 | 2110316.1346299998 | 37.7753329226168 | -122.393812364761 | (37.7753329226168, -122.393812364761) | |||
| 183890 | 183890 | 83155 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1714 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52368 | 6014530.43704 | 2094836.5062099998 | 37.7328389648403 | -122.392119708481 | (37.7328389648403, -122.392119708481) | |
| 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) | |||
| 188150 | 188150 | 227035 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2801 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009497.84698 | 2104977.4520099997 | 37.7604030614745 | -122.41023445656799 | (37.7604030614745, -122.410234456568) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 65554 | 65554 | 191154 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014318.22941 | 2110281.7957900004 | 37.7752366403051 | -122.393934177039 | (37.7752366403051, -122.393934177039) | |||
| 157356 | 157356 | 227036 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 121 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010214.63547 | 2100191.80382 | 37.7473028881185 | -122.40741801374901 | (37.7473028881185, -122.407418013749) | |||
| 160907 | 160907 | 227031 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2828 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009344.12011 | 2105016.02091 | 37.7605003447324 | -122.41076885260901 | (37.7605003447324, -122.410768852609) | |||
| 179861 | 179861 | 191203 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013547.7109 | 2109545.07141 | 37.7731709092433 | -122.39654794053499 | (37.7731709092433, -122.396547940535) | |||
| 182570 | 182570 | 227034 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2801 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009481.322269999 | 2104976.8585200002 | 37.760400505599 | -122.41029156621201 | (37.760400505599, -122.410291566212) | |||
| 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) | |||
| 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) |
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");