4,014 rows where qSpecies_id = 40 sorted by Supervisor Districts

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)
99053 116894 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Alhambra St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6001897.52549 2120678.68583 37.8030857122852 -122.437644885099 (37.8030857122852, -122.437644885099) 13 9 1 57 17
100266 36753 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2579 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM 8   Permit Number 41197 6002394.06342 2116399.40669 37.7913641456997 -122.435620277371 (37.7913641456997, -122.435620277371) 13 9 1 29490 27
102209 12753 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1730 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/2000 12:00:00 AM 12 3X3   5990048.72352 2114754.53717 37.7861388679375 -122.478214101082 (37.7861388679375, -122.478214101082) 11 6 1 55 33
102732 135931 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1361 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004797.09073 2120517.98623 37.8028089081649 -122.42759940931 (37.8028089081649, -122.42759940931) 13 9 1 57 17
102829 12827 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2212 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 3 3X3   5988580.16808 2114701.52791 37.7859079633533 -122.483290964922 (37.7859079633533, -122.483290964922) 11 6 1 55 33
103609 250820 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 60 Sea View Ter 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5986182.97775 2114165.47247 37.7842963089586 -122.491544993816 (37.7842963089586, -122.491544993816) 11 6 1 55 33
103826 250676 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 735 El Camino Del Mar 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5986293.29726 2114811.88275 37.786077611448 -122.49121092176 (37.786077611448, -122.49121092176) 11 6 1 55 33
104679 250758 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 214 32nd Ave 1 : Tree Private 2     6 Width 3ft   5985901.94322 2114466.62788 37.7851067672137 -122.492539447037 (37.7851067672137, -122.492539447037) 11 6 1 55 33
104741 250761 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 228 32nd Ave 2 : Tree Private 2     6 Width 3ft   5985903.37202 2114379.41265 37.7848673829594 -122.49252807871 (37.7848673829594, -122.49252807871) 11 6 1 55 33
105143 135961 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2600 Divisadero St 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   6000735.77189 2117237.48779 37.7935709695869 -122.441418078004 (37.7935709695869, -122.441418078004) 13 9 1 57 27
105736 99740 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2770 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2012 12:00:00 AM   3x3 Permit Number 768985 6000934 2116568 37.7917440216798 -122.440684150501 (37.7917440216798, -122.440684150501) 13 6 1 29490 27
110826 33141 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3143 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 9   Permit Number 37367 6001898.22805 2118969.04221 37.7983915210181 -122.437519950413 (37.7983915210181, -122.437519950413) 13 9 1 57 17
112019 48418 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2490 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2002 12:00:00 AM 5   Permit Number 45796 6001083.86892 2118658.42768 37.7974923221726 -122.440315587421 (37.7974923221726, -122.440315587421) 13 9 1 57 17
112966 41181 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1780 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM 11   Permit Number 41899 6001559.95191 2121091.33566 37.8041995397404 -122.438842652585 (37.8041995397404, -122.438842652585) 13 9 1 57 17
113555 135930 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1960 Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6000826.24021 2120988.33796 37.8038749654115 -122.441374316075 (37.8038749654115, -122.441374316075) 13 9 1 57 17
113935 253424 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993083 2114893 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285) 11 6 1 54 11
114399 135958 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2961 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5999426.86428 2117337.28078 37.7937703214002 -122.445954168467 (37.7937703214002, -122.445954168467) 13 9 1 57 27
115280 36752 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2579 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/1999 12:00:00 AM 5   Permit Number 41197 6002410.05116 2116400.74901 37.7913687394284 -122.435565056287 (37.7913687394284, -122.435565056287) 13 9 1 29490 27
117138 124618 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 700 Euclid Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996155.43813 2113845.79893 37.7839963058327 -122.45702086273 (37.7839963058327, -122.45702086273) 11 6 1 54 31
117467 33992 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2034 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2013 12:00:00 AM 3   Permit Number 769995 6001444.58 2115566.6422 37.7890236150982 -122.438845759727 (37.7890236150982, -122.438845759727) 13 6 1 29490 27
118774 108694 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950X Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.8039101397338 -122.440613252117 (37.8039101397338, -122.440613252117) 13 9 1 57 17
120825 34255 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2280 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2016 12:00:00 AM 3 6x4 Permit Number 779106 6002701.36974 2117843.10011 37.7953456053627 -122.434660283471 (37.7953456053627, -122.434660283471) 13 9 1 57 17
122080 250869 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 133 30th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5986468.30668 2114640.25117 37.7856165847741 -122.490592812307 (37.7856165847741, -122.490592812307) 11 6 1 55 33
122741 12834 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2240 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2005 12:00:00 AM 16 5   5988481.05496 2114714.7558 37.7859385147967 -122.483634834967 (37.7859385147967, -122.483634834967) 11 6 1 55 33
122944 124377 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 43 Jordan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5996171.6686 2114245.14999 37.7850937492478 -122.456993606965 (37.7850937492478, -122.456993606965) 11 6 1 54 31
123692 17355 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2200 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6005540.30706 2117584.3351 37.7947958596827 -122.424818667772 (37.7947958596827, -122.424818667772) 13 9 1 28858 27
124069 88367 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2014 12:00:00 AM 3 3x3 Permit Number 772880 5999340.32482 2115698.11509 37.7892646630799 -122.446135640871 (37.7892646630799, -122.446135640871) 13 6 1 29490 31
124864 48575 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2275 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2002 12:00:00 AM 6   Permit Number 45888 5999350.9725 2120803.18902 37.8032824443927 -122.446466222664 (37.8032824443927, -122.446466222664) 13 9 1 57 17
126258 135921 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2495 Filbert St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001125.35407 2118620.11363 37.797389483787 -122.440169289291 (37.797389483787, -122.440169289291) 13 9 1 57 17
129220 111197 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2317 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     6     6003620.63323 2116569.07161 37.7918995930282 -122.431388491405 (37.7918995930282, -122.431388491405) 13 9 1 29490 27
130599 105719 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2317 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2015 12:00:00 AM 3 3x3 Permit Number 775548 6003614.61217 2116568.84347 37.7918986253737 -122.431409307988 (37.7918986253737, -122.431409307988) 13 9 1 29490 27
131162 98034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1817 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2011 12:00:00 AM 3 3x3 Permit Number 768344 5999961.07212 2115342.88884 37.7883247339384 -122.443962403049 (37.7883247339384, -122.443962403049) 13 6 1 29490 27
131806 250521 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 95 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   5987685.5238 2115445.0256 37.7878972888638 -122.486440754852 (37.7878972888638, -122.486440754852) 11 6 1 55 33
132324 135974 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2266 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6003300.9204 2117230.69268 37.793698110328 -122.432541977147 (37.793698110328, -122.432541977147) 13 9 1 29490 27
133521 93018 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 963 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2010 12:00:00 AM   3x3 Permit Number 53140 6006134 2121397 37.805297983444 -122.423035527254 (37.805297983444, -122.423035527254) 5 1 1 28858 32
133775 31988 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 137 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 12   Permit Number 35388 5994566.45186 2114623.28431 37.7860396925732 -122.462574550559 (37.7860396925732, -122.462574550559) 11 6 1 54 11
134414 250874 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5986467.3841 2114682.39336 37.7857322411853 -122.490599105779 (37.7857322411853, -122.490599105779) 11 6 1 55 33
135045 135943 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2056 Jefferson St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   5999351.77852 2121203.50658 37.8043816542415 -122.446492250814 (37.8043816542415, -122.446492250814) 13 9 1 57 17
135205 123972 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 75 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993617.67519 2115041.45387 37.7871331868608 -122.46588743043 (37.7871331868608, -122.46588743043) 11 6 1 54 11
135207 52875 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 118@ BEACH Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2006 12:00:00 AM 5 3x3 Permit Number 48887 6001367.78659 2121129.52184 37.8042934541427 -122.439510392889 (37.8042934541427, -122.439510392889) 13 9 1 57 17
135527 67443 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 161 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1992 12:00:00 AM 9   Permit Number 30946 5994572.42148 2114474.4165 37.7856312857071 -122.462543095141 (37.7856312857071, -122.462543095141) 11 6 1 54 11
136396 51419 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2504 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/2012 12:00:00 AM     Permit Number 769443 6001518.65549528 2114626.94659681 37.7864476669078 -122.43852211335 (37.7864476669078, -122.43852211335) 13 6 1 29490 27
136751 250881 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 154 29th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5986823.25063 2114733.91146 37.7858944753023 -122.489371714655 (37.7858944753023, -122.489371714655) 11 6 1 55 33
141469 52065 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 155 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/11/2006 12:00:00 AM 3   Permit Number 48260 5994571.97803 2114501.44364 37.7857054693715 -122.462546590502 (37.7857054693715, -122.462546590502) 11 6 1 54 11
141913 135940 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 310 Locust St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5997632.68283 2115371.58358 37.7882704283935 -122.452020280013 (37.7882704283935, -122.452020280013) 11 6 1 54 31
142216 99741 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2770 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2012 12:00:00 AM   3x3 Permit Number 768985 6000934 2116568 37.7917440216798 -122.440684150501 (37.7917440216798, -122.440684150501) 13 6 1 29490 27
143085 120705 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 21st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5989295.69695 2115021.44108 37.78682797013 -122.480838891203 (37.78682797013, -122.480838891203) 11 6 1 55 33
143911 88451 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 1 Median : Cutout Tree DPW 1   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.8052099010884 -122.425294529632 (37.8052099010884, -122.425294529632) 5 1 1 28858 32
144490 94744 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1801 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2010 12:00:00 AM 4 3x3 Permit Number 53879 6004279.92071 2118358.49437 37.7968502341069 -122.429235007194 (37.7968502341069, -122.429235007194) 13 9 1 57 17
145043 135972 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2304 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6002483.01544 2117812.37138 37.7952488338219 -122.435413624843 (37.7952488338219, -122.435413624843) 13 9 1 57 17
146532 45569 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 310 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM 4   Permit Number 44312 5997642.12042 2115315.11009 37.7881159077753 -122.451983551718 (37.7881159077753, -122.451983551718) 11 6 1 54 31
146944 135954 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2993 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6000463.47531 2115807.7741 37.789629833704 -122.442257560964 (37.789629833704, -122.442257560964) 13 6 1 29490 27
147598 135963 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2517 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6001390.29582 2117256.32875 37.793659967376 -122.439154728128 (37.793659967376, -122.439154728128) 13 9 1 29490 27
147654 108702 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2382 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 772586 6001605.97197 2118381.98302 37.7967629901963 -122.438489159966 (37.7967629901963, -122.438489159966) 13 9 1 57 17
148181 135951 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3566 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997226.42135 2116056.02078 37.7901264312514 -122.453475306653 (37.7901264312514, -122.453475306653) 11 6 1 54 31
148417 27310 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2140 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2014 12:00:00 AM 5 5   5988795.04874 2114709.3 37.7859418063725 -122.4825481157 (37.7859418063725, -122.4825481157) 11 6 1 55 33
150885 135949 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Alhambra St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6001899.24184 2120659.238 37.8030324112758 -122.437637552032 (37.8030324112758, -122.437637552032) 13 9 1 57 17
151203 135960 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2980 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5999353.02383 2117377.12096 37.7938754952995 -122.446212529304 (37.7938754952995, -122.446212529304) 13 9 1 57 27
152505 12571 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/05/1993 12:00:00 AM 3 2X2   5994414.30523 2114928.25799 37.7868683042504 -122.463123069231 (37.7868683042504, -122.463123069231) 11 6 1 54 11
152903 250902 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 266 29th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5986843.33005 2114156.49339 37.7843102232907 -122.489259776936 (37.7843102232907, -122.489259776936) 11 6 1 55 33
153324 250677 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 735 El Camino Del Mar 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5986302.66224 2114812.53014 37.7860799361791 -122.49117856955 (37.7860799361791, -122.49117856955) 11 6 1 55 33
154082 12830 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2224 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 5   5988512.18064 2114699.82463 37.7858993297316 -122.483526054934 (37.7858993297316, -122.483526054934) 11 6 1 55 33
154376 18953 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2857 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2000 12:00:00 AM 3 3X3   6001142.52027 2115568.9795 37.7890128430163 -122.439891012071 (37.7890128430163, -122.439891012071) 13 6 1 29490 27
156207 135964 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2574 Broadway 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6001301.48342 2117308.30173 37.7937976176176 -122.439465753262 (37.7937976176176, -122.439465753262) 13 9 1 57 27
157300 33140 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3143 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 6   Permit Number 37367 6001896.074 2118984.29093 37.7984332675401 -122.437528496644 (37.7984332675401, -122.437528496644) 13 9 1 57 17
158140 94877 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3043 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2010 12:00:00 AM 12 3x3   6000192.74031 2115767.95632 37.7895050707416 -122.443191412453 (37.7895050707416, -122.443191412453) 13 6 1 29490 27
158690 135917 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2350 Green St 9 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6001679.33795 2118057.34258 37.7958757853901 -122.438212029083 (37.7958757853901, -122.438212029083) 13 9 1 57 17
159313 46513 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2563 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM 4   Permit Number 44679 6002506.83642 2116089.37205 37.790519274906 -122.435207900427 (37.790519274906, -122.435207900427) 13 9 1 29490 27
160773 72310 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3560 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/2009 12:00:00 AM   3x3 Permit Number 52568 5997222.81760297 2116058.54886417 37.7901331661187 -122.453487957873 (37.7901331661187, -122.453487957873) 11 6 1 54 31
162106 17354 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2200 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6005542.87933 2117567.08542 37.7947486417029 -122.424808539584 (37.7947486417029, -122.424808539584) 13 9 1 28858 27
162413 135947 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 31 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6001885.41156 2120707.63326 37.8031645054925 -122.437688879962 (37.8031645054925, -122.437688879962) 13 9 1 57 17
165313 64351 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2829 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/1988 12:00:00 AM 10   Permit Number 25187 5999331.75802 2118714.36409 37.7975459946103 -122.446382356375 (37.7975459946103, -122.446382356375) 13 9 1 57 17
166696 135942 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 420 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5998162.58841 2115059.8609 37.7874448588433 -122.450164425556 (37.7874448588433, -122.450164425556) 13 6 1 54 31
167469 51995 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2837 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2005 12:00:00 AM 11   Permit Number 48213 5999309.41845 2118712.36147 37.7975392200233 -122.446459512793 (37.7975392200233, -122.446459512793) 13 9 1 57 17
167709 64286 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2137 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/1988 12:00:00 AM 3   Permit Number 25090 6003796.62217 2115819.36952 37.7898510741089 -122.430726046274 (37.7898510741089, -122.430726046274) 13 9 1 29490 27
168359 12826 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2212 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/2010 12:00:00 AM 3 3X3   5988595.84675 2114702.32759 37.7859110714864 -122.483236780343 (37.7859110714864, -122.483236780343) 11 6 1 55 33
168448 135944 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1998 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5999737.82806 2121247.80693 37.8045253335298 -122.445159485234 (37.8045253335298, -122.445159485234) 13 9 1 57 17
170697 54378 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2105 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2013 12:00:00 AM 3 0 Permit Number 769000 6003486.81156 2117545.01589 37.7945717009834 -122.431921232674 (37.7945717009834, -122.431921232674) 13 9 1 29490 27
171289 136015 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Havens St 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6007560.5835 2119380.86157 37.7998425735334 -122.417955630044 (37.7998425735334, -122.417955630044) 5 1 1 28858 32
171595 120701 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 70 22nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 5ft   5988982.8407 2114887.49266 37.7864419959893 -122.481911472455 (37.7864419959893, -122.481911472455) 11 6 1 55 33
171714 135950 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3012 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004722.9901 2119938.49945 37.8012135953823 -122.427814520823 (37.8012135953823, -122.427814520823) 13 9 1 57 17
174379 108635 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Lake St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774602 5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787) 11 6 1 55 33
175868 68292 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 1   Permit Number 32101 5991174.54811 2115022.52462 37.7869399743547 -122.474338648581 (37.7869399743547, -122.474338648581) 11 6 1 54 33
175938 135975 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2325 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003558.57482 2116562.95168 37.79187927196 -122.431602776473 (37.79187927196, -122.431602776473) 13 9 1 29490 27
176507 136014 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Havens St 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6007575.68988 2119392.22094 37.7998746136871 -122.417904161874 (37.7998746136871, -122.417904161874) 5 1 1 28858 32
176731 17356 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2200 Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6005536.16539 2117610.65272 37.7948678872914 -122.424834871756 (37.7948678872914, -122.424834871756) 13 9 1 28858 27
177908 117091 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2X 09TH AVE 2 Sidewalk: Curb side : Yard Tree Private 2     3 3x3   5993083 2114893 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285) 11 6 1 54 11
180377 111196 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2317 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2015 12:00:00 AM 3   Permit Number 775548 6003599.35024 2116566.69152 37.7918918516902 -122.431461960596 (37.7918918516902, -122.431461960596) 13 9 1 29490 27
180572 88280 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3261 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2017 12:00:00 AM 3 3x3 Permit Number 778851 5999200.48769 2115630.53591 37.7890711217748 -122.446614594592 (37.7890711217748, -122.446614594592) 13 6 1 29490 31
180833 250876 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 30th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5986468.29527 2114661.08637 37.7856737915584 -122.490594385245 (37.7856737915584, -122.490594385245) 11 6 1 55 33
181937 87739 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 11 Median : Cutout Tree DPW 1   05/10/2008 12:00:00 AM 3 4x4   6005433.61853 2121623.41722 37.8058801199389 -122.425475412067 (37.8058801199389, -122.425475412067) 13 1 1 28858 17
183204 135956 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3168 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5999589.99296 2115734.38967 37.789378518158 -122.445274431176 (37.789378518158, -122.445274431176) 13 6 1 29490 27
184501 108692 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950X Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.8039101397338 -122.440613252117 (37.8039101397338, -122.440613252117) 13 9 1 57 17
184890 135939 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 Walnut St 7 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5998471.02227 2116380.33284 37.7910881707365 -122.449192479647 (37.7910881707365, -122.449192479647) 13 6 1 54 31
186102 250644 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2610 Lake St 5 : Tree Private 2     4 Width 3ft   5987312.10464 2114657.57566 37.785713403992 -122.487674827026 (37.785713403992, -122.487674827026) 11 6 1 55 33
186218 122246 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 47 Lake St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5990773.91586 2114787.49655 37.7862714344835 -122.475707561575 (37.7862714344835, -122.475707561575) 11 6 1 54 33
186265 124620 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 700 Euclid Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996122.36346 2113846.22153 37.7839955667695 -122.457135318887 (37.7839955667695, -122.457135318887) 11 6 1 54 31
187218 34878 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3009 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1997 12:00:00 AM 10   Permit Number 38491 6000242.0296 2115774.84436 37.7895267938762 -122.443021372241 (37.7895267938762, -122.443021372241) 13 6 1 29490 27
189194 66052 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2153 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1990 12:00:00 AM 5   Permit Number 29091 6000458.6364 2120609.13793 37.8028128355005 -122.442619184653 (37.8028128355005, -122.442619184653) 13 9 1 57 17
189841 135969 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2831 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002539.26746 2117862.89665 37.7953907576358 -122.435222599839 (37.7953907576358, -122.435222599839) 13 9 1 57 17

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