Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18 sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
168210 218135 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 0 Noriega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5992409.03176 2103467.31015 37.7552838973381 -122.469226308173 (37.7552838973381, -122.469226308173)
76634 237056 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6005793.31637 2107190.9812 37.7662725407724 -122.423204074428 (37.7662725407724, -122.423204074428)
151398 237057 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6005792.84324 2107206.9501900002 37.766316361124204 -122.423206846131 (37.7663163611242, -122.423206846131)
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)
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)
38826 237101 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Dearborn St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6005826.7194 2106021.63498 37.7630636778686 -122.423005419568 (37.7630636778686, -122.423005419568)
42225 237100 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Dearborn St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6005826.477630001 2105998.8251400003 37.7630010337862 -122.42300463446101 (37.7630010337862, -122.423004634461)
153474 196471 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Middle Point Rd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6018269.46967 2096338.3756 37.7371696942217 -122.379297066815 (37.7371696942217, -122.379297066815)
184483 237163 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Norwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009249.65239 2099454.9972599996 37.7452257212815 -122.410702842362 (37.7452257212815, -122.410702842362)
156323 213482 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Sola Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994974.838219999 2100674.05314 37.7477622510295 -122.460150689121 (37.7477622510295, -122.460150689121)
165527 238521 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Sussex St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   6002789.51517 2096155.18282 37.7358008721014 -122.43280519430701 (37.7358008721014, -122.432805194307)
40170 213651 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994859.86261 2099088.6488 37.743402514010704 -122.460433407183 (37.7434025140107, -122.460433407183)
72974 213652 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994842.29481 2099078.88139 37.743374684505206 -122.46049344413099 (37.7433746845052, -122.460493444131)
76291 213654 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5994824.078840001 2099066.74247 37.7433403061049 -122.460555550413 (37.7433403061049, -122.460555550413)
76930 213653 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994833.218169999 2099074.30171 37.7433615876766 -122.46052449682699 (37.7433615876766, -122.460524496827)
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 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 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 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 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)
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)
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)
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 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)
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 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)
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)
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 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 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 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 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 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 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 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 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 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 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 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)
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 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)
34215 179115 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Yale St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6006932.90152 2093437.9228299998 37.7285739974769 -122.41828725417 (37.7285739974769, -122.41828725417)
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)
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)
62212 78428 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1000 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/2000 12:00:00 AM 10     6003760.55793 2089507.02649 37.7176015427445 -122.42897407970699 (37.7176015427445, -122.428974079707)
154800 79787 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1000 Russia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/2000 12:00:00 AM 10     6003769.36441 2089501.7721900002 37.717587614063895 -122.428943265313 (37.7175876140639, -122.428943265313)
133460 196469 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1001 Cesar Chavez St 1 : 4 Tree 1 Private 1     5 Width 3ft   6015764.4296 2101073.59632 37.750033173207 -122.388288593857 (37.750033173207, -122.388288593857)
50139 136013 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1001 Chestnut St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006984.715969999 2120484.67695 37.8028409447119 -122.420026726469 (37.8028409447119, -122.420026726469)
163914 136012 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1001 Chestnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006953.337619999 2120481.80968 37.802831303989 -122.420135108266 (37.802831303989, -122.420135108266)
77358 47252 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1001 Le Conte Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/16/2011 12:00:00 AM   3x3 Permit Number 767654 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
158154 79061 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1006 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/2002 12:00:00 AM 4     6012156.574130001 2103666.55961 37.756952313327396 -122.40094698961599 (37.7569523133274, -122.400946989616)
114167 99706 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100@Moncada Paloma Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5992094.2 2093835.6 37.7288194775612 -122.469613947177 (37.7288194775612, -122.469613947177)
119703 99707 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100@Moncada Paloma Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5992094.2 2093835.6 37.7288194775612 -122.469613947177 (37.7288194775612, -122.469613947177)
92548 103760 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100X Austin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006758.9 2115521.2 37.789199755991795 -122.420455645258 (37.7891997559918, -122.420455645258)
106963 27248 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100X CORTLAND AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/08/2000 12:00:00 AM 4 3X3   6006272.0 2097672.0 37.7401626122958 -122.420872513823 (37.7401626122958, -122.420872513823)
31155 87154 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/2008 12:00:00 AM 3 3x3 Permit Number 50137 5992080.87589 2114715.15142 37.7861484784179 -122.47118058793998 (37.7861484784179, -122.47118058794)
72144 87155 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 12th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/2008 12:00:00 AM 4 3x3 Permit Number 50137 5992081.9043 2114697.2023099996 37.7860992546106 -122.471175721775 (37.7860992546106, -122.471175721775)
153588 68685 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/2008 12:00:00 AM 3 3x3 Permit Number 50137 5992080.71456 2114734.20286 37.7862007790713 -122.47118253461001 (37.7862007790713, -122.47118253461)
34957 214766 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993866.28574 2101627.27037 37.7503157185921 -122.464053162237 (37.7503157185921, -122.464053162237)
38174 214754 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995607.36531 2093372.70982 37.7277509145579 -122.457435300396 (37.7277509145579, -122.457435300396)
96244 40667 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Maynard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767516 6004070.62612566 2093782.39936272 37.72935831911229 -122.428206841061 (37.7293583191123, -122.428206841061)
127500 40666 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Maynard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767516 6004070.62612566 2093782.39936272 37.72935831911229 -122.428206841061 (37.7293583191123, -122.428206841061)
49374 237038 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Octavia St 1 : 4 Tree 1 Private 1     5 Width 4ft   6005608.429830001 2109742.33589 37.773267513529 -122.424025015163 (37.773267513529, -122.424025015163)
147759 237040 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Octavia St 3 : 4 Tree 1 Private 1     5 Width 4ft   6005610.09761 2109720.52403 37.7732077175873 -122.42401769467699 (37.7732077175873, -122.424017694677)
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)
24809 237307 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6008865.15222 2098033.0279200003 37.741299740778 -122.41193191702601 (37.741299740778, -122.411931917026)
120325 89313 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Scott St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/07/2011 12:00:00 AM   3x3 Permit Number 767419 6002340.0 2108819.0 37.7705471897255 -122.43526488371799 (37.7705471897255, -122.435264883718)
150273 179139 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Woolsey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6011492.5608 2092126.86899 37.725229725463706 -122.40243201763799 (37.7252297254637, -122.402432017638)
150817 179141 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Woolsey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6011519.75007 2092135.2288799998 37.7252541978079 -122.402338614032 (37.7252541978079, -122.402338614032)
151819 179142 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Woolsey St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6011536.91523 2092140.59723 37.7252698963774 -122.402279652698 (37.7252698963774, -122.402279652698)
169557 179140 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Woolsey St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6011506.1503099995 2092130.7968400002 37.725241269158104 -122.402385315842 (37.7252412691581, -122.402385315842)
3103 238168 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1010 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1989 12:00:00 AM 14 Width 4ft Permit Number 27196 6003119.41534 2102323.30502 37.7527558068522 -122.432104939916 (37.7527558068522, -122.432104939916)
66671 237246 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1011 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5998816.10599 2106399.33422 37.763702653385 -122.447279838404 (37.763702653385, -122.447279838404)
134618 237248 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1018 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998867.298909999 2106367.84933 37.7636191288389 -122.447100512681 (37.7636191288389, -122.447100512681)
3084 238169 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1018 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1989 12:00:00 AM 2 Width 4ft Permit Number 27197 6003120.08624 2102266.16095 37.7525989407879 -122.432098539422 (37.7525989407879, -122.432098539422)
3629 103766 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101X Austin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006706.11036 2115484.69473 37.7890965465282 -122.420635698799 (37.7890965465282, -122.420635698799)
127259 103765 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101X Austin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006551.29204 2115477.0840000003 37.789066922774204 -122.42117081077 (37.7890669227742, -122.42117081077)
180862 239523 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 102 Bradford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6009546.51282 2097971.75612 37.7411697051097 -122.40957167870701 (37.7411697051097, -122.409571678707)
155046 237178 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 102 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010211.56612 2100240.61937 37.747436753123395 -122.407432068339 (37.7474367531234, -122.407432068339)
56422 179145 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 102 Wayland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6011376.8849 2092609.1227799999 37.726547436394604 -122.402865802033 (37.7265474363946, -122.402865802033)
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)
162028 237362 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1024 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008600.1572 2102553.65045 37.753697493244296 -122.41316776537901 (37.7536974932443, -122.413167765379)
181028 237124 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1025 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6008637.74753 2102555.44614 37.7537045340508 -122.413037896084 (37.7537045340508, -122.413037896084)
66573 237191 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1026 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6004373.7656 2102888.2274700003 37.7543779877776 -122.427807417997 (37.7543779877776, -122.427807417997)
87465 51286 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1026 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767263 6004381.40328388 2102911.72608688 37.7544429415209 -122.42778267914301 (37.7544429415209, -122.427782679143)
137373 136004 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1027 Broadway 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     19 Width 3ft   6008655.5558400005 2118272.73317 37.796861491822604 -122.41408816572999 (37.7968614918226, -122.41408816573)
42755 178970 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1029 Sunnydale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008583.66239 2086910.8267599999 37.7107447436356 -122.412119359132 (37.7107447436356, -122.412119359132)
51769 178969 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1029 Sunnydale Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008570.63643 2086915.27252 37.710756219889 -122.412164693966 (37.710756219889, -122.412164693966)
155352 178968 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1029 Sunnydale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008554.00356 2086922.9270900001 37.710776304465 -122.412222721805 (37.710776304465, -122.412222721805)
2957 238483 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103 Germania St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1996 12:00:00 AM 13 Width 3ft Permit Number 37768 6003709.010969999 2108821.61027 37.7706320052989 -122.430529650538 (37.7706320052989, -122.430529650538)
2962 238484 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103 Germania St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1996 12:00:00 AM 7 Width 3ft Permit Number 37768 6003723.3725 2108822.3529 37.7706348579377 -122.430480026835 (37.7706348579377, -122.430480026835)
185392 238527 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103 Randall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6004847.1355800005 2097543.60322 37.7397296468092 -122.425789984144 (37.7397296468092, -122.425789984144)
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)
4600 103784 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103X Fern St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006741.56415 2115141.24736 37.788155522905505 -122.420488644345 (37.7881555229055, -122.420488644345)
8999 103785 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103X Fern St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006767.43674 2115144.46398 37.7881658129506 -122.420399357843 (37.7881658129506, -122.420399357843)
76200 214712 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 104 Aptos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993048.1007199995 2094327.00059 37.730223828061206 -122.46635197506599 (37.7302238280612, -122.466351975066)
129573 214713 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 104 Aptos Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993041.99484 2094312.53309 37.730183751567004 -122.466372032662 (37.730183751567, -122.466372032662)
27195 135991 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1040 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008482.86494 2115597.67171 37.789506729108204 -122.414496332055 (37.7895067291082, -122.414496332055)
52218 136001 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1043 Mason St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009476.76834 2116835.36375 37.792960917161395 -122.41114498327299 (37.7929609171614, -122.411144983273)
56430 135998 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1043 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009470.07385 2116888.9827900003 37.7931077665596 -122.411171935935 (37.7931077665596, -122.411171935935)

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