trees

269 rows where qSpecies_id = 163 sorted by PlantDate

✎ 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)
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
27811 101170 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 420 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769436 6002934 2105795 37.7622777366985 -122.432994152167 (37.7622777366985, -122.432994152167) 15 4 5 28862 3
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
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
38867 105048 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 205 Carl St   Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 771190 5997152.5 2107007 37.7652759487806 -122.453077573625 (37.7652759487806, -122.453077573625) 15 5 11 29492 12
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
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
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
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
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
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
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
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
78265 104980 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 626X York St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770171 6009833.00308 2105253.62946 37.7611801632772 -122.409094789719 (37.7611801632772, -122.409094789719) 2 4 8 28859 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
97025 99934 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 63 Manchester St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768712 6008250 2099654 37.7457160396744 -122.41417355851 (37.7457160396744, -122.41417355851) 2 7 7 28859 2
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
100682 93045 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 487 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 53148 5998548 2106357 37.7635710908608 -122.448204081475 (37.7635710908608, -122.448204081475) 15 5 11 29492 9
102628 102210 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90X Elgin Park 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3 Permit Number 769653 6005787 2108557.3 37.7700237698437 -122.423323058889 (37.7700237698437, -122.423323058889) 8 2 5 28853 19
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
115020 105675 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 667 Ivy St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 771978 6004175 2110959.5 37.7765285144209 -122.429070243114 (37.7765285144209, -122.429070243114) 7 9 11 28852 10
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
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
140710 95158 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200 San Jose Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 54076 6006077 2101949 37.7518952895514 -122.421850476115 (37.7518952895514, -122.421850476115) 2 4 5 28859 19
142876 102211 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90X Elgin Park 4 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3 Permit Number 769653 6005787 2108557.3 37.7700237698437 -122.423323058889 (37.7700237698437, -122.423323058889) 8 2 5 28853 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
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
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
159571 105125 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1520 WILLARD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 2x4 Permit Number 771187 5996927.9 2105971.4 37.7624195807215 -122.453779617781 (37.7624195807215, -122.453779617781) 15 5 11 29492 12
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
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
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
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
32157 83665 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 40 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2013 12:00:00 AM 4 3x3 Permit Number 769772 6002625 2105668 37.761911493648 -122.434053786903 (37.761911493648, -122.434053786903) 15 4 5 28862 3
48386 102202 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 408 Roosevelt Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
127767 102203 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 408 Roosevelt Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
60865 102204 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 42 Upper Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
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
23496 108927 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1612 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
35591 95139 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 217 States St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2011 12:00:00 AM   3x3 Permit Number 54073 6000763 2106514 37.764128551802 -122.440554377209 (37.764128551802, -122.440554377209) 15 5 5 28862 3
107850 95141 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 260 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2011 12:00:00 AM   2.5x2.5 Permit Number 54074 6004098.9 2107250.7 37.7663407453736 -122.429068996663 (37.7663407453736, -122.429068996663) 8 4 5 28862 3
137715 95140 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 260 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2011 12:00:00 AM   2x2.5 Permit Number 54074 6004098.9 2107250.7 37.7663407453736 -122.429068996663 (37.7663407453736, -122.429068996663) 8 4 5 28862 3
148855 95142 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1020 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2011 12:00:00 AM 3 3x3 Permit Number 54075 6006837 2114321 37.7859087030895 -122.420100217722 (37.7859087030895, -122.420100217722) 13 9 9 28858 36
167646 57178 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 219 States St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2011 12:00:00 AM   3x3 Permit Number 54073 6000772.77457474 2106496.84625241 37.7640820084406 -122.440519339477 (37.7640820084406, -122.440519339477) 15 5 5 28862 3
182631 108932 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 418 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2015 12:00:00 AM 3 3x3 Permit Number 772806 6007857.4 2096898 37.7381266140463 -122.415336047656 (37.7381266140463, -122.415336047656) 2 7 7 28859 2
30427 102046 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2853 Vallejo St 2 Sidewalk: Curb side : Cutout Tree 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
33547 50699 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 315 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2004 12:00:00 AM 12 6x8 Permit Number 47261 6006595.62338541 2097346.13779241 37.7392861034365 -122.419730437543 (37.7392861034365, -122.419730437543) 2 7 7 28859 2
33256 55962 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 231-235 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2013 12:00:00 AM     Permit Number 769518 6006188.56935661 2101819.0911912 37.7515448810816 -122.421455427946 (37.7515448810816, -122.421455427946) 2 4 5 28859 19
43166 109310 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 99 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/2015 12:00:00 AM 3 3x3 Permit Number 772820 6006724 2099085 37.7440678610189 -122.419409894241 (37.7440678610189, -122.419409894241) 2 7 7 28859 2
56456 50396 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 62 Springfield Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/18/2006 12:00:00 AM     Permit Number 47047 5986810.92291605 2095425.7307643 37.7328787927022 -122.487995140078 (37.7328787927022, -122.487995140078) 1 8 4 64 35
60179 178749 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 309 Elliot St 1 Sidewalk: Curb side : Cutout Tree 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
37648 95396 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 913 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767270 6003139 2102931 37.7544255036425 -122.432080605043 (37.7544255036425, -122.432080605043) 2 4 5 28862 22

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)
);