Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2754 | 2754 | 253208 | DPW Maintained 3 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 201x Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011752.0 | 2111938.0 | 37.7796412414558 | -122.402927910408 | (37.7796412414558, -122.402927910408) | ||||
| 18083 | 18083 | 110821 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
| 58944 | 58944 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
| 69382 | 69382 | 110827 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
| 77471 | 77471 | 100428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 79434 | 79434 | 105048 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 205 Carl St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 771190 | 5997152.5 | 2107007.0 | 37.765275948780605 | -122.453077573625 | (37.7652759487806, -122.453077573625) | ||||
| 79737 | 79737 | 107876 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 878 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007933.7 | 2102810.7 | 37.754365855539206 | -122.41549072804399 | (37.7543658555392, -122.415490728044) | |||
| 81125 | 81125 | 117210 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620x YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009734.0 | 2105398.0 | 37.761571025328294 | -122.409447389709 | (37.7615710253283, -122.409447389709) | ||||
| 81803 | 81803 | 107281 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3545 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005985.0 | 2101973.7 | 37.7519579213255 | -122.422170380161 | (37.7519579213255, -122.422170380161) | ||||
| 83818 | 83818 | 110808 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 84216 | 84216 | 110807 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 84447 | 84447 | 98446 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1117 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Looks like it was planted at same time as tree no. 1 which permit was issued for. | 6009758.0 | 2111239.0 | 37.7776104068373 | -122.409776693812 | (37.7776104068373, -122.409776693812) | |||
| 84552 | 84552 | 110812 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 85046 | 85046 | 101944 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 611 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009843.1 | 2105428.6 | 37.7616611583313 | -122.40907221501699 | (37.7616611583313, -122.409072215017) | |||
| 85489 | 85489 | 117213 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620x YORK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009734.0 | 2105398.0 | 37.761571025328294 | -122.409447389709 | (37.7615710253283, -122.409447389709) | ||||
| 85783 | 85783 | 99725 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
| 88537 | 88537 | 100426 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 89587 | 89587 | 110815 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 91846 | 91846 | 116189 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1751 CARROLL AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6013485.0 | 2092424.0 | 37.72615661412179 | -122.395565112125 | (37.7261566141218, -122.395565112125) | |||
| 92520 | 92520 | 100195 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
| 93276 | 93276 | 100093 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 11X Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 93522 | 93522 | 100427 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 93898 | 93898 | 100429 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 95825 | 95825 | 113796 | Section 143 8 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 331 TERESITA BLVD | 2 | Hanging basket : Cutout 29 | Tree 1 | Private 1 | 3x3 | 5997873.0 | 2098382.0 | 37.741635103508294 | -122.44996387489401 | (37.7416351035083, -122.449963874894) | ||||
| 96013 | 96013 | 104980 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 626X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770171 | 6009833.00308 | 2105253.62946 | 37.7611801632772 | -122.409094789719 | (37.7611801632772, -122.409094789719) | |||
| 96064 | 96064 | 111890 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 176X PERALTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 25 | 3x3 | 6009847.0 | 2100071.0 | 37.7469506034955 | -122.408680755084 | (37.7469506034955, -122.408680755084) | ||
| 97899 | 97899 | 93045 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 487 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 53148 | 5998548.0 | 2106357.0 | 37.76357109086079 | -122.448204081475 | (37.7635710908608, -122.448204081475) | ||
| 98200 | 98200 | 102210 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90X Elgin Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 769653 | 6005787.0 | 2108557.3 | 37.770023769843704 | -122.42332305888901 | (37.7700237698437, -122.423323058889) | ||
| 98334 | 98334 | 98504 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1720 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006632.0 | 2116686.0 | 37.7923908555977 | -122.420977439548 | (37.7923908555977, -122.420977439548) | ||||
| 98446 | 98446 | 99934 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 63 Manchester St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768712 | 6008250.0 | 2099654.0 | 37.7457160396744 | -122.41417355851002 | (37.7457160396744, -122.41417355851) | |||
| 98719 | 98719 | 102227 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 621 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x2 | 6002457.0 | 2100031.0 | 37.746424100900995 | -122.43423182524401 | (37.746424100901, -122.434231825244) | |||
| 98894 | 98894 | 110828 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 101001 | 101001 | 117071 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 10 JOY ST | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 3x3 | 6010420.0 | 2098909.0 | 37.7437920807055 | -122.406617489968 | (37.7437920807055, -122.406617489968) | ||||
| 101529 | 101529 | 110805 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 102318 | 102318 | 100091 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 11X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 103595 | 103595 | 99722 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
| 104610 | 104610 | 110818 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 105375 | 105375 | 105675 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 667 Ivy St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771978 | 6004175.0 | 2110959.5 | 37.7765285144209 | -122.429070243114 | (37.7765285144209, -122.429070243114) | ||||
| 106989 | 106989 | 106814 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1382 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007675.9 | 2101620.4 | 37.75108306814229 | -122.416297967978 | (37.7510830681423, -122.416297967978) | ||||
| 107239 | 107239 | 110820 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
| 107418 | 107418 | 110810 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 108423 | 108423 | 99724 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
| 108809 | 108809 | 100402 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 70 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 8.5x4.5 | 6008217.0 | 2099607.0 | 37.7455851344824 | -122.414284343223 | (37.7455851344824, -122.414284343223) | |||
| 110984 | 110984 | 95158 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54076 | 6006077.0 | 2101949.0 | 37.7518952895514 | -122.421850476115 | (37.7518952895514, -122.421850476115) | |||
| 112098 | 112098 | 100401 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 91 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x4.5 | 6008260.0 | 2099484.0 | 37.7452498191594 | -122.414126954963 | (37.7452498191594, -122.414126954963) | |||
| 112099 | 112099 | 108510 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 301x LEXINGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006555.0 | 2104289.0 | 37.7583473352026 | -122.420363554061 | (37.7583473352026, -122.420363554061) | ||||
| 113308 | 113308 | 102211 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90X Elgin Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 769653 | 6005787.0 | 2108557.3 | 37.770023769843704 | -122.42332305888901 | (37.7700237698437, -122.423323058889) | ||
| 115349 | 115349 | 100186 | DPW Maintained 3 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2445 HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6008897.0 | 2104213.0 | 37.758270352242796 | -122.41225848424999 | (37.7582703522428, -122.41225848425) | |||
| 117679 | 117679 | 117480 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 117790 | 117790 | 110813 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 120201 | 120201 | 100430 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 120763 | 120763 | 117479 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 120776 | 120776 | 99721 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
| 120903 | 120903 | 108881 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
| 121490 | 121490 | 99723 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
| 121867 | 121867 | 105125 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1520 WILLARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x4 | Permit Number 771187 | 5996927.9 | 2105971.4 | 37.7624195807215 | -122.453779617781 | (37.7624195807215, -122.453779617781) | ||
| 122076 | 122076 | 115803 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 23 WOODWARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006525.0 | 2108358.0 | 37.7695181628378 | -122.420756172845 | (37.7695181628378, -122.420756172845) | ||||
| 123511 | 123511 | 110811 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 123555 | 123555 | 110806 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 123569 | 123569 | 108880 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301X JESSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
| 123913 | 123913 | 117212 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620x YORK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009734.0 | 2105398.0 | 37.761571025328294 | -122.409447389709 | (37.7615710253283, -122.409447389709) | |||
| 123998 | 123998 | 102756 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2807 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002069.0 | 2117756.0 | 37.7950705311236 | -122.436842144361 | (37.7950705311236, -122.436842144361) | |||
| 125600 | 125600 | 99742 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 511 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001875.0 | 2100872.0 | 37.7487002375378 | -122.436304489265 | (37.7487002375378, -122.436304489265) | ||||
| 126566 | 126566 | 108882 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
| 127042 | 127042 | 100193 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
| 127476 | 127476 | 98989 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1491 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11313 | 5993631.9 | 2105378.7 | 37.7606026656916 | -122.46513612094601 | (37.7606026656916, -122.465136120946) | |||
| 128042 | 128042 | 117483 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 128476 | 128476 | 100894 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1400 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008828.0 | 2109520.0 | 37.7728382767515 | -122.412872323828 | (37.7728382767515, -122.412872323828) | |||
| 128954 | 128954 | 108884 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
| 129057 | 129057 | 101170 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 420 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769436 | 6002934.0 | 2105795.0 | 37.7622777366985 | -122.432994152167 | (37.7622777366985, -122.432994152167) | |||
| 129346 | 129346 | 110822 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
| 139654 | 139654 | 116183 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1751 CARROLL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013485.0 | 2092424.0 | 37.72615661412179 | -122.395565112125 | (37.7261566141218, -122.395565112125) | |||
| 139778 | 139778 | 108879 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301X JESSIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
| 140623 | 140623 | 117481 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 143480 | 143480 | 117482 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 144722 | 144722 | 110814 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
| 80562 | 80562 | 102202 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 408 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769776 | 5999992.4 | 2106715.5 | 37.764637910001 | -122.443234124093 | (37.764637910001, -122.443234124093) |
| 104177 | 104177 | 102203 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 408 Roosevelt Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769776 | 5999992.4 | 2106715.5 | 37.764637910001 | -122.443234124093 | (37.764637910001, -122.443234124093) |
| 126101 | 126101 | 83665 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 40 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769772 | 6002625.0 | 2105668.0 | 37.761911493648 | -122.434053786903 | (37.761911493648, -122.434053786903) |
| 86404 | 86404 | 102204 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 42 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/03/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769777 | 5999985.2 | 2107061.7 | 37.7655880783734 | -122.443283894556 | (37.7655880783734, -122.443283894556) |
| 129151 | 129151 | 108927 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1612 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773055 | 6010381.6 | 2100196.5 | 37.7473251266072 | -122.406840990737 | (37.7473251266072, -122.406840990737) |
| 98618 | 98618 | 95141 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 260 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 2.5x2.5 | Permit Number 54074 | 6004098.9 | 2107250.7 | 37.766340745373604 | -122.42906899666299 | (37.7663407453736, -122.429068996663) | ||
| 111723 | 111723 | 95140 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 260 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 2x2.5 | Permit Number 54074 | 6004098.9 | 2107250.7 | 37.766340745373604 | -122.42906899666299 | (37.7663407453736, -122.429068996663) | ||
| 114551 | 114551 | 95142 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1020 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3 | 3x3 | Permit Number 54075 | 6006837.0 | 2114321.0 | 37.7859087030895 | -122.420100217722 | (37.7859087030895, -122.420100217722) | |
| 122838 | 122838 | 57178 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 219 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3x3 | Permit Number 54073 | 6000772.77457474 | 2106496.84625241 | 37.764082008440596 | -122.440519339477 | (37.7640820084406, -122.440519339477) | ||
| 128428 | 128428 | 95139 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 217 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3x3 | Permit Number 54073 | 6000763.0 | 2106514.0 | 37.764128551802 | -122.440554377209 | (37.764128551802, -122.440554377209) | ||
| 139398 | 139398 | 108932 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 418 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772806 | 6007857.4 | 2096898.0 | 37.738126614046294 | -122.415336047656 | (37.7381266140463, -122.415336047656) |
| 125446 | 125446 | 102046 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2853 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 1x1 | Permit Number 769645 | 5999908.6 | 2117385.9 | 37.7939313129836 | -122.444290820426 | (37.7939313129836, -122.444290820426) | ||
| 128836 | 128836 | 50699 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 315 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2004 12:00:00 AM | 12 | 6x8 | Permit Number 47261 | 6006595.62338541 | 2097346.13779241 | 37.7392861034365 | -122.419730437543 | (37.7392861034365, -122.419730437543) | |
| 125016 | 125016 | 55962 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 231-235 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2013 12:00:00 AM | Permit Number 769518 | 6006188.56935661 | 2101819.0911912 | 37.7515448810816 | -122.421455427946 | (37.7515448810816, -122.421455427946) | |||
| 82633 | 82633 | 109310 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772820 | 6006724.0 | 2099085.0 | 37.7440678610189 | -122.41940989424101 | (37.7440678610189, -122.419409894241) |
| 82587 | 82587 | 50396 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 62 Springfield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2006 12:00:00 AM | Permit Number 47047 | 5986810.92291605 | 2095425.7307643 | 37.7328787927022 | -122.48799514007798 | (37.7328787927022, -122.487995140078) | ||
| 124891 | 124891 | 95396 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 913 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767270 | 6003139.0 | 2102931.0 | 37.7544255036425 | -122.432080605043 | (37.7544255036425, -122.432080605043) | |
| 104577 | 104577 | 115767 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 910 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 768750 | 6001869.2 | 2101401.0 | 37.7501524163175 | -122.436362400387 | (37.7501524163175, -122.436362400387) | ||
| 104624 | 104624 | 115872 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 211 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2016 12:00:00 AM | 3 | Permit Number 771795 | 5996543.2 | 2105806.0 | 37.7619433716087 | -122.455098192614 | (37.7619433716087, -122.455098192614) | ||
| 139739 | 139739 | 95561 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 835 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767355 | 6001294.0 | 2101527.0 | 37.7504656822521 | -122.43836049802401 | (37.7504656822521, -122.438360498024) | |
| 145852 | 145852 | 95542 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 537 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767329 | 6002431.0 | 2099434.0 | 37.7447834031825 | -122.43427905661301 | (37.7447834031825, -122.434279056613) | |
| 116374 | 116374 | 95641 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 4444 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767410 | 6001257.0 | 2105261.0 | 37.7607162386451 | -122.438755985042 | (37.7607162386451, -122.438755985042) | |
| 113596 | 113596 | 50935 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2140 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767415 | 5991665.93715326 | 2100855.12914226 | 37.7480685606743 | -122.471605782529 | (37.7480685606743, -122.471605782529) | |
| 105180 | 105180 | 95781 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1864 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2011 12:00:00 AM | Permit Number 58773 | 5993804.7 | 2102837.8 | 37.7536359736806 | -122.46435400663401 | (37.7536359736806, -122.464354006634) |
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");