Street_Tree_List

Data source: data.sfgov.org

347 rows where qCaretaker = 2 and qSpecies = 18 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize, PermitNotes

qCaretaker

  • DPW · 347
Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
187959 88452 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2   06/07/2008 12:00:00 AM 4 5x12   6005470.42698 2121378.16696 37.8052088057127 -122.425330567252 (37.8052088057127, -122.425330567252)
166035 214700 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 200x Vasquez Ave 2 Median : Cutout 11 Tree 1 DPW 2     8 Width 6ft   5994642.56982 2099211.09063 37.7437262061113 -122.461193618499 (37.7437262061113, -122.461193618499)
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)
158887 121620 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1300x Kansas St 1 Median : Cutout 11 Tree 1 DPW 2     1 3x3   6011700.392659999 2102280.30315 37.7531205008135 -122.402427173876 (37.7531205008135, -122.402427173876)
145745 86213 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2487 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2007 12:00:00 AM 3 3x3   5988895.867106 2098417.748537 37.74121550369679 -122.481006033613 (37.7412155036968, -122.481006033613)
145441 91972 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993348.371695 2106356.020653 37.7632697788308 -122.46618773317101 (37.7632697788308, -122.466187733171)
145234 14624 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 14 Matthew Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/1998 12:00:00 AM 6 3X4   6018000.3078284 2094247.4364445 37.7314135402286 -122.38008243669701 (37.7314135402286, -122.380082436697)
144839 91991 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1381 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993317.352604 2106094.2794669997 37.7625493164634 -122.466275994064 (37.7625493164634, -122.466275994064)
144626 91890 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1120 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992320.002593 2106621.8585900003 37.763940313594496 -122.469763845315 (37.7639403135945, -122.469763845315)
144272 86370 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1299X 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5987998.480578 2106474.452955 37.763284845117205 -122.484699699179 (37.7632848451172, -122.484699699179)
144161 91904 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 Irving St 1 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)
144160 86065 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1939 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987527.802452 2102087.3075490003 37.7512115136965 -122.486005547987 (37.7512115136965, -122.486005547987)
144158 91985 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1259 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993288.9465769995 2106919.972764 37.7648148143539 -122.466434253957 (37.7648148143539, -122.466434253957)
143790 91892 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1140 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992260.438373 2106619.818257 37.7639312683688 -122.46996970970899 (37.7639312683688, -122.469969709709)
143691 91888 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1104 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/18/2009 12:00:00 AM 3 3x3   5992367.653968 2106623.490856 37.763947549515 -122.469599153768 (37.763947549515, -122.469599153768)
143615 91965 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1380 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993357.328954 2106095.6547560003 37.7625553991217 -122.46613783148999 (37.7625553991217, -122.46613783149)
143250 86436 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2574 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/29/2006 12:00:00 AM 3 3x3   5988026.00444 2097787.2202669997 37.7394336348182 -122.48396744726001 (37.7394336348182, -122.48396744726)
143190 89681 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2501 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/08/2008 12:00:00 AM 3 3x3   5990870.1336900005 2111960.99815 37.7785162312166 -122.47516825710899 (37.7785162312166, -122.475168257109)
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)
142923 91979 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1262 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993329.831033 2106894.951731 37.76474847223739 -122.46629102779801 (37.7647484722374, -122.466291027798)
142920 91935 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1115 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992339.241228 2106582.494136 37.7638333412086 -122.46969443927 (37.7638333412086, -122.46969443927)
142905 91986 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1317X 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993303.02099 2106510.864902 37.763692323852204 -122.46635583933201 (37.7636923238522, -122.466355839332)
142679 91988 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1333 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993306.603893 2106406.718543 37.7634065720307 -122.466335877787 (37.7634065720307, -122.466335877787)
142580 90633 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986086.317840001 2110484.4196099997 37.7741835411504 -122.491608341302 (37.7741835411504, -122.491608341302)
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)
142451 28354 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3182 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2001 12:00:00 AM 3 3X3   6008528.194294999 2100617.5445899 37.7483773408239 -122.413279726103 (37.7483773408239, -122.413279726103)
142397 91949 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 821 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993250.564595 2106613.710756 37.763971684644204 -122.46654474398001 (37.7639716846442, -122.46654474398)
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)
141870 4028 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2150 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/2003 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
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)
141655 1576 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/16/1999 12:00:00 AM 6 3x3   5995596.544419999 2112077.2508400003 37.779108233448 -122.45882633362 (37.779108233448, -122.45882633362)
141412 86539 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1719 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987787.197497 2103588.458912 37.755348384307105 -122.485218677787 (37.7553483843071, -122.485218677787)
141034 4148 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3631 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/17/1999 12:00:00 AM 3 3X3 She would like to be kept in the loop on what happens with this. 6006082.4281665 2100506.5376626 37.7479349243864 -122.421729258843 (37.7479349243864, -122.421729258843)
141011 91897 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1410 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991402.471947 2106590.429322 37.7638009409158 -122.47293498664301 (37.7638009409158, -122.472934986643)
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)
140651 103762 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 90X Frank Norris St 1 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)
140305 86249 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2266 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988574.227066 2099899.242089 37.7452645932744 -122.482226651217 (37.7452645932744, -122.482226651217)
140218 28356 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3188 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2001 12:00:00 AM 3 3X3   6008491.5836326 2100617.3863908 37.7483748509345 -122.413406314174 (37.7483748509345, -122.413406314174)
139518 103788 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99X Fern St 1 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)
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)
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)
139089 91874 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 700 Irving St 1 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)
138906 86075 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2241 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/22/2007 12:00:00 AM 3 3x3   5987598.017854 2100035.189447 37.7455810378659 -122.48561215120199 (37.7455810378659, -122.485612151202)
138599 91924 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1419 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991378.8994970005 2106549.5983990002 37.7636874653776 -122.473013538025 (37.7636874653776, -122.473013538025)
138449 91950 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 801X Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993310.100207 2106615.750107 37.7639807195417 -122.466338977932 (37.7639807195417, -122.466338977932)
138413 86332 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2263 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988533.319976 2099923.8448349996 37.745329766428 -122.482369901671 (37.745329766428, -122.482369901671)
130339 92531 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298X Kansas St 1 Median : Cutout 11 Tree 1 DPW 2     4     6011695.143180001 2102366.06354 37.75335568701529 -122.40245135756201 (37.7533556870153, -122.402451357562)
129428 85380   Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3390 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6007302.06128 2100623.1120599997 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933)
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)
129219 91981 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1210 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993318.025647 2107238.1041650004 37.7656899972839 -122.46635680061001 (37.7656899972839, -122.46635680061)
129008 86060 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1869 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987511.195169 2102571.5912409998 37.7525402584661 -122.486098523179 (37.7525402584661, -122.486098523179)
128762 13087 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 710 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/19/2006 12:00:00 AM 3 3X3   6008944.94841 2120470.5671200003 37.8029124483908 -122.413242294464 (37.8029124483908, -122.413242294464)
128216 91932 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Irving St 2 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)
127380 89680 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2501 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990849.40142 2111961.25142 37.778515724988 -122.47523999566299 (37.778515724988, -122.475239995663)
127018 90632 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3040 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2008 12:00:00 AM 3 3x3   5986103.36345 2110484.3741200003 37.774184412397794 -122.491549374976 (37.7741844123978, -122.491549374976)
126683 10217 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1351 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2002 12:00:00 AM 6 3X3   6005868.4867153 2101104.801102 37.7495655521395 -122.422511564697 (37.7495655521395, -122.422511564697)
126105 86220 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2663 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5988937.695499 2097215.793619 37.7379176798007 -122.480773433176 (37.7379176798007, -122.480773433176)
125543 86250 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2242 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2006 12:00:00 AM 3 3x3   5988568.6306529995 2100055.451314 37.7456931770541 -122.48225744501998 (37.7456931770541, -122.48225744502)
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)
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)
124769 86219 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2643 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5988933.146151001 2097346.5203529997 37.7382763570454 -122.48079873027201 (37.7382763570454, -122.480798730272)
124677 91957 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993916.960821 2106636.537582 37.7640727935932 -122.464241552933 (37.7640727935932, -122.464241552933)
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)
123551 91915 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1555 Irving St 1 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)
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)
122988 91920 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1443 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991304.074022 2106547.035288 37.7636760954029 -122.473272146607 (37.7636760954029, -122.473272146607)
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)
122083 91956 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 617 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993881.230819999 2106635.313677 37.7640673735885 -122.46436504271401 (37.7640673735885, -122.464365042714)
121473 89675 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2543 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/07/2008 12:00:00 AM 3 3x3   5990673.7254 2111954.26646 37.7784863623151 -122.47584720917801 (37.7784863623151, -122.475847209178)
120983 86378 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1361 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988013.321416 2106043.0662599998 37.762101239533294 -122.484616725198 (37.7621012395333, -122.484616725198)
120658 12826 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2212 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2010 12:00:00 AM 3 3X3   5988595.84675 2114702.3275900004 37.785911071486396 -122.48323678034299 (37.7859110714864, -122.483236780343)
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)
120382 86542 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1731 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5987789.915173001 2103510.132538 37.755133479572294 -122.485203532524 (37.7551334795723, -122.485203532524)
120189 86101 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2600X 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2007 12:00:00 AM 3 3x3   5988963.56832 2097622.4377 37.7390357226089 -122.48071374038 (37.7390357226089, -122.48071374038)
120112 91989 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1369 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993314.665426999 2106172.3892240003 37.7627636303371 -122.466290964862 (37.7627636303371, -122.466290964862)
120005 12571 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 340 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/05/1993 12:00:00 AM 3 2X2   5994414.30523 2114928.2579900003 37.7868683042504 -122.46312306923099 (37.7868683042504, -122.463123069231)
119998 13086 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 710 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6008944.94841 2120470.5671200003 37.8029124483908 -122.413242294464 (37.8029124483908, -122.413242294464)
119872 86543 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1739 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2011 12:00:00 AM 3 3x3   5987791.726956 2103457.914967 37.7549902097756 -122.485193435735 (37.7549902097756, -122.485193435735)
119573 91877 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 744 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5993487.005858 2106661.8332909998 37.7641174577129 -122.465730467172 (37.7641174577129, -122.465730467172)
119467 91940 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 939 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992887.176206 2106601.263166 37.763916530494 -122.46780068014799 (37.763916530494, -122.467800680148)
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)
119192 91990 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1373 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2009 12:00:00 AM 3 3x3   5993315.561153 2106146.352622 37.7626921923354 -122.46628597458401 (37.7626921923354, -122.466285974584)
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)
118008 91898 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1428 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991346.352841 2106588.506989 37.763792413618106 -122.47312894339198 (37.7637924136181, -122.473128943392)
117924 91900 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1450X Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/20/2015 01:07:00 PM 3 3x3   5991277.7628190005 2106586.1574709998 37.763781990932 -122.47336600159201 (37.763781990932, -122.473366001592)
117846 90860 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2325 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2008 12:00:00 AM 3 3x3   5988359.69279 2110509.77218 37.7743857485973 -122.483746287708 (37.7743857485973, -122.483746287708)
117470 28355 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3188 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/02/2001 12:00:00 AM 3 4x4   6008491.5836326 2100617.3863908 37.7483748509345 -122.413406314174 (37.7483748509345, -122.413406314174)
117365 4143 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3615-3623X Cesar Chavez St 2 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)
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)
116951 85937 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600X 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988110.016747 2104395.766944 37.7575838341785 -122.484161486754 (37.7575838341785, -122.484161486754)
116783 14410 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2001X Mason St 1 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)
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)
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)
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)
114470 91973 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1336 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993347.47597 2106382.057231 37.7633412167636 -122.466192723388 (37.7633412167636, -122.466192723388)
114369 28253 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3432 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2002 12:00:00 AM 3 3X3   6012031.1541281 2089723.1062284 37.718659534499295 -122.40040137877199 (37.7186595344993, -122.400401378772)
114197 11071 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1769 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6007332.0 2118349.0 37.7969964730533 -122.418673401001 (37.7969964730533, -122.418673401001)
113728 85959 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298X 26TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/2006 12:00:00 AM 3 3x3   5988007.0 2106798.0 37.764173712799 -122.484693968894 (37.764173712799, -122.484693968894)
113587 103831 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Myrtle St 1 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)
113189 85956 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1334 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988047.4774629995 2106213.623528 37.762571532243705 -122.484511104656 (37.7625715322437, -122.484511104656)

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