Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179207 | 179207 | 200191 | Undocumented 2 | :: 54 | 981 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.39271586587799 | (37.7188778046353, -122.392715865878) | |||
| 147039 | 147039 | 200193 | Undocumented 2 | :: 54 | 975 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | |||
| 33211 | 33211 | 200211 | Undocumented 2 | :: 54 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014078.3317 | 2089599.8969999999 | 37.7184351760665 | -122.39331644356001 | (37.7184351760665, -122.39331644356) | |||
| 171028 | 171028 | 182594 | Undocumented 2 | :: 54 | 965 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990156.9225 | 2100377.7114 | 37.7466702775018 | -122.476788966542 | (37.7466702775018, -122.476788966542) | |||
| 154367 | 154367 | 140121 | Undocumented 2 | :: 54 | 963 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003256.5481 | 2110653.9088 | 37.7756374037509 | -122.43222560059799 | (37.7756374037509, -122.432225600598) | |||
| 129236 | 129236 | 41854 | Permitted Site 1 | :: 54 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42241 | 5991990.35837611 | 2105257.12694546 | 37.7601740626082 | -122.47080455929701 | (37.7601740626082, -122.470804559297) | ||
| 86244 | 86244 | 41853 | Permitted Site 1 | :: 54 | 936 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42240 | 5992008.2421953 | 2105257.75589238 | 37.7601768237518 | -122.470742754033 | (37.7601768237518, -122.470742754033) | ||
| 110336 | 110336 | 52107 | Permitted Site 1 | :: 54 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48299 | 5996504.69473395 | 2098122.17494067 | 37.7408432986479 | -122.454676219762 | (37.7408432986479, -122.454676219762) | ||
| 73420 | 73420 | 200232 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | |||
| 177805 | 177805 | 200235 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | |||
| 165416 | 165416 | 200238 | Undocumented 2 | :: 54 | 917 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | |||
| 170841 | 170841 | 138237 | Undocumented 2 | :: 54 | 91 Nido Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999199.3094 | 2112299.5485 | 37.779925031073 | -122.446378945526 | (37.779925031073, -122.446378945526) | |||
| 154962 | 154962 | 141900 | Undocumented 2 | :: 54 | 901 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004811.6243 | 2111979.8877 | 37.7793662649292 | -122.42694066580098 | (37.7793662649292, -122.426940665801) | |||
| 118536 | 118536 | 36929 | Permitted Site 1 | :: 54 | 901 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39571 | 6000612.32634681 | 2101962.60570598 | 37.751622953989205 | -122.440749012812 | (37.7516229539892, -122.440749012812) | ||
| 2526 | 2526 | 141913 | Undocumented 2 | :: 54 | 900 MCALLISTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004416.1749 | 2111910.2001 | 37.779152551854104 | -122.42830372330299 | (37.7791525518541, -122.428303723303) | |||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 166377 | 166377 | 142106 | Undocumented 2 | :: 54 | 9 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998629.1793 | 2110805.0036 | 37.775788818037206 | -122.44824362140899 | (37.7757888180372, -122.448243621409) | |||
| 179646 | 179646 | 140210 | Undocumented 2 | :: 54 | 890 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003670.0896 | 2110760.6625 | 37.7759539617211 | -122.43080267947701 | (37.7759539617211, -122.430802679477) | |||
| 153352 | 153352 | 244386 | Undocumented 2 | :: 54 | 887 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003218.6187 | 2110296.9095 | 37.7746550213638 | -122.432331304978 | (37.7746550213638, -122.432331304978) | |||
| 100579 | 100579 | 117313 | Permitted Site 1 | :: 54 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981355.6 | 2109736.3 | 37.7718518197324 | -122.50791691513099 | (37.7718518197324, -122.507916915131) | |||||
| 45872 | 45872 | 141030 | Undocumented 2 | :: 54 | 88 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998905.3901 | 2112810.7346 | 37.781311824276294 | -122.44743254381099 | (37.7813118242763, -122.447432543811) | |||
| 5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
| 175149 | 175149 | 139288 | Undocumented 2 | :: 54 | 850 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6003023.9373 | 2111228.5503 | 37.7772020350349 | -122.433071323703 | (37.7772020350349, -122.433071323703) | |||
| 61493 | 61493 | 105361 | Permitted Site 1 | :: 54 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 83497 | 83497 | 105359 | Permitted Site 1 | :: 54 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 91070 | 91070 | 105360 | Permitted Site 1 | :: 54 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 138801 | 138801 | 115762 | Undocumented 2 | :: 54 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | |||
| 143047 | 143047 | 115869 | Undocumented 2 | :: 54 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
| 145417 | 145417 | 115870 | Undocumented 2 | :: 54 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
| 84556 | 84556 | 115963 | Undocumented 2 | :: 54 | 847 43RD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585.0 | 2109998.0 | 37.7726427311472 | -122.50368379034599 | (37.7726427311472, -122.503683790346) | ||
| 93014 | 93014 | 115931 | Undocumented 2 | :: 54 | 847 43RD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585.0 | 2109998.0 | 37.7726427311472 | -122.50368379034599 | (37.7726427311472, -122.503683790346) | ||
| 122432 | 122432 | 124725 | Permitted Site 1 | :: 54 | 846 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5984221.0 | 2110064.0 | 37.772920001740104 | -122.498029654692 | (37.7729200017401, -122.498029654692) | |||
| 101699 | 101699 | 120937 | Undocumented 2 | :: 54 | 843 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5985373.0 | 2110131.0 | 37.773171438580604 | -122.494049746171 | (37.7731714385806, -122.494049746171) | ||||
| 93962 | 93962 | 115298 | Permitted Site 1 | :: 54 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | |||||
| 139436 | 139436 | 35137 | Permitted Site 1 | :: 54 | 832 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38668 | 6002000.93226273 | 2088942.9752097 | 37.7159530242515 | -122.435015979431 | (37.7159530242515, -122.435015979431) | ||
| 135474 | 135474 | 140554 | Undocumented 2 | :: 54 | 830 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003715.6997 | 2111462.8271 | 37.7778845161396 | -122.43069501997101 | (37.7778845161396, -122.430695019971) | |||
| 5224 | 5224 | 253827 | Permitted Site 1 | :: 54 | 825 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 73720 | 73720 | 140010 | Undocumented 2 | :: 54 | 820 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004913.6029 | 2111647.1443 | 37.7784583990483 | -122.42656417869699 | (37.7784583990483, -122.426564178697) | |||
| 82474 | 82474 | 108629 | Undocumented 2 | :: 54 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | |||
| 113035 | 113035 | 118550 | Undocumented 2 | :: 54 | 8140 Geary Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5981686.0706 | 2112397.3766900003 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | |||||
| 10128 | 10128 | 173868 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 126598 | 126598 | 121612 | Undocumented 2 | :: 54 | 800X Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001168.0 | 2102650.0 | 37.7535420028484 | -122.43887668159701 | (37.7535420028484, -122.438876681597) | ||||
| 141620 | 141620 | 121614 | Undocumented 2 | :: 54 | 800X Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001168.0 | 2102650.0 | 37.7535420028484 | -122.43887668159701 | (37.7535420028484, -122.438876681597) | ||||
| 72168 | 72168 | 182979 | Undocumented 2 | :: 54 | 800 Vicente St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990295.2626 | 2097717.7991 | 37.739374871061294 | -122.47611636270099 | (37.7393748710613, -122.476116362701) | |||
| 172874 | 172874 | 139933 | Undocumented 2 | :: 54 | 800 GOUGH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005708.0541 | 2112525.3709 | 37.7809146750444 | -122.42387833426001 | (37.7809146750444, -122.42387833426) | |||
| 51323 | 51323 | 33210 | Permitted Site 1 | :: 54 | 80 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 83937 | 83937 | 33209 | Permitted Site 1 | :: 54 | 80 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 102292 | 102292 | 33205 | Permitted Site 1 | :: 54 | 80 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 110733 | 110733 | 33206 | Permitted Site 1 | :: 54 | 80 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 114951 | 114951 | 33208 | Permitted Site 1 | :: 54 | 80 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 131984 | 131984 | 201234 | Undocumented 2 | :: 54 | 795 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6012343.1682 | 2112809.9895 | 37.7820685155731 | -122.400944074647 | (37.7820685155731, -122.400944074647) | |||
| 81995 | 81995 | 37632 | Permitted Site 1 | :: 54 | 791 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40050 | 5990357.50342651 | 2110002.09732806 | 37.773107903504794 | -122.476798459473 | (37.7731079035048, -122.476798459473) | ||
| 123748 | 123748 | 246002 | Undocumented 2 | :: 54 | 79 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999916.7673 | 2108675.5169 | 37.7700153125584 | -122.44363653081801 | (37.7700153125584, -122.443636530818) | |||
| 160080 | 160080 | 248532 | Undocumented 2 | :: 54 | 780 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998628.6838 | 2107761.1245 | 37.7674310747458 | -122.448026126243 | (37.7674310747458, -122.448026126243) | |||
| 19176 | 19176 | 36500 | Permitted Site 1 | :: 54 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39380 | 6007942.28499887 | 2098248.55652594 | 37.741839715130894 | -122.41513812883001 | (37.7418397151309, -122.41513812883) | ||
| 177239 | 177239 | 143326 | Undocumented 2 | :: 54 | 771 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009948.2831 | 2118449.9038 | 37.7974204821659 | -122.40962751849399 | (37.7974204821659, -122.409627518494) | |||
| 69632 | 69632 | 139980 | Undocumented 2 | :: 54 | 755 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005557.6295 | 2112012.432 | 37.779497777315505 | -122.42436223357599 | (37.7794977773155, -122.424362233576) | |||
| 2900 | 2900 | 70091 | Permitted Site 1 | :: 54 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | |
| 79667 | 79667 | 109978 | Undocumented 2 | :: 54 | 75 Escondido Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986097.0 | 2096084.1 | 37.73464482809 | -122.490511739576 | (37.73464482809, -122.490511739576) | ||||
| 108481 | 108481 | 28868 | DPW Maintained 3 | :: 54 | 75 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6013233.2298598 | 2115774.102568 | 37.790256890180295 | -122.39807285434601 | (37.7902568901803, -122.398072854346) | ||
| 29665 | 29665 | 138192 | Undocumented 2 | :: 54 | 747 LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000012.96 | 2111513.4792 | 37.7778131233274 | -122.44350769286301 | (37.7778131233274, -122.443507692863) | |||
| 5229 | 5229 | 253834 | Permitted Site 1 | :: 54 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | |||
| 32319 | 32319 | 138821 | Undocumented 2 | :: 54 | 745 BUCHANAN ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6004449.5065 | 2111116.3546 | 37.776974733592205 | -122.428131826933 | (37.7769747335922, -122.428131826933) | |||
| 18795 | 18795 | 31192 | Permitted Site 1 | :: 54 | 744 Shields St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 20493 | 20493 | 31189 | Permitted Site 1 | :: 54 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 140174 | 140174 | 31188 | Permitted Site 1 | :: 54 | 744 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 142035 | 142035 | 31191 | Permitted Site 1 | :: 54 | 744 Shields St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 146146 | 146146 | 31190 | Permitted Site 1 | :: 54 | 744 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 54373 | 54373 | 246202 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999863.7722 | 2107959.3261 | 37.7680458100097 | -122.443768378658 | (37.7680458100097, -122.443768378658) | |||
| 159456 | 159456 | 246199 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999875.5825 | 2108001.7222 | 37.7681628926873 | -122.443730574399 | (37.7681628926873, -122.443730574399) | |||
| 170361 | 170361 | 246200 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999871.6458 | 2107989.0034 | 37.7681277455177 | -122.443743277143 | (37.7681277455177, -122.443743277143) | |||
| 173941 | 173941 | 246198 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999879.5193 | 2108013.2297 | 37.7681947139353 | -122.443717784266 | (37.7681947139353, -122.443717784266) | |||
| 2881 | 2881 | 253260 | Permitted Site 1 | :: 54 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993234.0 | 2110465.0 | 37.7745453462497 | -122.46688203122801 | (37.7745453462497, -122.466882031228) | ||||
| 122041 | 122041 | 38338 | Permitted Site 1 | :: 54 | 73 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1998 12:00:00 AM | Permit Number 40405 | 5998234.47777194 | 2107177.32360217 | 37.7658055638462 | -122.44934755802 | (37.7658055638462, -122.44934755802) | |||
| 67019 | 67019 | 248388 | Undocumented 2 | :: 54 | 729 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999022.2102 | 2108122.8538 | 37.7684467791283 | -122.446691007031 | (37.7684467791283, -122.446691007031) | |||
| 5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) | |||
| 73891 | 73891 | 246215 | Undocumented 2 | :: 54 | 725 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999843.1798 | 2107896.3377 | 37.767871685104105 | -122.443835079351 | (37.7678716851041, -122.443835079351) | |||
| 39868 | 39868 | 142767 | Undocumented 2 | :: 54 | 724 LARKIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6007520.0381 | 2113832.9802 | 37.7846071803113 | -122.41770248523599 | (37.7846071803113, -122.417702485236) | |||
| 127904 | 127904 | 105121 | Undocumented 2 | :: 54 | 721 BEACH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.42096901139601 | (37.8064757462399, -122.420969011396) | |||||
| 161034 | 161034 | 140786 | Undocumented 2 | :: 54 | 72 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996552.5125 | 2114073.3864 | 37.784643994956 | -122.455663594493 | (37.784643994956, -122.455663594493) | |||
| 154987 | 154987 | 141117 | Undocumented 2 | :: 54 | 719 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997254.2301 | 2112852.8681 | 37.781333017932404 | -122.45314776051599 | (37.7813330179324, -122.453147760516) | |||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 115253 | 115253 | 106460 | Undocumented 2 | :: 54 | 701 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
| 117839 | 117839 | 106461 | Undocumented 2 | :: 54 | 701 Cortland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
| 71149 | 71149 | 142745 | DPW Maintained 3 | :: 54 | 700x COLUMBUS AVE | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | |||
| 80868 | 80868 | 116284 | Undocumented 2 | :: 54 | 700X Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 82559 | 82559 | 116276 | Undocumented 2 | :: 54 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 84777 | 84777 | 116279 | Undocumented 2 | :: 54 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 92470 | 92470 | 116283 | Undocumented 2 | :: 54 | 700X Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 98757 | 98757 | 116282 | Undocumented 2 | :: 54 | 700X Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 116105 | 116105 | 116281 | Undocumented 2 | :: 54 | 700X Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 117089 | 117089 | 116277 | Undocumented 2 | :: 54 | 700X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138269 | 138269 | 116274 | Undocumented 2 | :: 54 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138579 | 138579 | 116278 | Undocumented 2 | :: 54 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 140188 | 140188 | 116280 | Undocumented 2 | :: 54 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 141239 | 141239 | 116275 | Undocumented 2 | :: 54 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) |
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");