6,714 rows where qSpecies_id = 7 sorted by PermitNotes

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)
72 135801 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 16 Phoenix Ter 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6008610.92916 2117913.61927 37.7958729471262 -122.414217164494 (37.7958729471262, -122.414217164494) 5 1 10 308 21
95 261359 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007238 2095678 37.7347419306018 -122.417391193891 (37.7347419306018, -122.417391193891) 2 7 7 28859 2
97 261358 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2x Bache St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007175 2095707 37.7348180134015 -122.417611061749 (37.7348180134015, -122.417611061749) 2 7 7 28859 2
152 235666 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Jessie St 4 : Tree Private 2     3 Width 2ft   6006462.25734 2109005.38337 37.7712921868165 -122.421019169707 (37.7712921868165, -122.421019169707) 8 2 9 28853 19
189 178694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 184 Mount Vernon Ave 7 Side Yard : Yard Tree Private 2     9     5998957.82756 2089383.479 37.7169892861082 -122.445565994978 (37.7169892861082, -122.445565994978) 9 7 6 28861 25
199 237529 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1197 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003874.24561 2101347.66783 37.7501197023675 -122.429425031242 (37.7501197023675, -122.429425031242) 2 4 5 28862 22
211 196303 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 249 Shipley St 1 : Tree Private 2     1 Width 5ft   6011469.59111 2111688.37468 37.7789400547713 -122.403887319468 (37.7789400547713, -122.403887319468) 14 2 9 28856 34
259 196282 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1 25th St 13 : Yard Tree Private 2     12     6015015.25562 2102205.64875 37.7531000097757 -122.390958410295 (37.7531000097757, -122.390958410295) 10 3 8 28856 29
312 201949 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1650 Carroll Ave 18 : Tree Private 2     2 Width 3ft   6013468.57071 2092447.06427 37.7262190300648 -122.395623522912 (37.7262190300648, -122.395623522912) 10 3 8 58 1
332 182987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1975 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5989890.895 2098325.8493 37.7410209633467 -122.477558903564 (37.7410209633467, -122.477558903564) 1 8 3 29491 35
389 121965 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6     5991180.37033 2114963.80683 37.7867790889821 -122.474314218886 (37.7867790889821, -122.474314218886) 11 6 1 54 33
437 202267 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 28 Orsi Cir 1 : Tree Private 2     5 Width 2ft   6013033.98272 2093207.99375 37.7282842035544 -122.397179214247 (37.7282842035544, -122.397179214247) 10 3 8 58 1
491 246210 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 725 Buena Vista Ave West 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2019 12:00:00 AM 3 Width 0ft   5999854.0817 2107930.8602 37.7679670970626 -122.443799851593 (37.7679670970626, -122.443799851593) 15 5 11 29492 9
518 70144 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 8 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5991175.64413 2115000.10527 37.7868784805694 -122.474333220033 (37.7868784805694, -122.474333220033) 11 6 1 54 33
604 20034 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
681 71797 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2033 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5998131.4502 2109940.9744 37.7733879494567 -122.449903100064 (37.7733879494567, -122.449903100064) 15 5 11 29492 16
726 213079 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 127 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5994523.12061 2101041.16824 37.7487442639422 -122.461739308234 (37.7487442639422, -122.461739308234) 1 8 4 29491 40
816 248050 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 38 Rutledge St 7 Side Yard : Yard Tree Private 2     5     6010496.13368 2099436.61391 37.7452450531093 -122.406391405264 (37.7452450531093, -122.406391405264) 2 7 7 28859 2
839 71209 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2170 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988552.6315 2100561.3439 37.7470812936995 -122.48234982645 (37.7470812936995, -122.48234982645) 1 8 3 29491 35
902 213099 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 48 Brentwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5996420.67751 2095562.94637 37.733811460225 -122.454781859719 (37.733811460225, -122.454781859719) 9 7 4 59 40
967 78568 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1192 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6009666.22083 2090670.9365 37.7211299140849 -122.408642858878 (37.7211299140849, -122.408642858878) 9 3 7 309 28
994 236914 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 341 Moultrie St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007736.81458 2097491.93265 37.7397506441775 -122.415795016921 (37.7397506441775, -122.415795016921) 2 7 7 28859 2
996 70145 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 32 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5991181.63526 2114912.21638 37.7866375092707 -122.474306076539 (37.7866375092707, -122.474306076539) 11 6 1 54 33
1074 80599 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015456.30873 2104984.78613 37.7607553924711 -122.389627233831 (37.7607553924711, -122.389627233831) 10 3 8 28856 29
1128 178845 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 543 Sawyer St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007634.8415 2086934.39681 37.7107561785306 -122.415400376427 (37.7107561785306, -122.415400376427) 9 7 8 309 39
1159 70451 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2683 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5983041.4986 2096885.6865 37.7366668238827 -122.5011347377 (37.7366668238827, -122.5011347377) 1 8 3 29491 35
1236 78452 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3075 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5989337.22841 2094863.71499 37.7314826909771 -122.479220054956 (37.7314826909771, -122.479220054956) 1 8 4 64 35
1243 237775 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 51 States St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001962.65396 2106203.64248 37.763344625173 -122.43638291504 (37.763344625173, -122.43638291504) 15 5 5 28862 3
1251 218033 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 70 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5993104.01352 2098691.4194 37.7422106578044 -122.466475770336 (37.7422106578044, -122.466475770336) 1 8 4 59 40
1276 72277 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 819 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5983524.1138 2110218.5518 37.7733034736496 -122.500451657892 (37.7733034736496, -122.500451657892) 11 6 2 55 26
1364 253839 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 94 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/12/2011 12:00:00 AM   3x3   6006239 2097690 37.7402101761268 -122.42098789234 (37.7402101761268, -122.42098789234) 2 7 7 28859 2
1429 237519 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 155 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004137.76382 2100992.35213 37.7491590042859 -122.428488446692 (37.7491590042859, -122.428488446692) 2 4 5 28862 22
1470 261195 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 600X Benton Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007231 2095349 37.7338381748563 -122.417392087376 (37.7338381748563, -122.417392087376) 2 7 7 28859 2
1550 201970 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1651 Carroll Ave 21 : Tree Private 2     3 Width 3ft   6013765.00423 2092206.62002 37.7255753034535 -122.39458193082 (37.7255753034535, -122.39458193082) 10 3 8 58 1
1756 217968 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2535 17th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991076.46377 2098128.02027 37.74054650193 -122.473445254517 (37.74054650193, -122.473445254517) 1 8 4 29491 40
1775 196240 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 477 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010588.30864 2112340.27099 37.7806807348789 -122.406982002622 (37.7806807348789, -122.406982002622) 14 2 9 28853 34
1797 72003 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1991 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5987539.672 2101751.7111 37.7502907477313 -122.485939871711 (37.7502907477313, -122.485939871711) 1 8 3 29491 35
1801 73988 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3380 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5998684.41396 2115276.24554 37.7880688417562 -122.448374611919 (37.7880688417562, -122.448374611919) 13 6 1 54 31
1813 25410 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 153 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/22/1996 12:00:00 AM 3 3X3   6005712.73498 2108443.02914 37.7697058178046 -122.423571815294 (37.7697058178046, -122.423571815294) 8 4 5 28853 19
1836 214279 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 422 Edna St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5998780.00952 2094220.12118 37.7302594304325 -122.446528398166 (37.7302594304325, -122.446528398166) 9 7 4 28861 40
1844 212645 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 385 Vernon St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   5992447.95571 2090426.49221 37.7194793442858 -122.468143110712 (37.7194793442858, -122.468143110712) 9 8 6 64 24
1922 260512 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 180 Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990850 2091280 37.7217304489912 -122.473728831815 (37.7217304489912, -122.473728831815) 9 8 4 64 40
1931 213034 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 119 Edgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5996575.5142 2106308.44603 37.7633248140133 -122.455022738629 (37.7633248140133, -122.455022738629) 15 5 11 29492 12
2046 72250 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 360 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6002105.68115 2091634.84352 37.7233502412928 -122.434846310935 (37.7233502412928, -122.434846310935) 9 7 6 28861 5
2068 214271 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 519 Gennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5997445.19027 2095126.33403 37.7326713410914 -122.451208353186 (37.7326713410914, -122.451208353186) 9 7 4 59 40
2132 235898 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3623 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 6x5   6005449.14976 2104867.03319 37.7598721008326 -122.424229185527 (37.7598721008326, -122.424229185527) 2 4 5 28859 19
2141 70199 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 479-481 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5990281.69585 2112130.11385 37.7789464534529 -122.477216227307 (37.7789464534529, -122.477216227307) 11 6 2 55 26
2255 236751 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 420 Collingwood St 1 Sidewalk: Curb side : Pot Tree Private 2     5     6002101.36864 2103370.60532 37.7555736715096 -122.435700446513 (37.7555736715096, -122.435700446513) 2 4 5 28862 22
2298 248463 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 130 Beulah St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997448.7103 2107810.4856 37.7674990867904 -122.452111034778 (37.7674990867904, -122.452111034778) 15 5 11 29492 9
2423 183529 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2590 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5988341.8215 2097699.5391 37.7392112662203 -122.482869079468 (37.7392112662203, -122.482869079468) 1 8 3 29491 35
2505 196318 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 323 11th St 1 : Tree Private 2     4 Width 3ft   6008553.79261 2109149.29537 37.7718050135221 -122.413794615322 (37.7718050135221, -122.413794615322) 8 2 9 28853 34
2535 70599 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 346 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6004344.49924 2091141.9903 37.7221238322355 -122.427072045934 (37.7221238322355, -122.427072045934) 9 7 6 28861 5
2596 70483 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 939 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6005126.74678 2092081.98496 37.7247490558006 -122.424434831697 (37.7247490558006, -122.424434831697) 9 7 6 28861 5
2712 84610 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 535 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5987793.08995 2112320.51653 37.7793245451935 -122.485839179975 (37.7793245451935, -122.485839179975) 11 6 2 55 26
2811 246987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 70 Clipper St 1 : Tree Private 2     11 Width 3ft   6004726.23458 2101068.69852 37.7494019174823 -122.426458941248 (37.7494019174823, -122.426458941248) 2 4 5 28862 22
2821 212702 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1350 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5994593.65798 2106323.94898 37.7632534869818 -122.461878404565 (37.7632534869818, -122.461878404565) 15 5 11 56 12
2922 72315 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3526 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5997893.64237 2115823.01153 37.7895248738152 -122.451149975496 (37.7895248738152, -122.451149975496) 11 6 1 54 31
2984 261389 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 611 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2           6010649.76194 2118553.23001 37.7977434736118 -122.407207494731 (37.7977434736118, -122.407207494731) 3 1 10 308 4
2987 212886 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1941 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5990935.1255 2102170.56129 37.7516380862328 -122.474228847281 (37.7516380862328, -122.474228847281) 1 8 4 29491 12
3010 124046 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 723 12th Ave 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5992224.36446 2110496.07608 37.7745723492368 -122.470376788909 (37.7745723492368, -122.470376788909) 11 6 2 54 11
3055 20039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
3087 201271 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 200 Kalmanovitz St 5 Sidewalk: Curb side : Yard Tree Private 2     6 Width 2ft   6013058.71274 2092794.89099 37.7271512843849 -122.397064767443 (37.7271512843849, -122.397064767443) 10 3 8 58 1
3116 71316 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 558 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6003372.2866 2090101.06042 37.7192106439431 -122.430358515827 (37.7192106439431, -122.430358515827) 9 7 6 28861 5
3128 236759 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 239 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004655.95554 2096917.75381 37.7380004006851 -122.426406454101 (37.7380004006851, -122.426406454101) 2 7 5 63 7
3173 78509 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 750 Eucalyptus Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5988915.04586 2094775.69423 37.7312164799499 -122.480673162464 (37.7312164799499, -122.480673162464) 1 8 4 64 35
3278 72888 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2506 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5989566.1304 2098258.2718 37.7408165618747 -122.478676867492 (37.7408165618747, -122.478676867492) 1 8 3 29491 35
3291 237670 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 69 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003090.82539 2107383.74854 37.7666489493115 -122.432565239916 (37.7666489493115, -122.432565239916) 15 5 5 28862 3
3299 178756 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 47 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6008299.13366 2086795.43914 37.7104119441216 -122.413094604643 (37.7104119441216, -122.413094604643) 9 7 8 309 39
3324 100985 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
3353 261197 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 690x Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007331 2095336 37.7338081055982 -122.417045435619 (37.7338081055982, -122.417045435619) 2 7 7 28859 2
3475 78427 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 721 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6001123.96924 2089480.39079 37.7173788130682 -122.438085642862 (37.7173788130682, -122.438085642862) 9 7 6 28861 5
3561 246211 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 725 Buena Vista Ave West 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2019 12:00:00 AM 3 Width 0ft   5999847.7223 2107912.6904 37.7679168446173 -122.443820542416 (37.7679168446173, -122.443820542416) 15 5 11 29492 9
3582 71321 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 336 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6004246.97959 2090473.39754 37.7202825081141 -122.427361543098 (37.7202825081141, -122.427361543098) 9 7 6 28861 5
3643 202263 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 8 Orsi Cir 4 Sidewalk: Curb side : Yard Tree Private 2     5 Width 2ft   6013104.38405 2093156.20787 37.7281459291672 -122.396932202872 (37.7281459291672, -122.396932202872) 10 3 8 58 1
3723 260511 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 199X Stratford Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990954 2091213 37.7215525064104 -122.47336445039 (37.7215525064104, -122.47336445039) 9 8 4 64 40
3756 261450 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 302 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006908 2095729 37.7348633927281 -122.418535734777 (37.7348633927281, -122.418535734777) 2 7 7 28859 2
3895 78222 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1186 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6009661.32539 2090689.78042 37.7211813813865 -122.408661109741 (37.7211813813865, -122.408661109741) 9 3 7 309 28
3923 25589 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1380X Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6009160.7320011 2097455.9675675 37.7397318376167 -122.410869155933 (37.7397318376167, -122.410869155933) 10 7 7 28859 2
3972 73489 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 45 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000901.50106 2088195.84142 37.7138390733861 -122.438762613813 (37.7138390733861, -122.438762613813) 9 7 6 28861 5
3989 218019 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 645 Santiago St 5 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   5990820.54277 2099711.93527 37.7448807008818 -122.474445681024 (37.7448807008818, -122.474445681024) 1 8 4 29491 40
4085 212397 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 35 San Rafael Way 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   5991907.97112 2095768.21214 37.7341151819682 -122.470398435962 (37.7341151819682, -122.470398435962) 9 8 4 59 40
4104 78658 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 650 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6012076.11303 2105354.08238 37.761581389203 -122.401343843369 (37.761581389203, -122.401343843369) 10 3 8 28856 29
4181 142314 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1685 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5999759.4558 2110518.5336 37.7750667961639 -122.444313131138 (37.7750667961639, -122.444313131138) 15 5 11 29492 16
4188 236744 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 4201 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001442.35648 2103342.9897 37.7554603910923 -122.437977533533 (37.7554603910923, -122.437977533533) 2 4 5 28862 22
4248 261193 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 600X Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007231 2095349 37.7338381748563 -122.417392087376 (37.7338381748563, -122.417392087376) 2 7 7 28859 2
4349 212581 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 698 Hearst Ave 7 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5996847.55389 2094438.38996 37.7307481750846 -122.453224871536 (37.7307481750846, -122.453224871536) 9 7 4 59 40
4424 261436 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 375 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6007268 2095787 37.7350429085654 -122.417295195055 (37.7350429085654, -122.417295195055) 2 7 7 28859 2
4448 202285 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 Issleib Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 2ft   6012731.44947 2093293.25918 37.7285014779546 -122.398231071208 (37.7285014779546, -122.398231071208) 10 3 8 58 1
4609 236279 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 342 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007175.75737 2105294.6184 37.761143491293 -122.418287995211 (37.761143491293, -122.418287995211) 2 4 7 28859 19
4679 236258 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 900 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009116.08466 2103840.92057 37.7572609975042 -122.411474503866 (37.7572609975042, -122.411474503866) 2 4 7 28859 19
4741 236777 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 540 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003149.68066 2096096.4709 37.7356600832353 -122.431555771598 (37.7356600832353, -122.431555771598) 2 7 5 63 7
4775 218083 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 281 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5994638.85855 2100259.1397 37.7466036724264 -122.461282408569 (37.7466036724264, -122.461282408569) 1 8 4 29491 40
4777 261199 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 690x Benton Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007331 2095336 37.7338081055982 -122.417045435619 (37.7338081055982, -122.417045435619) 2 7 7 28859 2
4779 73552 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1558 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000334.7955 2110645.229 37.7754474779657 -122.4423320082 (37.7754474779657, -122.4423320082) 15 5 11 29492 16
4921 71593 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 34 Rhine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5994443.94493 2086683.28618 37.7093164601484 -122.46097260021 (37.7093164601484, -122.46097260021) 9 8 6 28861 25
4948 212696 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1342 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5994280.27927 2106365.59 37.7633497765027 -122.462965291019 (37.7633497765027, -122.462965291019) 1 5 11 56 12
4963 72437 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3770 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5996832.97473 2115019.84204 37.7872588007918 -122.4547616987 (37.7872588007918, -122.4547616987) 11 6 1 54 31
4991 20043 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
5018 261361 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3 Bache St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007238 2095678 37.7347419306018 -122.417391193891 (37.7347419306018, -122.417391193891) 2 7 7 28859 2
5034 71218 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2271 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5988222.5624 2099870.3089 37.7451646891306 -122.483440513109 (37.7451646891306, -122.483440513109) 1 8 3 29491 35

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