2,694 rows where qSpecies_id = 84 sorted by Neighborhoods (old) descending

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old) ▲
1181 238014 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 77 Ashbury Ter 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5999606.96605 2106732.73135 37.7646632372481 -122.444568471453 (37.7646632372481, -122.444568471453) 15 5 5 29492 9
2220 117168 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
2221 238015 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 77 Ashbury Ter 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5999599.38464 2106733.87641 37.7646659486903 -122.444594775755 (37.7646659486903, -122.444594775755) 15 5 5 29492 9
2238 88648 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 74 Carmelita St   Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51628 6002619 2108775 37.7704422164895 -122.434296675208 (37.7704422164895, -122.434296675208) 15 5 5 29492 9
2537 245955 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 450 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5997557.5774 2107478.8878 37.7665948394439 -122.45171055689 (37.7665948394439, -122.45171055689) 15 5 11 29492 9
6155 247321 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 212 Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6002821 2109296 37.7718842175888 -122.433635197846 (37.7718842175888, -122.433635197846) 15 5 11 29492 9
10622 58722 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 73 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22987 6002575.33914396 2108761.52820117 37.7704027479761 -122.434446734741 (37.7704027479761, -122.434446734741) 15 5 5 29492 9
13830 62681 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 59 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM     Permit Number 23015 6002832.11131033 2108737.08241022 37.7703501979341 -122.433556812869 (37.7703501979341, -122.433556812869) 15 5 5 29492 9
17485 64739 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 139 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51671 6002793.57505281 2109015.34015791 37.7711120386945 -122.433710000051 (37.7711120386945, -122.433710000051) 15 5 11 29492 9
19438 244904 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 151 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999860.3433 2109070.0361 37.7710953445719 -122.443860048791 (37.7710953445719, -122.443860048791) 15 5 11 29492 9
19528 244063 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1670 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3 Width 0ft   5998595.6913 2109011.0161 37.7708610734694 -122.448230254318 (37.7708610734694, -122.448230254318) 15 5 11 29492 9
21824 67193 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 115 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30643 5997981.64121917 2106794.49458323 37.764739946577 -122.450194465027 (37.764739946577, -122.450194465027) 15 5 11 29492 9
22687 245213 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1155 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6001001.539 2109303.6237 37.7718017456892 -122.439929374343 (37.7718017456892, -122.439929374343) 15 5 11 29492 9
24662 245027 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1255 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6000554.2196 2109238.2078 37.7715966562859 -122.441471983052 (37.7715966562859, -122.441471983052) 15 5 11 29492 9
24845 237978 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 25 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5998568.18197 2106878.54944 37.7650042880525 -122.448171835459 (37.7650042880525, -122.448171835459) 15 5 11 29492 9
26683 238016 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 50 Ashbury Ter 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   5999571.74452 2106835.86862 37.7649444165749 -122.44469770674 (37.7649444165749, -122.44469770674) 15 5 5 29492 9
27433 245875 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 230 Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6001285.051 2109638.8769 37.7727384019806 -122.438972719673 (37.7727384019806, -122.438972719673) 15 5 11 29492 9
30534 35157 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 52 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2002 12:00:00 AM     Permit Number 44857 6002886.83329691 2108721.01150397 37.7703091758364 -122.433366381141 (37.7703091758364, -122.433366381141) 15 5 5 29492 9
31967 238021 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 142 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5999408.51642 2107367.43215 37.7663946408336 -122.445300491725 (37.7663946408336, -122.445300491725) 15 5 5 29492 9
32101 245028 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1267 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6000516.7427 2109233.4639 37.7715814955912 -122.441601276959 (37.7715814955912, -122.441601276959) 15 5 11 29492 9
32686 114513 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 418 BELVEDERE ST 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   6x7   5998550 2106753 37.7646585215155 -122.448225680862 (37.7646585215155, -122.448225680862) 15 5 11 29492 9
33839 238020 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 20 Ashbury Ter 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   5999596.30607 2106935.78713 37.7652201693967 -122.444619936965 (37.7652201693967, -122.444619936965) 15 5 5 29492 9
36560 245991 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1250 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999788.9734 2108484.4317 37.769483351344 -122.444064834189 (37.769483351344, -122.444064834189) 15 5 11 29492 9
41889 238012 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 170 Upper Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5999727.58165 2106665.35693 37.7644851256196 -122.444146453789 (37.7644851256196, -122.444146453789) 15 5 5 29492 9
43181 245887 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 204 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6001309.3147 2109461.0534 37.772251523616 -122.438876043486 (37.772251523616, -122.438876043486) 15 5 11 29492 9
44407 84962 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 85 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51457 5998153 2107172 37.7657862856112 -122.449628987429 (37.7657862856112, -122.449628987429) 15 5 11 29492 9
44828 88652 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 600 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51633 6003259 2109313 37.7719557379099 -122.432121339966 (37.7719557379099, -122.432121339966) 15 9 11 29492 9
45075 47650 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 867 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2002 12:00:00 AM     Permit Number 45454 5999132.82266547 2107294.05273346 37.7661774182509 -122.446248782885 (37.7661774182509, -122.446248782885) 15 5 11 29492 9
49345 246220 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1375 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5999535.8083 2107910.8735 37.7678940596266 -122.444899283084 (37.7678940596266, -122.444899283084) 15 5 11 29492 9
52254 117170 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
54623 238023 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1430 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999614.18249 2107598.76839 37.7670415699392 -122.444605761842 (37.7670415699392, -122.444605761842) 15 5 5 29492 9
55450 245057 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 38 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6000389.8085 2109086.3569 37.7711703439937 -122.442029787415 (37.7711703439937, -122.442029787415) 15 5 11 29492 9
57353 238027 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251 Alma St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997671.60097 2106142.0382 37.7629307194099 -122.451219750302 (37.7629307194099, -122.451219750302) 15 5 11 29492 9
60199 84018 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 35 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51242 5998460.05145867 2107208.75729753 37.7659047733573 -122.448569613891 (37.7659047733573, -122.448569613891) 15 5 11 29492 9
61011 62661 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 70 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2004 12:00:00 AM     Permit Number 22986 6002627.88843488 2108761.13623259 37.770404654499 -122.434264938817 (37.770404654499, -122.434264938817) 15 5 5 29492 9
63900 247414 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 971 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6001933.8006 2109433.5045 37.772211390909 -122.436713922993 (37.772211390909, -122.436713922993) 15 5 11 29492 9
63921 56805 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 821 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1974 12:00:00 AM     Permit Number 14034 5999098.25319347 2107541.33481317 37.7668544182522 -122.446386142574 (37.7668544182522, -122.446386142574) 15 5 11 29492 9
65163 237975 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 132 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5998055.30969 2105976.44068 37.7624979926238 -122.449880705624 (37.7624979926238, -122.449880705624) 15 5 11 29492 9
66999 245166 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1356 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6000067.3756 2109215.4243 37.7715063509193 -122.443154362685 (37.7715063509193, -122.443154362685) 15 5 11 29492 9
68043 245135 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 108 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6000350.1465 2109371.4561 37.7719508943795 -122.442187448391 (37.7719508943795, -122.442187448391) 15 5 11 29492 9
70016 62659 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 61 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22983 6002580.16870108 2108726.61196064 37.7703071507246 -122.434427532503 (37.7703071507246, -122.434427532503) 15 5 5 29492 9
70247 245006 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1201 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6000755.8359 2109268.0945 37.7716902017242 -122.440776726653 (37.7716902017242, -122.440776726653) 15 5 11 29492 9
70297 238024 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251 Alma St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5997519.0494 2106123.05363 37.7628698568746 -122.451746001204 (37.7628698568746, -122.451746001204) 15 5 11 29492 9
74098 54891 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 163 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32197 5997538.48619649 2107080.3370833 37.7654994273486 -122.451747836229 (37.7654994273486, -122.451747836229) 15 5 11 29492 9
74996 88734 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 85 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51669 6002352 2108735 37.7703172279103 -122.435217366486 (37.7703172279103, -122.435217366486) 15 5 5 29492 9
76070 41898 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 56 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42263 6002884.94747083 2108734.62843838 37.7703464576053 -122.433373877399 (37.7703464576053, -122.433373877399) 15 5 5 29492 9
77038 45127 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 110 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2001 12:00:00 AM     Permit Number 43984 6000366.86976442 2109279.71080278 37.7716999379516 -122.442123014739 (37.7716999379516, -122.442123014739) 15 5 11 29492 9
77910 45136 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1226 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/2001 12:00:00 AM     Permit Number 43993 6000686.57421699 2109306.41262626 37.7717914689993 -122.441019055934 (37.7717914689993, -122.441019055934) 15 5 11 29492 9
80400 88253 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1025 Ashbury St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51238 5999131 2106547 37.7641260948648 -122.446201344399 (37.7641260948648, -122.446201344399) 15 5 11 29492 9
81137 245099 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1116 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6001200.4602 2109374.4683 37.7720075888162 -122.439246372799 (37.7720075888162, -122.439246372799) 15 5 11 29492 9
82245 246225 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1387 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5999540.3508 2107874.8368 37.7677953711537 -122.444880980384 (37.7677953711537, -122.444880980384) 15 5 11 29492 9
84055 117166 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
84779 244104 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1950 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5997280.7606 2108828.2055 37.7702838623248 -122.452765409992 (37.7702838623248, -122.452765409992) 15 5 11 29492 9
86205 62658 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 58 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22982 6002632.81860855 2108725.49256472 37.7703070655924 -122.434245336767 (37.7703070655924, -122.434245336767) 15 5 5 29492 9
88829 67776 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 71 Potomac St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1992 12:00:00 AM     Permit Number 31409 6003067.4657108 2108808.86098812 37.7705606350184 -122.432747851071 (37.7705606350184, -122.432747851071) 15 5 5 29492 9
90953 246222 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1381 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999537.3225 2107899.6688 37.7678633807549 -122.444893240119 (37.7678633807549, -122.444893240119) 15 5 11 29492 9
91330 246224 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1382 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999585.4723 2107870.9 37.7677871366823 -122.444724628037 (37.7677871366823, -122.444724628037) 15 5 11 29492 9
93722 245066 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 26 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6000396.341 2109035.0297 37.7710297846632 -122.44200350657 (37.7710297846632, -122.44200350657) 15 5 11 29492 9
93849 237976 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 510 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5998599.32877 2106219.09376 37.7631953691937 -122.448016622395 (37.7631953691937, -122.448016622395) 15 5 11 29492 9
95395 117167 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
96954 112423 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 48 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000897 2109209 37.7715359812847 -122.440284193858 (37.7715359812847, -122.440284193858) 15 5 11 29492 9
98020 247314 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 303 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6003237.761 2109364.6049 37.7720962280958 -122.432198493214 (37.7720962280958, -122.432198493214) 15 9 11 29492 9
98488 62656 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 54 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM 8   Permit Number 22980 6002634.46199827 2108713.61135297 37.7702745359856 -122.434238802768 (37.7702745359856, -122.434238802768) 15 5 5 29492 9
98630 248511 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 77 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998828.2482 2107822.9016 37.7676121046283 -122.447340309872 (37.7676121046283, -122.447340309872) 15 5 11 29492 9
98707 62655 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 49 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22979 6002584.99825819 2108691.69572011 37.7702115534684 -122.434408330313 (37.7702115534684, -122.434408330313) 15 5 5 29492 9
100157 244907 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 150 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999911.6566 2109010.7372 37.7709354515424 -122.443678294205 (37.7709354515424, -122.443678294205) 15 5 11 29492 9
100296 245019 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1231 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6000585.055 2109242.4773 37.7716101359109 -122.441365628321 (37.7716101359109, -122.441365628321) 15 5 11 29492 9
101115 107518 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 59 POTOMAC ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x4   6003087.6 2108634.4 37.7700827498113 -122.432665742309 (37.7700827498113, -122.432665742309) 15 5 5 29492 9
107391 238026 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251 Alma St 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997640.69708 2106136.91348 37.7629148787356 -122.451326266018 (37.7629148787356, -122.451326266018) 15 5 11 29492 9
109206 238025 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251 Alma St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5997578.60338 2106127.58066 37.7628856975313 -122.451540352327 (37.7628856975313, -122.451540352327) 15 5 11 29492 9
111420 49436 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 79@ DUBOCE Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2003 12:00:00 AM     Permit Number 46374 6002353.45805216 2108701.89573226 37.7702264145578 -122.4352099549 (37.7702264145578, -122.4352099549) 15 5 5 29492 9
112478 88731 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 248 Scott St   Sidewalk: Curb side : Cutout Tree Private 2   08/11/2008 12:00:00 AM   3x3 Permit Number 51665 6002314 2109330 37.771948792814 -122.435391376972 (37.771948792814, -122.435391376972) 15 5 11 29492 9
113424 248602 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 462 Frederick St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5997486.7154 2107468.2888 37.7665616787282 -122.451954890142 (37.7665616787282, -122.451954890142) 15 5 11 29492 9
113894 64824 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 150 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1989 12:00:00 AM     Permit Number 25833 5999918.04659081 2109002.2102987 37.7709124032726 -122.443655578467 (37.7709124032726, -122.443655578467) 15 5 11 29492 9
114408 45135 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1155 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2001 12:00:00 AM     Permit Number 43992 6001042.61306002 2109303.63872684 37.7718041250014 -122.439787297823 (37.7718041250014, -122.439787297823) 15 5 11 29492 9
114732 245121 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1226 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6000650.5369 2109296.0266 37.7717608989394 -122.441142965804 (37.7717608989394, -122.441142965804) 15 5 11 29492 9
116097 245193 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 48 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000872.1204 2109220.0374 37.7715648706602 -122.440371045249 (37.7715648706602, -122.440371045249) 15 5 11 29492 9
117603 244105 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1950 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5997257.6483 2108826.1419 37.770276871813 -122.452845205966 (37.770276871813, -122.452845205966) 15 5 11 29492 9
119312 247304 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 247 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002738.4372 2109472.2087 37.7723633581964 -122.433933385595 (37.7723633581964, -122.433933385595) 15 5 11 29492 9
121485 244107 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1950 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5997179.2314 2108813.7603 37.7702383812245 -122.453115554339 (37.7702383812245, -122.453115554339) 15 5 11 29492 9
134315 45133 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1155 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2014 12:00:00 AM     Permit Number 772552 6001042.61306002 2109303.63872684 37.7718041250014 -122.439787297823 (37.7718041250014, -122.439787297823) 15 5 11 29492 9
134530 88653 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 600 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51633 6003259 2109313 37.7719557379099 -122.432121339966 (37.7719557379099, -122.432121339966) 15 9 11 29492 9
135431 238013 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 77 Ashbury Ter 3 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   5999618.47962 2106729.85774 37.764656004003 -122.444528442659 (37.764656004003, -122.444528442659) 15 5 5 29492 9
135521 56765 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 643 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1986 12:00:00 AM     Permit Number 23013 6002645.35055824 2108831.38976108 37.7705985445001 -122.434209560526 (37.7705985445001, -122.434209560526) 15 5 5 29492 9
136382 237979 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 823 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5999103.16972 2107519.69828 37.7667952905854 -122.446367580505 (37.7667952905854, -122.446367580505) 15 5 11 29492 9
138557 247294 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 836 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6002133.2487 2109156.7194 37.771462740403 -122.436004206745 (37.771462740403, -122.436004206745) 15 5 11 29492 9
139819 117169 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
141412 245195 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 48 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6000874.4772 2109202.1258 37.7715158240845 -122.440361608185 (37.7715158240845, -122.440361608185) 15 5 11 29492 9
142541 244897 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 39 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6000347.0687 2109078.5751 37.7711465414406 -122.442177066871 (37.7711465414406, -122.442177066871) 15 5 11 29492 9
143215 238011 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 170 Upper Ter 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5999678.69839 2106620.27376 37.7643585496334 -122.444312287003 (37.7643585496334, -122.444312287003) 15 5 5 29492 9
143895 45138 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1255 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/2001 12:00:00 AM     Permit Number 43995 6000565.8743917 2109237.20505579 37.771594566971 -122.4414315966 (37.771594566971, -122.4414315966) 15 5 11 29492 9
145185 62660 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 65 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22984 6002578.55884971 2108738.25070023 37.7703390164558 -122.434433933239 (37.7703390164558, -122.434433933239) 15 5 5 29492 9
145478 244106 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1950 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5997207.2964 2108819.9511 37.7702569879828 -122.453018925124 (37.7702569879828, -122.453018925124) 15 5 11 29492 9
147741 117171 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 299x ALMA ST 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
148286 99280 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 230 Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2           6001309.9 2109637.7 37.7727365843062 -122.43888668006 (37.7727365843062, -122.43888668006) 15 5 11 29492 9
149783 238018 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 50 Ashbury Ter 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   5999581.71277 2106854.10087 37.7649950466081 -122.444664539759 (37.7649950466081, -122.444664539759) 15 5 5 29492 9
149849 238460 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 52 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 Width 3ft Permit Number 779768 6002902.99046 2108581.89909 37.7699281239255 -122.433300551682 (37.7699281239255, -122.433300551682) 15 5 5 29492 9
151492 238022 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1430 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5999608.40723 2107632.11134 37.7671327917617 -122.444628134274 (37.7671327917617, -122.444628134274) 15 5 5 29492 9
152593 245004 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1201 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6000727.3724 2109263.3505 37.7716755548589 -122.440874843035 (37.7716755548589, -122.440874843035) 15 5 11 29492 9
152771 245026 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 1255 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6000539.9879 2109236.7846 37.7715919377433 -122.441521109042 (37.7715919377433, -122.441521109042) 15 5 11 29492 9

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