trees
262 rows where qSpecies_id = 131
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 698 | 190843 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 150 Berry St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6014866.38244 | 2110860.17534 | 37.7768551897557 | -122.392078432289 | (37.7768551897557, -122.392078432289) | 6 | 2 | 9 | 28856 | 20 | |||
| 1039 | 51110 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 1582 | 51483 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 235 Berry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Permit Number 47794 | 6014118.18221 | 2110089.57063 | 37.774697713467 | -122.39461272721 | (37.774697713467, -122.39461272721) | 6 | 2 | 9 | 310 | 20 | |||
| 2276 | 258359 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 355 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009753.35872 | 2093996.86693 | 37.7302671007809 | -122.408576146225 | (37.7302671007809, -122.408576146225) | 10 | 3 | 7 | 309 | 28 | |||
| 3599 | 78586 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012194.44084 | 2102964.2828 | 37.755026127363 | -122.400766695348 | (37.755026127363, -122.400766695348) | 10 | 3 | 8 | 28856 | 29 | |||
| 4367 | 191204 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 335 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013569.4383 | 2109566.49789 | 37.7732309506901 | -122.396474284254 | (37.7732309506901, -122.396474284254) | 14 | 2 | 9 | 310 | 20 | |||
| 5385 | 255216 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 301 Somerset St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 6236 | 190886 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 255 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6013955.07229 | 2109935.90001 | 37.774266698985 | -122.395166195169 | (37.774266698985, -122.395166195169) | 6 | 2 | 9 | 310 | 20 | |||
| 6351 | 228352 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 284 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001097.75419 | 2104738.1252 | 37.7592714913126 | -122.439269264863 | (37.7592714913126, -122.439269264863) | 2 | 4 | 5 | 28862 | 3 | |||
| 6451 | 258147 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 545 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010168.94115 | 2091715.95591 | 37.7240274636628 | -122.406978711235 | (37.7240274636628, -122.406978711235) | 10 | 3 | 7 | 309 | 28 | |||
| 6468 | 259343 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 103 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6009643.40643 | 2093960.40517 | 37.7301608259889 | -122.408953696123 | (37.7301608259889, -122.408953696123) | 10 | 3 | 7 | 309 | 28 | ||
| 6772 | 255215 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 301 Somerset St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 7244 | 171732 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1000 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007830.37334 | 2093450.39965 | 37.7286587343082 | -122.415185517621 | (37.7286587343082, -122.415185517621) | 9 | 3 | 7 | 309 | 5 | ||
| 7323 | 190833 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 703 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011016.09695 | 2105008.53851 | 37.7605734047683 | -122.404985694736 | (37.7605734047683, -122.404985694736) | 10 | 3 | 8 | 28856 | 29 | |||
| 8325 | 190892 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 255 Berry St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6014082.2782 | 2110055.46717 | 37.7746020768646 | -122.394734538572 | (37.7746020768646, -122.394734538572) | 6 | 2 | 9 | 310 | 20 | |||
| 8566 | 258149 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 545 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010168.94115 | 2091715.95591 | 37.7240274636628 | -122.406978711235 | (37.7240274636628, -122.406978711235) | 10 | 3 | 7 | 309 | 28 | |||
| 9309 | 258372 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1000 Silliman St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 3x5 | 6007882.23453 | 2093465.09674 | 37.7287020037839 | -122.415007269683 | (37.7287020037839, -122.415007269683) | 9 | 3 | 7 | 309 | 5 | |||
| 9899 | 227043 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 203 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007125.13338 | 2096948.38801 | 37.7382237850914 | -122.417871436422 | (37.7382237850914, -122.417871436422) | 2 | 7 | 7 | 28859 | 2 | |||
| 10102 | 259354 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 348 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6005790.37628 | 2092060.92468 | 37.7247286821936 | -122.42213924671 | (37.7247286821936, -122.42213924671) | 9 | 7 | 7 | 309 | 5 | ||
| 10782 | 148125 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 586 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6010249.77584 | 2091840.23784 | 37.7243732390304 | -122.406708031371 | (37.7243732390304, -122.406708031371) | 10 | 3 | 7 | 309 | 28 | ||
| 12769 | 262574 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 300 Berry St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 5ft | 6013629.16381 | 2109678.37452 | 37.7735414622978 | -122.39627552692 | (37.7735414622978, -122.39627552692) | 14 | 2 | 9 | 310 | 20 | ||||
| 12921 | 172225 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 293 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002620.96329 | 2091863.08034 | 37.7240061708318 | -122.433081377925 | (37.7240061708318, -122.433081377925) | 9 | 7 | 6 | 28861 | 5 | |||
| 15937 | 258364 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 740 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008632.63792 | 2093695.13863 | 37.7293757893363 | -122.412429323354 | (37.7293757893363, -122.412429323354) | 9 | 3 | 7 | 309 | 28 | |||
| 15948 | 190852 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 150 Berry St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6014650.44732 | 2110654.39937 | 37.7762781838256 | -122.392811023636 | (37.7762781838256, -122.392811023636) | 6 | 2 | 9 | 28856 | 20 | |||
| 17585 | 258148 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 545 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6010168.94115 | 2091715.95591 | 37.7240274636628 | -122.406978711235 | (37.7240274636628, -122.406978711235) | 10 | 3 | 7 | 309 | 28 | ||
| 18157 | 190867 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014182.02863 | 2110206.19934 | 37.7750214990787 | -122.394400035746 | (37.7750214990787, -122.394400035746) | 6 | 2 | 9 | 310 | 20 | |||
| 18460 | 190860 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014325.82728 | 2110344.39106 | 37.7754089351207 | -122.393912276726 | (37.7754089351207, -122.393912276726) | 6 | 2 | 9 | 310 | 20 | |||
| 19509 | 255217 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 301 Somerset St | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 20004 | 191175 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 362 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013105.34974 | 2109176.16166 | 37.772133338027 | -122.39805225091 | (37.772133338027, -122.39805225091) | 14 | 2 | 9 | 310 | 20 | |||
| 21081 | 191193 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 401 Berry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6013038.65565 | 2109052.45663 | 37.7717899570585 | -122.398274271964 | (37.7717899570585, -122.398274271964) | 14 | 2 | 9 | 310 | 20 | |||
| 21586 | 191162 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 300 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6013718.31553 | 2109764.71694 | 37.7737834995356 | -122.395973187435 | (37.7737834995356, -122.395973187435) | 14 | 2 | 9 | 310 | 20 | |||
| 21965 | 51121 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 22933 | 227044 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 319 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006891.79407 | 2096315.86967 | 37.7364738950591 | -122.418633368154 | (37.7364738950591, -122.418633368154) | 2 | 7 | 7 | 28859 | 2 | |||
| 23838 | 51141 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 25073 | 191156 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 201 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014354.13785 | 2110316.13463 | 37.7753329226168 | -122.393812364761 | (37.7753329226168, -122.393812364761) | 6 | 2 | 9 | 310 | 20 | |||
| 25680 | 190862 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014289.87185 | 2110309.5547 | 37.7753112840173 | -122.394034216714 | (37.7753112840173, -122.394034216714) | 6 | 2 | 9 | 310 | 20 | |||
| 26521 | 191180 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 362 Berry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6013011.10848 | 2109086.96064 | 37.7718831628012 | -122.398371981496 | (37.7718831628012, -122.398371981496) | 14 | 2 | 9 | 310 | 20 | |||
| 27114 | 191211 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 325 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013764.85039 | 2109752.71047 | 37.7737531213363 | -122.395811373297 | (37.7737531213363, -122.395811373297) | 14 | 2 | 9 | 310 | 20 | |||
| 27318 | 64532 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1414 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2018 12:00:00 AM | 3 | Permit Number 782066 | 6016046.60541162 | 2094755.16174124 | 37.7326996741976 | -122.38687221028 | (37.7326996741976, -122.38687221028) | 10 | 3 | 8 | 58 | 1 | |
| 28048 | 191186 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 455 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6012843.92542 | 2108867.55559 | 37.7712714115714 | -122.398934881559 | (37.7712714115714, -122.398934881559) | 14 | 2 | 9 | 310 | 20 | |||
| 28891 | 190872 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 200 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014072.10328 | 2110103.11714 | 37.7747323472599 | -122.394773073625 | (37.7747323472599, -122.394773073625) | 6 | 2 | 9 | 310 | 20 | |||
| 29526 | 49806 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1164SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46601 | 6014134.35886 | 2105751.71512 | 37.762787822535 | -122.394252998377 | (37.762787822535, -122.394252998377) | 14 | 3 | 8 | 28856 | 29 | ||
| 30153 | 191153 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 235 Berry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014300.13588 | 2110263.57014 | 37.7751855911885 | -122.393995491012 | (37.7751855911885, -122.393995491012) | 6 | 2 | 9 | 310 | 20 | |||
| 30233 | 85227 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 355 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | 10 | Permit Number 49539 | 6013279.22191 | 2109288.33477 | 37.7724510226373 | -122.397458676797 | (37.7724510226373, -122.397458676797) | 14 | 2 | 9 | 310 | 20 | ||
| 31304 | 51108 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 31771 | 190854 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 150 Berry St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6014595.17181 | 2110600.56829 | 37.7761273054628 | -122.392998471116 | (37.7761273054628, -122.392998471116) | 6 | 2 | 9 | 28856 | 20 | |||
| 34345 | 191157 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 201 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014408.33325 | 2110366.57718 | 37.7754744381338 | -122.39362842011 | (37.7754744381338, -122.39362842011) | 6 | 2 | 9 | 310 | 20 | |||
| 35979 | 191202 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 335 Berry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6013529.91648 | 2109527.13301 | 37.7731206641192 | -122.39660823648 | (37.7731206641192, -122.39660823648) | 14 | 2 | 9 | 310 | 20 | |||
| 37323 | 227036 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 121 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010214.63547 | 2100191.80382 | 37.7473028881185 | -122.407418013749 | (37.7473028881185, -122.407418013749) | 2 | 7 | 7 | 28859 | 2 | |||
| 37626 | 191212 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 325 Berry St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6013783.16711 | 2109770.00926 | 37.7738016388768 | -122.395749224742 | (37.7738016388768, -122.395749224742) | 14 | 2 | 9 | 310 | 20 | |||
| 37677 | 190857 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014414.04572 | 2110429.2067 | 37.7756467221642 | -122.393613043529 | (37.7756467221642, -122.393613043529) | 6 | 2 | 9 | 310 | 20 | |||
| 37813 | 85228 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 355 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013295.28168 | 2109303.69122 | 37.7724940821684 | -122.397404201236 | (37.7724940821684, -122.397404201236) | 14 | 2 | 9 | 310 | 20 | ||
| 38451 | 115879 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1125X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015016.8 | 2096457.8 | 37.7373176998372 | -122.390551463966 | (37.7373176998372, -122.390551463966) | 10 | 3 | 8 | 58 | 1 | ||
| 40721 | 95589 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767379 | 6008735.1 | 2099385.7 | 37.7450065831384 | -122.412477186149 | (37.7450065831384, -122.412477186149) | 2 | 7 | 7 | 28859 | 2 | |
| 41628 | 190851 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 150 Berry St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6014668.67654 | 2110670.86203 | 37.7763243990775 | -122.392749115191 | (37.7763243990775, -122.392749115191) | 6 | 2 | 9 | 28856 | 20 | |||
| 41639 | 51109 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 41652 | 191208 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 325 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013709.66552 | 2109700.15636 | 37.7736057494514 | -122.395998584276 | (37.7736057494514, -122.395998584276) | 14 | 2 | 9 | 310 | 20 | |||
| 41942 | 190877 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 200 Berry St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6013984.28553 | 2110015.29135 | 37.7744863143202 | -122.395070702467 | (37.7744863143202, -122.395070702467) | 6 | 2 | 9 | 310 | 20 | |||
| 42395 | 85225 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 355 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013241.67832 | 2109252.65125 | 37.7723509532716 | -122.39758604147 | (37.7723509532716, -122.39758604147) | 14 | 2 | 9 | 310 | 20 | ||
| 42661 | 85230 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 355 Berry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013331.92947 | 2109338.95114 | 37.7725929383524 | -122.397279905049 | (37.7725929383524, -122.397279905049) | 14 | 2 | 9 | 310 | 20 | ||
| 42884 | 190837 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 540 Barneveld Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6011137.80262 | 2097880.16304 | 37.7410072488818 | -122.404063094656 | (37.7410072488818, -122.404063094656) | 10 | 3 | 8 | 58 | 1 | |||
| 43060 | 191174 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 362 Berry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013121.88332 | 2109194.88719 | 37.772185674958 | -122.397996373354 | (37.772185674958, -122.397996373354) | 14 | 2 | 9 | 310 | 20 | |||
| 44171 | 51122 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | 9 | Permit Number 47557 | 6012812.37793 | 2108902.32047 | 37.7713651101465 | -122.399046446937 | (37.7713651101465, -122.399046446937) | 14 | 2 | 9 | 310 | 20 | ||
| 45191 | 191159 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 201 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014441.85996 | 2110400.02301 | 37.7755681357843 | -122.39351478358 | (37.7755681357843, -122.39351478358) | 6 | 2 | 9 | 310 | 20 | |||
| 45192 | 85223 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 355 Berry St | 1 | : | Tree | Private 2 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013205.26566 | 2109218.04927 | 37.7722539164092 | -122.397709569661 | (37.7722539164092, -122.397709569661) | 14 | 2 | 9 | 310 | 20 | ||
| 46087 | 191185 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 455 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6012824.91108 | 2108848.72466 | 37.7712186465448 | -122.398999331472 | (37.7712186465448, -122.398999331472) | 14 | 2 | 9 | 310 | 20 | |||
| 46942 | 227049 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 53 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002595.33861 | 2096033.4537 | 37.7354556169913 | -122.433467841774 | (37.7354556169913, -122.433467841774) | 2 | 7 | 5 | 63 | 7 | |||
| 48267 | 227028 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 2443 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6011191.55955 | 2102271.08783 | 37.7530667789276 | -122.404186180354 | (37.7530667789276, -122.404186180354) | 10 | 4 | 8 | 28859 | 19 | |||
| 48439 | 190859 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014379.08951 | 2110393.29962 | 37.7755461869437 | -122.39373145277 | (37.7755461869437, -122.39373145277) | 6 | 2 | 9 | 310 | 20 | |||
| 49304 | 191184 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 455 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6012805.88802 | 2108829.45241 | 37.7711646692314 | -122.399063780475 | (37.7711646692314, -122.399063780475) | 14 | 2 | 9 | 310 | 20 | |||
| 50267 | 190879 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 200 Berry St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6013947.21695 | 2109982.78674 | 37.7743950025592 | -122.395196653408 | (37.7743950025592, -122.395196653408) | 6 | 2 | 9 | 310 | 20 | |||
| 51703 | 51140 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 52004 | 190890 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 255 Berry St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014028.53972 | 2110004.30919 | 37.7744586205966 | -122.394916848253 | (37.7744586205966, -122.394916848253) | 6 | 2 | 9 | 310 | 20 | |||
| 54387 | 227027 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1301 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011166.45785 | 2102232.02401 | 37.7529581156441 | -122.404270238186 | (37.7529581156441, -122.404270238186) | 10 | 4 | 8 | 28859 | 19 | |||
| 54491 | 227045 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 691 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009312.22316 | 2105039.82895 | 37.7605639276988 | -122.410880851495 | (37.7605639276988, -122.410880851495) | 2 | 4 | 7 | 28859 | 19 | |||
| 55482 | 190846 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 150 Berry St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014778.17275 | 2110775.57556 | 37.7766179998472 | -122.392377660099 | (37.7766179998472, -122.392377660099) | 6 | 2 | 9 | 28856 | 20 | |||
| 56251 | 191173 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 362 Berry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013140.43532 | 2109211.39045 | 37.7722320224209 | -122.397933357863 | (37.7722320224209, -122.397933357863) | 14 | 2 | 9 | 310 | 20 | |||
| 56669 | 191158 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 201 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014425.70872 | 2110384.34677 | 37.7755241949197 | -122.393569557682 | (37.7755241949197, -122.393569557682) | 6 | 2 | 9 | 310 | 20 | |||
| 57641 | 87858 | - 12 | Koelreuteria paniculata :: Golden Rain Tree 131 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000340.49747 | 2104887.90927 | 37.7596396402708 | -122.441898968169 | (37.7596396402708, -122.441898968169) | 2 | 4 | 5 | 28862 | 3 | ||||||
| 58004 | 227037 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1528 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010462.23727 | 2100563.14483 | 37.7483363647345 | -122.406587984451 | (37.7483363647345, -122.406587984451) | 2 | 7 | 7 | 28859 | 2 | |||
| 58051 | 51126 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012833.17756 | 2108921.61104 | 37.7714192367477 | -122.39897585375 | (37.7714192367477, -122.39897585375) | 14 | 2 | 9 | 310 | 20 | ||
| 60706 | 190868 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014162.65537 | 2110188.57843 | 37.7749720390567 | -122.39446581847 | (37.7749720390567, -122.39446581847) | 6 | 2 | 9 | 310 | 20 | |||
| 61464 | 191209 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 325 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6013727.79169 | 2109719.00523 | 37.7736585126619 | -122.395937203756 | (37.7736585126619, -122.395937203756) | 14 | 2 | 9 | 310 | 20 | |||
| 63288 | 190895 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 235 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6014262.57866 | 2110228.29984 | 37.7750866594644 | -122.394122941124 | (37.7750866594644, -122.394122941124) | 6 | 2 | 9 | 310 | 20 | |||
| 64773 | 32234 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1598 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/1995 12:00:00 AM | 2 | Permit Number 35550 | 6008744.76884 | 2099374.88042 | 37.7449774175718 | -122.41244298828 | (37.7449774175718, -122.41244298828) | 2 | 7 | 7 | 28859 | 2 | ||
| 66276 | 227031 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 2828 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009344.12011 | 2105016.02091 | 37.7605003447324 | -122.410768852609 | (37.7605003447324, -122.410768852609) | 2 | 4 | 7 | 28859 | 19 | |||
| 66716 | 190840 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 150 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6014957.07587 | 2110944.72485 | 37.7770923787421 | -122.391770606946 | (37.7770923787421, -122.391770606946) | 6 | 2 | 9 | 28856 | 20 | |||
| 67639 | 95804 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767548 | 6012200 | 2102946 | 37.7549762368602 | -122.400746185712 | (37.7549762368602, -122.400746185712) | 10 | 3 | 8 | 28856 | 29 | |
| 68250 | 85233 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 355 Berry St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | 12 | Permit Number 49539 | 6013385.07992 | 2109389.55863 | 37.7727348540654 | -122.397099599979 | (37.7727348540654, -122.397099599979) | 14 | 2 | 9 | 310 | 20 | ||
| 69279 | 51113 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 70522 | 51120 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012887.75032 | 2108975.98412 | 37.771571573793 | -122.398790899202 | (37.771571573793, -122.398790899202) | 14 | 2 | 9 | 310 | 20 | ||
| 72910 | 119659 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 401X Berry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012884.61917 | 2108905.38384 | 37.7713775468798 | -122.398796774473 | (37.7713775468798, -122.398796774473) | 14 | 2 | 9 | 310 | 20 | |||
| 73314 | 51131 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | 1 | Permit Number 47557 | 6012714.57353 | 2108809.39867 | 37.7711045171766 | -122.399378234725 | (37.7711045171766, -122.399378234725) | 14 | 2 | 9 | 310 | 20 | ||
| 73921 | 51137 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 74141 | 190861 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014308.34576 | 2110328.57935 | 37.7753645481678 | -122.393971642775 | (37.7753645481678, -122.393971642775) | 6 | 2 | 9 | 310 | 20 | |||
| 74186 | 51138 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 36 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | 14 | 2 | 9 | 310 | 20 | |||
| 76310 | 51129 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 420@ 6TH ST Berry St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2004 12:00:00 AM | 11 | Permit Number 47557 | 6012752.45555 | 2108845.8204 | 37.7712066343196 | -122.399249755781 | (37.7712066343196, -122.399249755781) | 14 | 2 | 9 | 310 | 20 | ||
| 77317 | 190866 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 180 Berry St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6014217.98901 | 2110241.26669 | 37.7751197850873 | -122.394278095768 | (37.7751197850873, -122.394278095768) | 6 | 2 | 9 | 310 | 20 | |||
| 78405 | 190894 | DPW Maintained 1 | Koelreuteria paniculata :: Golden Rain Tree 131 | 235 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014191.20495 | 2110159.4009 | 37.7748935111682 | -122.394365015227 | (37.7748935111682, -122.394365015227) | 6 | 2 | 9 | 310 | 20 | |||
| 79847 | 45173 | Permitted Site 7 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1528 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44021 | 6010431.85887632 | 2100611.56059168 | 37.7484676041777 | -122.406696444192 | (37.7484676041777, -122.406696444192) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );