4,014 rows where qSpecies_id = 40 sorted by rowid 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)
194486 86928 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 838 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2014 12:00:00 AM 3 3x3 Permit Number 774404 6011535 2104444 37.7590523005339 -122.403151323818 (37.7590523005339, -122.403151323818) 10 3 8 28856 29
194485 181039 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2017 12:00:00 AM 3 Width 4ft   6000909.27168 2088176.54977 37.7137865448937 -122.438734374192 (37.7137865448937, -122.438734374192) 9 7 6 28861 5
194458 238322 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194455 238321 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194451 238323 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194333 238518 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 210 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6002025.02718 2096169.57182 37.7357969924364 -122.435449354007 (37.7357969924364, -122.435449354007) 2 7 5 63 7
194236 108084 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 626 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           6010239.31853 2105432.72154 37.7616946632209 -122.407702139761 (37.7616946632209, -122.407702139761) 10 4 8 28859 19
194209 214653 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 306 Noriega St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993065.83044 2103254.91574 37.7547386482769 -122.466939481481 (37.7547386482769, -122.466939481481) 1 8 4 56 12
194207 238095 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6009056.8841 2104842.92268 37.7600089470684 -122.411750042628 (37.7600089470684, -122.411750042628) 2 4 7 28859 19
194182 237272 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 538 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007680.62623 2096843.59864 37.7379673029564 -122.415943393383 (37.7379673029564, -122.415943393383) 2 7 7 28859 2
194107 238432 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 308 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5999552.15368 2105159.38108 37.7603400810593 -122.444644958805 (37.7603400810593, -122.444644958805) 15 5 5 28862 3
194103 109076 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1137 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.436420213894 (37.7106245477128, -122.436420213894) 9 7 6 28861 5
194090 239383 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 905 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6001941.13579 2101387.13956 37.7501184460087 -122.436112650804 (37.7501184460087, -122.436112650804) 2 4 5 28862 22
194058 30683 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 425 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3   Permit Number 782764 6004598.67244 2110025.49511 37.773987938825 -122.42753808092 (37.773987938825, -122.42753808092) 7 9 11 28852 10
193969 213400 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 621 Quintara St 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991548.41511 2101099.17874 37.7487318577911 -122.472029950926 (37.7487318577911, -122.472029950926) 1 8 4 29491 40
193932 108082 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 626 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           6010239.31853 2105432.72154 37.7616946632209 -122.407702139761 (37.7616946632209, -122.407702139761) 10 4 8 28859 19
193916 237357 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1448 Treat Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008697.70775 2100711.62827 37.7486451892219 -122.412700200662 (37.7486451892219, -122.412700200662) 2 4 7 28859 19
193908 238140 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 29th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006215.4678 2099105.76551 37.7440962231594 -122.421169762096 (37.7440962231594, -122.421169762096) 2 7 7 28859 2
193760 98461 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 210 UPPER TER 3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2012 12:00:00 AM   3x3 Permit Number 768632 5999573.7 2106360.6 37.7636395591816 -122.444656780294 (37.7636395591816, -122.444656780294) 15 5 5 29492 9
193741 239499 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 185 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008300.3877 2097749.03672 37.7404882618287 -122.41386459608 (37.7404882618287, -122.41386459608) 2 7 7 28859 2
193704 88452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Van Ness Ave 2 Median : Cutout Tree DPW 1   06/07/2008 12:00:00 AM 4 5x12   6005470.42698 2121378.16696 37.8052088057127 -122.425330567252 (37.8052088057127, -122.425330567252) 5 1 1 28858 17
193634 108648 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 196 Lippard Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774607 6001751.75522 2094959.06379 37.7324576925005 -122.436307555189 (37.7324576925005, -122.436307555189) 9 7 5 63 40
193626 214536 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 647 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993699.40392 2106621.4524 37.7640188316212 -122.464992916908 (37.7640188316212, -122.464992916908) 1 8 11 56 12
193622 110514 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600x 15TH ST 12 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6006820 2107391 37.7668796319268 -122.419667156869 (37.7668796319268, -122.419667156869) 8 4 7 28853 19
193580 214541 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 604 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993864.92677 2106687.84743 37.764210677717 -122.464425247739 (37.764210677717, -122.464425247739) 11 8 11 56 12
193521 10102 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 771 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2003 12:00:00 AM 3 2X2   6005674.23902 2104513.09601 37.7589129792732 -122.423425548652 (37.7589129792732, -122.423425548652) 2 4 5 28859 19
193429 96036 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1498 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767675 6006383 2118353 37.7969539806541 -122.421957458925 (37.7969539806541, -122.421957458925) 13 9 10 28858 32
193415 91972 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1340 09th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2009 12:00:00 AM 3 3x3   5993348.371695 2106356.020653 37.7632697788308 -122.466187733171 (37.7632697788308, -122.466187733171) 1 8 11 56 12
193362 38717 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 458 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/1998 12:00:00 AM 8   Permit Number 40620 5994382.59481 2112404.76272 37.7799376414757 -122.463049617411 (37.7799376414757, -122.463049617411) 11 6 2 54 11
193301 237051 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1385 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6010363.50755 2101264.14929 37.7502556447887 -122.406978792951 (37.7502556447887, -122.406978792951) 10 4 7 28859 19
193299 82189 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1925 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/29/2007 12:00:00 AM   3x3 Permit Number 49857 5989069.54890365 2102231.72490285 37.7516977731236 -122.480684653834 (37.7516977731236, -122.480684653834) 1 8 3 29491 35
193218 4054 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2957 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/1999 12:00:00 AM 3 3X3   6009770.62771 2100537.88813 37.7482282977114 -122.408977781708 (37.7482282977114, -122.408977781708) 2 4 7 28859 2
193161 239434 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 641 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002846.37462 2095677.38762 37.734492180455 -122.432574491237 (37.734492180455, -122.432574491237) 2 7 5 63 7
193127 135962 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2600 Divisadero St 12 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6000720.81325 2117333.08986 37.7938326156312 -122.441476699387 (37.7938326156312, -122.441476699387) 13 9 1 57 27
192977 179005 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 500 Paris St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6001802.30971 2090646.62638 37.7206195902147 -122.435824335343 (37.7206195902147, -122.435824335343) 9 7 6 28861 5
192966 237178 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 102 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6010211.56612 2100240.61937 37.7474367531234 -122.407432068339 (37.7474367531234, -122.407432068339) 2 7 7 28859 2
192955 239529 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 85 Wool St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007405.60756 2097821.43374 37.7406367560843 -122.416963533051 (37.7406367560843, -122.416963533051) 2 7 7 28859 2
192951 106990 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1737-1795 Post St 13 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2014 02:15:00 PM 3     6003734.5 2114103.2 37.7851353863698 -122.430818459211 (37.7851353863698, -122.430818459211) 13 9 11 29490 13
192928 237124 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1025 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6008637.74753 2102555.44614 37.7537045340508 -122.413037896084 (37.7537045340508, -122.413037896084) 2 4 7 28859 19
192905 56621 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1120 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2012 12:00:00 AM     Permit Number 769116 6001921.73131937 2100826.98518644 37.7485792926383 -122.436139672143 (37.7485792926383, -122.436139672143) 2 4 5 28862 22
192904 238222 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 209 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004148.77666 2102090.97951 37.7521762018776 -122.428528663484 (37.7521762018776, -122.428528663484) 2 4 5 28862 22
192887 238107 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 149 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6006184.05234 2102126.82183 37.7523895840278 -122.421492901086 (37.7523895840278, -122.421492901086) 2 4 5 28859 19
192804 237270 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Moultrie St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007691.78832 2097311.69538 37.7392532210546 -122.415937938991 (37.7392532210546, -122.415937938991) 2 7 7 28859 2
192795 54425 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 664 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1972 12:00:00 AM 10   Permit Number 10199 6012377.17429 2104832.12129 37.7601649920327 -122.400265927655 (37.7601649920327, -122.400265927655) 10 3 8 28856 29
192701 99889 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646@ Whipple Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25
192696 238273 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4134 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002159.93034 2104730.60743 37.7593112359535 -122.435595213262 (37.7593112359535, -122.435595213262) 2 4 5 28862 3
192680 103498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1850X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2014 12:00:00 AM 1 3x3 Permit Number 771036 5989807.55073 2110619.14229 37.7747702228876 -122.478745931564 (37.7747702228876, -122.478745931564) 11 6 2 55 26
192622 214652 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 306 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993036.75439 2103256.19316 37.7547404775 -122.467040126413 (37.7547404775, -122.467040126413) 1 8 4 56 12
192611 114543 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011964.29912 2103715.17017 37.7570750599871 -122.401615369369 (37.7570750599871, -122.401615369369) 10 3 8 28856 29
192603 50228 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 741 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/2003 12:00:00 AM 5   Permit Number 46935 5987844.86264 2110914.45258 37.7754669057327 -122.485556863724 (37.7754669057327, -122.485556863724) 11 6 2 55 26
192558 214766 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Alton Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5993866.28574 2101627.27037 37.7503157185921 -122.464053162237 (37.7503157185921, -122.464053162237) 1 8 4 29491 40
192544 239473 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 192 Upper Ter 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5999645.38119 2106544.57309 37.7641487935566 -122.444422080731 (37.7641487935566, -122.444422080731) 15 5 5 29492 9
192533 237373 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009218.81749 2102679.40367 37.7540774954946 -122.41103717252 (37.7540774954946, -122.41103717252) 2 4 7 28859 19
192369 238167 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 950 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003106.03405 2102661.1372 37.7536826553521 -122.432175338843 (37.7536826553521, -122.432175338843) 2 4 5 28862 22
192366 38239 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 81 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1998 12:00:00 AM 11   Permit Number 40353 6010121.79913 2110806.9834 37.7764445709857 -122.408487702448 (37.7764445709857, -122.408487702448) 8 2 9 28853 34
192359 135959 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2980 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5999366.62942 2117378.52806 37.793880135816 -122.446165554106 (37.793880135816, -122.446165554106) 13 9 1 57 27
192346 94665 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 113 Cuvier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53802 6004019 2095233 37.7333384216066 -122.428488672198 (37.7333384216066, -122.428488672198) 9 7 5 28861 25
192316 47519 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 250 Santa Rosa Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45392 6000921.51016478 2093527.18016994 37.728478861528 -122.439075316563 (37.728478861528, -122.439075316563) 9 7 6 28861 25
192315 237241 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 467 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5998529.49857 2106472.57998 37.7638873867061 -122.448276395158 (37.7638873867061, -122.448276395158) 15 5 11 29492 9
192289 50606 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 219 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2003 12:00:00 AM 7   Permit Number 47205 5994896.0666 2113978.53623 37.784288365195 -122.461387423321 (37.784288365195, -122.461387423321) 11 6 2 54 11
192272 115301 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 333 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2016 12:00:00 AM     Permit Number 775906 5992046.2 2097184.7 37.738012491984 -122.470023644047 (37.738012491984, -122.470023644047) 1 8 4 59 40
192256 35253 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2250 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/17/1998 12:00:00 AM 16   Permit Number 38739 6008088.43141 2120207.50426 37.8021420203875 -122.416187651964 (37.8021420203875, -122.416187651964) 5 1 10 308 32
192165 106875 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3200X Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2014 12:00:00 AM 9 3x3 Permit Number 772880 5999376.01262 2115702.70086 37.7892792923525 -122.446012495778 (37.7892792923525, -122.446012495778) 13 6 1 29490 31
192055 214821 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 481 Flood Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5997537.28609 2094088.45494 37.729826844835 -122.450815148913 (37.729826844835, -122.450815148913) 9 7 4 28861 40
192046 102844 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1471 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/2013 12:00:00 AM   3x3 Permit Number 770146 6003321 2099676 37.7454983546222 -122.431218877952 (37.7454983546222, -122.431218877952) 2 7 5 63 22
192027 196459 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1760 Cesar Chavez St 5 : Tree Private 2     5 Width 2ft   6013796.36432 2101069.01684 37.7499113519264 -122.395093999398 (37.7499113519264, -122.395093999398) 10 3 8 58 1
191933 91991 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1381 09th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/23/2009 12:00:00 AM 3 3x3   5993317.352604 2106094.279467 37.7625493164634 -122.466275994064 (37.7625493164634, -122.466275994064) 1 8 11 56 12
191927 238330 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 246 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002691.78046 2104466.49417 37.7586162380656 -122.433736942321 (37.7586162380656, -122.433736942321) 2 4 5 28862 3
191921 14624 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 14 Matthew Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1998 12:00:00 AM 6 3X4   6018000.3078284 2094247.4364445 37.7314135402286 -122.380082436697 (37.7314135402286, -122.380082436697) 10 3 8 58 1
191885 238084 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 673 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009779.10173 2098199.02126 37.7418067560729 -122.408783495762 (37.7418067560729, -122.408783495762) 10 7 7 28859 2
191876 196439 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6015016.02089 2101171.05558 37.7502592780626 -122.390883463504 (37.7502592780626, -122.390883463504) 10 3 8 28856 1
191795 238503 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 68 Wilder St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002672.92744 2095557.23 37.7341524174814 -122.433165572429 (37.7341524174814, -122.433165572429) 2 7 5 63 7
191775 94799 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2495@Ulloa 23rd Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM     Permit Number 767295 5989187.3 2098380.9 37.741131264018 -122.479995678002 (37.741131264018, -122.479995678002) 1 8 3 29491 35
191718 239535 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6007214.41178 2097683.04521 37.7402460150284 -122.417614810389 (37.7402460150284, -122.417614810389) 2 7 7 28859 2
191703 104979 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 423 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 2x3   6011155.37894 2112276.30906 37.7805368262604 -122.405015718617 (37.7805368262604, -122.405015718617) 14 2 9 28853 34
191702 213592 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2038 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993203.16917 2101587.87617 37.7501693125627 -122.466343382053 (37.7501693125627, -122.466343382053) 1 8 4 29491 40
191658 214557 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1138 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992182.77942 2106630.32651 37.7639556317565 -122.4702390716 (37.7639556317565, -122.4702390716) 11 8 11 56 12
191654 102036 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3601X Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 52501 6012999.572 2089254.628 37.7174271437906 -122.397021097837 (37.7174271437906, -122.397021097837) 10 3 8 58 1
191627 178987 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 438 Delano Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5999543.39819 2091383.90085 37.722515400656 -122.443685595329 (37.722515400656, -122.443685595329) 9 7 6 28861 25
191604 50298 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2909 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/2004 12:00:00 AM 6   Permit Number 47009 5989047.46422 2095832.25514 37.7341252202046 -122.48029267727 (37.7341252202046, -122.48029267727) 1 8 4 64 35
191463 85006 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 850 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49366 6010976 2110190 37.7747982776561 -122.40548930108 (37.7747982776561, -122.40548930108) 14 2 9 28853 34
191438 47481 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1809 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 7   Permit Number 45377 5999494.32332 2115164.49026 37.7878082622913 -122.445564438253 (37.7878082622913, -122.445564438253) 13 6 1 29490 31
191393 36 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 773 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6003693.31613 2107706.24814 37.7675686032223 -122.430504342717 (37.7675686032223, -122.430504342717) 7 9 5 28862 3
191337 79376 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 683 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM 3 3x3 Permit Number 52671 5983799.61702 2111191.23616 37.7759903525694 -122.499570569578 (37.7759903525694, -122.499570569578) 11 6 2 55 26
191288 238246 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3841 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003994.77157 2105366.69296 37.7611618194852 -122.429294799534 (37.7611618194852, -122.429294799534) 2 4 5 28862 3
191250 135953 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2104 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6000948.49534 2115676.42691 37.7892968192312 -122.440570020904 (37.7892968192312, -122.440570020904) 13 6 1 29490 27
191235 88420 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51386 6009510 2116776 37.7927997823299 -122.411025804578 (37.7927997823299, -122.411025804578) 3 1 10 28857 21
191170 46257 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1409 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2002 12:00:00 AM 10 3x3 Permit Number 44541 5992686.9 2105815.5 37.7617474653886 -122.46843619791 (37.7617474653886, -122.46843619791) 1 8 4 56 12
191168 214561 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1410 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991361.03473 2106601.03714 37.7638276681257 -122.473079077556 (37.7638276681257, -122.473079077556) 11 8 11 56 12
190897 49743 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 114 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 8   Permit Number 46542 6010621.23603 2087831.01483 37.7133855110935 -122.405141759495 (37.7133855110935, -122.405141759495) 9 7 8 309 39
190791 237201 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 225 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6004272.78183 2099243.31496 37.7443641923478 -122.427896939189 (37.7443641923478, -122.427896939189) 2 7 5 63 22
190720 238502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 144 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6003801.02731 2097515.16828 37.7395923994732 -122.429404953883 (37.7395923994732, -122.429404953883) 2 7 5 63 7
190559 237233 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 110 Carmel St 2 Sidewalk: Curb side : Pot Tree Private 2     7 Width 3ft   5998197.90052 2105385.612 37.7608838831125 -122.449344967798 (37.7608838831125, -122.449344967798) 15 5 11 29492 12
190551 99776 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800x Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 4205 24th St corner property 6001819.1 2101713.8 37.7510084437682 -122.436558035286 (37.7510084437682, -122.436558035286) 2 4 5 28862 22
190502 37342 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 507 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 15   Permit Number 39850 5999504.92576 2086983.76919 37.7104314441222 -122.443502666028 (37.7104314441222, -122.443502666028) 9 7 6 28861 5
190498 239401 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 338 Hoffman Ave 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   6000615.63827 2101746.41589 37.7510295374914 -122.440722053988 (37.7510295374914, -122.440722053988) 2 4 5 28862 22
190473 69303 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 813 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/2014 12:00:00 AM 6   Permit Number 770956 5999968.796 2111801.6454 37.7786018352438 -122.443681177953 (37.7786018352438, -122.443681177953) 15 5 11 29490 16
190461 239521 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Putnam St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009178.34843 2097439.10396 37.7396865216048 -122.410807054895 (37.7396865216048, -122.410807054895) 10 7 7 28859 2
190417 59830 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 338 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2015 12:00:00 AM 3 3x3 Permit Number 774862 6006503.62307489 2104130.4907972 37.7579092104441 -122.420529986932 (37.7579092104441, -122.420529986932) 2 4 7 28859 19
190365 237402 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 57 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6005879.67082 2102263.49254 37.7527476832626 -122.422555214468 (37.7527476832626, -122.422555214468) 2 4 5 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);