269 rows where qSpecies_id = 163

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)
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
79007 33064 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 82-98X Missouri St 3 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
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
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
81524 36739 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 7 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
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
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
87327 45030 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3310 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM 2 3x3 Permit Number 43923 6007466.67182557 2105026.73123369 37.7604243064239 -122.4172628604 (37.7604243064239, -122.4172628604) 2 4 7 28859 19
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
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
92185 84149 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3376 19th St 2 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
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
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
93926 42591 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 121 Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42664 5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
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
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
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
94891 93003 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 11 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
96566 45186 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90 Montcalm St 1 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
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
98283 94778 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 11 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
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
108344 93006 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 14 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
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
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
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
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
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
117128 43407 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 458 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43150 6002175.1657372 2101516.64467827 37.7504873295285 -122.435312625256 (37.7504873295285, -122.435312625256) 2 4 5 28862 22
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
118748 57465 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1439 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1976 12:00:00 AM 20 3x3 Permit Number 16313 5994563.72083648 2105730.98306422 37.7616236328643 -122.461938945528 (37.7616236328643, -122.461938945528) 1 5 11 56 12
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
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
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
122757 50885 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2127 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47394 5991285.70524254 2100933.45919482 37.7482616292065 -122.472926308365 (37.7482616292065, -122.472926308365) 1 8 4 29491 40
123787 92724 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 41 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2009 12:00:00 AM   3x3 Permit Number 52959 6003346 2105631 37.7618507928241 -122.43155749122 (37.7618507928241, -122.43155749122) 15 4 5 28862 3
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
124513 82863 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3450 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50587 6006545.62237249 2104975.62835635 37.7602321285391 -122.420444723128 (37.7602321285391, -122.420444723128) 2 4 7 28859 19
124830 57204 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2450 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2009 12:00:00 AM   3x3 Permit Number 52710 5992063.41903222 2098761.57831598 37.7423431948322 -122.470078897994 (37.7423431948322, -122.470078897994) 1 8 4 29491 40
125185 94168 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 900 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53525 5990680 2101127 37.7487579569011 -122.475034924429 (37.7487579569011, -122.475034924429) 1 8 4 29491 12
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
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
126853 50125 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 70 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46848 5993079.36799121 2098627.78111817 37.7420345009836 -122.466556361723 (37.7420345009836, -122.466556361723) 1 8 4 59 40
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
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
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
128002 47910 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1394on Pierce McAllister St 1 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
128547 93004 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 250 Valencia St 12 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
128707 84473 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 173 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50476 6004035.61598466 2097396.11275514 37.7392787789652 -122.428585363223 (37.7392787789652, -122.428585363223) 2 7 5 63 7
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
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
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
131131 33815 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2004 12:00:00 AM 12 3x3 Permit Number 47361 6006849.4113767 2097983.16030049 37.7410495186328 -122.418898117948 (37.7410495186328, -122.418898117948) 2 7 7 28859 2
132024 55376 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1491 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1972 12:00:00 AM   3x3 Permit Number 11313 5993646.25927439 2105360.40659062 37.760553264764 -122.465085130446 (37.760553264764, -122.465085130446) 1 8 11 56 12
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
134277 94773 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
136222 94782 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 15 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
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
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
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
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
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
139420 94169 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 900 Quintara St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53525 5990680 2101127 37.7487579569011 -122.475034924429 (37.7487579569011, -122.475034924429) 1 8 4 29491 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
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
142379 45185 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 90 Montcalm St 2 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
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
142715 82675 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1175 Gilman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52488 6014632.30522662 2090165.00558289 37.7200176149462 -122.391441056407 (37.7200176149462, -122.391441056407) 10 3 8 58 1
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
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
144559 64676 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3652 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52395 6005952.88192889 2104356.55028011 37.7584988641554 -122.422450746558 (37.7584988641554, -122.422450746558) 2 4 5 28859 19
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
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
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
148697 94779 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 12 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
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
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
150144 94776 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
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
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

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