Street_Tree_List

Data source: data.sfgov.org

351 rows where qLegalStatus = 3 and qSpecies = 18 sorted by SiteOrder descending

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes

qLegalStatus

  • DPW Maintained · 351
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
107698 16451 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1395 Newcomb Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/29/2009 12:00:00 AM 3 3x3   6016285.996927 2094866.0167389999 37.733017311739104 -122.386052291775 (37.7330173117391, -122.386052291775)
22982 106990 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1737-1795 Post St 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/24/2014 02:15:00 PM 3     6003734.5 2114103.2 37.785135386369795 -122.43081845921101 (37.7851353863698, -122.430818459211)
101983 16450 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1395 Newcomb Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6016285.996927 2094866.0167389999 37.733017311739104 -122.386052291775 (37.7330173117391, -122.386052291775)
8626 87739 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 11 Median : Cutout 11 Tree 1 DPW 2   05/10/2008 12:00:00 AM 3 4x4   6005433.618530001 2121623.41722 37.8058801199389 -122.42547541206699 (37.8058801199389, -122.425475412067)
5494 87738 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 10 Median : Cutout 11 Tree 1 DPW 2   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217)
20572 27519 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2000 12:00:00 AM 8 3X3   6005760.41969 2101697.87743 37.751187906306896 -122.42292741057 (37.7511879063069, -122.42292741057)
38785 136006 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1237x Robert C Levy Tunl 10 Median : Yard 3 Tree 1 DPW 2     3     6007669.82361 2118117.1353700003 37.7963788445653 -122.417488005977 (37.7963788445653, -122.417488005977)
90605 104256 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Octavia St Frontage East 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
124060 104255 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Octavia St Frontage East 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
164473 136005 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1237x Robert C Levy Tunl 9 Median : Yard 3 Tree 1 DPW 2     3     6007661.46268 2118150.4985 37.7964699809712 -122.417519302367 (37.7964699809712, -122.417519302367)
54621 4034 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2150 Cesar Chavez St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/28/1995 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
140726 104254 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Octavia St Frontage East 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
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)
37982 237111 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2x Coso Ave 7 Median : Yard 3 Tree 1 DPW 2     2     6007125.29232 2099860.06971 37.7462186223039 -122.418077248072 (37.7462186223039, -122.418077248072)
116546 103081 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 445 Octavia St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005464.0 2110963.0 37.7766110057417 -122.42461146641399 (37.7766110057417, -122.424611466414)
139120 4124 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3435 Cesar Chavez St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 12 3X3   6006760.09222 2100373.98133 37.7476091457032 -122.419376518884 (37.7476091457032, -122.419376518884)
139217 103052 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 400X Octavia St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 3x3   6005072.0 2110257.0 37.774650355650394 -122.42591724231501 (37.7746503556504, -122.425917242315)
142091 22527 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6600 03rd St 7 Median : Cutout 11 Tree 1 DPW 2     3 3X3   6012847.5284056 2089784.7633558998 37.7188743244909 -122.39758380657601 (37.7188743244909, -122.397583806576)
143027 104253 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Octavia St Frontage East 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
53189 91930 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2014 12:00:00 AM 3 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
73837 103051 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 400X Octavia St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 3x3   6005072.0 2110257.0 37.774650355650394 -122.42591724231501 (37.7746503556504, -122.425917242315)
98877 4032 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2150 Cesar Chavez St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
107701 18240 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1790X Post St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2000 12:00:00 AM 3 4X4   6003623.876054401 2114224.0660337 37.785460985782706 -122.431209813682 (37.7854609857827, -122.431209813682)
108756 104252 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Octavia St Frontage East 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
112605 103080 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 445 Octavia St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005464.0 2110963.0 37.7766110057417 -122.42461146641399 (37.7766110057417, -122.424611466414)
119959 100985 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2190 Powell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
15791 27728 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015202.17288 2101166.08495 37.750255956855 -122.390239385253 (37.750255956855, -122.390239385253)
57041 98796 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950@Washington Clay St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   03/16/2012 12:00:00 AM 3 3x3 Permit Number 768771 6010177.18626 2117200.01626 37.7940014192822 -122.40874722700701 (37.7940014192822, -122.408747227007)
80642 26729 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 710 Lombard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6008944.94841 2120470.5671200003 37.8029124483908 -122.413242294464 (37.8029124483908, -122.413242294464)
92706 4122 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3435 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 6 3X3   6006760.09222 2100373.98133 37.7476091457032 -122.419376518884 (37.7476091457032, -122.419376518884)
101459 98790 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950x CLAY ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
112616 100037 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199@Washington Mason St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
120512 23489 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2500X Van Ness Ave 5 Median : Cutout 11 Tree 1 DPW 2   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
123262 104251 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8X Octavia St Frontage East 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
124487 100032 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Mason St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM   3x3 Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
129347 4146 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3615-3623X Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
141865 103079 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 445 Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005464.0 2110963.0 37.7766110057417 -122.42461146641399 (37.7766110057417, -122.424611466414)
142574 4031 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2150 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/06/2015 02:05:00 PM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
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)
17532 24463 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3550 Cesar Chavez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/30/1995 12:00:00 AM 3 3x3   6006349.89396 2100605.1669900003 37.7482208171583 -122.420811373242 (37.7482208171583, -122.420811373242)
22030 4104 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3330 Cesar Chavez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/17/1999 12:00:00 AM 3 3X3   6007482.20732 2100611.45835 37.7483018487579 -122.416896303343 (37.7483018487579, -122.416896303343)
66520 100031 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Mason St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009418.42249 2117262.251 37.7941297732341 -122.411377035334 (37.7941297732341, -122.411377035334)
73055 106983 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1737-1795 Post St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/01/2012 12:00:00 AM 4     6003734.5 2114103.2 37.785135386369795 -122.43081845921101 (37.7851353863698, -122.430818459211)
84875 4071 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3148 Cesar Chavez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4X4   6008736.4549488 2100618.4445096003 37.748391502035204 -122.41255962658701 (37.7483915020352, -122.412559626587)
85319 4145 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3615-3623X Cesar Chavez St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
87590 91928 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
97122 16435 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1299X Newcomb Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/27/2008 12:00:00 AM 3 3x3   6016431.7799349995 2094795.0104810002 37.7328304099415 -122.385543330143 (37.7328304099415, -122.385543330143)
97257 104250 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8x Octavia St Frontage East 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
103844 23488 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2500X Van Ness Ave 4 Median : Cutout 11 Tree 1 DPW 2   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
107730 89678 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990738.94558 2111956.39246 37.77849598088871 -122.475621745513 (37.7784959808887, -122.475621745513)
119256 103078 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 445 Octavia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005464.0 2110963.0 37.7766110057417 -122.42461146641399 (37.7766110057417, -122.424611466414)
124785 103049 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 400X Octavia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005072.0 2110257.0 37.774650355650394 -122.42591724231501 (37.7746503556504, -122.425917242315)
144094 100036 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199@Washington Mason St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
6617 103761 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 106X Austin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006685.575019999 2115508.13748 37.7891597571573 -122.42070841348101 (37.7891597571573, -122.420708413481)
11924 27095 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 711 Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6006067.91108 2093593.9714799998 37.7289537443201 -122.421288656069 (37.7289537443201, -122.421288656069)
13686 27731 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1100 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015524.1696 2101161.19501 37.7502603851148 -122.38912554882 (37.7502603851148, -122.38912554882)
21265 27509 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1335 Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/24/2000 12:00:00 AM 6 3X3   6005856.94451 2101204.3999 37.749838376446206 -122.42255855456001 (37.7498383764462, -122.42255855456)
38128 88409 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Mason St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009413.9789 2117291.03714 37.7942085637169 -122.41139444529 (37.7942085637169, -122.41139444529)
79188 103042 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450X Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6005621.8 2110912.7 37.7764818047314 -122.424062011758 (37.7764818047314, -122.424062011758)
80522 90634 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986072.775219999 2110484.3905599997 37.774182669931996 -122.49165518484101 (37.774182669932, -122.491655184841)
82021 104249 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 8 Octavia St Frontage East 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 4x4   6005716.34743 2109200.23605 37.771785130185 -122.423613163533 (37.771785130185, -122.423613163533)
95273 4120 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3435 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 6 3X3   6006760.09222 2100373.98133 37.7476091457032 -122.419376518884 (37.7476091457032, -122.419376518884)
95984 103790 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99X Fern St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6007061.73741 2115197.31568 37.788327510680205 -122.41938487643999 (37.7883275106802, -122.41938487644)
105409 103764 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 90X Frank Norris St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6007013.605 2115541.6847 37.789270352125605 -122.419575849271 (37.7892703521256, -122.419575849271)
106070 4144 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3615-3623X Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
107032 103833 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Myrtle St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6007204.7906599995 2114178.2136 37.7855373621017 -122.41881763042299 (37.7855373621017, -122.418817630423)
111068 91917 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5990949.753071 2106534.898314 37.763622247809295 -122.47449673434299 (37.7636222478093, -122.474496734343)
111854 89677 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990716.34706 2111955.94773 37.7784934496742 -122.47569988906 (37.7784934496742, -122.47569988906)
115072 91933 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992089.071506 2106573.92474 37.7637953493605 -122.470559068172 (37.7637953493605, -122.470559068172)
116126 100035 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199@Washington Mason St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
116762 4020 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1760 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 2X3   6013957.30178 2101067.5315943 37.7499162221241 -122.39453736171801 (37.7499162221241, -122.394537361718)
117047 90579 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2050X Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/15/2008 12:00:00 AM 3 3x3   5989191.56818 2110598.34198 37.774677325483 -122.480875193908 (37.774677325483, -122.480875193908)
119100 4093 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3265 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6007971.46841 2100526.65506 37.7480965064251 -122.415198444297 (37.7480965064251, -122.415198444297)
122784 26727 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 710 Lombard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6008944.94841 2120470.5671200003 37.8029124483908 -122.413242294464 (37.8029124483908, -122.413242294464)
124893 29668 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2500 Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2   12/09/2004 12:00:00 AM 6     6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
4125 135979 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99 Fern St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 4 Width 4ft   6006900.63841 2115164.21663 37.788227554109504 -122.419939904112 (37.7882275541095, -122.419939904112)
4328 28085 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2255 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6002770.4091 2114749.1272 37.786854268374796 -122.43420010239201 (37.7868542683748, -122.434200102392)
12903 28302 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3410 San Bruno Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 3X3   6012014.9954 2089805.7813099998 37.7188856424495 -122.40046303743799 (37.7188856424495, -122.400463037438)
16042 4051 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2550 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6011835.74556 2100958.0718 37.749497496525 -122.401866156092 (37.749497496525, -122.401866156092)
17463 4063 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3053 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/15/1995 12:00:00 AM 3 3X3   6009245.443659999 2100538.36575 37.7482001758998 -122.410793893342 (37.7482001758998, -122.410793893342)
17528 4246 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4038 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/1995 12:00:00 AM 3 3X3   6003621.03642 2100422.76167 37.747565786929 -122.43023466569599 (37.747565786929, -122.430234665696)
20721 10215 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1335 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/24/2000 12:00:00 AM 6 3X3   6005858.33864 2101181.45988 37.749775467064 -122.42255210370199 (37.749775467064, -122.422552103702)
71827 196444 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200x Kansas St 2 Median : Cutout 11 Tree 1 DPW 2     5 Width 5ft   6011674.76736 2102721.10758 37.7543294225845 -122.402546786399 (37.7543294225845, -122.402546786399)
77709 91916 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5990949.753071 2106534.898314 37.763622247809295 -122.47449673434299 (37.7636222478093, -122.474496734343)
79576 89676 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990695.40247 2111954.91498 37.778489399756204 -122.47577226813999 (37.7784893997562, -122.47577226814)
79774 84648 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301X 29th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/21/2006 12:00:00 AM 10 3x3   6004302.0 2098976.0 37.7436318598049 -122.427776865938 (37.7436318598049, -122.427776865938)
83473 14411 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2001X Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/13/2001 12:00:00 AM 6 3X3   6009024.63169 2120105.21371 37.801913752234704 -122.41294070113399 (37.8019137522347, -122.412940701134)
88119 86581 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2547 27th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/2007 12:00:00 AM 3 3x3   5987979.82634 2097967.749244 37.7399266315394 -122.48414034443701 (37.7399266315394, -122.484140344437)
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)
88615 100034 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199@Washington Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
90041 23487 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2500X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2   01/25/2008 12:00:00 AM 3 9   6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
94130 91875 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 700 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/10/2008 12:00:00 AM 3 3x3   5993617.143263 2106666.291015 37.764137203180205 -122.465280687147 (37.7641372031802, -122.465280687147)
98111 91929 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1201X IRVING ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2014 12:00:00 AM 2 3x3   5992070.0 2106573.0 37.7637917074669 -122.470624962715 (37.7637917074669, -122.470624962715)
99034 106992 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1701X Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2012 12:00:00 AM       6004025.8 2114231.4 37.785503891427005 -122.42981979958701 (37.785503891427, -122.429819799587)
100303 86387 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1515 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988049.8019900005 2104982.6702779997 37.7591918054497 -122.4844127767 (37.7591918054497, -122.4844127767)
100305 103832 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Myrtle St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6007204.7906599995 2114178.2136 37.7855373621017 -122.41881763042299 (37.7855373621017, -122.418817630423)
102400 6398 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4X Matthew Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/13/1998 12:00:00 AM 12 3X3   6018041.9202743 2094226.9871977002 37.7313596862419 -122.379937152762 (37.7313596862419, -122.379937152762)
104440 91993 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1385 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993318.248331 2106068.242865 37.7624778784584 -122.46627100381201 (37.7624778784584, -122.466271003812)
107318 91905 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5990960.285269001 2106575.2825419996 37.7637337423119 -122.47446325445 (37.7637337423119, -122.47446325445)
108374 103789 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99X Fern St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6007061.73741 2115197.31568 37.788327510680205 -122.41938487643999 (37.7883275106802, -122.41938487644)

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