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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158933 | 158933 | 196200 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013682.55541 | 2111829.59348 | 37.7794511934496 | -122.396241636866 | (37.7794511934496, -122.396241636866) | |||
159252 | 159252 | 196208 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013488.1481 | 2111645.63657 | 37.778935270397206 | -122.396901277881 | (37.7789352703972, -122.396901277881) | |||
166958 | 166958 | 196199 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013692.0119 | 2111837.7722 | 37.7794741765351 | -122.396209495994 | (37.7794741765351, -122.396209495994) | |||
168103 | 168103 | 196201 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013661.85599 | 2111812.39055 | 37.7794028063227 | -122.396312039369 | (37.7794028063227, -122.396312039369) | |||
182692 | 182692 | 196202 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013641.30182 | 2111791.44038 | 37.779344138168895 | -122.396381676574 | (37.7793441381689, -122.396381676574) | |||
42760 | 42760 | 212608 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.24598 | 2089933.0697299999 | 37.718308715656704 | -122.45705219282699 | (37.7183087156567, -122.457052192827) | |||
71201 | 71201 | 236654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006198.97088 | 2103487.79706 | 37.7561273490041 | -122.42153795981301 | (37.7561273490041, -122.421537959813) | |||
105011 | 105011 | 46168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.45665958836399 | (37.7648158648531, -122.456659588364) | ||
135709 | 135709 | 212315 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996111.7334 | 2106830.07991 | 37.764730469656 | -122.45666452114901 | (37.764730469656, -122.456664521149) | |||
168699 | 168699 | 247958 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | ||||
37243 | 37243 | 202167 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6013164.547619999 | 2093230.83795 | 37.7283541968866 | -122.396729443526 | (37.7283541968866, -122.396729443526) | |||
45654 | 45654 | 202165 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6013169.468859999 | 2093279.75554 | 37.7284887885067 | -122.39671585835698 | (37.7284887885067, -122.396715858357) | |||
64207 | 64207 | 202166 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6013167.38298 | 2093268.67632 | 37.7284582511357 | -122.39672229302201 | (37.7284582511357, -122.396722293022) | |||
186399 | 186399 | 202168 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.728359287049706 | -122.396753038148 | (37.7283592870497, -122.396753038148) | |||
31422 | 31422 | 237707 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000247.199630001 | 2106827.67898 | 37.764960451486004 | -122.44236089665002 | (37.764960451486, -122.44236089665) | |||
173487 | 173487 | 237708 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Levant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000245.79944 | 2106807.6241 | 37.764905305964206 | -122.442364299668 | (37.7649053059642, -122.442364299668) | |||
29000 | 29000 | 237789 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999974.87074 | 2106875.7261900003 | 37.7650768516417 | -122.443306262176 | (37.7650768516417, -122.443306262176) | |||
48155 | 48155 | 237787 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999975.78391 | 2106902.16823 | 37.76514950696679 | -122.44330500312701 | (37.7651495069668, -122.443305003127) | |||
59446 | 59446 | 237788 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5999974.057569999 | 2106889.15487 | 37.7651136770803 | -122.44331003932699 | (37.7651136770803, -122.443310039327) | |||
151324 | 151324 | 237790 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999973.591030001 | 2106866.6906 | 37.765051969188704 | -122.443310039322 | (37.7650519691887, -122.443310039322) | |||
88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
50305 | 50305 | 213569 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995296.87532 | 2100197.80172 | 37.7464731016692 | -122.459002630776 | (37.7464731016692, -122.459002630776) | |||
149108 | 149108 | 213571 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995317.16684 | 2100218.39007 | 37.746530798564 | -122.458933955845 | (37.746530798564, -122.458933955845) | |||
166643 | 166643 | 213570 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995304.50078 | 2100206.2944900002 | 37.7464968590373 | -122.458976877776 | (37.7464968590373, -122.458976877776) | |||
52038 | 52038 | 237164 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009246.95837 | 2099498.34897 | 37.7453446044841 | -122.41071521884899 | (37.7453446044841, -122.410715218849) | |||
123229 | 123229 | 42079 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42389 | 6009265.41363365 | 2099503.07167939 | 37.7453586067376 | -122.41065173677299 | (37.7453586067376, -122.410651736773) | ||
165156 | 165156 | 69496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 6 | Permit Number 33619 | 6000930.02783 | 2092989.43743 | 37.7270028279165 | -122.439007348127 | (37.7270028279165, -122.439007348127) | |
183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
91181 | 91181 | 51065 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
105516 | 105516 | 51062 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
111577 | 111577 | 51061 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
115880 | 115880 | 51064 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
141391 | 141391 | 51063 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
141745 | 141745 | 51060 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
41657 | 41657 | 213555 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Valdez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5996402.0458 | 2093842.9488400002 | 37.7290876920423 | -122.45472205120599 | (37.7290876920423, -122.454722051206) | |||
79328 | 79328 | 88522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Valdez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417.0 | 2093827.6 | 37.7290464055545 | -122.45466924520201 | (37.7290464055545, -122.454669245202) | |||
159216 | 159216 | 179109 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005498.42194 | 2092990.6944 | 37.7272651547613 | -122.42321455871 | (37.7272651547613, -122.42321455871) | |||
60101 | 60101 | 135697 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Walnut St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5998449.317000001 | 2116481.46771 | 37.7913646187353 | -122.449274868335 | (37.7913646187353, -122.449274868335) | |||
172696 | 172696 | 135698 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Walnut St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5998453.121780001 | 2116461.2064400003 | 37.7913092042995 | -122.449260243563 | (37.7913092042995, -122.449260243563) | |||
175435 | 175435 | 236824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997056.16867 | 2106590.5026700003 | 37.7641268320976 | -122.453380686287 | (37.7641268320976, -122.453380686287) | |||
57160 | 57160 | 46089 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2001 12:00:00 AM | 3 | Permit Number 44465 | 5989928.0373599995 | 2114622.7859900002 | 37.7857701098965 | -122.478621999998 | (37.7857701098965, -122.478621999998) | ||
82956 | 82956 | 47713 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
85199 | 85199 | 47712 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
85911 | 85911 | 47714 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
158723 | 158723 | 124414 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 100 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5996072.31903 | 2115814.16927 | 37.7893961490256 | -122.457450879091 | (37.7893961490256, -122.457450879091) | |||
146276 | 146276 | 33499 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37589 | 6006683.58482984 | 2099106.89574168 | 37.74412570540729 | -122.419551194294 | (37.7441257054073, -122.419551194294) | |||
38558 | 38558 | 57413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1976 12:00:00 AM | 5 | Permit Number 16255 | 5996562.3267 | 2113747.4862 | 37.78374972289961 | -122.455606076565 | (37.7837497228996, -122.455606076565) | ||
60810 | 60810 | 215238 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 De Montfort Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995012.54401 | 2091916.70112 | 37.723718881496296 | -122.45938619431601 | (37.7237188814963, -122.459386194316) | |||
177454 | 177454 | 215237 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 De Montfort Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995021.72102 | 2091916.5089599998 | 37.7237188815105 | -122.45935445725901 | (37.7237188815105, -122.459354457259) | |||
98555 | 98555 | 42815 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42760 | 6001684.72316119 | 2105247.9392865 | 37.760704701255 | -122.437275750105 | (37.760704701255, -122.437275750105) | ||
66908 | 66908 | 141667 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 EWING TER | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998723.4884 | 2112384.3231 | 37.7801306125765 | -122.448031120952 | (37.7801306125765, -122.448031120952) | |||
130184 | 130184 | 141666 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 EWING TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998741.7631 | 2112389.0611 | 37.7801446665071 | -122.447968241937 | (37.7801446665071, -122.447968241937) | |||
64593 | 64593 | 60783 | Permitted Site 1 | Syzygium paniculatum :: Brush Cherry 198 | 100 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 5 | Permit Number 20453 | 5998776.2822 | 2112393.1221 | 37.7801577900357 | -122.447849117584 | (37.7801577900357, -122.447849117584) | |
104017 | 104017 | 102628 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | |
132913 | 132913 | 215229 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6000677.32217 | 2094383.25488 | 37.7308155477923 | -122.439980842666 | (37.7308155477923, -122.439980842666) | |||
34117 | 34117 | 237115 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Hwy 101 Southbound | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005846.05822 | 2108984.84199 | 37.7712010306339 | -122.42314917169399 | (37.7712010306339, -122.423149171694) | ||||
76069 | 76069 | 237116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Hwy 101 Southbound | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005840.35144 | 2109000.46624 | 37.7712436090254 | -122.423170022474 | (37.7712436090254, -122.423170022474) | ||||
18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
18983 | 18983 | 11186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | |||
60094 | 60094 | 178818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Ina Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6004783.72135 | 2091297.0719 | 37.722574479812 | -122.42556479298099 | (37.722574479812, -122.425564792981) | ||||
74220 | 74220 | 214218 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001377.44838 | 2094959.38668 | 37.7324373042189 | -122.43760164301399 | (37.7324373042189, -122.437601643014) | |||
149527 | 149527 | 214291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999381.70111 | 2093509.42542 | 37.7283423752946 | -122.444397221682 | (37.7283423752946, -122.444397221682) | |||
90587 | 90587 | 117635 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 LOCUST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
118135 | 118135 | 117636 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 LOCUST ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
1661 | 1661 | 245154 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000359.4788 | 2109307.5305 | 37.771775902629706 | -122.44215057779499 | (37.7717759026297, -122.442150577795) | |||
1669 | 1669 | 245155 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000354.8127 | 2109347.659 | 37.7718858194659 | -122.442169599164 | (37.7718858194659, -122.442169599164) | |||
1675 | 1675 | 245153 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000359.9454 | 2109295.8652 | 37.7717438992436 | -122.44214812628701 | (37.7717438992436, -122.442148126287) | |||
65386 | 65386 | 245152 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000363.2117 | 2109282.8001 | 37.77170821191321 | -122.44213588997101 | (37.7717082119132, -122.442135889971) | |||
10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
166971 | 166971 | 238063 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Manchester St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008227.615119999 | 2099350.5643599997 | 37.7448816154881 | -122.414229497799 | (37.7448816154881, -122.414229497799) | |||
115201 | 115201 | 121666 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993653.0 | 2099666.0 | 37.7449182738718 | -122.46464831295299 | (37.7449182738718, -122.464648312953) | ||||
134948 | 134948 | 178732 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Morse St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 1ft | 6000912.22914 | 2087974.06631 | 37.713230738679705 | -122.43870965184601 | (37.7132307386797, -122.438709651846) | |||
149450 | 149450 | 178733 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Morse St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 1ft | 6000880.0864 | 2087963.6418299999 | 37.713200286736495 | -122.438820001354 | (37.7132002867365, -122.438820001354) | |||
182840 | 182840 | 179092 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004478.253830001 | 2092876.7352900002 | 37.7268946223776 | -122.42673316430201 | (37.7268946223776, -122.426733164302) | |||
169744 | 169744 | 236538 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007123.60944 | 2096775.0241200002 | 37.73774768042 | -122.417864419915 | (37.73774768042, -122.417864419915) | |||
131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
168224 | 168224 | 237032 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6005721.49565 | 2109758.3052 | 37.7733177442556 | -122.423635040324 | (37.7733177442556, -122.423635040324) | |||
171710 | 171710 | 237031 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6005723.44032 | 2109745.94906 | 37.773283927046 | -122.423627434762 | (37.773283927046, -122.423627434762) | |||
45242 | 45242 | 213576 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994554.1980800005 | 2099981.39248 | 37.7458361756945 | -122.46155502007299 | (37.7458361756945, -122.461555020073) | |||
169697 | 169697 | 213577 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994569.9735900005 | 2099964.1686400003 | 37.745789791378 | -122.46149922251001 | (37.745789791378, -122.46149922251) | |||
77900 | 77900 | 99712 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
90054 | 90054 | 99710 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
101806 | 101806 | 99709 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
113083 | 113083 | 99708 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
139212 | 139212 | 99711 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
119018 | 119018 | 62880 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1986 12:00:00 AM | 3x3 | Permit Number 49921 | 6008828.47380472 | 2098062.83988383 | 37.7413795400306 | -122.41206084487 | (37.7413795400306, -122.41206084487) | ||
105631 | 105631 | 34419 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38167 | 6003358.09011166 | 2096226.49076231 | 37.7360288984966 | -122.43084449611601 | (37.7360288984966, -122.430844496116) | ||
38906 | 38906 | 237981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003493.73736 | 2095146.1048599998 | 37.7330700888164 | -122.43029845283002 | (37.7330700888164, -122.43029845283) | |||
56182 | 56182 | 236666 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Rousseau St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003492.24635 | 2095170.16548 | 37.7331360693763 | -122.430305323657 | (37.7331360693763, -122.430305323657) | |||
65737 | 65737 | 237406 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003490.74781 | 2095180.0910599998 | 37.733163237889705 | -122.43031121240801 | (37.7331632378897, -122.430311212408) | |||
109631 | 109631 | 94680 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53816 | 6003489.0 | 2095230.0 | 37.733300177534204 | -122.430320814613 | (37.7333001775342, -122.430320814613) | |
3403 | 3403 | 19880 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
14604 | 14604 | 19885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
9515 | 9515 | 19958 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
10800 | 10800 | 19957 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
16368 | 16368 | 19956 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
12896 | 12896 | 19960 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY41 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
4106 | 4106 | 20001 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY46 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
3019 | 3019 | 20034 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST |
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");