Street_Tree_List

Data source: data.sfgov.org

201 rows where DBH = 7 and qSpecies = 18 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize

DBH

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188990 237330 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Montezuma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007590.604590001 2099741.7313 37.745919870209605 -122.416459870422 (37.7459198702096, -122.416459870422)
188326 237054 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6005797.6398599995 2107141.4188 37.766136698186706 -122.423185596933 (37.7661366981867, -122.423185596933)
187756 238343 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 219 Collingwood St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002082.73822 2104584.2017099997 37.7589048565973 -122.43585170530001 (37.7589048565973, -122.4358517053)
186638 238427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 46 Mars St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999551.73328 2105494.96582 37.761261489550705 -122.444670533732 (37.7612614895507, -122.444670533732)
186400 214739 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 163 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995642.708819999 2093778.0293599998 37.7288658544767 -122.457342428316 (37.7288658544767, -122.457342428316)
186156 178984 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 33 Leo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6001422.09119 2091414.6513 37.722706807859396 -122.43719359092199 (37.7227068078594, -122.437193590922)
185527 237450 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 48 Fountain St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6000333.56461 2101396.44944 37.750052546398 -122.441672377502 (37.750052546398, -122.441672377502)
184536 214808 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 550 Judson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5996759.66261 2093640.1443 37.7285513453471 -122.453471111309 (37.7285513453471, -122.453471111309)
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)
184059 39688 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 464 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7   Permit Number 41073 5991907.09743 2112240.92064 37.779344868431004 -122.47160144327101 (37.779344868431, -122.471601443271)
183083 237039 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Octavia St 2 : 4 Tree 1 Private 1     7 Width 4ft   6005609.24206 2109730.37641 37.7732347215415 -122.424021354908 (37.7732347215415, -122.424021354908)
182686 213280 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 370 Ashton Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5994204.93621 2092304.65471 37.7247376407218 -122.462206059074 (37.7247376407218, -122.462206059074)
181987 238365 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 662 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003646.50565 2104391.10484 37.7584633650117 -122.430429691789 (37.7584633650117, -122.430429691789)
181618 239476 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 192 Upper Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5999659.94513 2106593.00366 37.7642826027833 -122.444375189158 (37.7642826027833, -122.444375189158)
180881 237295 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 614 Banks St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6008499.92821 2095980.82324 37.735644337901 -122.413049665524 (37.735644337901, -122.413049665524)
180553 136007 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 851 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008899.0755 2119356.3922200003 37.7998506260751 -122.413322200567 (37.7998506260751, -122.413322200567)
180015 238342 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 219 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002084.58101 2104567.6189900003 37.7588594291365 -122.43584414559099 (37.7588594291365, -122.435844145591)
179415 213431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2336 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991475.01091 2099520.48282 37.74439291849001 -122.472168720814 (37.74439291849, -122.472168720814)
178867 250677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5986302.66224 2114812.53014 37.78607993617911 -122.49117856955 (37.7860799361791, -122.49117856955)
177590 179114 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Yale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006904.09352 2093533.23761 37.7288340895016 -122.418393600792 (37.7288340895016, -122.418393600792)
177339 237055 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6005794.81287 2107159.8300900003 37.7661870916781 -122.42319668379601 (37.7661870916781, -122.423196683796)
177043 196434 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2400 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010626.05667 2105554.79226 37.7620514837216 -122.406373163394 (37.7620514837216, -122.406373163394)
176768 239441 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003250.543219999 2096175.03145 37.735881508914105 -122.431212656842 (37.7358815089141, -122.431212656842)
174561 68280 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Bowdoin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 7   Permit Number 32088 6008949.32855 2093160.8279900001 37.7279264532255 -122.411296760036 (37.7279264532255, -122.411296760036)
174447 214741 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 149 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995646.65866 2093691.6399400001 37.7286288768052 -122.457322526337 (37.7286288768052, -122.457322526337)
173955 179013 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 Lisbon St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6001863.70015 2090153.04553 37.719267814726 -122.435576835623 (37.719267814726, -122.435576835623)
172812 196484 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 22 South Park 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6014481.0981 2112803.55306 37.7821698664821 -122.393547301273 (37.7821698664821, -122.393547301273)
172050 179155 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1219 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001609.50582 2087555.82392 37.7121219807101 -122.436269715579 (37.7121219807101, -122.436269715579)
170838 68956 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 874 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 7   Permit Number 32945 5988542.5052 2110035.3324599997 37.7730937088544 -122.483079131422 (37.7730937088544, -122.483079131422)
170585 237238 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 160 Belgrave Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5997759.67882 2104910.90723 37.7595553865982 -122.45082634726002 (37.7595553865982, -122.45082634726)
170119 239410 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 615 27th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002505.2924 2100033.0164799998 37.74643237854389 -122.43406497993901 (37.7464323785439, -122.434064979939)
169877 179150 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 332 Edinburgh St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6003465.83302 2091792.2726 37.7238596371003 -122.43015574750099 (37.7238596371003, -122.430155747501)
169751 238450 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 54 Carmelita St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002646.27631 2108571.6357400003 37.769885376435205 -122.43418778596 (37.7698853764352, -122.43418778596)
167046 239490 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 249 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007775.8469 2097942.50211 37.7409900025935 -122.415691953736 (37.7409900025935, -122.415691953736)
166797 50876 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 322 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2004 12:00:00 AM 7   Permit Number 47534 5987167.73714 2113766.40078 37.7832580715076 -122.48810878253401 (37.7832580715076, -122.488108782534)
165754 239381 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1045 Diamond St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001965.34817 2100982.03085 37.749007489225896 -122.43599993875 (37.7490074892259, -122.43599993875)
164627 213356 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 128 Shields St 1 : 4 Tree 1 Private 1     7 Width 3ft   5993609.42924 2089850.5677200002 37.717965004654495 -122.464086568463 (37.7179650046545, -122.464086568463)
163917 79764 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 26 Wanda St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 7     6000559.455569999 2091550.49268 37.723030722971394 -122.440185263946 (37.7230307229714, -122.440185263946)
163881 237201 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 225 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6004272.781830001 2099243.3149599996 37.744364192347795 -122.427896939189 (37.7443641923478, -122.427896939189)
163799 237426 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4301 26th St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6001882.89987 2100571.76133 37.747876302159796 -122.436255687975 (37.7478763021598, -122.436255687975)
163750 237142 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2725 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010327.48365 2102797.81501 37.7544647354838 -122.407211464653 (37.7544647354838, -122.407211464653)
163514 237319 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 13 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6009381.9747 2097364.8525 37.7394940586067 -122.41009775870899 (37.7394940586067, -122.410097758709)
163171 32104 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 242 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 7   Permit Number 35476 6002688.38371 2104495.7919400004 37.7586964899576 -122.433750783787 (37.7586964899576, -122.433750783787)
163139 213469 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 134 Forest Side Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992386.6287 2098205.19502 37.740834186951396 -122.468920866899 (37.7408341869514, -122.468920866899)
162531 238498 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 105 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003477.3432599995 2097803.5179 37.7403658101453 -122.43054468270901 (37.7403658101453, -122.430544682709)
161431 179036 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 551 Sawyer St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007618.72078 2086894.99872 37.7106470934606 -122.415453306029 (37.7106470934606, -122.415453306029)
160968 213417 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991348.87476 2098431.44962 37.7413954124699 -122.47252548818001 (37.7413954124699, -122.47252548818)
160670 213443 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2379 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992616.385419999 2099292.02218 37.743831610246 -122.468205503896 (37.743831610246, -122.468205503896)
160656 237144 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 170 Linda St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6005849.94213 2104551.74877 37.7590290259771 -122.422820631377 (37.7590290259771, -122.422820631377)
160632 239489 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 149 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007596.83968 2097934.55267 37.7409581108362 -122.41631033385 (37.7409581108362, -122.41631033385)
160414 213608 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 31 Fairfield Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993869.7323900005 2093013.6052400002 37.7266649400141 -122.46341623267 (37.7266649400141, -122.46341623267)
159580 237269 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 380 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007692.75798 2097326.0370099996 37.7392926545231 -122.415935601652 (37.7392926545231, -122.415935601652)
159029 238162 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3886 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002578.83158 2102997.86594 37.754577326999005 -122.434022589469 (37.754577326999, -122.434022589469)
157637 213481 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5995034.05151 2100934.56273 37.7484809505562 -122.45996480284201 (37.7484809505562, -122.459964802842)
157439 30897 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 252 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/09/1995 12:00:00 AM 7   Permit Number 34724 6007528.97575 2097493.2020099997 37.739742443263296 -122.416513727228 (37.7397424432633, -122.416513727228)
156414 213668 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Edgehill Way 4 Front Yard : Yard 7 Tree 1 Private 1     7 Width 3ft   5994864.53372 2098940.09364 37.742994887300895 -122.460406494088 (37.7429948873009, -122.460406494088)
156212 213288 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1039 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995905.05181 2090820.4262299999 37.720760046333496 -122.456221739052 (37.7207600463335, -122.456221739052)
156183 237270 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 380 Moultrie St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007691.788319999 2097311.69538 37.739253221054604 -122.415937938991 (37.7392532210546, -122.415937938991)
156124 213373 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1623 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5992438.33257 2104386.8742299997 37.757810473397605 -122.46919190279101 (37.7578104733976, -122.469191902791)
155818 213407 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2281 Cecilia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991478.9532699995 2099887.90451 37.7454019920197 -122.47218186622 (37.7454019920197, -122.47218186622)
153971 50505 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 671 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/2003 12:00:00 AM 7   Permit Number 47140 6001286.63286 2089768.4439299998 37.7181789920349 -122.43754400816002 (37.7181789920349, -122.43754400816)
153792 68094 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 51 Wanda St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/1993 12:00:00 AM 7   Permit Number 31838 6000539.95972 2091455.5942900002 37.7227690436428 -122.440245854872 (37.7227690436428, -122.440245854872)
153101 214648 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8 Hillway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996112.805480001 2106851.3196400004 37.7647888500462 -122.456662349289 (37.7647888500462, -122.456662349289)
150482 237061 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 189 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006054.68331 2099167.27831 37.744256057884705 -122.42173008828001 (37.7442560578847, -122.42173008828)
149473 213517 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995657.9114 2093576.16628 37.728312460239 -122.45727527503 (37.728312460239, -122.45727527503)
148458 65791 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 523 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/1990 12:00:00 AM 7   Permit Number 28759 6001804.02439 2090571.26735 37.7204127686105 -122.43581301917801 (37.7204127686105, -122.435813019178)
147925 69417 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 149 Seville St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 7   Permit Number 33522 6001453.459840001 2087297.44526 37.7114036625088 -122.436790570551 (37.7114036625088, -122.436790570551)
147855 213348 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 438 Victoria St 1 : 4 Tree 1 Private 1     7 Width 3ft   5993267.15159 2090112.97171 37.7186657698839 -122.46528871291599 (37.7186657698839, -122.465288712916)
147688 239501 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 91 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008340.02558 2098183.52098 37.7416834859956 -122.41375826834499 (37.7416834859956, -122.413758268345)
147639 213305 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 223 Capitol Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995012.40881 2087891.7837 37.712667406052496 -122.45909535897499 (37.7126674060525, -122.459095358975)
147549 239437 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Natick St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6003054.423690001 2095570.6971900002 37.7342110290136 -122.43184758179399 (37.7342110290136, -122.431847581794)
147395 213428 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2356 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991465.99867 2099400.33215 37.744062494091 -122.472191126522 (37.744062494091, -122.472191126522)
138154 213546 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Colon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996160.95111 2093881.0696900003 37.729178530763704 -122.45555828401001 (37.7291785307637, -122.45555828401)
137695 214748 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 131 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995627.33147 2093578.0296099999 37.728315820111206 -122.457381125259 (37.7283158201112, -122.457381125259)
136441 238408 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 227 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999936.15736 2105561.41019 37.7614658586796 -122.44334575050199 (37.7614658586796, -122.443345750502)
136377 33273 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1121 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/13/1996 12:00:00 AM 7   Permit Number 37442 6009382.25638 2117052.9627099996 37.7935530901583 -122.41148738125901 (37.7935530901583, -122.411487381259)
135510 214623 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1405 11th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992699.2887699995 2105840.21181 37.7618160331047 -122.46839514841801 (37.7618160331047, -122.468395148418)
135425 237190 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950 Church St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6004359.56384 2103198.7943700003 37.755229928123995 -122.427878659579 (37.755229928124, -122.427878659579)
134250 238384 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 87 Collingwood St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002038.08202 2105382.6143099996 37.7610945672917 -122.436063279813 (37.7610945672917, -122.436063279813)
133870 237233 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 110 Carmel St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   5998197.90052 2105385.6119999997 37.760883883112506 -122.449344967798 (37.7608838831125, -122.449344967798)
133733 237425 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4357 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6001592.53489 2100559.93073 37.7478273160869 -122.43725890779 (37.7478273160869, -122.43725890779)
133475 178977 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 190 Rae Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 1ft   5997636.8287 2087155.6990200002 37.71079680899621 -122.449971558745 (37.7107968089962, -122.449971558745)
133417 238363 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 309 Cumberland St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003625.4315599995 2104470.89055 37.7586812437646 -122.430508268262 (37.7586812437646, -122.430508268262)
133247 50771 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 638 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/04/2004 12:00:00 AM 7   Permit Number 47314 5988487.7879800005 2111617.79391 37.7774355226981 -122.48338443014799 (37.7774355226981, -122.483384430148)
133107 213425 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2333 Cecilia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991441.219819999 2099500.5467 37.744336223447704 -122.472284109241 (37.7443362234477, -122.472284109241)
132655 250524 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.45058 2115374.99193 37.7877049922276 -122.486435864334 (37.7877049922276, -122.486435864334)
132126 213640 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999549.40588 2096053.5305299999 37.735337459545605 -122.444000182688 (37.7353374595456, -122.444000182688)
132095 238152 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 723 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001697.56131 2102027.17148 37.751861979657996 -122.437000760097 (37.751861979658, -122.437000760097)
131978 238049 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 400 Lily St 4 : 4 Tree 1 Private 1     7 Width 3ft   6004542.4291199995 2110001.70207 37.7739194275845 -122.427730940528 (37.7739194275845, -122.427730940528)
131464 82264 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 41 Parsons St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 7 3x3 Permit Number 51587 5996552.33685 2110597.55386 37.775100265791394 -122.455412906224 (37.7751002657914, -122.455412906224)
131249 237120 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2132 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009548.42279 2104767.49302 37.759829396529 -122.410044714901 (37.759829396529, -122.410044714901)
130209 214797 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 338 Juanita Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995039.23542 2097556.26401 37.7392052826872 -122.459702216086 (37.7392052826872, -122.459702216086)
130098 213561 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Montecito Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996368.30466 2094246.96905 37.7301950992263 -122.45486787625099 (37.7301950992263, -122.454867876251)
129792 239380 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1045 Diamond St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001965.88505 2100966.71291 37.748965460295295 -122.435996986282 (37.7489654602953, -122.435996986282)
129580 68530 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 632 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 7   Permit Number 32411 5994733.00638 2111219.97817 37.7767047179401 -122.461751466472 (37.7767047179401, -122.461751466472)
122146 237078 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1213 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6011151.97874 2102591.50578 37.7539443643514 -122.404345610361 (37.7539443643514, -122.404345610361)
118166 179079 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 72 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004347.61094 2093176.52987 37.7277104045865 -122.42720613936899 (37.7277104045865, -122.427206139369)
105585 113819 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4101x 25TH ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
78887 47481 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1809 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 7   Permit Number 45377 5999494.3233199995 2115164.49026 37.7878082622913 -122.445564438253 (37.7878082622913, -122.445564438253)
76653 213500 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 777 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5994870.75365 2093146.80923 37.7270883084579 -122.45996540448 (37.7270883084579, -122.45996540448)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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