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)
190291 213522 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995639.49669 2093392.93286 37.7278082877035 -122.457325684754 (37.7278082877035, -122.457325684754) 9 7 4 28861 40
190269 237202 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 300 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003860.21691 2099267.14708 37.7444062815193 -122.429325201109 (37.7444062815193, -122.429325201109) 2 7 5 63 22
190259 237370 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1429 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6009322.80718 2100850.01678 37.7490602380523 -122.410548375712 (37.7490602380523, -122.410548375712) 2 4 7 28859 19
190227 96081 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 790 41st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2011 12:00:00 AM 1 3x3 Permit Number 767704 5983251.84023 2110453.37841 37.773932253218 -122.501410848383 (37.773932253218, -122.501410848383) 11 6 2 55 26
190218 238496 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1716 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003948.65821 2098247.39872 37.7416112938229 -122.428946700751 (37.7416112938229, -122.428946700751) 2 7 5 63 7
190180 42715 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 43 Pomona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 10   Permit Number 42728 6014158.74539 2094459.12789 37.7317821166448 -122.393378351035 (37.7317821166448, -122.393378351035) 10 3 8 58 1
190142 68954 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 754 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 3   Permit Number 32943 5988851.01728 2110187.80327 37.7735302992339 -122.482023133058 (37.7735302992339, -122.482023133058) 11 6 2 55 26
190138 179023 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 947 Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008910.54006 2090367.60541 37.7202546776964 -122.411233621349 (37.7202546776964, -122.411233621349) 9 3 7 309 28
190131 214615 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1381 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5993310.7573 2106091.15894 37.7625403677758 -122.466298577838 (37.7625403677758, -122.466298577838) 1 8 11 56 12
190120 86213 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2487 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2007 12:00:00 AM 3 3x3   5988895.867106 2098417.748537 37.7412155036968 -122.481006033613 (37.7412155036968, -122.481006033613) 1 8 3 29491 35
190080 196481 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2075 Palou Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 7ft   6012348.97653 2097093.78891 37.738915629056 -122.399820067148 (37.738915629056, -122.399820067148) 10 3 8 58 1
190060 104076 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340X Juanita Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     2x3   5995047.73702 2097534.72021 37.7391466176195 -122.459671261566 (37.7391466176195, -122.459671261566) 9 7 4 59 40
190038 43317 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 263 Athens St 2 Sidewalk: Property side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 3 3x3 Permit Number 51344 6004450.31399 2091734.8767 37.7237577510972 -122.426748470773 (37.7237577510972, -122.426748470773) 9 7 6 28861 5
190010 45578 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 325 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM 6   Permit Number 44318 5998557.11063 2115405.08726 37.7884153280452 -122.448824341269 (37.7884153280452, -122.448824341269) 13 6 1 54 31
190003 214564 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1500 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991061.99419 2106591.75351 37.763784859493 -122.47411268006 (37.763784859493, -122.47411268006) 11 8 11 56 12
189928 8486 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1900X Geary Blvd 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/15/2006 12:00:00 AM 3 3X3   6002632.5922648 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971) 13 9 11 29490 13
189926 214738 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 169 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5995625.76587 2093824.24438 37.7289917766278 -122.457404343046 (37.7289917766278, -122.457404343046) 9 7 4 28861 40
189925 237101 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1 Dearborn St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005826.7194 2106021.63498 37.7630636778686 -122.423005419568 (37.7630636778686, -122.423005419568) 8 4 5 28859 19
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
189812 237371 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1123 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 5x8   6009231.77106 2102473.88108 37.753513902957 -122.410977860458 (37.753513902957, -122.410977860458) 2 4 7 28859 19
189789 238250 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3866 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003891.49124 2104823.9004 37.7596655931054 -122.429613289016 (37.7596655931054, -122.429613289016) 2 4 5 28862 3
189754 196482 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Bridgeview Dr 1 : Tree Private 2     5 Width 2ft   6012916.33928 2095157.16046 37.7336296640747 -122.39772257563 (37.7336296640747, -122.39772257563) 10 3 8 58 1
189708 239528 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1304 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009160.31566 2097453.89362 37.7397261196631 -122.410870449031 (37.7397261196631, -122.410870449031) 10 7 7 28859 2
189691 213342 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 442 Vernon St 2 : Tree Private 2     10 Width 3ft   5992492.2832 2090792.26428 37.7204862252464 -122.468016479897 (37.7204862252464, -122.468016479897) 9 8 6 64 24
189602 94876 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 48 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53945 6011636 2095053 37.7332722799512 -122.402141786329 (37.7332722799512, -122.402141786329) 10 3 8 58 1
189491 238163 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3888 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002568.78071 2102996.86313 37.754574003112 -122.434057276326 (37.754574003112, -122.434057276326) 2 4 5 28862 22
189431 179142 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Woolsey St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011536.91523 2092140.59723 37.7252698963774 -122.402279652698 (37.7252698963774, -122.402279652698) 10 3 7 309 28
189281 239403 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 338 Hoffman Ave 10 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   6000617.55151 2101735.06623 37.7509984830156 -122.440714623806 (37.7509984830156, -122.440714623806) 2 4 5 28862 22
189233 95691 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767442 5997236 2108822 37.7702642586668 -122.452919787946 (37.7702642586668, -122.452919787946) 15 5 11 29492 9
189198 47005 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 124 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2002 12:00:00 AM     Permit Number 45003 6004800.11223501 2108943.4032863 37.77102816901 -122.426764190216 (37.77102816901, -122.426764190216) 7 9 5 28852 10
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
189169 103788 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99X Fern St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6007061.73741 2115197.31568 37.7883275106802 -122.41938487644 (37.7883275106802, -122.41938487644) 13 9 10 28858 21
189116 214480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1406 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   5990546.58136 2105796.37428 37.7615710910435 -122.475837228101 (37.7615710910435, -122.475837228101) 1 8 4 56 12
189074 213640 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 32 Malta Dr 22 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5999549.40588 2096053.53053 37.7353374595456 -122.444000182688 (37.7353374595456, -122.444000182688) 9 7 4 63 40
189012 213387 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1818 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5993154.76021 2103068.62065 37.7542322625174 -122.466618400145 (37.7542322625174, -122.466618400145) 1 8 4 56 12
188955 43281 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 731 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2000 12:00:00 AM 9   Permit Number 43050 6009296.58944 2092411.79299 37.7258892316024 -122.410043408191 (37.7258892316024, -122.410043408191) 9 3 7 309 28
188903 213368 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1590 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1998 12:00:00 AM 8 Width 3ft Permit Number 38628 5992480.65426 2104648.2196 37.7585305048007 -122.469064557877 (37.7585305048007, -122.469064557877) 1 8 4 56 12
188878 213488 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995426.39984 2094264.81715 37.7301900297225 -122.458125434766 (37.7301900297225, -122.458125434766) 9 7 4 28861 40
188875 213562 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 145 Hazelwood Ave 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5996449.59751 2094511.04667 37.7309248558938 -122.454605908258 (37.7309248558938, -122.454605908258) 9 7 4 28861 40
188862 238242 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 185 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003074.67279 2105029.92031 37.7601849902558 -122.432452970336 (37.7601849902558, -122.432452970336) 2 4 5 28862 3
188833 62202 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 29 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1985 12:00:00 AM 16   Permit Number 22322 6000871.44377 2091886.89896 37.7239721755559 -122.439130885281 (37.7239721755559, -122.439130885281) 9 7 6 28861 25
188805 91888 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1104 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 02/18/2009 12:00:00 AM 3 3x3   5992367.653968 2106623.490856 37.763947549515 -122.469599153768 (37.763947549515, -122.469599153768) 11 8 11 56 12
188794 108402 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1285 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2014 12:00:00 AM 3 3x3 Permit Number 772748 6010079.79191 2101731.52319 37.7515230698123 -122.407992860037 (37.7515230698123, -122.407992860037) 2 4 7 28859 19
188709 106920 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1     6006764 2107336 37.76672546023 -122.419856949025 (37.76672546023, -122.419856949025) 8 4 7 28853 19
188684 214834 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1223 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995042.942 2092029.67306 37.7240308230599 -122.459289291479 (37.7240308230599, -122.459289291479) 9 8 4 28861 24
188606 213455 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 305 Dorantes Ave 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5993130.50239 2099670.13691 37.744899496713 -122.466455299074 (37.744899496713, -122.466455299074) 1 8 4 29491 40
188589 66638 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 952-956 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3   Permit Number 772673 6010185.68090669 2103671.40205978 37.7568554734734 -122.407763452505 (37.7568554734734, -122.407763452505) 2 4 7 28859 19
188480 238298 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4315 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001600.66613 2105234.95586 37.7606642731648 -122.437565535242 (37.7606642731648, -122.437565535242) 2 4 5 28862 3
188469 238455 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 82 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002623.005 2108745.80631 37.7703622851278 -122.434280734471 (37.7703622851278, -122.434280734471) 15 5 5 29492 9
188468 237337 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 124 Ellert St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6007298.22515 2096977.17548 37.7383125688774 -122.417275008733 (37.7383125688774, -122.417275008733) 2 7 7 28859 2
188456 4104 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3330 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/17/1999 12:00:00 AM 3 3X3   6007482.20732 2100611.45835 37.7483018487579 -122.416896303343 (37.7483018487579, -122.416896303343) 2 4 7 28859 19
188387 86539 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1719 27th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/27/2006 12:00:00 AM 3 3x3   5987787.197497 2103588.458912 37.7553483843071 -122.485218677787 (37.7553483843071, -122.485218677787) 1 8 3 56 35
188362 238422 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 39 Ord St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000862.68048 2106132.31447 37.7630862130923 -122.440182239531 (37.7630862130923, -122.440182239531) 15 5 5 28862 3
188328 214548 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW 06/17/2015 12:00:00 AM 1 Width 4ft Permit Number 768500 5993241.50872 2106665.18013 37.7641124834295 -122.46657980664 (37.7641124834295, -122.46657980664) 11 8 11 56 12
188280 238058 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 216 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006774.03607 2098239.1296 37.7417481085947 -122.419176891418 (37.7417481085947, -122.419176891418) 2 7 7 28859 2
188242 58294 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 381 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/11/2009 12:00:00 AM   3x3 Permit Number 52608 6002968.92974236 2106036.66958694 37.7629432841861 -122.432890609259 (37.7629432841861, -122.432890609259) 15 4 5 28862 3
188159 103814 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99X Hemlock St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006931.25215 2114822.01169 37.7872896682178 -122.41980969397 (37.7872896682178, -122.41980969397) 13 9 10 28858 21
188115 104360 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 57 Stillman St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013954.4 2112927.1 37.7824798185974 -122.39537811084 (37.7824798185974, -122.39537811084) 6 2 9 28856 6
188046 104253 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8X Octavia St Frontage East 7 Sidewalk: Curb side : Cutout Tree DPW 1     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533) 7 2 11 28852 10
188022 213551 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 159 Valdez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996188.75737 2094532.85187 37.7309697635433 -122.455509245751 (37.7309697635433, -122.455509245751) 9 7 4 28861 40
187971 95992 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 858 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767644 5986371.40114 2110056.12968 37.7730242344515 -122.490590683906 (37.7730242344515, -122.490590683906) 11 6 2 55 26
187895 239399 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 338 Hoffman Ave 7 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   6000615.20196 2101754.98366 37.751053037676 -122.44072417729 (37.751053037676, -122.44072417729) 2 4 5 28862 22
187819 106551 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 203 Los Palmos Dr   Sidewalk: Curb side : Cutout Tree Private 2       2.5X4 Permit Number 58742 5998066.5 2096226.6 37.7357279634759 -122.449139578572 (37.7357279634759, -122.449139578572) 9 7 4 59 40
187812 102171 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 9X Hattie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809) 15 5 5 28862 3
187810 4031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/06/2015 02:05:00 PM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
187774 238203 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3977 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 5x6   6003360.67641 2101824.39279 37.7513995869453 -122.4312350068 (37.7513995869453, -122.4312350068) 2 4 5 28862 22
187708 214703 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 520 Darien Way 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5992960.17778 2094882.50244 37.7317440249629 -122.4666962976 (37.7317440249629, -122.4666962976) 9 8 4 59 40
187615 239429 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 565 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM 5 Width 2ft Permit Number 51470 6001213.70363 2103034.08129 37.7545991976029 -122.438746149019 (37.7545991976029, -122.438746149019) 2 4 5 28862 22
187567 238509 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 306 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6004358.32259 2096414.34747 37.7366013316931 -122.427399667156 (37.7366013316931, -122.427399667156) 2 7 5 63 7
187556 237294 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3764 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6008418.8045 2097374.13847 37.739465523113 -122.413428648806 (37.739465523113, -122.413428648806) 2 7 7 28859 2
187544 50504 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 671 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM 9   Permit Number 47140 6001297.56946 2089761.94857 37.7181617790314 -122.437505740198 (37.7181617790314, -122.437505740198) 9 7 6 28861 5
187542 213354 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 142 Garfield St 1 : Tree Private 2     3 Width 3ft   5993565.63371 2090507.60393 37.7197665436602 -122.464285624407 (37.7197665436602, -122.464285624407) 9 8 6 64 24
187325 238342 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 219 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002084.58101 2104567.61899 37.7588594291365 -122.435844145591 (37.7588594291365, -122.435844145591) 2 4 5 28862 3
187252 246498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 313 Duncan St 1 : Tree Private 2     4 Width 3ft   6004359.59327 2099835.65026 37.7459955193923 -122.42763895699 (37.7459955193923, -122.42763895699) 2 7 5 63 22
187250 21662 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1750 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2015 12:00:00 AM 3 4X4 Permit Number 774105 6004219.9241 2114651.242 37.7866676632245 -122.429178134342 (37.7866676632245, -122.429178134342) 13 9 11 29490 27
187249 237244 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 91 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5998158.2745 2107170.05749 37.7657812537214 -122.449610604152 (37.7657812537214, -122.449610604152) 15 5 11 29492 9
187225 37725 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 75 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 770874 6002405.30455981 2096579.06253335 37.7369429497362 -122.434163852172 (37.7369429497362, -122.434163852172) 2 7 5 63 7
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
187176 34523 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 586 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1997 12:00:00 AM 8   Permit Number 38233 6010643.98093 2105619.91693 37.7622313040582 -122.40631575879 (37.7622313040582, -122.40631575879) 8 4 8 28859 19
187166 92430 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1758 41st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2009 12:00:00 AM   3x3 Permit Number 52821 5983521.6 2103180.6 37.7539791070225 -122.499940017573 (37.7539791070225, -122.499940017573) 1 8 3 56 35
187162 213483 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200 Magellan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994968.55628 2100619.47305 37.7476120264893 -122.460168457927 (37.7476120264893, -122.460168457927) 1 8 4 29491 40
187056 214741 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 149 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5995646.65866 2093691.63994 37.7286288768052 -122.457322526337 (37.7286288768052, -122.457322526337) 9 7 4 28861 40
187035 31446 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 239 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1995 12:00:00 AM 7   Permit Number 35021 6002088.5838 2104465.22029 37.7585784944253 -122.435822975577 (37.7585784944253, -122.435822975577) 2 4 5 28862 3
187034 214649 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 16 Hillway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996114.56342 2106803.43322 37.7646574671859 -122.456652805703 (37.7646574671859, -122.456652805703) 15 5 11 29492 12
187026 86868 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 602 Randolph St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2007 12:00:00 AM   3x3 Permit Number 49803 5992443 2088555 37.7143403939216 -122.468024182233 (37.7143403939216, -122.468024182233) 9 8 6 64 24
187006 51965 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 624 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/2005 12:00:00 AM     Permit Number 48186 6004986.46742486 2111098.21623731 37.7769552960255 -122.426273020817 (37.7769552960255, -122.426273020817) 7 9 11 28852 10
186934 239510 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 402 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008765.7261 2096876.23159 37.7381178521643 -122.412193960581 (37.7381178521643, -122.412193960581) 10 7 7 28859 2
186883 67219 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 433 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1992 12:00:00 AM   3x3 Permit Number 772588 6003633.80184801 2108969.08064564 37.771032662095 -122.430800325407 (37.771032662095, -122.430800325407) 15 9 11 29492 10
186866 213502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 799 Faxon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5994882.72041 2093271.23079 37.7274306282098 -122.459933045084 (37.7274306282098, -122.459933045084) 9 7 4 28861 40
186828 237214 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004332.80938 2099540.38769 37.7451832813937 -122.427710538533 (37.7451832813937, -122.427710538533) 2 7 5 63 22
186786 214527 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 843 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993074.14838 2106598.7512 37.7639204278081 -122.467153822304 (37.7639204278081, -122.467153822304) 1 8 11 56 12
186778 213386 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1846 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993160.52883 2102907.84462 37.7537911459483 -122.466586765563 (37.7537911459483, -122.466586765563) 1 8 4 56 12
186760 28351 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3168 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2001 12:00:00 AM 3 3X3   6008614.0192907 2100617.9154502 37.7483831772452 -122.412982970428 (37.7483831772452, -122.412982970428) 2 4 7 28859 19
186754 86249 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2266 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2006 12:00:00 AM 3 3x3   5988574.227066 2099899.242089 37.7452645932744 -122.482226651217 (37.7452645932744, -122.482226651217) 1 8 3 29491 35
186735 238267 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4080 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002464.90163 2104746.35591 37.7593717944886 -122.434541601739 (37.7593717944886, -122.434541601739) 2 4 5 28862 3
186732 238074 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 131 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007150.37364 2097131.45657 37.7387278712849 -122.417797140718 (37.7387278712849, -122.417797140718) 2 7 7 28859 2
186661 237062 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 189 Tiffany Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6006064.26727 2099183.21264 37.7443003503954 -122.421698080498 (37.7443003503954, -122.421698080498) 2 7 7 28859 2
186643 121594 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 68X Wilder St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6002713 2095655 37.7344231446599 -122.433034012036 (37.7344231446599, -122.433034012036) 2 7 5 63 7
186587 47518 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 250 Santa Rosa Ave 2 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
186392 213453 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 305 Dorantes Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993154.52454 2099672.26971 37.7449067389721 -122.466372390591 (37.7449067389721, -122.466372390591) 1 8 4 29491 40

Next page

Advanced export

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

CSV options:

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