Street_Tree_List

Data source: data.sfgov.org

400 rows where DBH = 4 and qSpecies = 18 sorted by YCoord

View and edit SQL

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

DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▼ Latitude Longitude Location
28128 179162 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 171 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002093.74544 2086607.8879 37.7095466578231 -122.434528308849 (37.7095466578231, -122.434528308849)
176683 179153 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 412 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 8ft   6001969.08964 2086773.8202799999 37.7099951946836 -122.434970999229 (37.7099951946836, -122.434970999229)
72980 69395 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1075 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 4   Permit Number 33499 6002066.46838 2087158.9447 37.711058190666705 -122.43466196070801 (37.7110581906667, -122.434661960708)
36399 179158 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 148 Seville St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6001439.08808 2087342.2198599998 37.7115257868681 -122.436843446185 (37.7115257868681, -122.436843446185)
60368 69413 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 73 Seville St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 4   Permit Number 33518 6001961.1999 2087395.4649599998 37.711701646594 -122.43504269857 (37.711701646594, -122.43504269857)
12196 86961 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 212 Head St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2007 12:00:00 AM 4 3x3 Permit Number 49929 5993495.99209 2087406.2303400002 37.7112468999028 -122.464301303157 (37.7112468999028, -122.464301303157)
174698 49745 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 34@ LELAND Britton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 4   Permit Number 46544 6008556.3350599995 2087877.23988 37.7133967814171 -122.41228206988899 (37.7133967814171, -122.412282069889)
150046 178975 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Dichiera Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 1ft   5998617.79966 2087941.66603 37.713010978548496 -122.44663762444999 (37.7130109785485, -122.44663762445)
56762 49698 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 87@ TUCKER Alpha St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2008 12:00:00 AM 4 3x3 Permit Number 50825 6011117.29096 2088288.9421 37.7146706063491 -122.403459407649 (37.7146706063491, -122.403459407649)
47314 179018 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 27 Pope St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000118.2745199995 2088586.12335 37.7148661099687 -122.441497716551 (37.7148661099687, -122.441497716551)
51420 179019 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 27 Pope St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000109.84085 2088611.05825 37.714934095108106 -122.44152865502701 (37.7149340951081, -122.441528655027)
173982 213346 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 223 Ramsell St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992956.82489 2088699.8094099998 37.7147676656708 -122.466258733373 (37.7147676656708, -122.466258733373)
170449 179031 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 121 Tucker Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6010327.66378 2088774.95095 37.7159609509146 -122.406222917279 (37.7159609509146, -122.406222917279)
149456 213310 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 111 Caine Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   5997269.145819999 2089132.21478 37.716202819983 -122.451384810958 (37.716202819983, -122.451384810958)
147069 213311 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 109 Caine Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   5997282.73831 2089151.44786 37.716256407882106 -122.451339215357 (37.7162564078821, -122.451339215357)
66393 213312 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 109 Caine Ave 2 : 4 Tree 1 Private 1     4 Width 3ft   5997293.25449 2089167.74263 37.716301751698204 -122.451304041065 (37.7163017516982, -122.451304041065)
162648 82704 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 67 Jennings Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/12/2005 12:00:00 AM 4     6012930.127090001 2089200.7150299998 37.7172752435332 -122.39725735994301 (37.7172752435332, -122.397257359943)
46295 213353 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 315 Bright St 1 : 4 Tree 1 Private 1     4 Width 3ft   5993739.98906 2089300.2829200001 37.7164615783281 -122.46359536864401 (37.7164615783281, -122.463595368644)
36539 179000 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 710 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6002131.90364 2089651.07814 37.7179047536928 -122.43461388473699 (37.7179047536928, -122.434613884737)
146887 213309 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 31 Majestic Ave 1 : 4 Tree 1 Private 1     4 Width 3ft   5997387.15624 2089756.5855900003 37.7179239542144 -122.45102191023899 (37.7179239542144, -122.451021910239)
181827 213350 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 610 Head St 1 : 4 Tree 1 Private 1     4 Width 3ft   5993524.58129 2089927.1808799999 37.7181704754556 -122.464385407781 (37.7181704754556, -122.464385407781)
31801 213330 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 217 Byxbee St 3 : 4 Tree 1 Private 1     4 Width 2ft   5991929.42464 2089936.9124 37.7181051172336 -122.46989983921101 (37.7181051172336, -122.469899839211)
54772 213329 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 217 Byxbee St 2 : 4 Tree 1 Private 1     4 Width 2ft   5991930.7925 2089955.0472 37.718154990039295 -122.46989643078999 (37.7181549900393, -122.46989643079)
36712 179027 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 376 Ordway St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6010782.01904 2090025.31129 37.719419589727 -122.404740419057 (37.719419589727, -122.404740419057)
154266 213293 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 930 Capitol Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995051.99009 2090130.06095 37.7188154620373 -122.45912052741001 (37.7188154620373, -122.45912052741)
65836 213340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 375 Ralston St 2 : 4 Tree 1 Private 1     4 Width 3ft   5992193.1878 2090324.6899599999 37.719185103182895 -122.469016337141 (37.7191851031829, -122.469016337141)
157491 213339 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 375 Ralston St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992194.5826900005 2090348.43318 37.7192503768696 -122.46901324258499 (37.7192503768696, -122.469013242585)
56569 213355 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 430 Garfield St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992826.5059 2090512.32679 37.7197368804329 -122.466840849243 (37.7197368804329, -122.466840849243)
59307 179003 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 500 Paris St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6001817.20315 2090671.4915099998 37.7206887102981 -122.435774631595 (37.7206887102981, -122.435774631595)
155814 78132 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 Dartmouth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 4     6009313.83221 2090783.0166900002 37.7214179201914 -122.409868876754 (37.7214179201914, -122.409868876754)
186721 213319 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 262 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   5991459.9673 2090912.89222 37.7207577701313 -122.471593616958 (37.7207577701313, -122.471593616958)
24513 213290 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 155 Ashton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   5994132.71522 2090951.16156 37.721017116620004 -122.46235759304399 (37.72101711662, -122.462357593044)
41715 52943 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 428 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 4   Permit Number 48930 6000112.39427 2091327.92801 37.722394148651 -122.44171469507299 (37.722394148651, -122.441714695073)
65650 178988 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 438 Delano Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5999531.661280001 2091360.0960900001 37.7224493688267 -122.44372445771799 (37.7224493688267, -122.443724457718)
138034 178994 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Wanda St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000603.2635699995 2091634.41392 37.723263645593796 -122.44003984357799 (37.7232636455938, -122.440039843578)
58497 179110 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 815 Peru Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6005507.996180001 2092102.1157099998 37.7248258525216 -122.42311832767 (37.7248258525216, -122.42311832767)
46977 179094 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 527 Avalon Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004128.76783 2092448.66408 37.725699468329395 -122.42791084003001 (37.7256994683294, -122.42791084003)
62835 179146 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 102 Wayland St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011358.3265 2092604.64263 37.726534098550204 -122.40292964310301 (37.7265340985502, -122.402929643103)
152516 179088 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 177 Edinburgh St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6004073.80671 2092653.92212 37.7262599519094 -122.428115457389 (37.7262599519094, -122.428115457389)
73777 213497 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 202 Elmwood Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994828.14977 2092676.9722400003 37.725795799211895 -122.460078661524 (37.7257957992119, -122.460078661524)
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)
69877 179126 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Somerset St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009968.82833 2092901.7859 37.727272304355296 -122.407754049022 (37.7272723043553, -122.407754049022)
129635 179129 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Somerset St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009946.62163 2092970.74893 37.7274604191465 -122.407835678673 (37.7274604191465, -122.407835678673)
72057 70279 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 90 Arago St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/1994 12:00:00 AM 4     5999591.10411 2092976.06015 37.726889823596295 -122.443635008456 (37.7268898235963, -122.443635008456)
170814 179132 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Somerset St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009928.59229 2093027.9547 37.727616484787205 -122.40790203874501 (37.7276164847872, -122.407902038745)
154108 70417 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 124 Yale St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1994 12:00:00 AM 4     6007053.10759 2093048.1738200001 37.7275105968359 -122.417844078137 (37.7275105968359, -122.417844078137)
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)
61846 214827 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Marston Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 1ft   5998577.38588 2093218.92266 37.7274987986193 -122.447156866022 (37.7274987986193, -122.447156866022)
165776 179116 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Yale St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006991.89793 2093240.59071 37.7280354870245 -122.418069316059 (37.7280354870245, -122.418069316059)
149622 179047 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 179 Santa Rosa Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6001242.17906 2093241.43471 37.7277125108115 -122.43794629111099 (37.7277125108115, -122.437946291111)
62059 179134 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 137 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6010795.656719999 2093351.7204900002 37.7285539830718 -122.404927357511 (37.7285539830718, -122.404927357511)
61389 213491 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 600 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995441.35755 2093353.2906 37.7276880573446 -122.458007783642 (37.7276880573446, -122.458007783642)
166435 179135 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 137 Burrows St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6010828.32671 2093363.20014 37.7285873299367 -122.404815222846 (37.7285873299367, -122.404815222846)
45711 213490 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 600 Miramar Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995429.38895 2093366.82572 37.7277245338512 -122.45805013812901 (37.7277245338512, -122.458050138129)
180872 179136 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 137 Burrows St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6010838.78874 2093367.25092 37.7285990373024 -122.404779339894 (37.7285990373024, -122.404779339894)
180962 214752 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 107 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5995609.0834800005 2093408.98072 37.727850604413796 -122.457431983704 (37.7278506044138, -122.457431983704)
93408 213521 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 112 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995640.44181 2093438.11503 37.7279324013586 -122.45732568475401 (37.7279324013586, -122.457325684754)
176556 179061 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Colonial Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000459.355169999 2093573.28788 37.728579155081206 -122.440676311782 (37.7285791550812, -122.440676311782)
136542 213516 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 136 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995661.5652 2093604.66303 37.728390915308 -122.457264704412 (37.728390915308, -122.457264704412)
95908 214740 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 163 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5995646.212069999 2093762.0324799998 37.7288221321117 -122.45732916060699 (37.7288221321117, -122.457329160607)
68055 213556 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 30 Valdez Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996400.31757 2093921.04642 37.729302030160206 -122.454733665924 (37.7293020301602, -122.454733665924)
166176 68393 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 248 Cotter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1993 12:00:00 AM 4   Permit Number 32221 6001588.48331 2093972.4225299999 37.729739323692705 -122.436801419974 (37.7297393236927, -122.436801419974)
169376 213558 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Valdez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996393.4117 2094019.32459 37.72957148234121 -122.45476463767599 (37.7295714823412, -122.454764637676)
49073 179123 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 332 Silliman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009698.7682 2094025.87435 37.730343691484705 -122.40876691948401 (37.7303436914847, -122.408766919484)
30695 213637 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 Flood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996768.7356 2094088.63508 37.7297833140429 -122.45347211404899 (37.7297833140429, -122.453472114049)
45305 214820 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 481 Flood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5997505.26463 2094090.09958 37.7298295275143 -122.450925968752 (37.7298295275143, -122.450925968752)
158498 213636 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 Flood Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996783.68078 2094092.94585 37.729796007073396 -122.453420758283 (37.7297960070734, -122.453420758283)
174844 213535 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Montecito Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996040.92015 2094127.28499 37.7298476902047 -122.45599103146499 (37.7298476902047, -122.455991031465)
28530 178973 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1501 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001853.9573099995 2094253.8181599998 37.7305270560629 -122.43590377514299 (37.7305270560629, -122.435903775143)
45874 213559 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Montecito Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996394.710419999 2094260.17076 37.7302328626481 -122.45477754205099 (37.7302328626481, -122.454777542051)
181027 196510 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Matthew Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6017931.224780001 2094293.63767 37.7315365882339 -122.380324481997 (37.7315365882339, -122.380324481997)
181691 213563 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Hazelwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996504.15927 2094478.31136 37.7308381018815 -122.454414916535 (37.7308381018815, -122.454414916535)
40188 213362 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Elmhurst Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5991224.3842 2094533.07073 37.730684246775205 -122.472671762002 (37.7306842467752, -122.472671762002)
156755 214709 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 San Benito Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992867.50655 2094851.0126200002 37.7316522131806 -122.46701438961901 (37.7316522131806, -122.467014389619)
41923 213613 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 El Verano Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994697.15129 2094857.83515 37.7317763834666 -122.460689482843 (37.7317763834666, -122.460689482843)
76196 213612 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 El Verano Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994709.538 2094870.2012900002 37.73181105052 -122.460647555557 (37.73181105052, -122.460647555557)
73753 213611 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 El Verano Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994722.957669999 2094879.2521400002 37.73183667401 -122.460601816946 (37.73183667401, -122.460601816946)
43236 50295 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3052 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 4   Permit Number 47008 5990301.1325 2094963.1495599998 37.7318116476733 -122.47589494839501 (37.7318116476733, -122.475894948395)
176727 213479 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 250 San Fernando Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992112.189780001 2095156.89303 37.7324484585195 -122.46964790583701 (37.7324484585195, -122.469647905837)
165469 45480 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3014 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 4   Permit Number 44262 5990294.42195 2095159.6612900002 37.732350829908704 -122.47593249418699 (37.7323508299087, -122.475932494187)
156197 45478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3008 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 4   Permit Number 44261 5990292.274259999 2095193.2885900002 37.732443037405 -122.475942374151 (37.732443037405, -122.475942374151)
154776 213478 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 240 San Fernando Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992116.2351400005 2095210.5304 37.7325959671276 -122.46963782354099 (37.7325959671276, -122.469637823541)
56213 213675 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 178 Lippard Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001823.54146 2095259.6315400002 37.7332870610355 -122.43608087414101 (37.7332870610355, -122.436080874141)
170540 213688 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 601 Foerster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5998099.236269999 2095311.8097599999 37.7332180398727 -122.44896052110501 (37.7332180398727, -122.448960521105)
54107 214780 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5992818.43379 2095348.2287 37.7330146123238 -122.467220181466 (37.7330146123238, -122.467220181466)
68105 213617 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 317 Hazelwood Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5996181.3126 2095353.67754 37.7332231255301 -122.455594290163 (37.7332231255301, -122.455594290163)
73876 45510 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2929 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2001 12:00:00 AM 4   Permit Number 44276 5988794.07528 2095754.20535 37.7338961880477 -122.481162998885 (37.7338961880477, -122.481162998885)
172983 50299 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2917 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 4   Permit Number 47010 5989048.57412 2095810.2761099997 37.7340649359436 -122.480287231884 (37.7340649359436, -122.480287231884)
52062 179041 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2908 20th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   5990269.38069 2095895.56899 37.734369993170795 -122.476072795627 (37.7343699931708, -122.476072795627)
151667 213622 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 759 Foerster St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5998023.15096 2095930.2118 37.7349116728363 -122.44926810546002 (37.7349116728363, -122.44926810546)
186414 45549 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990323.96119 2095935.96592 37.7344840775814 -122.47588704426201 (37.7344840775814, -122.475887044262)
167820 45548 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990306.88184 2095939.17218 37.734491890873606 -122.475946326684 (37.7344918908736, -122.475946326684)
162176 45547 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 345 Sloat Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2001 12:00:00 AM 4   Permit Number 44299 5990293.1703699995 2095939.4617299999 37.734491890875795 -122.47599375241501 (37.7344918908758, -122.475993752415)
68541 213641 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 23 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5999538.90053 2096063.9991900001 37.7353656047375 -122.444037255413 (37.7353656047375, -122.444037255413)
166620 213624 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 54 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995380.54139 2096143.4290099998 37.735345605619294 -122.458419901559 (37.7353456056193, -122.458419901559)
67099 83292 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1722 Newcomb Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM 4 3x3 Permit Number 52353 6014576.18583 2096214.42431 37.7366249865567 -122.39205786839199 (37.7366249865567, -122.392057868392)
178321 213623 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Cresta Vista Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5995805.80133 2096226.42669 37.7355979265959 -122.456955630803 (37.7355979265959, -122.456955630803)
63574 239445 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 487 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003430.76287 2096270.90417 37.736154964868604 -122.43059640542299 (37.7361549648686, -122.430596405423)
163145 239496 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 541 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008200.5938800005 2096299.6237700002 37.7365028864977 -122.414107129744 (37.7365028864977, -122.414107129744)
176665 237281 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 536 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007994.0626300005 2096346.0131 37.7366186589168 -122.414824480273 (37.7366186589168, -122.414824480273)

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