trees

269 rows where qSpecies_id = 163

✎ 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
2793 93002 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 10 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2008 12:00:00 AM   3x3 Permit Number 50388 6006066 2108133 37.7688744854504 -122.42232784963 (37.7688744854504, -122.42232784963) 8 4 5 28853 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
5091 84428 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3376 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50585 6007059.6670395 2105004.14927822 37.7603393951154 -122.418668903501 (37.7603393951154, -122.418668903501) 2 4 7 28859 19
5724 87766 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3896 22nd St   Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50469 6002488 2102987 37.7545423364482 -122.434335932006 (37.7545423364482, -122.434335932006) 2 4 5 28862 22
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
8675 87809 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3388 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50586 6005908.6 2098553.3 37.7425619734414 -122.422191602046 (37.7425619734414, -122.422191602046) 2 7 7 28859 2
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
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
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
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
14037 92146 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 728 Jamestown Ave 3 Sidewalk: Property side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52458 6015302.1 2088427.9 37.7152850141922 -122.389004565667 (37.7152850141922, -122.389004565667) 10 3 8 58 1
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
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
15748 83385 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1743 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53553 5992776.43619882 2103602.82847895 37.7556772189572 -122.467965581747 (37.7556772189572, -122.467965581747) 1 8 4 56 12
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
19397 47958 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 300 Los Palmos Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45688 5997800.77741149 2096297.42452827 37.7359072289386 -122.450063383576 (37.7359072289386, -122.450063383576) 9 7 4 59 40
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
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
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
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
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
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
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
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
33029 47908 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1394on Pierce McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52419 6002488.12877118 2111638.62757639 37.7782975970335 -122.434954188456 (37.7782975970335, -122.434954188456) 15 5 11 29490 41
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
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
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
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
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
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
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
35883 50501 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 731 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM     Permit Number 47137 6002346.93991516 2089394.75729347 37.7172131586139 -122.43385228912 (37.7172131586139, -122.43385228912) 9 7 6 28861 5
36235 36738 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2008 12:00:00 AM   3x3 Permit Number 50388 6006056.66890888 2108134.46852817 37.7688779913212 -122.422360229632 (37.7688779913212, -122.422360229632) 8 4 5 28853 19
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
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
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
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
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
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
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
43812 36734 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2008 12:00:00 AM   3x3 Permit Number 50388 6006056.66890888 2108134.46852817 37.7688779913212 -122.422360229632 (37.7688779913212, -122.422360229632) 8 4 5 28853 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
45283 52185 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 44 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2005 12:00:00 AM     Permit Number 48377 6005762.6437766 2106998.90164263 37.765743404895 -122.423296509679 (37.765743404895, -122.423296509679) 8 4 5 28853 19
45907 47978 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2551 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45712 5992034.71482162 2098081.02537392 37.7404729102685 -122.470128602855 (37.7404729102685, -122.470128602855) 1 8 4 59 40
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
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
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
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
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
49911 36735 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2008 12:00:00 AM   3x3 Permit Number 50388 6006056.66890888 2108134.46852817 37.7688779913212 -122.422360229632 (37.7688779913212, -122.422360229632) 8 4 5 28853 19
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
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
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
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
55573 91399 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 76 Keystone Way 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2009 12:00:00 AM   3x3 Permit Number 52095 5994157 2093252.7 37.7273379826423 -122.46244050013 (37.7273379826423, -122.46244050013) 9 8 4 59 40
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
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
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
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
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
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
62721 52872 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 379@ TOMPKIN Nevada St 1 Sidewalk: Property side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52289 6008958.88978629 2096550.85337252 37.7372352710538 -122.411503113021 (37.7372352710538, -122.411503113021) 10 7 7 28859 2
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
62940 33060 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1300 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47189 6013414.11525102 2106644.78468583 37.7651999335347 -122.3968066986 (37.7651999335347, -122.3968066986) 14 3 8 28856 20
63705 94152 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2075 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53545 5991258.5 2101318 37.7493159033344 -122.473048420915 (37.7493159033344, -122.473048420915) 1 8 4 29491 12
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
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
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
67935 36737 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2008 12:00:00 AM   3x3 Permit Number 50388 6006056.66890888 2108134.46852817 37.7688779913212 -122.422360229632 (37.7688779913212, -122.422360229632) 8 4 5 28853 19
68513 50500 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 731 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM     Permit Number 47137 6002346.93991516 2089394.75729347 37.7172131586139 -122.43385228912 (37.7172131586139, -122.43385228912) 9 7 6 28861 5
68683 45184 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90 Montcalm St 4 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
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
69489 94151 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1719 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53546 5991153.7 2103679.7 37.7557944451048 -122.473583068651 (37.7557944451048, -122.473583068651) 1 8 4 56 12
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
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
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
77394 69420 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2631 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3 Permit Number 52649 6010038.90987973 2105005.87245397 37.7605114113713 -122.408365166937 (37.7605114113713, -122.408365166937) 2 4 8 28859 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

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