Street_Tree_List

Data source: data.sfgov.org

14,663 rows where search matches "cherry" sorted by Latitude descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▲ Longitude Location
25716 25716 135893 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 323 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6001843.597519999 2121830.48703 37.806245186226505 -122.437914052191 (37.8062451862265, -122.437914052191)
74939 74939 135892 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 323 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6001823.0897 2121828.5954400003 37.8062388262166 -122.437984887306 (37.8062388262166, -122.437984887306)
159197 159197 44057 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 708 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/19/2000 12:00:00 AM 7   Permit Number 43584 6007279.94096 2121616.88851 37.8059663388498 -122.419085450154 (37.8059663388498, -122.419085450154)
168893 168893 41226 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 155 Retiro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/30/1999 12:00:00 AM 8   Permit Number 41932 6001878.60529 2121714.18401 37.805927839759896 -122.437784566908 (37.8059278397599, -122.437784566908)
5494 5494 87738 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 10 Median : Cutout 11 Tree 1 DPW 2   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217)
8626 8626 87739 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 11 Median : Cutout 11 Tree 1 DPW 2   05/10/2008 12:00:00 AM 3 4x4   6005433.618530001 2121623.41722 37.8058801199389 -122.42547541206699 (37.8058801199389, -122.425475412067)
68012 68012 136610 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 7 Side Yard : Yard 17 Tree 1 Private 1     15 Width 4ft   6002559.08771 2121673.9848 37.805856133210895 -122.43542677652 (37.8058561332109, -122.43542677652)
188021 188021 136609 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 6 Side Yard : Yard 17 Tree 1 Private 1     7 Width 4ft   6002557.10875 2121672.73918 37.805852600677795 -122.435433535844 (37.8058526006778, -122.435433535844)
72627 72627 136608 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 5 Side Yard : Yard 17 Tree 1 Private 1     14 Width 4ft   6002554.72948 2121670.19367 37.8058454762555 -122.435441587454 (37.8058454762555, -122.435441587454)
75463 75463 136607 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 4 Side Yard : Yard 17 Tree 1 Private 1     11 Width 5ft   6002552.02607 2121667.51893 37.8058379785924 -122.435450751546 (37.8058379785924, -122.435450751546)
188746 188746 136606 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 3 Side Yard : Yard 17 Tree 1 Private 1     8 Width 5ft   6002550.09467 2121664.33857 37.8058291364749 -122.43545720778799 (37.8058291364749, -122.435457207788)
52420 52420 136605 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 2 Side Yard : Yard 17 Tree 1 Private 1     10 Width 4ft   6002548.49635 2121661.6698 37.805821717964605 -122.43546254797701 (37.8058217179646, -122.435462547977)
37251 37251 136604 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 1 Side Yard : Yard 17 Tree 1 Private 1     2 Width 2ft   6002548.10466 2121650.0452 37.8057897776435 -122.435463071378 (37.8057897776435, -122.435463071378)
173199 173199 136030 Undocumented 2 Prunus subhirtella 'Pendula' :: Weeping Cherry 370 475 Marina Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6000838.224669999 2121681.08222 37.805777738417795 -122.441382580867 (37.8057777384178, -122.441382580867)
95840 95840 51935 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Bay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2005 12:00:00 AM     Permit Number 48161 6009200.27838208 2121477.92859384 37.805692742557 -122.412429964781 (37.805692742557, -122.412429964781)
42905 42905 51703 Permitted Site 1 Prunus x yedoensis :: Yoshino Cherry 237 54 Casa Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2005 12:00:00 AM 3   Permit Number 47979 6001520.693580001 2121621.59135 37.805653247063 -122.439016533799 (37.805653247063, -122.439016533799)
61737 61737 106161 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 827 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/2014 12:00:00 AM 3 3x3 Permit Number 770049 6006757.57528 2121490.3236599998 37.8055893943007 -122.42088419136499 (37.8055893943007, -122.420884191365)
158495 158495 136603 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 1490 Jefferson St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   6002078.64435 2121585.74714 37.8055865587436 -122.437083100219 (37.8055865587436, -122.437083100219)
176628 176628 41234 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 3743 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/30/1999 12:00:00 AM 5   Permit Number 41939 6002518.8447 2121486.57255 37.805339263172606 -122.435552627664 (37.8053392631726, -122.435552627664)
115727 115727 93018 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 963 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2010 12:00:00 AM   3x3 Permit Number 53140 6006134.0 2121397.0 37.805297983444 -122.42303552725402 (37.805297983444, -122.423035527254)
40934 40934 142736 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 15 VANDEWATER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6009218.8197 2121322.4003 37.805266741303 -122.412354799662 (37.805266741303, -122.412354799662)
133655 133655 112372 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 15 Vandewater St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6009194.601 2121319.3086 37.805256893193494 -122.412438393162 (37.8052568931935, -122.412438393162)
54813 54813 143215 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 215 FRANCISCO ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6010264.7976 2121285.9953 37.805225422298996 -122.408732475128 (37.805225422299, -122.408732475128)
137394 137394 142655 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 55 VANDEWATER ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6009102.8791 2121306.4263 37.8052163739487 -122.412754898161 (37.8052163739487, -122.412754898161)
7662 7662 88451 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.805209901088396 -122.425294529632 (37.8052099010884, -122.425294529632)
187959 187959 88452 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2   06/07/2008 12:00:00 AM 4 5x12   6005470.42698 2121378.16696 37.8052088057127 -122.425330567252 (37.8052088057127, -122.425330567252)
51491 51491 118370 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 55 Vandewater St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 2x2   6009076.084 2121302.8193 37.8052049660579 -122.41284737107901 (37.8052049660579, -122.412847371079)
50875 50875 118368 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 55 Vandewater St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2x2   6009048.7736 2121299.2122 37.8051935288948 -122.412941627226 (37.8051935288948, -122.412941627226)
168116 168116 136592 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3751 Broderick St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5999587.9447800005 2121442.35116 37.8050509432145 -122.445692167157 (37.8050509432145, -122.445692167157)
105255 105255 98564 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301X Francisco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
112530 112530 98567 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301X Francisco St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
123219 123219 98563 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301X Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138890 138890 98565 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301X Francisco St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
136401 136401 136593 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3751 Broderick St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   5999588.18576 2121438.86805 37.8050413932949 -122.445691082582 (37.8050413932949, -122.445691082582)
180397 180397 136594 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3751 Broderick St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5999588.789480001 2121434.9578400003 37.805030691384204 -122.44568871197501 (37.8050306913842, -122.445688711975)
160416 160416 142656 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 382 Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6009478.0111 2121215.2198 37.8049869916815 -122.411450254798 (37.8049869916815, -122.411450254798)
69906 69906 142657 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 392 Francisco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6009464.6135 2121214.7045 37.8049848253291 -122.411496582459 (37.8049848253291, -122.411496582459)
154475 154475 142658 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 396 Francisco St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6009447.6089 2121213.6739 37.8049810417497 -122.411555356166 (37.8049810417497, -122.411555356166)
134214 134214 142744 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 410 FRANCISCO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6009308.9956 2121195.6387 37.804923745513 -122.41203376959 (37.804923745513, -122.41203376959)
4622 4622 142543 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4558 4558 142520 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4611 4611 142519 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4605 4605 142542 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 301 FRANCISCO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
184236 184236 65288 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 41 Rico Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1990 12:00:00 AM 7   Permit Number 28836 6001457.593230001 2121333.88235 37.8048596843835 -122.439214266819 (37.8048596843835, -122.439214266819)
70496 70496 249782 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 115 Pfeiffer St 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 0ft   6010481.39254 2121146.06325 37.804853332490296 -122.40797304381701 (37.8048533324903, -122.407973043817)
170996 170996 136595 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3801 Divisadero St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6000087.86823 2121359.44111 37.804851824321 -122.44395616894501 (37.804851824321, -122.443956168945)
129840 129840 249783 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 115 Pfeiffer St 2 Back Yard : Yard 13 Tree 1 Private 1     4 Width 0ft   6010478.38783 2121144.55662 37.804849027432105 -122.407983335672 (37.8048490274321, -122.407983335672)
57496 57496 136596 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3801 Divisadero St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6000089.42959 2121343.8815599997 37.8048091910506 -122.443949647073 (37.8048091910506, -122.443949647073)
57824 57824 142965 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 111 Pfeiffer St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6010321.3688 2121130.7743 37.8048023922739 -122.40852574641599 (37.8048023922739, -122.408525746416)
164242 164242 136597 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3801 Divisadero St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   6000090.23448 2121338.2924900004 37.804793890882294 -122.443946459857 (37.8047938908823, -122.443946459857)
135712 135712 142964 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 115 Pfeiffer St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6010284.5248 2121125.6441 37.8047862425651 -122.408652887366 (37.8047862425651, -122.408652887366)
137419 137419 142963 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 119 Pfeiffer St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6010263.5377 2121122.3795 37.804776103337296 -122.408725285275 (37.8047761033373, -122.408725285275)
166742 166742 142968 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 123 PFEIFFER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6010234.1558 2121117.7157 37.8047616520024 -122.408826635586 (37.8047616520024, -122.408826635586)
27129 27129 136601 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 1900 Jefferson St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 4ft   6000030.07826 2121297.6398099996 37.80467883793111 -122.444151713048 (37.8046788379311, -122.444151713048)
128967 128967 142540 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2100 POWELL ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6009421.7884 2121061.7254 37.8045623807522 -122.411633968656 (37.8045623807522, -122.411633968656)
186749 186749 136029 Undocumented 2 Prunus subhirtella 'Pendula' :: Weeping Cherry 370 3743 Scott St 1 : 4 Tree 1 Private 1     4 Width 2ft   6000599.31455 2121234.7075799997 37.804538500507995 -122.44217730004101 (37.804538500508, -122.442177300041)
169417 169417 249809 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 8 Back Yard : Yard 13 Tree 1 Private 1     5 Width 0ft   6010708.4562800005 2121025.2354099997 37.804534279087704 -122.407178739215 (37.8045342790877, -122.407178739215)
87567 87567 100981 DPW Maintained 3 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
89035 89035 100982 DPW Maintained 3 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
97910 97910 100983 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 2190 Powell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
107842 107842 100984 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 2190 Powell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
119959 119959 100985 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2190 Powell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
140818 140818 100980 DPW Maintained 3 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145388 145388 100987 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 2190 Powell St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
53839 53839 249807 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 6 Back Yard : Yard 13 Tree 1 Private 1     7 Width 0ft   6010752.11734 2121021.55825 37.8045266258517 -122.407027386026 (37.8045266258517, -122.407027386026)
67735 67735 135944 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1998 Jefferson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5999737.82806 2121247.80693 37.804525333529796 -122.44515948523399 (37.8045253335298, -122.445159485234)
52205 52205 249810 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 9 Back Yard : Yard 13 Tree 1 Private 1     5 Width 0ft   6010696.08755 2121019.21593 37.804517058874396 -122.407221117962 (37.8045170588744, -122.407221117962)
59892 59892 135945 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1998 Jefferson St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5999716.32151 2121244.69535 37.8045155623958 -122.44523368650499 (37.8045155623958, -122.445233686505)
156801 156801 249808 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 7 Back Yard : Yard 13 Tree 1 Private 1     12 Width 0ft   6010714.23144 2121016.75548 37.80451131849129 -122.40715815553101 (37.8045113184913, -122.407158155531)
187914 187914 135943 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2056 Jefferson St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   5999351.778519999 2121203.50658 37.8043816542415 -122.446492250814 (37.8043816542415, -122.446492250814)
152357 152357 136602 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3698 Beach St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 5ft   6002136.39741 2121144.63129 37.8043786541109 -122.43685163990101 (37.8043786541109, -122.436851639901)
25791 25791 135673 Undocumented 2 Prunus caroliniana :: Carolina Cherry Laurel 133 3639 Webster St 1 : 4 Tree 1 Private 1     5 Width 3ft   6002560.08245 2121134.92796 37.8043760820531 -122.435384749408 (37.8043760820531, -122.435384749408)
64989 64989 142537 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2100 POWELL ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6009436.3973 2120993.5505 37.8043760089549 -122.411578593269 (37.8043760089549, -122.411578593269)
185006 185006 52876 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 118@ BEACH Cervantes Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2006 12:00:00 AM 3   Permit Number 48887 6001354.74762 2121139.05445 37.8043188860645 -122.439556198976 (37.8043188860645, -122.439556198976)
32782 32782 142536 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2100 POWELL ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6009440.4553 2120971.6371 37.8043160678486 -122.411563000977 (37.8043160678486, -122.411563000977)
156227 156227 52875 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 118@ BEACH Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2006 12:00:00 AM 5 3x3 Permit Number 48887 6001367.786590001 2121129.52184 37.8042934541427 -122.439510392889 (37.8042934541427, -122.439510392889)
154849 154849 135905 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2843 Larkin St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6006460.32075 2121020.9303099997 37.804283800830795 -122.42187952052099 (37.8042838008308, -122.421879520521)
46269 46269 41181 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1780 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/24/1999 12:00:00 AM 11   Permit Number 41899 6001559.95191 2121091.33566 37.8041995397404 -122.438842652585 (37.8041995397404, -122.438842652585)
149267 149267 41180 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1780 Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/24/1999 12:00:00 AM 3   Permit Number 41899 6001541.153 2121088.1531 37.804189731738 -122.43890747929701 (37.804189731738, -122.438907479297)
98671 98671 50376 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1620 Montgomery St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
112875 112875 50379 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1620 Montgomery St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
144023 144023 50380 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1620 Montgomery St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
58041 58041 135851 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 787 Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6007518.53532 2120901.3436 37.804015067204105 -122.41820899156299 (37.8040150672041, -122.418208991563)
32276 32276 31868 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 3633 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/29/1999 12:00:00 AM 7   Permit Number 41912 5999648.6988 2121058.91348 37.804001595372604 -122.445454333359 (37.8040015953726, -122.445454333359)
137794 137794 142584 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2232 Mason St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6008967.5673 2120856.1596 37.803972458794796 -122.41319130359699 (37.8039724587948, -122.413191303597)
49365 49365 142583 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2234 Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6008971.4462 2120841.4199 37.80393220502779 -122.41317683745301 (37.8039322050278, -122.413176837453)
127326 127326 108693 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950X Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
139925 139925 108694 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950X Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
143086 143086 108692 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950X Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
60338 60338 135850 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2456 Leavenworth St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6007513.5376 2120862.81684 37.803909001168606 -122.418223553398 (37.8039090011686, -122.418223553398)
165767 165767 135928 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1960 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6000881.44205 2120995.2314 37.8038970374844 -122.44118378211901 (37.8038970374844, -122.441183782119)
136311 136311 142582 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2236 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6008972.9977 2120827.456 37.8038939507527 -122.413170480356 (37.8038939507527, -122.413170480356)
172041 172041 135929 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1960 Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6000857.17484 2120992.84894 37.8038891135616 -122.44126758904 (37.8038891135616, -122.44126758904)
154793 154793 135930 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1960 Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6000826.2402099995 2120988.3379599997 37.8038749654115 -122.441374316075 (37.8038749654115, -122.441374316075)
67124 67124 135849 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2456 Leavenworth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007515.30382 2120841.49853 37.8038505659037 -122.418215928918 (37.8038505659037, -122.418215928918)
70624 70624 135855 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 220 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6011218.6149 2120762.89652 37.8038424981016 -122.405394792746 (37.8038424981016, -122.405394792746)
172038 172038 135857 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 220 Lombard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6011195.52799 2120759.07991 37.803830727779896 -122.405474417834 (37.8038307277799, -122.405474417834)
46464 46464 135859 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 220 Lombard St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6011176.6986 2120755.37641 37.8038195060395 -122.405539317394 (37.8038195060395, -122.405539317394)
167843 167843 135854 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 220 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6011219.52919 2120749.38326 37.8038054451262 -122.405390676534 (37.8038054451262, -122.405390676534)
29291 29291 135856 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 220 Lombard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6011197.01398 2120748.14382 37.803800783049 -122.405468504785 (37.803800783049, -122.405468504785)

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 2940.719ms · Data source: data.sfgov.org