Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84856 | 84856 | 96800 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 295x Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5992696.0 | 2088571.0 | 37.7143989335186 | -122.467150884655 | (37.7143989335186, -122.467150884655) | |||
91490 | 91490 | 113779 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 322 LISBON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002684.0 | 2091576.0 | 37.723221487961 | -122.432842971004 | (37.723221487961, -122.432842971004) | |||||
90866 | 90866 | 116182 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
94479 | 94479 | 116171 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
98099 | 98099 | 116167 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
100414 | 100414 | 116168 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
100716 | 100716 | 116173 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
107117 | 107117 | 116172 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
110822 | 110822 | 116166 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
122788 | 122788 | 116170 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
139884 | 139884 | 116175 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
143651 | 143651 | 116169 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
143970 | 143970 | 116174 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
145010 | 145010 | 116176 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1786 CARROLL AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013382.0 | 2092582.0 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | |||
73842 | 73842 | 105230 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 69 KEYSTONE WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/17/2014 12:00:00 AM | 30 | Permit Number 773353 | 5994093.4 | 2093229.9 | 37.7272717167315 | -122.462658710338 | (37.7272717167315, -122.462658710338) | ||
120178 | 120178 | 114533 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 31 BAY VIEW ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014415.0 | 2094670.0 | 37.732375362640205 | -122.39250716407801 | (37.7323753626402, -122.392507164078) | ||||
141778 | 141778 | 114530 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 31 BAY VIEW ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014415.0 | 2094670.0 | 37.732375362640205 | -122.39250716407801 | (37.7323753626402, -122.392507164078) | ||||
145697 | 145697 | 114531 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 31 BAY VIEW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014415.0 | 2094670.0 | 37.732375362640205 | -122.39250716407801 | (37.7323753626402, -122.392507164078) | ||||
145299 | 145299 | 116120 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1649x NEWHALL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6014119.0 | 2095297.0 | 37.7340805339716 | -122.393574379436 | (37.7340805339716, -122.393574379436) | ||||
84889 | 84889 | 121339 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 214 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009065.0 | 2096301.0 | 37.736555179088995 | -122.41111859640199 | (37.736555179089, -122.411118596402) | ||||
141820 | 141820 | 104844 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 395X Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003932.8304 | 2096688.9511799999 | 37.7373312570435 | -122.428890347629 | (37.7373312570435, -122.428890347629) | |||
103683 | 103683 | 109411 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 401 MOLIMO DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997363.9 | 2097040.1 | 37.737921427785395 | -122.451627389441 | (37.7379214277854, -122.451627389441) | ||||
123486 | 123486 | 6710 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1200X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/1997 12:00:00 AM | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
103556 | 103556 | 102074 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 273 Magellan Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
30545 | 30545 | 116073 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 88 MONTCALM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010492.0 | 2099980.0 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | ||||
92941 | 92941 | 116074 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 88 MONTCALM ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010492.0 | 2099980.0 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | ||||
95905 | 95905 | 107345 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 220 MAGELLAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x7 | 5994880.3 | 2100549.9 | 37.7474159195797 | -122.46046860033998 | (37.7474159195797, -122.46046860034) | |||
9479 | 9479 | 4260 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 4094X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003303.5082097 | 2100409.5413687 | 37.74751149692779 | -122.431331714787 | (37.7475114969278, -122.431331714787) | |||
9149 | 9149 | 4258 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 4094X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003364.7569552 | 2100412.8299453 | 37.747523997545706 | -122.431120155296 | (37.7475239975457, -122.431120155296) | |||
9175 | 9175 | 4259 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 4094X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6003364.7569552 | 2100412.8299453 | 37.747523997545706 | -122.431120155296 | (37.7475239975457, -122.431120155296) | |||
98335 | 98335 | 105751 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1934 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x9 | 5993512.3 | 2102309.6 | 37.752168813411004 | -122.46532681705901 | (37.752168813411, -122.465326817059) | |||
115352 | 115352 | 104391 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 3506 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6006060.0 | 2102069.0 | 37.7522238232197 | -122.42191778801599 | (37.7522238232197, -122.421917788016) | |||
9730 | 9730 | 121694 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1225 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | 6011141.0 | 2102636.0 | 37.75406592216039 | -122.404386709259 | (37.7540659221604, -122.404386709259) | ||
91058 | 91058 | 122473 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 3201x 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6006946.0 | 2103163.0 | 37.7552776242638 | -122.41893143991999 | (37.7552776242638, -122.41893143992) | |||
94361 | 94361 | 122475 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 3201x 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6006946.0 | 2103163.0 | 37.7552776242638 | -122.41893143991999 | (37.7552776242638, -122.41893143992) | |||
116653 | 116653 | 122474 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 3201x 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6006946.0 | 2103163.0 | 37.7552776242638 | -122.41893143991999 | (37.7552776242638, -122.41893143992) | |||
77730 | 77730 | 102868 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 2761 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | .75X.75 | 6009574.6 | 2103896.5 | 37.757439313651396 | -122.409892695521 | (37.7574393136514, -122.409892695521) | |||
143394 | 143394 | 102875 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 2761 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009574.6 | 2103896.5 | 37.757439313651396 | -122.409892695521 | (37.7574393136514, -122.409892695521) | ||||
85902 | 85902 | 122812 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 889 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009956.83094511 | 2104043.07852524 | 37.757863199609794 | -122.40858112241999 | (37.7578631996098, -122.40858112242) | ||||
117086 | 117086 | 66635 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 889 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1998 12:00:00 AM | Permit Number 29846 | 6009956.83094511 | 2104043.07852524 | 37.757863199609794 | -122.40858112241999 | (37.7578631996098, -122.40858112242) | ||
142021 | 142021 | 86911 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 2256 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49876 | 6009641.0 | 2104201.0 | 37.758279123090404 | -122.40968454901301 | (37.7582791230904, -122.409684549013) | |
4716 | 4716 | 253674 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 600 x Sanchez St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
94137 | 94137 | 107306 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 191 CASELLI AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000068.0 | 2104828.0 | 37.759459612723106 | -122.442837096046 | (37.7594596127231, -122.442837096046) | |||
78057 | 78057 | 107955 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 105 Danvers St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999967.5 | 2105076.1 | 37.760135104087794 | -122.44320249258301 | (37.7601351040878, -122.443202492583) | ||||
9668 | 9668 | 124721 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 701x York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3x3 | 6009904.0 | 2104980.0 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | |||
98672 | 98672 | 124720 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 701x York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x3 | 6009904.0 | 2104980.0 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | ||
107544 | 107544 | 124719 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 701x York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009904.0 | 2104980.0 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | ||||
122494 | 122494 | 124722 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 701x York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009904.0 | 2104980.0 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | ||||
77405 | 77405 | 113027 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 277 EDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996519.0 | 2105526.0 | 37.7611731745556 | -122.45516165577699 | (37.7611731745556, -122.455161655777) | ||||
80406 | 80406 | 39172 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 736 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 8 | Permit Number 40834 | 6007488.6062833 | 2105367.57823812 | 37.761361427438004 | -122.417211152399 | (37.761361427438, -122.417211152399) | |
117630 | 117630 | 116343 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 611 YORK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009887.0 | 2105445.0 | 37.7617086481783 | -122.40892153916599 | (37.7617086481783, -122.408921539166) | ||||
24431 | 24431 | 108674 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
82239 | 82239 | 108668 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
94811 | 94811 | 108669 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
119468 | 119468 | 108676 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
125414 | 125414 | 108671 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
140558 | 140558 | 108672 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
140590 | 140590 | 108670 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
141532 | 141532 | 108673 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
144133 | 144133 | 108675 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 290x DORLAND ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003652.0 | 2105829.0 | 37.762411792447 | -122.43051328718201 | (37.762411792447, -122.430513287182) | |||
119132 | 119132 | 113025 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 183 EDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996556.0 | 2106005.0 | 37.7624905091914 | -122.455068303068 | (37.7624905091914, -122.455068303068) | ||||
144237 | 144237 | 113026 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 183 EDGEWOOD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996556.0 | 2106005.0 | 37.7624905091914 | -122.455068303068 | (37.7624905091914, -122.455068303068) | ||||
84190 | 84190 | 113977 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
98380 | 98380 | 113980 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
112111 | 112111 | 117165 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 299x ALMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
120849 | 120849 | 113976 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
128979 | 128979 | 113978 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
142159 | 142159 | 113981 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
90739 | 90739 | 122606 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 27 Belmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996763.0 | 2106090.0 | 37.7627357707848 | -122.454358510098 | (37.7627357707848, -122.454358510098) | |||||
92758 | 92758 | 110586 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 151 EDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x10 | 5996558.0 | 2106132.0 | 37.7628393335165 | -122.45507056334999 | (37.7628393335165, -122.45507056335) | |||
102645 | 102645 | 110587 | Private 5 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 151 EDGEWOOD AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996558.0 | 2106132.0 | 37.7628393335165 | -122.45507056334999 | (37.7628393335165, -122.45507056335) | |||||
81103 | 81103 | 113021 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 135 EDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996560.0 | 2106197.0 | 37.7630179216572 | -122.45506834325701 | (37.7630179216572, -122.455068343257) | ||||
104745 | 104745 | 113022 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 135 EDGEWOOD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996560.0 | 2106197.0 | 37.7630179216572 | -122.45506834325701 | (37.7630179216572, -122.455068343257) | ||||
128185 | 128185 | 101258 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1049 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992548.0 | 2106581.0 | 37.763841302397104 | -122.46897230376699 | (37.7638413023971, -122.468972303767) | ||||
119046 | 119046 | 99651 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1300 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3x3 | 5991764.0 | 2106610.0 | 37.7638756002396 | -122.47168600964599 | (37.7638756002396, -122.471686009646) | |||
79849 | 79849 | 101169 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1301X 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 33324 | 5994554.0 | 2106650.0 | 37.7641464551633 | -122.462039213312 | (37.7641464551633, -122.462039213312) | ||||
140637 | 140637 | 101168 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 401 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 33324 | 5994554.0 | 2106650.0 | 37.7641464551633 | -122.462039213312 | (37.7641464551633, -122.462039213312) | ||||
143351 | 143351 | 101167 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 401 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 33324 | 5994554.0 | 2106650.0 | 37.7641464551633 | -122.462039213312 | (37.7641464551633, -122.462039213312) | ||||
110337 | 110337 | 69257 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 401 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1994 12:00:00 AM | Permit Number 33324 | 5994548.69419505 | 2106652.17355678 | 37.7641521177083 | -122.462057722056 | (37.7641521177083, -122.462057722056) | |||
97384 | 97384 | 104327 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 69 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002459.0 | 2106769.0 | 37.7649251496158 | -122.434706648196 | (37.7649251496158, -122.434706648196) | ||||
123149 | 123149 | 54897 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 203 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1972 12:00:00 AM | 3x3 | Permit Number 10763 | 5997226.12135807 | 2107036.80892371 | 37.765362015501 | -122.452825087824 | (37.765362015501, -122.452825087824) | ||
108301 | 108301 | 109020 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 111x 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.41571376452801 | (37.7678993280557, -122.415713764528) | ||||
126658 | 126658 | 109017 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 111x 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.41571376452801 | (37.7678993280557, -122.415713764528) | ||||
99882 | 99882 | 100896 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1800 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 30965 | 6007972.0 | 2107962.0 | 37.76851228983521 | -122.415722998498 | (37.7685122898352, -122.415722998498) | ||
142857 | 142857 | 100895 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1800 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 30965 | 6007972.0 | 2107962.0 | 37.76851228983521 | -122.415722998498 | (37.7685122898352, -122.415722998498) | ||
94758 | 94758 | 24372 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 196 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005439.3271375 | 2108485.5635222 | 37.7698071707032 | -122.42452055163 | (37.7698071707032, -122.42452055163) | |||
142648 | 142648 | 24373 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005439.3271375 | 2108485.5635222 | 37.7698071707032 | -122.42452055163 | (37.7698071707032, -122.42452055163) | |||
77541 | 77541 | 88720 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 301 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | ||
96994 | 96994 | 58133 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 311 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | Permit Number 17115 | 6000220.45021465 | 2109949.44722515 | 37.7735305196789 | -122.442677584536 | (37.7735305196789, -122.442677584536) | ||
104559 | 104559 | 114737 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
146239 | 146239 | 21848 | Permitted Site 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 224 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/1993 12:00:00 AM | 5 | 3X3 | 5994910.90461 | 2110804.06513 | 37.775572970261 | -122.46110591428499 | (37.775572970261, -122.461105914285) | ||
91069 | 91069 | 108917 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 45 LANGTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 2x3 | 6010039.0 | 2111121.0 | 37.7773021497785 | -122.408796288569 | (37.7773021497785, -122.408796288569) | |||
121035 | 121035 | 108915 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 45 LANGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2x3 | 6010039.0 | 2111121.0 | 37.7773021497785 | -122.408796288569 | (37.7773021497785, -122.408796288569) | |||
51556 | 51556 | 113716 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 498x 21ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989370.0 | 2112285.0 | 37.7793187899318 | -122.480381451803 | (37.7793187899318, -122.480381451803) | ||||
122571 | 122571 | 102390 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 30X Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010362.0 | 2111859.0 | 37.7793466114027 | -122.407730971847 | (37.7793466114027, -122.407730971847) | ||||
103324 | 103324 | 12901 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 255X Larch St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6006360.815119999 | 2112999.8871299997 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | |||
111203 | 111203 | 12898 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 255X Larch St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006360.815119999 | 2112999.8871299997 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | |||
124986 | 124986 | 12897 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 255X Larch St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006360.815119999 | 2112999.8871299997 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | |||
127466 | 127466 | 12899 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 255X Larch St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006360.815119999 | 2112999.8871299997 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | |||
142162 | 142162 | 12896 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 255X Larch St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006360.815119999 | 2112999.8871299997 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) |
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");