home / trees

Street_Tree_List

Data source: data.sfgov.org

267 rows where qSpecies = 30

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
96 100091 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 11X Shotwell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
98 100093 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 11X Shotwell St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
187 100186 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2445 HARRISON ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3x3   6008897.0 2104213.0 37.758270352242796 -122.41225848424999 (37.7582703522428, -122.41225848425) 2 4 7 28859 19
195 100193 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
196 100194 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 2 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
197 100195 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 3 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
372 100401 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 91 Manchester St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 6x4.5   6008260.0 2099484.0 37.7452498191594 -122.414126954963 (37.7452498191594, -122.414126954963) 2 7 7 28859 2
373 100402 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 70 Manchester St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 8.5x4.5   6008217.0 2099607.0 37.7455851344824 -122.414284343223 (37.7455851344824, -122.414284343223) 2 7 7 28859 2
393 100426 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 200X Stonecrest Dr 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
394 100427 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 200X Stonecrest Dr 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
395 100428 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 200X Stonecrest Dr 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
396 100429 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 200X Stonecrest Dr 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
398 100430 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 200X Stonecrest Dr 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
794 100894 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1400 15th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 3x3   6008828.0 2109520.0 37.7728382767515 -122.412872323828 (37.7728382767515, -122.412872323828) 8 2 9 28853 34
1019 101170 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 420 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769436 6002934.0 2105795.0 37.7622777366985 -122.432994152167 (37.7622777366985, -122.432994152167) 15 4 5 28862 3
1456 101644 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 49 Hartford St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/10/2012 12:00:00 AM 10 3x3 Permit Number 769556 6002658.0 2105616.0 37.761770587011 -122.433935935928 (37.761770587011, -122.433935935928) 15 4 5 28862 3
1665 101944 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 611 York St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6009843.1 2105428.6 37.7616611583313 -122.40907221501699 (37.7616611583313, -122.409072215017) 2 4 8 28859 19
1666 101945 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 611 York St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/07/2012 12:00:00 AM 10 3x3 Permit Number 769515 6009843.1 2105428.6 37.7616611583313 -122.40907221501699 (37.7616611583313, -122.409072215017) 2 4 8 28859 19
1767 102046 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2853 Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/15/2013 12:00:00 AM   1x1 Permit Number 769645 5999908.6 2117385.9 37.7939313129836 -122.444290820426 (37.7939313129836, -122.444290820426) 13 9 1 57 27
1821 102103 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 705X Tehama St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/19/2012 12:00:00 AM   3x3 Permit Number 769483 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047) 8 2 9 28853 34
1915 102202 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 408 Roosevelt Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769776 5999992.4 2106715.5 37.764637910001 -122.443234124093 (37.764637910001, -122.443234124093) 15 5 5 29492 3
1916 102203 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 408 Roosevelt Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769776 5999992.4 2106715.5 37.764637910001 -122.443234124093 (37.764637910001, -122.443234124093) 15 5 5 29492 3
1917 102204 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 42 Upper Ter 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/03/2013 12:00:00 AM 3 3x3 Permit Number 769777 5999985.2 2107061.7 37.7655880783734 -122.443283894556 (37.7655880783734, -122.443283894556) 15 5 5 29492 9
1924 102210 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 90X Elgin Park 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3 Permit Number 769653 6005787.0 2108557.3 37.770023769843704 -122.42332305888901 (37.7700237698437, -122.423323058889) 8 2 5 28853 19
1925 102211 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 90X Elgin Park 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3 Permit Number 769653 6005787.0 2108557.3 37.770023769843704 -122.42332305888901 (37.7700237698437, -122.423323058889) 8 2 5 28853 19
1942 102227 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 621 27th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 2x2   6002457.0 2100031.0 37.746424100900995 -122.43423182524401 (37.746424100901, -122.434231825244) 2 7 5 63 22
1943 102228 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 621 27th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/25/2013 12:00:00 AM 10 2x2 Permit Number 769631 6002457.0 2100031.0 37.746424100900995 -122.43423182524401 (37.746424100901, -122.434231825244) 2 7 5 63 22
2442 102756 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2807 Steiner St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6002069.0 2117756.0 37.7950705311236 -122.436842144361 (37.7950705311236, -122.436842144361) 13 9 1 57 27
2663 102995 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 533 28th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/06/2013 12:00:00 AM 12 3x3 Permit Number 770096 6002456.0 2099436.0 37.7447903136679 -122.434192754421 (37.7447903136679, -122.434192754421) 2 7 5 63 22
2664 102996 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 533 28th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/06/2013 12:00:00 AM   3x3 Permit Number 770096 6002456.0 2099436.0 37.7447903136679 -122.434192754421 (37.7447903136679, -122.434192754421) 2 7 5 63 22
4028 104533 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 277 32nd Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/16/2013 12:00:00 AM     Permit Number 770674 5985841.1 2114065.7 37.7840023776023 -122.492720403083 (37.7840023776023, -122.492720403083) 11 6 1 55 33
4438 104980 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 626X York St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 770171 6009833.00308 2105253.62946 37.7611801632772 -122.409094789719 (37.7611801632772, -122.409094789719) 2 4 8 28859 19
4497 105048 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 205 Carl St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3X3 Permit Number 771190 5997152.5 2107007.0 37.765275948780605 -122.453077573625 (37.7652759487806, -122.453077573625) 15 5 11 29492 12
4549 105125 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1520 WILLARD ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 2x4 Permit Number 771187 5996927.9 2105971.4 37.7624195807215 -122.453779617781 (37.7624195807215, -122.453779617781) 15 5 11 29492 12
5020 105675 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 667 Ivy St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 771978 6004175.0 2110959.5 37.7765285144209 -122.429070243114 (37.7765285144209, -122.429070243114) 7 9 11 28852 10
5720 106552 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 207 Los Palmos Dr   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/08/2014 12:00:00 AM   3X3 Permit Number 768265 5998005.6 2096224.8 37.7357195377121 -122.44935000292601 (37.7357195377121, -122.449350002926) 9 7 4 59 40
5910 106814 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1382 South Van Ness Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6007675.9 2101620.4 37.75108306814229 -122.416297967978 (37.7510830681423, -122.416297967978) 2 4 7 28859 19
6136 107079 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 92 Homestead St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/25/2014 12:00:00 AM   3x3 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227) 2 4 5 28862 22
6292 107281 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 3545 24TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6005985.0 2101973.7 37.7519579213255 -122.422170380161 (37.7519579213255, -122.422170380161) 2 4 5 28859 19
6357 107374 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2828X 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529.0 2105470.0 37.761757232521504 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
6358 107375 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2828X 18th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529.0 2105470.0 37.761757232521504 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
6359 107376 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2828X 18th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529.0 2105470.0 37.761757232521504 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
6360 107377 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2828X 18th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529.0 2105470.0 37.761757232521504 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
6361 107378 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2828X 18th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529.0 2105470.0 37.761757232521504 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
6362 107379 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2828X 18th St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529.0 2105470.0 37.761757232521504 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
6780 107876 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 878 SHOTWELL ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6007933.7 2102810.7 37.754365855539206 -122.41549072804399 (37.7543658555392, -122.415490728044) 2 4 7 28859 19
7388 108510 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 301x LEXINGTON ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006555.0 2104289.0 37.7583473352026 -122.420363554061 (37.7583473352026, -122.420363554061) 2 4 7 28859 19
7406 108527 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1685 18th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773678 5990568.02917 2103933.50348 37.7564573872125 -122.47562701791 (37.7564573872125, -122.47562701791) 1 8 4 56 12
7411 108531 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 60 Lurline St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773683 5991872.4302900005 2105034.56834 37.7595561547996 -122.47119619773599 (37.7595561547996, -122.471196197736) 1 8 4 56 12
7778 108879 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1301X JESSIE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006447.0 2109024.0 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
7780 108880 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1301X JESSIE ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006447.0 2109024.0 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
7781 108881 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1301x JESSIE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006447.0 2109024.0 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
7782 108882 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1301x JESSIE ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006447.0 2109024.0 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
7784 108884 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1301x JESSIE ST 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006447.0 2109024.0 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
7829 108927 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1612 York St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773055 6010381.6 2100196.5 37.7473251266072 -122.406840990737 (37.7473251266072, -122.406840990737) 2 7 7 28859 2
7834 108932 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 418 Anderson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/12/2015 12:00:00 AM 3 3x3 Permit Number 772806 6007857.4 2096898.0 37.738126614046294 -122.415336047656 (37.7381266140463, -122.415336047656) 2 7 7 28859 2
8216 109310 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 99 Coleridge St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/10/2015 12:00:00 AM 3 3x3 Permit Number 772820 6006724.0 2099085.0 37.7440678610189 -122.41940989424101 (37.7440678610189, -122.419409894241) 2 7 7 28859 2
9404 110805 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9405 110806 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9406 110807 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9407 110808 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9410 110810 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9411 110811 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9412 110812 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9413 110813 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9414 110814 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9415 110815 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2X FREELON ST 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9418 110818 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1X WELSH ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9420 110820 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1X WELSH ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9421 110821 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1X WELSH ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9422 110822 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1X WELSH ST 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9424 110827 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1X WELSH ST 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
9425 110828 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1X WELSH ST 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6013408.0 2111682.0 37.7790306545162 -122.39718109463199 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
10372 111890 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 176X PERALTA AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   25 3x3   6009847.0 2100071.0 37.7469506034955 -122.408680755084 (37.7469506034955, -122.408680755084) 2 7 7 28859 2
10465 111997 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 69 Divisadero St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/08/2015 12:00:00 AM 3 6x3 Permit Number 775676 6001902.9 2108046.4 37.7684009894266 -122.436721500778 (37.7684009894266, -122.436721500778) 15 5 5 29492 3
11628 113254 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 178 Edgewood Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/16/2015 12:00:00 AM     Permit Number 774289 5996632.6 2106029.8 37.762562997849706 -122.454805165139 (37.7625629978497, -122.454805165139) 15 5 11 29492 12
12148 113796 Section 143 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 331 TERESITA BLVD 2 Hanging basket : Cutout 26 Tree 1 Private 2       3x3   5997873.0 2098382.0 37.741635103508294 -122.44996387489401 (37.7416351035083, -122.449963874894) 9 7 4 59 40
13986 115767 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 910 Diamond St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/24/2016 12:00:00 AM 3   Permit Number 768750 6001869.2 2101401.0 37.7501524163175 -122.436362400387 (37.7501524163175, -122.436362400387) 2 4 5 28862 22
14016 115803 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 23 WOODWARD ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006525.0 2108358.0 37.7695181628378 -122.420756172845 (37.7695181628378, -122.420756172845) 8 4 7 28853 19
14086 115872 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 211 Edgewood Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/29/2016 12:00:00 AM 3   Permit Number 771795 5996543.2 2105806.0 37.7619433716087 -122.455098192614 (37.7619433716087, -122.455098192614) 15 5 11 29492 12
14363 116183 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1751 CARROLL AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x15   6013485.0 2092424.0 37.72615661412179 -122.395565112125 (37.7261566141218, -122.395565112125) 10 3 8 58 1
14369 116189 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1751 CARROLL AVE 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6013485.0 2092424.0 37.72615661412179 -122.395565112125 (37.7261566141218, -122.395565112125) 10 3 8 58 1
15222 117071 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 10 JOY ST 1 Unaccepted Street : Cutout 24 Tree 1 Private 2       3x3   6010420.0 2098909.0 37.7437920807055 -122.406617489968 (37.7437920807055, -122.406617489968) 2 7 7 28859 2
15366 117210 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 620x YORK ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009734.0 2105398.0 37.761571025328294 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
15367 117211 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 620x YORK ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/13/2016 12:00:00 AM 3 3x3   6009734.0 2105398.0 37.761571025328294 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
15368 117212 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 620x YORK ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6009734.0 2105398.0 37.761571025328294 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
15369 117213 Undocumented 3 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 620x YORK ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009734.0 2105398.0 37.761571025328294 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
15631 117479 Planning Code 138.1 required 8 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 601 PACHECO ST 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
15633 117480 Planning Code 138.1 required 8 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 601 PACHECO ST 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
15634 117481 Planning Code 138.1 required 8 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 601 PACHECO ST 3 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
15635 117482 Planning Code 138.1 required 8 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 601 PACHECO ST 4 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
15636 117483 Planning Code 138.1 required 8 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 601 PACHECO ST 5 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
34179 135739 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1900 Lyon St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/27/2018 12:00:00 AM 3 Width 3ft Permit Number 778152 5999498.187419999 2115472.9221900003 37.7886553562023 -122.44557325702299 (37.7886553562023, -122.445573257023) 13 6 1 29490 27
34181 135740 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1900 Lyon St 7 Sidewalk: Property side : Yard 5 Tree 1 Private 2   02/27/2018 12:00:00 AM 3 Width 3ft Permit Number 778152 5999505.99761 2115475.33585 37.7886624293634 -122.44554640865101 (37.7886624293634, -122.445546408651) 13 6 1 29490 27
34186 135745 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 1902 Lyon St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/27/2018 12:00:00 AM 3 Width 3ft Permit Number 778152 5999490.88519 2115530.47859 37.788812974099 -122.44560266213301 (37.788812974099, -122.445602662133) 13 6 1 29490 27
49988 178749 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 309 Elliot St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/23/2018 12:00:00 AM 3 Width 3ft Permit Number 772136 6008837.67953 2088153.65534 37.7141715446555 -122.411329156315 (37.7141715446555, -122.411329156315) 9 7 8 309 39
108950 236813 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 207 Carl St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/13/2017 12:00:00 AM 3 Width 4ft Permit Number 771190 5997138.1422 2107019.95988 37.7653107104358 -122.453128169228 (37.7653107104358, -122.453128169228) 15 5 11 29492 12
123572 253208 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 201x Shipley St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       3x3   6011752.0 2111938.0 37.7796412414558 -122.402927910408 (37.7796412414558, -122.402927910408) 14 2 9 28856 34
125165 255547 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 221 San Carlos St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006715.0 2104806.0 37.759775912066495 -122.419846887761 (37.7597759120665, -122.419846887761) 2 4 7 28859 19
125170 255552 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 299X San Carlos St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006768.0 2104412.0 37.7586970651618 -122.419635631527 (37.7586970651618, -122.419635631527) 2 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 30.226ms · Data source: data.sfgov.org