269 rows where qSpecies_id = 163 sorted by PermitNotes descending

View and edit SQL

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)
12967 212358 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2550 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2020 12:00:00 AM 3 Width 3ft Permit Number 785254 5991428.90703 2098042.93626 37.7403332861562 -122.47222045343 (37.7403332861562, -122.47222045343) 1 8 4 29491 40
7929 212670 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 215 Garfield St 1 : Tree Private 2   04/09/2020 12:00:00 AM 3 Width 3ft Permit Number 785243 5993431.79105 2090458.25949 37.7196233401385 -122.464744686025 (37.7196233401385, -122.464744686025) 9 8 6 64 24
55143 135739 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1900 Lyon St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2018 12:00:00 AM 3 Width 3ft Permit Number 778152 5999498.18742 2115472.92219 37.7886553562023 -122.445573257023 (37.7886553562023, -122.445573257023) 13 6 1 29490 27
57403 135745 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1902 Lyon St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2018 12:00:00 AM 3 Width 3ft Permit Number 778152 5999490.88519 2115530.47859 37.788812974099 -122.445602662133 (37.788812974099, -122.445602662133) 13 6 1 29490 27
104291 135740 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1900 Lyon St 7 Sidewalk: Property side : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 Width 3ft Permit Number 778152 5999505.99761 2115475.33585 37.7886624293634 -122.445546408651 (37.7886624293634, -122.445546408651) 13 6 1 29490 27
179825 111997 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 69 Divisadero St   Sidewalk: Curb side : Cutout Tree 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
142784 113254 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 178 Edgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM     Permit Number 774289 5996632.6 2106029.8 37.7625629978497 -122.454805165139 (37.7625629978497, -122.454805165139) 15 5 11 29492 12
167248 108531 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 60 Lurline St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773683 5991872.43029 2105034.56834 37.7595561547996 -122.471196197736 (37.7595561547996, -122.471196197736) 1 8 4 56 12
179081 108527 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1685 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
94341 107079 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 92 Homestead St   Sidewalk: Curb side : Cutout Tree 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
30096 107377 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2828X 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529 2105470 37.7617572325215 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
114106 107374 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2828X 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529 2105470 37.7617572325215 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
124121 107378 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2828X 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529 2105470 37.7617572325215 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
142391 107379 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2828X 18th St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529 2105470 37.7617572325215 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
151967 107375 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2828X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529 2105470 37.7617572325215 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
156268 107376 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2828X 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2014 12:00:00 AM   3X3 Permit Number 773434 6009529 2105470 37.7617572325215 -122.410161487216 (37.7617572325215, -122.410161487216) 8 4 7 28859 19
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
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
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
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
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
116205 115872 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 211 Edgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/29/2016 12:00:00 AM 3   Permit Number 771795 5996543.2 2105806 37.7619433716087 -122.455098192614 (37.7619433716087, -122.455098192614) 15 5 11 29492 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
159286 236813 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 207 Carl St 1 Sidewalk: Curb side : Cutout Tree 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
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
51221 104533 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 277 32nd Ave 2 Sidewalk: Curb side : Cutout Tree 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
156025 61149 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 639 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2013 12:00:00 AM     Permit Number 770286 6009856.18087269 2105304.12445974 37.7613201095027 -122.409018190245 (37.7613201095027, -122.409018190245) 2 4 8 28859 19
129498 32111 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 230 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1995 12:00:00 AM     Permit Number 770196 6003513.5729425 2106915.66682873 37.7653876747993 -122.431069617721 (37.7653876747993, -122.431069617721) 15 4 5 28862 3
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
150474 102995 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 533 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2013 12:00:00 AM 12 3x3 Permit Number 770096 6002456 2099436 37.7447903136679 -122.434192754421 (37.7447903136679, -122.434192754421) 2 7 5 63 22
175638 102996 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 533 28th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2013 12:00:00 AM   3x3 Permit Number 770096 6002456 2099436 37.7447903136679 -122.434192754421 (37.7447903136679, -122.434192754421) 2 7 5 63 22
174592 34294 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2868 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2013 12:00:00 AM     Permit Number 769996 6010202.37211243 2101668.36098933 37.7513565026505 -122.407564507802 (37.7513565026505, -122.407564507802) 2 4 7 28859 19
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
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
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
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
122390 31079 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90X Elgin Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/04/2016 12:00:00 AM 4 3x3 Permit Number 769653 6005829.36591877 2108508.00080397 37.769890796995 -122.423173010857 (37.769890796995, -122.423173010857) 8 4 5 28853 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
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
153495 102228 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 621 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2013 12:00:00 AM 10 2x2 Permit Number 769631 6002457 2100031 37.746424100901 -122.434231825244 (37.746424100901, -122.434231825244) 2 7 5 63 22
176818 101644 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 49 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2012 12:00:00 AM 10 3x3 Permit Number 769556 6002658 2105616 37.761770587011 -122.433935935928 (37.761770587011, -122.433935935928) 15 4 5 28862 3
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
105183 101945 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 611 York St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM 10 3x3 Permit Number 769515 6009843.1 2105428.6 37.7616611583313 -122.409072215017 (37.7616611583313, -122.409072215017) 2 4 8 28859 19
138090 102103 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 705X Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/19/2012 12:00:00 AM   3x3 Permit Number 769483 6009386 2110546 37.7756867379095 -122.411014612047 (37.7756867379095, -122.411014612047) 8 2 9 28853 34
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
129970 63832 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 331 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2012 12:00:00 AM     Permit Number 769403 6008107.39821454 2097107.9451309 37.7387171249892 -122.414486527778 (37.7387171249892, -122.414486527778) 2 7 7 28859 2
104132 81777 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1028-1030 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/06/2012 12:00:00 AM 5 3x3 Permit Number 768981 6006794.60823814 2114319.27887682 37.7859015887371 -122.420246759613 (37.7859015887371, -122.420246759613) 13 9 9 28858 36
152098 99932 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 277 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2012 12:00:00 AM   3x3 Permit Number 768952 6006756.8 2104530.9 37.7590229060886 -122.419682802567 (37.7590229060886, -122.419682802567) 2 4 7 28859 19
132217 115767 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 910 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 768750 6001869.2 2101401 37.7501524163175 -122.436362400387 (37.7501524163175, -122.436362400387) 2 4 5 28862 22
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
157784 106552 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 207 Los Palmos Dr   Sidewalk: Curb side : Cutout Tree Private 2   05/08/2014 12:00:00 AM   3X3 Permit Number 768265 5998005.6 2096224.8 37.7357195377121 -122.449350002926 (37.7357195377121, -122.449350002926) 9 7 4 59 40
67900 54092 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 130 San Rafael Way 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2011 12:00:00 AM     Permit Number 768262 5991854.42006361 2095289.1308882 37.7327966487645 -122.47054869605 (37.7327966487645, -122.47054869605) 9 8 4 59 40
136591 97422 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 130 San Rafael Way 2 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2011 12:00:00 AM   2x2 Permit Number 768262 5991847.6 2095285.1 37.7327851865934 -122.470571981031 (37.7327851865934, -122.470571981031) 9 8 4 59 40
93592 72891 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 143 Valdez Ave 1 Sidewalk: Property side : Yard Tree Private 2   09/01/2011 12:00:00 AM     Permit Number 768196 5996238.58765499 2094412.40177524 37.7306418958229 -122.455328273496 (37.7306418958229, -122.455328273496) 9 7 4 28861 40
156962 72691 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 143 Valdez Ave 1 Sidewalk: Property side : Yard Tree Private 2   09/01/2011 12:00:00 AM     Permit Number 768196 5996238.58765499 2094412.40177524 37.7306418958229 -122.455328273496 (37.7306418958229, -122.455328273496) 9 7 4 28861 40
26260 54080 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 412 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2011 12:00:00 AM   3x3 Permit Number 768002 6002927.97599078 2105840.12301402 37.7624012918991 -122.433018210909 (37.7624012918991, -122.433018210909) 15 4 5 28862 3
26127 96724 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1357 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   07/06/2011 12:00:00 AM     Permit Number 767997 6009298 2101259 37.7501818243182 -122.410663037771 (37.7501818243182, -122.410663037771) 2 4 7 28859 19
46167 96164 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 42 Putnam St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767796 6009164 2097229 37.7391088173015 -122.41084183089 (37.7391088173015, -122.41084183089) 10 7 7 28859 2
46178 96165 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 42 Putnam St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767796 6009164 2097229 37.7391088173015 -122.41084183089 (37.7391088173015, -122.41084183089) 10 7 7 28859 2
64987 96056 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1532 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767684 6009571 2100485 37.7480718940124 -122.409664358821 (37.7480718940124, -122.409664358821) 2 7 7 28859 2
80458 82941 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 705X Tehama St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM   3x3 Permit Number 767578 6009380.46605511 2110537.73170402 37.7756637247842 -122.411033171265 (37.7756637247842, -122.411033171265) 8 2 9 28853 34
67324 95732 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 483 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767479 6003045.8 2090902.6 37.7213929950365 -122.43154424747 (37.7213929950365, -122.43154424747) 9 7 6 28861 5
149826 50935 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2140 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/07/2011 12:00:00 AM   3x3 Permit Number 767415 5991665.93715326 2100855.12914226 37.7480685606743 -122.471605782529 (37.7480685606743, -122.471605782529) 1 8 4 29491 40
148252 95641 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 4444 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767410 6001257 2105261 37.7607162386451 -122.438755985042 (37.7607162386451, -122.438755985042) 15 4 5 28862 3
172016 95561 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 835 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767355 6001294 2101527 37.7504656822521 -122.438360498024 (37.7504656822521, -122.438360498024) 2 4 5 28862 22
191331 95542 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 537 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2011 12:00:00 AM   3x3 Permit Number 767329 6002431 2099434 37.7447834031825 -122.434279056613 (37.7447834031825, -122.434279056613) 2 7 5 63 22
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
101111 75018 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 25 Elgin Park 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1997 12:00:00 AM   3x3 Permit Number 767139 6005836.8050618 2108949.68605393 37.7711039786835 -122.423178679412 (37.7711039786835, -122.423178679412) 8 2 5 28853 19
127373 95781 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1864 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2011 12:00:00 AM     Permit Number 58773 5993804.7 2102837.8 37.7536359736806 -122.464354006634 (37.7536359736806, -122.464354006634) 1 8 4 56 12
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
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
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
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
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
88307 53711 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 4332 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2010 12:00:00 AM   4x4 Permit Number 54013 6001635.45830725 2104703.42170206 37.7592067876859 -122.437407142233 (37.7592067876859, -122.437407142233) 2 4 5 28862 3
188588 78046 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 4278 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/2010 12:00:00 AM   3x3 Permit Number 53968 6002070.11098959 2101218.55986767 37.749662892833 -122.435654588507 (37.749662892833, -122.435654588507) 2 4 5 28862 22
189078 56773 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1590X McKinnon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53948 6015510.6381706 2096034.20336208 37.736181973612 -122.388814458679 (37.736181973612, -122.388814458679) 10 3 8 58 1
87121 94872 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3229 Jennings St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53942 6013605 2090171 37.7199770026118 -122.394992544907 (37.7199770026118, -122.394992544907) 10 3 8 58 1
141247 94873 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3229 Jennings St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53942 6013605 2090171 37.7199770026118 -122.394992544907 (37.7199770026118, -122.394992544907) 10 3 8 58 1
41665 94824 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1391 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53904 5990789.3 2105954.6 37.762019606095 -122.475009322669 (37.762019606095, -122.475009322669) 1 8 3 56 12
34153 94576 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3775 21st St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53754 6003162 2103575 37.7561950785204 -122.432047050117 (37.7561950785204, -122.432047050117) 2 4 5 28862 22
183587 55046 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3775 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/12/1972 12:00:00 AM   3x3 Permit Number 53754 6003208.53256552 2103569.18124739 37.7561817396096 -122.431885709289 (37.7561817396096, -122.431885709289) 2 4 5 28862 22
93383 42709 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1600 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM   3x3 Permit Number 53744 6005315.92998199 2118904.40480493 37.7984077601464 -122.42568904485 (37.7984077601464, -122.42568904485) 13 9 1 57 17
98326 42707 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1600 Union St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM   3x3 Permit Number 53744 6005315.92998199 2118904.40480493 37.7984077601464 -122.42568904485 (37.7984077601464, -122.42568904485) 13 9 1 57 17
121504 42711 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1600 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM   3x3 Permit Number 53744 6005315.92998199 2118904.40480493 37.7984077601464 -122.42568904485 (37.7984077601464, -122.42568904485) 13 9 1 57 17
105620 49398 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 226@ DANVERS Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2010 12:00:00 AM   3x3 Permit Number 53717 5999940.69424532 2104865.65120183 37.7595557350724 -122.443280084978 (37.7595557350724, -122.443280084978) 2 4 5 28862 3
108345 94534 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1545@ Post St Divisadero St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2010 12:00:00 AM     Permit Number 53714 6001163 2113666 37.7837889169409 -122.439683671841 (37.7837889169409, -122.439683671841) 15 6 11 29490 13
126678 94533 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1545@ Post St Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2010 12:00:00 AM     Permit Number 53714 6001163 2113666 37.7837889169409 -122.439683671841 (37.7837889169409, -122.439683671841) 15 6 11 29490 13
102318 94510 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2531 28th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/25/2010 12:00:00 AM   3x3 Permit Number 53695 5987646.3 2098052 37.7401385375939 -122.485299705684 (37.7401385375939, -122.485299705684) 1 8 3 29491 35
83893 37154 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 175 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2010 12:00:00 AM   3x3 Permit Number 53678 6005395.05541488 2100179.52375956 37.7469982334442 -122.424082914114 (37.7469982334442, -122.424082914114) 2 7 5 28859 22
9592 94429 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 11 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1
37056 94424 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 13 Sidewalk: Property side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1
75306 94427 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1
103600 94426 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1
137841 94421 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 6 Sidewalk: Property side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1
145415 94430 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 14 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1
154038 94428 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1
166675 94425 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 5800 03rd St 15 Sidewalk: Property side : Cutout Tree Private 2   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849 2092184 37.7255178628117 -122.394289979276 (37.7255178628117, -122.394289979276) 10 3 8 58 1

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