trees

269 rows where qSpecies_id = 163 sorted by qAddress

✎ 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)
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
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
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
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
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
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
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
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
158224 99721 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
166587 99723 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
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
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
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
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
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
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
186143 108879 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1301X JESSIE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006447 2109024 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
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
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
157566 108881 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1301x JESSIE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006447 2109024 37.7713424435686 -122.421073267678 (37.7713424435686, -122.421073267678) 8 2 9 28853 19
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
192125 86753 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1376 06th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3 Permit Number 52654 5994310.3 2106169.4 37.7628128189867 -122.462847225894 (37.7628128189867, -122.462847225894) 1 5 11 56 12
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
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
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
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
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
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
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
156439 60397 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1445 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52466 6016065.49318693 2093986.4863783 37.7305900909313 -122.38675332477 (37.7305900909313, -122.38675332477) 10 3 8 58 1
38093 98989 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1491 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 11313 5993631.9 2105378.7 37.7606026656916 -122.465136120946 (37.7606026656916, -122.465136120946) 1 8 11 56 12
132024 55376 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1491 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1972 12:00:00 AM   3x3 Permit Number 11313 5993646.25927439 2105360.40659062 37.760553264764 -122.465085130446 (37.760553264764, -122.465085130446) 1 8 11 56 12
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
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
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
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
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
162909 92428 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1606 40th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2009 12:00:00 AM   3x3 Permit Number 52819 5983797.4 2104193.9 37.7567775277693 -122.499061114391 (37.7567775277693, -122.499061114391) 1 8 3 56 35
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
187234 82676 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1621 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM   3x3 Permit Number 52504 6014985.81451712 2094439.95411177 37.7317753861847 -122.390517640406 (37.7317753861847, -122.390517640406) 10 3 8 58 1
172144 83322 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1630 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53558 5992802.78725609 2104361.64977018 37.757762266381 -122.467929643141 (37.757762266381, -122.467929643141) 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
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
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
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
166718 87771 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 173 Laidley St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50476 6004033 2097383 37.7392426262863 -122.428593473676 (37.7392426262863, -122.428593473676) 2 7 5 63 7
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
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
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
182195 116183 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1751 CARROLL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x15   6013485 2092424 37.7261566141218 -122.395565112125 (37.7261566141218, -122.395565112125) 10 3 8 58 1
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
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
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
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
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
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
183620 82800 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1942 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53540 5990674.38979657 2102169.39971398 37.7516197886013 -122.475130410819 (37.7516197886013, -122.475130410819) 1 8 4 29491 12
8789 110821 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 5 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
11312 110827 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1X WELSH ST 11 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6013408 2111682 37.7790306545162 -122.397181094632 (37.7790306545162, -122.397181094632) 6 2 9 28856 34
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
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
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
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
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
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
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
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
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
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
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
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
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
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
148697 94779 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 12 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
150144 94776 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
152383 94768 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
181944 94771 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
184106 94772 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
186736 94781 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Loomis St 14 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863) 10 3 8 58 1
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
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
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
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
169022 100430 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 200X Stonecrest Dr 6 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
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
185389 50880 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 2035 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2004 12:00:00 AM     Permit Number 47390 5991589.50004972 2101572.19756465 37.7500330221911 -122.471922351205 (37.7500330221911, -122.471922351205) 1 8 4 29491 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
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
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
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
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
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

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