trees

269 rows where qSpecies_id = 163 sorted by PermitNotes

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes ▼ XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
1040 94769 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
2260 94780 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 13 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
2369 117212 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 620x YORK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6009734 2105398 37.7615710253283 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
8789 110821 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 5 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
11312 110827 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 11 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
15706 110811 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
16672 108880 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1301X JESSIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006447 2109024 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
17650 255554 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 299X San Carlos St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006768 2104412 37.7586970651618 -122.419635631527 (37.7586970651618, -122.419635631527) 2 4 7 28859 19
17949 100194 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 2 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
18089 110806 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
23020 100894 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1400 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6008828 2109520 37.7728382767515 -122.412872323828 (37.7728382767515, -122.412872323828) 8 2 9 28853 34
26702 117483 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 5 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
28471 108884 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1301x JESSIE ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006447 2109024 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
28871 100193 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 1 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
29991 255552 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 299X San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006768 2104412 37.7586970651618 -122.419635631527 (37.7586970651618, -122.419635631527) 2 4 7 28859 19
33210 99742 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 511 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001875 2100872 37.7487002375378 -122.436304489265 (37.7487002375378, -122.436304489265) 2 4 5 28862 22
33387 108882 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1301x JESSIE ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006447 2109024 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
33594 110822 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 6 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
33745 100428 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Stonecrest Dr 5 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
34089 102756 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2807 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002069 2117756 37.7950705311236 -122.436842144361 (37.7950705311236, -122.436842144361) 13 9 1 57 27
43138 117210 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 620x YORK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009734 2105398 37.7615710253283 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
43383 107876 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 878 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6007933.7 2102810.7 37.7543658555392 -122.415490728044 (37.7543658555392, -122.415490728044) 2 4 7 28859 19
43502 94783 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 16 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
45078 255553 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 299X San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006768 2104412 37.7586970651618 -122.419635631527 (37.7586970651618, -122.419635631527) 2 4 7 28859 19
46177 73875 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 450X Banks St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 8 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
46317 110807 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
47556 110808 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
52008 110812 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
52285 94774 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 7 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
56136 107281 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3545 24TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005985 2101973.7 37.7519579213255 -122.422170380161 (37.7519579213255, -122.422170380161) 2 4 5 28859 19
62259 100426 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Stonecrest Dr 3 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
62638 94770 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
62879 101944 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 611 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6009843.1 2105428.6 37.7616611583313 -122.409072215017 (37.7616611583313, -122.409072215017) 2 4 8 28859 19
68729 110815 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
70574 94775 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 8 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
70901 117213 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 620x YORK ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009734 2105398 37.7615710253283 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
73246 99725 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
73550 94777 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 10 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
77101 100429 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Stonecrest Dr 7 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
77223 100093 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 11X Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
78968 111890 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 176X PERALTA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   25 3x3   6009847 2100071 37.7469506034955 -122.408680755084 (37.7469506034955, -122.408680755084) 2 7 7 28859 2
80551 100195 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 3 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
89621 100427 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Stonecrest Dr 4 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
90728 113796 Section 143 10 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 331 TERESITA BLVD 2 Hanging basket : Cutout Tree Private 2       3x3   5997873 2098382 37.7416351035083 -122.449963874894 (37.7416351035083, -122.449963874894) 9 7 4 59 40
93965 116189 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1751 CARROLL AVE 9 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6013485 2092424 37.7261566141218 -122.395565112125 (37.7261566141218, -122.395565112125) 10 3 8 58 1
94725 253208 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 201x Shipley St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011752 2111938 37.7796412414558 -122.402927910408 (37.7796412414558, -122.402927910408) 14 2 9 28856 34
97064 100091 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 11X Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
97677 99722 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
98283 94778 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 11 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
104672 110828 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
106734 110805 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
106795 102227 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 621 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 2x2   6002457 2100031 37.746424100901 -122.434231825244 (37.746424100901, -122.434231825244) 2 7 5 63 22
107173 117071 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 10 JOY ST 1 Unaccepted Street : Cutout Tree Private 2       3x3   6010420 2098909 37.7437920807055 -122.406617489968 (37.7437920807055, -122.406617489968) 2 7 7 28859 2
113938 98504 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1720 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006632 2116686 37.7923908555977 -122.420977439548 (37.7923908555977, -122.420977439548) 13 9 10 28858 21
114262 110818 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
118586 100402 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 70 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 8.5x4.5   6008217 2099607 37.7455851344824 -122.414284343223 (37.7455851344824, -122.414284343223) 2 7 7 28859 2
118753 99724 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
121380 106814 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1382 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007675.9 2101620.4 37.7510830681423 -122.416297967978 (37.7510830681423, -122.416297967978) 2 4 7 28859 19
125667 110810 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
126855 255555 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 299X San Carlos St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006768 2104412 37.7586970651618 -122.419635631527 (37.7586970651618, -122.419635631527) 2 4 7 28859 19
128930 110820 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 4 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
134277 94773 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
136222 94782 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 15 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
137121 108510 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 301x LEXINGTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006555 2104289 37.7583473352026 -122.420363554061 (37.7583473352026, -122.420363554061) 2 4 7 28859 19
137124 100186 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2445 HARRISON ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6008897 2104213 37.7582703522428 -122.41225848425 (37.7582703522428, -122.41225848425) 2 4 7 28859 19
146086 100401 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 91 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 6x4.5   6008260 2099484 37.7452498191594 -122.414126954963 (37.7452498191594, -122.414126954963) 2 7 7 28859 2
148697 94779 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 12 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
150144 94776 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
152383 94768 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
156602 115803 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 23 WOODWARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006525 2108358 37.7695181628378 -122.420756172845 (37.7695181628378, -122.420756172845) 8 4 7 28853 19
157566 108881 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1301x JESSIE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006447 2109024 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
157658 117211 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 620x YORK ST 2 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 3x3   6009734 2105398 37.7615710253283 -122.409447389709 (37.7615710253283, -122.409447389709) 2 4 8 28859 19
158224 99721 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
159993 110813 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
160718 117479 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
165760 255547 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 221 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006715 2104806 37.7597759120665 -122.419846887761 (37.7597759120665, -122.419846887761) 2 4 7 28859 19
166329 117480 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
166587 99723 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
169022 100430 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Stonecrest Dr 6 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
180031 110814 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2X FREELON ST 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
181944 94771 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
182195 116183 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1751 CARROLL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x15   6013485 2092424 37.7261566141218 -122.395565112125 (37.7261566141218, -122.395565112125) 10 3 8 58 1
184106 94772 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
184372 117482 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 4 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
186143 108879 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1301X JESSIE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006447 2109024 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
186736 94781 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 14 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
187328 117481 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 3 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
192893 78536 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 62 Colby St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/08/2019 08:00:00 AM 3     6007979.64148 2093805.90285 37.7296432572303 -122.414694635261 (37.7296432572303, -122.414694635261) 9 3 7 309 28
52560 98446 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1117 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Looks like it was planted at same time as tree no. 1 which permit was issued for. 6009758 2111239 37.7776104068373 -122.409776693812 (37.7776104068373, -122.409776693812) 8 2 9 28853 34
38093 98989 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1491 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 11313 5993631.9 2105378.7 37.7606026656916 -122.465136120946 (37.7606026656916, -122.465136120946) 1 8 11 56 12
132024 55376 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1491 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1972 12:00:00 AM   3x3 Permit Number 11313 5993646.25927439 2105360.40659062 37.760553264764 -122.465085130446 (37.760553264764, -122.465085130446) 1 8 11 56 12
118748 57465 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1439 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1976 12:00:00 AM 20 3x3 Permit Number 16313 5994563.72083648 2105730.98306422 37.7616236328643 -122.461938945528 (37.7616236328643, -122.461938945528) 1 5 11 56 12
179413 66648 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 952 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1991 12:00:00 AM     Permit Number 29859 6009925.98754531 2103657.07059122 37.7568015810734 -122.408660561624 (37.7568015810734, -122.408660561624) 2 4 7 28859 19
183634 31078 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90X Elgin Park 2 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM 4 3x3 Permit Number 34817 6005829.36591877 2108508.00080397 37.769890796995 -122.423173010857 (37.769890796995, -122.423173010857) 8 4 5 28853 19
93926 42591 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 121 Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42664 5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
117128 43407 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 458 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43150 6002175.1657372 2101516.64467827 37.7504873295285 -122.435312625256 (37.7504873295285, -122.435312625256) 2 4 5 28862 22
154338 44787 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 620 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM     Permit Number 43883 6010080.44912755 2105396.9401007 37.7615875207802 -122.408249083688 (37.7615875207802, -122.408249083688) 2 4 8 28859 19
14752 45033 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3310 19TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM 2 3x3 Permit Number 43923 6007454.2 2105037.1 37.7604520749855 -122.417306729583 (37.7604520749855, -122.417306729583) 2 4 7 28859 19
87327 45030 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3310 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM 2 3x3 Permit Number 43923 6007466.67182557 2105026.73123369 37.7604243064239 -122.4172628604 (37.7604243064239, -122.4172628604) 2 4 7 28859 19
4205 45183 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90 Montcalm St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/2001 12:00:00 AM     Permit Number 44029 6010481.84262238 2099977.43671259 37.7467292351784 -122.406478923454 (37.7467292351784, -122.406478923454) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);