Data source: data.sfgov.org
This data as json, CSV (advanced)
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) | |||
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) | |
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) | |||
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) | |||
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) | ||
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) | ||
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) | ||
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) | |||
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) | |
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) | |
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) | |||
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) | |||
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) | |||
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |
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) | |||
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) | |
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) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
23468 | 23468 | 136049 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2258 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999403.25073 | 2120854.72135 | 37.8034269240649 | -122.44628902201299 | (37.8034269240649, -122.446289022013) | |||
43716 | 43716 | 136598 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2298 Beach St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5999341.14558 | 2120854.69423 | 37.803423302506 | -122.446503936615 | (37.803423302506, -122.446503936615) | |||
135196 | 135196 | 136599 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2298 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999338.92824 | 2120854.31751 | 37.8034221414854 | -122.44651158266001 | (37.8034221414854, -122.44651158266) | |||
40688 | 40688 | 136600 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2298 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999337.17722 | 2120854.21997 | 37.8034217736525 | -122.44651763508999 | (37.8034217736525, -122.44651763509) | |||
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) | |||
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) | |||
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) | |||
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) | |||
183700 | 183700 | 68974 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32964 | 5999680.68438 | 2120824.08507 | 37.803358645751295 | -122.44532675102501 | (37.8033586457513, -122.445326751025) |
JSON shape: default, array, newline-delimited
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");