Street_Tree_List

Data source: data.sfgov.org

201 rows where DBH = 7 and qSpecies = 18 sorted by YCoord

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
73045 31021 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 317 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1995 12:00:00 AM 7   Permit Number 34787 6002776.11429 2086581.1916200002 37.7095120680942 -122.432168021935 (37.7095120680942, -122.432168021935)
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)
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)
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)
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)
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)
45575 78381 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 631 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/2000 12:00:00 AM 7     6003379.385319999 2089522.9059 37.7176235608499 -122.43029275202299 (37.7176235608499, -122.430292752023)
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)
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)
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)
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)
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)
39666 213322 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Monticello St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5991674.008280001 2090730.18875 37.720268492169296 -122.470840448222 (37.7202684921693, -122.470840448222)
63221 84826 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 855 Goettingen St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2010 12:00:00 AM 7   Permit Number 53480 6010945.70103 2090738.7413400002 37.7213876696754 -122.404224813428 (37.7213876696754, -122.404224813428)
31968 213326 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Byxbee St 1 : 4 Tree 1 Private 1     7 Width 3ft   5991939.8499300005 2090759.9353900002 37.7203655398194 -122.46992369461701 (37.7203655398194, -122.469923694617)
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)
66676 213286 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 361 Faxon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5994727.8524400005 2090960.34895 37.7210765950904 -122.460301059362 (37.7210765950904, -122.460301059362)
68722 213285 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 361 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5994728.2194300005 2090977.86647 37.721124715117995 -122.460301059356 (37.721124715118, -122.460301059356)
73040 179149 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 387 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6003556.4774 2091326.8138400002 37.7225867240926 -122.429809220726 (37.7225867240926, -122.429809220726)
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)
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)
69928 179111 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1362 Wayland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6007634.67362 2091466.7715 37.723201116628395 -122.415721669126 (37.7232011166284, -122.415721669126)
45771 48784 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 268 Onondaga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/2002 12:00:00 AM 7   Permit Number 46039 6000083.90087 2091529.02554 37.7229446929396 -122.44182761574801 (37.7229446929396, -122.441827615748)
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)
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)
69506 51979 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 201 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2015 12:00:00 AM 7 3x3 Permit Number 775837 6000531.055869999 2092082.3650200001 37.7244895060779 -122.440321560704 (37.7244895060779, -122.440321560704)
38699 52528 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 San Juan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2005 12:00:00 AM 7   Permit Number 48628 6001332.37944 2092272.13723 37.725056169781205 -122.437565081984 (37.7250561697812, -122.437565081984)
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)
37021 52927 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 155 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 7   Permit Number 48911 6000347.40158 2092558.92243 37.7257875650324 -122.44099059964199 (37.7257875650324, -122.440990599642)
37085 43877 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 144 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/2000 12:00:00 AM 7   Permit Number 43492 6003098.49585 2092711.51751 37.726362865838 -122.431491164302 (37.726362865838, -122.431491164302)
48145 213532 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1321 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995868.11744 2092855.1447 37.726344778666004 -122.456496470238 (37.726344778666, -122.456496470238)
31889 214758 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 41 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995633.68738 2092918.64015 37.7265056601867 -122.457311470041 (37.7265056601867, -122.457311470041)
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)
54203 78243 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 30 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 7     6000646.02726 2093117.37413 37.727337949475896 -122.439998300301 (37.7273379494759, -122.439998300301)
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)
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)
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)
30982 179077 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 26 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004472.54344 2093374.1401799999 37.7282600630306 -122.426788312529 (37.7282600630306, -122.426788312529)
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)
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)
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)
48498 214807 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 550 Judson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5996780.18786 2093638.94841 37.72854923825879 -122.45340006847799 (37.7285492382588, -122.453400068478)
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)
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)
50711 213511 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 150 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995678.2658 2093705.9591 37.728670009096604 -122.457214294721 (37.7286700090966, -122.457214294721)
28886 40657 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Congdon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 7   Permit Number 47919 6004684.27364 2093706.73058 37.729185251382 -122.4260800191 (37.729185251382, -122.4260800191)
33723 179058 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6000523.58378 2093733.7871599998 37.729023506521294 -122.44046577686899 (37.7290235065213, -122.440465776869)
38127 179057 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6000509.01333 2093743.60898 37.7290496453045 -122.440516852064 (37.7290496453045, -122.440516852064)
37645 40655 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Congdon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 7   Permit Number 47919 6004683.61058 2093747.9444400002 37.729298378011705 -122.42608524416401 (37.7292983780117, -122.426085244164)
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)
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)
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)
29134 213564 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Hazelwood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996496.71182 2094497.05235 37.730889133023894 -122.454442016707 (37.7308891330239, -122.454442016707)
25588 213562 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 145 Hazelwood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996449.59751 2094511.04667 37.7309248558938 -122.454605908258 (37.7309248558938, -122.454605908258)
76147 213552 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 159 Valdez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996195.23273 2094521.1933400002 37.7309381235969 -122.45548601716999 (37.7309381235969, -122.45548601717)
62002 214782 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1627 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5992928.85631 2095341.1686900002 37.733001600925 -122.466837912033 (37.733001600925, -122.466837912033)
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)
60077 239432 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Carrie St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002796.18666 2095574.4213900003 37.7342066124483 -122.43274065448401 (37.7342066124483, -122.432740654484)
74927 239435 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002953.41411 2095684.87756 37.73451881569579 -122.43220495528799 (37.7345188156958, -122.432204955288)
56653 239436 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Chenery St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002980.82708 2095688.8923400003 37.734531393606204 -122.43211046622 (37.7345313936062, -122.43211046622)
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)
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)
54367 213646 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999502.91716 2096107.4577900001 37.735482879036105 -122.444164784704 (37.7354828790361, -122.444164784704)
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)
73174 239450 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 51 Mizpah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001052.8438 2096432.45143 37.736463536652295 -122.438829397462 (37.7364635366523, -122.438829397462)
34283 71395 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1553 Kirkwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1988 12:00:00 AM 7     6015450.35777 2096531.9462 37.7375453329415 -122.389057616714 (37.7375453329415, -122.389057616714)
46671 214787 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 Robinhood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5996140.97875 2096605.13185 37.7366570006238 -122.455824168555 (37.7366570006238, -122.455824168555)
25654 239525 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 86 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009315.75125 2096958.2130200001 37.738373802798 -122.41029802783501 (37.738373802798, -122.410298027835)
37823 239507 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008641.776000001 2097174.69349 37.738930407604606 -122.41264361263599 (37.7389304076046, -122.412643612636)
27689 237321 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 33 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6009370.212719999 2097234.61116 37.739135784895204 -122.41012923409299 (37.7391357848952, -122.410129234093)
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)
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)
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)
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)
49680 214796 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 336 Juanita Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995062.32448 2097542.59009 37.7391690651991 -122.45962139492701 (37.7391690651991, -122.459621394927)
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)
51859 214798 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 338 Juanita Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995023.55094 2097563.83424 37.7392251667135 -122.459756993785 (37.7392251667135, -122.459756993785)
67810 213625 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 Sequoia Way 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5998243.47992 2097619.18832 37.73956179822439 -122.448627959023 (37.7395617982244, -122.448627959023)
48553 237350 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1327 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6008148.7592400005 2097711.6028400003 37.740376959939496 -122.41438622176399 (37.7403769599395, -122.414386221764)
56247 239495 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 183 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008119.0668 2097783.93358 37.7405738961806 -122.414494003717 (37.7405738961806, -122.414494003717)
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)
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)
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)
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)
64826 239556 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 222 Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006749.08669 2098198.6867400003 37.741635656457 -122.419260290053 (37.741635656457, -122.419260290053)
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)
60874 214690 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Forest Side Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992455.885480001 2098286.40938 37.7410611821255 -122.468687312988 (37.7410611821255, -122.468687312988)
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)
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)
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)
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)
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)
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)
27902 237161 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1704 Alabama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009291.76832 2099412.6751099997 37.745111875222605 -122.41055422399799 (37.7451118752226, -122.410554223998)
50996 213444 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2351 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992608.79172 2099462.0696400004 37.7442980787015 -122.468244128866 (37.7442980787015, -122.468244128866)
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)
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)
47537 213432 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2330 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991474.23883 2099545.3415099997 37.744461129378 -122.472173202136 (37.744461129378, -122.472173202136)
71505 213438 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2310 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991478.325209999 2099662.36916 37.7447826936787 -122.472167601152 (37.7447826936787, -122.472167601152)
39553 213453 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 305 Dorantes Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993154.524540001 2099672.2697099997 37.7449067389721 -122.46637239059099 (37.7449067389721, -122.466372390591)

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