Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18 sorted by PlantDate descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▲ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
97285 102172 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 9X Hattie St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621.0 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809)
143029 102171 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 9X Hattie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621.0 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809)
81443 100355 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 Waller St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   12/30/2014 12:00:00 AM 3 27x6 Permit Number 769031 6002899.6 2108847.2 37.770656382716396 -122.43333123962 (37.7706563827164, -122.43333123962)
87786 105728 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 82-98X Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772582 6002862.0 2108710.0 37.7702775320686 -122.43345149235701 (37.7702775320686, -122.433451492357)
111761 105729 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 82-98X Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772582 6002862.0 2108710.0 37.7702775320686 -122.43345149235701 (37.7702775320686, -122.433451492357)
139650 108635 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Lake St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774602 5987336.48113 2114673.56953 37.7857587403195 -122.487591667787 (37.7857587403195, -122.487591667787)
145525 108648 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 196 Lippard Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774607 6001751.75522 2094959.06379 37.7324576925005 -122.436307555189 (37.7324576925005, -122.436307555189)
17623 4137 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3550 Cesar Chavez St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/30/2000 12:00:00 AM 3 3x3   6006233.57538 2100604.08317 37.7482112843407 -122.421213523093 (37.7482112843407, -122.421213523093)
20694 4134 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3550 Cesar Chavez St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/30/2000 12:00:00 AM 3 3x3   6006304.68418 2100605.7275799997 37.7482198080922 -122.42096774735901 (37.7482198080922, -122.420967747359)
121180 41272 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 516 Foerster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/30/1999 12:00:00 AM     Permit Number 41955 5998145.81312844 2095035.80887782 37.7324628706429 -122.448779620072 (37.7324628706429, -122.448779620072)
69506 51979 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 201 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2015 12:00:00 AM 7 3x3 Permit Number 775837 6000531.055869999 2092082.3650200001 37.7244895060779 -122.440321560704 (37.7244895060779, -122.440321560704)
8180 21666 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1765 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2014 12:00:00 AM 3 4X4 Permit Number 774582 6004178.5577 2114595.027 37.7865109691436 -122.42931724201799 (37.7865109691436, -122.429317242018)
10801 83237 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2012 12:00:00 AM 4 3x3 Permit Number 769756 6004043.10746 2093201.4009 37.727761469894794 -122.42826058457099 (37.7277614698948, -122.428260584571)
97679 86443 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2450 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 12/29/2006 12:00:00 AM 3 3x3   5987997.37774 2098622.10748 37.741724349066 -122.484127634313 (37.741724349066, -122.484127634313)
143250 86436 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2574 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/29/2006 12:00:00 AM 3 3x3   5988026.00444 2097787.2202669997 37.7394336348182 -122.48396744726001 (37.7394336348182, -122.48396744726)
139783 39603 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 636 Wisconsin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1998 12:00:00 AM 10   Permit Number 41005 6012670.17637 2104503.85017 37.759279965615704 -122.39922952194401 (37.7592799656157, -122.399229521944)
40751 68941 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 730 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 32928 5989462.36102 2110347.5276900004 37.774004395159295 -122.479920119491 (37.7740043951593, -122.479920119491)
42627 68954 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 754 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 3   Permit Number 32943 5988851.01728 2110187.80327 37.7735302992339 -122.482023133058 (37.7735302992339, -122.482023133058)
59592 68878 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 535 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 9   Permit Number 32849 5994664.33554 2111876.7239 37.778504013274 -122.462036654628 (37.778504013274, -122.462036654628)
101603 68962 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2302 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 5 3x3 Permit Number 32951 5988444.16962 2110572.72123 37.7745635062345 -122.483458685783 (37.7745635062345, -122.483458685783)
135870 68953 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 750 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 3 3x3 Permit Number 32942 5988850.38114 2110206.21118 37.7735808052559 -122.48202668229901 (37.7735808052559, -122.482026682299)
161168 68950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 734 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 32939 5988846.075 2110312.98983 37.7738737393837 -122.482049401575 (37.7738737393837, -122.482049401575)
165599 68952 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 747 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 3   Permit Number 32941 5988797.45218 2110217.11495 37.7736076654938 -122.482210568345 (37.7736076654938, -122.482210568345)
170838 68956 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 874 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 7   Permit Number 32945 5988542.5052 2110035.3324599997 37.7730937088544 -122.483079131422 (37.7730937088544, -122.483079131422)
9780 65693 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3779 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2016 12:00:00 AM 3 4x4 Permit Number 779357 6005288.42845233 2101344.00549356 37.7501896116955 -122.424534439725 (37.7501896116955, -122.424534439725)
13234 82735 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 174 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2012 12:00:00 AM 5 4x4 Permit Number 769757 6003803.82611 2092820.0296 37.726700767200896 -122.429060604385 (37.7267007672009, -122.429060604385)
103979 95132 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 201 Capistrano Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2010 12:00:00 AM   3x3 Permit Number 54056 6001204.4 2093241.7 37.7277110907766 -122.438076912641 (37.7277110907766, -122.438076912641)
129425 68081 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 201 Capistrano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2010 12:00:00 AM   3x3 Permit Number 54056 6001211.28738215 2093268.78253612 37.727785844916895 -122.438055042052 (37.7277858449169, -122.438055042052)
38699 52528 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 San Juan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2005 12:00:00 AM 7   Permit Number 48628 6001332.37944 2092272.13723 37.725056169781205 -122.437565081984 (37.7250561697812, -122.437565081984)
173528 39575 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 885 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1998 12:00:00 AM 13   Permit Number 40992 6011619.84178 2104260.65443 37.7585536119741 -122.40284500428999 (37.7585536119741, -122.40284500429)
179064 39571 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 835 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1998 12:00:00 AM 8   Permit Number 40989 6011610.458330001 2104449.8311400004 37.7590725253066 -122.402890761795 (37.7590725253066, -122.402890761795)
20662 84576 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3966 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003390.40048346 2101879.79659646 37.7515533971776 -122.43113617160401 (37.7515533971776, -122.431136171604)
93247 84579 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3930 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003612.12595164 2101892.03490833 37.7515995627601 -122.43037029061001 (37.7515995627601, -122.43037029061)
94175 84667 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4045 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM     Permit Number 769743 6002887.32453677 2101799.94982156 37.7513056360956 -122.432870165781 (37.7513056360956, -122.432870165781)
100725 84674 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4045 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6002887.32453677 2101799.94982156 37.7513056360956 -122.432870165781 (37.7513056360956, -122.432870165781)
103524 84660 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 816 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6001872.13741629 2101710.47895055 37.751002338731 -122.436374389271 (37.751002338731, -122.436374389271)
112631 84578 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3934 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003587.48978851 2101890.6750959 37.751594433496706 -122.430455388545 (37.7515944334967, -122.430455388545)
113773 84575 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3972-3976 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003353.44622149 2101877.75687686 37.7515457024264 -122.431263818404 (37.7515457024264, -122.431263818404)
120819 84577 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3950 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003488.94513598 2101885.23584618 37.75157391582871 -122.430795780168 (37.7515739158287, -122.430795780168)
107220 86544 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1743 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987792.632848 2103431.806163 37.75491857482479 -122.48518838735201 (37.7549185748248, -122.485188387352)
113728 85959 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298X 26TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5988007.0 2106798.0 37.764173712799 -122.484693968894 (37.764173712799, -122.484693968894)
120382 86542 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1731 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987789.915173001 2103510.132538 37.755133479572294 -122.485203532524 (37.7551334795723, -122.485203532524)
141412 86539 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1719 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987787.197497 2103588.458912 37.755348384307105 -122.485218677787 (37.7553483843071, -122.485218677787)
158467 52461 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 686@ CABRILLO 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2005 12:00:00 AM 3   Permit Number 48572 5992267.31152 2110802.49998 37.7754161894068 -122.470250546869 (37.7754161894068, -122.470250546869)
114798 105147 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 52 Mirabel Ave   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.41622057503099 (37.7464458666696, -122.416220575031)
91229 86519 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1309 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/26/2006 12:00:00 AM 3 3x3   5987691.436672 2106370.804533 37.7629823684162 -122.485754041828 (37.7629823684162, -122.485754041828)
98755 47002 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/25/2005 12:00:00 AM     Permit Number 45001 6004750.78049806 2108920.69040717 37.77096301566829 -122.426933212426 (37.7709630156683, -122.426933212426)
11960 108570 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772580 6010210.43031 2095090.8811299999 37.733296619935004 -122.407073064382 (37.733296619935, -122.407073064382)
12716 108567 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450 Hamilton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773758 6009500.29517 2092233.5680799999 37.725411278805296 -122.409326636833 (37.7254112788053, -122.409326636833)
14555 86928 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 838 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/24/2014 12:00:00 AM 3 3x3 Permit Number 774404 6011553.2134300005 2104436.20347 37.759031910124 -122.403087784389 (37.759031910124, -122.403087784389)
142929 108563 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Girard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772473 6010406.15109 2094405.89757 37.7314267509243 -122.406348153233 (37.7314267509243, -122.406348153233)
110438 12424 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1701X Laguna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/23/2015 12:00:00 AM 2 4X4   6004421.35326 2114759.5543400003 37.7869764624576 -122.428488960967 (37.7869764624576, -122.428488960967)
103165 108498 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 762 10th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773796 5992905.3087 2110276.51424 37.774008838888996 -122.468005315635 (37.774008838889, -122.468005315635)
72213 108460 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 944 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773734 6010189.19593 2103716.38941 37.7569791954421 -122.40775446824301 (37.7569791954421, -122.407754468243)
78760 63239 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3620-3622 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773724 6006149.84854852 2104367.47863685 37.7585399802366 -122.421770322909 (37.7585399802366, -122.421770322909)
127421 47277 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2633 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3   Permit Number 773722 6010344.90771607 2104548.95765438 37.7592739569349 -122.40727464517599 (37.7592739569349, -122.407274645176)
141116 66638 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 952-956 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3   Permit Number 772673 6010185.68090669 2103671.40205978 37.756855473473394 -122.407763452505 (37.7568554734734, -122.407763452505)
10479 35851 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 500 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/2016 12:00:00 AM 3 3x3 Permit Number 778923 6001833.39372 2090697.4113200002 37.720760799954206 -122.435720519401 (37.7207607999542, -122.435720519401)
84650 85958 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1300 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988039.866297 2106434.861495 37.7631785479619 -122.48455365718 (37.7631785479619, -122.48455365718)
113189 85956 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1334 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988047.4774629995 2106213.623528 37.762571532243705 -122.484511104656 (37.7625715322437, -122.484511104656)
9712 121497 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 468 Valley St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/20/2016 12:00:00 AM 3 3x3   6002891.0 2099226.0 37.744238382256704 -122.432673610292 (37.7442383822567, -122.432673610292)
9713 121496 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 468 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/20/2016 12:00:00 AM 3 3x3   6002891.0 2099226.0 37.744238382256704 -122.432673610292 (37.7442383822567, -122.432673610292)
79666 86376 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1343 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988009.291975 2106160.192246 37.7624226008214 -122.484639253233 (37.7624226008214, -122.484639253233)
100303 86387 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1515 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988049.8019900005 2104982.6702779997 37.7591918054497 -122.4844127767 (37.7591918054497, -122.4844127767)
120983 86378 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1361 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988013.321416 2106043.0662599998 37.762101239533294 -122.484616725198 (37.7621012395333, -122.484616725198)
144272 86370 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1299X 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5987998.480578 2106474.452955 37.763284845117205 -122.484699699179 (37.7632848451172, -122.484699699179)
11888 108379 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Bertita St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773806 6000690.090969999 2090159.58738 37.7192190489897 -122.439634019098 (37.7192190489897, -122.439634019098)
140778 108402 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1285 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 772748 6010079.79191 2101731.52319 37.7515230698123 -122.407992860037 (37.7515230698123, -122.407992860037)
112154 12805 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2099 Lake St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/19/2003 12:00:00 AM 5 3X3   5989075.33471 2114664.85982 37.7858360879126 -122.48157515850401 (37.7858360879126, -122.481575158504)
19466 12753 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1730 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/19/2000 12:00:00 AM 12 3X3   5990048.7235199995 2114754.53717 37.786138867937495 -122.478214101082 (37.7861388679375, -122.478214101082)
74037 62580 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 775 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/2007 12:00:00 AM 4 3x3 Permit Number 50012 6011310.429380001 2104760.0499299997 37.759907559306505 -122.403950240515 (37.7599075593065, -122.403950240515)
81586 85943 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1538 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988095.160504 2104827.59989 37.7587686653948 -122.484244534442 (37.7587686653948, -122.484244534442)
82772 85934 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1630 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988116.725594 2104200.7569 37.7570487799795 -122.484123984508 (37.7570487799795, -122.484123984508)
84020 85942 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1542 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988096.057532 2104801.525596 37.758697124688894 -122.48423951990299 (37.7586971246889, -122.484239519903)
88698 85946 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1490 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988083.436249 2105168.393711 37.7597037099979 -122.48431007589701 (37.7597037099979, -122.484310075897)
108528 85940 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1554 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988098.748614 2104723.302763 37.7584825026991 -122.48422447635599 (37.7584825026991, -122.484224476356)
116951 85937 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600X 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988110.016747 2104395.766944 37.7575838341785 -122.484161486754 (37.7575838341785, -122.484161486754)
138413 86332 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2263 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988533.319976 2099923.8448349996 37.745329766428 -122.482369901671 (37.745329766428, -122.482369901671)
17813 4106 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3359 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/2003 12:00:00 AM 3 3X3   6007379.19247 2100526.00618 37.7480614213048 -122.417246472374 (37.7480614213048, -122.417246472374)
19895 4295 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4342 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/2003 12:00:00 AM 3 3X3   6001671.89746 2100317.83526 37.7471670905043 -122.436967147015 (37.7471670905043, -122.436967147015)
101052 4160 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3739 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/2003 12:00:00 AM 3 4X4   6005605.475964599 2100485.3064168 37.7478497208127 -122.42337703166099 (37.7478497208127, -122.423377031661)
141870 4028 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2150 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/2003 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
145644 102844 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1471 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/2013 12:00:00 AM   3x3 Permit Number 770146 6003321.0 2099676.0 37.7454983546222 -122.431218877952 (37.7454983546222, -122.431218877952)
121235 108310 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1563 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2014 12:00:00 AM 3     5986200.157869999 2104606.03112 37.7580497793679 -122.49078193256099 (37.7580497793679, -122.490781932561)
83935 91902 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1516 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991061.448475 2106578.7477680002 37.7637491175921 -122.474113618488 (37.7637491175921, -122.474113618488)
96954 91903 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1534 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991007.891482 2106576.913236 37.7637409778654 -122.47429871990299 (37.7637409778654, -122.474298719903)
103727 91901 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991109.054689 2106580.378462 37.7637563526576 -122.473949083869 (37.7637563526576, -122.473949083869)
107318 91905 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5990960.285269001 2106575.2825419996 37.7637337423119 -122.47446325445 (37.7637337423119, -122.47446325445)
111226 91896 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1400 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991433.649229 2106591.497285 37.7638056781662 -122.472827232872 (37.7638056781662, -122.472827232872)
118008 91898 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1428 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991346.352841 2106588.506989 37.763792413618106 -122.47312894339198 (37.7637924136181, -122.473128943392)
141011 91897 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1410 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991402.471947 2106590.429322 37.7638009409158 -122.47293498664301 (37.7638009409158, -122.472934986643)
144161 91904 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5990960.285269001 2106575.2825419996 37.7637337423119 -122.47446325445 (37.7637337423119, -122.47446325445)
94546 86392 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1579 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988064.154428 2104565.481775 37.758047154773294 -122.48433254224199 (37.7580471547733, -122.484332542242)
125543 86250 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2242 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988568.6306529995 2100055.451314 37.7456931770541 -122.48225744501998 (37.7456931770541, -122.48225744502)
140305 86249 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2266 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988574.227066 2099899.242089 37.7452645932744 -122.482226651217 (37.7452645932744, -122.482226651217)
17409 4836 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 123 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2000 12:00:00 AM 6 3X3   6006379.67825 2097659.7420099997 37.7401350234134 -122.420499335499 (37.7401350234134, -122.420499335499)
11489 918 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1246 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/14/2000 12:00:00 AM 3 3x6   6002972.02958 2094203.5052200002 37.730452359288996 -122.43203484674801 (37.730452359289, -122.432034846748)
10595 78395 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 367 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/13/2011 12:00:00 AM 3 3x3 Permit Number 768554 5999771.76948 2091747.9413700001 37.723527995008396 -122.442922299331 (37.7235279950084, -122.442922299331)
84968 86321 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988408.134093 2103583.601964 37.7553712008265 -122.483070961912 (37.7553712008265, -122.483070961912)
98643 86320 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1701 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988402.93355 2103727.2102369997 37.755765207864705 -122.483099472181 (37.7557652078647, -122.483099472181)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 1925.989ms · Data source: data.sfgov.org