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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 68603 | 68603 | 142716 | DPW Maintained 3 | :: 54 | 1120 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008073.8404 | 2121121.2819 | 37.804650203273 | -122.416302902461 | (37.804650203273, -122.416302902461) | |||
| 161855 | 161855 | 142539 | Undocumented 2 | :: 54 | 2100 POWELL ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009429.9045 | 2121027.6379 | 37.80446924024871 | -122.411603472126 | (37.8044692402487, -122.411603472126) | |||
| 168746 | 168746 | 142538 | Undocumented 2 | :: 54 | 2100 POWELL ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009433.1509 | 2121013.8406 | 37.8044315384071 | -122.41159126219999 | (37.8044315384071, -122.4115912622) | |||
| 48216 | 48216 | 142535 | Undocumented 2 | :: 54 | 2100 POWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009442.0785 | 2120948.1005 | 37.8042515332642 | -122.411555719808 | (37.8042515332642, -122.411555719808) | |||
| 94995 | 94995 | 108989 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 99690 | 99690 | 108992 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 112032 | 112032 | 108988 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 127461 | 127461 | 108990 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 139188 | 139188 | 108993 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 119594 | 119594 | 142533 | Undocumented 2 | :: 54 | 2100 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009449.382999999 | 2120911.5782 | 37.8041516618577 | -122.411527859992 | (37.8041516618577, -122.411527859992) | |||
| 76803 | 76803 | 142532 | Undocumented 2 | :: 54 | 2100 POWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009454.2526 | 2120892.9113 | 37.8041006803451 | -122.411509688684 | (37.8041006803451, -122.411509688684) | |||
| 27534 | 27534 | 142574 | Undocumented 2 | :: 54 | 2251 MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008922.4097 | 2120888.3705 | 37.804058366605894 | -122.413349854276 | (37.8040583666059, -122.413349854276) | |||
| 71471 | 71471 | 142991 | Undocumented 2 | :: 54 | 1847 GRANT AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010381.3657 | 2120852.2682 | 37.8040410433015 | -122.40829846422399 | (37.8040410433015, -122.408298464224) | |||
| 66974 | 66974 | 143024 | Undocumented 2 | :: 54 | 455 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009921.899 | 2120677.5714 | 37.8035356299689 | -122.409876147779 | (37.8035356299689, -122.409876147779) | |||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4726 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 155771 | 155771 | 143061 | Undocumented 2 | :: 54 | 448 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010702.5496 | 2120345.6865 | 37.802668074688796 | -122.407151249431 | (37.8026680746888, -122.407151249431) | |||
| 170895 | 170895 | 143062 | Undocumented 2 | :: 54 | 454 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010688.107000001 | 2120341.9039 | 37.802656880339 | -122.40720096156299 | (37.802656880339, -122.407200961563) | |||
| 54235 | 54235 | 143063 | Undocumented 2 | :: 54 | 454 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010670.2258 | 2120340.5284 | 37.802652102828105 | -122.407262742811 | (37.8026521028281, -122.407262742811) | |||
| 179241 | 179241 | 143066 | Undocumented 2 | :: 54 | 454 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010650.2813 | 2120338.1214 | 37.802644377560505 | -122.407331591384 | (37.8026443775605, -122.407331591384) | |||
| 162078 | 162078 | 143072 | Undocumented 2 | :: 54 | 644 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009782.3270000005 | 2120221.5354 | 37.8022756451991 | -122.410326926401 | (37.8022756451991, -122.410326926401) | |||
| 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) | |||||
| 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) | |||
| 151800 | 151800 | 142762 | Undocumented 2 | :: 54 | 400 FILBERT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010787.7026 | 2120010.8966 | 37.8017535888682 | -122.40683296646999 | (37.8017535888682, -122.40683296647) | |||
| 42482 | 42482 | 143383 | Undocumented 2 | :: 54 | 1630 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004501.2884 | 2119830.7279 | 37.8009051385339 | -122.42857401927601 | (37.8009051385339, -122.428574019276) | |||
| 26182 | 26182 | 142482 | Undocumented 2 | :: 54 | 1501 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010536.0572 | 2119686.9897 | 37.800850136387204 | -122.407680928456 | (37.8008501363872, -122.407680928456) | |||
| 33364 | 33364 | 143238 | Undocumented 2 | :: 54 | 1734 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004092.1528 | 2119775.7189 | 37.8007309359716 | -122.429985874998 | (37.8007309359716, -122.429985874998) | |||
| 42994 | 42994 | 109343 | Permitted Site 1 | :: 54 | 3211 Baker St | 2 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 97307 | 97307 | 109345 | Permitted Site 1 | :: 54 | 3211 Baker St | 4 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 99464 | 99464 | 109344 | Permitted Site 1 | :: 54 | 3211 Baker St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 117141 | 117141 | 115013 | Permitted Site 1 | :: 54 | 2493 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 5999602.09209 | 2119817.77431 | 37.8005911003042 | -122.44552631681499 | (37.8005911003042, -122.445526316815) | ||||
| 77940 | 77940 | 114567 | Permitted Site 1 | :: 54 | 1930 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/2015 12:00:00 AM | 3x3 | 6008702.7 | 2119505.5 | 37.8002490116896 | -122.414012289596 | (37.8002490116896, -122.414012289596) | ||
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 36780 | 36780 | 143122 | Undocumented 2 | :: 54 | 1965 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003008.0203 | 2119542.9474 | 37.8000303489096 | -122.433720773421 | (37.8000303489096, -122.433720773421) | |||
| 33983 | 33983 | 142497 | Undocumented 2 | :: 54 | 555 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009877.0468 | 2119393.2664 | 37.8000067321588 | -122.40994064461901 | (37.8000067321588, -122.409940644619) | |||
| 125946 | 125946 | 109370 | Permitted Site 1 | :: 54 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 128427 | 128427 | 109369 | Permitted Site 1 | :: 54 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 101115 | 101115 | 109364 | Permitted Site 1 | :: 54 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 124298 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 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) | ||||||
| 79234 | 79234 | 121045 | Undocumented 2 | :: 54 | 2316 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006394.0 | 2118785.0 | 37.7981407640584 | -122.42195009968201 | (37.7981407640584, -122.421950099682) | ||||
| 99667 | 99667 | 121044 | Undocumented 2 | :: 54 | 2300 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006372.0 | 2118729.0 | 37.7979857614387 | -122.42202224598101 | (37.7979857614387, -122.422022245981) | ||||
| 186274 | 186274 | 143336 | Undocumented 2 | :: 54 | 1858 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004106.6848 | 2118733.7418 | 37.797870758582 | -122.429861223474 | (37.797870758582, -122.429861223474) | |||
| 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) | |||
| 162576 | 162576 | 143541 | Undocumented 2 | :: 54 | 2145 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002743.897999999 | 2118498.8394 | 37.7971485097359 | -122.434560038838 | (37.7971485097359, -122.434560038838) | |||
| 83254 | 83254 | 110159 | Permitted Site 1 | :: 54 | 1041 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 55966 | 6008597.3 | 2118278.8 | 37.7968748776387 | -122.414290174718 | (37.7968748776387, -122.414290174718) | |||
| 142347 | 142347 | 109178 | Permitted Site 1 | :: 54 | 2832 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2015 12:00:00 AM | 3 | 6001592.1 | 2118171.6 | 37.796184544404895 | -122.438522078694 | (37.7961845444049, -122.438522078694) | |||
| 114892 | 114892 | 115259 | Permitted Site 1 | :: 54 | 2130 Jackson St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004.0 | 37.7931106894063 | -122.43038787884501 | (37.7931106894063, -122.430387878845) | ||||
| 99206 | 99206 | 115258 | Permitted Site 1 | :: 54 | 2150 Jackson St | : Cutout 24 | Landscaping 2 | Private 1 | 01/21/2016 12:00:00 AM | 6x12 | 6003858.0 | 2116995.5 | 37.7930839063862 | -122.430597643601 | (37.7930839063862, -122.430597643601) | ||||
| 1824 | 1824 | 251724 | Permitted Site 1 | :: 54 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.792580631742204 | -122.419937373279 | (37.7925806317422, -122.419937373279) | ||
| 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) | ||
| 3345 | 3345 | 253419 | Planning Code 138.1 required 4 | :: 54 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
| 98437 | 98437 | 113995 | Permitted Site 1 | :: 54 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692456996 | -122.44641142836599 | (37.789931692457, -122.446411428366) | |||
| 137781 | 137781 | 137836 | Undocumented 2 | :: 54 | 2275 CALIFORNIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003502.6074 | 2115546.0928 | 37.7890840639569 | -122.43172379026699 | (37.7890840639569, -122.431723790267) | |||
| 74336 | 74336 | 137805 | Undocumented 2 | :: 54 | 2050 BUCHANAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003886.2253 | 2115511.1067 | 37.789009738509 | -122.430394024555 | (37.789009738509, -122.430394024555) | |||
| 83840 | 83840 | 107144 | Undocumented 2 | :: 54 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6015708.0 | 2115219.0 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | |||||
| 159669 | 159669 | 137910 | Undocumented 2 | :: 54 | 1911 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004805.9953 | 2115383.078 | 37.78871026126421 | -122.427202616598 | (37.7887102612642, -122.427202616598) | |||
| 27362 | 27362 | 137901 | Undocumented 2 | :: 54 | 402 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005281.3807 | 2115310.0743 | 37.7885366835693 | -122.425552653183 | (37.7885366835693, -122.425552653183) | |||
| 25506 | 25506 | 137920 | Undocumented 2 | :: 54 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.788390961736795 | -122.433650548643 | (37.7883909617368, -122.433650548643) | |||
| 162420 | 162420 | 137600 | Undocumented 2 | :: 54 | 1962 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003923.2555 | 2115244.7298 | 37.788280432381704 | -122.43024689312901 | (37.7882804323817, -122.430246893129) | |||
| 172981 | 172981 | 137942 | Undocumented 2 | :: 54 | 2211 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003314.7712 | 2115171.6201 | 37.788045207943895 | -122.432346923095 | (37.7880452079439, -122.432346923095) | |||
| 34796 | 34796 | 138319 | Undocumented 2 | :: 54 | 1915 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001944.4165 | 2115111.5373 | 37.7878024384193 | -122.437083797069 | (37.7878024384193, -122.437083797069) | |||
| 72928 | 72928 | 138462 | Undocumented 2 | :: 54 | 2583 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001603.2252 | 2114934.9525 | 37.787298182297604 | -122.43825159732701 | (37.7872981822976, -122.438251597327) | |||
| 166677 | 166677 | 138614 | Undocumented 2 | :: 54 | 2605 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001446.0479 | 2114908.9608 | 37.7872178749778 | -122.438793533195 | (37.7872178749778, -122.438793533195) | |||
| 128256 | 128256 | 37520 | Permitted Site 1 | :: 54 | 649 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39973 | 6008796.59183246 | 2114756.17350418 | 37.787213798801396 | -122.41335133309099 | (37.7872137988014, -122.413351333091) | ||
| 139869 | 139869 | 138464 | Undocumented 2 | :: 54 | 1860 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001535.6052 | 2114878.1517 | 37.7871383757455 | -122.438481476588 | (37.7871383757455, -122.438481476588) | |||
| 6373 | 6373 | 138089 | Undocumented 2 | :: 54 | 1600 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004809.7961 | 2114741.3813 | 37.7869485378128 | -122.427143741054 | (37.7869485378128, -122.427143741054) | ||||
| 3276 | 3276 | 149033 | Permitted Site 1 | :: 54 | 3916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2017 12:00:00 AM | 3 | 5.5x12 | 5996085.364440001 | 2114918.02173 | 37.7869363183091 | -122.45734088598302 | (37.7869363183091, -122.457340885983) | ||
| 29653 | 29653 | 138301 | Undocumented 2 | :: 54 | 2201 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002887.8567 | 2114766.9673 | 37.786909917993 | -122.433795036923 | (37.786909917993, -122.433795036923) | |||
| 40775 | 40775 | 138003 | Undocumented 2 | :: 54 | 1670 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004492.797 | 2114606.7181 | 37.7865608551259 | -122.428230885205 | (37.7865608551259, -122.428230885205) | |||
| 88689 | 88689 | 109762 | Permitted Site 1 | :: 54 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
| 97786 | 97786 | 109767 | Permitted Site 1 | :: 54 | 1801 Scott St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 11.75x1.5+3.6x3.6 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
| 103132 | 103132 | 113996 | Undocumented 2 | :: 54 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989321.8 | 2114884.9 | 37.786454584135704 | -122.480738581989 | (37.7864545841357, -122.480738581989) | |||||
| 108795 | 108795 | 113997 | Undocumented 2 | :: 54 | 58 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989321.8 | 2114884.9 | 37.786454584135704 | -122.480738581989 | (37.7864545841357, -122.480738581989) | |||||
| 166273 | 166273 | 138329 | Undocumented 2 | :: 54 | 1736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002069.0633 | 2114564.3547 | 37.786307099293104 | -122.436613361614 | (37.7863070992931, -122.436613361614) | |||
| 20483 | 20483 | 109769 | Permitted Site 1 | :: 54 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 106864 | 106864 | 109768 | Permitted Site 1 | :: 54 | 2502X Bush St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x13 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 70552 | 70552 | 138623 | Undocumented 2 | :: 54 | 2580 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001132.7512 | 2114573.2069 | 37.78627815239479 | -122.439853387833 | (37.7862781523948, -122.439853387833) | |||
| 109524 | 109524 | 113719 | Undocumented 2 | :: 54 | 1705 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000536.0 | 2114563.0 | 37.78621614021311 | -122.44191725395099 | (37.7862161402131, -122.441917253951) | ||||
| 46286 | 46286 | 138648 | Undocumented 2 | :: 54 | 600 PRESIDIO AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999215.949 | 2114570.5132 | 37.786161460452796 | -122.446484808381 | (37.7861614604528, -122.446484808381) | |||
| 164453 | 164453 | 138698 | Undocumented 2 | :: 54 | 1600 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000125.4805 | 2114462.3047 | 37.7859162558141 | -122.443330304354 | (37.7859162558141, -122.443330304354) | |||
| 118485 | 118485 | 141225 | Undocumented 2 | :: 54 | 3 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996479.075 | 2114520.1031 | 37.7858663452689 | -122.45594996776899 | (37.7858663452689, -122.455949967769) |
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");