Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95838 | 95838 | 92924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | tree 4 on 14th st | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 84452 | 84452 | 92923 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | tree 3 on 14th st | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 89271 | 89271 | 92926 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 398 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | tree 2 on 15th st | 5991862.0 | 2096794.0 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | |||
| 122422 | 122422 | 92922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | tree 2 on 14th st. | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 81647 | 81647 | 92928 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | tree 2 on 14th st | 5992361.0 | 2097058.0 | 37.7376827987343 | -122.46892601674101 | (37.7376827987343, -122.468926016741) | |||
| 84463 | 84463 | 92925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 398 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | tree 1 on 15th st | 5991862.0 | 2096794.0 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | |||
| 127493 | 127493 | 92943 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2800X 15TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | tree 1 on 15th st | 5991935.0 | 2096694.0 | 37.7366587249535 | -122.470372388311 | (37.7366587249535, -122.470372388311) | |||
| 79068 | 79068 | 92921 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | tree 1 on 14th st. | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 122362 | 122362 | 92927 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | tree 1 on 14th st | 5992361.0 | 2097058.0 | 37.7376827987343 | -122.46892601674101 | (37.7376827987343, -122.468926016741) | |||
| 97926 | 97926 | 93120 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Tree 4 on Lyon St | 6000421.0 | 2110261.0 | 37.774397395284 | -122.44200622209299 | (37.774397395284, -122.442006222093) | ||
| 83656 | 83656 | 101246 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1301X 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.763865841987204 | -122.465411719392 | (37.7638658419872, -122.465411719392) | |||
| 58203 | 58203 | 30450 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 9 | Permit Number 99 | 5999622.18885 | 2116719.4943 | 37.792085194227795 | -122.44523389245 | (37.7920851942278, -122.44523389245) | ||
| 153737 | 153737 | 54042 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2500 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1972 12:00:00 AM | 14 | Permit Number 9764 | 6001049.7336099995 | 2117960.3763 | 37.795573713011706 | -122.440383615719 | (37.7955737130117, -122.440383615719) | ||
| 38675 | 38675 | 54001 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 19 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 12 | Permit Number 9719 | 6010666.13404 | 2089379.87515 | 37.717640876409604 | -122.405095569414 | (37.7176408764096, -122.405095569414) | ||
| 184602 | 184602 | 54000 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 19 | Permit Number 9718 | 6010673.62628 | 2089402.8086700002 | 37.71770426600779 | -122.40507128591001 | (37.7177042660078, -122.40507128591) | ||
| 156741 | 156741 | 53749 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2373 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1972 12:00:00 AM | 16 | Permit Number 9429 | 6001634.46158 | 2118690.86864 | 37.7976127296949 | -122.438412720891 | (37.7976127296949, -122.438412720891) | ||
| 165993 | 165993 | 30440 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 364 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 11 | Permit Number 93 | 6011168.38887 | 2119716.6741400003 | 37.8009670192778 | -122.40549487558901 | (37.8009670192778, -122.405494875589) | ||
| 167944 | 167944 | 30433 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 341 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 8 | Permit Number 86 | 6011286.31064 | 2119684.8725 | 37.80088629253979 | -122.40508457338998 | (37.8008862925398, -122.40508457339) | ||
| 2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 3063 | 3063 | 13736 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 780155 | 6010795.99203 | 2114077.5984099996 | 37.785462646015894 | -122.40638597245399 | (37.7854626460159, -122.406385972454) | ||
| 3066 | 3066 | 13737 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 780155 | 6010751.43772 | 2114034.04518 | 37.7853405666668 | -122.40653704776001 | (37.7853405666668, -122.40653704776) | ||
| 3498 | 3498 | 200857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1117 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 0ft | Permit Number 780155 | 6008905.5117 | 2112149.5313 | 37.7800626991558 | -122.412790138104 | (37.7800626991558, -122.412790138104) | ||
| 3500 | 3500 | 13943 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Permit Number 780155 | 6008953.3362 | 2112197.3558 | 37.780196698058894 | -122.412628072717 | (37.7801966980589, -122.412628072717) | |||
| 3507 | 3507 | 200856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1117 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | Permit Number 780155 | 6008896.2254 | 2112159.7462 | 37.7800902256084 | -122.412822986117 | (37.7800902256084, -122.412822986117) | ||
| 3515 | 3515 | 13941 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1101 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 780155 | 6008943.5856 | 2112207.5707 | 37.780224198497294 | -122.412662526962 | (37.7802241984973, -122.412662526962) | ||
| 449 | 449 | 200971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1408 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | Permit Number 779898 | 6007408.8361 | 2110843.7597 | 37.7763932439775 | -122.417875241075 | (37.7763932439775, -122.417875241075) | ||
| 476 | 476 | 174954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4xt | Permit Number 779898 | 6007316.0 | 2110809.0 | 37.776292577113104 | -122.418193923043 | (37.7762925771131, -122.418193923043) | |||
| 477 | 477 | 14079 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | ||
| 480 | 480 | 200973 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1416 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 489 | 489 | 200974 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1422 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 0ft | Permit Number 779898 | 6007323.0 | 2110807.0 | 37.7762874795996 | -122.41816956622401 | (37.7762874795996, -122.418169566224) | ||
| 453 | 453 | 200966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1438 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | Permit Number 779897 | 6007276.3996 | 2110716.1923 | 37.776035520315205 | -122.418324330264 | (37.7760355203152, -122.418324330264) | ||
| 481 | 481 | 14087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.775888228839705 | -122.418499137854 | (37.7758882288397, -122.418499137854) | ||
| 493 | 493 | 14089 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | Permit Number 779892 | 6007243.2905 | 2110686.0046 | 37.7759507683181 | -122.418436722662 | (37.7759507683181, -122.418436722662) | ||
| 494 | 494 | 14085 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.775991697649104 | -122.418387229062 | (37.7759916976491, -122.418387229062) | ||
| 9783 | 9783 | 57570 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 151 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 10 | Permit Number 779323 | 6002543.91093059 | 2107348.98528352 | 37.766522467805295 | -122.434454434548 | (37.7665224678053, -122.434454434548) | ||
| 21574 | 21574 | 22927 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779266 | 6006081.681609999 | 2107578.1286400002 | 37.767351825256 | -122.42223418076901 | (37.767351825256, -122.422234180769) | |
| 6831 | 6831 | 101231 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3575 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | Permit Number 779254 | 5997777.0237 | 2115106.06857 | 37.7875496613457 | -122.451501728247 | (37.7875496613457, -122.451501728247) | ||
| 22259 | 22259 | 32095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779125 | 6003421.63406 | 2105677.3546700003 | 37.761982358207796 | -122.431299212108 | (37.7619823582078, -122.431299212108) | |
| 3632 | 3632 | 122539 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3443 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779060 | 5998247.97366 | 2115501.74936 | 37.788663053514 | -122.44990087023001 | (37.788663053514, -122.44990087023) | ||
| 2303 | 2303 | 122440 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013669.1059 | 2114077.4124 | 37.785622440131 | -122.39644576664499 | (37.785622440131, -122.396445766645) | ||
| 2305 | 2305 | 201174 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Permit Number 778941 | 6013723.602999999 | 2114126.7683 | 37.785760992593296 | -122.396260681537 | (37.7857609925933, -122.396260681537) | ||
| 2307 | 2307 | 122432 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778941 | 6013714.3488 | 2114207.9998 | 37.7859835205848 | -122.396298394128 | (37.7859835205848, -122.396298394128) | ||
| 2309 | 2309 | 122433 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013698.925 | 2114193.6044 | 37.785943135879 | -122.396350747311 | (37.785943135879, -122.396350747311) | ||
| 2313 | 2313 | 201193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 611 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 778941 | 6013579.6483 | 2113996.1808 | 37.7853944182999 | -122.39674956946399 | (37.7853944182999, -122.396749569464) | ||
| 2319 | 2319 | 201172 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | Permit Number 778941 | 6013687.6143 | 2114096.9491 | 37.785677113353294 | -122.396383102325 | (37.7856771133533, -122.396383102325) | ||
| 2323 | 2323 | 201173 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | Permit Number 778941 | 6013705.0945 | 2114111.3445 | 37.7857176125048 | -122.39632363473801 | (37.7857176125048, -122.396323634738) | ||
| 2324 | 2324 | 195018 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 778941 | 6013610.320719999 | 2113989.12597 | 37.7853767544813 | -122.39664295660499 | (37.7853767544813, -122.396642956605) | ||
| 2331 | 2331 | 122431 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | Permit Number 778941 | 6013729.7725 | 2114223.4236 | 37.786026729010295 | -122.396246113338 | (37.7860267290103, -122.396246113338) | ||
| 2332 | 2332 | 122438 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | Permit Number 778941 | 6013622.8347 | 2114119.5705 | 37.785735621476 | -122.396608809095 | (37.785735621476, -122.396608809095) | ||
| 2334 | 2334 | 122437 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013638.2584 | 2114134.9942 | 37.7857788297664 | -122.396556528653 | (37.7857788297664, -122.396556528653) | ||
| 2337 | 2337 | 122436 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | Permit Number 778941 | 6013651.6256 | 2114147.3332 | 37.7858134537143 | -122.39651114681001 | (37.7858134537143, -122.39651114681) | ||
| 2344 | 2344 | 122435 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | Permit Number 778941 | 6013667.0494 | 2114164.8134 | 37.785862308640105 | -122.396459010111 | (37.7858623086401, -122.396459010111) | ||
| 2350 | 2350 | 122434 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 778941 | 6013681.4448 | 2114180.2371 | 37.7859054596404 | -122.39641028715201 | (37.7859054596404, -122.396410287152) | ||
| 2351 | 2351 | 201241 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Permit Number 778941 | 6013597.1285 | 2114096.9491 | 37.78567207766061 | -122.396696159476 | (37.7856720776606, -122.396696159476) | ||
| 2360 | 2360 | 122439 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Permit Number 778941 | 6013610.4957 | 2114107.2315 | 37.7857010547146 | -122.39665063354099 | (37.7857010547146, -122.396650633541) | ||
| 171632 | 171632 | 98232 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 778130 | 6003238.99921 | 2117573.43548 | 37.7946356823309 | -122.432780725547 | (37.7946356823309, -122.432780725547) | ||
| 171828 | 171828 | 117267 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2420 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 778065 | 6001282.64713 | 2116736.29992 | 37.7922259776859 | -122.439489905429 | (37.7922259776859, -122.439489905429) | ||
| 96604 | 96604 | 115832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 FONT BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 30x30 | Permit Number 777501 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | ||
| 92233 | 92233 | 111089 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10x HIGUERA AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777485 | 5988057.0 | 2090190.0 | 37.7185754269376 | -122.483303520979 | (37.7185754269376, -122.483303520979) | |
| 109545 | 109545 | 111090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 28x HIGUERA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 3 | Permit Number 777485 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||
| 169469 | 169469 | 112177 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 607 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 9 | 3x3 | Permit Number 777059 | 5986882.7001 | 2111755.36791 | 37.777719715360206 | -122.488946999623 | (37.7777197153602, -122.488946999623) | |
| 56437 | 56437 | 114300 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 435 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 776923 | 6014014.05979 | 2111781.9059099997 | 37.7793386945555 | -122.39509147319401 | (37.7793386945555, -122.395091473194) | |||
| 64993 | 64993 | 53281 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 435 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/1969 12:00:00 AM | 7 | Permit Number 776923 | 6013979.24841 | 2111752.10583 | 37.7792549344058 | -122.39520981318998 | (37.7792549344058, -122.39520981319) | ||
| 12326 | 12326 | 113363 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 126 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x6 | Permit Number 776810 | 5991720.20644 | 2088367.09772 | 37.7137826921811 | -122.470508741378 | (37.7137826921811, -122.470508741378) | ||
| 141067 | 141067 | 35814 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 985 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 776809 | 6006347.1524299 | 2103860.86986085 | 37.7571600746524 | -122.42105198546999 | (37.7571600746524, -122.42105198547) | ||
| 69883 | 69883 | 114317 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1X 09TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x3 | Permit Number 776579 | 6008059.0 | 2111315.0 | 37.77772372592089 | -122.41565950833 | (37.7777237259209, -122.41565950833) | ||
| 14868 | 14868 | 28521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 363 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 776437 | 6011229.90589 | 2111312.4766599997 | 37.777894532647 | -122.40469002104601 | (37.777894532647, -122.404690021046) | ||
| 15874 | 15874 | 28520 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 363 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 776437 | 6011243.37931 | 2111294.78009 | 37.7778466950054 | -122.40464216540899 | (37.7778466950054, -122.404642165409) | ||
| 16549 | 16549 | 28519 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 363 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 776437 | 6011256.2125 | 2111285.60514 | 37.777822219954295 | -122.404597124655 | (37.7778222199543, -122.404597124655) | ||
| 62484 | 62484 | 48755 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 7 | Permit Number 776234 | 6015449.916019999 | 2113164.62035 | 37.783215059461604 | -122.390220832228 | (37.7832150594616, -122.390220832228) | ||
| 121931 | 121931 | 112266 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2731X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776046 | 6000462.89689 | 2117155.53731 | 37.79333040605621 | -122.442356358867 | (37.7933304060562, -122.442356358867) | |
| 34123 | 34123 | 113060 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2015 12:00:00 AM | 5 | 3x3 | Permit Number 776016 | 6000308.57696 | 2117462.63212 | 37.7941648108216 | -122.442912378013 | (37.7941648108216, -122.442912378013) | |
| 188343 | 188343 | 113059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2015 12:00:00 AM | 5 | 3x3 | Permit Number 776016 | 6000289.21565 | 2117461.28412 | 37.7941600057183 | -122.44297927319599 | (37.7941600057183, -122.442979273196) | |
| 7456 | 7456 | 111007 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 600X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2015 12:00:00 AM | 3 | Permit Number 776001 | 6007258.06948 | 2121954.7995599997 | 37.8068929247227 | -122.41918512469299 | (37.8068929247227, -122.419185124693) | ||
| 87016 | 87016 | 104798 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 342 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775822 | 6014205.7 | 2115535.6 | 37.7896561328511 | -122.39469144446801 | (37.7896561328511, -122.394691444468) | |
| 111271 | 111271 | 111095 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 841x GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 3 | Permit Number 775593 | 5988358.0 | 2089771.0 | 37.7174424713469 | -122.48223241855301 | (37.7174424713469, -122.482232418553) | ||
| 139222 | 139222 | 111092 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 801 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 2 | Permit Number 775593 | 5988333.0 | 2089769.0 | 37.717435525652704 | -122.48231868452 | (37.7174355256527, -122.48231868452) | |||
| 114908 | 114908 | 110241 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2582 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 775248 | 6000594.1 | 2118607.8 | 37.7973254142876 | -122.442006676457 | (37.7973254142876, -122.442006676457) | ||||
| 127066 | 127066 | 66888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2582 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1991 12:00:00 AM | Permit Number 775248 | 6000599.43821353 | 2118595.02893704 | 37.7972906525234 | -122.441987287783 | (37.7972906525234, -122.441987287783) | |||
| 89248 | 89248 | 110210 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775226 | 6001402.5 | 2108966.8 | 37.7708997282987 | -122.438518289029 | (37.7708997282987, -122.438518289029) | |
| 99959 | 99959 | 57199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | Permit Number 775226 | 6001375.73081118 | 2109018.49214906 | 37.7710401392977 | -122.438614588589 | (37.7710401392977, -122.438614588589) | ||
| 92292 | 92292 | 39627 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 103609 | 103609 | 39626 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1550 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | ||
| 104147 | 104147 | 39629 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 122002 | 122002 | 39628 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 105001 | 105001 | 93172 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 208 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | Permit Number 775123 | 6005390.7 | 2102395.4 | 37.753082272967895 | -122.424255546161 | (37.7530822729679, -122.424255546161) | ||
| 7932 | 7932 | 110078 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2500X Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775116 | 6001243.709869999 | 2117009.2046 | 37.792973086793 | -122.439644202145 | (37.792973086793, -122.439644202145) | |
| 91863 | 91863 | 59036 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3332 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774919 | 6006108.98648198 | 2103781.3528661 | 37.7569283108811 | -122.42187000821998 | (37.7569283108811, -122.42187000822) | |
| 104228 | 104228 | 68809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 703 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2015 12:00:00 AM | 3 | Permit Number 774820 | 5998513.39462493 | 2108248.20865668 | 37.768761893338706 | -122.448459975986 | (37.7687618933387, -122.448459975986) | ||
| 8205 | 8205 | 110025 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2585 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 774536 | 6001760.7528800005 | 2116964.32872 | 37.7928792839017 | -122.437851993568 | (37.7928792839017, -122.437851993568) | ||
| 103678 | 103678 | 108035 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 945 Market St | unknown : Cutout 12 | Tree 1 | DPW 2 | 3x3 | Permit Number 774370 | 6010085.9126699995 | 2113154.0076 | 37.782886937251796 | -122.408777465126 | (37.7828869372518, -122.408777465126) | ||||
| 145649 | 145649 | 107453 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1817 JACKSON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774262 | 6005381.0 | 2117121.5 | 37.793516032231395 | -122.425336940693 | (37.7935160322314, -122.425336940693) | |||
| 104522 | 104522 | 109450 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 15x4 | Permit Number 774141 | 6003118.8 | 2111045.9 | 37.7767059032045 | -122.43273011286101 | (37.7767059032045, -122.432730112861) | |
| 10666 | 10666 | 108381 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 204 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773815 | 6001936.176109999 | 2090655.40431 | 37.7206512958141 | -122.435362229505 | (37.7206512958141, -122.435362229505) |
| 81702 | 81702 | 85480 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2400X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773456 | 6007069.955904 | 2120527.918212 | 37.8029644763569 | -122.419734821932 | (37.8029644763569, -122.419734821932) | |
| 31899 | 31899 | 106735 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 4 | 3x3 | Permit Number 773198 | 6006215.20028 | 2117589.05238 | 37.794846907909104 | -122.42248377590599 | (37.7948469079091, -122.422483775906) | |
| 174738 | 174738 | 106739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773198 | 6006308.23049 | 2117598.1394 | 37.794877106244606 | -122.42216252370199 | (37.7948771062446, -122.422162523702) | |
| 176460 | 176460 | 106736 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773198 | 6006250.8348900005 | 2117590.81509 | 37.7948537580534 | -122.42236060026698 | (37.7948537580534, -122.422360600267) | |
| 184952 | 184952 | 106737 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 4 | 3x3 | Permit Number 773198 | 6006268.17593 | 2117593.2029 | 37.7948612925596 | -122.42230076746901 | (37.7948612925596, -122.422300767469) |
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");